S Cognos Services table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Data Structure) |
Ttenbergen (talk | contribs) m (→Data Structure) |
||
| Line 16: | Line 16: | ||
| hosp || text || 3 || Hospital | | 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]] | | exclude || boolean || || usually "true" since we don't collect most services, but occasionally false; this determines whether the service will show up in [[CSS]] | ||
|} | |} | ||
Revision as of 12:08, 2021 February 12
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 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 |