L Person table: Difference between revisions

Revision as of 17:05, 2017 November 29

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_Person is populated as part of Encounter processing.

field	type	description
Person_ID	text	Person_ID field
Death	date	the field is not currently populated; we are hoping to import it from a central repository at some point.
Last_update	date	last time the record was updated by Encounter processing; date that gets set to "now" whenever a new bit of info is found for the corresponding patient

@@ Line 14: / Line 14: @@
 || '''Person_ID''' || text || [[Person_ID field]]
 |-
-|| '''Death''' || date || date of death as per [[where does this come from?]] {{discussion}} date of death as acquired from [[PCH data]] when we get that set up
+|| '''Death''' || date || the field is not currently populated; we are hoping to import it from a central repository at some point.
 |-
 || '''Last_update''' || date || last time the record was updated by [[Encounter processing]]; date that gets set to "now" whenever a new bit of info is found for the corresponding patient