S Cognos Units table
The Cognos_dispo_translator table in CCMDB.accdb contains the mapping of unit names in Cognos EPR Report against those in s_dispo table. Cognos_dispo_translator_additions_needed query checks for values in Cognos EPR Report that are not yet in cognos_dispo_translator table.
Data Structure
field | type | description |
---|---|---|
AsgnUnit | text | value in Cognos EPR Report |
Dispo | text | value in s_dispo table |
isER | boolean | true if the place is an ER; needed to generate the Accept_DtTm_Equiv |
Related articles
Related articles: |