L Hospitalization table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (removed task, there is no task here.) |
||
| Line 22: | Line 22: | ||
|| '''Hospital_discharge''' || date || date of discharge from hospital | || '''Hospital_discharge''' || date || date of discharge from hospital | ||
|- | |- | ||
|| '''Disposition''' || | || '''Disposition''' || text || we would likely want an s_table for this | ||
|} | |} | ||
| Line 28: | Line 28: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: L_Hospitalization table| *]] | [[Category:L_Hospitalization table| *]] | ||
[[Category: L Table]] | [[Category:L Table]] | ||
[[Category:Multiple Encounter]] | [[Category:Multiple Encounter]] | ||
Revision as of 14:44, 2022 August 10
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: |
|