ICLSUBCL

Subclaim | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
SUBCLAIM Subclaim
Column Name Description
Column Name Description
Column Name Description
BENSTART_DT Start of Benefit
BENEND_DT End of Benefit
ARCHIVE_FLUD Resubmission Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
STHANDLER "Claim Handling" Process Active Show values
STNOCLAIM No Claim Made Show values
STCLOSED "Close (Sub)Claim" Process Executed Show values
STINVALID Subclaim Invalid Show values
STREJECT Claim/Subclaim Rejected Show values
XCOMPLETE Flag: Claim Item List (Presumably) Complete Show values
XSALVAGE Flag: Salvage? Show values
XOTHERINSURE Flag: Other Insurance? Show values
XSUBRO Subrogation/Recovery Status Show values
SUBRO_POTENTIAL Subrogation/Recovery Potential of a Subclaim (Check Status) Show values
XLITIGATION Flag: Litigation? Show values
XNEGOTIATION Flag: Negotiation? Show values
XFRAUD Flag: Potential Fraud? Show values
XCOVCONFIRMED Indication of Compensability Show values
ASSIGN_STATE Assignment Status of a Claim Subobject Show values
WF_STATUS Workflow Status Show values
COMPENSABILITY Compensability 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
STATUSCHG Date and Time of Last Status Change ICL_TIMESTAMP
HANDLERTYPE_GRP Object Category of Subclaim Handler Group OTYPE
CLAIMHANDLER_GRP Claim Handler Group for Subclaims XUBNAME
SUBCLAIMDESC Name of Claim/Subclaim TEXT20
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
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
MAX_ITEMNR Current Highest Claim Item Number ICL_SCLITEM
OVERRULEREASON Overruling Reason ICL_OVERRULEREASON
BENCALC_NUM Sequence Number of Benefit Calculation ICL_BENCALC_NUM
INSUREDOBJ Insured Object Number ICL_INSOBJ
REJECTION Rejection Reason
DUMMY_ICLVDM_SUBCL_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations | to Other Relations ↓ Join Conditions
Changed By
  • ICLSUBCL.CLIENT == USR02.MANDT
  • ICLSUBCL.CHANGEDBY == USR02.BNAME
Claim Handler for Subclaim
  • ICLSUBCL.CLIENT == USR02.MANDT
  • ICLSUBCL.CLAIMHANDLER == USR02.BNAME
Client ICLSUBCL.CLIENT == T000.MANDT
Created By
  • ICLSUBCL.CLIENT == USR02.MANDT
  • ICLSUBCL.CREATEDBY == USR02.BNAME
Object Category of Subclaim Handler
  • ICLSUBCL.CLIENT == T778O.MANDT
  • ICLSUBCL.HANDLERTYPE == T778O.OTYPE
Status of Subclaim
  • Status of Subclaim
  • Client
Subclaim Type
  • ICLSUBCL.CLIENT == TICL004.CLIENT
  • ICLSUBCL.SUBCLTYPE == TICL004.SUBCLTYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Complexity of Claim/Subclaim
  • ?
  • ?
  • Subclaim Type
  • Complexity of Claim/Subclaim
  • Client
  • ?
  • ICLSUBCL.[column in domain "ICL_CLTYPE"] == TICL027.CLTYPE
  • ICLSUBCL.[column in domain "ICL_CLTYPEV"] == TICL027.VERSION
  • ICLSUBCL.SUBCLTYPE == TICL027.SUBCLTYPE
  • ICLSUBCL.COMPLEX == TICL027.COMPLEX
  • ICLSUBCL.CLIENT == TICL027.CLIENT
  • ICLSUBCL.[column in domain "ICL_CLTYPEG"] == TICL027.GENERAT
Reason for Changing the Status
  • ?
  • Reason for Changing the Status
  • Client
  • ?
  • ?
  • Subclaim Type
  • Status of Subclaim
  • ICLSUBCL.[column in domain "ICL_CLTYPE"] == TICL047.CLTYPE
  • ICLSUBCL.STATREASON == TICL047.FORMOFSET
  • ICLSUBCL.CLIENT == TICL047.CLIENT
  • ICLSUBCL.[column in domain "ICL_CLTYPEG"] == TICL047.GENERAT
  • ICLSUBCL.[column in domain "ICL_CLTYPEV"] == TICL047.VERSION
  • ICLSUBCL.SUBCLTYPE == TICL047.SUBCLTYPE
  • ICLSUBCL.STATUS == TICL047.STATUS