I_InsurClmLossReportCube

Data Cube View for Loss Triangle | view: IICLLOSSTRGCUBE | TRAN | Extraction: Not supported | Component: Claims Management
Column Name Description
Column Name Description
💲 null (DisplayCurrency):
InsurClm12MnthPaidLossAmt Total Amount in Claim Date Year
InsurClm24MnthPaidLossAmt Total Amount in Claim Date Year and in Next Year
InsurClm36MnthPaidLossAmt Total Amount in Claim Date Year and in Next Two Years
InsurClm48MnthPaidLossAmt Total Amount in Claim Date Year and in Next Three Years
InsurClm60MnthPaidLossAmt Total Amount in Claim Date Year and in Next Four Years
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
InsurClmOccrncYear Year of Claim Date NUM4
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
Master Data Relations Join Conditions
Authorization Group for Claims (VIP)
  • Client
  • Authorization Group for Claims (VIP)
  • I_INSURCLMLOSSREPORTCUBE.MANDT == TICL113.CLIENT
  • I_INSURCLMLOSSREPORTCUBE.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Coverage Type
  • Client
  • Coverage Type
  • I_INSURCLMLOSSREPORTCUBE.MANDT == TICL322.CLIENT
  • I_INSURCLMLOSSREPORTCUBE.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMLOSSREPORTCUBE.MANDT == TICL004.CLIENT
  • I_INSURCLMLOSSREPORTCUBE.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • Internal Claim Type
  • Client
  • ?
  • I_INSURCLMLOSSREPORTCUBE.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMLOSSREPORTCUBE.MANDT == TICL011.CLIENT
  • I_INSURCLMLOSSREPORTCUBE.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • I_INSURCLMLOSSREPORTCUBE.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMLOSSREPORTCUBE.MANDT == TICL011.CLIENT
  • I_INSURCLMLOSSREPORTCUBE.INSURCLMTYPEGENERATION == TICL011.VERSION