I_InsurClmTotExpndtrAnalytics

Main Data Collection for Total Expenditure Query | view: IICLTOTEXPAN | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: SCAL_TT_DATE, ICLCLAIM, ICLPOLM, ICLCLAIMASSIGN, ICLPAY, ICLPAYI, ICLPOL, ICLRESERVE, ICLSUBCL, ICL_SUBROG, ICLPOL, 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
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsuranceContract Contract Number ICL_POLICY
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
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_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL113.CLIENT
Coverage Type
  • Client
  • Coverage Type
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL322.CLIENT
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
Status of Claim
  • Client
  • Status of Claim
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL140.CLIENT
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMLIFECYCSTS == TICL140.STATUS
Policy Product
  • Client
  • Policy Product
  • ?
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • I_INSURCLMTOTEXPNDTRANALYTICS.[column in domain "ICL_GENERAT"] == TICL320.VERSION
Currency of Reserve (Transactn Crcy)
  • Currency of Reserve (Transactn Crcy)
  • Client
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMRESERVECURRENCY == TCURC.WAERS
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TCURC.MANDT
Reserve Type
  • Reserve Type
  • Client
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMRSRVTYPE == TICL020.RESTYPE
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL020.CLIENT
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL004.CLIENT
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • Internal Claim Type
  • Client
  • ?
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRANALYTICS.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRANALYTICS.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRANALYTICS.INSURCLMTYPEGENERATION == TICL011.VERSION