I_InsurClm1stNotifFactDeltdTP

Notice of Loss - Facts | view: ICL1STNFFACTDTP | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLLOSSDES, ICLLOSSDET, TBSFC002, TBSFC002T, TBSFC001, TBSFC001T
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmFactCaptureCategory FK Facts Capture Category
InsurClmSubobject ID of Claim Subobject
InsurClmFactCaptureQstn FK Facts Capture: Question
InsurClmFactCaptureAnswer FK Facts Capture: Answer
Column Name Description
Column Name Description
Column Name Description
Column Name Description
InsurClmFactFreeTextAnswerCat Category for User-Defined Text Input Show values
InsurClmFactCaptureQstnCat Structure Facts Capture: Question Category Show values
InsurClmFactQstnIsMltplChoice Flag: Multiple Answers Allowed? Show values
Column Name Description Domain name
InsurClmFactCaptureQstnPos Position of Question in Sequence NUMC3
InsurClmFactCaptureQstnSqnc Facts Capture: Key of Question Sequence BSFC_QUESEQ
InsurClmFactCaptureSqncVariant Variant of a Question Sequence NUMC02
InsurClmFactCaptureQstnShrtTxt Facts Capture: Question Short Text TEXT30
InsurClmFactCaptureQstnLongTxt Facts Capture: Question Long Text TEXT80
InsurClmFactAnswerShortText Structured Facts Capture: Answer Short Text TEXT30
InsurClmFactAnswerLongText Structured Facts Capture: Answer Long Text TEXT254
InsurClmFactCaptureTextAnswer Free Format Answer Text ICL_ANSWERN
InsurClmFactUsrSeldAnswerKeys Free Format Answer Text ICL_ANSWERN
Master Data Relations Join Conditions
Facts Capture: Answer
  • ?
  • Facts Capture: Key of Question Sequence
  • Version of Question Sequence
  • Variant of a Question Sequence
  • Client
  • Facts Capture: Answer
  • Facts Capture: Answer
  • Facts Capture: Question
  • Facts Capture: Question
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC002.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC002.QUESEQ
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVERSION == TBSFC002.VERSION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVARIANT == TBSFC002.AVARIANT
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC002.CLIENT
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREANSWER == TBSFC002.ANSWER
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREANSWFOREDIT == TBSFC002.ANSWER
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC002.QUESTION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTN == TBSFC002.QUESTION
Facts Capture: Answer
  • ?
  • Facts Capture: Key of Question Sequence
  • Version of Question Sequence
  • Variant of a Question Sequence
  • Client
  • Facts Capture: Answer
  • Facts Capture: Answer
  • Facts Capture: Question
  • Facts Capture: Question
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC002.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC002.QUESEQ
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVERSION == TBSFC002.VERSION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVARIANT == TBSFC002.AVARIANT
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC002.CLIENT
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREANSWER == TBSFC002.ANSWER
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREANSWFOREDIT == TBSFC002.ANSWER
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC002.QUESTION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTN == TBSFC002.QUESTION
Facts Capture Category
  • ?
  • Client
  • Facts Capture Category
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC004.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC004.CLIENT
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURECATEGORY == TBSFC004.CATEGORY
Facts Capture: Question
  • ?
  • Facts Capture: Question
  • Facts Capture: Key of Question Sequence
  • Version of Question Sequence
  • Client
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC001.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURENEXTQSTN == TBSFC001.QUESTION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC001.QUESEQ
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVERSION == TBSFC001.VERSION
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC001.CLIENT
Facts Capture: Question
  • ?
  • Facts Capture: Key of Question Sequence
  • Version of Question Sequence
  • Client
  • Facts Capture: Question
  • Facts Capture: Question
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC001.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC001.QUESEQ
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVERSION == TBSFC001.VERSION
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC001.CLIENT
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC001.QUESTION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTN == TBSFC001.QUESTION
Facts Capture: Question
  • ?
  • Facts Capture: Key of Question Sequence
  • Version of Question Sequence
  • Client
  • Facts Capture: Question
  • Facts Capture: Question
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC001.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC001.QUESEQ
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVERSION == TBSFC001.VERSION
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC001.CLIENT
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC001.QUESTION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTN == TBSFC001.QUESTION
Version of Question Sequence
  • ?
  • Facts Capture: Key of Question Sequence
  • Version of Question Sequence
  • Client
  • I_INSURCLM1STNOTIFFACTDELTDTP.[column in domain "BSFC_APPLICATION"] == TBSFC000.APPLICATION
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC000.QUESEQ
  • I_INSURCLM1STNOTIFFACTDELTDTP.INSURCLMFACTCAPTURESQNCVERSION == TBSFC000.VERSION
  • I_INSURCLM1STNOTIFFACTDELTDTP.MANDT == TBSFC000.CLIENT