|
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
BN66.1 PR140 PR189 PR195 PR218 PR278
PR288 PR418 PR80.1 PR89.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 Hr
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 Lev HrContains 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: Effect Date Contains the date the rates in the
table become effective.
WCC-WC-CLASS Alpha 4 PR18.1
Element: Wc Class Contains the workers' compensation
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: Exp Rate Contains 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 Ind Contains 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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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 BN66.1 PR140
COUNTRY-CODE PR18.1 PR18.2
WC-STATE PR189 PR195
PROCESS-LEVEL PR218 PR278
EFFECT-DATE PR288 PR418
WC-CLASS PR80.1 PR89.1
CA-WC-CLASS
WCCSET2 COMPANY KeyChange HR06.1 HR06.4
WC-CLASS HR506 HWCA.1
CA-WC-CLASS HWCC.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
|