S Cognos Services table

From CCMDB Wiki
Jump to navigationJump 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

Related articles

Related articles: