Dear colleagues,
we would like to request relationship_id we can use in order to link in fact_relationship table the following records from cdm event tables :
- condition_occurrence_id (records containing icd code in _source_value) with measurement_id:
- stage
- t (tumor)
- n (nodes)
- m (metastases)
- grade
- progression_ind (identifier if patient has progressed in treatment)
- condition_occurrence_id (records containing icd code in _source_value ) with observation_id:
- ajcc_stage_ind (identifier if stage was set using AJCC rules)
- histology
- condition_occurrence_id (record containing icd code in _source_value) with condition_occurrence_id:
- gleason_total
- lung_cancer_type
- metastatic_ind (identifier if the cancer has metastasized)
- histology
- condition_occurrence_id with drug_exposure_id
Thanks you in advance.
Irina