L PCH table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "|*" to "| *" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 12: | Line 12: | ||
|| '''[[Person_ID]]''' || Long integer || key against table [[L_Person table]] | || '''[[Person_ID]]''' || Long integer || key against table [[L_Person table]] | ||
|- | |- | ||
|| '''PCH_ID''' || Long integer || ID of the PCH, key against | || '''PCH_ID''' || Long integer || ID of the PCH, key against [[S_PCH table]] | ||
|- | |- | ||
|| '''PCH_admission''' || date/time || date of admission to that PCH | || '''PCH_admission''' || date/time || date of admission to that PCH | ||
Revision as of 12:24, 16 May 2018
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: |