L Person table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{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= 
'''L_Person''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Multiple Encounter]].
'''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]].
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]].
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 || date of death as per [[where does this come from?]] {{discussion}} date of death as acquired from [[PCH data]] when we get that set up
|| '''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  
Line 23: Line 29:
[[Category: Multiple Encounter]]
[[Category: Multiple Encounter]]
[[Category: L Table]]
[[Category: L Table]]
[[Category:Legacy Data structure]]
}}

Latest revision as of 08:35, 2023 June 6

Legacy Content

This page contains Legacy Content.
  • Explanation: This page describes a currently unsupported process. Part of it might be implemented, but it isn't being used or checked.
  • Successor: xxx

Click Expand to show legacy content.

L_Person is a table in Centralized_data.mdb used to record the concept of Multiple Encounter.

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

{