I_InsurancePersonSpecification

Insurance Specification of Persons | view: IINSPSN | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_INS_PSN
Column Name Description
InsurancePersonUUID Insurance Person GUID
Column Name Description
💲 Currency (InsurancePersonSinglePremCrcy):
InsurancePersonSinglePremAmt Insurance one time Cntribution /Single Premium insurance
💲 Currency (InsurPersonOneTimeContrbnCrcy):
InsurPersnOneTmeContrbnAmt Undrawn(unused) one time contribution
Column Name Description
Column Name Description
InsurancePersonStatusDate Status date of insurance
InsurancePersonPremRenewalDate Renewal date(insurance premium)
Column Name Description
Column Name Description Domain name
InsuranceObjectUUID Insurance GUID SYSUUID
InsurancePersonName Name of the insured person CMS_INS_PER_NAME
InsurancePersonRankDesc Specification on the insurance rank of the person CMS_INS_SPEC_RNK_PRSN
InsurancePersonEnteredBy Login ID of the User who created the Record CMS_USER
InsurancePersonEnteredDateTime Creation Timestamp TZNTSTMPS
InsurancePersonLastChangedBy Last Changed By CMS_USER
InsurancePersonLastChgdDteTme Change Timestamp TZNTSTMPS
InsurancePersonEnteredSource Source of Entry CMS_SOURCE
InsuranceObjectCategory Object Category CMS_OBJ_CAT
Master Data Relations Join Conditions
Insured risk
  • ?
  • Insured risk
  • Client
  • I_INSURANCEPERSONSPECIFICATION.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_INSURANCEPERSONSPECIFICATION.INSURANCEPERSONRISK == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_INSURANCEPERSONSPECIFICATION.MANDT == TCMS_ATT_ID_TY.MANDT
Currency
  • Client
  • Currency
  • I_INSURANCEPERSONSPECIFICATION.MANDT == TCURC.MANDT
  • I_INSURANCEPERSONSPECIFICATION.INSURANCEPERSONSINGLEPREMCRCY == TCURC.WAERS
Status of insurance
  • ?
  • Client
  • Status of insurance
  • I_INSURANCEPERSONSPECIFICATION.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_INSURANCEPERSONSPECIFICATION.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_INSURANCEPERSONSPECIFICATION.INSURANCEPERSONSTATUS == TCMS_ATT_ID_TY.INDICATOR_TYPE
Currency
  • Client
  • Currency
  • I_INSURANCEPERSONSPECIFICATION.MANDT == TCURC.MANDT
  • I_INSURANCEPERSONSPECIFICATION.INSURPERSONONETIMECONTRBNCRCY == TCURC.WAERS