L Person table
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.
Fields
- Person_ID that uniquely identifies a person (rather than a patient ward admission, as in L_Log).
- 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.
- Death
- date of death as acquired from PCH data when we get that set up
- outstanding, will need to be set up, leaving blank for now Template:Discussion
- date of death as acquired from PCH data when we get that set up
- Last_update
- date that gets set to "now" whenever a new bit of info is found for the corresponding patient