L Hospitalization table: Difference between revisions

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Hospitalization_table"

@@ Line 1: / Line 1: @@
-<onlyinclude>'''L_Hospitalization''' was meant to group together several ward admissions that constitute one hospitalization.</onlyinclude>
+{{DISPLAYTITLE:L_Hospitalization table}}
+{{LegacyContent
+| explanation=This page describes a currently unsupported process. Part of it might be implemented, but it isn't being used or checked.
+| successor=xxx
+| content=
+<onlyinclude>'''L_Hospitalization''' is a table in [[Centralized_data.mdb]] used to record the concept of [[Continuous Stay]].</onlyinclude>
-{{discussion}} I don't think implementation was ever finalized, and it wasn't tested and isn't used.
+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 ==
-{{discussion}}}
+{| class="wikitable sortable"
-Can be entered if we ever start using it.
+|-
+!| 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}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: L_Hospitalization table|*]]
+[[Category:L_Hospitalization table| *]]
-[[Category: L Table]]
+[[Category:L Table]]
+[[Category:Multiple Encounter]]
+[[Category:Legacy Data structure]]
+}}