L PCH table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 18: Line 18:


== Where does this data come from? ==
== 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.
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 ==

Revision as of 12:52, 2018 January 12

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 table S_PCH
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: