I_InsurClmSubclaim

Subclaim | view: IICLSUBCLAIM | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLSUBCL
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmSubclm Subclaim
Column Name Description
Column Name Description
Column Name Description
Column Name Description
InsurClmSubrogtnRecoveryStatus Subrogation/Recovery Status Show values
IsInProcess "Claim Handling" Process Active Show values
IsClosed "Close (Sub)Claim" Process Executed Show values
InsurClmCvrgConfirmedFlag Indication of Compensability Show values
InsurClmFraudFlag Flag: Potential Fraud? Show values
InsurClmSalvageFlag Flag: Salvage? Show values
InsurClmLitigationFlag Flag: Litigation? Show values
InsurClmNegotiationFlag Flag: Negotiation? Show values
InsurClmIsOtherInsurance Flag: Other Insurance? Show values
InsurClmSubrogtnPotential Subrogation/Recovery Potential of a Subclaim (Check Status) Show values
Column Name Description Domain name
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmSubclmStsChgdOnDteTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmSubclaimDescription Name of Claim/Subclaim TEXT20
InsurClmBenefitTypeTree Benefit Type Tree ICL_BENTREE
InsurClmBnftTypeTreeGeneration Generation of Benefit Type Tree ICL_BENTREEG
InsurClmBnftTypeTreeVersion Version of Benefit Type Tree ICL_BENTREEV
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
Master Data Relations | to Other Relations ↓ Join Conditions
Status of Subclaim
  • Status of Subclaim
  • Client
  • I_INSURCLMSUBCLAIM.INSURCLMLIFECYCSTS == TICL140.STATUS
  • I_INSURCLMSUBCLAIM.MANDT == TICL140.CLIENT
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMSUBCLAIM.MANDT == TICL004.CLIENT
  • I_INSURCLMSUBCLAIM.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Complexity of Claim/Subclaim
  • ?
  • ?
  • ?
  • Client
  • Subclaim Type
  • Complexity of Claim/Subclaim
  • I_INSURCLMSUBCLAIM.[column in domain "ICL_CLTYPEG"] == TICL027.GENERAT
  • I_INSURCLMSUBCLAIM.[column in domain "ICL_CLTYPEV"] == TICL027.VERSION
  • I_INSURCLMSUBCLAIM.[column in domain "ICL_CLTYPE"] == TICL027.CLTYPE
  • I_INSURCLMSUBCLAIM.MANDT == TICL027.CLIENT
  • I_INSURCLMSUBCLAIM.INSURCLMSUBCLMTYPE == TICL027.SUBCLTYPE
  • I_INSURCLMSUBCLAIM.INSURCLMCOMPLEXITY == TICL027.COMPLEX
Reason for Changing the Status
  • ?
  • ?
  • ?
  • Reason for Changing the Status
  • Status of Subclaim
  • Client
  • Subclaim Type
  • I_INSURCLMSUBCLAIM.[column in domain "ICL_CLTYPEV"] == TICL047.VERSION
  • I_INSURCLMSUBCLAIM.[column in domain "ICL_CLTYPEG"] == TICL047.GENERAT
  • I_INSURCLMSUBCLAIM.[column in domain "ICL_CLTYPE"] == TICL047.CLTYPE
  • I_INSURCLMSUBCLAIM.INSURCLMSUBCLMSTSRSN == TICL047.FORMOFSET
  • I_INSURCLMSUBCLAIM.INSURCLMLIFECYCSTS == TICL047.STATUS
  • I_INSURCLMSUBCLAIM.MANDT == TICL047.CLIENT
  • I_INSURCLMSUBCLAIM.INSURCLMSUBCLMTYPE == TICL047.SUBCLTYPE