Show TOC

Testing Locate this document in the navigation structure

 

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

This search and analytics model is used to get the testing data.

Technical Data

Model Usage

Application Model

Software Component for Search and Analytics

GRCFND_A

Root Node: GRC PC Testing (Testlog) Attributes

Technical Name

0GPC_TL_ATTR

DataSource

0GPC_TL_ATTR

Operational Data Provider: GRC PC Testing (Testlog) Attributes

Technical Name

0GPC_TL

ODP-Semantics

Master Data Attributes

View

Data Extraction

Direct Access Enabled

Yes

Operational Data Provider: GRC PC Testing (Testlog) Texts

Technical Name

0GPC_TL

ODP-Semantics

Texts

View

Data Extraction

Direct Access Enabled

Yes

Node Relationship: GRC PC Testing (Testlog) Texts

Node

0GPC_TL_TEXT

Association

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

GUID

GUID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Test Result Texts

Node

0GPC_TLEXCE.0GPC_TL_EXCEPTION_T

Association

TESTLOG: TEST RESULT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_EXCEPTION

ATTR

Equal

Node Relationship: GRC PC Evaluation Type Texts

Node

0GPC_EVLTYP.0GPC_EVLTYP_TEXT

Association

TESTLOG: EVA TYPE TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_EVALTYP

ATTR

Equal

Node Relationship: GRC Rating Texts

Node

0GFN_RATING_TEXT.0GFN_RATING_TEXT

Association

TESTLOG: RATING

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_RATING

ATTR

Equal

Node Relationship: GRC Status Texts

Node

0GFN_STATUS_TEXT.0GFN_STATUS_TEXT

Association

TESTLOG: STATUS

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_STATUS

ATTR

Equal

Node Relationship: GRC Timeframe

Node

0GFN_TF.0GFN_TF_ATTR

Association

0GPC_TL_ATTR20GFN_TF_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC Timeframe Year Frequency

Node

0GFN_TF_FREQ.0GFN_TF_FREQ

Association

0GPC_TL_ATTR20GFN_TF_FREQ

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_FREQ

TF_FREQ

Equal

Node Relationship: GRC Timeframe Year

Node

0GFN_TF_YEAR.0GFN_TF_YEAR

Association

0GPC_TL_ATTR20GFN_TF_YEAR

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

Node Relationship: GRC PC Regulation

Node

0GPC_RE.0GPC_RE

Association

TESTLOG: REGULATION ATTRIBUTE

Cardinality

Arbitrary

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

TL_RE

OBJID

Equal

Node Relationship: GRC Organizations Attributes

Node

0GFN_OU.0GFN_OU_ATTR

Association

0GPC_TL_ATTR20GFN_OU_ATTR_1

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_TL_ATTR20GPC_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_TL_ATTR20GPC_CN_ATTR_1

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 Indirect Entity-Level Control Attributes

Node

0GPC_EC.0GPC_EC_ATTR

Association

0GPC_TL_ATTR20GPC_EC_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

EC_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC User Texts

Node

0GFN_USER_TEXT.0GFN_USER_TEXT

Association

TESTLOG: TESTER

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_TESTER

ATTR

Equal

Node Relationship: GRC User Texts

Node

0GFN_USER_TEXT.0GFN_USER_TEXT

Association

TESTLOG: TEST OWNER

Cardinality

Up to One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_TEST_OWNER

ATTR

Equal

Node Relationship: GRC User Texts

Node

0GFN_USER_TEXT.0GFN_USER_TEXT

Association

TESTLOG: TEST REVIEWER

Cardinality

Up to One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_VAL_USER

ATTR

Equal

Node Relationship: GRC PC Testing Category Texts

Node

0GPC_TLCATE.0GPC_TL_CATEGORY_T

Association

TESTLOG: CATEGORY TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_CATEGORY

ATTR

Equal

Node Relationship: GRC User Texts

Node

0GFN_USER_TEXT.0GFN_USER_TEXT

Association

TESTLOG: CLOSED BY

Cardinality

Up to One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_VAL_USER

ATTR

Equal

Node Relationship: GRC PC Testing (Testlog) Test Automation Texts

Node

0GPC_TLTSTA.0GPC_TL_TEST_AUTOM_T

Association

TESTLOG: TEST AUTOMATION

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_TEST_AUTOM

ATTR

Equal

Node Relationship: GRC PC Testing (Testlog) Test Method Texts

Node

0GPC_TLTSTM.0GPC_TL_TEST_METH_T

Association

TESTLOG: TEST METHOD

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_TEST_METH

ATTR

Equal

Node Relationship: GRC PC Testing (Testlog) Test Method Texts

Node

0GPC_TLTSTM.0GPC_TL_TEST_METH_T

Association

TESTLOG: TEST METHOD

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_TEST_METH

ATTR

Equal

Node Relationship: GRC PC Test Plan Attributes

Node

0GPC_TP.0GPC_TP_ATTR

Association

TESTLOG: TEST PLAN ATTRIBUTE

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

TL_TEST_PLAN

OBJID

Equal

Node Relationship: GRC PC Control Testing Technique Texts

Node

0GPC_CNTTEC.0GPC_CN_TTECH_TEXT

Association

TESTLOG: TEST TECHNIQUE

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TL_TTECH

ATTR

Equal

Node Relationship: GRC PC Issue Attributes

Node

0GPC_IS.0GPC_IS_ATTR

Association

0GPC_IS_ATTR20GPC_TL_ATTR_1

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

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

GUID

TL_ID

Equal