L Hospitalization table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (removed task, there is no task here.)
mNo edit summary
Line 1: Line 1:
<onlyinclude>'''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]].</onlyinclude>
{{DISPLAYTITLE:L_Hospitalization table}}<onlyinclude>'''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]].</onlyinclude>


There can be multiple records in table L_Hospitalization for each entry in table [[L_Person table]].
There can be multiple records in table L_Hospitalization for each entry in table [[L_Person table]].

Revision as of 15:08, 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: