L PCH table: Difference between revisions
Jump to navigation
Jump to search
m TinaBot moved page L PCH to L PCH table without leaving a redirect: consistent naming of table articles and categories |
No edit summary |
||
| Line 25: | Line 25: | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: L Table]] | [[Category: L Table]] | ||
[[Category:Multiple Encounter]] | [[Category: Multiple Encounter]] | ||
[[Category: L PCH table|*]] | |||
Revision as of 17:24, 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: |