L Hospitalization table

From CCMDB Wiki
Revision as of 15:58, 13 April 2022 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

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 date

still need to figure out if I need an s_table for this.

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Related Articles

Related articles: