S dispo table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (21 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_dispo table}}The '''s_dispo''' table in [[CCMDB.accdb]] contains the possible values for the following fields: | ||
* [[Pre-admit Inpatient Institution field]] | * [[Pre-admit Inpatient Institution field]] | ||
* [[Previous Location field]] | * [[Previous Location field]] | ||
* [[Dispo field]] | * [[Dispo field]] | ||
* [[Service/Location field]] - i.e. it contains the [[Site and Location table]] | * [[Service/Location field]] - i.e. it contains the [[Site and Location table]] | ||
{{DJ | | |||
* "Hospice - other, WPG" is currently not grouped as Hospital {{=}} "Other Institution in WPG" as the other hospices - should it be? [[User:Ttenbergen|Ttenbergen]] 17:03, 11 March 2025 (CDT) | |||
}} | |||
== Data Structure == | == Data Structure == | ||
| Line 24: | Line 31: | ||
|| '''ward''' || text || ward name only, e.g. A1 for HSC_A1 | || '''ward''' || text || ward name only, e.g. A1 for HSC_A1 | ||
|- | |- | ||
|| '''hospital''' || text || hospital if one where we collect | || '''[[s_dispo.hospital]]''' || text || hospital if one where we collect | ||
|- | |- | ||
|| '''loc_type''' || text || [[S dispo.loc type]] | || '''[[s_dispo.loc_type]]''' || text || [[S dispo.loc type]] | ||
|- | |- | ||
|| '''geog''' || text || geographical area (in town, out of province, etc) | || '''[[s_dispo.geog]]''' || text(20) || geographical area (in town, out of province, etc) | ||
|- | |- | ||
|| '''[[MB_RHA]]''' || text || regional health authority the institution is | || '''[[s_dispo.geoRegion]]''' || text(17) || geographical region | ||
|- | |||
|| '''[[MB_RHA]]''' || text(7) || regional health authority the institution is administered by | |||
|- | |- | ||
|| '''notes''' || text || general notes about record | || '''notes''' || text || general notes about record | ||
| Line 36: | Line 45: | ||
|| '''question''' || text || questions while we implement, can be deleted after | || '''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 | || '''[[s_dispo.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]] | || '''previous_location''' || yes/no || can be used as [[Previous Location field]] | ||
| Line 52: | Line 61: | ||
|| '''acuity_level''' || 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 | || '''[[s_dispo.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 | ||
|- | |- | ||
|| ''' | || '''[[S_dispo.center]]''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals); also used to combine [[Change of remaining location names from "our" names to EPR/Cognos names | old and new names of locations]] for reporting | ||
|} | |} | ||
| Line 67: | Line 74: | ||
We can occasionally check query [[Query z_s_dispo_lastUsed]] for entries that have not been used in a long time. If it is never used it may be an entry we no longer need, but it may also just be an entry that is rarely used. | We can occasionally check query [[Query z_s_dispo_lastUsed]] for entries that have not been used in a long time. If it is never used it may be an entry we no longer need, but it may also just be an entry that is rarely used. | ||
{{Todo | |||
| who = Tina | |||
| question = _wiki housekeeping | |||
* break this out because it needs to apply to locations in general, wiki side, s_dispo, boarding loc etc. | |||
| todo_added = 2022-02-10 | |||
| todo_action = 2022-02-10 | |||
}} | |||
{{Foreign key | |||
| foreign_key_table=L_Log | |||
| foreign_key_field=Previous Location | |||
| primary_key_table=s_dispo | |||
| primary_key_field=dispo_ID}} | |||
{{Foreign key | |||
| foreign_key_table=L_Log | |||
| foreign_key_field=Pre-admit Inpatient Institution | |||
| primary_key_table=s_dispo | |||
| primary_key_field=dispo_ID}} | |||
<!-- {Foreign key | |||
| foreign_key_table=L_Log | |||
| foreign_key_field=Service/Location | |||
| primary_key_table=s_dispo | |||
| primary_key_field=dispo_ID} --> | |||
{{Foreign key | |||
| foreign_key_table=L_Log | |||
| foreign_key_field=Dispo | |||
| primary_key_table=s_dispo | |||
| primary_key_field=dispo_ID}} | |||
==Log== | |||
* 2022-04-21 - updated [[s_dispo table]].meanLOS3STD with data from Julie | |||
* 2022-03-24 - removed field "service_type" since it's no longer used; as discussed at task around 2022-02-03 | |||
== Related articles == | == Related articles == | ||