ICSSUBCL

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
CHANGETIME Changed: Date + Time
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
CREATETIME Created: Date + Time ICL_TIMESTAMP
STATUSCHG Date and Time of Last Status Change ICL_TIMESTAMP
STATREASON Reason for Changing the Status ICL_FORMSET
COVPOLVNR Version Number of Coverage Contract ICL_POLVCNTR
HANDLERTYPE Object Category of Subclaim Handler OTYPE
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
  • ICSSUBCL.CLIENT == USR02.MANDT
  • ICSSUBCL.CHANGEDBY == USR02.BNAME
Claim Handler for Subclaim
  • ICSSUBCL.CLIENT == USR02.MANDT
  • ICSSUBCL.CLAIMHANDLER == USR02.BNAME
Client ICSSUBCL.CLIENT == T000.MANDT
Created By
  • ICSSUBCL.CLIENT == USR02.MANDT
  • ICSSUBCL.CREATEDBY == USR02.BNAME
Status of Subclaim
  • Status of Subclaim
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Complexity of Claim/Subclaim
  • ?
  • ?
  • Subclaim Type
  • Complexity of Claim/Subclaim
  • Client
  • ?
  • ICSSUBCL.[column in domain "ICL_CLTYPE"] == TICL027.CLTYPE
  • ICSSUBCL.[column in domain "ICL_CLTYPEV"] == TICL027.VERSION
  • ICSSUBCL.SUBCLTYPE == TICL027.SUBCLTYPE
  • ICSSUBCL.COMPLEX == TICL027.COMPLEX
  • ICSSUBCL.CLIENT == TICL027.CLIENT
  • ICSSUBCL.[column in domain "ICL_CLTYPEG"] == TICL027.GENERAT
Subclaim Type
  • ?
  • Subclaim Type
  • Client
  • ?
  • ?
  • ICSSUBCL.[column in domain "ICL_CLTYPEG"] == TICL005.GENERAT
  • ICSSUBCL.SUBCLTYPE == TICL005.SUBCLTYPE
  • ICSSUBCL.CLIENT == TICL005.CLIENT
  • ICSSUBCL.[column in domain "ICL_CLTYPE"] == TICL005.CLTYPE
  • ICSSUBCL.[column in domain "ICL_CLTYPEV"] == TICL005.VERSION