TABLE A1.
Cancer Registry Data Elements
| Object | Source Table | Data Mart Column | Source Column | Comments |
|---|---|---|---|---|
| Clinical findings CLINICAL_FINDINGS_IE_VW, CLINICAL_FINDINGS_IE_CNTRL_VW |
IMG_Clinical_Finding_IE | PATIENT_STUDY_ID | PERSON_ID | Research identifier of patient |
| Accession_Number | ACCESSION_NUMBER | |||
| Internat_Exam_ID | INTERNAL_EXAM_ID | |||
| Patient_ID | Patient_ID | |||
| Idxrad_Exam_ID | IDXRAD_EXAM_ID | |||
| Clinical_Finding_DE | CLINICAL_FINDING_DE | |||
| Clinical_Finding_CD | CLINICAL_FINDING_CD | |||
| Clinical_Finding_Name | CLINICAL_FINDING_NAME | |||
| Exam_Completed_Date | COMPLETED_DATE | ‘MM/DD/YYYY’ | ||
| Diagnosis DIAGNOSIS_VW, DIAGNOSIS_CNTRL_VW |
Diagnosis | PATIENT_STUDY_ID | PERSON_ID | Research identifier of patient |
| Diagnosis_Code | DX_CODE | |||
| Diagnosis_Type | DX_CODE_REF.CODE_TYPE | Reference lookup for dx code type | ||
| Diagnosis_Name | DX_CODE_REF.CODE_DESCRIPTION | Reference lookup for dx code name | ||
| Diagnosis_From_Date | DX_FROM_DATE | Begin encounter level assignment of DX | ||
| ‘MM/DD/YYYY’ | ||||
| Diagnosis_To_Date | DX_TO_DATE | End encounter level assignment of DX | ||
| ‘MM/DD/YYYY’ | ||||
| Primary_Diagnosis_YN | PRIMARY_DX_IND | ‘Y’ or ‘N’ | ||
| Discharge summary DISCHARGE_SUMMARY_VW, DISCHARGE_SUMMARY_CNTRL_VW |
Enc_Notes, Enc_Notes_Text | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| VISIT.HOSP_ADM_DATE | ||||
| Admission_Date | ‘MM/DD/YYYY HH24:MI:SS’ | |||
| VISIT.START_DATE | ||||
| Discharge_Date | VISIT.HOSP_DISCHG_DATE | ‘MM/DD/YYYY HH24:MI:SS’ | ||
| VISIT.END_DATE | ||||
| Note_Contact_Date | CONTACT_DATE | ‘MM/DD/YYYY’ | ||
| Note_CSN_ID | NOTE_CSN_ID | Unique note identifier | ||
| Line_Num | LINE_NUM | |||
| Note_Text | NOTE_TEXT | |||
| Encounter ENCOUNTER_VW, ENCOUNTER_CNTRL_VW |
Visit | Patient_Study_ID | PERONS_ID | Research identifier of patient |
| Visit_Start_Date | START_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Vist_End_Date | END_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Encounter_Type | CODE_REF.CODE_TITLE | Reference lookup for ‘ENC_TYPE’ | ||
| Facility | CODE_REF.CODE_TITLE | Reference lookup for ‘LOCATION’ | ||
| Appointment_Status | CODE_REF.CODE_TITLE | Reference lookup for ‘APPT_STATUS’ | ||
| Admit_Source | CODE_REF.CODE_TITLE | Reference lookup for ‘ADMIT_TYPE’ | ||
| Hospital_Service | CODE_REF.CODE_TITLE | Reference lookup for ‘HOSPITAL_SERVICE’ | ||
| Patient_Type | CODE_REF.CODE_TITLE | Reference lookup for ‘PATIENT_TYPE’ | ||
| Patient_Class | CODE_REF.CODE_TITLE | Reference lookup for ‘PATIENT_CLASS’ | ||
| Chief_Complaint | CHIEF_COMPLAINT | Free text data capture | ||
| Chief_Complaint_Onset_Date | CHIEF_COMPLAINT_ONSET_DATE | ‘MM/DD/YYYY’ | ||
| Discharge_Disposition | CODE_REF.CODE_TITLE | Reference lookup for ‘DISCHARGE_DISP’ | ||
| Financial_Class | CODE_REF.CODE_TITLE | Reference lookup for ‘FIN_CLASS’ | ||
| Enter edit findings ENTEREDIT_FINDINGS_VW, ENTEREDIT_FINDINGS_CNTRL_VW |
IMG_EnterEdit_Findings | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Accession_Number | ACCESSION_NUMBER | |||
| Org_Code | ORG_CODE | |||
| Internal_Exam_ID | INTERNAL_EXAM_ID | |||
| Patient_ID | PATIENT_ID | Imagecast Patient Identifier | ||
| Composition_Name | COMPOSITION_NAME | |||
| Finding_Location | FINDING_LOCATION | |||
| Finding_Category | FINDING_CATEGORY | |||
| Finding_Rec | FINDING_REC | |||
| Exam_Complete_Date | COMPLETED_DATE | MM/DD/YYYY | ||
| Family history AMILY_HX_VW, FAMILY_HX_CNTRL_VW |
Family_HX | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Line_Num | LINE_NUM | Identify each line in history | ||
| Contact_Date | CONTACT_DATE | ‘MM/DD/YYYY’ | ||
| Medical_HX_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘MEDICAL_HX’ | ||
| Relation_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘RELATION’ | ||
| Hormonal mens HORMONAL_MENS_VW, HORMONAL_MENS_CNTRL_VW |
IMG_Hormonal_Mens | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Accession_Number | ACCESSION_NUMBER | |||
| Internal_Exam_ID | INTERNAL_EXAM_ID | |||
| Patient_ID | PATIENT_ID | |||
| Entry_Name | ENTRY_NAME | |||
| Age_First_Use | AGE_FIRST_USE | |||
| Age_Last_Use | AGE_LAST_USE | |||
| Duration | DURATION | |||
| Current_Use_IND | CURRENT_USE_IND | |||
| Never_Use_IND | NEVER_USE_IND | |||
| Age_Menarche | AGE_MENARCHE | |||
| Age_First_Live_Birth | AGE_FIRST_LIVE_BIRTH | |||
| Age_Menopause | AGE_MENOPAUSE | |||
| Age_Hysterectomy | AGE_HYSTERECTOMY | |||
| Age_Right_Ovary_Removal | AGE_RIGHT_OVARY_REMOVAL | |||
| Age_Left_Ovary_Removal | AGE_LEFT_OVARY_REMOVAL | |||
| Parity_Count | PARITY_COUNT | |||
| Pregnancy_Count | PREGNANCY_COUNT | |||
| Last_Menstrual_Date | LAST_MENSTRUAL_DATE | ‘MM/DD/YYYY’ | ||
| Cycle_Phase | CYCLE_PHASE | |||
| Pregnant_IND | PREGNANT_IND | |||
| Menstrual_Status_CD | MENSTRUAL_STATUS_CD | |||
| Exam_Completed_Date | COMPLETED_DATE | ‘MM/DD/YYYY’ | ||
| IMG procedures IMG_PROCEDURES_VW, IMG_PROCEDURES_CNTRL_VW |
IMG_Procedures | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Accession_Number | ACCESSION_NUMBER | |||
| Internal_Exam_ID | INTERNAL_EXAM_ID | |||
| Patient_ID | PATIENT_ID | |||
| Procedure_Side | PROCEDURE_SIDE | |||
| Procedure_Date | PROCEDURE_DATE | ‘MM/DD/YYYY’ | ||
| Procedure_Outcome | PROCEDURE_OUTCOME | |||
| Implant_Side | IMPLANT_SIDE | |||
| Implant_Type | IMPLANT_TYPE | |||
| Exam_Completed_Date | COMPLETED_DATE | ‘MM/DD/YYYY’ | ||
| Laboratory results LAB_RESULT_VW, LAB_RESULT_CNTRL_VW |
Lab_Result | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Result_Date | RESULT_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Component_Name | COMPONENT_NAME | |||
| Result_Value | ORD_VALUE | |||
| Result_Unit | REFERENCE_UNIT | |||
| Reference_Low | REFERENCE_LOW | |||
| Reference_High | REFERENCE_HIGH | |||
| Lab_Result_Status | CODE_REF.CODE_TITLE | Reference lookup for ‘RESULT_STATUS’ | ||
| Specimen_Collected_Date | SPECIMEN_COLLECTED_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Specimen_Received_Date | SPECIMEN_RECEIVED_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Specimen_Type | CODE_REF.CODE_TITLE | Reference lookup for ‘SPECIMEN_TYPE’ | ||
| Specimen_Source | CODE_REF.CODE_TITLE | Reference lookup for ‘SPECIMEN_SOURCE’ | ||
| Laboratory sensitivity LAB_SENSITIVITY_VW |
Lab_Sensitivity | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Contact_Date | CONTACT_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Result_Date | RESULT_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Organism | ORANISM_NAME | |||
| Antibiotic | CODE_REF.CODE_TITLE | Reference lookup for ‘ANTIBIOTIC’ | ||
| Suscept | CODE_REF.CODE_TITLE | Reference lookup for ‘SUSCEPT’ | ||
| Sensitivity_Value | SENSITIVITY_VALUE | |||
| Sensitivity_Units | SENSITIVITY_UNITS | |||
| Sensitivity_Status | CODE_REF.CODE_TITLE | Reference lookup for ‘RESULT_STATUS’ | ||
| Medication fill MED_FILL_VW, MED_FILL_CNTRL_VW |
Med_Fill | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Filled_Date | FILLED_DATE | ‘MM/DD/YYYY’ | ||
| Drug_Name | DRUG_NAME | |||
| Simple_Generic_Name | SIMPLE_GENERIC_NAME | |||
| Drug_Code_Sys | DRUG_CODE_SYS | |||
| NDC | NDC | |||
| Amount | AMOUNT | |||
| Med_Units | MED_UNIT_TXT | |||
| Med_Unit_Strength | MED_UNIT_STRENGTH | |||
| Quantity | QUANTITY | |||
| Days_Supply | DAYS_SUPPLY | |||
| Medication order MED_ORDER_VW, MED_ORDER_CNTRL_VW |
Med_Order | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Order_Date | ORDER_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Medication_ID | MEDICATION_ID | |||
| Medication | MEDICATION_NAME | |||
| Simple_Generic_Name | CODE_REF.CODE_TITLE | Reference lookup for ‘SIMPLE_GENERIC’ | ||
| Pharm_Class | CODE_REF.CODE_TITLE | Reference lookup for ‘PHARM_CLASS’ | ||
| Dose | DOSE | |||
| Med_Units | MED_UNIT_TITLE | |||
| Quantity | QUANTITY | |||
| Refills | REFILLS | |||
| Start_Date | START_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| End_Date | END_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Admin_Route_Title | ADMIN_ROUTE_TITLE | |||
| Frequency | FREQUENCY | |||
| Instructions | INSTRUCTIONS | |||
| Order result ORDER_RESULT_VW, ORDER_RESULT_CNTRL_VW |
Order_Result | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Order_Procedure_ID | ORDER_PROC_ID | |||
| Result_Date | RESULT_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Component_Name | COMPONENT_NAME | COMPONENT_REF | ||
| Result_Value | ORD_VALUE | |||
| Result_Unit | REFERENCE_UNIT | |||
| Reference_Low | REFERENCE_LOW | |||
| Reference_High | REFERENCE_HIGH | |||
| Result_Flag_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘RESULT_FLAG’ | ||
| Result_Status | CODE_REF.CODE_TITLE | Reference lookup for ‘RESULT_STATUS’ | ||
| Specimen_Collected_Date | SPECIMEN_COLLECTED_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Specimen_Received_Date | SPECIMEN_RECEIVED_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Patient data IE PATIENT_DATA_IE_VW, PATIENT_DATA_IE_CNTRL_VW |
IMG_Patient_Data_IE | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Order_Procedure_ID | ACCESSION_NUMBER | |||
| Result_Date | ORG_CODE | |||
| Component_Name | ORG_NAME | |||
| Result_Value | EXAM_CODE | |||
| Result_Unit | EXAM_NAME | |||
| Reference_Low | EXAM_MODIFIER | |||
| Reference_High | EXAM_STATUS | |||
| Result_Flag_Title | SCHEDULED_DATE | ‘MM/DD/YYYY’ | ||
| Result_Status | COMPLETED_DATE | ‘MM/DD/YYYY’ | ||
| Specimen_Collected_Date | FINALIZED_DATE | ‘MM/DD/YYYY’ | ||
| Specimen_Received_Date | BEGIN_DATE | ‘MM/DD/YYYY’ | ||
| Order_Date | ORDER_DATE | ‘MM/DD/YYYY’ | ||
| Exam_Type_ID | EXAM_TYPE_ID | |||
| Exam_Side | EXAM_SIDE | |||
| Exam_Requestor | EXAM_REQUESTOR | |||
| Exam_Type | EXAM_TYPE | |||
| Self_Request_Ind | SELF_REQUEST_IND | |||
| Equipment_Clean_Ind | EQUIPMENT_CLEAN_IND | |||
| First_Mammo_Ind | FIRST_MAMMO_IND | |||
| Last_Screen_Month_CD | LAST_SCREEN_MONTH_CD | |||
| Last_CBE_CD | LAST_CBE_CD | |||
| Last_CBE_Date | LAST_CBE_DATE | ‘MM/DD/YYYY’ | ||
| Last_Activity_Date | LAST_ACTIVITY_DATE | ‘MM/DD/YYYY’ | ||
| Internal_Exam_ID | INTERNAL_EXAM_ID | |||
| Patient_ID | PATIENT_ID | |||
| Patient demographics PATIENT_DEMO_VW, PATIENT_DEMO_CNTRL_VW |
Patient_Demographic | Person_ID | PATIENT_STUDY_ID | Research identifier of patient ‘MM/DD/YYYY’ default to July 1st of birth year |
| Birth_Date | BIRTH_DATE | ‘MM/DD/YYYY’ | ||
| Death_Date | DEATH_DATE | Reference lookup for ‘GENDER’ | ||
| Gender_Title Race_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘RACE’ | ||
| Ethnic_Title | CODE_REF.CODE_TITLE CODE_REF.CODE_TITLE | Reference lookup for ‘ETHNIC_GROUP' | ||
| Pathology PATHOLOGY_VW, PATHOLOGY_CNTRL_VW |
IMG_Pathology | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Bx_ID | BX_ID | |||
| Pathology_Date | PATHOLOGY_DATE | MM/DD/YYYY | ||
| Patient_ID | PATIENT_ID | |||
| Site_Number | SITE_NUMBER | |||
| Side | SIDE | |||
| Lesion_Class | LESION_CLASS | |||
| Lesion_Location | LESION_LOCATION | |||
| Technique | TECHNIQUE | |||
| Comments | COMMENTS | |||
| Pathology findings PATHOLOGY_FINDINGS_VW, PATHOLOGY_FINDINGS_CNTRL_VW |
IMG_Pathology_Findings | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Bx_ID | BX_ID | |||
| Pathology_Date | PATHOLOGY_DATE | MM/DD/YYYY | ||
| Patient_ID | PATIENT_ID | |||
| Finding_ID | FINDING_ID | |||
| Pathology_CD | PATHOLOGY_CD | |||
| Lesion_Class | LESION_CLASS | |||
| Finding_Size_1 | FINDING_SIZE_1 | |||
| Finding_Size_2 | FINDING_SIZE_2 | |||
| Measurement_Type | MEASUREMENT_TYPE | |||
| Histrology_Grade | HISTROLOGY_GRADE | |||
| Nodes_Removed | NODES_REMOVED | |||
| Nodes_Positive | NODES_POSITIVE | |||
| Margin_Status | MARGIN_STATUS | |||
| Estrogen_Receptor | ESTROGEN_RECEPTOR | |||
| Progesterone_Receptor | PROGESTERONE_RECEPTOR | |||
| HER2NEU | HER2NEU | |||
| Stage_T | STAGE_T | |||
| Stage_N | STAGE_N | |||
| Stage_M | STAGE_M | |||
| Stage_Num | STAGE_NUM | |||
| Nipples_Involved | NIPPLES_INVOLVED | |||
| Problem list PROBLEM_LIST_VW, PROBLEM_LIST_CNTRL_VW |
Problem_List | Patient_Study_ID | PERSON_ID | Research Identifier of Patient |
| Diagnosis_Code | DX_CODE | |||
| Diagnosis_Type | DX_CODE_TYPE | |||
| Diagnosis_Name | DX_NAME | |||
| Reported_Date | REPORTED_DATE | ‘MM/DD/YYYY’ | ||
| Onset_Date | ONSET_DATE | ‘MM/DD/YYYY’ | ||
| Resolved_Date | RESOLVED_DATE | ‘MM/DD/YYYY’ | ||
| Resovled_Reason | RESOLVED_REASON | |||
| Status_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘PROBLEM_STATUS’ | ||
| Procedures PROCEDURES_VW, PROCEDURES_CNTRL_VW |
Procedures | PATIENT_STUDY_ID | PERSON_ID | Research identifier of patient Order listed sequence finding first not null value: |
| Procedure_Date | RESULT_DATE, PROC_DATE, ORDER_DATE | ‘MM/DD/YYYY’ | ||
| Procedure_Code | PROC_CODE | |||
| Procedure_Type | PROC_CODE_REF.CODE_TYPE | |||
| Procedure_Name | PROC_CODE_REF.CODE_DESCRIPTION | |||
| Procedure_Location | PROCEDURE_LOCATION | |||
| Order_Date | ORDER_DATE | ‘MM/DD/YYYY’ | ||
| Procedure notes PROCEDURES_NOTES_VW, PROCEDURES_NOTES_CNTRL_VW |
Proc_Notes, Proc_Notes_Text | PATIENT_STUDY_ID | PERSON_ID | Research identifier of patient |
| Order_Date | ORDER_DATE | ‘MM/DD/YYYY’ | ||
| Result_Time | RESULT_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Procedure_Code | PROC_CODE | |||
| Procedure_Name | CODE_DESCRIPTION | PROC_CODE_REF | ||
| Note_CSN_ID | NOTE_CSN_ID | |||
| Line_Num | LINE_NUM | |||
| Note_Text | NOTE_TEXT | |||
| Recommendations RECOMMENDATIONS_VW, RECOMMENDATIONS_CNTRL_VW |
IMG_Recommendation_IE | PATIENT_STUDY_ID | PERSON_ID | Research identifier of patient |
| Accession_Number | ACCESSION_NUMBER | |||
| Internal_Exam_id | INTERNAL_EXAM_ID | |||
| Patient_ID | PATIENT_ID | |||
| Recommend_ID | RECOMMEND_ID | |||
| Recommend_CD | RECOMMEND_CD | |||
| Recommend_Status | RECOMMEND_STATUS | |||
| Recommend_Side | RECOMMEND_SIDE | |||
| Due_Date | DUE_DATE | ‘MM/DD/YYYY’ | ||
| Exam_Completed_Date | COMPLETED_DATE | ‘MM/DD/YYYY’ | ||
| Risk factors RISK_FACTORS_VW, RISK_FACTORS_CNTRL_VW |
IMG_Risk_Factors | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Accession_Number | ACCESSION_NUMBER | |||
| Internal_Exam_id | INTERNAL_EXAM_ID | |||
| Patient_ID | PATIENT_ID | |||
| Risk_Factor_CD | RISK_FACTOR_CD | |||
| Risk_Factor_Name | RISK_FACTOR_NAME | |||
| Risk_Sequence | RISK_SEQUENCE | |||
| Relationship_CD | RELATIONSHIP_CD | |||
| Problem_CD | PROBLEM_CD | |||
| Person_Age | PERSON_AGE | |||
| Comments | COMMENTS | |||
| Exam_Completed_Date | COMPLETED_DATE | ‘MM/DD/YYYY’ | ||
| Social history alcohol SOCIAL_HX_ALC_VW, SOCIAL_HX_ALC_CNTRL_VW |
Social_HX_Alc | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Contact_Date | CONTACT_DATE | ‘MM/DD/YYYY’ | ||
| Drinks_Per_Week | DRINKS_PER_WEEK | |||
| Drink_Type_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘DRINK_TYPE’ | ||
| Social history tobacco SOCIAL_HX_TOB_VW, SOCIAL_HX_TOB_CNTRL_VW |
Social_HX_Tob | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Contact_Date | CONTACT_DATE | ‘MM/DD/YYYY’ | ||
| Smoking_Use_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘SMOKE_TOB_USE’ | ||
| Tobacco_Use_Per_Day | TOBACCO_PAK_PER_DAY | |||
| Tobacco_Use_Years | TOBACCO_USED_YEARS | |||
| Translate ‘Y’ to ‘Yes’ | ||||
| Cigarettes_Indicator | CIGARETTES_IND | Translate ‘N’ to ‘No’ | ||
| Otherwise NULL | ||||
| Translate ‘Y’ to ‘Yes’ | ||||
| Pipes_Indicator | PIPES_IND | Translate ‘N’ to ‘No’ | ||
| Otherwise NULL | ||||
| Translate ‘Y’ to ‘Yes’ | ||||
| Cigars_Indicator | CIGARS_IND | Translate ‘N’ to ‘No’ | ||
| Otherwise NULL | ||||
| Translate ‘Y’ to ‘Yes’ | ||||
| Snuff_Indicator | SNUFF_IND | Translate ‘N’ to ‘No’ | ||
| Otherwise NULL | ||||
| Translate ‘Y’ to ‘Yes’ | ||||
| Chew_Indicator | CHEW_IND | Translate ‘N’ to ‘No’ | ||
| Otherwise NULL | ||||
| Smokeless_Tob_Use_Title | CODE_REF.CODE_TITLE | Reference lookup for ‘SMOKELESS_TOB_USE’ | ||
| Surgical pathology SURGICAL_PATH_NOTES_VW, Notes SURGICAL_PATH_NOTES_CNTRL_VW |
Proc_Notes, Proc_Notes_Text | PATIENT_STUDY_ID | PERSON_ID | Research identifier of patient |
| Order_Date | ORDER_DATE | ‘MM/DD/YYYY’ | ||
| Result_Time | RESULT_DATE | ‘MM/DD/YYYY HH:MI:SS’ | ||
| Procedure_Code | PROC_CODE | |||
| Procedure_Name | CODE_DESCRIPTION | PROC_CODE_REF | ||
| Note_CSN_ID | NOTE_CSN_ID | |||
| Line_Num | LINE_NUM | |||
| Note_Text | NOTE_TEXT | |||
| Vitals VITALS_VW, VITALS_CNTRL_VW |
Vitals | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| Visit_ID | VISIT_ID | |||
| Weight | WEIGHT | |||
| Weight_Unit | WEIGHT_UNIT | |||
| Height | HEIGHT | |||
| Height_In | HEIGHT_IN | |||
| Height_Unit | HEIGHT_UNIT | |||
| Date_Taken | CONTACT_DATE | |||
| BMI | BMI | |||
| Patient cancer registry PATIENT_CANCER_REGISTRY_VW |
BCC_Cancer_Registry | Patient_Study_ID | PERSON_ID | Research identifier of patient |
| HOSPITAL_ID | HOSPITAL_ID | |||
| SEQUENCE_NUMBER | SEQUENCE_NUMBER | |||
| CLASS_OF_CASE | CLASS_OF_CASE | |||
| CASE_STATUS | CASE_STATUS | |||
| DATE_OF_BIRTH | DATE_OF_BIRTH | Default to July 1st of birth year | ||
| SEX | SEX | |||
| SEX_DESC | SEX_DESC | |||
| RACE_1 | RACE_1 | |||
| RACE_1_DESC | RACE_1_DESC | |||
| SPANISH_HISPANIC_ORIGIN | SPANISH_HISPANIC_ORIGIN | |||
| SPANISH_HISP_ORIG_DESC | SPANISH_HISP_ORIG_DESC | |||
| PRIMARY_PAYOR_DX_DESC | PRIMARY_PAYOR_DX_DESC | |||
| POSTAL_CODE_AT_DX | POSTAL_CODE_AT_DX | |||
| COUNTY_AT_DX | COUNTY_AT_DX | |||
| PRIMARY_SITE | PRIMARY_SITE | |||
| PRIMARY_SITE_DESC | PRIMARY_SITE_DESC | |||
| LATERALITY_DESC | LATERALITY_DESC | |||
| HISTO_BEHAVE_ICDO3 | HISTO_BEHAVE_ICDO3 | |||
| HISTO_BEHAVE_ICDO3_DESC | HISTO_BEHAVE_ICDO3_DESC | |||
| HISTO_BEHAVE_ICDO3_DESC | HISTO_BEHAVE_ICDO3_DESC | |||
| CORRECTED_BEST_STAGE | CORRECTED_BEST_STAGE | |||
| DATE_1ST_CONTACT | DATE_1ST_CONTACT | |||
| COURSE_DATE_1ST_DX | COURSE_DATE_1ST_DX | |||
| COURSE_1ST_DXSTG_PROCFAC_DESC | COURSE_1ST_DXSTG_PROCFAC_DESC | |||
| COURSE_1ST_DXSTG_PROCSUM_DESC | COURSE_1ST_DXSTG_PROCSUM_DESC | |||
| CS_SITE_SPEC_FACTOR_1 | CS_SITE_SPEC_FACTOR_1 | |||
| CS_SITE_SPEC_FACTOR_2 | CS_SITE_SPEC_FACTOR_2 | |||
| CS_SITE_SPEC_FACTOR_15 | CS_SITE_SPEC_FACTOR_15 | |||
| AJCC_CLINICAL_T_DESC | AJCC_CLINICAL_T_DESC | |||
| AJCC_CLINICAL_N_DESC | AJCC_CLINICAL_N_DESC | |||
| AJCC_CLINICAL_M_DESC | AJCC_CLINICAL_M_DESC | |||
| REASON_NO_SURGERY_DESC | REASON_NO_SURGERY_DESC | |||
| MOST_DEFINITIVE_SURG_DATE | MOST_DEFINITIVE_SURG_DATE | |||
| COURSE_1ST_SURG_PRIMSITE_DESC | COURSE_1ST_SURG_PRIMSITE_DESC | |||
| COURSE_1ST_SURG_PRIMSUMM_DESC | COURSE_1ST_SURG_PRIMSUMM_DESC | |||
| COURSE_1ST_SCOPE_LN_SURG_DESC | COURSE_1ST_SCOPE_LN_SURG_DESC | |||
| REGIONAL_NODES_EXAM | REGIONAL_NODES_EXAM | |||
| REGIONAL_NODES_POSITIVE | REGIONAL_NODES_POSITIVE | |||
| COURSE_1ST_SURG_MARG_DESC | COURSE_1ST_SURG_MARG_DESC | |||
| REASON_NO_CHEMO_DESC | REASON_NO_CHEMO_DESC | |||
| COURSE_1ST_CHEMO_DATE | COURSE_1ST_CHEMO_DATE | |||
| COURSE_1ST_CHEMO_FAC_DESC | COURSE_1ST_CHEMO_FAC_DESC | |||
| COURSE_1ST_CHEMO_SUMM_DESC | COURSE_1ST_CHEMO_SUMM_DESC | |||
| REASON_NO_HORMONE_THERAPY | REASON_NO_HORMONE_THERAPY | |||
| COURSE_1ST_HORMONE_RX_DATE | COURSE_1ST_HORMONE_RX_DATE | |||
| COURSE_1ST_HORMONE_FAC_DESC | COURSE_1ST_HORMONE_FAC_DESC | |||
| COURSE_1ST_HORMONE_RX_SUMM | COURSE_1ST_HORMONE_RX_SUMM | |||
| MEDICAL_ONCOLOGY_PHYS_NPI | MEDICAL_ONCOLOGY_PHYS_NPI | |||
| MEDICAL_ONC_PHYS_LASTNAME | MEDICAL_ONC_PHYS_LASTNAME | |||
| MEDICAL_ONC_PHYS_FIRSTNAME | MEDICAL_ONC_PHYS_FIRSTNAME | |||
| REASON_NO_RADIATION_DESC | REASON_NO_RADIATION_DESC | |||
| DATE_RT_STARTED | DATE_RT_STARTED | |||
| DATE_RT_ENDED | DATE_RT_ENDED | |||
| COURSE_1ST_RADIATION_FAC | COURSE_1ST_RADIATION_FAC | |||
| COURSE_1ST_RT_MODALITY_SUMM | COURSE_1ST_RT_MODALITY_SUMM | |||
| COURSE_1ST_RT_VOLUME_SUMM | COURSE_1ST_RT_VOLUME_SUMM | |||
| COURSE_1ST_RT_REG_DOSE_SUMM | COURSE_1ST_RT_REG_DOSE_SUMM | |||
| COURSE_1ST_RX_SUMMARY | COURSE_1ST_RX_SUMMARY | |||
| RADIATION_ONC_PHYS_NPI | RADIATION_ONC_PHYS_NPI | |||
| RADIATION_ONC_PHYS_LASTNAME | RADIATION_ONC_PHYS_LASTNAME | |||
| RADIATION_ONC_PHYS_FIRSTNAME | RADIATION_ONC_PHYS_FIRSTNAME | |||
| CHEMOTHERAPY_TEXT | CHEMOTHERAPY_TEXT | |||
| DATE_LAST_CONTACT | DATE_LAST_CONTACT | |||
| VITAL_STATUS | VITAL_STATUS | |||
| CANCER_STATUS_DESC | CANCER_STATUS_DESC | |||
| DATE_1ST_RECURRENCE | DATE_1ST_RECURRENCE | |||
| TYPE_1ST_RECURRENCE_DESC | TYPE_1ST_RECURRENCE_DESC |