s_Cognos_Units table
Jump to navigation
Jump to search
The s_Cognos_Units table in CCMDB.accdb contains the mapping of unit names in Cognos EPR Report against those in s_dispo table.
S_Cognos_Units_additions_needed query checks for values in Cognos EPR Report that are not yet in S_Cognos_Units table.
Data Structure
field | type | description |
---|---|---|
AsgnUnit | text | value in Cognos EPR Report/Cognos data import |
BoardingLoc | text | value corresponding to Boarding Loc entry |
Dispo | text | value in s_dispo table (blank if not a unit we follow) |
exclude | boolean | true for units we don't include in Cognos2 Unit Starter |
isER | boolean | true if the place is an ER; not used any more |
Related articles
Related articles: |