S Cognos Units table: Difference between revisions
Ttenbergen (talk | contribs) Created page with "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_tran..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_Cognos_Units 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]]. | |||
== Data Structure == | == Data Structure == | ||
| Line 9: | Line 10: | ||
!| description | !| description | ||
|- | |- | ||
|| '''AsgnUnit''' || text || value in [[Cognos EPR Report]] | || '''AsgnUnit''' || text || value in [[Cognos EPR Report]]/[[Cognos data import]] | ||
|- | |||
|| '''BoardingLoc''' || text || value corresponding to [[Boarding Loc]] entry | |||
|- | |||
|| '''Dispo''' || text || value in [[s_dispo table]] (blank if not a unit we follow) | |||
|- | |||
|| '''exclude''' || boolean || true for units we don't include in [[Cognos2 Unit Starter]] | |||
|- | |- | ||
|| ''' | || '''isER''' || boolean || true if the place is an ER; not used any more | ||
|} | |} | ||
| Line 17: | Line 24: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category:Cognos Report Integrator]] | [[Category:Cognos Report Integrator]] | ||