L Person table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Ttenbergen moved page L Person to L Person table without leaving a redirect: consistency
mNo edit summary
 
(9 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_Hospitalization is populated as part of [[Encounter processing]].
L_Person is populated as part of [[Encounter processing]].  


==Fields==  
== Data Structure ==
* '''Person_ID''' that uniquely identifies a person (rather than a patient ward admission, as in L_Log).
{| class="wikitable sortable"
** 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.  
!| field
* Death
!| type
** date of death as acquired from [[PCH data]] when we get that set up
!| description
*** outstanding, will need to be set up, leaving blank for now {{discussion}}
|-
* Last_update
|| '''Person_ID''' || text || [[Person_ID field]]
** date that gets set to "now" whenever a new bit of info is found for the corresponding patient
|-
|| '''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  
|}


[[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]]
}}

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

{

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Person_table&oldid=159571"