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
• Last_update
  • date that gets set to "now" whenever a new bit of info is found for the corresponding patient