L PCH table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m cat |
Ttenbergen (talk | contribs) m cat, link fix, RA |
||
| Line 4: | Line 4: | ||
* '''D_PCH_ID''' - unique ID column | * '''D_PCH_ID''' - unique ID column | ||
** a random number generated by Access when a new line is added | ** a random number generated by Access when a new line is added | ||
* '''Person_ID''' - key against table [[L_Person]] | * '''[[Person_ID]]''' - key against table [[L_Person table]] | ||
* '''PCH_ID''' - ID of the PCH, key against table [[S_PCH]] | * '''PCH_ID''' - ID of the PCH, key against table [[S_PCH]] | ||
* '''PCH_admission''' - date of admission to that PCH | * '''PCH_admission''' - date of admission to that PCH | ||
There can be multiple records in table L_PCH for each entry in table | There can be multiple records in table L_PCH for each entry in [[L_Person table]] in case they change PCHs. | ||
L_PCH is populated as part of [[what did we call the Death/PCH data exchange...?]] | L_PCH is populated as part of [[what did we call the Death/PCH data exchange...?]] | ||
== Related Pages == | |||
{{Related Pages}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category:L Table]] | [[Category: L Table]] | ||
[[Category:Multiple Encounter]] | |||
Revision as of 12:14, 18 September 2017
L_PCH is a table in Centralized_data.mdb.
Fields:
- D_PCH_ID - unique ID column
- a random number generated by Access when a new line is added
- Person_ID - key against table L_Person table
- PCH_ID - ID of the PCH, key against table S_PCH
- PCH_admission - date of admission to that PCH
There can be multiple records in table L_PCH for each entry in L_Person table in case they change PCHs.
L_PCH is populated as part of what did we call the Death/PCH data exchange...?