Interventional Radiology: Data Elements # Entity Data Element Column_Name Definition Format Valid values (Notes) Applies to Purpose and Use Mandatory Business key (Description) (Uniqueness) 01 IR Health Card Patient's CHAR(10) Must be a valid ten-digit All To link data with other CCO data holding Yes (Yes) Number Ontario Health HCN areas. Card Number. 02 IR Patient Chart Facility’s CHAR (12) Must be alpha-numeric (i.e. All For reimbursement: to uniquely identify Yes Number internal unique no punctuation, must have procedure for a patient; patient numbers and characters). For investigations: chart number will be identifier. provided in log file for the records with errors. This will allow facilities to link data in log file with their data sets. 03 IR Date of Birth Date_Of_Birth Patient birth CHAR (8) YYYYMMDD Valid date All To link data with other CCO data holding Yes date areas. Must be later than 01-01-1900 1. Must match any of these 04 IR Postal Code Postal_Code Patient’s CHAR(10) All Geographical distribution reporting. Yes format masks: ANANAN, residential NNNNN, NNNNN-NNNN, AA postal code. 2. If matches mask ANANAN, cannot begin with D,F,I,O,Q,U, or W 3. If matches mask AA, should an entry in Appendix-3 (Province and State Codes). 05 IR Facility Number Submitting CHAR(3) Valid facility number All Funding and planning Yes (Yes) Facility_Number facility number MOHLTC classification listed in Appendix-3
Interventional Radiology: Data Elements # Entity Data Element Column_Name Definition (Description) Format Valid values (Notes) Applies to Purpose and Use Mandatory Business key (Uniqueness) 01 IR Health Card Number Patient's Ontario Health Card Number. CHAR(10) Must be a valid ten-digit HCN All To link data with other CCO data holding areas. Yes (Yes) 02 IR Patient Chart Number Facility’s internal unique patient identifier. CHAR (12) Must be alpha-numeric (i.e. no punctuation, must have numbers and characters). All For reimbursement: to uniquely identify procedure for a patient; For investigations: chart number will be provided in log file for the records with errors. This will allow facilities to link data in log file with their data sets. Yes 03 IR Date of Birth Date_Of_Birth Patient birth date CHAR (8) YYYYMMDD Valid date Must be later than 01-01-1900 All To link data with other CCO data holding areas. Yes 04 IR Postal Code Postal_Code Patient’s residential postal code. CHAR(10) 1. Must match any of these format masks: ANANAN, NNNNN, NNNNN-NNNN, AA 2. If matches mask ANANAN, cannot begin with D,F,I,O,Q,U, or W 3. If matches mask AA, should an entry in Appendix-3 (Province and State Codes). All Geographical distribution reporting. Yes 05 IR Facility Number Facility_Number Submitting facility number CHAR(3) Valid facility number MOHLTC classification listed in Appendix-3 All Funding and planning Yes (Yes)
SSO_Interventional_Radiology_Data_Dictionary_20170601.docx