I have a lab test panel (Complete urine culture panel) which includes multiple test items such as RBC, WBC etc. The data is shown below.
The LOINC code 58077-9 belongs to Measurement domain. But if I put this data into Measurement table, there is no column to put the test item description information, i.e., PH, RBC, WBC etc. After reading some of the forum post, it looks like I should put this information into fact_relationship table. But I am not sure how because fact_relationship table only takes concept_id. Does this mean I need to map all the individual test item into standard concept_id? Also how do I get fact_id?