I_InsurClmTotExpndtrRsrvClm

Merge Reserve/Claim for Total Expenditure Query | view: IICLTOTEXPDRESCL | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPOLM, ICLCLAIMASSIGN, ICLPAY, ICLPAYI, ICLPOL, ICLRESERVE, ICLSUBCL, ICL_SUBROG, ICLPOL, TICL321, TICL055, TICL020, TICL020T, ICL_CSUBROGREAS
Column Name Description
InsurClmRsrvType FK Reserve Type
InsurClmLossExpnType Losses or Expenses Show values
InsurClmReserveCurrency FK Currency of Reserve (Transactn Crcy)
InsuranceClaim FK Number of Claim
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
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsuranceContract Contract Number ICL_POLICY
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmRsrvChangeTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL113.CLIENT
Coverage Type
  • Client
  • Coverage Type
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL322.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
Status of Claim
  • Client
  • Status of Claim
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL140.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMLIFECYCSTS == TICL140.STATUS
Policy Product
  • Client
  • Policy Product
  • ?
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • I_INSURCLMTOTEXPNDTRRSRVCLM.[column in domain "ICL_GENERAT"] == TICL320.VERSION
Currency of Reserve (Transactn Crcy)
  • Client
  • Currency of Reserve (Transactn Crcy)
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TCURC.MANDT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMRESERVECURRENCY == TCURC.WAERS
Reserve Type
  • Client
  • Reserve Type
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL020.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMRSRVTYPE == TICL020.RESTYPE
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL004.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • Client
  • Internal Claim Type
  • ?
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRRSRVCLM.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Generation of Internal Claim Type
  • Client
  • Internal Claim Type
  • Generation of Internal Claim Type
  • I_INSURCLMTOTEXPNDTRRSRVCLM.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRRSRVCLM.INSURCLMTYPEGENERATION == TICL011.VERSION