Versions Compared

Old Version 1

changes.mady.by.user E Pendergast

Saved on

compared with

New Version Current

changes.mady.by.user Hadaf Zubi

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 for program names, group names and caseworker names along with a listing of all locked clients for HSPs using the Client Lock module. 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. 

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. 

Please note that date ranges may not match if they are time-limited. For example, a case note might be attached to a program opened 5 years ago, but unless DD-01 (admissions) and DD-07 (client programs) match that date range, the metadata about the case note won't be available. Due to this, it's recommended that the Data Downloads be run for as wide a date range as possible.

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-07: Program Information
  • 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:

Image Added

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

Image Added

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.

Image Added

Image of parameters for pulling 10 years of data:

Image Removed

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

Image RemovedImage Added

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

Image RemovedImage Added

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
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
Expand
titleDD-0203: Client Address HistoryInformation

Description

The DD-0203: Client Address History Information report generates a data download that contains all client address changes in Catalyst of all timedownload 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

CLIENT_IDADDRESS
  • SITE_NO
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • CITY_DESC
  • PROVINCE_DESC
  • POSTAL_CODE
  • COUNTRY_DESC
  • COUNTY_DESC
  • EFFECTIVE_DATE

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

Image Removed

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.

Image Removed

  • 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:

Image Added

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

Image Added

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.

Image Added

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
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:

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

Expand
titleDD-0405: Gambling ActivitiesHealth Conditions

Description

The DD-0405: Gambling Activities Health Conditions report generates a data download that contains Admission Information as well as Gambling behaviour descriptions for 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
  • GAMBLING_ACTSCOND_DESC
  • FOR CLIENT MAPPING PURPOSES

Image of parameters for pulling 10 years of data:

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

Expand
titleDD-05: Health Conditions06: Pre-admission Services History

Description

The DD-05: Health Conditions 06: Pre-admission Services History report generates a data download that contains Admission Information as well as Descriptions of Health Conditions listed for all clients that were captured entry service information that was entered within the selected date range.


Report Columns

  • SITE_NO
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSIONSERVICE_NODATE
  • ENTRY_SERVICE_DESC
  • DURATION
  • ENTRY_SERVICE_NOTE1
  • ENTRY_SERVICE_NOTE2_DESC
  • ENTRY_SERVICE_PROVIDER
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • COND_DESC
  • FOR CLIENT MAPPING PURPOSES

Image of parameters for pulling 10 years of data:

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

Expand
titleDD-06: Pre-admission Services History07: Program Information

Description

The DD-06: Pre-admission Services History 07: Program Information report generates a data download that contains entry service information that was entered within the 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
  • 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:

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

Expand
titleDD-07: Program Information08: Referral Source History

Description

The DD-07: Program Information 08: Referral Source History report generates a data download that contains all Admission and Program Information entered within the referral information that was entered within the selected date range.


Report Columns

  • SITE_NO
  • CLIENT_ID
  • CASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
  • ADMISSION_SITE
  • ADMISSION_DATETIME
  • OSAB_REG
  • PROGRAM_NO
  • PROGRAM_NAME
  • 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:

Image Added

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

Image Added

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.

Image Added

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
  • 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:

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

Expand
titleDD-08: Referral Source History10: Discharge Information

Description

The DD-08: Referral Source History 10: Discharge Information report generates a data download that contains referral information Admission and Discharge Information that was entered within the selected date range.

Report Columns

  • SITECASE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • GENDER_DESC
  • CLIENT_SITE_IDNO
  • CASEADMISSION_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • REFERRED_ON
  • 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
  • REFERRAL_SRC_DESC
  • REFERRAL_AGCY_DESC
  • REFERRAL_CONTACT
  • REFERRAL_AREA
  • REFERRAL_PHONE
  • REFERRAL_EXT

Image of parameters for pulling 10 years of data:

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

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

Expand
titleDD-09: Substances Used in the Past 12 Months11: Activity Log - Appointment Information (includes all Entry Service)

Description

The DD-09: Substances Used in the Past 12 Months 11: Activity Log report generates a data download that contains Admission Information and Substances Used that was Activities and Program Information that was entered within the selected date range.


Report Columns

CASE
  • SITE_NO
  • LASTNAME
  • FIRSTNAME
  • DOB
  • ADMISSION_NO
    • ADMISSION_SITE
    • SERVICE_SITE
    • ServiceProviderName1
    • ACTLOG_ID
    • START_DATE
    • Group_name
    • CLIENT_ID
    • CHART_NO
    • LASTNAME
    • FIRSTNAME
    • ADMISSION_NO
    • ADMISSION_DATETIME
    OSAB
    • DISCHARGE_DT_
    REG
    • TM
    SUBSTANCE
    • PROGRAM_
    DESC
  • FOR CLIENT MAPPING

    • Image of parameters for pulling 10 years of data:

    Image Removed

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

    Image Removed

    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.

    Image Removed

    Expand
    titleDD-10: Discharge Information
    • 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:

    Image Added

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

    Image Added

    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.

    Image Added

    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:

    Image Added

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

    Image Added

    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.

    Image Added

    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:

    Image Added

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

    Image Added

    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.

    Image Added

    Image of parameters for pulling 10 years of data:

    Image Removed

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

    Image Removed

    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.

    Image Removed

    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:

    Image Removed

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

    Image Removed

    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.

    Image Removed

  • CONTACT_EMAIL
  • Reason for Referral
  • REASON_REFERRAL_OTHER
  • Transmitted
  • OUTCOMES
  • OUTCOMES_OTHER
  • Referral Status
    • STATUS_REFERRAL_OTHER
    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
    • 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
    Expand
    titleDD-11: Activity Log - Appointment Information (includes all Entry Service)
    • 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
    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
    • LABELS
    • VALUES
    • FOR CLIENT MAPPING PURPOSES

    Image of parameters for pulling 10 years of data:

    Image Removed

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

    :

    Image Added

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

    Image Added

    Appearance in Catalyst Reports when first downloading the DD-14A:

    Image Added

    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.

    Image AddedImage Removed

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

    Expand
    titleDD-13: Group Attendance Information15: Gambling Data Form and Reason for Not Completing the Gambling Data Form

    Description

    The DD-13: Group Attendance Information 15: Gambling Data Form report generates a data download that contains includes Group Attendance, Activity, and Program Information 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:

    Image Added

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

    Image Added

    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.

    Image Added

    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

    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
    • PRGOUTCOME_START_DATE
    • PRG_END_DATE
    • Client - Activity Status
    • Client - Activity Comment
    • DESC
    • NOTES
    • LABELS
    • VALUES
    • CLIENT_IDVISIT_TYPE_DESC

    Image of parameters for pulling 10 years of data:

    Image RemovedImage Added

    Appearance in Catalyst Reports when first downloading the DD-1316:Image Removed

    Image Added

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

    Image RemovedImage Added

    Image of parameters for pulling 10 years of data:

    Image Removed

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

    Image Removed

    Appearance in Catalyst Reports when first downloading the DD-14A:

    Image Removed

    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.

    Image Removed

    Expand
    titleDD-1417: Supplementary FormPrescribed Drugs

    Description

    The DD-14: Supplementary Form Opiates report and DD-14A: Supplementary Form Supportive Housing 17: Client Address History report generates a data download that contains Admission , Discharge, and Supplementary Form information that was and Previous Drug Use descriptions that were entered within the selected date range.


    Report Columns

    for DD-14

    CHART
    • CASE_NO
    • LASTNAME
    • FIRSTNAME
    • DOB
    • ADMISSION_NO
    • ADMISSION_SITE
    • ADMISSION_DATETIME
    • OSAB_REG
    ADMISSION
    • P_
    SITE_NO

    • DISCHARGE_DT_TM
    • FORM_ID
    • FORM_DATE
    • LABELS
    • VALUES
    • FOR CLIENT MAPPING PURPOSES
    • DRUG_DESC
    • FOR CLIENT MAPPING PURPOSES

    Image of parameters for pulling 10 years of data:

    Image Added

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

    Image Added

    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.

    Image Added


    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.

     Image Added

    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

    Image AddedAppearance 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 Form18: Group Information

    Description

    The DD-15: Gambling Data Form 18: Group Information report generates a data download that contains that was entered within the selected date range.all your organization's Group, Program, and Functional Centre information for all time.  

    Report Columns

    CASENO
  • 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
    • DART 
    • GROUP_
    • 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:

    Image Removed

    • 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:

    Image Added

    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.

    Image Added

    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-1519:

    Image Removed

    Image Added

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

    Image RemovedImage Added

    Image of parameters for pulling 10 years of data:

    Image Removed
    • ACTIVITY LOG
    • NO_OF_BEDS
    • ACTIVE
    • PROGRAM_DESCFC_ID
    • FC_ACCOUNT

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

    Image Removed

    Image Added

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

    Image RemovedImage Added

    Expand
    titleDD-16: Follow Up Information20: Agency Program Lookup

    Description

    The DD-16: Follow Up Information 20: Agency Program Lookup report generates a data download that contains Follow Up Information of Programs that was entered within the selected date range.all your organization's Program, Bed Numbers, Activities, and Functional Centre information for all time.  

    Report Columns

    LASTNAMEADMISSION_NO
    • DART
  • FIRSTNAME
  • FOLLOW_UP_DATE
    • PROGRAM_ID
    • PROGRAM_NAME
    • OUTCOME_DESC
    • NOTES
    • LABELS
    • VALUES
    • CLIENT_ID
    • DART
    • CLIENT_ID
    • USER_ID
    • USER FIRSTNAME
    • USER LASTNAME

    Image of parameters for pulling 10 years of data:

    Image Removed

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

    Image Removed

    Image Added

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

    Image RemovedImage Added

    Expand
    titleDD-1721: Prescribed DrugsACL Lookup

    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 range21: 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

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