L Person table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
No edit summary
Line 19: Line 19:
|}
|}


[[Category: L_Person table]]
[[Category: Data structure]]
[[Category: Data structure]]
[[Category:Multiple Encounter]]
[[Category: Multiple Encounter]]
[[Category:L Table]]
[[Category: L Table]]

Revision as of 17:04, 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.

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