L PCH table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m cleanup and then some |
m Text replacement - "L_PCH" to "L_PCH table" |
||
| Line 1: | Line 1: | ||
'''L_PCH''' is a table in [[Centralized_data.mdb]]. | '''L_PCH table''' is a table in [[Centralized_data.mdb]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 18: | Line 18: | ||
== Where does this data come from? == | == 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 [[what did we call the Death/PCH data exchange...?]] {{discussion}} | ||
== Related Articles == | == Related Articles == | ||
Revision as of 16:47, 29 November 2017
L_PCH table is a table in Centralized_data.mdb.
Data Structure
| 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 table S_PCH |
| PCH_admission | date/time | date of admission to that PCH |
Where does this data come from?
L_PCH table is populated as part of what did we call the Death/PCH data exchange...? Template:Discussion
Related Articles
| Related articles: |