Mental Health

Printer-friendly version

Date range: April 1, 1986 onwards (fiscal year)

Data source: The BC Ministry of Health

This checklist is historical and provided only for reference. Please refer to https://my.popdata.bc.ca/dar/ for the current application and checklists.


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.

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/).

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

 


Page last revised: November 1, 2017