L PCH table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) u |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (12 intermediate revisions by 3 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]]. | |||
== 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 [[ | == 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}} | |||
}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: L Table]] | |||
[[Category: Multiple Encounter]] | |||
[[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.