| Ontario Health - Cancer Care Ontario's Data Book - 2021-2022 |
|
Updated December 2020
All monthly data submissions from each hospital will be processed through the data quality assurance (QA) checks presented in this document. Both OPIS and non-OPIS data feeds use the same QA process and checks.
The QA checks are classified into two categories: Rejected Records and Non-Rejected Records.
Rejected records are not retained by OH-CCO. These records will cause problems in OH-CCO’s key databases and reports if loaded. (e.g. a missing patient chart number.)
Non-rejected content errors are accepted by OH- CCO because some or all of OH-CCO’s key databases can handle the errors without causing process problems. (e.g. a missing Body Region Code) However, the record needs to be corrected in order to be fully useable by OH-CCO.
There are four edit reports which are generated with each submission of ALR data. It is important that each report be reviewed after every submission to ensure data completeness and accuracy. These reports are:
Files Submitted report – which details the files submitted and the count of records in each file
Record Count report – which provides a summary of the record errors associated with the submission – including error number, and count of each error.
Record QA report – which details the individual, record level errors identified in the Record Count report
Duplicate Disease QA report - to supplement PHI details for error #502. The report identifies all of the disease records that have been flagged as potential duplicates by error #502.
The report contains the following content header:
"Duplicate Group","Patient Chart Number","Health Card Number","Disease Number","Registration Date","Diagnosis Code","Topography Code","Morphology Code", "Laterality", "Has Act","Has Smk"
where,
• duplicate group will be a number starting from 1 and will represent a set of duplicate records.
• “Has Act” column means there is/are activity record/s referencing this disease record if the value is ‘Y’ and none if ‘N’.
• “Has Smk” column means there is a smoking cessation record referencing this disease record if the value is ‘Y’ and none if ‘N’.
5. Duplicate Patient QA report - to supplement PHI details for error #501. The report identifies all of the patient records that have been flagged as potential duplicates by error #501.
The report will have the following content header:
"Duplicate Group","Health Card Number","Patient Chart Number","Has Act","Has Smk"
where duplicate group will be a number starting from 1 and will represent a set of duplicate records.
“Has Act” column means there is/are activity record/s referencing this patient record if the value is ‘Y’ and none if ‘N’.
“Has Smk” column means there is a smoking cessation record referencing this patient record if the value is ‘Y’ and none if ‘N’.