s_Cognos_Services table
Jump to navigation
Jump to search
S Cognos Services table is an administrative-only table in CCMDB.mdb. It contains the values used to make sense of the services data in Cognos EPR Report.
Data Structure
| Field Name | Data Type | Length | Meaning |
|---|---|---|---|
| Service | String | 255 | Name as from Cognos EPR Report/Cognos data import |
| sorter | Number | long | sort order of collector dropdown; "common" units should be near the top and rare ones at the bottom, but generally the list is alphabetical, so use something sensible in discussion with local collector |
| MISI | text | 4 | data to help break services into what locations they correspond to |
| program | text | 3 | CC (Critical Care) or Med (Medicine); sometimes blank if it's neither |
| hosp | text | 3 | Hospital |
| exclude | boolean | usually "true" since we don't collect most services, but occasionally false; this determines whether the service will show up in CSS |
Exceptional entries
Almost all the data in this table is added as it first appears on Cognos EPR Report. There are some exceptions where we added records to facilitate dealing with manual entries we make in Service tmp entry:
- HSC Critical Care – MICU
- HSC Critical Care – SICU