L Hospitalization table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) 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: |
|
}}