Versions Compared

Old Version 4

changes.mady.by.user E Pendergast

Saved on

compared with

New Version 5

changes.mady.by.user E Pendergast

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. The Case Notes Migration Steps resource has been created to support HSPs and their vendors to understand how to best map Case Notes and Attachments. 

The following Data Downloads will cover every aspect of a client's journey: 

  • DD-01: Admission Information
  • DD-03: Client Information
  • DD-06: Pre-admission Services History
  • DD-10: Discharge Information
  • DD-11: Activity Log
  • DD-13: Group Attendance
  • DD-14: Supplementary Form - Opiates DD-14A: Supplementary Form - Supportive Housing
  •  DD-15: Gambling Data

It is important to understand what data exists currently in Catalyst, essential MHA PDS fields, as well as the required fields for all your HSP's business needs before selecting the data to be migrated into your new CMS/EMR. 

If your HSP is an AMHO member and need support understanding your data, you can contact pds@amho.ca. If your HSP is a CMHA, you can contact PDS_support@ontario.cmha.ca. Additional questions can be asked at MHA PDS Onboarding Communities of Practice and you can sign up at MHA PDS Onboarding Communities of Practice.

Resources to better understand your Catalyst data that can be found at Training, Catalyst Reports, Glossary of Reports and the DATIS Mandatory Data Set. 

Should you still need further support understanding your Catalyst data, simply respond to your Catalyst Offboarding ticket requesting this assistance. 



Expand
titleDD-01: Admissions Information

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

  • Chart/File Number
  • Lastname
  • Firstname
  • Date of Birth
  • Gender
  • Admission No
  • Admission Site
  • Admission Date/Time
  • DISCHARGE_DT_TM
  • REASON_TERMINATION_DESC
  • OSAB Registered
  • Admission Status
  • Client Type
  • Treatment Mandated/Required By
  • Probation Start Date
  • Probation End Date
  • Legal Status
  • Young Offender
  • Education
  • Relationship Status
  • Employment Status
  • Income Source
  • Non Medical IDU
  • Primary Presenting Substance (PPS) 
  • PPS Frequency
  • Presenting Issues
  • Presenting Issues Other
  • Primary Worker
  • Gambling Identified as a Problem
  • Treatment Plan
  • Referred On
  • Referral Agency One
  • Referral Source One
  • Residential City at Admission
  • Residential County at Admission
  • Postal Code at Admission
  • Provider_Name
  • Contact_Info
  • Overnight_Hosp
  • Overnight_Hosp_Unknown
  • Reason_Hosp
  • Diag_Mh_12_Months
  • Diag_Mh_Lifetime
  • Diagnoses
  • Hosp_Mh_12_Months
  • Hosp_Mh_Lifetime
  • Rcv_Mh_Current
  • Rcv_Mh_Provider
  • Rcv_Mh_Contact
  • Rcv_Mh_12_Months
  • Rcv_Mh_Lifetime
  • Med_Mh_Current
  • Med_Mh_12_Months
  • Med_Mh_Lifetime
  • Visual
  • Hearing
  • Mobility
  • Pregnant
  • Methadone
  • Meth_Prescriber
  • Meth_Phone_Area
  • Meth_Phone_No
  • Meth_Phone_Ext
  • Meth_Note
  • Drugs
  • Drugs_Prescriber
  • Drugs_Phone_Area
  • Drugs_Phone_No
  • Drugs_Phone_Ext
  • PRIMARY_SUBSTANCE_ID
  • PRIMARY_SUBSTANCE_FREQ_ID
  • CATALYST CLIENT_ID

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.

Expand
titleDD-02: Client Address History

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

  • SITE_NO
  • CLIENT_ID
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • ADDRESS
  • CITY_DESC
  • PROVINCE_DESC
  • POSTAL_CODE
  • COUNTRY_DESC
  • COUNTY_DESC
  • EFFECTIVE_DATE

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.

Expand
titleDD-03: Client Information

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

  • SITE_NO
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • GENDER_DESC
  • LASTNAME_AT_BIRTH
  • DATIS_KEY
  • ALTERNATE_NAME
  • HEALTH_CARD_NO
  • HEALTH_CARD_VERSION
  • HOME_PHONE_AREA CODE
  • HOME_PHONE
  • HOME_OK_TO_CALL
  • HOME_OK_MSG
  • WORK_PHONE_AREA_CODE
  • WORK_PHONE
  • WORK_PHONE_EXT
  • WORK_OK_CALL
  • WORK_OK_MSG
  • NOW_AT_ADDRESS
  • NOW_AT_PHONE_AREA
  • NOW_AT_PHONE
  • NOW_AT_PHONE_EXT
  • EMERGENCY_CONTACT
  • EMERGENCY_PHONE_AREA
  • EMERGENCY_PHONE
  • ETHNICITY
  • LANGUAGE_DESC
  • P_ISSUES
  • PRESENTING_OTHERS
  • ADDRESS
  • CITY
  • PROVINCE
  • POSTAL_CODE
  • COUNTRY
  • COUNTY
  • EFFECTIVE_DATE
  • LATEST_ADMISSION_NO
  • LATEST_ADMISSION_DATE
  • LATEST_DISCHARGE_DATE
  • REFERRED_ON
  • REFERRAL_SRC
  • REFERRAL_AGCY
  • REFERRAL_CONTACT
  • REFERRAL_AREA
  • OFFICIAL_LANGUAGE
  • REFERRAL_PHONE
  • REFERRAL_EXT
  • MOTHER_TONGUE
  • LABELS   
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-04: Gambling Activities

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

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • GAMBLING_ACTS_DESC
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-05: Health Conditions

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

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • COND_DESC
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-06: Pre-admission Services History

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

  • SITE_NO
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • SERVICE_DATE
  • ENTRY_SERVICE_DESC
  • DURATION
  • ENTRY_SERVICE_NOTE1
  • ENTRY_SERVICE_NOTE2_DESC
  • ENTRY_SERVICE_PROVIDER

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.

Expand
titleDD-07: Program Information

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

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • PROGRAM_NO
  • PROGRAM_NAME
  • PROV_SRV_CATGRY
  • PRG_START_DATE
  • PRG_END_DATE
  • VCARE_STATUS
  • PROGRAM_WORKER
  • REASON_DISCHARGE_DESC
  • OTHER_REASON_DISCHARGE
  • USE_ACTIVITY_LOG
  • TOTAL_SESSIONS
  • TOTAL_HOURS_DS_MANUAL
  • TOTAL_HOURS_IS_MANUAL
  • REFERRED_ON
  • REFERRED_BY
  • OUTCOMES
  • OUTCOMES_OTHER
  • FOLLOW_UP
  • LABELS
  • VALUES
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-08: Referral Source History

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

  • SITE_NO
  • CLIENT_ID
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • REFERRED_ON
  • REFERRAL_SRC_DESC
  • REFERRAL_AGCY_DESC
  • REFERRAL_CONTACT
  • REFERRAL_AREA
  • REFERRAL_PHONE
  • REFERRAL_EXT

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.

Expand
titleDD-09: Substances Used in the Past 12 Months

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

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • SUBSTANCE_DESC
  • FOR CLIENT MAPPING

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.

Expand
titleDD-10: Discharge Information

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

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • GENDER_DESC
  • CLIENT_SITE_NO
  • ADMISSION_NO
  • ADM_SITE_NO
  • ADMISSION_DATETIME
  • DISCHARGE_DT_TM
  • REASON_TERMINATION_DESC
  • CLIENT_TYPE_DESC
  • PRIMARY_WORKER
  • ADM_STATUS
  • ZERO_REFERRALS_MADE
  • LEGAL_STATUS
  • RELATIONSHIP STATUS
  • EMPLOYMENT STATUS
  • INCOME SOURCE
  • EDUCATION
  • LABELS
  • VALUES
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-11: Activity Log - Appointment Information (includes all Entry Service)

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

  • SITE_NO
  • SERVICE_SITE
  • ServiceProviderName1
  • ACTLOG_ID
  • START_DATE
  • Group_name
  • CLIENT_ID
  • CHART_NO
  • LASTNAME
  • FIRSTNAME
  • ADMISSION_NO
  • ADMISSION_DATETIME
  • DISCHARGE_DT_TM
  • PROGRAM_NO
  • PROGRAM_NAME
  • PRG_START_DATE
  • PRG_END_DATE
  • Service Type
  • Activity_Desc
  • CLIENT TIME
  • DURATION
  • CASEWORKER_1_TIME_SPENT
  • ACTSTATUS_DESC
  • ACTNOTE_DESC
  • ANON_TOTAL
  • ANON_MALE
  • ANON_FEMALE
  • ANON_OTHER
  • ANON_UNDER16
  • ANON_16_18
  • ANON_19_54
  • ANON_55_65
  • ANON_OVER65
  • LARGE_TOTAL
  • CREATED_BY
  • CREATED_ON
  • ServiceProviderNames
  • CWS_TIME_SPENT
  • LABELS
  • VALUES

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.

Expand
titleDD-12: Referral Information

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

  • CHART_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE_NO
  • ADMISSION_DATETIME
  • DISCHARGE_DT_TM
  • REFERRAL_NO
  • Refer On
  • Refer By
  • Participating_Refer To PSC
  • Participating_Refer To Agency
  • E-Referral_ApprovedByClien
  • Non-Participating_REFER_TO
  • Non-Participating_ReferToServiceType
  • Internal_ReferToProgram
  • Internal_ReferToProgram_PSC
  • REFERRING_PROGRAM_ID
  • CONTACT
  • CONTACT_DEPT
  • CONTACT_PHONE_AREA
  • CONTACT_PHONE
  • CONTACT_PHONE_EXT
  • CONTACT_FAX_AREA
  • CONTACT_FAX
  • CONTACT_EMAIL
  • Reason for Referral
  • REASON_REFERRAL_OTHER
  • Transmitted
  • OUTCOMES
  • OUTCOMES_OTHER
  • Referral Status
  • STATUS_REFERRAL_OTHER
  • LABELS
  • VALUES
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-13: Group Attendance Information

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:

  1. Group attendees of the same group have the same ACTLOG_ID.
  2. The Service Provider field contains the main provider, i.e. the provider who filled in the group attendance information.
  3. 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

  • ACTLOG_ID
  • SITE_NO
  • SERVICE_SITE
  • ServiceProviderName
  • START_DATE
  • GROUP
  • Service Type
  • ACTIVITY_DESC
  • DURATION
  • ACTUAL_TIME_SPENT
  • Appointment - Activity Status
  • Appointment - Activity Comment
  • CLIENT_ID
  • CHART_NO
  • FIRSTNAME
  • LASTNAME
  • Client is a member of the Group?
  • ADMISSION_NO
  • ADMISSION_DATETIME
  • DISCHARGE_DT_TM
  • PROGRAM_NO
  • PROGRAM_NAME
  • PRG_START_DATE
  • PRG_END_DATE
  • Client - Activity Status
  • Client - Activity Comment
  • VISIT_TYPE_DESC

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.

Expand
titleDD-14: Supplementary Form

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

  • CHART_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_DATETIME
  • ADMISSION_SITE_NO
  • DISCHARGE_DT_TM
  • FORM_ID
  • FORM_DATE
  • LABELS
  • VALUES
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-15: Gambling Data Form and Reason for Not Completing the Gambling Data Form

Description

The DD-15: Gambling Data Form report generates a data download that contains that was entered within the selected date range.


Report Columns

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • SITE_NO
  • REASON_NO_GAMBLING_FORM
  • Q1_SEEKING_HELP
  • Q2_YEARS
  • Q2_MONTHS
  • Q3_NUMBER
  • Q3_YR_MO_WK_DY
  • Q4
  • Q5AS
  • Q5S_19_OTHER
  • Q5B_MAJOR
  • Q5B_OTHERS
  • Q5B_2ND_OTHER
  • Q6A_S
  • Q6B_MAJOR
  • Q6B_OTHERS
  • Q7_ONTARIO
  • Q7_ANOTHER_PROVINCE
  • Q7_OUTSIDE_CANADA
  • FOR CLIENT MAPPING PURPOSES

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.

Expand
titleDD-16: Follow Up Information

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

  • LASTNAME
  • FIRSTNAME
  • FOLLOW_UP_DATE
  • ADMISSION_NO
  • PROGRAM_NAME
  • OUTCOME_DESC
  • NOTES
  • LABELS
  • VALUES
  • CLIENT_ID

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.

Expand
titleDD-17: Prescribed Drugs

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

  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • P_DRUG_DESC
  • FOR CLIENT MAPPING PURPOSES

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.


New Data Downloads for Data Migration
Expand
titleWhere to find the new Data Migration Reports

To find the new Data Downloads for Migration, you will be able to find them under the Data Downloads folder, in the Data Migration Reports folder.

 

Once selected, users will have access to the following reports:

DD-18: Group Information

DD-19: Case Worker Lookup

DD-20: Agency Program Lookup

DD-21: ACL Lookup

Expand
titleDD-18: Group Information

Description

The DD-18: Group Information report generates a data download that contains all your organization's Group, Program, and Functional Centre information for all time.  

Report Columns

  • DART 
  • GROUP_ID 
  • GROUP_DESC 
  • GRP_STARTDATE 
  • GRP_ENDDATE 
  • GRPLEADER1_ID 
  • GRPLEADER2_ID 
  • GRPLEADER3_ID 
  • PROGRAM_ID 
  • PROGRAM_NAME 
  • FC_ACCOUNT 

Appearance in Catalyst Reports when first downloading the DD-18:

Appearance once the DD-18 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.

Expand
titleDD-19: Caseworker Lookup

Description

The DD-19: Case Worker Lookup report generates a data download of all Case Worker ID’s, their name (in the CASEWORKER_DESC column), and if their user status is active or not.   

Report Columns

  • DART 
  • CASEWORKER_ID 
  • CASEWORKER_DESC 
  • ACTIVE 

Appearance in Catalyst Reports when first downloading the DD-19:

Appearance once the DD-19 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.

Expand
titleDD-20: Agency Program Lookup

Description

The DD-20: Agency Program Lookup report generates a data download that contains all your organization's Program, Bed Numbers, Activities, and Functional Centre information for all time.  

Report Columns

  • DART
  • PROGRAM_ID
  • PROGRAM_NAME
  • ACTIVITY LOG
  • NO_OF_BEDS
  • ACTIVE
  • PROGRAM_DESCFC_ID
  • FC_ACCOUNT

Appearance in Catalyst Reports when first downloading the DD-20:

Appearance once the DD-20 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.

Expand
titleDD-21: ACL Lookup

Description

The DD-21: ACL Lookup report generates a data download that contains all your organization's currently locked clients using the Access Client Lock function in Catalyst.  If there are any rows generated in this report, these restrictions will have to reviewed to ensure that the primary person on your team performing the Data Downloads for the migration is not restricted and allowed to extract all clients' data. Note, this information can be transferred to any lockbox function in any CMS/EMR using this report.

Report Columns

  • DART
  • CLIENT_ID
  • USER_ID
  • USER FIRSTNAME
  • USER LASTNAME

Appearance in Catalyst Reports when first downloading the DD-21:

Appearance once the DD-21 has been exported as a "Microsoft Excel Workbook Data-only" file format and the headers of each column have been resized.