Cancer Care Ontario



Cancer Care OntarioSpecialized Services Oversight (SSO) ProgramKyphoplasty and Vertebroplasty Data Dictionary03-April-2018Contents TOC \o "1-3" \h \z \u Kyphoplasty and Vertebroplasty Procedures Data Elements PAGEREF _Toc506458983 \h 2Definitions for DARTs PAGEREF _Toc506458984 \h 11Quality Assurance Checks PAGEREF _Toc506458985 \h 12Validations: File Level Validations (Level 100) PAGEREF _Toc506458986 \h 12Validations: File Format Errors (Level 200) PAGEREF _Toc506458987 \h 13Validations: Content Errors, Record Rejected (Level 300) PAGEREF _Toc506458988 \h 13Validations: Content Errors, Record Not Rejected (Level 400) PAGEREF _Toc506458989 \h 16Validations: Duplicate or Apparent Duplicate Records (Level 500) PAGEREF _Toc506458990 \h 16Data Submission, Validation and Error Reporting Schedule PAGEREF _Toc506458991 \h 17Appendix PAGEREF _Toc506458992 \h 18Appendix-1: Facility Numbers PAGEREF _Toc506458993 \h 18Appendix-2: MOHLTC Master Numbering System PAGEREF _Toc506458994 \h 18Appendix-3: Valid 2-digit Postal Codes PAGEREF _Toc506458995 \h 19Kyphoplasty and Vertebroplasty Procedures Data Elements#EntityData ElementColumn_NameDefinition (Description)FormatValid values (Notes)Applies toPurpose and UseMandatoryBusiness key (Uniqueness)01KVHealth Card NumberHealth_Card_NumberPatient's Ontario Health Card Number.CHAR(10)Must be a valid ten-digit HCNAllTo link data with other CCO data holding areas.YesYes02KVPatient Chart NumberPatient_Chart_NumberFacility’s internal unique patient identifier.CHAR (12). Cell must be in ‘Text’ Category in Format Cells option in Excel. Must be alpha-numeric (i.e. no punctuation, must have numbers and characters).AllFor 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.Yes03KVDate of BirthDate_Of_BirthPatient birth dateCHAR (8) YYYYMMDDValid dateMust be later than01-01-1900AllTo link data with other CCO data holding areas.Yes04KVPostal CodePostal_CodePatient’s residential postal code available to the facility at the time of procedure.CHAR(10)1. Must match any of these format masks: ANANAN, NNNNN, NNNNN-NNNN, AA2. If matches mask ANANAN, cannot begin with D,F,I,O,Q,U, or W3. If matches mask AA, should match an entry in Appendix-3 (Province and State Codes).AllGeographical distribution reporting.Yes05KVFacility NumberFacility_NumberSubmitting facility numberCHAR(3)Valid facility number MOHLTC classification listed in Appendix-3AllFunding, planning and reportingYesYes06KVType of ProcedureType_of_ProcedureType of vertebral augmentation procedure used. This includes procedures that are performed in Interventional Radiology Suites by interventional radiologists or interventional neuroradiologists, and in the Operating Room by neurosurgeons or orthopaedic surgeons.CHAR(80)Select from drop down:VertebroplastyKyphoplastyFTA-assisted VertebroplastyFTA-assisted KyphoplastyAllFunding, planning and performance managementYesYes07KVEligibility for KyphoplastyEligibility_for_KyphoplastySelect the indication for why kyphoplasty was performed. ‘Fracture with gas filled cleft,’ is gas in the fractured vertebral body on MR or CT which is an indication of a non-healing fracture. It may have originated from the disc space but would not be in the bone unless there is a fracture.CHAR(80)If provided, must be one of the options in the drop down:Acute fracture treated within 6 weeksFracture with gas filled cleft (un-united fracture)Fracture with soft tissue tumour and absent cortexReason not indicated in recommendations reportProcedure Type = ‘Kyphoplasty’ and ‘FTA-assisted Kyphoplasty’ onlyQuality assurance and fundingYes if Procedure Type = ‘Kyphoplasty’ and ‘FTA-assisted Kyphoplasty’ only08KVConfirmed Cancer CaseConfirmed_Cancer_CaseWas this vertebral augmentation procedure performed on a patient diagnosed with malignant disease (not benign)?CHAR(3)If provided, must be one of the options in the drop down:YesNoAllQuality assurance and fundingYes09KVProcedure DateDate_of_ProcedureDate of procedureCHAR(8) YYYYMMDDValid DateMust be on or after date of consultation and must be in current reporting periodAllFundingYesYes10KVDate of Receipt of ReferralDate_of_Receipt_of_ReferralDate on which a request for consultation with a specialist is received in the specialist office for this service/procedure. If the specialist does not accept the referral at this time (e.g., referral form incomplete, workup not complete), this date does not change.CHAR(8) YYYYMMDDValid dateMust be later than01-01-1900 and on or before date of procedure.AllPerformance metrics - wait timesYes11KVConsultation DateDate_of_ConsultationFirst date on which a patient sees the specialist for consultation regarding this specific service/procedureCHAR(8) YYYYMMDDValid dateMust be on or after date of receipt of referral.AllPerformance metrics - wait timesYes12KVMultidisciplinary ConsultationMultidisciplinary_ConsultationDid this case have a documented multidisciplinary consultation or was discussed or reported back to a multidisciplinary cancer conference (MCC)?CHAR(3)If provided, must be one of the options in the drop down:YesNoAllFunding and quality assuranceYes13KVNumber of vertebra levels treated in procedureVertebra_levels_treatedSelect the number of vertebra levels that are treated in procedureCHAR(50)If provided, must be one of the options in the drop down:1234 5678 or moreAllPlanning, potentially for funding by levels rather than by procedureYes14KVDates Affecting Readiness to Treat From Date – 1st instanceDART_From_Date_1The beginning date (YYYYMMDD) of the first period of time when the patient is unavailable for the procedure due to patient-related reasons.CHAR(8) YYYYMMDDValid dateMust be on or after date of date of consultation and before date of procedureOnly procedures where there were DARTs. Up to 3 DARTs are allowed per procedure.Performance metrics - wait timesNo15KVDates Affecting Readiness to Treat To Date – 1st instanceDART_To_Date_1The end date (YYYYMMDD) of the first period of time when the patient is unavailable for the procedure due to patient-related reasons.CHAR(8) YYYYMMDDValid dateMust be on or after date of date of consultation and before date of procedure, and after DART From DateOnly procedures where there were DARTs. Up to 3 DARTs are allowed per procedure.Performance metrics - wait timesYes if DART_From_Date_1 is not null16KVDates Affecting Readiness to Treat Reason for 1st instanceDART_Reason_1The reason the patient is unavailable for the procedure for the first DART.CHAR(80)If provided, must be one of the options in the drop down:Inability to Contact the Patient Change in Medical Status Missed Procedure/No Show Pre-Procedure Instructions Not Followed Patient treatment related timed event, please specifyPatient Chooses to DeferRows where DART_From_Date_1 and DART_To_Date_1 are enteredPerformance metrics - wait timesYes if DART_From_Date_1 and DART_To_Date_1 are entered17KVDART Timed Event Reason for 1st instanceDART_Timed_Event_1If ‘Patient treatment related timed event, please specify’ is selected for DART_Reason_1, the reason for the timed event should be indicated.CHAR(80)If provided, must be one of the options in drop down menu:Neo-adjuvant chemotherapyNeo-adjuvant radiation therapyTumour AblationOther, please specifyRows where DART_Reason_1 = ‘Patient treatment related timed event’Performance metrics - wait timesYes, if DART_Reason_1 = ‘Patient treatment related timed event’18KVDART Timed Event Other Reason for 1st instanceDART_Timed_Event_Other_1If ‘Other, please specify’ is selected for DART_Timed_Event_1, the details for the other reason should be provided.CHAR(80)Free textRows where DART_Timed_Event_1 = ‘Other, please specify’Performance metrics - wait timesYes, if DART_Timed_Event_1 = ‘Other, please specify’19KVDates Affecting Readiness to Treat From Date – 2nd instanceDART_From_Date_2The beginning date (YYYYMMDD) of the second period of time when the patient is unavailable for the procedure due to patient-related reasons.CHAR(8) YYYYMMDDValid dateMust be on or after date of date of consultation and before date of procedureOnly procedures where there were DARTs. Up to 3 DARTs are allowed per procedure.Performance metrics - wait timesNo20KVDates Affecting Readiness to Treat To Date – 2nd instanceDART_To_Date_2The end date (YYYYMMDD) of the second period of time when the patient is unavailable for the procedure due to patient-related reasons.CHAR(8) YYYYMMDDValid dateMust be on or after date of date of consultation and before date of procedure, and after DART From DateOnly procedures where there were DARTs. Up to 3 DARTs are allowed per procedure.Performance metrics - wait timesYes if DART_From_Date_2 is not null21KVDates Affecting Readiness to Treat Reason for 2nd instanceDART_Reason_2The reason the patient is unavailable for the procedure for the second DART.CHAR(80)If provided, must be one of the options in the drop down:Inability to Contact the Patient Change in Medical Status Missed Procedure/No Show Pre-Procedure Instructions Not Followed Patient treatment related timed event, please specifyPatient Chooses to DeferRows where DART_From_Date_2 and DART_To_Date_2 are enteredPerformance metrics - wait timesYes if DART_From_Date_2 and DART_To_Date_2 are entered22KVDART Timed Event Reason for 2nd instanceDART_Timed_Event_2If ‘Patient treatment related timed event, please specify’ is selected for DART_Reason_2, the reason for the timed event should be indicated.CHAR(80)If provided, must be one of the options in drop down menu:Neo-adjuvant chemotherapyNeo-adjuvant radiation therapyTumour AblationOther, please specifyRows where DART_Reason_2 = ‘Patient treatment related timed event’Performance metrics - wait timesYes, if DART_Reason_2 = ‘Patient treatment related timed event’23KVDART Timed Event Other Reason for 2nd instanceDART_Timed_Event_Other_2If ‘Other, please specify’ is selected for DART_Timed_Event_2, the details for the other reason should be provided.CHAR(80)Free textRows where DART_Timed_Event_2 = ‘Other, please specify’Performance metrics - wait timesYes, if DART_Timed_Event_2 = ‘Other, please specify’24KVDates Affecting Readiness to Treat From Date – 3rd instanceDART_From_Date_3The beginning date (YYYYMMDD) of the third period of time when the patient is unavailable for the procedure due to patient-related reasons.CHAR(8) YYYYMMDDValid dateMust be on or after date of date of consultation and before date of procedureOnly procedures where there were DARTs. Up to 3 DARTs are allowed per procedure.Performance metrics - wait timesNo25KVDates Affecting Readiness to Treat To Date – 3rd instanceDART_To_Date_3The end date (YYYYMMDD) of the third period of time when the patient is unavailable for the procedure due to patient-related reasons.CHAR(8) YYYYMMDDValid dateMust be on or after date of date of consultation and before date of procedure, and after DART From DateOnly procedures where there were DARTs. Up to 3 DARTs are allowed per procedure.Performance metrics - wait timesYes if DART_From_Date_3 is not null26KVDates Affecting Readiness to Treat Reason for 3rd instanceDART_Reason_3The reason the patient is unavailable for the procedure for the third DART.CHAR(80)If provided, must be one of the options in the drop down:Inability to Contact the Patient Change in Medical Status Missed Procedure/No Show Pre-Procedure Instructions Not Followed Patient treatment related timed event, please specifyPatient Chooses to DeferRows where DART_From_Date_3 and DART_To_Date_3 are enteredPerformance metrics - wait timesYes if DART_From_Date_3 and DART_To_Date_3 are entered27KVDART Timed Event Reason for 3rd instanceDART_Timed_Event_3If ‘Patient treatment related timed event, please specify’ is selected for DART_Reason_3, the reason for the timed event should be indicated.CHAR(80)If provided, must be one of the options in drop down menu:Neo-adjuvant chemotherapyNeo-adjuvant radiation therapyTumour AblationOther, please specifyRows where DART_Reason_3 = ‘Patient treatment related timed event’Performance metrics - wait timesYes, if DART_Reason_3 = ‘Patient treatment related timed event’28KVDART Timed Event Other Reason for 3rd instanceDART_Timed_Event_Other_3If ‘Other, please specify’ is selected for DART_Timed_Event_3, the details for the other reason should be provided.CHAR(80)Free textRows where DART_Timed_Event_3 = ‘Other, please specify’Performance metrics - wait timesYes, if DART_Timed_Event_3 = ‘Other, please specify’Definitions for DARTsDates Affecting Readiness to Treat ReasonDefinitionInability to Contact the Patient The scheduler has made a reasonable effort (determined by facility guidelines) to contact the patient in order to schedule or confirm the date and time for the procedure, but has not been able to do so. Change in Medical Status The patient's medical status has changed such that the procedure cannot be performed at this time. Missed Procedure/No Show The patient is a no show for their procedure at the scheduled date and time, or cancels on the scheduled procedure date, and as a result the procedure must be rescheduled. For this DART reason, one day will be subtracted from the overall consult to procedure wait time. Pre-Procedure Instructions Not Followed The patient has not completed the necessary prerequisites for the procedure as advised at the time of appointment notification. Patient treatment related timed event, please specifyAlso known as a specified date procedure or timed procedure, a timed event is used to indicate a procedure that should be completed once a predefined time period has elapsed that is linked to patient’s treatment pathway and other medical interventions linked to a patient’s disease. This reason should not be used to capture system related issues.Patient Chooses to Defer The patient is unavailable for the procedure due to personal reasons (such as vacation or death in the family), personal preferences for the date and time of the procedure, or weather reasons (such as road and airport closures). Quality Assurance ChecksThe QA checks are grouped by number as follows:100’s - File level checks200’s - File format errors: Entire record is rejected.300’s - Rejected content errors: Entire record is rejected.400’s - Non-rejected content errors: Entire record is retained, including erroneous field.500’s - Apparent duplicate record warnings: These are not necessarily errors, but could be.Built-in Data Assurance Checks within the Manual Submission TemplateCells in the submission template being used for 2017/18 will light up red for data elements that are mandatory based on the treatment data being submitted on each row of the template. Cells in the submission template will light up yellow when the format of the data elements which are dates are incorrect. For all other data elements, an error message will appear if the format is incorrect.Validations: File Level Validations (Level 100)The following rules will be applied and checked against every file submitted for SSO program.#TypeConditionError MessageReject101Invalid HeaderHeader list in Excel file is incorrectFile Error- Header list is incorrect.Yes102Incorrect number of ColumnsRecord in file has incorrect number of data elementsFile Error- Record has incorrect number of data elements.Yes103File name maskFile name does not follow the convention for file name mask: KV_nnn_ffff_ffffQx.xlsWhere:KV: a fixed string indicating the program name (Kyphoplasty and vertebroplasty)nnn: the three-digit code of the submitting site (e.g. 567)ffff _ffff: the two calendar years that make up the fiscal year separated by an underscore character (e.g. 2015_2016)Q: a fixed character for Quarterx: the quarter within the fiscal, which is always an integer number between 1 and 4 (e.g. 3).xls: a fixed string indicating that the file is in Excel format. This can also be .xlsx.Example: KV_567_2015_2016Q3.xlsNote: This validation should be non-case-sensitive so that, for example, the string "KV" can also be sent as "kv".File Error - File is incorrectly named.Yes104EmptyFile is empty Note: files with only one row (i.e. the header row is present and not patient level data) are considered valid. This error applies only when there is no such header.File Error - invalid number of data columns in “&file_name” file.Yes105No DataFile includes only one line, and that line is a valid header line.Note: This is a valid submission if there were no procedures in the reported quarter, so we issue a warning just to make sure.Warning - No data submitted. If there are data records, please resubmit.NoValidations: File Format Errors (Level 200)NumberEntityData ElementConditionError MessageReject201AllAll FieldsData field is too longInvalid field lengthYes202AllAll Date FieldsDate is not in YYYYMMDD formatInvalid - Must be in YYYYMMDD format(For optional date fields, ignore if null)YesValidations: Content Errors, Record Rejected (Level 300)NumberElement #Data ElementColumn_NameConditionError MessageReject300KV 01Patient Health Card NumberHealth_Card_NumberIs NullInvalid - Null ValueYes303KV 01Patient Health Card NumberHealth_Card_NumberIs not a valid ten-digit HCNIgnore if NullInvalid Ontario Health Card NumberYes300KV 02Patient Chart NumberPatient_Chart_NumberIs NullInvalid - Null ValueYes302KV 02Patient Chart NumberPatient_Chart_NumberContains special characters e.g. *,/,{Ignore if NullInvalid Patient Chart Number - Contains non alpha numeric charactersYes307KV 02Patient Chart NumberPatient_Chart_NumberContains a cell format that is not the ‘Text’ Category in Excel. Text format cells are treated as text even when a number is in the cell. The cell is displayed exactly as entered.Invalid cell formatYes300KV 03Date of BirthDate_Of_BirthIs NullInvalid - Null ValueYes601KV 03Date of BirthDate_Of_BirthIs before 1900-01-01Date is before 1900-01-01Yes300KV 04Postal CodePostal_CodeIs NullInvalid - Null ValueYes304KV 04Postal CodePostal_CodeMatches mask ANANAN but begins with D, F, I, O, Q, U, or W.Invalid Postal Code- Invalid Initial LetterYes305KV 04Postal CodePostal_CodeMatches mask of AA but does not match any entry in Appendix 3 (Prov/State Codes)Invalid Postal Code (Prov/State) - consult lookup table in template.Yes306KV 04Postal CodePostal_CodeDoes not match mask: ANANAN, NNNNN, NNNNN-NNNN, AAIgnore if NullInvalid Postal Code- Invalid maskYes300KV 05Facility NumberFacility_NumberIs NullInvalid - Null ValueYes301KV 05Facility NumberFacility_NumberDoes not match any legal entry in Appendix-3Ignore if NullInvalid Hospital Number - consult lookup table in template.Yes300KV 06Type of ProcedureType_of_ProcedureIs NullInvalid - Null ValueYes399KV 06Type of ProcedureType_of_ProcedureIs not a value in predefined listIgnore if NullInvalid answerYes399KV 07Eligibility for KyphoplastyEligibility_for_KyphoplastyIs not a value in predefined listIgnore if NullInvalid answerYes300KV 07Eligibility for KyphoplastyEligibility_for_KyphoplastyIs Null and Type_of_ Procedure = ‘Kyphoplasty’ or ‘FTA-assisted Kyphoplasty’Invalid - Null ValueYes399KV 08Confirmed Cancer CaseConfirmed_Cancer_CaseIs not a value in predefined listIgnore if NullInvalid answerYes300KV 08Confirmed Cancer CaseConfirmed_Cancer_CaseIs NullInvalid - Null ValueYes300KV 09Procedure DateDate_of_ProcedureIs NullInvalid - Null ValueYes606KV 09Procedure DateDate_of_ProcedureIs before Date of ConsultationIgnore if NullDate of procedure cannot be before date of consultationYes623KV 09Procedure DateDate_of_ProcedureIs not in current reporting quarterIgnore if NullDate of procedure is not in the quarter being submittedYes300KV 10Date of Receipt of ReferralDate_of_Receipt_of_ReferralIs NullInvalid - Null ValueYes602KV 10Date of Receipt of ReferralDate_of_Receipt_of_ReferralIs before 1900-01-01Date is before 1900-01-01Yes610KV 10Date of Receipt of ReferralDate_of_Receipt_of_ReferralIs after date of procedureDate of receipt of referral cannot be after date of procedureYes300KV 11Consultation DateDate_of_ConsultationIs NullInvalid - Null ValueYes603KV 11Consultation DateDate_of_ConsultationIs before date of referralDate of consultation cannot be before date of referralYes399KV 12Multidisciplinary ConsultationMultidisciplinary_ConsultationIs not a value in predefined list (Yes or No)Ignore if NullInvalid answerYes300KV 12Multidisciplinary ConsultationMultidisciplinary_ConsultationIs NullInvalid - Null ValueYes399KV 13Number of vertebra levels treated in procedureVertebra_levels_treatedIs not a value in predefined list.Ignore if NullInvalid answerYes300KV 13Number of vertebra levels treated in procedureVertebra_levels_treatedIs NullInvalid - Null ValueYes608KV 14Dates Affecting Readiness to Treat From Date – 1st instanceDART_From_Date_1Is before Date of ConsultationIgnore if NullDART From Date cannot be before date of consultationYes609KV 15Dates Affecting Readiness to Treat To Date – 1st instanceDART_To_Date_1Is before Date of ConsultationIgnore if NullDART To Date cannot be before date of consultationYes300KV 15Dates Affecting Readiness to Treat To Date – 1st instanceDART_To_Date_1Is Null and DART_From_Date_1 is enteredInvalid - Null ValueYes300KV 16Dates Affecting Readiness to Treat Reason for 1st instanceDART_Reason_1Is Null and DART_From_Date_1 and DART_To_Date_1 are enteredInvalid - Null ValueYes399KV 16Dates Affecting Readiness to Treat Reason for 1st instanceDART_Reason_1Is not a value in predefined listIgnore if NullInvalid answerYes300KV 17DART Timed Event Reason for 1st instanceDART_Timed_Event_1Is Null and DART_Reason_1 = ‘Patient treatment related timed event, please specify’Invalid - Null ValueYes399KV 17DART Timed Event Reason for 1st instanceDART_Timed_Event_1Is not a value in predefined listIgnore if NullInvalid answerYes607KV 18DART Timed Event Other Reason for 1st instanceDART_Timed_Event_Other_1Is Null and DART_Timed_Event_1 = ‘Other, please specify’Since Timed Event Reason is Other, a description of the reason is expectedYes608KV 19Dates Affecting Readiness to Treat From Date – 2nd instanceDART_From_Date_2Is before Date of ConsultationIgnore if NullDART From Date cannot be before date of consultationYes609KV 20Dates Affecting Readiness to Treat To Date – 2nd instanceDART_To_Date_2Is before Date of ConsultationIgnore if NullDART To Date cannot be before date of consultationYes300KV 20Dates Affecting Readiness to Treat To Date – 2nd instanceDART_To_Date_2Is Null and DART_From_Date_2 is enteredInvalid - Null ValueYes300KV 21Dates Affecting Readiness to Treat Reason for 2nd instanceDART_Reason_2Is Null and DART_From_Date_2 and DART_To_Date_2 are enteredInvalid - Null ValueYes399KV 21Dates Affecting Readiness to Treat Reason for 2nd instanceDART_Reason_2Is not a value in predefined listIgnore if NullInvalid answerYes300KV 22DART Timed Event Reason for 2nd instanceDART_Timed_Event_2Is Null and DART_Reason_2 = ‘Patient treatment related timed event, please specify’Invalid - Null ValueYes399KV 22DART Timed Event Reason for 2nd instanceDART_Timed_Event_2Is not a value in predefined listIgnore if NullInvalid answerYes607KV 23DART Timed Event Other Reason for 2nd instanceDART_Timed_Event_Other_2Is Null and DART_Timed_Event_2 = ‘Other, please specify’Since Timed Event Reason is Other, a description of the reason is expectedYes608KV 24Dates Affecting Readiness to Treat From Date – 3rd instanceDART_From_Date_3Is before Date of ConsultationIgnore if NullDART From Date cannot be before date of consultationYes609KV 25Dates Affecting Readiness to Treat To Date – 3rd instanceDART_To_Date_3Is before Date of ConsultationIgnore if NullDART To Date cannot be before date of consultationYes300KV 25Dates Affecting Readiness to Treat To Date – 3rd instanceDART_To_Date_3Is Null and DART_From_Date_3 is enteredInvalid - Null ValueYes300KV 26Dates Affecting Readiness to Treat Reason for 3rd instanceDART_Reason_3Is Null and DART_From_Date_3 and DART_To_Date_3 are enteredInvalid - Null ValueYes399KV 26Dates Affecting Readiness to Treat Reason for 3rd instanceDART_Reason_3Is not a value in predefined listIgnore if NullInvalid answerYes300KV 27DART Timed Event Reason for 3rd instanceDART_Timed_Event_3Is Null and DART_Reason_3 = ‘Patient treatment related timed event, please specify’Invalid - Null ValueYes399KV 27DART Timed Event Reason for 3rd instanceDART_Timed_Event_3Is not a value in predefined listIgnore if NullInvalid answerYes607KV 28DART Timed Event Other Reason for 3rd instanceDART_Timed_Event_Other_3Is Null and DART_Timed_Event_3 = ‘Other, please specify’Since Timed Event Reason is Other, a description of the reason is expectedYesValidations: Content Errors, Record Not Rejected (Level 400)NumberEntityData ElementConditionError MessageReject401Eligibility for KyphoplastyEligibility_for_KyphoplastyType of Procedure <> ‘Kyphoplasty' or ‘FTA-assisted Kyphoplasty’It is not expected that the ‘Eligibility for Kyphoplasty’ is completed for a procedure type other than ‘Kyphoplasty' or ‘FTA-assisted Kyphoplasty’.No402DART Timed Event Other Reason for 1st instanceDART_Timed_Event_Other_1Is not null when DART_Timed_Event_1 <> Other, please specifySince Timed Event Reason is not Other, a description of the reason is not expectedNo402DART Timed Event Other Reason for 2nd instanceDART_Timed_Event_Other_2Is not null when DART_Timed_Event_2 <> Other, please specifySince Timed Event Reason is not Other, a description of the reason is not expectedNo402DART Timed Event Other Reason for 3rd instanceDART_Timed_Event_Other_3Is not null when DART_Timed_Event_3 <> Other, please specifySince Timed Event Reason is not Other, a description of the reason is not expectedNo403Date of BirthDate_Of_BirthPatient age is less than 18 years of age.Warning: This record is for a person less than 18 years of age. Please note CCO does not provide funding for cases where the patient is less than 18 years of age.NoValidations: Duplicate or Apparent Duplicate Records (Level 500)No.EntityData ElementConditionError MessageReject501Uniqueness of procedureHealth Card NumberFacility NumberType of ProcedureProcedure DateThe four data elements (Health Card Number, Facility Number, Type of Procedure and Procedure Date) are the same for two records in the same file.Error: Apparent duplicate recordsYes502Facility numberFacility NumberFacility number in the data does not match with the facility number associated with MFT Tumbleweed folder permissions.Facility number mismatch YesData Submission, Validation and Error Reporting ScheduleFor FY 2018/19 data and moving forward, data submission windows will be as follows:Kyphoplasty and Vertebroplasty Procedures Manual Data Collection Submission Timelines for FY 2018/19 data and beyondQuarterCorresponding Time FrameSubmission WindowInitial Data Validation and Error Report Send Back for all submissions receivedSecond Data Validation and Error Report Send BackData Resubmission Window Open (Optional) with data validation for all submissions receivedQ1April 1 - June 30July 15 - August 30Every Friday from July 15 - August 30September 1 - 21 September 22-28Q2July 1 - September 30October 15 - November 30Every Friday from October 15 - November 30December 1 -21December 22- January 12Q3October 1 - December 31January 15 - February 28Every Friday from January 15 - February 28March 1 – 21March 22 -28Q4January 1 - March 31April 15 - May 30Every Friday from April 15 - May 30June 1 – 21June 22 - 28AppendixAppendix-1: Facility NumbersFacility #Legal Name930Grand River Hospital950Halton Healthcare Services Corporation942Hamilton Health Sciences Corporation959Health Sciences North / Horizon Santé Nord941Humber River Hospital978Kingston Health Sciences Centre952Lakeridge Health 936London Health Sciences Centre962Niagara Health System606Royal Victoria Regional Health Centre979Scarborough and Rouge Hospital852St. Michael's Hospital953Sunnybrook Health Sciences Centre958The Ottawa Hospital935Thunder Bay Regional Health Sciences Centre975Trillium Health Partners947University Health Network933Windsor Regional HospitalAppendix-2: MOHLTC Master Numbering SystemThe Master Numbering System has been developed for the purpose of bringing together all Health Facilities and Programs under one system of identification. The list is a composite of health and health related units, facilities, clinics, programs and services. Each such organization has been assigned a unique four digit identifying code.(For details, please refer Cancer Care Ontario's Data Book - 2012-2013, Appendix A: MOHLTC Master Numbering System, at link ).Appendix-3: Valid 2-digit Postal Codes(Source: Cancer Care Ontario's Data Book - 2012-2013, Appendix B - Province and State codes, at link ).The table below provides list of valid 2 digit postal codes for province and State codes.lefttop00 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download