L Person table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m integration |
Ttenbergen (talk | contribs) m link fix |
||
| Line 16: | Line 16: | ||
|| '''Death''' || date || date of death a per [[where does this come from?]] {{discussion}} date of death as acquired from [[PCH data]] when we get that set up | || '''Death''' || date || date of death a per [[where does this come from?]] {{discussion}} date of death as acquired from [[PCH data]] when we get that set up | ||
|- | |- | ||
|| '''Last_update''' || date || last time the record was updated by [[ | || '''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 | ||
|} | |} | ||
Revision as of 12:12, 2017 September 18
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.
Data Structure
| field | type | description |
|---|---|---|
| Person_ID | text | Person_ID field |
| Death | date | date of death a per where does this come from? Template:Discussion date of death as acquired from PCH data when we get that set up |
| 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 |