S Cognos Units table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 19: | Line 19: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category:Cognos Report Integrator]] | [[Category:Cognos Report Integrator]] | ||
Revision as of 11:12, 28 July 2020
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 |