L Person table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
m m
Line 3: Line 3:
There can be multiple records in table L_Person for each entry in table [[L_Log]].
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]].
L_Person is populated as part of [[Encounter processing]].


== Data Structure ==
== Data Structure ==

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

Data Structure

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