Concept: Long Term Care (LTC) Data Overview
Last Updated: 2018-01-04
NOTE: Before beginning your work with the data, it is recommended that you identify what facilities and level of care will be included in your study definition of LTC / PCH.
I - Manitoba Health Long Term Care (LTC) Utilization Database
The Manitoba Health Long Term Care (LTC) Utilization database is a database maintained by Manitoba Health that contains data for the entire province beginning in 1973. It includes records of services provided by LTC facilities in Manitoba, more recently including records for hospital patients in LTC-designated beds awaiting placement in a PCH facility. This data consists of four main files that can be linked together by scrPHIN (Scrambled PHIN) and the corresponding dates.
- Assessments File
- contains data on each individual assessed for admission into LTC and while in LTC. The data also includes people assessed but never admitted into LTC.
- variables include: level of care required, location indicator and date of the assessment. NOTE: The changes in levels of care for existing PCH residents are not consistently recorded in recent years.
- can be used to determine Panel to PCH information, and the waiting time from panel to LTC / PCH admission.
- Admissions File
- contains data for individuals admitted to any LTC facility in Manitoba.
- variables include: level of care, location indicator, assessment and admission dates. This also includes respite care admissions (Level of Care = 5).
- can be used to determine LTC residency, LTC admissions, waiting time, and length of stay (LOS).
- Separations File
- contains data for separations (discharges) from LTC facilities and does not include respite care records. Separations can be linked to admissions, using scrambled PHIN, assessment and admission dates. For residents still admitted at the time of the Separation file creation, separation records will be missing. For longer hospital stays (> ? of days), there will be a PCH separation record generated and a new admission record will appear once/if the resident returns to the PCH after hospital discharge.
- variables include: location indicator, assessment and separation dates, and type of separation (e.g. ’9’ is for separation type due to death).
- can be used to determine LTC residency, LTC separations, and length of stay (LOS).
- Rate Change Transactions File
- contains data on the per diem rate paid by an individual for PCH services, date, and a rate appeal code.
- file can be used to determine the PCH residents’ per diem rate and approximate income level.
Commonly Used Variables
- Demographics - Manitoba Health adds sex, date of birth and limited postal code and municipality code information to the LTC Utilization data from the Manitoba Health Insurance Registry data when the LTC database is generated.
- Levels of Care - in a PCH - this is a classification system for PCH residents used to define the extent of their dependence, and to approximate the amount of daily nursing care they may require. Residents assigned to Level of Care I are estimated to require 0.5 hours of nursing care, residents assigned to Level of Care II - 2.0 hours of care, and those assigned to Level of Care III or IV - at least 3.5 hours of nursing care during a 24-hour period.
Note: Analysis of Level of Care at time of LTC admission has a broader scope of interpretation - please read the Level of Care - LTC Admissions glossary term for more information.
- Facility Number - facility numbers ranging from 500 to 900 in the LTC database represent licensed PCH facilities. Levels of care for residents in these facilities will range from 1 to 4. in some cases, Level of Care = 5 represents respite care.Special Considerations: for Riverview, Deer Lodge, Misericordia Place, Companion Care (PCH # 507) and other Facility Numbers.
- Riverview PCH is facility # 587 and Riverview CC is facility/hospital # 6.
- Deer Lodge PCH is facility # 699 and Deer Lodge CC is facility/hospital # 19.
- Misericordia Place PCH is facility #509. Misericordia Place facility # 4 is not a licensed PCH, but in many respects functions like one.
- Companion Care PCH # 507 is "unknown location".
The residents of these "special consideration" facilities are part of the WRHA MDS 2.0 data, and can be included in a definition of LTC by specific facility number (< 500) and/or level of care = 6 (CC).
- Dates: - admission, separation and assessment dates are used to determine LTC / PCH residency, new admissions versus existing residents, discharges, transfers and length of stay (LOS).
Data Limitations / Cautions
The process of data collection, acquisition, as well as some formats and values in this database underwent changes over time. Here are some of the highlights:
- Changes in Data Acquisition Process - historically, each new set of MH LTC data completely replaced the previously received data acquisition. However, since year (??) only new records and changes/corrections to pre-existing data are received and installed in the Data Repository. This means that selection of data and the process of removing duplicate records can give slightly different results depending on sorting order and/or variables used in such sorting. The overall population effect of these differences is usually small.
- Changes in Data Coding - between 1997 and 2002, admission Levels of Care = 7, 8 and 9 were used to designate "waiting in hospital for placement- - for respite, PCH, or CC, respectively. Since 2003, such records have Levels 5, 1-4, 6 recoded, with facility/hospital number <500.
- Other Considerations - with the introduction of Supportive Housing as alternative to PCH placement, the record with original Panel to PCH date might not be available until the actual PCH placement.
SAS Code Examples for LTC Utilization Data
The following SAS code examples for working with the LTC Utilization data are available in the SAS Code and Formats section below (Internal Access Only):See the Manitoba Health Long Term Care (LTC) Utilization Data Description for more general information about this database.
- LTC Utilization Admissions SAS Code - this code extracts data on Long Term Care (LTC) admissions into licensed PCH or PCH bed in any facility, or admissions into any type of LTC facility (such as PCH, PCH bed in hospital, or CC facility) except for respite care.
- LTC Utilization Panel to PCH SAS Code - this code identifies outcome data (Panel Status) on the Panel to Personal Care Home (PCH) process for admission to PCH
- LTC Utilization Residents SAS Code - this code extracts data on Long Term Care (LTC) and Personal Care Home (PCH) residents.
II - Winnipeg Regional Health Authority (WRHA) LTC Minimum Data Set (MDS) Database
The Winnipeg Regional Health Authority (WRHA) LTC Minimum Data Set (MDS) database is a database maintained by the Winnipeg Regional Health Authority (WRHA) that contains data for Winnipeg only, beginning in 2000. It consists of five types of files: admissions, discharges, re-entries and full and quarterly assessments. The assessments include a wide array of information about the resident. Full assessments are typically completed on admission to a facility and then once per year. However, some facilities choose to complete Full Assessments on a quarterly basis (every 3 months). All forms include basic demographic information such as birthdate, sex, and scrambled PHIN. All the data from these files can be linked together by scrPHIN (Scrambled PHIN), and organized chronologically by date.
- Admissions File
- contains data on individuals admitted to Winnipeg PCHs.
- variables include: individual-level demographic and personal health data, including: marital status; language; education level; postal code before 1st admission, at 1st admission and at current admission; facility / service admitted from; and data on specific medical conditions.
- Discharge File
- contains data on individuals discharges from Winnipeg PCHs.
- variables include: date of discharge and discharge disposition.
- Full MDS Assessments File
- contains comprehensive assessment data for each individual assessed for admission to PCH, and on a yearly (or more frequent) basis.
- variables include individual-level:
- medical history and limited health care use history;
- Activities of Daily Living (ADL) measures: (e.g.: movement in bed, transfers, dressing, personal hygiene, etc.) necessary for normal self-care.
- levels of independence in recreation, mealtime, and other daily activities;
- clinical and health care information (e.g.: chronic conditions, advanced directives (living will, DNR, etc.), memory, weight, height, dietary considerations and therapies (speech, OT, PT, etc.)).
- Quarterly MDS Assessments
- contains data on quarterly individual-level assessments. After an initial full assessment upon admission to the LTC facility, assessments are completed quarterly thereafter to capture changes in health and functional performance and record some of the events / health care use between assessments.
- variables include: those similar to the Full Assessment (see above).
- NOTE: Quarterly MDS assessments typically have less information than Full MDS assessments.
Special Considerations for Assessments
- some facilities choose to complete Full Assessments on a quarterly basis.
- all data fields are automatically populated from the default values or in case of non-first form, by previously filled values. Thus, there are no explicit missing values in this database. Missing dates are coded by default SAS date January 1, 1960.
- forms can be completed over several days and there are locked (finalized) and unlocked (still in process) forms in the database. As a rule, MCHP only use locked MDS 2.0 records during analysis.
- Facility File
- contains data on WRHA LTC facilities.
- variables include: the WRHA MDS facility number (variable = UniqFacilityID), address and name of the facility. PCH facility number can be derived from the first three digits of a variable MDSINNUM and this value will corresponds to the facility number coded in MH LTC database.
Data Limitations / Cautions
- The data only contains information from LTC facilities in Winnipeg.
- Facility data comes in a separate file and has changed in format over time.
SAS Code Examples for WRHA LTC MDS Data
The following SAS code examples for working with the WRHA LTC MDS data are available in the SAS Code and Formats section below (Internal Access Only):See the Winnipeg Regional Health Authority (WRHA) LTC Minimum Data Set (MDS) Data Description for more general information about this database.
- LTC MDS Add Facility SAS Macro - this code adds additional facility information (PCH number, location address, etc.) to any MDS table.
- LTC MDS Assessments SAS Code - this code extracts MDS Assessment records from the FULL and QUARTERLY Assessment datasets.