S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 53: Line 53:
|| '''acuity_level''' || yes/no || logical delete from dropdowns
|| '''acuity_level''' || yes/no || logical delete from dropdowns
|-
|-
|| '''program''' || text || CC or Med for our locations only  
|| '''program''' || text || CC or Med, used for rows where '''real_name''' is one of our locations only  
|-
|-
|| '''colour''' || text || colour code for patient list view  
|| '''colour''' || text || colour code for patient list view  

Revision as of 15:27, 2017 November 15

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
real_collection text unit name as collected by us, e.g. HSC_MICU vs HSC_MICa
real_name text unit name as reported, e.g. STB_ICMU vs STB_MICU
site text our short hospital name, eg HSC
ward text ward name only, e.g. A1 for HSC_A1
hospital text hospital if one where we collect
loc_type text S dispo.loc type
geog text geographical area (in town, out of province, etc)
MB_RHA text regional health authority the institution is part of
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 location where actual surgeries happpen (used by e.g. Check ORDx) (ie not just a surgical ward)
meanLOS3STD integer used by LOS check
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
acuity_level yes/no logical delete from dropdowns
program text CC or Med, used for rows where real_name is one of our locations only
colour text colour code for patient list view
service_type text S dispo.service type
center long integer chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals)

"temporary" field vs "inpatient" field

Template:Discussion can't remember how this is used, and a quick look VBA and queries in ccmdb.mdb didn't tell me either. Does anyone remember what exactly this is and how it is different from the inpatient field? Ttenbergen 17:29, 2017 November 6 (CST) I just had this hunch that that was a concept we used to use, but gave up on a while ago. Does anyone remember about this? Ttenbergen 18:47, 2017 November 8 (CST)