Show TOC

Control Risk Coverage Locate this document in the navigation structure

 

Search and Analytics Model (Search and Analytics Model) Search and Analytics Model: 0GPC_RSCN

This search and analytics model is used to get the PC control risk coverage data.

Technical Data

Model Usage

Application Model

Software Component for Search and Analytics

GRCFND_A

Root Node: GRC PC Risk Coverage from all sources

Technical Name

0GPC_SP_RS_CN_ALL

DataSource

0GPC_SP_RS_CN_ALL

Operational Data Provider: GRC PC Risk Coverage from all sources

Technical Name

0GPC_RSCN

ODP-Semantics

Master Data Attributes

View

Data Extraction

Direct Access Enabled

Yes

Node Relationship: GRC Organizations Attributes

Node

0GFN_OU.0GFN_OU_ATTR

Association

0GPC_SP_RS_CN_ALL20GFN_OU_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

OU_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Subprocess Attributes

Node

0GPC_SP.0GPC_SP_ATTR

Association

0GPC_SP_RS_CN_ALL20GPC_SP_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

SP_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Control Attributes

Node

0GPC_CN.0GPC_CN_ATTR

Association

0GPC_SP_RS_CN_ALL20GPC_CN_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ID

CN_ID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Control Objective Attributes

Node

0GPC_COBJ.0GPC_COBJ_ATTR

Association

0GPC_SP_RS_CN_ALL20GPC_COBJ_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CO_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC FS Assertion Texts

Node

0GPC_ASS.0GPC_ASS_TEXT

Association

0GPC_SP_RS_CN_ALL20GPC_ASS_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

ASS_ID

ATTR

Equal

Node Relationship: GRC PC FS Account Group Attributes

Node

0GPC_AG.0GPC_AG_ATTR

Association

0GPC_SP_RS_CN_ALL20GPC_AG_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

AG_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Subprocess Attributes

Node

0GPC_SPSRC.0GPC_SP_RS_SOURCE_AT

Association

0GPC_SP_RS_CN_ALL20GPC_SP_RS_SOU

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

SOURCE_SP_ID

OBJID

Equal

TF_FREQ

TF_FREQ

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC Entity Type Texts

Node

0GFN_ENTTYP.0GFN_ENTTYP_TEXT

Association

0GPC_SP_RS_CN_ALL20GFN_ENTTYP_TE

Cardinality

Arbitrary

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

SOURCE_TYPE

ATTR

Equal

Node Relationship: GRC Risk Attributes

Node

0GFN_RS.0GFN_RS_ATTR

Association

0GFN_RS_ATTR20GPC_SP_RS_CN_ALL

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

RS_ID

RS_ID

Equal