S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m link fix
m clean up
Line 3: Line 3:
* [[Previous Location field]]
* [[Previous Location field]]
* [[Dispo field]]
* [[Dispo field]]
[[PrevInptLocation field]].


== Data Structure ==
== Data Structure ==
Line 20: Line 18:
|-
|-
|| '''loc_type''' || text || see [[#location types]]   
|| '''loc_type''' || text || see [[#location types]]   
|-
|| '''inpatient''' || yes/no || is an inpatient location, used by [[Pre-admit Inpatient Institution field]] drop-down and cross checks
|-
|| '''temporary''' || yes/no || is a temporary location, used by [[Pre-admit Inpatient Institution field]] cross checks
|-
|| '''old_hospital_code''' || number || old code as in [[S_HospitalCodes]]
|-
|-
|| '''geog''' || text || geographical area (in town, out of province, etc)  
|| '''geog''' || text || geographical area (in town, out of province, etc)  
Line 31: Line 23:
|| '''notes''' || text || general notes about record  
|| '''notes''' || text || general notes about record  
|-
|-
|| '''active''' || yes/no || logical delete
|| '''question''' || text || questions while we implement, can be deleted after
|-
|| '''inpatient''' || yes/no || is an inpatient location, used by [[Pre-admit Inpatient Institution field]] drop-down and cross checks
|-
|-
|| '''question''' || text || temporary field for questions during implementation
|| '''temporary''' || yes/no || is a temporary location, used by [[Pre-admit Inpatient Institution field]] cross checks
|-
|-
|| '''admit_from''' || yes/no || can be used as [[admit from]]  
|| '''previous_location''' || yes/no || can be used as [[Previous Location field]]  
|-
|-
|| '''discharge_to''' || yes/no || can be used as [[discharge to]]  
|| '''surgical''' || yes/no || is a surgical location (used by e.g. [[Check ORDx]])
|-
|-
|| '''s_location''' || yes/no || can be used as [[location]]  
|| '''s_location''' || yes/no || can be used as [[location]]  
|-
|-
|| '''surgical''' || yes/no || is a surgical location (used by e.g. [[Check ORDx]])
|| '''dispo''' || yes/no || can be used in [[Dispo field]]
|-
|-
|| '''boarding''' || yes/no || related to [[:Category:Overflow]] but not really clear how this is to be used, needs review {{discussion}}
|| '''active''' || yes/no || logical delete from dropdowns
|}
|}


Some additional legacy fields are stored in the [[s_dispo_legacy_codes table]].
Some additional legacy and reporting fields are stored in the [[s_dispo_legacy_codes table]].
 
== location types ==
For easier sorting. Options are:
*ambulatory care
*ER
*hospice
*ICU
*non-patient
*Nursing Station
*operating
*PCH
*recovery
*unknown/other
*Ward


[[Category: Data structure]]
[[Category: Data structure]]
[[Category: 2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]

Revision as of 09:48, 2016 March 22

The S_dispo table in CCMDB.mdb contains the possible values for the following fields:

Data Structure

field type description
dispo_ID text unique ID
location_name text name as seen by collector
hospital text hospital if one where we collect
loc_type text see #location types
geog text geographical area (in town, out of province, etc)
notes text general notes about record
question text questions while we implement, can be deleted after
inpatient yes/no is an inpatient location, used by Pre-admit Inpatient Institution field drop-down and cross checks
temporary yes/no is a temporary location, used by Pre-admit Inpatient Institution field cross checks
previous_location yes/no can be used as Previous Location field
surgical yes/no is a surgical location (used by e.g. Check ORDx)
s_location yes/no can be used as location
dispo yes/no can be used in Dispo field
active yes/no logical delete from dropdowns

Some additional legacy and reporting fields are stored in the s_dispo_legacy_codes table.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_dispo_table&oldid=47159"