L PCH table

From CCMDB Wiki
Jump to navigation Jump to search

L_PCH table is a table in Centralized_data.mdb.

Data Structure

field type description
D_PCH_ID Long integer (AutoNumber) unique ID column, random number generated by Access when a new line is added
Person_ID Long integer key against table L_Person table
PCH_ID Long integer ID of the PCH, key against S_PCH table
PCH_admission date/time date of admission to that PCH

Where does this data come from?

L_PCH table is populated as part of Crosschecking data with Manitoba Health. MB Health provides the PCH Facility Name and PCH Admission Date who are PCH residents and are in the database. Last update done in April 2015.

Related Articles

Related articles: