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 |
RS_ID |
|
GRFN_REP_RISK_ID |
CHAR9 |
CHAR |
9 |
0 |
Risk ID |
|
19 |
OU_ID |
|
GRFN_REP_ORGUNIT_ID |
NUMC08 |
NUMC |
8 |
0 |
Organization ID |
|
20 |
AC_ID |
|
GRFN_REP_ACTIVITY_C9 |
|
CHAR |
9 |
0 |
Activity ID |
|
21 |
OB_ID |
|
GRFN_REP_OBJECTIVE |
|
NUMC |
8 |
0 |
Objective Id |
|
22 |
AL_ID |
|
GRFN_REP_ANALYSIS_ID |
|
CHAR |
32 |
0 |
Analysis ID |
|
23 |
RG_ID |
|
GRFN_REP_CRISKGROUP |
|
NUMC |
8 |
0 |
Risk Category Group ID |
|
24 |
.INCLUDE |
|
|
|
|
0 |
0 |
Risk Entity Attribute |
|
25 |
RS_VALID_FROM |
|
GRFN_REP_RISK_VALID_FROM |
DATUM |
DATS |
8 |
0 |
Risk Valid From |
|
26 |
RS_VALID_TO |
|
GRFN_REP_RISK_VALID_TO |
DATUM |
DATS |
8 |
0 |
Risk Valid To |
|
27 |
RS_RESP_USER |
|
GRFN_REP_RISK_RESP_USER |
XUBNAME |
CHAR |
12 |
0 |
Risk Owner ID |
* |
28 |
RS_STATUS |
|
GRFN_REP_RISK_STATUS |
J_ISTAT |
CHAR |
5 |
0 |
Risk Status ID |
* |
29 |
RS_RSA_PRL |
|
GRFN_REP_RISK_PROB_LEVEL |
GRFN_REP_RISK_PROB_LEVEL |
NUMC |
3 |
0 |
Probability ID |
|
30 |
RS_RSA_IML |
|
GRFN_REP_RISK_IMPACT_LEVEL |
GRFN_IMPACT_LEVEL |
NUMC |
2 |
0 |
Impact Level ID |
* |
31 |
RS_RSA_RSL |
|
GRFN_REP_RISK_RISK_LEVEL |
GRFN_REP_RISK_RISK_LEVEL |
CHAR |
4 |
0 |
Risk Level ID |
|
32 |
RS_PAR_OBJTYPE |
|
GRFN_REP_PARENT_OBJTYPE |
GRFN_OBJTYPE |
CHAR |
10 |
0 |
Parent Objtype |
|
33 |
RS_PARENT |
|
GRFN_REP_RISK_PARENT |
|
NUMC |
8 |
0 |
Risk Parent ID |
|
34 |
RS_CENTRAL |
|
GRFN_REP_RISK_REFCRISK |
|
NUMC |
8 |
0 |
Crisk ID |
|
35 |
RS_CONTROL_ID |
|
GRFN_REP_CONTROL_ID |
|
CHAR |
9 |
0 |
Control ID |
|
36 |
RS_RISK_TYPE |
|
GRFN_REP_RISK_TYPE |
GRRM_RISK_TYPE |
CHAR |
10 |
0 |
Risk type ID |
|
37 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
38 |
.INCLUDE |
|
|
|
|
0 |
0 |
domain specific attributes of analysis for reporting |
|
39 |
AL_CREATED_BY |
|
GRFN_REP_ANALYSIS_CREATE_USER |
XUBNAME |
CHAR |
12 |
0 |
Analysis Created By |
* |
40 |
AL_CREATE_TIME |
|
GRFN_REP_ANALYSIS_CREATE_TIME |
SCMG_TIMESTAMP |
DEC |
15 |
0 |
Analysis Created On |
|
41 |
AL_CHANGED_BY |
|
GRFN_REP_ANALYSIS_CHANGE_USER |
XUBNAME |
CHAR |
12 |
0 |
Analysis Last Changed By |
* |
42 |
AL_CHANGE_TIME |
|
GRFN_REP_ANALYSIS_CHANGE_TIME |
SCMG_TIMESTAMP |
DEC |
15 |
0 |
Analysis Last Changed On |
|
43 |
AL_RESP_USER |
|
GRFN_REP_ANALYSIS_PERS_RESP |
XUBNAME |
CHAR |
12 |
0 |
Analysis Owner |
* |
44 |
AL_STATUS |
|
GRFN_REP_ANALYSIS_STATUS |
GRRM_ANALYSIS_STATUS |
NUMC |
2 |
0 |
Analysis Status |
|
45 |
AL_CURRENCY |
|
GRFN_REP_ANALYSIS_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
46 |
AL_VALID_FROM |
|
GRFN_REP_ANALYSIS_VALID_FROM |
|
DATS |
8 |
0 |
Analysis Date |
|
47 |
AL_VALID_TO |
|
GRFN_REP_ANALYSIS_VALID_TO |
|
DATS |
8 |
0 |
Analysis End Date |
|
48 |
AL_PROFILE_ID |
|
GRFN_REP_ANALYSIS_PROFILE_ID |
|
CHAR |
10 |
0 |
Cause & Consequence Id |
|
49 |
AL_INH_PRB |
|
GRFN_REP_ANALYSIS_INH_PRB |
|
DEC |
6 |
4 |
Inherent Probability |
|
50 |
AL_INH_EXL |
|
GRFN_REP_ANALYSIS_INH_EXL |
|
CURR |
15 |
2 |
Inherent Expected Loss |
|
51 |
AL_INH_PRL |
|
GRFN_REP_ANALYSIS_INH_PRL |
|
NUMC |
3 |
0 |
Inherent Probability Level |
|
52 |
AL_INH_IMN |
|
GRFN_REP_ANALYSIS_INH_IMN |
|
CURR |
15 |
2 |
Inherent Impact (Best Case) |
|
53 |
AL_INH_IAV |
|
GRFN_REP_ANALYSIS_INH_IAV |
|
CURR |
15 |
2 |
Inherent Impact (Average Case) |
|
54 |
AL_INH_IMX |
|
GRFN_REP_ANALYSIS_INH_IMX |
|
CURR |
15 |
2 |
Inherent Impact (Worst case) |
|
55 |
AL_INH_IWG |
|
GRFN_REP_ANALYSIS_INH_IWG |
|
CURR |
15 |
2 |
Inherent Impact (Weighted) |
|
56 |
AL_INH_IML |
|
GRFN_REP_ANALYSIS_INH_IML |
GRFN_IMPACT_LEVEL |
NUMC |
2 |
0 |
Inherent Impact Level ID |
* |
57 |
AL_INH_RSL |
|
GRFN_REP_ANALYSIS_INH_RSL |
|
CHAR |
4 |
0 |
Inherent Risk Level ID |
|
58 |
AL_INH_RSC |
|
GRFN_REP_ANALYSIS_INH_RSC |
GRRM_RISK_LEVEL_COLOR |
CHAR |
2 |
0 |
Inherent Risk Level colour |
|
59 |
AL_INH_PRI |
|
GRFN_REP_ANALYSIS_INH_PRI |
GRRM_RISK_PRIORITY |
NUMC |
3 |
0 |
Inherent Risk Priority ID |
* |
60 |
AL_INH_IMM |
|
GRFN_REP_ANALYSIS_INH_IMM |
|
CURR |
15 |
2 |
Inherent Total Loss |
|
61 |
AL_RSP_PRB |
|
GRFN_REP_ANALYSIS_RSP_PRB |
|
DEC |
6 |
4 |
Planned Probability |
|
62 |
AL_RSP_EXL |
|
GRFN_REP_ANALYSIS_RSP_EXL |
|
CURR |
15 |
2 |
Planned Expected Loss |
|
63 |
AL_RSP_PRL |
|
GRFN_REP_ANALYSIS_RSP_PRL |
|
NUMC |
3 |
0 |
Planned Probabaility Level ID |
|
64 |
AL_RSP_IMN |
|
GRFN_REP_ANALYSIS_RSP_IMN |
|
CURR |
15 |
2 |
Planned Impact (Best Case) |
|
65 |
AL_RSP_IAV |
|
GRFN_REP_ANALYSIS_RSP_IAV |
|
CURR |
15 |
2 |
Planned Impact (Average Case) |
|
66 |
AL_RSP_IMX |
|
GRFN_REP_ANALYSIS_RSP_IMX |
|
CURR |
15 |
2 |
Planned Impact (Worst Case) |
|
67 |
AL_RSP_IWG |
|
GRFN_REP_ANALYSIS_RSP_IWG |
|
CURR |
15 |
2 |
Planned Impact (Weighted) |
|
68 |
AL_RSP_IML |
|
GRFN_REP_ANALYSIS_RSP_IML |
GRFN_IMPACT_LEVEL |
NUMC |
2 |
0 |
Planned Impact Level ID |
* |
69 |
AL_RSP_RSL |
|
GRFN_REP_ANALYSIS_RSP_RSL |
|
CHAR |
4 |
0 |
Planned Risk Level ID |
|
70 |
AL_RSP_RSC |
|
GRFN_REP_ANALYSIS_RSP_RSC |
GRRM_RISK_LEVEL_COLOR |
CHAR |
2 |
0 |
Planned Risk Level Colour |
|
71 |
AL_RSP_PRI |
|
GRFN_REP_ANALYSIS_RSP_PRI |
GRRM_RISK_PRIORITY |
NUMC |
3 |
0 |
Planned Risk Priority ID |
* |
72 |
AL_RSP_IMM |
|
GRFN_REP_ANALYSIS_RSP_IMM |
|
CURR |
15 |
2 |
Planned Total Loss |
|
73 |
AL_RSA_PRB |
|
GRFN_REP_ANALYSIS_RSA_PRB |
|
DEC |
6 |
4 |
Residual Probability |
|
74 |
AL_RSA_EXL |
|
GRFN_REP_ANALYSIS_RSA_EXL |
|
CURR |
15 |
2 |
Residual Expected Loss |
|
75 |
AL_RSA_PRL |
|
GRFN_REP_ANALYSIS_RSA_PRL |
|
NUMC |
3 |
0 |
Residual Probability Level ID |
|
76 |
AL_RSA_IMN |
|
GRFN_REP_ANALYSIS_RSA_IMN |
|
CURR |
15 |
2 |
Residual Impact (Best Case) |
|
77 |
AL_RSA_IAV |
|
GRFN_REP_ANALYSIS_RSA_IAV |
|
CURR |
15 |
2 |
Residual Impact (Average Case) |
|
78 |
AL_RSA_IMX |
|
GRFN_REP_ANALYSIS_RSA_IMX |
|
CURR |
15 |
2 |
Residual Impact (Worst Case) |
|
79 |
AL_RSA_IWG |
|
GRFN_REP_ANALYSIS_RSA_IWG |
|
CURR |
15 |
2 |
Residual Impact (Weighted) |
|
80 |
AL_RSA_IML |
|
GRFN_REP_ANALYSIS_RSA_IML |
GRFN_IMPACT_LEVEL |
NUMC |
2 |
0 |
Residual Impact Level ID |
* |
81 |
AL_RSA_RSL |
|
GRFN_REP_ANALYSIS_RSA_RSL |
|
CHAR |
4 |
0 |
Residual Risk Level ID |
|
82 |
AL_RSA_RSC |
|
GRFN_REP_ANALYSIS_RSA_RSC |
GRRM_RISK_LEVEL_COLOR |
CHAR |
2 |
0 |
Residual Risk Level Colour |
|
83 |
AL_RSA_PRI |
|
GRFN_REP_ANALYSIS_RSA_PRI |
GRRM_RISK_PRIORITY |
NUMC |
3 |
0 |
Residual Risk Priority ID |
* |
84 |
AL_RSA_IMM |
|
GRFN_REP_ANALYSIS_RSA_IMM |
|
CURR |
15 |
2 |
Residual Total Loss |
|