Data Dictionary
The PanCAN Know Your Tumor Data Dictionary (the embedded excel file) is a guide to understanding the details of each csv file, the column (i.e field) names and the renaming of filterable vs downloaded field names.
Note:
Some fields that have PanCAN Field Nameās are marked as non-filterable ā in these cases you should ignore the PanCAN Field Name as it is only there for possible future enhancements to the set of filterable data.
It is divided by each csv file component (ex. adverse events, assessments, etc) and contains the following columns:
a. Table Name ā this is the name of the csv file which will contain the data for which you are downloading. Example, when downloading āadverse eventsā for a specific defined cohort the download file will be named āadverse_events.csvā
b. Column Name ā this is the column name/header for each column of the referenced csv file. Example, when downloading āadverse eventsā in the file named āadverse_events.csvā you will see columns named patient_id, care_plan_id, adverse_event_idā¦..
c. PanCAN Field Name ā This the name of the field which, if renamed, you will when filtering cohorts. If this field is blank it means that the āCSV Column Nameā will be shown when filtering. Example, when filtering on comorbidity information, you would see āComorbidity Nameā instead of ācomobidity_concept_canonical_nameā.
d. Filterable ā as previously note, for each of use and understanding not every field is available as a filter. This column indicates which are (denoted with a Y) which are not (denoted with a āNā or blank) available for a cohort filter. As an example, the āHistopathological Grade Descriptionā is available to filter however āobservationb_concept_systemā of the histopath file is not.
e. Data Type ā the general characteristic if the data type (ex. character, numeric).
f. Description ā a basic description of the data field as provided by Tempus.
Updated over 2 years ago