L PCH table
L_PCH table is a table in Centralized_data.mdb.
|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.