ICSCLAIM - Claim

Claim information is stored in SAP table ICSCLAIM.
It is part of development package ICL_CDC in software component FS-CM. This development package consists of objects that can be grouped under "FS-CM: Data Capture".

Fields for table ICSCLAIM

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6T000
ACTIVETable entry is active (A) or in suspense (S)XICL_ACTIVECHAR2
CLAIMNumber of ClaimXICL_CLAIMCHAR34
CHANGETIMEChanged: Date + TimeXICL_CHANGEUTC1DEC8
.INCLUDEICL_INCL_VER60
CHANGEDBYChanged ByICL_CHANGEDBYCHAR24USR02
DELETEDDatabase Line Status (Original, Changed, Deleted)ICL_RECSTATUSCHAR2
.INCLUDEICS_CLAIM0
.INCLUDEICL_INCL_ORG30
CREATEDBYCreated ByICL_CREATEDBYCHAR24USR02
CREATETIMECreated: Date + TimeICL_CREATEUTCDEC8
ACHANGEDBYWhole Claim Last Changed ByICL_ACHANGEDBYCHAR24USR02
ACHANGETIMEWhole Claim Last Changed AtICL_ACHANGETIMEDEC8
EXCLAIMNOCATExternal Number CategoryICL_CLAIMNOCATCHAR2
EXCLAIMNOExternal NumberICL_CLAIMNOCHAR46
STATUSStatus of ClaimICL_CLSTATUSCHAR4TICL140
STATUSCHGDate and Time of Last Status ChangeICL_STATUSCHGDEC8
STHANDLER"Claim Handling" Process ActiveICL_STHANDLERCHAR2
STNOCLAIMNo Claim MadeICL_STNOCLAIMCHAR2
STCLOSED"Close (Sub)Claim" Process ExecutedICL_STCLOSEDCHAR2
STATREASONReason for Changing the StatusICL_FORMSETCHAR4*
LOSSTYPEIncident Type of a ClaimICL_LOSSTYPECHAR8TICL062
CLAIMTYPEInternal Claim TypeICL_CLTYPECHAR8TICL011
CLTYPEGGeneration of Internal Claim TypeICL_CLTYPEGNUMC10TICL011
CLTYPEVInternal Claim Type VersionICL_CLTYPEVNUMC10TICL003
LOSSEVENTCumulative EventICL_LOSSEVENTCHAR34ICLCCEVENT
POLPRODPolicy ProductICL_POLPRODCHAR12TICL320
GENERATPolicy Product GenerationICL_GENERATNUMC10TICL320
VERSIONPolicy Product VersionICL_POLPRODVNUMC10TICL321
LRENEWALLast Renewal of Contract Before Claim Date/TimeICL_LRENEWALDEC8
POLICYContract NumberICL_POLICYCHAR34
LOSSCAUSECause of Loss/ClaimICL_LOSSCAUSECHAR6TICL009
PERILPerilICL_PERILCHAR8
DATELOSSDate of Loss/ClaimICL_LOSSDATEDATS16
TIMELOSSTime of Claim/LossICL_LOSSTIMETIMS12
LTIMEZONETime Zone of Claim/Loss EventICL_LTIMEZONECHAR12TTZZ
XDATEESTIMDate Is EstimateICL_XLOSSDATECHAR2
DATECHANGERReason for Changing Claim DateICL_DATECHANGERCHAR4TICL029
LOSSREPCOMPADate Claim Reported to Insurance CompanyICL_LOSSREPCOMPADATS16
LOSSREPAGENTDate on Which Claim Was Reported to AgentICL_LOSSREPAGENTDATS16
LOSSADDRESSLoss LocationICL_LOSSADDRESSCHAR20ADRC
XAUTHREPClaim/Loss Reported to AuthorityICL_XAUTHREPCHAR2
XSENSITIVESensitive Claim?ICL_CLAIMSENSCHAR2
COMPLEXComplexity of Claim/SubclaimICL_COMPLEXCHAR2TICL027
JURISCOUNTRYCountry/Region of JurisdictionICL_JURICOUNTRYCHAR6T005
JURISREGIONJurisdiction RegionICL_JURISREGIONCHAR6T005S
ASSIGN_STATEAssignment Status of a Claim SubobjectICL_ASSIGN_STATECHAR4
OWNERTYPEObject Type of Claim HandlerICL_OWNERTYPECHAR4T778O
OWNERID of Claim HandlerICL_CLAIMOWNERCHAR24
OWNERTYPE_GRPObject Type of Claim Handler GroupICL_OWNERTYPE2CHAR4*
OWNER_GRPClaim Handler GroupICL_CLAIMOWNER2CHAR24
XCUMULClaim Assigned to an AggregateICL_XCUMULCHAR2
VIEWFAULTFault of Policyholder from Point of View of InsurerICL_VIEWFAULTICHAR2TICL081
VIEWFAULTPHParty at Fault from Point of View of PolicyholderICL_VIEWFAULTPHCHAR2TICL081
TPNOThird Party Count (NOT USED)ICL_TPNONUMC4
XTPKNOWNFlag: Third Party Known?ICL_TPKNOWNCHAR2
COVEREDIndication of CompensabilityICL_COVEREDCHAR2
AUTHCLMAuthorization Group for Claims (VIP)ICL_AUTHCLMCHAR8TICL113
XCLAIMBEntry in ICLCLAIMB ExistsICL_XCLAIMBCHAR2
XNONOTIFProcessing Not Possible in Notification ModeICL_XNONOTIFCHAR2
XRESERVEAt Least One Reserve Exists in ClaimICL_XRESERVECHAR2
BENTREEBenefit Type TreeICL_BENTREECHAR16*
BENTREEGGeneration of Benefit Type TreeICL_BENTREEGNUMC10*
BENTREEVVersion of Benefit Type TreeICL_BENTREEVNUMC10*
WF_EXEC_TIMEExecution Time WorkflowICL_WF_EXECUTION_TIMEDEC8
WF_STATUSWorkflow StatusICL_WF_STATUSNUMC2
XDUMMYCLAIMClaim Is Dummy ClaimICL_XDUMMYCLAIMCHAR2
VERCHNGUTCTime for Reading VersionICL_VERCHNGUTCDEC8
OPENDATEOpened OnICL_OPENDATEDATS16
XWITHOUT_PRODUCTUse of Scenario Without Product CustomizingICL_XWITHOUTPRODUCT_DCHAR2
MAX_ITEMNRCurrent Highest Claim Item NumberICL_SCLITEM_NR_MAXCHAR8*
ASSIGN_GUIDUUID of Entry to be LinkedICL_ASSIGN_GUIDCHAR64
SIF_STATUSStatus of Second Injury FundICL_SIF_STATUS_DCHAR2
INVSTG_STATUSClaim Investigation Match StatusICL_INVSTG_MATCH_STATUS_D_PECHAR2
.INCLUDEICL_CLAIM_AS_DB0
EFFECTIVE_DTContract Validity DateICL_EFFECTIVE_DT_DDATS16
LOSSREP_DTDate on Request for Insurance BenefitICL_LOSSREP_DT_DDATS16
LUMPSUMOPTIONOption ExercisedICL_LUMPSUMOPTION_DCHAR2
STATPENSIONType of Statutory PensionICL_STATPENSION_DCHAR6*
WITHDRAWAMRequested Total Withdrawal AmountICL_WITHDRAWAM_DCURR8
WITHDRAWCURRCurrency of Withdrawal AmountICL_WITHDRAWCURR_DCUKY10*
WITHDRAWSEQWithdrawal SequenceICL_WITHDRAWSEQ_DCHAR6*
ALTERNATEBENDisplay Alternative Benefit ValuesICL_ALTERNATEBEN_DCHAR2
GENERATENOTIFMake Special Risk NotificationICL_GENERATENOTIF_DCHAR2
NOTIFREASONReason for Special Risk NotificationICL_NOTIFREASON_DCHAR6
AUTFOLLOWUPAutomatic ResubmissionICL_AUTFOLLOWUP_DCHAR2
FOLLOWUP_DTDate of Automatic ResubmissionICL_FOLLOWUP_DT_DDATS16
PROCESSING_DTProcessing OnICL_PROCESSING_DT_DDATS16
STATUSOBJIDObject numberJ_OBJNRCHAR44*
DUNNLEVELDunning StatusICL_DUNNLEVEL_DCHAR4
CLEARDATEPremium Paid Up ToICL_CLEARDATE_DDATS16
PREMBALANAMPremium BalanceICL_PREMBALANAM_DCURR8
PREMBALANAMCURRCurrency of Premium PaymentICL_PREMBALANAMCURR_DCUKY10*
WITHDRAWTYPEWithdrawal TypeICL_WITHDRAWTYPE_DCHAR6*
REACT_DTDate of Occupational Disability/Perm.Incap.to Wk ReactivatnICL_REACT_DT_DDATS16
GENNOTIFTIMESpecial Risk Message Submitted OnICL_GENERATENOTIFTIME_DDEC8
BEN_CALC_FAILTime of Last Incorrect Benefit CalculationICL_BEN_CALC_FAIL_DDEC8
POLSYSTEMTechnical Key of Policy SystemICL_POLSYSTEM_DCHAR16
.INCLUDEEXTICL_ICLCLAIM_FNOL0
DUMMY_FNOLDummy function in length 1DUMMYCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
.INCLUDEICLVDM_CLAIM_INCL_EEW_PS0
DUMMY_ICLVDM_CLAIM_INCL_EEW_PSCustom Fields: Dummy for Use in Extension IncludesCFD_DUMMYCHAR2
.INCLUDEICLVDM_CLAIMINQ_INCL_EEW_PS0
DUMMY_ICLVDM_CLINQ_INCL_EEW_PSCustom Fields: Dummy for Use in Extension IncludesCFD_DUMMYCHAR2
.INCLUDEAFX_STATUS_DATA_EXT0
ARCHIVE_STATUSArchiving StatusTYP_ARCHIVE_STATUSCHAR2
ARCHIVE_FLUDResubmission DateTYP_ARCHIVE_FLUDDATS16
REJECTIONRejection ReasonTYP_REJECTIONCHAR4
Privacy Policy