All Collections
Reports
Health Canada Reports
Health Canada Reports
Andrew Day avatar
Written by Andrew Day
Updated over a week ago

In the Reports module, open the Health Canada tab in the Report Types section to access Heath Canada reports. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report in CSV format.

Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight.

Note: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.

The Seed-to-Sale software currently offers one Health Canada report:

Quarterly By Province

Generates a quarterly report of patients by province, including patient, physician, prescription and shipment information.

  • Required Filter Fields: Start and End dates, and Province must be selected for the report.

  • Optional Filter Fields: None

  • Order:

  • Data Points Pulled:

    • Patient's full name

    • Patient's date of birth.

    • Patient's street address line 1

    • Patient's street address line 2

    • Patient's city

    • Patient's postal code

    • Patient's Province

    • Physician's title and full name

    • Physician's street address line 1

    • Physician's street address line 2

    • Physician's city

    • Physician's postal code

    • Physician's Province

    • Physician's license number

    • Grams per day in the patient's prescription

    • Duration of the prescription

    • Prescription start date

    • Total grams shipped to the patient

    • Date of shipment

      mceclip0.png
      mceclip1.png
      mceclip2.png
      mceclip3.png

Did this answer your question?