S Cognos Units table: Difference between revisions

Latest revision as of 15:20, 17 May 2023

The s_Cognos_Units table in CCMDB.accdb contains the mapping of unit names in Cognos EPR Report against those in s_dispo table.

field	type	description
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

Revision as of 12:10, 12 February 2021 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,577 edits m →Data Structure ← Older edit		Latest revision as of 15:20, 17 May 2023 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,577 edits 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]].		{{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]].		[[S_Cognos_Units_additions_needed query]] checks for values in [[Cognos EPR Report]] that are not yet in [[S_Cognos_Units table]].