I_InsurClmTotExpndtrClmAssgmt

Main Data Collection with Assignment | view: IICLTOTEXCLASGMT | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: SCAL_TT_DATE, ICLCLAIM, ICLPOLM, ICLCLAIMASSIGN, ICLPAY, ICLPAYI, ICLPOL, ICLRESERVE, ICLSUBCL, ICL_RBP, ICL_SUBROG, TICL321, TICL055, TICL020, TICL020T, ICL_CSUBROGREAS
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmLossExpnType Losses or Expenses Show values
InsurClmRsrvType FK Reserve Type
InsurClmReserveCurrency FK Currency of Reserve (Transactn Crcy)
InsurClmSubclm FK Subclaim
Column Name Description
GrossReserveAmount Total Reserve
InsurClmTotExpndtrAmt Total Reserve
Column Name Description
Column Name Description
InsurClmChangeDate null
Column Name Description
InsurClmLossExpnType Losses or Expenses Show values
Column Name Description Domain name
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmSubclaimPerformerObjID Object ID of Performer HROBJID_12
InsurClmPerformerObjID Object ID of Performer HROBJID_12
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsuranceContract Contract Number ICL_POLICY
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmRsrvChangeTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
YearQuarter Year Quarter NUM5
Master Data Relations Join Conditions
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL113.CLIENT
Coverage Type
  • Coverage Type
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL322.CLIENT
Status of Claim
  • Status of Claim
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMLIFECYCSTS == TICL140.STATUS
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL140.CLIENT
Policy Product
  • ?
  • Client
  • Policy Product
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Currency of Reserve (Transactn Crcy)
  • Currency of Reserve (Transactn Crcy)
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMRESERVECURRENCY == TCURC.WAERS
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TCURC.MANDT
Reserve Type
  • Reserve Type
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMRSRVTYPE == TICL020.RESTYPE
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL020.CLIENT
Subclaim Type
  • Subclaim Type
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL004.CLIENT
Internal Claim Type
  • ?
  • Internal Claim Type
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL011.CLIENT
Generation of Internal Claim Type
  • Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMTYPEGENERATION == TICL011.VERSION
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRCLMASSGMT.MANDT == TICL011.CLIENT