SAP ABAP Table GRRM_OB_S_FACT_LOSEVT_DATA (Loss Event Fact Data)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-RM (Application Component) GRC Risk Management
     ⤷ GRRM_OB_REPORTING (Package) Operational Risk Management for Banks: Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	GRRM_OB_S_FACT_LOSEVT_DATA	Table Relationship Diagram
Short Description	Loss Event Fact Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	LOSS_EVT_ID	☐	GRRM_OB_LOSS_EVT_ID	GRRM_OB_LOSS_EVT_ID	CHAR	18	0	Loss Event ID
2	.INCLUDE	☐				0	0	Loss Event Attributes - validity relevant attributes
3	ORG_UNIT	☐	GRFN_REP_ORGUNIT		NUMC	8	0	Orgunit ID
4	PROCESS	☐	GRRM_OB_PROCESS		NUMC	8	0	Process ID
5	PROCESS_ENTITY	☐	GRFN_API_ENTITY_ID	GRFN_API_ENTITY_ID	CHAR	20	0	Entity ID	*
6	PRODUCT	☐	GRRM_OB_PRODUCT		NUMC	8	0	Product ID
7	PRODUCT_ENTITY	☐	GRFN_API_ENTITY_ID	GRFN_API_ENTITY_ID	CHAR	20	0	Entity ID	*
8	RISK_CAT	☐	GRRM_OB_CRISKID		NUMC	8	0	Risk Category ID
9	.INCLUDE	☐				0	0	Loss Event Attributes - functional attributes
10	EXTERNAL_ID	☐	GRRM_OB_LOSS_EVT_EXTERNAL_ID		CHAR	50	0	External ID of Loss Event
11	NAME	☐	GRRM_OB_LOSS_EVT_NAME	GRFN_TITLE	CHAR	40	0	Name of Loss Event
12	TYPE	☐	GRRM_OB_LOSS_EVT_TYPE	GRRM_OB_LOSS_EVT_TYPE	CHAR	10	0	Loss Event Type ID	GRRMOBLOSEVTY
13	DESCRIPTION	☐	GRRM_OB_LOSS_EVT_DESCR	GRRM_DESCRIPTION	STRG	0	0	Description of Loss Event
14	INFL_DESCRIPTION	☐	GRRM_OB_LOSS_EVT_INFL_DESCR	GRRM_DESCRIPTION	STRG	0	0	Influence Description of Loss Event
15	EST_PROBABILITY	☐	GRRM_OB_EST_PROBABILITY	GRRM_OB_EST_PROBABILITY	DEC	6	2	Estimated Probability
16	COUNTRY	☐	GRRM_OB_LOSEVT_COUNTRY	LAND1	CHAR	3	0	Country ID of loss event	T005
17	OPERATIONAL_RISK	☐	GRRM_OB_OPERATIONAL_RISK_SHARE	GRRM_OB_FRACTION	DEC	7	4	Share of Operational Risk in Loss Event, %
18	CREDIT_RISK	☐	GRRM_OB_CREDIT_RISK_SHARE	GRRM_OB_FRACTION	DEC	7	4	Share of Credit Risk in Loss Event, %
19	MARKET_RISK	☐	GRRM_OB_MARKET_RISK_SHARE	GRRM_OB_FRACTION	DEC	7	4	Share of Market Risk in Loss Event, %
20	GLOBAL_EVT	☐	GRRM_OB_GLOBAL_EVENT	GRFN_XFELD	CHAR	1	0	Global Event
21	STATUS	☐	GRRM_OB_LOSEVT_STATUS	GRRM_OB_LOSEVT_STATUS	CHAR	3	0	Status of Loss Event - ID	GRRMOBWST
22	DETECT_ACTIVITY	☐	GRRM_OB_DET_ACT	GRRM_OB_DET_ACT	CHAR	10	0	Detection Activity ID	GRRMOBDETACT
23	LOSS_CRITERIA	☐	GRRM_OB_LOSS_CRIT	GRRM_OB_LOSS_CRIT	CHAR	10	0	Loss Criteria ID	GRRMOBLOSCRIT
24	CONFIDENTIALITY	☐	GRRM_OB_CONFIDENTIALITY	GRRM_OB_CONFIDENTIALITY	CHAR	4	0	Confidentiality of Loss Event
25	KEYWORDS	☐	GRRM_OB_KEYWORDS	GRRM_OB_KEYWORDS	CHAR	100	0	Keywords
26	WEIGHT	☐	GRRM_OB_LOSS_WEIGHT	GRRM_OB_LOSS_WEIGHT	DEC	4	2	Loss Weight
27	.INCLUDE	☐				0	0	Loss Event dates
28	.INCLUDE	☐				0	0	Loss Event dates - relevant for workflow customizing
29	OCCURENCE_DATE	☐	GRRM_OB_LOSEVT_OCC_DATE		DATS	8	0	Occurrence Date of Loss Event
30	OCCUR_END_DATE	☐	GRRM_OB_LOSEVT_OCC_END_DATE		DATS	8	0	Occurrence End Date for Loss Event
31	REMED_ACT_DATE	☐	GRRM_OB_LOSEVT_REMED_ACT_DATE		DATS	8	0	Remedial Action Date for Loss Event
32	APPROVAL_DATE	☐	GRRM_OB_LOSEVT_APPROVAL_DATE		DATS	8	0	Approval Date for Loss Event
33	EYE4_APPR_DATE	☐	GRRM_OB_LOSEVT_4EYE_APPR_DATE		DATS	8	0	4-eye Approval Date for Loss Event
34	REVIEW_DATE	☐	GRRM_OB_LOSEVT_REVIEW_DATE		DATS	8	0	Review Date for Loss Event
35	AUDIT_DATE	☐	GRRM_OB_LOSEVT_AUDIT_DATE		DATS	8	0	Audit Date for Loss Event
36	COMPL_DATE	☐	GRRM_OB_LOSEVT_COMPL_DATE		DATS	8	0	Completion Date for Loss Event
37	DISCOVERY_DATE	☐	GRRM_OB_LOSEVT_DISCOV_DATE		DATS	8	0	Discovery Date for Loss Event
38	EXP_RESOL_DATE	☐	GRRM_OB_LOSEVT_RESOL_DATE_EXP		DATS	8	0	Expected Resolution Date for Loss Event
39	ACT_RESOL_DATE	☐	GRRM_OB_LOSEVT_RESOL_DATE_ACT		DATS	8	0	Actual Resolution Date for Loss Evevnt
40	SETTL_DATE	☐	GRRM_OB_LOSEVT_SETTL_DATE		DATS	8	0	Settlement date
41	RESERVE_DATE	☐	GRRM_OB_LOSEVT_RESERVE_DATE		DATS	8	0	Reserve date
42	CONT_LIAB_DATE	☐	GRRM_OB_LOSEVT_CONT_LIAB_DATE		DATS	8	0	Contingent liability date
43	ACCOUNTING_DATE	☐	GRRM_OB_LOSEVT_CONT_ACC_DATE		DATS	8	0	Accounting date
44	.INCLUDE	☐				0	0	Loss Event dates - not relevant for workflow customizing
45	RECOGN_DATE	☐	GRRM_OB_LOSEVT_RECOGN_DATE		DATS	8	0	Date of recognition
46	.INCLUDE	☐				0	0	Loss Event amount parameters
47	CURRENCY	☐	GRFN_CURRENCY	WAERS	CUKY	5	0	Currency	*
48	ESTIMATE	☐	GRRM_OB_ESTIMATE	GRFN_AMOUNT	CURR	15	2	Estimated Loss
49	POTENTIAL	☐	GRRM_OB_POTENTIAL	GRFN_AMOUNT	CURR	15	2	Potential Loss
50	TOTAL_AMOUNT	☐	GRRM_OB_TOTAL_AMOUNT	GRFN_AMOUNT	CURR	15	2	Total Loss
51	GROSS_LOSS_AMT	☐	GRRM_OB_GROSS_LOSS_AMT	GRFN_AMOUNT	CURR	15	2	Gross Loss
52	NET_LOSS_AMT	☐	GRRM_OB_NET_LOSS_AMT	GRFN_AMOUNT	CURR	15	2	Net Loss
53	RECOV_LOSS_AMT	☐	GRRM_OB_RECOV_GROSS_LOSS_AMT	GRFN_AMOUNT	CURR	15	2	Capital Allocation
54	UNREALIZED	☐	GRRM_OB_UNREALIZED	GRFN_AMOUNT	CURR	15	2	Unrealized Loss
55	DIRECT_RECOV	☐	GRRM_OB_DIRECT_RECOV	GRFN_AMOUNT	CURR	15	2	Direct Recovery
56	INDIRECT_RECOV	☐	GRRM_OB_INDIRECT_RECOV	GRFN_AMOUNT	CURR	15	2	Indirect Recovery
57	LOSS_THRESHOLD	☐	GRRM_OB_LOSS_THRESHOLD	GRFN_AMOUNT	CURR	15	2	Loss Threshold
58	.INCLUDE	☐				0	0	Loss Event ORX specific attributes
59	ORX_REL_FLAG	☐	GRRM_OB_ORX_REL_FLAG	GRFN_XFELD	CHAR	1	0	Indicator: Loss Event is relevant for ORX Export
60	REF_ID	☐	GRRM_OB_ORX_REF_ID	GRRM_OB_LOSS_EVT_ID	CHAR	18	0	ORX - Legacy Reference ID
61	.INCLUDE	☐				0	0	ORX - Categorization Codes
62	ORXBL	☐	GRRM_OB_ORX_BL	GRRM_OB_ORX_BL	CHAR	6	0	ORX - Business Line Code	*
63	ORXEL	☐	GRRM_OB_ORX_EL	GRRM_OB_ORX_EL	CHAR	6	0	ORX - Event Type Code	*
64	ORXPD	☐	GRRM_OB_ORX_PD	GRRM_OB_ORX_PD	CHAR	6	0	ORX - Product Code	*
65	ORXPC	☐	GRRM_OB_ORX_PC	GRRM_OB_ORX_PC	CHAR	6	0	ORX - Process Code	*
66	.INCLUDE	☐				0	0	ORX - Large Loss Event Attributes
67	ORXCS_1	☐	GRRM_OB_ORX_CS	GRRM_OB_ORX_CS	CHAR	6	0	ORX - Alleged Cause Code	*
68	ORXCS_2	☐	GRRM_OB_ORX_CS	GRRM_OB_ORX_CS	CHAR	6	0	ORX - Alleged Cause Code	*
69	ORXCS_3	☐	GRRM_OB_ORX_CS	GRRM_OB_ORX_CS	CHAR	6	0	ORX - Alleged Cause Code	*
70	ORXCL_1	☐	GRRM_OB_ORX_CL	GRRM_OB_ORX_CL	CHAR	6	0	ORX - Control Code	*
71	ORXCL_2	☐	GRRM_OB_ORX_CL	GRRM_OB_ORX_CL	CHAR	6	0	ORX - Control Code	*
72	ORXCL_3	☐	GRRM_OB_ORX_CL	GRRM_OB_ORX_CL	CHAR	6	0	ORX - Control Code	*
73	ORXLS01	☐	GRRM_OB_ORX_LS01	GRRM_OB_ORX_LS01	CHAR	6	0	ORX - Jurisdiction / Choice of Law Code	*
74	ORXLS02	☐	GRRM_OB_ORX_LS02	GRRM_OB_ORX_LS02	CHAR	6	0	ORX - Counterparty / Claimant Type Code	*
75	ORXLS03	☐	GRRM_OB_ORX_LS03	GRRM_OB_ORX_LS03	CHAR	6	0	ORX - Role of the Firm Code	*
76	ORXLS04	☐	GRRM_OB_ORX_LS04	GRRM_OB_ORX_LS04	CHAR	6	0	ORX - Environmental Volatility Code	*
77	.INCLUDE	☐				0	0	ORX - Other Attributes
78	REL_EVENT_REF_ID	☐	GRRM_OB_ORX_REL_EVENT_REF_ID	GRRM_OB_LOSS_EVT_ID	CHAR	18	0	ORX - Related Loss Event Reference ID
79	ISS_OVERRIDE_FLAG	☐	GRRM_OB_ORX_ISS_OVERRIDE_FLAG	GRFN_XFELD	CHAR	1	0	ORX - Validation Issue Override
80	OVERRIDE_REASON	☐	GRRM_OB_ORX_OVERRIDE_REASON	GRFN_COMMENTS	STRG	0	0	ORX - Reason for Override
81	REPORTED_ORX_FLAG	☐	GRRM_OB_ORX_REPORTED_ORX_FLAG	GRFN_XFELD	CHAR	1	0	ORX - Indicator: Loss is reported to ORX
82	REPORTED_ORX_DATE	☐	GRRM_OB_ORX_REPORTED_ORX_DATE	GRFN_DATUM	DATS	8	0	ORX - Date when the loss was reported to ORX
83	REPORTED_REG_FLAG	☐	GRRM_OB_ORX_REPORTED_REG_FLAG	GRFN_XFELD	CHAR	1	0	ORX - Indicator: Loss is reported to Regulator
84	REPORTED_REG_DATE	☐	GRRM_OB_ORX_REPORTED_REG_DATE	GRFN_DATUM	DATS	8	0	ORX - Date when the loss was reported to Regulator
85	.INCLUDE	☐				0	0	Loss Event Attributes - technical part
86	.INCLUDE	☐				0	0	Creation attributes
87	CREATED_BY	☐	GRRM_OB_CREATED_BY	UNAME	CHAR	12	0	Creating user
88	CREATED_ON	☐	GRFN_CREATED_ON		DATS	8	0	Created on (Date)
89	CREATED_ON_TIME	☐	GRFN_TIME	SYTIME	TIMS	6	0	Time
90	.INCLUDE	☐				0	0	Change attributes
91	CHANGED_BY	☐	GRRM_OB_CHANGED_BY	UNAME	CHAR	12	0	Changing user
92	CHANGED_ON	☐	GRFN_CHANGED_ON	GRFN_DATUM	DATS	8	0	Changed on
93	CHANGED_ON_TIME	☐	GRFN_TIME	SYTIME	TIMS	6	0	Time
94	DELETION_FLAG	☐	GRRM_OB_DELETION_FLAG	GRFN_XFELD	CHAR	1	0	Deletion Indicator
95	MC_NAME	☐	GRRM_OB_LOSS_EVT_NAME_MC		CHAR	40	0	Name of Loss Event (Upper Case)
96	.INCLUDE	☐				0	0	Loss Event Text Attributes
97	ORG_UNIT_TXT	☐	GRRM_OB_ORGUNIT_NAME	GRFN_ORGUNIT_NAME	CHAR	40	0	Organizational Unit Title
98	RISK_CAT_TXT	☐	GRRM_RISK_CATEGORY		CHAR	40	0	Risk Category
99	PROCESS_TXT	☐	GRRM_OB_PROCESS_TXT	GRFN_TITLE	CHAR	40	0	Process
100	PRODUCT_TXT	☐	GRRM_OB_PRODUCT_TXT	GRFN_TITLE	CHAR	40	0	Product
101	ESTIMATE_TXT	☐	GRRM_OB_ESTIMATE_TXT	TEXT40	CHAR	40	0	Estimated Loss
102	POTENTIAL_TXT	☐	GRRM_OB_POTENTIAL_TXT	TEXT40	CHAR	40	0	Potential Loss
103	TOTAL_AMOUNT_TXT	☐	GRRM_OB_TOTAL_AMOUNT_TXT	TEXT40	CHAR	40	0	Total Loss
104	GROSS_LOSS_AMT_TXT	☐	GRRM_OB_GROSS_LOSS_AMT_TXT	TEXT40	CHAR	40	0	Gross Loss
105	NET_LOSS_AMT_TXT	☐	GRRM_OB_NET_LOSS_AMT_TXT	TEXT40	CHAR	40	0	Net Loss
106	RECOV_LOSS_AMT_TXT	☐	GRRM_OB_RECOV_LOSS_AMT_TXT	TEXT40	CHAR	40	0	Capital Allocation
107	UNREALIZED_TXT	☐	GRRM_OB_UNREALIZED_TXT	TEXT40	CHAR	40	0	Unrealized Loss
108	DIRECT_RECOV_TXT	☐	GRRM_OB_DIRECT_RECOV_TXT	TEXT40	CHAR	40	0	Direct Recovery
109	INDIRECT_RECOV_TXT	☐	GRRM_OB_INDIRECT_RECOV_TXT	TEXT40	CHAR	40	0	Indirect Recovery
110	LOSS_THRESHOLD_TXT	☐	GRRM_OB_LOSS_THRESHOLD_TXT	TEXT40	CHAR	40	0	Loss Threshold
111	COUNTRY_TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
112	TYPE_TXT	☐	GRRM_OB_LOSS_EVT_TYPE_TXT	GRFN_TITLE	CHAR	40	0	Loss Event Type Description
113	STATUS_TXT	☐	GRRM_OB_LOSEVT_STATUS_TXT	GRFN_TITLE	CHAR	40	0	Status of Loss Event - Text
114	LOSS_CRITERIA_TXT	☐	GRRM_OB_LOSS_CRIT_TXT	GRFN_TITLE	CHAR	40	0	Loss Criteria
115	DETECT_ACTIVITY_TXT	☐	GRRM_OB_DET_ACT_TXT	GRFN_TITLE	CHAR	40	0	Detection Activity
116	OPERATIONAL_RISK_TXT	☐	GRRM_OB_OPERATIONAL_RISK_TXT	TEXT40	CHAR	40	0	Share of Operational Risk in Loss Event
117	CREDIT_RISK_TXT	☐	GRRM_OB_CREDIT_RISK_TXT	TEXT40	CHAR	40	0	Share of Credit Risk in Loss Event
118	MARKET_RISK_TXT	☐	GRRM_OB_MARKET_RISK_TXT	TEXT40	CHAR	40	0	Share of Market Risk in Loss Event
119	CREATED_BY_TXT	☐	GRRM_OB_CREATED_BY_TXT	TEXT80	CHAR	80	0	User Name for WD
120	CHANGED_BY_TXT	☐	GRRM_OB_CHANGED_BY_TXT	TEXT80	CHAR	80	0	User Name for WD
121	.INCLUDE	☐				0	0	Texts for Loss Event ORX specific attributes
122	ORXBL_TXT	☐	GRRM_OB_ORX_BL_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Business Line Description
123	ORXEL_TXT	☐	GRRM_OB_ORX_EL_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Event Type Description
124	ORXPD_TXT	☐	GRRM_OB_ORX_PD_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Product Description
125	ORXPC_TXT	☐	GRRM_OB_ORX_PC_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Process Description
126	ORXCS_1_TXT	☐	GRRM_OB_ORX_CS_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Alleged Cause Description
127	ORXCS_2_TXT	☐	GRRM_OB_ORX_CS_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Alleged Cause Description
128	ORXCS_3_TXT	☐	GRRM_OB_ORX_CS_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Alleged Cause Description
129	ORXCL_1_TXT	☐	GRRM_OB_ORX_CL_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Control Description
130	ORXCL_2_TXT	☐	GRRM_OB_ORX_CL_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Control Description
131	ORXCL_3_TXT	☐	GRRM_OB_ORX_CL_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Control Description
132	ORXLS01_TXT	☐	GRRM_OB_ORX_LS01_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Jurisdiction / Choice of Law Description
133	ORXLS02_TXT	☐	GRRM_OB_ORX_LS02_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Counterparty / Claimant Type Description
134	ORXLS03_TXT	☐	GRRM_OB_ORX_LS03_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Role of the Firm Description
135	ORXLS04_TXT	☐	GRRM_OB_ORX_LS04_TXT	GRRM_OB_ORX_TXT	CHAR	80	0	ORX - Environmental Volatility Description
136	T_EFFECT	☐	GRRM_OB_T_FACT_EFFECT_DATA		TTYP	0	0
137	T_EFFALLC	☐	GRRM_OB_T_FACT_EFFALLC_DATA		TTYP	0	0
138	T_CAUSE	☐	GRRM_OB_T_FACT_CAUSE_DATA		TTYP	0	0
139	T_RISK	☐	GRRM_OB_T_FACT_RISK_DATA		TTYP	0	0
140	T_GROUPED_LOSS	☐	GRRM_OB_T_FACT_LOSEVTGR_DATA		TTYP	0	0
141	T_CDF	☐	GRFN_T_FACT_CDF		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GRRM_OB_S_FACT_LOSEVT_DATA	COUNTRY	T005	LAND1
2	GRRM_OB_S_FACT_LOSEVT_DATA	DETECT_ACTIVITY	GRRMOBDETACT	DETACT_ID	REF
3	GRRM_OB_S_FACT_LOSEVT_DATA	LOSS_CRITERIA	GRRMOBLOSCRIT	LOSS_CRIT_ID	REF
4	GRRM_OB_S_FACT_LOSEVT_DATA	STATUS	GRRMOBWST	STATUS_ID
5	GRRM_OB_S_FACT_LOSEVT_DATA	TYPE	GRRMOBLOSEVTY	LOSS_EVT_TYPE_ID	REF

History

Last changed by/on	SAP	20141106
SAP Release Created in	V1100