L Hospitalization table

From CCMDB Wiki
Revision as of 16:53, 5 May 2020 by Ttenbergen (talk | contribs) (Text replacement - "{{DT" to "{{TT")
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.


z

  • implementation was never finalized, and it wasn't tested and isn't used.
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

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: