L PCH table: Difference between revisions

Latest revision as of 09:35, 2023 June 6

This page contains Legacy Content.

Explanation: This page describes a currently unsupported process. Part of it might be implemented, but it isn't being used or checked.
Successor: xxx

Click Expand to show legacy content.

L_PCH table is a table in Centralized_data.mdb.

{

@@ 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=
+'''L_PCH table''' is a table in [[Centralized_data.mdb]].
 == Data Structure ==
@@ Line 12: / Line 18: @@
 || '''[[Person_ID]]''' || Long integer || key against table [[L_Person table]]
 |-
-|| '''PCH_ID''' || Long integer || ID of the PCH, key against table [[S_PCH]]
+|| '''PCH_ID''' || Long integer || ID of the PCH, key against [[S_PCH table]]
 |-
 || '''PCH_admission''' || date/time || date of admission to that PCH
@@ Line 18: / Line 24: @@
 == Where does this data come from? ==
-L_PCH is populated as part of [[what did we call the Death/PCH data exchange...?]] {{discussion}}
+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}}
+}}
 [[Category: Data structure]]
 [[Category: L Table]]
-[[Category:Multiple Encounter]]
+[[Category: Multiple Encounter]]
+[[Category: L PCH table| *]]
+[[Category:Legacy Data structure]]