(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.
Model Usage | Application Model |
Software Component for Search and Analytics | GRCFND_A |
Technical Name | 0GPC_SP_RS_CN_ALL |
DataSource | 0GPC_SP_RS_CN_ALL |
Technical Name | 0GPC_RSCN |
ODP-Semantics | Master Data Attributes |
View | Data Extraction |
Direct Access Enabled | Yes |
Node | 0GFN_OU.0GFN_OU_ATTR |
Association | 0GPC_SP_RS_CN_ALL20GFN_OU_ATTR |
Cardinality | Exactly One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
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 | 0GPC_SP.0GPC_SP_ATTR |
Association | 0GPC_SP_RS_CN_ALL20GPC_SP_ATTR |
Cardinality | Exactly One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
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 | 0GPC_CN.0GPC_CN_ATTR |
Association | 0GPC_SP_RS_CN_ALL20GPC_CN_ATTR |
Cardinality | Exactly One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
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 | 0GPC_COBJ.0GPC_COBJ_ATTR |
Association | 0GPC_SP_RS_CN_ALL20GPC_COBJ_ATTR |
Cardinality | Exactly One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
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 | 0GPC_ASS.0GPC_ASS_TEXT |
Association | 0GPC_SP_RS_CN_ALL20GPC_ASS_TEXT |
Cardinality | Arbitrary |
Reverse Cardinality | Arbitrary |
Sub-query | No |
Attribute of Parent Node | Value | Attribute of Child Node | Value | Join-Operator |
ASS_ID | ATTR | Equal |
Node | 0GPC_AG.0GPC_AG_ATTR |
Association | 0GPC_SP_RS_CN_ALL20GPC_AG_ATTR |
Cardinality | Exactly One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
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 | 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 |
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 | 0GFN_ENTTYP.0GFN_ENTTYP_TEXT |
Association | 0GPC_SP_RS_CN_ALL20GFN_ENTTYP_TE |
Cardinality | Arbitrary |
Reverse Cardinality | Arbitrary |
Sub-query | No |
Attribute of Parent Node | Value | Attribute of Child Node | Value | Join-Operator |
SOURCE_TYPE | ATTR | Equal |
Node | 0GFN_RS.0GFN_RS_ATTR |
Association | 0GFN_RS_ATTR20GPC_SP_RS_CN_ALL |
Cardinality | Exactly One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
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 |