|
|
WCCLASSHDR FILE
Work Comp Class Header
This file identifies workers' compensation classes. You can identify classes
by company, work state, or process level. You can add multiple records for the
same workers' compensation class by using different effective dates.
REFERENCED BY
PR218 PR288 PR418 PR17.1 PR278 BN66.1
PR140 PR189 PR195 PR80.1 PR89.1
UPDATED BY
PR18.1 PR18.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCH-COMPANY Numeric 4 PR18.1 PR18.2
Element: Company Hr
WCH-WC-STATE Alpha 2 PR18.1 PR18.2
Element: Wc State Contains the 2-digit code that
identifies the state in which the
workers' compensation plan is effective.
WCH-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.
WCH-EFFECT-DATE Numeric 8 (yyyymmdd) PR18.1 PR18.2
Element: Effect Date Contains the effective date of the
workers' compensation rate table.
WCH-WC-CODE Alpha 10 PR18.1
Element: Wc Code Contains the user-defined code that
identifies the workers' compensation
plan.
WCH-PREM-PER-WAGE Signed 11.3 PR18.1 PR18.2
Element: Prem Per Wage Contains the amount per wages on which
the premium is based.
WCH-PREM-PER-HOUR Signed 7.2 PR18.1
Element: Prem Per Hour Contains the amount per hour on which
the premium is based.
WCH-STA-ANN-LIMIT Signed 11.2 PR18.1 PR18.2
Element: Sta Ann Limit Contains the state annual limit defined
for the policy.
WCH-STA-MTH-LIMIT Signed 11.2 PR18.1
Element: Sta Mth Limit Contains the state monthly limit
defined for the policy. The system
checks the limit every calendar month.
WCH-INC-OVT-PREM Alpha 1 PR18.1 PR18.2
Element: Inc Ovt Prem Contains the value that determines if
the entire overtime pay amount or only
the straight time portion of the pay is
included in the calculation.
Y = Yes
N = No
WCH-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
WCH-CURR-ND Numeric 1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
WCH-INDUSTRY-CODE Alpha 10 PR18.2
Element: Industry Code This field will store the industry code
for the province that is being reported.
WCH-IND-CODE-DESC Alpha 30 (Lower Case) PR18.2
Element: Ind Code Desc Stores the description of the industry
code (e.g logging, mining, etc.).
WCH-COUNTRY-CODE Alpha 2 PR18.1 PR18.2
Element: Country Code Defines which country the record is
associated with.
" " = USA
CA = Canada
US = USA
WCH-E-MOD Signed 7.4
Element: E Mod
WCH-CA-ACCT-NBR Alpha 15 PR18.2
Element: Ca Acct Nbr Defines the provincial assigned account
number, firm number, registration
number, Quebec enterprise number, legal
entity, etc. for which this plan is
being set up.
WCH-CLIENT-E-MOD Signed 7.4
Element: Client E Mod
WCCLASSHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCHSET1 COMPANY PR18.1 PR18.2
COUNTRY-CODE PR218 PR288
WC-STATE PR418
PROCESS-LEVEL
EFFECT-DATE*
WCHSET2 COMPANY KeyChange PR17.1 PR278
COUNTRY-CODE
WC-CODE
CA-ACCT-NBR
EFFECT-DATE*
WC-STATE
PROCESS-LEVEL
WCHSET3 COMPANY BN66.1 PR140
COUNTRY-CODE PR189 PR195
EFFECT-DATE* PR80.1 PR89.1
WC-STATE
PROCESS-LEVEL
WCCLASSHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
WCH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Policy Code WCPOLICY Required
WCH-COMPANY -> WCP-COMPANY
WCH-WC-CODE -> WCP-WC-CODE
Process Level PRSYSTEM Required
When WCH-PROCESS-LEVEL != Spaces
WCH-COMPANY -> PRS-COMPANY
WCH-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Wc State PRSTATE Required
When WCH-WC-STATE != Spaces
WCH-WC-STATE -> PSA-STATE
WCCLASSHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Classes WCCLASS Delete Cascades
WCH-COMPANY -> WCC-COMPANY
WCH-COUNTRY-CODE -> WCC-COUNTRY-CODE
WCH-WC-STATE -> WCC-WC-STATE
WCH-PROCESS-LEVEL -> WCC-PROCESS-LEVEL
WCH-EFFECT-DATE -> WCC-EFFECT-DATE
WCC-WC-CLASS
WCC-CA-WC-CLASS
|
