SAP ABAP Table GRRM_OB_S_FACT_LOSEVT (Loss Event Fact Sheet)

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	Table Relationship Diagram
Short Description	Loss Event Fact Sheet

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

Foreign Keys

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

History

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