There are 21 Data Download Reports available for migration. Each report contains critical information needed to map all Catalyst data, (including custom fields) into your new CMS/EMR using the Provincial MDS to PDS Mapping Standard. All PDS-compliant vendors reviewed this tool each with the MHA Centre of Excellence and DATIS as well have been given the final copy.
Additional reports DD-18 through DD-21 were built for HSPs to provide to their vendors to assist with record mapping. DD-01 through DD-17 contain the data in client records.
There are 21 Data Download Reports available for migration. Each report contains critical information needed to map all Catalyst data, (including custom fields) into your new CMS/EMR using the Provincial MDS to PDS Mapping Standard. All PDS-compliant vendors reviewed this tool each with the MHA Centre of Excellence and DATIS as well have been given the final copy.
Additional reports DD-18 through DD-21 were built for HSPs to provide to their vendors to assist with record mapping. DD-01 through DD-17 contain the data in client records.
Description
The DD-01: Admission Information report generates a data download that contains all admission information for the selected date range. Note, if an admission was created outside of the date selection, it will not be included in the data download report.
Report Columns
|
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-01:
Appearance once the DD-01 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-02: Client Address History report generates a data download that contains all client address changes in Catalyst of all time.
Report Columns
|
|
|---|
Appearance in Catalyst Reports when first downloading the DD-02:
Appearance once the DD-02 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-03: Client Information report generates a data download that contains all client information for the selected date range. Note, you may want to run this report for all time to ensure all client information such as DOB, Emergency contact information, etc. are available when migrating. This is because the date range captures only when this form was first created, which may be outside of the date range desired for migration.
Report Columns
|
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-03:
Appearance once the DD-03 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-04: Gambling Activities report generates a data download that contains Admission Information as well as Gambling behaviour descriptions for the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-04:
Appearance once the DD-04 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-05: Health Conditions report generates a data download that contains Admission Information as well as Descriptions of Health Conditions listed for all clients that were captured within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-05:
Appearance once the DD-05 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-06: Pre-admission Services History report generates a data download that contains entry service information that was entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-06:
Appearance once the DD-06 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-07: Program Information report generates a data download that contains all Admission and Program Information entered within the selected date range.
Report Columns
|
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-07:
Appearance once the DD-07 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-08: Referral Source History report generates a data download that contains referral information that was entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-08:
Appearance once the DD-08 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-09: Substances Used in the Past 12 Months report generates a data download that contains Admission Information and Substances Used that was entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-09:
Appearance once the DD-09 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-10: Discharge Information report generates a data download that contains Admission and Discharge Information that was entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-10:
Appearance once the DD-10 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-11: Activity Log report generates a data download that contains Activities and Program Information that was entered within the selected date range.
Report Columns
|
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-11:
Appearance once the DD-11 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-12: Referral Information report generates a data download that contains Admission, Discharge, Participation, and Referral Information that was entered within the selected date range.
Report Columns
|
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-12:
Appearance once the DD-12 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-13: Group Attendance Information report generates a data download that contains includes Group Attendance, Activity, and Program Information that was entered within the selected date range.
Some important notes about DD-13:
- Group attendees of the same group have the same ACTLOG_ID.
- The Service Provider field contains the main provider, i.e. the provider who filled in the group attendance information.
- To identify the secondary providers of a group appointment, please use the Activity Log data dump (DD-11). All providers of a group appointment have the same GROUP_ID and START_DATE (date and time) values.
Report Columns
|
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-13:
Appearance once the DD-13 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-14: Supplementary Form Opiates report and DD-14A: Supplementary Form Supportive Housing generates a data download that contains Admission, Discharge, and Supplementary Form information that was entered within the selected date range.
Report Columns for DD-14
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-14:
Appearance in Catalyst Reports when first downloading the DD-14A:
Appearance once the DD-14 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Appearance once the DD-14A has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-15: Gambling Data Form report generates a data download that contains that was entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-15:
Appearance once the DD-15 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-16: Follow Up Information report generates a data download that contains Follow Up Information of Programs that was entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-16:
Appearance once the DD-16 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
Description
The DD-17: Client Address History report generates a data download that contains Admission and Previous Drug Use descriptions that were entered within the selected date range.
Report Columns
|
|
|---|
Image of parameters for pulling 10 years of data:
Appearance in Catalyst Reports when first downloading the DD-17:
Appearance once the DD-17 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.
