L Hospitalization table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Data Structure) |
Ttenbergen (talk | contribs) m (Text replacement - "{{DT" to "{{TT") |
||
| Line 5: | Line 5: | ||
L_Hospitalization is populated as part of [[Encounter processing]]. | L_Hospitalization is populated as part of [[Encounter processing]]. | ||
{{ | {{TT | z | ||
*implementation was never finalized, and it wasn't tested and isn't used. }} | *implementation was never finalized, and it wasn't tested and isn't used. }} | ||
== Data Structure == | == Data Structure == | ||
| Line 22: | Line 22: | ||
|| '''Hospital_discharge''' || date || date of discharge from hospital | || '''Hospital_discharge''' || date || date of discharge from hospital | ||
|- | |- | ||
|| '''Disposition''' || date || {{ | || '''Disposition''' || date || {{TT | still need to figure out if I need an s_table for this.}} | ||
|} | |} | ||
Revision as of 16:53, 2020 May 5
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
|
|
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 |
|
Related Articles
| Related articles: |
|