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 |
OBJID |
|
HROBJID |
HROBJID |
NUMC |
8 |
0 |
Object ID |
* |
19 |
GUID |
|
GRFN_GUID |
GRFN_GUID |
CHAR |
32 |
0 |
UUID of the GRC object (char32) |
|
20 |
.INCLUDE |
|
|
|
|
0 |
0 |
BW DS extraction for Ad_Hoc Issue attributes |
|
21 |
AI_EXT_REF |
|
GRFN_REP_ADISSUE_EX_REF |
GRFN_REP_TEXT_40 |
CHAR |
40 |
0 |
Ad-Hoc Issue External reference |
|
22 |
AI_PROCESSOR |
|
GRFN_REP_ADISSUE_PROC |
XUBNAME |
CHAR |
12 |
0 |
Ad-Hoc Issue Processor ID |
* |
23 |
AI_RESPONSIBLE |
|
GRFN_REP_ADISSUE_RESP |
XUBNAME |
CHAR |
12 |
0 |
Ad-Hoc Issue Responsible Person ID |
* |
24 |
AI_CATEGORY |
|
GRFN_REP_ADISSUE_CATEGORY |
CHAR4 |
CHAR |
4 |
0 |
AD-Hoc Issue Type ID |
|
25 |
AI_PRIORITY |
|
GRFN_REP_ADISSUE_PRIORITY |
GRFN_ISSUE_PRIORITY |
CHAR |
1 |
0 |
Ad-Hoc Issue Priority ID |
|
26 |
AI_CASE_TYPE |
|
GRFN_REP_ADISSUE_CASE_TYPE |
SCMGCASE_TYPE |
CHAR |
4 |
0 |
Ad-Hoc Issue Case Type |
* |
27 |
AI_STATUS |
|
GRFN_REP_ADISSUE_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Ad-Hoc Issue Status ID |
|
28 |
AI_CLOSED_ON |
|
GRFN_REP_ADISSUE_CLOSED_ON |
|
DATS |
8 |
0 |
Ad-Hoc Issue Closed On (Date) |
|
29 |
AI_VALIDATED_ON |
|
GRFN_REP_ADISSUE_VAL_DATE |
DATUM |
DATS |
8 |
0 |
Ad-Hoc Issue validation date |
|
30 |
AI_VALIDATED_BY |
|
GRFN_REP_ADISSUE_VAL_USER |
GRFN_REP_RESP_USER |
CHAR |
12 |
0 |
Ad-Hoc Issue validation user ID |
|
31 |
AI_WORKFLOW_TYPE |
|
GRFN_REP_ADISSUE_WF_TYPE |
GRPC_ISSUE_WF_TYPE |
CHAR |
1 |
0 |
Ad-Hoc Issue Work Flow Type |
|
32 |
AI_USE_CAPAPLAN |
|
GRFN_REP_ADISSUE_USE_CAPA |
XFELD |
CHAR |
1 |
0 |
Ad-Hoc Issue Use CAPA Plan |
|
33 |
AI_SERIOUS |
|
GRFN_REP_ADISSUE_SERIOUS |
GRFN_ATTRVALUE |
CHAR |
10 |
0 |
Ad-Hoc Issue Serious ID |
|
34 |
AI_IMPACT |
|
GRFN_REP_ADISSUE_IMPACT |
GRPC_ATTRVALUE |
CHAR |
10 |
0 |
Ad-Hoc Issue Impact ID |
|
35 |
AI_ORI_OBJ_ID |
|
GRFN_REP_ADISSUE_ORI_OBJ_ID |
CHAR50 |
CHAR |
50 |
0 |
Ad-Hoc Issue Original Object ID |
|
36 |
AI_ORI_OBY_TYPE |
|
GRFN_REP_ADISSUE_ORI_OBJ_TYP |
GRFN_API_ENTITY_ID |
CHAR |
20 |
0 |
Ad-Hoc Issue Original Entity ID |
* |
37 |
AI_ORI_OBJ_NAME |
|
GRFN_REP_ADISSUE_ORI_OBJ_T |
GRFN_REP_TEXT_100 |
CHAR |
100 |
0 |
Ad-Hoc Issue Original Object Name |
|
38 |
AI_CREATE_ON |
|
GRFN_REP_ADISSUE_CREATED_ON |
|
DATS |
8 |
0 |
Ad-Hoc Issue Created On (Date) |
|
39 |
AI_UPDATE_ON |
|
GRFN_REP_ADISSUE_CHANGED_ON |
|
DATS |
8 |
0 |
Ad-Hoc Issue Changed On (Date) |
|
40 |
AI_UPDATE_ON_TM |
|
GRFN_REP_ADISSUE_CHANGED_ON_TM |
|
TIMS |
6 |
0 |
Ad-Hoc Issue Changed On (Time) |
|
41 |
AI_UPDATE_BY |
|
GRFN_REP_ADISSUE_CHANGED_BY |
XUBNAME |
CHAR |
12 |
0 |
Ad-Hoc Issue Changed By ID |
* |
42 |
AI_REPORT_BY |
|
GRFN_REP_ADISSUE_REPORT_BY |
XUBNAME |
CHAR |
12 |
0 |
Ad-Hoc Issue Report by ID |
* |
43 |
AI_IS_ANONYMOUS |
|
GRFN_REP_ADISSUE_IS_ANO |
BOOLEAN |
CHAR |
1 |
0 |
Ad-Hoc Issue Is Anonymous |
|
44 |
AI_ANO_NAME |
|
GRFN_REP_ADISSUE_ANO_NAME |
GRFN_REP_TEXT_100 |
CHAR |
100 |
0 |
Ad-Hoc Issue Is Anonymous Name |
|
45 |
AI_DUE_DATE |
|
GRFN_REP_ADISSUE_DUE_DATE |
DATUM |
DATS |
8 |
0 |
Ad-Hoc Issue Due Date |
|
46 |
AI_DATE |
|
GRFN_REP_ADISSUE_DATE |
DATUM |
DATS |
8 |
0 |
Ad-Hoc Issue Date |
|
47 |
AI_SOURCE |
|
GRFN_REP_ADISSUE_ISSUE_SOU |
GRFN_REP_TEXT_20 |
CHAR |
20 |
0 |
Ad_Hoc Issue Source ID |
|
48 |
AI_PRIORITY_RA |
|
GRFN_REP_ADISSUE_PRIORITY_RA |
GRFN_ISSUE_PRIORITY |
CHAR |
1 |
0 |
Ad-Hoc Issue Priority ID of Remedial Action |
|
49 |
AI_DURATION |
|
GRFN_REP_ADISSUE_DURATION |
|
INT4 |
10 |
0 |
Duration in Days |
|
50 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|