L PCH table: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-'''L_PCH''' is a table in [[Centralized_data.mdb]].
+{{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=
-Fields:
+'''L_PCH table''' is a table in [[Centralized_data.accdb]].
-* '''D_PCH_ID''' - unique ID column
-** a random number generated by Access when a new line is added
-* '''Person_ID''' - key against table [[L_Person]]
-* '''PCH_ID''' - ID of the PCH, key against table [[S_PCH]]
-* '''PCH_admission''' - date of admission to that PCH
-There can be multiple records in table L_PCH for each entry in table L_Person in case they change PCHs.
+== Data Structure ==
+{| class="wikitable sortable"
+|-
+!| 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
+|}
-L_PCH is populated as part of [[what did we call the Death/PCH data exchange...?]]
+== 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.
-[[Category: Data structure]]
+== Related Articles ==
+{{Related Articles}}
+}}
+[[Category:Data structure]]
 [[Category:L Table]]
+[[Category:Multiple Encounter]]
+[[Category:L PCH table| *]]
+[[Category:Legacy Data structure]]