L PCH table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
mNo edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{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]].
'''L_PCH table''' is a table in [[Centralized_data.mdb]].


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 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
|| '''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 [[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 ==
{{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]]

Latest revision as of 08:35, 6 June 2023

Legacy Content

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.

Data Structure

{