SAP ABAP Table ICLSC_DI_INT (Enhancement DI Structure Benefit/Charges Catalog)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_SERVICE_CATALOG (Package) FS-CM: Benefits/Services/Fees Catalog

Basic Data

Table Category	INTTAB	Structure
Structure	ICLSC_DI_INT	Table Relationship Diagram
Short Description	Enhancement DI Structure Benefit/Charges Catalog

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ORG_INDEX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
2	.INCLUDE	☐				0	0	DI Rec. Structure for Appl. Object ICLB (Ben./Charge Cat.)
3	.INCLUDE	☐				0	0	ICLB: Header Data for Direct Input
4	.INCLUDE	☐				0	0	BDT: General Header Data (Direct Input)
5	AKTYP	☐	BU_AKTYP	BU_AKTYP	CHAR	2	0	Activity Category	*
6	RLTP1	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
7	RLTP2	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
8	RLTP3	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
9	RLTP4	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
10	RLTP5	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
11	RLTP6	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
12	RLTP7	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
13	RLTP8	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
14	RLTP9	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
15	.INCLUDE	☐				0	0	ICLB: Header Data for Direct Input
16	SERVCATID	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
17	SC_VARIANT	☐	ICL_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Variant of a Benefits/Services/Fee Catalog	*
18	SCPOSID_EXT	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
19	SCPOS_TYPE_ENTRY	☐	ICL_SERVCAT_POS_TYPE	ICL_SERVCAT_POS_TYPE	CHAR	4	0	Type of Benefits Catalog Item	*
20	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
21	VALID_TIME	☐	ICL_TIMESTAMP_DI		CHAR	15	0	UTZ Time Stamp in Short Form
22	.INCLUDE	☐				0	0	ICLB: Workers Compensation Header Data for Direct Input
23	.INCLUDE	☐				0	0	Workers Compensation - Benefits Catalag (Ext.Catalog Item)
24	COUNTRY	☐	ICL_JURICOUNTRY	LAND1	CHAR	3	0	Jurisdiction Country	T005
25	REGION	☐	ICL_JURISREGION	REGIO	CHAR	3	0	Jurisdiction Region	T005S
26	DISABILITY_CLASS	☐	ICL_DISABILITY_CLASS	ICL_DISABILITY_CLASS	CHAR	2	0	Disability Class	TICL460
27	.INCLUDE	☐				0	0	DI Structure for Table ICLSERVCAT
28	CHIND_HEAD	☐	BU_CHIND	BU_CHIND	CHAR	1	0	Change category
29	SCPOS_CURR	☐	ICL_CUKY_DI		CHAR	5	0	Currency (Direct Input)
30	SCPOS_TYPE	☐	ICL_SERVCAT_POS_TYPE	ICL_SERVCAT_POS_TYPE	CHAR	4	0	Type of Benefits Catalog Item	*
31	SCPOS_XSEL	☐	ICL_SERVCAT_POS_SELECTABLE	XFELD	CHAR	1	0	Entry Lock for Benefits Catalog Item
32	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	*
33	BENTYPE_EXP	☐	BRF_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF: Expression	*
34	SCPOS_QUANTITY	☐	ICL_QUANT_DI	CHAR10	CHAR	10	0	Quantity
35	SCPOS_QUANTITYTO	☐	ICL_QUANT_DI	CHAR10	CHAR	10	0	Quantity
36	SCPOS_QUANUNIT	☐	ICL_UNIT_DI	CHAR03	CHAR	3	0	Unit
37	SCPOS_VALPERUNIT	☐	ICL_SERVCAT_POS_VALPERUNIT_DI	CHAR20	CHAR	20	0	Value per Unit of Benefits Catalog Item (Direct Input)
38	SCPOS_XREIMBURSE	☐	ICL_SERVCAT_POS_REIMBURSABLE	ICL_SERVCAT_POS_REIMBURSABLE	CHAR	1	0	Reimbursability of a Benefits Catalog Item
39	SCPOS_XAPPROVAL	☐	ICL_SERVCAT_POS_APPROVAL	XFELD	CHAR	1	0	Approval Requirement of a Benef/Serv/Fees Catalog Item
40	SCPOSN	☐	ICL_SERVCAT_POS_SHORTNAME	TEXT30	CHAR	30	0	Short Text of a Benefits Catalog Item
41	SCPOSLN	☐	ICL_SERVCAT_POS_NAME	TEXT100	CHAR	100	0	Long Text of Benefits Catalog Item
42	SCPOSXLN	☐	ICL_SERVCAT_POS_XLONG_TEXT	TEXT255	CHAR	255	0	Description of Benefits Catalog Item
43	EFFFROMDA	☐	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
44	EFFFROMTI	☐	ICL_TIME_DI		CHAR	6	0	Time (Direct Input)
45	EFFTODA	☐	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
46	EFFTOTI	☐	ICL_TIME_DI		CHAR	6	0	Time (Direct Input)
47	.INCLUDE	☐				0	0	DI Structure for Hospital-Specific Data
48	RV	☐	ICL_SERVCAT_RV_DI_D_PE		CHAR	10	0	Relative Value
49	RVU	☐	ICL_SERVCAT_RVU_DI_D_PE		CHAR	3	0	Unit of Measure of Relative Value
50	AVLENGTH	☐	ICL_SERVCAT_AVLENG_DI_D_PE		CHAR	3	0	Average Length of Stay
51	DEDUCTION	☐	ICL_SERVCAT_DEDUCTION_DI_D_PE		CHAR	3	0	First Day of Markdown
52	SURCHARGE	☐	ICL_SERVCAT_SURCHARGE_DI_D_PE		CHAR	3	0	First Day of Markup
53	LOCALIZATION	☐	ICL_LOCALIZATION	ICL_LOCALIZATION	CHAR	1	0	Side Localization of a Diagnosis	*
54	CATAID	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	*
55	DIAGID	☐	ICL_MDCPOSID_D_PE	ICL_DIAGID	CHAR	10	0	Code of an MDC Item	*
56	.INCLUDE	☐				0	0	DI Structure for Note Text
57	CHIND_HINT	☐	BU_CHIND	BU_CHIND	CHAR	1	0	Change category
58	SCPOSHINT	☐	ICL_SERVCAT_POS_TXT_D_PE	ICL_SERVCAT_POS_TXT_D_PE	CHAR	100	0	Benefits Catalog Text Field
59	.INCLUDE	☐				0	0	DI Structure for Table ICLSCATTRIB
60	CHIND_ATTRIB	☐	BU_CHIND	BU_CHIND	CHAR	1	0	Change category
61	SC_ATTRIBUT	☐	ICL_SERVCAT_ATTRIBUT	FDNAME	CHAR	30	0	Attributes of a Services/Benefits/Fees Catalog	*
62	SEQ_NO	☐	ICL_SERVCAT_ATTRIBUT_SEQNO_DI		CHAR	5	0	Seq. Number Benefit/Services/Fees Catalog Attribute (DI)
63	VALUE	☐	ICL_SERVCAT_ATTRIBUT_VALUE		CHAR	80	0	Attribute Values of a Benefits/Services/Fees Catalog
64	.INCLUDE	☐				0	0	DI Structure for Workers Compensation Benefits Catalog
65	.INCLUDE	☐				0	0	Workers Comp - Benefit Catalog Data - Loss of Wages
66	SAWW	☐	ICL_SAWW_AMT_DI	CHAR20	CHAR	20	0	State Average Weekly Wage (AWW)
67	BENEFIT_RULE	☐	ICL_BEN_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Benefit	*
68	MAX_BEN	☐	ICL_MAX_AMT_DI	CHAR20	CHAR	20	0	Maximum Amount
69	MAX_RULE	☐	ICL_MAX_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Maximum Weekly Benefit	*
70	MIN_BEN	☐	ICL_MIN_AMT_DI	CHAR20	CHAR	20	0	Minimum Amount
71	MIN_RULE	☐	ICL_MIN_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Minimum Weekly Benefit	*
72	WAITING_PERIOD	☐	ICL_WAITINGPRD_DI	CHAR4	CHAR	4	0	Waiting Period
73	RETRO_PERIOD	☐	ICL_RETROPRD_DI	CHAR4	CHAR	4	0	Retroactive Period
74	MAX_PERIOD	☐	ICL_MAXPRD_DI		CHAR	4	0	Maximum Benefit Period in Weeks
75	MAX_TOTAL	☐	ICL_MAX_PYMNT_DI	CHAR20	CHAR	20	0	Maximum Payment Amount
76	FORMULA	☐	ICL_WC_FORM	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Overall Benefit	*
77	.INCLUDE	☐				0	0	Workers Comp - Benefits Catalog Injuries DI
78	TOTAL_SCHED	☐	ICL_WCMP_OVERALL_SCHED	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Determining Total Weeks	TBRF150
79	SCH_SERVCATID	☐	ICL_WCMP_SCH_SERVCATID	ICL_SERVCATID	CHAR	10	0	Scheduled Benefits Catalog for Injuries	TICL401
80	SCH_SC_VARIANT	☐	ICL_WCMP_SCH_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Scheduled Benefits Catalog Variant for Injuries	TICL402
81	.INCLUDE	☐				0	0	Workers Comp - Benefits Catalog Death DI
82	SPOUSE_CHILD_BEN	☐	ICL_SPS_CHLD_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Spouse and Child Rule	*
83	SPOUSE_ONLY_BEN	☐	ICL_SPS_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Spouse Rule	*
84	ONE_CHILD_BEN	☐	ICL_CHLD_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Child Rule	*
85	MAX_SPSECHLD_AMT	☐	ICL_SPSECHLD_AMT_DI	CHAR20	CHAR	20	0	Maximum Weekly Amount for Spouse and Child
86	MAX_SPSEONLY_AMT	☐	ICL_SPSEONLY_AMT_DI	CHAR20	CHAR	20	0	Maximum Weekly Amount for Spouse
87	MIN_SPSEONLY_AMT	☐	ICL_SPSE_MIN_AMT_DI	CHAR20	CHAR	20	0	Minimum Amount for Spouse
88	AMOUNT_LIMIT_SC	☐	ICL_MAX_AMT_SC_DI	CHAR20	CHAR	20	0	Amount Limit for Spouse Plus Child in Total
89	AMOUNT_LIMIT_SO	☐	ICL_MAX_AMT_SO_DI	CHAR20	CHAR	20	0	Amount Limit for Spouse
90	TIME_LIMIT	☐	ICL_MAXPRD_DI		CHAR	4	0	Maximum Benefit Period in Weeks
91	BURIAL_AMOUNT	☐	ICL_BURIAL_AMT_DI	CHAR20	CHAR	20	0	Workers Compensation: Burial Amount
92	CHILD_MAX_AGE	☐	ICL_CHILD_MAX_AGE_DI		CHAR	4	0	Maximum Age of Child
93	STDNT_MAX_AGE	☐	ICL_STDNT_MAX_AGE_DI		CHAR	4	0	Maximum Age for Student
94	TRANSPORTN_MAX	☐	ICL_TRNSPT_MAX_DI	CHAR20	CHAR	20	0	Maximum Amount for Transport
95	LUMP_SUM	☐	ICL_LUMP_SUM_DI	CHAR20	CHAR	20	0	Lump Sum
96	FORMULA_DTH	☐	ICL_WC_FORM	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Overall Benefit	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLSC_DI_INT	COUNTRY	T005	LAND1
2	ICLSC_DI_INT	DISABILITY_CLASS	TICL460	DISABILITY_CLASS
3	ICLSC_DI_INT	REGION	T005S	BLAND
4	ICLSC_DI_INT	SCH_SC_VARIANT	TICL402	SC_VARIANT
5	ICLSC_DI_INT	SCH_SERVCATID	TICL401	SERVCATID
6	ICLSC_DI_INT	TOTAL_SCHED	TBRF150	EXPRESSION

History

Last changed by/on	SAP	20130529
SAP Release Created in	473