S Cognos Units table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Ttenbergen moved page Cognos dispo translator table to S Cognos Locations table without leaving a redirect: Text replacement - "Cognos dispo translator table" to "s_Cognos_Locations table" |
Ttenbergen (talk | contribs) m Text replacement - "Cognos_dispo_translator_additions_needed query" to "s_Cognos_Locations_additions_needed query" |
||
| Line 1: | Line 1: | ||
The '''Cognos_dispo_translator''' table in [[CCMDB.accdb]] contains the mapping of unit names in [[Cognos EPR Report]] against those in [[s_dispo 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]]. | ||
[[ | [[s_Cognos_Locations_additions_needed query]] checks for values in [[Cognos EPR Report]] that are not yet in [[cognos_dispo_translator table]]. | ||
== Data Structure == | == Data Structure == | ||
Revision as of 09:48, 4 November 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. s_Cognos_Locations_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 |