| Ontario Health - Cancer Care Ontario's Data Book - 2021-2022 |
|
Updated in February 2016
Data for the three Reference Entities should be selected and submitted using a transactional changes method. Records should be submitted if they meet one of the following criteria:
A new record is ADDED (registered) since the last submission.
An old record is UPDATED (including coding/staging of Diseases) since the last submission.
An old record is DELETED since the last submission (Patient & Disease only).
ADDS and UPDATES are sent in the .csv files and should include all data elements defined for the entity.
DELETES are sent in the optional .del files which are in CSV format, but which only contain the business identifiers for the entity (as noted on the previous page).
The following fields are used to establish the uniqueness of a record. Records that match on all of these fields are considered to represent the same Patient, Disease, or HCP. The latest record will overwrite all previous records. Records that differ on any or all of these fields are considered to be a new record, and will not overwrite a previously submitted record:
patient - patient_chart_number, submitting_hospital_number
disease - patient_chart_number, submitting_hospital_number, registration_date, disease_sequence_number
healthcare_professional – submitting_hospital_number, hcp_number
You can send more than one .csv or .del file for same Reference Entity during a submission period. For example, if you have Patient data being extracted from two different systems, you can send this data as two files.
However, if a Patient, Disease or HCP, as defined by the business keys above, appears in both files and there are differences between the records, one will overwrite the other. Similarly, if a record appears more than once in the same file and there are differences between them, the last record in the file will overwrite the previous one(s).