L Person table: Difference between revisions

No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'''L_Person''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Multiple Encounter]].
{{DISPLAYTITLE:L_Person table}}
{{LegacyContent
| explanation=This page describes a currently unsupported process. Part of it might be implemented, but it isn't being used or checked.
| successor=xxx
| content= 


There can be multiple records in table L_Person for each entry in table [[L_Log]].
'''L_Person''' is a table in [[Centralized_data.accdb]] used to record the concept of [[Multiple Encounter]].


L_Person is populated as part of [[Encounter processing]].
There can be multiple records in [[L_Log table]] for each entry in the L_Person table.
 
L_Person is populated as part of [[Encounter processing]].  


== Data Structure ==
== Data Structure ==
Line 14: Line 20:
|| '''Person_ID''' || text || [[Person_ID field]]
|| '''Person_ID''' || text || [[Person_ID field]]
|-
|-
|| '''Death''' || date || the field is not currently populated; we are hoping to import it from a central repository at some point.
|| '''Death''' || date || we are hoping to import it from a central repository at some point; it could also be populated partly by storing the [[dispo DtTm]] of the first time a patient has [[Dispo]] = dead; don't think that's implemented right now either.  
|-
|-
|| '''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  
|| '''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  
|}
|}


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