L PCH table: Difference between revisions
No edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (9 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
'''L_PCH table''' is a table in [[Centralized_data. | {{DISPLAYTITLE:L_PCH table}} | ||
{{LegacyContent | |||
| explanation=This page describes a currently unsupported process. Part of it might be implemented, but it isn't being used or checked. | |||
| successor=xxx | |||
| content= | |||
'''L_PCH table''' is a table in [[Centralized_data.accdb]]. | |||
== Data Structure == | == Data Structure == | ||
| Line 12: | Line 18: | ||
|| '''[[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 | ||
| Line 18: | Line 24: | ||
== Where does this data come from? == | == Where does this data come from? == | ||
L_PCH table is populated as part of [[ | 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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
}} | |||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: L Table]] | [[Category:L Table]] | ||
[[Category: Multiple Encounter]] | [[Category:Multiple Encounter]] | ||
[[Category: L PCH table|*]] | [[Category:L PCH table| *]] | ||
[[Category:Legacy Data structure]] | |||