WCCLASS

Work Comp Class Detail

Contains the detail information of workers' compensation plans and stores the experience rates and limits by effective date.
UPDATED BY
BN66.1 HR06.1 HR06.4 HR506 HWCA.1 HWCC.1
LT101 PR140 PR18.1 PR18.2 PR189 PR195
PR218 PR278 PR288 PR418 PR80.1 PR80.4
PR89.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCC-COMPANY
Element: Company Hr
Numeric 4
PR18.1 PR18.2
WCC-WC-STATE
Element: Wc State
Alpha 2
Contains the 2-digit code that identifies the state in which the worker's compensation plan is effective.
PR18.1 PR18.2
WCC-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the process level if the workers' compensation classification is specific to a process level.
PR18.1 PR18.2
WCC-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date the rates in the table become effective.
PR18.1 PR18.2
WCC-WC-CLASS
Element: Wc Class
Alpha 4
Contains the workers' compensation class.
PR18.1
WCC-CA-WC-CLASS
Element: Ca Wc Class
Alpha 10
Contains the Canadian Workers Compensation classification to be used on the job code.
PR18.2
WCC-DESC
Element: Description
Alpha 30 (Lower Case)
Contains the workers' compensation classification description.
PR18.1 PR18.2
WCC-EXP-RATE
Element: Exp Rate
Signed 7.4
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.
PR18.1 PR18.2
WCC-WAGE-LIMIT
Element: Wage Limit
Signed 11.2
Contains the wage limit amount if defined.
PR18.1 PR18.2
WCC-LIMIT-IND
Element: Limit Ind
Alpha 2
Contains the value that indicates if the wage limit amount defined is a monthly or annual limit.
MO = Monthly
AN = Annual
PR18.1
WCC-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
WCC-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
WCC-E-MOD
Element: E Mod
Signed 7.4
WCC-COUNTRY-CODE
Element: Country Code
Alpha 2
Defines which country the record is associated with.
PR18.1 PR18.2


WCCLASS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCCSET1 COMPANY
COUNTRY-CODE
WC-STATE
PROCESS-LEVEL
EFFECT-DATE
WC-CLASS
CA-WC-CLASS
BN66.1 PR140
PR18.1 PR18.2
PR189 PR195
PR218 PR278
PR288 PR418
PR80.1 PR80.4
PR89.1
WCCSET2 COMPANY
WC-CLASS
CA-WC-CLASS
COUNTRY-CODE
WC-STATE
PROCESS-LEVEL
EFFECT-DATE*
KeyChange
HR06.1 HR06.4
HR506 HWCA.1
HWCC.1 LT101


WCCLASS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:27:34 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.