S Cognos Units table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
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 [[Cognos Admitter]]
|| '''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: