|
|
WCCLASS FILE
Work Comp Class Detail
Contains the detail information of workers' compensation plans and stores the
experience rates and limits by effective date.
REFERENCED BY
PBIP.1 PR218 PR278 PR288 PR418 PRWC.1
HR06.1 HR06.4 HR506 HWCA.1 HWCC.1
UPDATED BY
PR18.1 PR18.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCC-COMPANY Numeric 4 PR18.1 PR18.2
Element: Company The company number represents an
established company and is entered on
all function codes.
WCC-WC-STATE Alpha 2 PR18.1 PR18.2
Element: Wc State Contains the 2-digit code that
identifies the state in which the
worker's compensation plan is effective.
WCC-PROCESS-LEVEL Alpha 5 PR18.1 PR18.2
Element: Process Level Contains the process level if the
workers' compensation classification is
specific to a process level.
WCC-EFFECT-DATE Numeric 8 (yyyymmdd) PR18.1 PR18.2
Element: Date Contains the date the rates in the
table become effective.
WCC-WC-CLASS Alpha 4 PR18.1
Workers Comp Contains the workers' compensation
Classification class.
WCC-CA-WC-CLASS Alpha 10 PR18.2
Element: Ca Wc Class Contains the Canadian Workers
Compensation classification to be used
on the job code.
WCC-DESC Alpha 30 (Lower Case) PR18.1 PR18.2
Element: Description Contains the workers' compensation
classification description.
WCC-EXP-RATE Signed 7.4 PR18.1 PR18.2
Element: Experience RatContains the experience rate. The value
in this field represents an amount if
you enter a value in either the Premium
Per Wages or Premium Per Hours field in
PR18.1 (Workers' Compensation
Classification). If you do not enter a
value in either of those fields, the
value represents a percent.
WCC-WAGE-LIMIT Signed 11.2 PR18.1 PR18.2
Element: Wage Limit Contains the wage limit amount if
defined.
WCC-LIMIT-IND Alpha 2 PR18.1
Element: Limit IndicatoContains the value that indicates if
the wage limit amount defined is a
monthly or annual limit.
MO = Monthly
AN = Annual
WCC-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
WCC-CURR-ND Numeric 1
Account Currency
Code
WCC-E-MOD Signed 7.4
Element: E Mod
WCC-COUNTRY-CODE Alpha 2 PR18.1 PR18.2
Element: Country Code Defines which country the record is
associated with.
WCCLASS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCCSET1 COMPANY PBIP.1 PR18.1
COUNTRY-CODE PR18.2 PR218
WC-STATE PR278 PR288
PROCESS-LEVEL PR418 PRWC.1
EFFECT-DATE
WC-CLASS
CA-WC-CLASS
WCCSET2 COMPANY KeyChange HR06.1 HR06.4
WC-CLASS HR506 HWCA.1
CA-WC-CLASS HWCC.1 PBIP.1
COUNTRY-CODE
WC-STATE
PROCESS-LEVEL
EFFECT-DATE*
WCCLASS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Class Header WCCLASSHDR Required
WCC-COMPANY -> WCH-COMPANY
WCC-COUNTRY-CODE -> WCH-COUNTRY-CODE
WCC-WC-STATE -> WCH-WC-STATE
WCC-PROCESS-LEVEL -> WCH-PROCESS-LEVEL
WCC-EFFECT-DATE -> WCH-EFFECT-DATE
Company PRSYSTEM Required
WCC-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Policy Code WCPOLICY Required
WCC-COMPANY -> WCP-COMPANY
WCH-WC-CODE -> WCP-WC-CODE
Process Level PRSYSTEM Required
When WCC-PROCESS-LEVEL != Spaces
WCC-COMPANY -> PRS-COMPANY
WCC-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Wc State PRSTATE Required
When WCC-WC-STATE != Spaces
WCC-WC-STATE -> PSA-STATE
|
