L Hospitalization: Difference between revisions

m still clean-up
m Redirected page to L Hospitalization table
Tag: New redirect
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]].
#redirect: [[L Hospitalization table]]
 
convenience redirect
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
 
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]].
 
[[Category: Data structure]]