L Hospitalization: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m links, cleanup and then some
Line 4: Line 4:


L_Hospitalization is populated as part of [[Encounter processing]].
L_Hospitalization is populated as part of [[Encounter processing]].
==Fields==
* '''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


== Data Structure ==
== Data Structure ==

Revision as of 12:35, 18 September 2017

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 table.

L_Hospitalization is populated as part of Encounter processing.

Data Structure

field type description
Hospitalization_ID Long Integer (AutoNumber) unique ID column, a random number generated by Access when a new line is added
Person_ID Long Integer key against table L_Person table
Hospital_admission date date of admission to hospital
Hospital_discharge date date of discharge from hospital
Disposition date still need to figure out if I need an s_table for this Template:Discussion


Related Articles

Related articles: