|
|
| (One intermediate revision by the same user not shown) |
| Line 1: |
Line 1: |
| '''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]].
| | #redirect: [[L Hospitalization table]] |
| | | convenience redirect |
| 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]].
| |
| | |
| == Data Structure ==
| |
| {| class="wikitable sortable"
| |
| |-
| |
| !| 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]] {{discussion}}
| |
| |}
| |
| | |
| | |
| == Related Articles ==
| |
| {{Related Articles}}
| |
| | |
| [[Category: Data structure]]
| |
| [[Category:Multiple Encounter]]
| |