SAP ABAP Table GRRM_OB_S_QRR_LOSEVT_DATA (Loss Event Data for QRR)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	GRRM_OB_S_QRR_LOSEVT_DATA	Table Relationship Diagram
Short Description	Loss Event Data for QRR

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

History

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