L Hospitalization

Revision as of 10:43, 1 April 2015 by Ttenbergen (talk | contribs) (cat)

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.

L_Hospitalization is populated as part of Encounter processing.

Fields

  • Hospitalization_ID - unique ID column
    • a random number generated by Access when a new line is added
  • Person_ID - key against table L_Person
  • 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