Mental Health Services data set

Description

The Mental Health data set contains administrative data in several files that were created using tables in the Mental Health Data Warehouse (MHDW). The mental health data we have are the Minimum Reporting Requirement (MRR) tables from the MHDW at the Ministry of Health Services. The MRR is now the requirement for all HAs in reporting on all patient/clients receiving mental health services in the community. The mental health data are a snapshot from a continuously updated relational database system with files such as client, care episodes, and service events.Project-specific ‘care episode keys' are provided unless otherwise authorized. This allows the grouping of service records within a single care episode.

Fields available

Field Name

CARE EPISODE FILE

Care episode number Replaced by project-specific identification number (unless otherwise authorized) Note: Care episode number and project-specific Service event number are provided unless otherwise authorized. This allows the grouping of service records within a single care episode or service event.

Location code - Replaced by project-specific identification number OR  Location code (unencrypted) – Research rationale describing why this field is required must be supplied before it will be considered for release:

First contact date

CPIM PharmaCare registration code

Residence at admission code

Referral source code

Referral date

DSM axis1 code 1

DSM axis1 code 2

DSM axis2 code 1

DSM axis4 code 1

DSM axis5 code 1

DSM axis5 code 2

Residence at discharge code

Referral target

Discontinue reason code

Discontinue date

Create date

SERVICE EVENTS FILE

Care episode number Replaced by project-specific identification number (unless otherwise authorized) Note: Care episode number and project-specific Service event number are provided unless otherwise authorized. This allows the grouping of service records within a single care episode or service event.

Service event number Replaced by project-specific identification number (unless otherwise authorized) Note: Care episode number and project-specific Service event number are provided unless otherwise authorized. This allows the grouping of service records within a single care episode or service event.

Location code - Replaced by project-specific identification number OR Location code (unencrypted) – Research rationale describing why this field is required must be supplied before it will be considered for release:

First contact date

Service event code

Service event date

Employment status code

Vocational status code

Marital status code

Household composition code

Education level code

Create date

Inclusions

Only Care Episodes and Service Events with a ‘first contact date' greater than or equal to April 1, 1986 are included in the data.

Exclusions

Any ongoing care episodes starting prior to April 1, 1986 and continuing for any period afterwards are not included in the data. Also the Service Events associated with these ongoing Care Episodes are not included in the data.

Data changes over time

The Minimum Reporting Requirement (MRR) data we now receive differ slightly from the data we previously received for mental health from the Client Patient Information Management (CPIM) system. Until a revised checklist is in use, we map the original data file and field checklist against a new file and field checklist and provide researchers with the cross-walked data.

Quality/accuracy of information/field coding source

We have reason to believe there is significant under reporting in the Mental Health Data Warehouse (MHDW), although we do not have further details at this time.

References

The Ministry of Health Services, Mental Health and Addictions website has information about the MHDW (http://www.healthservices.gov.bc.ca/mhd/).