Ineffective Controls for CO-Risks

Query Query: 0GPC_MR04_Q0000

This query displays Control Objectives/Risks with information about failed assessments or tests coming from associated PC Controls in a given timeframe. It allows navigation to summary reports which provide more details of failed testings or assessments of the given type.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Subprocess	`0GPC_IS_2___F5`	0P_GPCSP
Characteristic	Process	`0GPC_IS_2___F12`	0P_GPCPR
Characteristic	Control Objective	`0GPC_IS_2___F6`	0P_GPCCO
Characteristic	Risk	`0GPC_IS_2___F7`	0P_GPCRK
Characteristic	Control	`0GPC_IS_2___F8`	<> Not Assigned
Characteristic	Rating	`0GPC_IS_2___F15`	R; Y; G
Characteristic	Organizational Unit	`0GPC_IS_2___F4`	0S_GPCOU
Characteristic	Timeframe	`0GPC_IS_2___F3`	0P_GPCTF

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Organizational Unit	`0GPC_IS_2___F4`
Characteristic	Process	`0GPC_IS_2___F12`
Characteristic	Subprocess	`0GPC_IS_2___F5`
Characteristic	Control Type	`0GPC_IS_2___F9`

Variables
Object Type	Name	Technical Name
Variable	GRC PC Timeframe	`0P_GPCTF`
Variable	GRC PC Timeframe End Date (Exit)	`0P_GPCTE`
Variable	GPC PC Org. Units	`0P_GPCOU`
Variable	GRC PC Process	`0P_GPCPR`
Variable	GRC PC Subprocess	`0S_GPCSP`
Variable	GRC PC Control Objective	`0P_GPCCO`
Variable	GRC PC Risk	`0P_GPCRK`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Control Objective	`0GPC_IS_2___F6`	0P_GPCCO, refers to 0GPC_CO
Characteristic	Risk	`0GPC_IS_2___F7`	0P_GPCRK, refers to 0GPC_RISK

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	# of Controls (CT)	`0GPC_MR04_RKF_001`	—
Key Figure	# of Failed Controls (CT)	`0GPC_MR04_RKF_002`
Key Figure	% Ineffective (CT)	`0GPC_MR04_CKF_001`
Key Figure	# of Controls (CDA)	`0GPC_MR04_RKF_003`
Key Figure	# of Failed Controls (CDA)	`0GPC_MR04_RKF_004`
Key Figure	% Ineffective (CDA)	`0GPC_MR04_CKF_002`
Key Figure	# of Controls (SA)	`0GPC_MR04_RKF_005`
Key Figure	# of Failed Controls (SA)	`0GPC_MR04_RKF_006`
Key Figure	% Ineffective (SA)	`0GPC_MR04_CKF_003`

Report/Report Interfaces
Name	Technical Name
View Failed Testings	`0GPC_MR04_Q0001_T01`
View Failed Design Assessments	`0GPC_MR04_Q0001_T02`
View Failed Self Assessments	`0GPC_MR04_Q0001_T03`