L Person table: Difference between revisions

Revision as of 16:14, 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 as 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 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 a per [[where does this come from?]] {{discussion}} date of death as acquired from [[PCH data]] when we get that set up
+|| '''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
 |-
 || '''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