Importing Workers' Compensation Codes
The following tables show examples of data fields used in the Workers' Comp Codes section of the MasterPR.DEF file:
Header
| Table: tblPRWCCode | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,WORKCOMPCODE,HEADER,HWC | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
PRWC_CODE |
Y |
User Defined |
Workers' Comp Code ID |
|
|
PRWC_STATUS |
N |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
PRWC_TITLE |
Y |
User Defined |
Workers' Compensation Code Title |
|
| PRWC_AATRIX_TAX_TYPE | N | 60 | <None> | Defaults to <None>. This is the State assigned to the Workers' Compensation Code. |
|
PRWC_CHECKSTUB |
N |
1 |
0 |
0 = No; 1 = Yes. Available if PRWC_PAIDBY is ER |
|
PRWC_PAIDBY |
Y |
2 |
ER |
ER - Employer; EE - Employee |
|
PRWC_EXPENSE_ |
Y |
User Defined |
Must be a valid chart of accounts code (Maintain>Chart of Accounts Codes). Required for paid by Employer. |
|
|
PRWC_LIABILITY_ |
Y |
User Defined |
Must be a valid chart of accounts code (Maintain>Chart of Accounts Codes). |
|
|
PRWC_CALC_METHOD |
N |
2 |
RE |
Valid Calculation Methods: RE , RH, and RW. See Table 3. |
|
PRWC_RATE |
N |
Single |
0.00000 |
Rate |
|
PRWC_ADJUSTMENT_ |
N |
Single |
0.0000 |
Adjustment Factor |
|
PRWC_MAX_SUBJECT_ |
N |
Currency |
999,999.99 |
Maximum Subject Wages |
|
PRWC_ALLOCATION_ |
N |
2 |
AE |
Valid Distribution Methods: AE, CE, and DC. See Table 5. |
|
PRWC_ALLOC_DIST_ |
Y |
User Defined |
Required for a distribution method of DC. Must be a valid code with a distribution type of "B" or "P" (Maintain>Payroll>Distribution Codes). |
|
Detail
|
Table: tblPRWCCodeEarning Context Section: CONTEXT,WORKCOMPCODE,DETAIL,DWC |
||||
|
Field ID |
Req'd |
Field Length |
Default Value |
Notes |
|
PR_EC_CODE |
Y |
User Defined |
Required if calculation method of RE or RW. Can have more than one earning code. Must be a valid code (Maintain>Payroll>Earning Codes). |
|