L Hospitalization: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m still clean-up |
Ttenbergen (talk | contribs) m clean-up |
||
| Line 1: | Line 1: | ||
'''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]]. | '''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]]. | ||
Fields | There can be multiple records in table L_Hospitalization for each entry in table L_Person. | ||
L_Hospitalization is populated as part of [[Encounter processing]]. | |||
==Fields== | |||
* '''Hospitalization_ID''' - unique ID column | * '''Hospitalization_ID''' - unique ID column | ||
** a random number generated by Access when a new line is added | ** a random number generated by Access when a new line is added | ||
| Line 9: | Line 13: | ||
* '''Disposition''' - [[still need to figure out if I need an s_table for this | * '''Disposition''' - [[still need to figure out if I need an s_table for this | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
Revision as of 11:21, 22 January 2015
L_Hospitalization is a table in Centralized_data.mdb used to record the concept of Continuous Stay.
There can be multiple records in table L_Hospitalization for each entry in table L_Person.
L_Hospitalization is populated as part of Encounter processing.
Fields
- Hospitalization_ID - unique ID column
- a random number generated by Access when a new line is added
- Person_ID - key against table L_Person
- Hospital_admission - date of admission to hospital
- Hospital_discharge - date of discharge from hospital
- Disposition - [[still need to figure out if I need an s_table for this