I_InsurClmFactsItems

SFC Items | view: ICLSFCITEMS | Extraction: Not supported | Component: Claims Management

Tables used: ICLCLAIM, ICLLOSSDES, ICLLOSSDET, TBSFC002, TBSFC002T, TBSFC001, TBSFC001T

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (3)
Other (9)
🔗 Relations (8)

Column Name	Description
InsuranceClaim FK	Number of Claim
InsurClmFactCaptureCategory FK	Facts Capture Category
InsurFactsSubobject	ID of Claim Subobject
InsurClmFactCaptureQstn FK	Facts Capture: Question
InsurClmFactCaptureAnswer FK	Facts Capture: Answer
InsurClmFactsDraftUUID	16 Byte UUID in 16 Bytes (Raw Format)

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: Answer Facts Capture: Answer Facts Capture: Question Facts Capture: Question ? Variant of a Question Sequence Client Version of Question Sequence Facts Capture: Key of Question Sequence	`I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREANSWER == TBSFC002.ANSWER` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREANSWFOREDIT == TBSFC002.ANSWER` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC002.QUESTION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTN == TBSFC002.QUESTION` `I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC002.APPLICATION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVARIANT == TBSFC002.AVARIANT` `I_INSURCLMFACTSITEMS.MANDT == TBSFC002.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVERSION == TBSFC002.VERSION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC002.QUESEQ`
Facts Capture: Answer Facts Capture: Answer Facts Capture: Answer Facts Capture: Question Facts Capture: Question ? Variant of a Question Sequence Client Version of Question Sequence Facts Capture: Key of Question Sequence	`I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREANSWER == TBSFC002.ANSWER` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREANSWFOREDIT == TBSFC002.ANSWER` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC002.QUESTION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTN == TBSFC002.QUESTION` `I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC002.APPLICATION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVARIANT == TBSFC002.AVARIANT` `I_INSURCLMFACTSITEMS.MANDT == TBSFC002.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVERSION == TBSFC002.VERSION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC002.QUESEQ`
Facts Capture Category ? Client Facts Capture Category	`I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC004.APPLICATION` `I_INSURCLMFACTSITEMS.MANDT == TBSFC004.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURECATEGORY == TBSFC004.CATEGORY`
Facts Capture: Question ? Client Version of Question Sequence Facts Capture: Question Facts Capture: Key of Question Sequence	`I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC001.APPLICATION` `I_INSURCLMFACTSITEMS.MANDT == TBSFC001.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVERSION == TBSFC001.VERSION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURENEXTQSTN == TBSFC001.QUESTION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC001.QUESEQ`
Facts Capture: Question Facts Capture: Question Facts Capture: Question ? Client Version of Question Sequence Facts Capture: Key of Question Sequence	`I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC001.QUESTION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTN == TBSFC001.QUESTION` `I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC001.APPLICATION` `I_INSURCLMFACTSITEMS.MANDT == TBSFC001.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVERSION == TBSFC001.VERSION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC001.QUESEQ`
Facts Capture: Question Facts Capture: Question Facts Capture: Question ? Client Version of Question Sequence Facts Capture: Key of Question Sequence	`I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNFOREDIT == TBSFC001.QUESTION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTN == TBSFC001.QUESTION` `I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC001.APPLICATION` `I_INSURCLMFACTSITEMS.MANDT == TBSFC001.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVERSION == TBSFC001.VERSION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC001.QUESEQ`
Version of Question Sequence ? Client Version of Question Sequence Facts Capture: Key of Question Sequence	`I_INSURCLMFACTSITEMS.[column in domain "BSFC_APPLICATION"] == TBSFC000.APPLICATION` `I_INSURCLMFACTSITEMS.MANDT == TBSFC000.CLIENT` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTURESQNCVERSION == TBSFC000.VERSION` `I_INSURCLMFACTSITEMS.INSURCLMFACTCAPTUREQSTNSQNC == TBSFC000.QUESEQ`