S Cognos Services table
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 |