S dispo table
The S_dispo table in CCMDB.accdb contains the possible values for the following fields:
- Pre-admit Inpatient Institution field
- Previous Location field
- Dispo field
- Service/Location field - i.e. it contains the Site and Location table
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; this is used to link the Previous Location/Dispo to Service/Location |
| 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 |
| 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) |
Inactivating locations
Before inactivating a location, make sure that it is not used in any incomplete profiles. Run the following query in CFE. It will ask for two parameters, the name of the location and the latest time at which the location would have been available.
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Dispo_DtTm, preAdm.location_name AS preAdm, previous.location_name AS Prev, SL.location_name AS SL, dispo.location_name AS dispo
FROM (((L_Log INNER JOIN s_dispo AS preAdm ON L_Log.Pre_admit_Inpatient_Institution = preAdm.dispo_ID) INNER JOIN s_dispo AS previous ON L_Log.Previous_Location = previous.dispo_ID) INNER JOIN s_dispo AS SL ON L_Log.Service_Location = SL.dispo_ID) INNER JOIN s_dispo AS dispo ON L_Log.Dispo = dispo.dispo_ID
WHERE (((L_Log.RecordStatus)="incomplete") AND ((preAdm.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((previous.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((SL.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((dispo.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((preAdm.location_name) Is Null)) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((previous.location_name) Is Null)) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((SL.location_name) Is Null)) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((dispo.location_name) Is Null));