L PCH table: Difference between revisions
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]] | |||