L Person table: Difference between revisions

Revision as of 12:07, 2017 September 18

L_Person is a table in Centralized_data.mdb used to record the concept of Multiple Encounter.

There can be multiple records in table L_Person for each entry in table L_Log.

L_Hospitalization is populated as part of Encounter processing.

field	type	description
Person_ID	text	Person_ID field
Death	date	date of death a per where does this come from? Template:Discussion date of death as acquired from PCH data when we get that set up
Last_update	date	last time the record was updated by what process Template:Discussion date that gets set to "now" whenever a new bit of info is found for the corresponding patient

@@ Line 5: / Line 5: @@
 L_Hospitalization is populated as part of [[Encounter processing]].
-==Fields==
+== Data Structure ==
-* '''Person_ID''' that uniquely identifies a person (rather than a patient ward admission, as in L_Log).
+{| class="wikitable sortable"
-** a random number generated by Access when a new line is added
+|-
-** It would be permanently stored and therefore remain the same for new encounters of that patient in L_Log/L_PHI, but if an L_Person record were ever deleted and recreated it would NOT receive the same ID next time around.
+!| field
-* Death
+!| type
-** date of death as acquired from [[PCH data]] when we get that set up
+!| description
-*** outstanding, will need to be set up, leaving blank for now {{discussion}}
+|-
-* Last_update
+|| '''Person_ID''' || text || [[Person_ID field]]
-** date that gets set to "now" whenever a new bit of info is found for the corresponding patient
+|-
+|| '''Death''' || date || date of death a per [[where does this come from?]] {{discussion}} date of death as acquired from [[PCH data]] when we get that set up
+|-
+|| '''Last_update''' || date || last time the record was updated by [[what process]]{{discussion}} date that gets set to "now" whenever a new bit of info is found for the corresponding patient
+|}
 [[Category: Data structure]]
 [[Category:Multiple Encounter]]
 [[Category:L Table]]