Ontario Health - Cancer Care Ontario's Data Book - 2023-2024

 

 

 

Updated June 2023

Frequently Asked Questions (FAQ) about Data Book

1. What is a baseline file, and when does it need to be submitted? 1. What is a baseline file, and when does it need to be submitted?

A baseline file is used to identify all existing patient cases prior to the hospital’s start of data submission (for Clinic Visits). Once the visit activity submission commences, each visit is cross referenced back to the baseline file to determine if the patient is a new case (as of the visit date). If the patient does not match a record on the baseline file, it is counted as a new case visit and subsequently added onto the file to identify further follow up visits. A record match will count as a follow up visit. New case and follow up visits are grouped by the Visit Program Code.

2. For Clinical Practice Groups (and Sub Groups) what are the criteria for grouping the disease diagnosis codes?. For Clinical Practice Groups (and Sub Groups) what are the criteria for grouping the disease diagnosis codes?

See Appendix 1.39 for Clinical Practice Group and Subgroup mapping tables for ICD10CA and ICDO3.

• CPG assignment is based on ICDO3 Topography and Morphology code combinations.

• For ALR cases where the Disease records are submitted with only an ICD10CA “Diagnosis Code” within the neoplasm code range C000 – D489, a conversion ‘up’ to ICDO3 Topography and Morphology is done.

• The “ICD10CA CPG” tab contains the mapping from ICD10CA “Diagnosis Code” (ICD10CA_CD) to ICDO3 Topography (ICDO3_TOPOG_CD) and Morphology (ICDO3_MORPH_CD) codes, and the CPG and subgroup assignment.

• The “ICDO3 CPG” tab contains the mapping from ICDO3 Topography and Morphology codes to the CPG and subgroup assignment using the following steps:

1. Exact match between Topography code (ICDO3_TOPOG_CD) and full Morphology code (ICDO3_MORPH_CD), assign to CPG and subgroup.

2. If no exact match between Topography (ICDO3_TOPOG_CD) and full Morphology code (ICDO3_MORPH_CD),  then match between Topography (ICDO3_TOPOG_CD) and the full Morphology code

that ends with Behaviour (BEHAVIOUR_CD) = 0, 1, 2, 3, 6, 9, assign to CPG and subgroup.

3. For Visit Types, what is considered to be “Face-to-Face” and “Telephone” visits?. For Visit Types, what is considered to be “Face-to-Face” and “Telephone” visits?

Face to face includes visits that allow both parties to see each other (ie. includes video conferencing). Telephone visits include modes such as teleconference and email.

 

4. How do we capture non-physician providers for the HCP entity (for programs like Psychosocial Oncology  (PSO))?. How do we capture non-physician providers for the HCP entity (for programs like Psychosocial Oncology  (PSO))?

For Psychosocial Oncology (PSO) clinic visits it is necessary to capture the HCP Number for various HCP Specialties. The HCP file must be updated for non-physician HCP numbers and their corresponding HCP Specialty. A generic HCP Number could be used to correspond to the specialties required for the programs, if unique HCP Numbers are not being used for non-physicians. The key HCP Specialties used by the PSO program are:

• 12000 Social Worker

• 06000 Nutritional Therapy (ie. dietitian)

• 03002 Physiotherapy

• 00064 Psychiatry

• 15000 Psychology

• 03003 Occupational Therapy

• 03009 Speech Language Pathology ·          · If unique HCP Numbers are not used for these specialties, the option to use the HCP Specialty Code as the generic HCP number is advised.    For example, for ALL Social Workers, use one HCP record with HCP Number = 12000, HCP Specialty Code = 12000, CCO Program Code = PSO.

5. How do I access the OH-CCO upload application to do a data submission? What are the steps?. How do I access the OH-CCO upload application to do a data submission? What are the steps?

See the Submission Specifications Process topic.

6. How do I correct and resubmit records identified by the QA reports?. How do I correct and resubmit records identified by the QA reports?

After reviewing the ALR QA reports generated after a package is submitted, the patient level details for the records that have been flagged with errors can be found on the “QA Full Report” for the corresponding Load ID of the package submitted.  Once the errors have been addressed on the hospital information system (HIS), the applicable ALR (csv) files can be re-extracted and resubmitted to the Data Submission Portal (DSP).  Please follow the steps for submission, as outlined in FAQ #5 (for more details).

Note:  resubmission of data months outside of the “optional (quarterly) resubmissions” schedule require an ALR Special Resubmission Request Form to be submitted for approval.  See the ALR – Submission Schedule for the form link.

7. What are some of the current changes in Data Book this year?. What are some of the current changes in Data Book this year?

See the Summary of Changes topic.

8. What are the file specifications for submitting to Data Book (ALR)?. What are the file specifications for submitting to Data Book (ALR)?

Submission specifications for the data elements required for ALR are listed in the Specifications topic.

9. Is there a list of chemotherapy drugs (other than Intravenous anti-neoplastic ) that should be captured?. Is there a list of chemotherapy drugs (other than Intravenous anti-neoplastic ) that should be captured?

See Appendix 1.38 for a list of oral and other agents used in chemotherapy which should be reports.

10. How do we capture a physician treating patients for Systemic treatment versus Palliative Care consultations?10. How do we capture a physician treating patients for Systemic treatment versus Palliative Care consultations?

CIHI has provided a Palliative Medicine code which was included in the Data Book 2012/13. Palliative Medicine specialty code 00121 should be used with CCO Program Code “PA” for Palliative Program in the HCP file. If a patient does not receive any chemotherapy and opts for Palliative care without treatment, the Clinic Visit should be captured with: •HCP Number associated with the Palliative Medicine (00121) HCP Specialty Code. •Palliative Care (PA) as the Visit Program Code.

If the patient undergoes systemic treatment, the Clinic Visit would capture an HCP Number associated to a Medical Oncologist, Systemic Program (SYS) as the Visit Program Code, followed by subsequent chemotherapy treatments captured in the Systemic Drug Delivery Event entity.

11. How do we capture family members accessing  the Psychosocial Oncology program?11. How do we capture family members accessing  the Psychosocial Oncology program?

Family member visits should be captured separately for the patient receiving the consultation/assessment (ie. Not linked to the existing cancer patient case). Instead, a new patient case should be created. The disease registration record for the family member should have a diagnosis code Z63.7 - "Other stressful life events affecting family and household". In the Clinic Visit file, the Visit Program Code should be “PSO” (Psychosocial Oncology).

12. For first consultations to the Systemic and Radiation programs, what specialty type is counted towards a C1S or C1R?12. For first consultations to the Systemic and Radiation programs, what specialty type is counted towards a C1S or C1R?

To count for a C1S or a C1R the HCP Specialty must part of the 'physician' or 'dentistry' group.  For the systemic program, a patient is typically seen by a ‘medical oncologist’ but can also be seen by physicians with fellowships in medical oncology, hematology, or internal medicine.

13. For Skin cancers, does a separate primary need to be captured if it occurs at different sites on the body?13. For Skin cancers, does a separate primary need to be captured if it occurs at different sites on the body?

Multiple primaries are counted when the histologies, such as basal cell skin carcinoma or squamous cell skin carcinoma occur on the skin, ie. Topography Code C44.*, and the Topography Code differs at the fourth character (ie. Cxx.X). See SEER 2023 Solid Tumor Rules, Other Sites, rule M14 for more details (see page 70).

Example:

Code and submit additional skin cancers, as net new primaries, by submitting separate Disease records for each (ie. maximum separate skin primaries in a patient’s lifetime would be less than 9 – the number of skin subsites from rubric C44*, see table below).  If it is the scenario of synchronous primaries, and Disease Sequence Number (DSN) is not submitted to ALR, ensure that the Registration Date is unique for each Disease record by incrementing by one day (add or minus), otherwise, the Disease records will overwrite each other and will result with only one primary (ie. the last Disease record submitted).

C441

Eyelid

C442

External ear

C443

Skin other and unspecified parts of face

C444

Skin of scalp and neck

C445

Skin of trunk

C446

Skin of upper limb and shoulder

C447

Skin of lower limb and hip

C448

Overlapping lesion of skin

C449

Skin NOS

14. Oral Prescriptions - How should the dose be reported?  (Example:  prescription- 10mg, 3 times/day)14. Oral Prescriptions - How should the dose be reported?  (Example:  prescription- 10mg, 3 times/day)

The single dose should be reported.(direction as of April 1, 2013)

15. Oral Prescriptions – OPIS:  Where is “Dose” being pulled from?15. Oral Prescriptions – OPIS:  Where is “Dose” being pulled from?

a. All administered treatments are pulled from “Given Dose” in OPIS.

b. Un-administered ‘Oral’ treatments (and hormones) are pulled from “Dose” in OPIS, which is the dose ordered.

16. Intent for Systemic Treatment – Unknown.  Does this affect funding?16. Intent for Systemic Treatment – Unknown.  Does this affect funding?

Intent is necessary for all anti-cancer treatment, however, we understand that non anti-cancer treatments ordered through EZ order may have an unknown intent, and that in this case only, the warning error # 483.2 can be ignored.

CCO advises that EZ order not be used (or discontinue use) for ordering anti-cancer treatments to avoid the potential assignment to ‘unknown’ intent, as this would impact funding.

Example:  Bisphosphonates such as Denosumab, Zoledronic Acid and Pamidronate that are reported through EZ orders where ‘intent’ could be ‘unknown’ will have funding impact.  There is funding provided through the funding model for these drugs.

Where Tylenol, Benadryl etc., have been identified as required for a regimen, the cost of these is built into the cost of the regimen (and all that is needed to trigger the funding is the regimen).

17. Does OH-CCO expect to receive Nursing visits for ALR (face-to-face and telephone)?17. Does OH-CCO expect to receive Nursing visits for ALR (face-to-face and telephone)?

Nurse visits are currently excluded from Radiation and Systemic activity (ie. C1R, C1S, R17, S1 etc.). Currently, ALR collects data for the Psychosocial Oncology (PSO) program that is interested in ‘Nursing’ visits in addition to different disciplines (specialties) associated with the program such as, dietitian, social worker, therapists etc.. If these PSO clinic visits occur via telephone, you can flag them by using “OM” in the visit type field.

18. Does OH-CCO still expect to receive ‘Surgery Only’ visits for ALR?18. Does OH-CCO still expect to receive ‘Surgery Only’ visits for ALR?

(May 14, 2014)  The future of ‘Surgery Only Caselists’ and reports are uncertain at this time until a decision from senior management is made, they are unfortunately currently still on hold and therefore not required at this time for submission.

19. What cases are RCCs expected to provide TNM stage for?19. What cases are RCCs expected to provide TNM stage for?

(May 14, 2014)  Submission of TNM Stage Data via ALR Databook:  submission of TNM stage data to CCO by RCCs is in fact still required for all primary cancer sites excluding those that are currently being staged at CCO using the Collaborative Stage Data Collection ( i.e. breast, lung, prostate, colorectal, gynecological sites, melanoma of skin and thyroid).  For the scope of what TNM stage data should be submitted by the RCC (see Data Book – ALR Appendix 1.9).

20. Should ‘inpatient’ activity be reported to ALR?20. Should ‘inpatient’ activity be reported to ALR?

Any activity that occurs on the inpatient ward should be submitted to ALR.  The Visit Hospital Number can be used to identify this activity by using the appropriate ‘AT’ master number for your facility.

Examples of activity to capture includes any consultations or follow up assessments (clinic visit file), and any Systemic drug administrations for oncology (ie. Antineoplastic treatment).  The Visit Date should be when the patient receives the consult or treatment and submitted according to the submission deadlines for when that time period is due (even if the patient remains as an inpatient overlapping submission deadlines).

21. Latest Diagnosis: What are the timelines to report a ‘new primary’ disease, as opposed to updating the original disease?21. Latest Diagnosis: What are the timelines to report a ‘new primary’ disease, as opposed to updating the original disease?

(Updated July 2019)

The 2018 SEER Solid Tumor rules (along with 2007 Multiple Primary and Histology rules, where applicable) and Hematopoietic and Lymphoid

Database (for haematology cancer) should be followed in determining when multiple primaries should be abstracted and submitted to ALR.

There are several criteria/rules to consider by disease site, in determining if capturing multiple primaries is applicable (some include: site, histology, timing, laterality etc.)

Caveat: for synchronous multiple primaries, where SEER rules instruct to abstract a separate record for each primary, only one ALR disease record should be submitted, along with the stage for the case with the worst prognosis. See FAQ #22 for example.

22. Bilateral Breast disease:  How to capture and submit for ALR?22. Bilateral Breast disease:  How to capture and submit for ALR?

Effective April 1st, 2023, this update is to retract the direction previously made on May 2020, and pertains to synchronous bilateral breast cancer, determined by 2023 SEER Solid Tumor rules, Breast, rule M7 (see page 28), is to be reported as multiple primaries (ie. submitted as separate ALR Disease records). 

NOTE:

For ST-QBP, regarding synchronous bilateral breast cancer, two Disease records are submitted, but select only one Disease record (ie. Right side) to link Clinic Visit and Systemic activity for the duration of the course/cycle of treatment.  This is to prevent over-funding of duplicate ALR cases for systemic treatment.

For RT-QBP, regarding synchronous bilateral breast cancer, two Disease records are submitted, and link Clinic Visit and Radiation activity to the appropriate Disease record(s) for the duration of the course(s) of treatment.  This is to ensure the appropriate RT protocols are captured for each case, as each side (right, left) may have differences (stage, morphology) that require specialized treatment(s) and are funded accordingly.

23. Is there an up-to-date drug classification list available?23. Is there an up-to-date drug classification list available?

The ALR drug classification report is run monthly and available in Data Book appendix 1.43.

24. Does OH-CCO count ‘benign’ disease for C1R?24. Does OH-CCO count ‘benign’ disease for C1R?

Yes, CCO pays for benign consultation as it is appropriate and good care.   We are monitoring these volumes for benign and other non-cancers to make sure it is appropriate

25. What provider specialty should ‘Advanced Practice Nurse (APN)’ be captured under?25. What provider specialty should ‘Advanced Practice Nurse (APN)’ be captured under?

Advanced Practice Nurse is an ‘umbrella’ term used across the country to identify that there are nurses who have a higher level of practice, by virtue of graduate education and/or title protection.  APNs include Clinical Nurse Specialists and Nurse Practitioners.   There is currently no specialty code specific to an APN, therefore, it is advised that the site use one of the specialty codes in Appendix 1.17 that best fits – Practical Nurse (PN) or Clinical Nurse Specialist (CNS).

26. How many Procedure codes (CCI code) can be submitted per record in the Procedure file?26. How many Procedure codes (CCI code) can be submitted per record in the Procedure file?

Only one procedure code (CCI code) is permitted per record in the Procedure file, therefore, multiple records per case may be submitted if more than one procedure code is done on the same visit date.

27. How far back does ALR go back (ie. since when did OH-CCO start collecting ALR data)?27. How far back does ALR go back (ie. since when did OH-CCO start collecting ALR data)?

CCO started collecting ALR from RCCs in 2005.  Some hospitals began reporting the full ALR data set (excluding Radiation and Procedure activity) in 2014, and then started to report Procedure activity in 2015.

The list of ALR reporting facilities is available in Data Book appendix 1.34:

http://www.cancercare.on.ca/ext/databook/db1415/Appendix/Appendix_1.34_-_Reporting_Facilities.htm

28. New sites reporting ALR that receive QA error 470 – Invalid Visit Date – Earlier than first consult, could be false if the first visit is reported in the baseline file.28. New sites reporting ALR that receive QA error 470 – Invalid Visit Date – Earlier than first consult, could be false if the first visit is reported in the baseline file.

The new sites have started to submit complete ALR data as of April 1, 2014.  The baseline file is used for the Clinic Visit activity to be able to identify cases that are already ‘active’ prior to the submission start date.  Since the baseline file is not used in the QA process on submission, the logic of error 470 is using the first visit as reported in Clinic Visit activity as the ‘first consult’, even though the case has been reported in the baseline.

There is no data quality issue on your end, since when the data moves to ALR the baseline file is accounted for, and would not affect metrics or wait times.

The false counts would be expected to taper down as time goes by, so this is a positive sign.

29. Which ‘date’ in OPIS (create date, Admin Start date, Planned Admin date) interfaces as the “Visit Date” on the Systemic file?29. Which ‘date’ in OPIS (create date, Admin Start date, Planned Admin date) interfaces as the “Visit Date” on the Systemic file?

Visit Date on Systemic file is extracted as per the following:

For administered drugs – it’s the ‘Treat Date’ on Medication Administration (Treatment screen).

For un-administered drugs – it’s the ‘Planned Adm Date’ on Chemo Order Entry (Order Details screen).

30. How are the Radiation and Systemic ALR metrics calculated? 30. How are the Radiation and Systemic ALR metrics calculated?

There is high level documentation available for ALR metrics for the Radiation program (See Radiation Program) (New ALR Metrics for Radiation Planning and Treatment Activities) and Systemic Program (See Systemic program).

31. What happens to historical ALR cases submitted with Diagnosis Codes in old ICD versions? 31. What happens to historical ALR cases submitted with Diagnosis Codes in old ICD versions?

CCO uses a mapping file to convert Diagnosis Codes submitted in old ICD versions (ie. ICD-8, ICD-9) to ICD-10-CA.  See link for CCO ICD8_9 to 10 mapping file.

 

 

 

Print This Page