L Hospitalization table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 32: Line 32:
[[Category:L Table]]
[[Category:L Table]]
[[Category:Multiple Encounter]]
[[Category:Multiple Encounter]]
}}

Revision as of 15:13, 2023 May 17

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.

Table is empty and not being populated; see Encounter processing for additional info on progress toward ever using hit

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 text we would likely want an s_table for this

Related Articles

Related articles:

}}