S Cognos Units table

From CCMDB Wiki

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: