S Cognos Units table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
The '''S_Cognos_Units''' table in [[CCMDB.accdb]] contains the mapping of unit names in [[Cognos EPR Report]] against those in [[s_dispo table]]. | 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]]. | [[S_Cognos_Units_additions_needed query]] checks for values in [[Cognos EPR Report]] that are not yet in [[S_Cognos_Units table]]. | ||
Line 15: | Line 16: | ||
|| '''Dispo''' || text || value in [[s_dispo table]] | || '''Dispo''' || text || value in [[s_dispo table]] | ||
|- | |- | ||
|| '''exclude''' || boolean || true for units we don't include in [[ | || '''exclude''' || boolean || true for units we don't include in [[Cognos2 Unit Starter]] | ||
|- | |- | ||
|| '''isER''' || boolean || true if the place is an ER; needed to generate the [[Accept_DtTm_Equiv]] | || '''isER''' || boolean || true if the place is an ER; needed to generate the [[Accept_DtTm_Equiv]] |
Revision as of 22:55, 2020 November 25
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 |
BoardingLoc | text | value corresponding to Boarding Loc entry |
Dispo | text | value in s_dispo table |
exclude | boolean | true for units we don't include in Cognos2 Unit Starter |
isER | boolean | true if the place is an ER; needed to generate the Accept_DtTm_Equiv |
Related articles
Related articles: |