P_InsurClmNewlyOpenedSubclaim

Newly Opened Subclaims w/o Claim Handler (for No. of SCs) | view: PICLNEWOPNSUBCLM | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIMICLSUBCL
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmSubclm Subclaim
Column Name Description
Column Name Description
Column Name Description
CreationDate null
Column Name Description
InsurClmSubrogtnRecoveryStatus Subrogation/Recovery Status Show values
Column Name Description Domain name
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmSubclmStsChgdOnDteTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmSubclaimDescription Name of Claim/Subclaim TEXT20
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
Master Data Relations Join Conditions
Status of Subclaim
  • Client
  • Status of Subclaim
  • P_INSURCLMNEWLYOPENEDSUBCLAIM.MANDT == TICL140.CLIENT
  • P_INSURCLMNEWLYOPENEDSUBCLAIM.INSURCLMLIFECYCSTS == TICL140.STATUS
Subclaim Type
  • Client
  • Subclaim Type
  • P_INSURCLMNEWLYOPENEDSUBCLAIM.MANDT == TICL004.CLIENT
  • P_INSURCLMNEWLYOPENEDSUBCLAIM.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE