ICSCCEVENT

Shadow Table Claim Bundle | #transactional | Component: Claims Management

🔑 Keys (4)
💰 Amounts (3)
∑ Quantities
📅 Dates (8)
☰ Categorical (11)
Other (10)
🔗 Relations (13)

Column Name	Description
CLIENT FK	Client
ACTIVE	Table entry is active (A) or in suspense (S)	Show values
CCEVENT	Claim Bundle
CHANGETIME	Changed: Date + Time

Column Name	Description
💲 Currency of Claim Bundle Reserve (CURR):
LIMIT	Claim Bundle Compensation Reserve
LIMITE	Claim Bundle Expenses Reserve
AMOUNT_TOTAL	Net Total Amount of Collective Invoice (acc. to Coll.Inv.)

Column Name	Description

Column Name	Description
RANGEFROM	Event Period: Date From
RANGETO	Event Period: Date To
ISSUEDATE	Collective Invoice Date
RECEIVEDATE	Date Received
BILLINGDATE	Next Billing Date
RESUBDATE	Date of Resubmission
SBRNOTIFDATE	Date on Which Subrogation Claim Was Reported
ARCHIVE_FLUD	Resubmission Date

Column Name	Description
ACTIVE	Table entry is active (A) or in suspense (S)	Show values
DELETED	Database Line Status (Original, Changed, Deleted)	Show values
LOCATYPE	Define Location via Region '1', Postal Code '2', Address '3'	Show values
PAYMENTLEVEL	Payment Level of a Collective Invoice	Show values
CLMINPROCESS	Dependent Claim Exists with Status "In Process"	Show values
RELEASED	Status "Released"	Show values
CANCEL	Status "Cancelled"	Show values
INPROCESS	Status "In Process"	Show values
STHANDLER	"Bundle Processing" Process Is Active	Show values
WF_STATUS	Workflow Status	Show values
ARCHIVE_STATUS	Archiving Status	Show values

Column Name	Description	Domain name
CREATETIME	Created: Date + Time	ICL_TIMESTAMP
CODE	External Name for Claim Bundle	CHAR20
NAME	Name of Claim Bundle	TEXT20
HOTLINE	Coordinator phone number	CHAR30
INVOICEREF_BULK	External Collective Invoice Number	CHAR16
EXTERNALREF_BULK	External Reference to Collective Invoice	ICL_EXTERNALREF_BULK
CLMINPROC_CNTR	Counter for Number of Open Claims	ICL_CLMSTATUS_INPROCESS_CNTR
ACHANGEDBY	Whole Claim Last Changed By	XUBNAME
ACHANGETIME	Whole Claim Last Changed At	ICL_TIMESTAMP
REJECTION	Rejection Reason

Master Data Relations	Join Conditions
Reason for Creation of Claim Bundle	`ICSCCEVENT.CLIENT == TICL012.CLIENT` `ICSCCEVENT.BUNDLECAUSE == TICL012.BUNDLECAUSE`
Subrogation Claim Type in Subrogation Subtype of Claim Bundle Type Claim Bundle Type Subrogation Claim Type in Subrogation	`ICSCCEVENT.CLIENT == TICL177.CLIENT` `ICSCCEVENT.SUBTYPE == TICL177.SUBTYPE` `ICSCCEVENT.CCTYPE == TICL177.CCTYPE` `ICSCCEVENT.CCSBRTYPE == TICL177.CCSBRTYPE`
Claim Bundle Type	`ICSCCEVENT.CLIENT == TICL001.CLIENT` `ICSCCEVENT.CCTYPE == TICL001.CCTYPE`
Changed By	`ICSCCEVENT.CLIENT == USR02.MANDT` `ICSCCEVENT.CHANGEDBY == USR02.BNAME`
Change Reason for Status of Collective Subrogation/Recovery	`ICSCCEVENT.CLIENT == TICL175.CLIENT` `ICSCCEVENT.CHREASONSBR == TICL175.CHREASONSBR`
Client	`ICSCCEVENT.CLIENT == T000.MANDT`
Created By	`ICSCCEVENT.CLIENT == USR02.MANDT` `ICSCCEVENT.CREATEDBY == USR02.BNAME`
Currency of Claim Bundle Reserve	`ICSCCEVENT.CLIENT == TCURC.MANDT` `ICSCCEVENT.CURR == TCURC.WAERS`
Data Origin	`ICSCCEVENT.CLIENT == TICL136.CLIENT` `ICSCCEVENT.DATASOURCE == TICL136.DATASOURCE`
Claim Bundle Handler	`ICSCCEVENT.CLIENT == USR02.MANDT` `ICSCCEVENT.OWNER == USR02.BNAME`
Status of Claim Bundle Status of Claim Bundle Client	`ICSCCEVENT.STATUS == TICL140.STATUS` `ICSCCEVENT.CLIENT == TICL140.CLIENT`
Subtype of Claim Bundle Type Subtype of Claim Bundle Type Claim Bundle Type	`ICSCCEVENT.CLIENT == TICL002.CLIENT` `ICSCCEVENT.SUBTYPE == TICL002.SUBTYPE` `ICSCCEVENT.CCTYPE == TICL002.CCTYPE`