SAP ABAP Table ICL_SCWCOMP (Workers Comp - Benefits Catalog)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_WCOMP (Package) Workers Compensation
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_WCOMP (Package) Workers Compensation
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_SCWCOMP | Table Relationship Diagram |
Short Description | Workers Comp - Benefits 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 | COUNTRY | ICL_JURICOUNTRY | LAND1 | CHAR | 3 | 0 | Jurisdiction Country | * | |
2 | REGION | ICL_JURISREGION | REGIO | CHAR | 3 | 0 | Jurisdiction Region | * | |
3 | DISABILITY_CLASS | ICL_DISABILITY_CLASS | ICL_DISABILITY_CLASS | CHAR | 2 | 0 | Disability Class | * | |
4 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
5 | .INCLUDE | 0 | 0 | Workers Comp - Benefits Catalog | |||||
6 | SAWW | ICL_SAWW_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | State Average Weekly Wage (AWW) | ||
7 | BENEFIT_RULE | ICL_BEN_RULE | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Deriving Benefit | * | |
8 | MAX_BEN | ICL_MAX_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | Maximum Amount | ||
9 | MAX_RULE | ICL_MAX_RULE | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Deriving Maximum Weekly Benefit | * | |
10 | MIN_BEN | ICL_MIN_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | Minimum Amount | ||
11 | MIN_RULE | ICL_MIN_RULE | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Deriving Minimum Weekly Benefit | * | |
12 | WAITING_PERIOD | ICL_WAITINGPRD | NUMC4 | NUMC | 4 | 0 | Waiting Period | ||
13 | RETRO_PERIOD | ICL_RETROPRD | NUMC4 | NUMC | 4 | 0 | Retroactive Period | ||
14 | MAX_PERIOD | ICL_MAXPRD | NUMC | 4 | 0 | Maximum Benefit Period in Weeks | |||
15 | MAX_TOTAL | ICL_MAX_PYMNT | ICL_RESAMOUNT | CURR | 15 | 2 | Maximum Payment Amount | ||
16 | FORMULA | ICL_WC_FORM | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Deriving Overall Benefit | * | |
17 | .INCLUDE | 0 | 0 | Workers Compensation - Benefits Catalog Death | |||||
18 | SPOUSE_CHILD_BEN | ICL_SPS_CHLD_RULE | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Spouse and Child Rule | * | |
19 | SPOUSE_ONLY_BEN | ICL_SPS_RULE | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Spouse Rule | * | |
20 | ONE_CHILD_BEN | ICL_CHLD_RULE | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Child Rule | * | |
21 | MAX_SPSECHLD_AMT | ICL_SPSECHLD_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | Maximum Weekly Amount for Spouse and Child | ||
22 | MAX_SPSEONLY_AMT | ICL_SPSEONLY_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | Maximum Weekly Amount for Spouse | ||
23 | MIN_SPSEONLY_AMT | ICL_SPSE_MIN_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | Minimum Amount for Spouse | ||
24 | AMOUNT_LIMIT_SC | ICL_MAX_AMT_SC | ICL_RESAMOUNT | CURR | 15 | 2 | Amount Limit for Spouse Plus Child in Total | ||
25 | AMOUNT_LIMIT_SO | ICL_MAX_AMT_SO | ICL_RESAMOUNT | CURR | 15 | 2 | Amount Limit for Spouse | ||
26 | TIME_LIMIT | ICL_MAXPRD | NUMC | 4 | 0 | Maximum Benefit Period in Weeks | |||
27 | BURIAL_AMOUNT | ICL_BURIAL_AMT | ICL_RESAMOUNT | CURR | 15 | 2 | Workers Compensation: Burial Amount | ||
28 | CHILD_MAX_AGE | ICL_CHILD_MAX_AGE | NUMC | 4 | 0 | Maximum Age of Child | |||
29 | STDNT_MAX_AGE | ICL_STDNT_MAX_AGE | NUMC | 4 | 0 | Maximum Age for Student | |||
30 | TRANSPORTN_MAX | ICL_TRNSPT_MAX | ICL_RESAMOUNT | CURR | 15 | 2 | Maximum Amount for Transport | ||
31 | LUMP_SUM | ICL_LUMP_SUM | ICL_RESAMOUNT | CURR | 15 | 2 | Lump Sum | ||
32 | FORMULA_DTH | ICL_WC_FORM | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Deriving Overall Benefit | * | |
33 | .INCLUDE | 0 | 0 | Workers Compensation - Benefits Catalog Injuries | |||||
34 | TOTAL_SCHED | ICL_WCMP_OVERALL_SCHED | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Determining Total Weeks | TBRF150 | |
35 | SCH_SERVCATID | ICL_WCMP_SCH_SERVCATID | ICL_SERVCATID | CHAR | 10 | 0 | Scheduled Benefits Catalog for Injuries | TICL401 | |
36 | SCH_SC_VARIANT | ICL_WCMP_SCH_SERVCAT_VARIANT | ICL_SERVCAT_VARIANT | CHAR | 4 | 0 | Scheduled Benefits Catalog Variant for Injuries | TICL402 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_SCWCOMP | CURRENCY | TCURC | WAERS | |||
2 | ICL_SCWCOMP | SCH_SC_VARIANT | TICL402 | SC_VARIANT | |||
3 | ICL_SCWCOMP | SCH_SERVCATID | TICL401 | SERVCATID | |||
4 | ICL_SCWCOMP | TOTAL_SCHED | TBRF150 | EXPRESSION |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 473 |