S Cognos Services table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→Data Structure) |
||
| Line 4: | Line 4: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Field Name !! Data Type !! Length !! | ! Field Name !! Data Type !! Length !! Meaning | ||
|- | |- | ||
| Service || String|| 255 | | Service || String|| 255 || Name as from [[Cognos data import]] | ||
|- | |- | ||
| sorter || Number|| long | | 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 | | MISI|| text|| 4 || data to help break services into what locations they correspond to | ||
|- | |- | ||
| program || text || 3 | | program || text || 3 || CC (Critical Care) or Med (Medicine); sometimes blank if it's neither | ||
|- | |- | ||
| hosp || text || 3 | | hosp || text || 3 || Hospital | ||
|- | |- | ||
| exclude || boolean || | | 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 |