I_InsurClmPaymentCube

Data Cube View for Claim Payments | view: IICLPAYMENTCUBE | TRAN | Extraction: Not supported | Component: Claims Management
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmSubclm FK Subclaim of Payment
InsurClmPayt Number of Claim Payment
InsurClmPaytItem Claim Payment Item
Column Name Description
💲 Display Currency (DisplayCurrency):
InsurClmPaytAmt Payment Amount
Column Name Description
Column Name Description
InsurClmPaytPostgDte Posting Date
Column Name Description
InsurClmPaymentDatabaseStatus Internal Payment Status (Database Status) Show values
InsurClmPaytCat Record Type of Payment Show values
InsurClmPaymentType Payment Type (Final Payment, Payment After Closure of Claim) Show values
InsurClmLossExpnType Losses or Expenses Show values
Column Name Description Domain name
InsurClmItemSubclm Subclaim to Which a Payment Item Is Assigned CHAR3
InsurClmCoverageType Coverage Type ICL_COVTYPE
InsurClmPaytPostgYear Calendar Year NUM4
InsurClmPaytPostgQtr Year Quarter NUM5
InsurClmPaytPostgMnth Year Month NUM6
InsuranceContract Contract Number ICL_POLICY
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmPerformerObjID Object ID of Performer HROBJID_12
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmSubclaimPerformerObjID Object ID of Performer HROBJID_12
OrganizationalUnit Organizational Unit HR_SOBJID
ParentOrganizationalUnit Higher-Level Organizational Unit HROBJID
Master Data Relations Join Conditions
Benefit Type
  • Benefit Type
  • Client
  • I_INSURCLMPAYMENTCUBE.INSURBNFTTYPE == TICL055.BENTYPE
  • I_INSURCLMPAYMENTCUBE.MANDT == TICL055.CLIENT
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • I_INSURCLMPAYMENTCUBE.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMPAYMENTCUBE.MANDT == TICL113.CLIENT
Status of Claim
  • Internal Payment Status (Database Status)
  • Status of Claim
  • Client
  • I_INSURCLMPAYMENTCUBE.INSURCLMPAYMENTDATABASESTATUS == TICL140.STATUS
  • I_INSURCLMPAYMENTCUBE.INSURCLMLIFECYCSTS == TICL140.STATUS
  • I_INSURCLMPAYMENTCUBE.MANDT == TICL140.CLIENT
Claim Payment Currency
  • Claim Payment Currency
  • Client
  • I_INSURCLMPAYMENTCUBE.INSURCLMPAYMENTCURRENCY == TCURC.WAERS
  • I_INSURCLMPAYMENTCUBE.MANDT == TCURC.MANDT
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMPAYMENTCUBE.MANDT == TICL004.CLIENT
  • I_INSURCLMPAYMENTCUBE.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • ?
  • Internal Claim Type
  • Client
  • I_INSURCLMPAYMENTCUBE.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMPAYMENTCUBE.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMPAYMENTCUBE.MANDT == TICL011.CLIENT
Generation of Internal Claim Type
  • Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • I_INSURCLMPAYMENTCUBE.INSURCLMTYPEGENERATION == TICL011.VERSION
  • I_INSURCLMPAYMENTCUBE.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMPAYMENTCUBE.MANDT == TICL011.CLIENT