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