|
|
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
PBWC.1 PR218 PR288 PR418 PR17.1 PR278
PRWC.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 Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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: Effective DateContains the effective date of the
workers' compensation rate table.
WCH-WC-CODE Alpha 10 PR18.1
Workers Comp Policy Contains the user-defined code that
Code identifies the workers' compensation
plan.
WCH-PREM-PER-WAGE Signed 11.3 PR18.1 PR18.2
Premium Based on Contains the amount per wages on which
Wages the premium is based.
WCH-PREM-PER-HOUR Signed 7.2 PR18.1
Premium Based on Contains the amount per hour on which
Nbr of Hours the premium is based.
WCH-STA-ANN-LIMIT Signed 11.2 PR18.1 PR18.2
Element: State Annual LContains the state annual limit defined
for the policy.
WCH-STA-MTH-LIMIT Signed 11.2 PR18.1
Element: State Monthly 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
Include Overtime Contains the value that determines if
Premium 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
Account Currency Represents the number of decimals
Code defined for the currency of the object.
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 PBWC.1 PR18.1
COUNTRY-CODE PR18.2 PR218
WC-STATE PR288 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 PRWC.1
COUNTRY-CODE
EFFECT-DATE*
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
|
