ICLCLAIM

Claim | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM Number of Claim
Column Name Description
💲 Currency of Withdrawal Amount (WITHDRAWCURR):
WITHDRAWAM Requested Total Withdrawal Amount
💲 Currency of Premium Payment (PREMBALANAMCURR):
PREMBALANAM Premium Balance
Column Name Description
Column Name Description
DATELOSS Date of Loss/Claim
TIMELOSS Time of Claim/Loss
LOSSREPCOMPA Date Claim Reported to Insurance Company
LOSSREPAGENT Date on Which Claim Was Reported to Agent
OPENDATE Opened On
EFFECTIVE_DT Contract Validity Date
LOSSREP_DT Date on Request for Insurance Benefit
FOLLOWUP_DT Date of Automatic Resubmission
PROCESSING_DT Processing On
CLEARDATE Premium Paid Up To
REACT_DT Date of Occupational Disability/Perm.Incap.to Wk Reactivatn
_DATAAGING Data Filter Value for Data Aging
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
EXCLAIMNOCAT External Number Category Show values
STHANDLER "Claim Handling" Process Active Show values
STNOCLAIM No Claim Made Show values
STCLOSED "Close (Sub)Claim" Process Executed Show values
XDATEESTIM Date Is Estimate Show values
XAUTHREP Claim/Loss Reported to Authority Show values
XSENSITIVE Sensitive Claim? Show values
ASSIGN_STATE Assignment Status of a Claim Subobject Show values
XCUMUL Claim Assigned to an Aggregate Show values
XTPKNOWN Flag: Third Party Known? Show values
COVERED Indication of Compensability Show values
XCLAIMB Entry in ICLCLAIMB Exists Show values
XNONOTIF Processing Not Possible in Notification Mode Show values
XRESERVE At Least One Reserve Exists in Claim Show values
WF_STATUS Workflow Status Show values
XDUMMYCLAIM Claim Is Dummy Claim Show values
XWITHOUT_PRODUCT Use of Scenario Without Product Customizing Show values
SIF_STATUS Status of Second Injury Fund Show values
INVSTG_STATUS Claim Investigation Match Status Show values
AUTFOLLOWUP Automatic Resubmission Show values
ARCHIVE_STATUS Archiving Status Show values
Column Name Description Domain name
CHANGETIME Changed: Date + Time ICL_TIMESTAMP
CREATETIME Created: Date + Time ICL_TIMESTAMP
ACHANGETIME Whole Claim Last Changed At ICL_TIMESTAMP
EXCLAIMNO External Number ICL_CLAIMNO
STATUSCHG Date and Time of Last Status Change ICL_TIMESTAMP
LRENEWAL Last Renewal of Contract Before Claim Date/Time ICL_TIMESTAMP
POLICY Contract Number ICL_POLICY
OWNER ID of Claim Handler ICL_CLAIMOWNER
OWNERTYPE_GRP Object Type of Claim Handler Group OTYPE
OWNER_GRP Claim Handler Group ICL_CLAIMOWNER
TPNO Third Party Count (NOT USED) NUMC2
BENTREE Benefit Type Tree ICL_BENTREE
BENTREEG Generation of Benefit Type Tree ICL_BENTREEG
BENTREEV Version of Benefit Type Tree ICL_BENTREEV
WF_EXEC_TIME Execution Time Workflow ICL_TIMESTAMP
VERCHNGUTC Time for Reading Version ICL_TIMESTAMP
MAX_ITEMNR Current Highest Claim Item Number ICL_SCLITEM
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
LUMPSUMOPTION Option Exercised ICL_LUMPSUMOPTION
STATPENSION Type of Statutory Pension ICL_STATPENSION
WITHDRAWSEQ Withdrawal Sequence ICL_WITHDRAWSEQ
ALTERNATEBEN Display Alternative Benefit Values ICL_ALTERNATEBEN
GENERATENOTIF Make Special Risk Notification ICL_GENERATENOTIF
NOTIFREASON Reason for Special Risk Notification ICL_NOTIFREASON
STATUSOBJID Object number J_OBJNR
DUNNLEVEL Dunning Status ICL_DUNNLEVEL
WITHDRAWTYPE Withdrawal Type ICL_WITHDRAWTYPE
GENNOTIFTIME Special Risk Message Submitted On ICL_GENERATENOTIFTIME
BEN_CALC_FAIL Time of Last Incorrect Benefit Calculation ICL_TIMESTAMP
POLSYSTEM Technical Key of Policy System SYCHAR08
DUMMY_FNOL Dummy function in length 1 DUMMY
DUMMY_ICLVDM_CLAIM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
DUMMY_ICLVDM_CLINQ_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
REJECTION Rejection Reason
Master Data Relations | to Other Relations ↓ Join Conditions
Whole Claim Last Changed By
  • ICLCLAIM.CLIENT == USR02.MANDT
  • ICLCLAIM.ACHANGEDBY == USR02.BNAME
Authorization Group for Claims (VIP)
  • ICLCLAIM.CLIENT == TICL113.CLIENT
  • ICLCLAIM.AUTHCLM == TICL113.AUTHCLM
Changed By
  • ICLCLAIM.CLIENT == USR02.MANDT
  • ICLCLAIM.CHANGEDBY == USR02.BNAME
Internal Claim Type
  • Internal Claim Type
  • ?
  • ICLCLAIM.CLIENT == TICL011.CLIENT
  • ICLCLAIM.CLAIMTYPE == TICL011.CLTYPE
  • ICLCLAIM.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Client ICLCLAIM.CLIENT == T000.MANDT
Generation of Internal Claim Type
  • Internal Claim Type
  • Generation of Internal Claim Type
  • ICLCLAIM.CLIENT == TICL011.CLIENT
  • ICLCLAIM.CLAIMTYPE == TICL011.CLTYPE
  • ICLCLAIM.CLTYPEG == TICL011.VERSION
Internal Claim Type Version
  • Generation of Internal Claim Type
  • Internal Claim Type
  • Internal Claim Type Version
  • ICLCLAIM.CLIENT == TICL003.CLIENT
  • ICLCLAIM.CLTYPEG == TICL003.GENERAT
  • ICLCLAIM.CLAIMTYPE == TICL003.CLTYPE
  • ICLCLAIM.CLTYPEV == TICL003.VERSION
Created By
  • ICLCLAIM.CLIENT == USR02.MANDT
  • ICLCLAIM.CREATEDBY == USR02.BNAME
Reason for Changing Claim Date
  • ICLCLAIM.CLIENT == TICL029.CLIENT
  • ICLCLAIM.DATECHANGER == TICL029.DATECHANGER
Policy Product Generation
  • Policy Product
  • Policy Product Generation
  • ICLCLAIM.CLIENT == TICL320.CLIENT
  • ICLCLAIM.POLPROD == TICL320.POLPROD
  • ICLCLAIM.GENERAT == TICL320.VERSION
Country/Region of Jurisdiction
  • Country/Region of Jurisdiction
  • Client
  • ICLCLAIM.JURISCOUNTRY == T005.LAND1
  • ICLCLAIM.CLIENT == T005.MANDT
Jurisdiction Region
  • Country/Region of Jurisdiction
  • Jurisdiction Region
  • ICLCLAIM.CLIENT == T005S.MANDT
  • ICLCLAIM.JURISCOUNTRY == T005S.LAND1
  • ICLCLAIM.JURISREGION == T005S.BLAND
Loss Location
  • Loss Location
  • ?
  • ?
  • ICLCLAIM.CLIENT == ADRC.CLIENT
  • ICLCLAIM.LOSSADDRESS == ADRC.ADDRNUMBER
  • ICLCLAIM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ICLCLAIM.[column in domain "AD_NATION"] == ADRC.NATION
Time Zone of Claim/Loss Event
  • ICLCLAIM.CLIENT == TTZZ.CLIENT
  • ICLCLAIM.LTIMEZONE == TTZZ.TZONE
Object Type of Claim Handler
  • ICLCLAIM.CLIENT == T778O.MANDT
  • ICLCLAIM.OWNERTYPE == T778O.OTYPE
Policy Product
  • Policy Product
  • ?
  • ICLCLAIM.CLIENT == TICL320.CLIENT
  • ICLCLAIM.POLPROD == TICL320.POLPROD
  • ICLCLAIM.[column in domain "ICL_GENERAT"] == TICL320.VERSION
Status of Claim
  • Status of Claim
  • Client
Policy Product Version
  • Policy Product
  • Policy Product Generation
  • Policy Product Version
  • ICLCLAIM.CLIENT == TICL321.CLIENT
  • ICLCLAIM.POLPROD == TICL321.POLPROD
  • ICLCLAIM.GENERAT == TICL321.GENERAT
  • ICLCLAIM.VERSION == TICL321.VERSION
Fault of Policyholder from Point of View of Insurer
  • ICLCLAIM.CLIENT == TICL081.CLIENT
  • ICLCLAIM.VIEWFAULT == TICL081.VIEWFAULT
Party at Fault from Point of View of Policyholder
  • ICLCLAIM.CLIENT == TICL081.CLIENT
  • ICLCLAIM.VIEWFAULTPH == TICL081.VIEWFAULT
Other Relations | to Master Data Relations ↑ Join Conditions
Complexity of Claim/Subclaim
  • Internal Claim Type
  • Internal Claim Type Version
  • ?
  • Complexity of Claim/Subclaim
  • Client
  • Generation of Internal Claim Type
  • ICLCLAIM.CLAIMTYPE == TICL027.CLTYPE
  • ICLCLAIM.CLTYPEV == TICL027.VERSION
  • ICLCLAIM.[column in domain "ICL_SUBCLTYPE"] == TICL027.SUBCLTYPE
  • ICLCLAIM.COMPLEX == TICL027.COMPLEX
  • ICLCLAIM.CLIENT == TICL027.CLIENT
  • ICLCLAIM.CLTYPEG == TICL027.GENERAT
Cause of Loss/Claim
  • Internal Claim Type Version
  • Internal Claim Type
  • Generation of Internal Claim Type
  • Cause of Loss/Claim
  • ICLCLAIM.CLIENT == TICL009.CLIENT
  • ICLCLAIM.CLTYPEV == TICL009.VERSION
  • ICLCLAIM.CLAIMTYPE == TICL009.CLTYPE
  • ICLCLAIM.CLTYPEG == TICL009.GENERAT
  • ICLCLAIM.LOSSCAUSE == TICL009.LOSSCAUSE
Incident Type of a Claim
  • ?
  • ?
  • Incident Type of a Claim
  • Client
  • ?
  • ICLCLAIM.[column in domain "ICL_GENERAT"] == TICL062.GENERAT
  • ICLCLAIM.[column in domain "ICL_POLPRODV"] == TICL062.VERSION
  • ICLCLAIM.LOSSTYPE == TICL062.LOSSTYPE
  • ICLCLAIM.CLIENT == TICL062.CLIENT
  • ICLCLAIM.[column in domain "ICL_POLPROD"] == TICL062.POLPROD
Reason for Changing the Status
  • Internal Claim Type
  • Reason for Changing the Status
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • ?
  • Status of Claim
  • ICLCLAIM.CLAIMTYPE == TICL047.CLTYPE
  • ICLCLAIM.STATREASON == TICL047.FORMOFSET
  • ICLCLAIM.CLIENT == TICL047.CLIENT
  • ICLCLAIM.CLTYPEG == TICL047.GENERAT
  • ICLCLAIM.CLTYPEV == TICL047.VERSION
  • ICLCLAIM.[column in domain "ICL_SUBCLTYPE"] == TICL047.SUBCLTYPE
  • ICLCLAIM.STATUS == TICL047.STATUS