| 1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common part of data source structures |
|
| 2 |
.INCLUDE |
|
|
|
|
0 |
0 |
Details about extraction |
|
| 3 |
SNAPSHOT_ID |
|
GRFN_DM_SNAPSHOT_ID |
SYSUUID_C |
CHAR |
32 |
0 |
Datamart - Snapshot ID |
|
| 4 |
TIMESTAMP |
|
GRFN_TIMESTAMP |
GRFN_TIMESTAMP |
DEC |
15 |
0 |
Time Stamp |
|
| 5 |
DB_TABLE |
|
GRFN_TABNAME |
|
CHAR |
30 |
0 |
Table name |
|
| 6 |
.INCLUDE |
|
|
|
|
0 |
0 |
Timeframe info for extraction |
|
| 7 |
TF_YEAR |
|
GRFN_TF_YEAR |
GRFN_TF_YEAR |
CHAR |
4 |
0 |
Timeframe Year |
|
| 8 |
TIMEFRAME |
|
GRFN_TIMEFRAME |
GRFN_TIMEFRAME |
CHAR |
10 |
0 |
Timeframe |
* |
| 9 |
TF_FREQ |
|
GRFN_TF_FREQUENCY |
GRFN_TF_FREQUENCY |
CHAR |
10 |
0 |
Timeframe Frequency |
* |
| 10 |
DATEFROM |
|
GRFN_DATE_FROM |
GRFN_DATE_FROM |
DATS |
8 |
0 |
Valid from Date |
|
| 11 |
DATETO |
|
GRFN_DATE_TO |
GRFN_DATE_TO |
DATS |
8 |
0 |
Valid to Date |
|
| 12 |
TF_ID |
|
GRFN_BI_TF_ID |
GRFN_BI_TF_ID |
CHAR |
32 |
0 |
Compounded timeframe ID |
|
| 13 |
.INCLUDE |
|
|
|
|
0 |
0 |
Object info for extraction |
|
| 14 |
OBJECT_ID |
|
GRFN_API_OBJECT_ID |
CHAR50 |
CHAR |
50 |
0 |
Object ID |
|
| 15 |
ENTITY_ID |
|
GRFN_API_ENTITY_ID |
GRFN_API_ENTITY_ID |
CHAR |
20 |
0 |
Entity ID |
* |
| 16 |
OBJECT_KEY |
|
GRFN_API_TECHNAME_ID |
GRFN_API_TECHNAME_ID |
CHAR |
50 |
0 |
Object's technical name |
|
| 17 |
SHORT_ENTITY_ID |
|
GRFN_SHORT_ENTITY_ID |
CHAR2 |
CHAR |
2 |
0 |
Shor Entity ID (used in DM) |
|
| 18 |
GUID |
|
GRFN_REP_TESTLOG |
SYSUUID_C |
CHAR |
32 |
0 |
Test Log ID |
|
| 19 |
RE_ID |
|
GRFN_REP_REGULATION |
NUMC08 |
NUMC |
8 |
0 |
Regulation ID |
|
| 20 |
OU_ID |
|
GRFN_REP_ORGUNIT_ID |
NUMC08 |
NUMC |
8 |
0 |
Organization ID |
|
| 21 |
SP_ID |
|
GRFN_REP_SUBPROCESS_ID |
NUMC08 |
NUMC |
8 |
0 |
Subprocess ID |
|
| 22 |
CN_ID |
|
GRFN_REP_CONTROL_ID |
|
CHAR |
9 |
0 |
Control ID |
|
| 23 |
CN_OBJID |
|
HROBJID |
HROBJID |
NUMC |
8 |
0 |
Object ID |
* |
| 24 |
EC_ID |
|
GRFN_REP_ECONTROL |
NUMC08 |
NUMC |
8 |
0 |
Indirect ELC ID |
|
| 25 |
.INCLUDE |
|
|
|
|
0 |
0 |
Test Log Reporting Attributes |
|
| 26 |
TL_EXCEPTION |
|
GRFN_REP_TESTLOG_EXCEPTION |
GRFN_REP_TESTLOG_EXCEPTION |
CHAR |
1 |
0 |
Test Result |
|
| 27 |
TL_TESTER |
|
GRFN_REP_TESTLOG_TESTER |
GRFN_REP_RESP_USER |
CHAR |
12 |
0 |
Test Log Tester |
|
| 28 |
TL_TTECH |
|
GRFN_REP_TESTLOG_TTECH |
GRFN_ATTRVALUE |
CHAR |
10 |
0 |
Test Log Testing Technique |
|
| 29 |
TL_TEST_DATE |
|
GRFN_REP_TESTLOG_TEST_DATE |
DATUM |
DATS |
8 |
0 |
Test Log Test Date |
|
| 30 |
TL_DUE_DATE |
|
GRFN_REP_TESTLOG_DUE_DATE |
DATUM |
DATS |
8 |
0 |
Test Log Due Date |
|
| 31 |
TL_TEST_PLAN |
|
GRFN_REP_TESTLOG_TEST_PLAN |
NUMC08 |
NUMC |
8 |
0 |
Test Log Test Plan |
|
| 32 |
TL_TFRAME |
|
GRFN_REP_TESTLOG_TIMEFRAME |
GRFN_ATTRVALUE |
CHAR |
10 |
0 |
Test Log Timeframe ID |
|
| 33 |
TL_TFRAME_YEAR |
|
GRFN_REP_TESTLOG_TF_YEAR |
|
CHAR |
4 |
0 |
Test Log Time Frame Year |
|
| 34 |
TL_CF_TFRAME |
|
GRFN_REP_TESTLOG_CF_TIMEFRAME |
GRFN_ATTRVALUE |
CHAR |
10 |
0 |
Test Log Timeframe Before Carryforward ID |
|
| 35 |
TL_CF_YEAR |
|
GRFN_REP_TESTLOG_CF_YEAR |
|
CHAR |
4 |
0 |
Test Log Timeframe Before Carryforward (Year) |
|
| 36 |
TL_STATUS |
|
GRFN_REP_TESTLOG_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Test Log Status ID |
|
| 37 |
TL_CF_STATUS |
|
GRFN_REP_TESTLOG_CF_STATUS |
GRFN_REP_CF_STATUS |
CHAR |
1 |
0 |
Test Log Carryforward Status ID |
|
| 38 |
TL_RE |
|
GRFN_REP_TESTLOG_REGULATION_ID |
NUMC08 |
NUMC |
8 |
0 |
Test log regulation ID |
|
| 39 |
TL_CATEGORY |
|
GRFN_REP_TESTLOG_CATEGORY |
CHAR4 |
CHAR |
4 |
0 |
Test log category |
|
| 40 |
TL_RATING |
|
GRPC_REP_TESTLOG_RATING |
GRFN_AS_RATING |
CHAR |
1 |
0 |
Testlog Rating ID |
|
| 41 |
TL_TF_BEGDA |
|
GRFN_REP_TESTLOG_TF_BEGDA |
DATUM |
DATS |
8 |
0 |
Test log time frame begin date |
|
| 42 |
TL_TF_ENDDA |
|
GRFN_REP_TESTLOG_TF_ENDDA |
DATUM |
DATS |
8 |
0 |
Test log time frame end date |
|
| 43 |
TL_TEST_METH |
|
GRFN_REP_TESTLOG_TEST_METHOD |
GRRN_REP_TESTING_METHOD |
CHAR |
1 |
0 |
Test log test method ID |
|
| 44 |
TL_TEST_AUTOM |
|
GRFN_REP_TESTLOG_TEST_AUTOM |
|
CHAR |
10 |
0 |
Test log test automation ID |
|
| 45 |
TL_VAL_DATE |
|
GRFN_REP_TESTLOG_VAL_DATE |
DATUM |
DATS |
8 |
0 |
Test log validation date |
|
| 46 |
TL_VAL_USER |
|
GRFN_REP_TESTLOG_VAL_USER |
GRFN_REP_RESP_USER |
CHAR |
12 |
0 |
Test log validated by ID |
|
| 47 |
TL_EXT_SYSTEM |
|
GRFN_REP_TESTLOG_EXT_SYSTEM |
GRFN_REP_EXT_SYSTEM |
CHAR |
40 |
0 |
Test log external system |
|
| 48 |
TL_EXT_TESTER |
|
GRFN_REP_TESTLOG_EXT_TESTER |
GRFN_REP_EXT_TESTER |
CHAR |
40 |
0 |
Test log external tester |
|
| 49 |
TL_TEST_OWNER |
|
GRFN_REP_TESTLOG_TEST_OWNER |
XUBNAME |
CHAR |
12 |
0 |
Test Owner |
* |
| 50 |
TL_CLOSE_USER |
|
GRFN_REP_TESTLOG_CLOSE_USER |
GRFN_REP_RESP_USER |
CHAR |
12 |
0 |
Test log closed by ID |
|
| 51 |
TL_CLOSE_AT |
|
GRFN_REP_TESTLOG_CLOSE_AT |
|
DATS |
8 |
0 |
Test Log Closed On (Date) |
|
| 52 |
TL_CLOSE_AT_TM |
|
GRFN_REP_TESTLOG_CLOSE_AT_TM |
|
TIMS |
6 |
0 |
Test Log Closed On (Time) |
|
| 53 |
TL_CREATED_ON |
|
GRFN_REP_TESTLOG_CREATED_ON |
|
DATS |
8 |
0 |
Test Log Created On (Date) |
|
| 54 |
TL_CREATED_ON_TM |
|
GRFN_REP_TESTLOG_CREATED_ON_TM |
|
TIMS |
6 |
0 |
Test Log Created On (Time) |
|
| 55 |
TL_CHANGED_ON |
|
GRFN_REP_TESTLOG_CHANGED_ON |
|
DATS |
8 |
0 |
Test Log Changed On (Date) |
|
| 56 |
TL_CHANGED_ON_TM |
|
GRFN_REP_TESTLOG_CHANGED_ON_TM |
|
TIMS |
6 |
0 |
Test Log Changed On (Time) |
|
| 57 |
TL_SCRIPTCATG |
|
GRFN_REP_TESTLOG_SCRIPTCATG |
CHAR30 |
CHAR |
30 |
0 |
Script Category(Obsolete) |
|
| 58 |
TL_SCRIPTTYPE |
|
GRFN_REP_TESTLOG_SCRIPTTYPE |
CHAR20 |
CHAR |
20 |
0 |
Script Type(Obsolete) |
|
| 59 |
TL_DEFICIENCY |
|
GRFN_REP_TESTLOG_DEFICIENCY |
GRPC_DEFTYPE |
CHAR |
5 |
0 |
Overall Deficiency Rating(Obsolete) |
* |
| 60 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
| 61 |
TL_EVALTYP |
|
GRFN_BI_EVALUATION_TYPE |
GRFN_BI_EVALUATION_TYPE |
CHAR |
4 |
0 |
Evaluation Type |
|
| 62 |
ASSIGNED_ISSUES |
|
GRFN_REP_ISSUES |
|
INT4 |
10 |
0 |
Issues |
|
| 63 |
ASSIGNED_PLANS |
|
GRFN_REP_PLANS |
|
INT4 |
10 |
0 |
Number of Remediation Plans |
|
| 64 |
ASSIGNED_CPPLANS |
|
GRFN_REP_PLANS |
|
INT4 |
10 |
0 |
Number of Remediation Plans |
|