L PCH table: Difference between revisions

Revision as of 12:32, 18 September 2017

L_PCH is a table in Centralized_data.mdb.

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

@@ Line 1: / Line 1: @@
 '''L_PCH''' is a table in [[Centralized_data.mdb]].
-Fields:
+== Data Structure ==
-* '''D_PCH_ID''' - unique ID column
+{| class="wikitable sortable"
-** a random number generated by Access when a new line is added
+|-
-* '''[[Person_ID]]''' - key against table [[L_Person table]]
+!| field
-* '''PCH_ID''' - ID of the PCH, key against table [[S_PCH]]
+!| type
-* '''PCH_admission''' - date of admission to that PCH
+!| 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
+|}
-There can be multiple records in table L_PCH for each entry in [[L_Person table]] in case they change PCHs.
+== 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 is populated as part of [[what did we call the Death/PCH data exchange...?]]
+== Related Articles ==
+{{Related Articles}}
-== Related Pages ==
-{{Related pages}}
 [[Category: Data structure]]
 [[Category: L Table]]
 [[Category:Multiple Encounter]]