Importing Adjust Employee Balances
The following tables show examples of data fields used in the Adjust Employee Balances section of the MasterPR.DEF file:
Header
| Table: tblPRHist | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,HEADER,HHIST | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SAD_EMPLOYEEID |
Y |
User Defined |
Employee ID |
|
|
SAD_ADJNUM |
Y |
30 |
Adjustment numbers must be unique within Employee ID. |
|
|
SAD_EFFDATE |
N |
Date |
Current Date |
Effective date of adjustment. Can be 6, 8, or 10 digit date. |
Detail Historical Earnings
| Table: tblPRHistEarn | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,DETAILHISTEARN,DHISTEARN | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SADEG_CODE |
N |
User Defined |
Earning Code ID |
|
|
SADEG_HOURS |
N |
Single |
0.00 |
Can be negative value. |
|
SADEG_AMOUNT |
N |
Currency |
0.00 |
Can be negative amount. |
Detail Historical Benefits
| Table: tblPRHistBene | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,DETAILHISTBENE,DHISTBENE | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SADBG_CODE |
N |
User Defined |
Benefit Code ID |
|
|
SADBG_AMOUNT |
N |
Currency |
0.00 |
Can be negative amount. |
Detail Historical Deductions
| Table: tblPRHistDeduct | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,DETAILHISTDED,DHISTDED | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SADDG_CODE |
N |
User Defined |
Deduction Code ID |
|
|
SADDG_AMOUNT |
N |
Currency |
0.00 |
Can be negative amount. |
Detail Historical Workers' Compensation
| Table: tblPRHistWC | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,DETAILHISTWC,DHISTWC | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SADWG_CODE |
N |
User Defined |
Workers' Comp Code ID |
|
|
SADWG_HOURS |
N |
Single |
0.00 |
Can be negative number. |
|
SADWG_SUBJEARN |
N |
Currency |
0.00 |
Can be negative amount. |
|
SADWG_ERAMOUNT |
N |
Currency |
0.00 |
Employer Amount. Can be negative amount. |
|
SADWG_EEAMOUNT |
N |
Currency |
0.00 |
Employee Amount. Can be negative amount. |
Detail Historical Leave
| Table: tblPRHistLeave | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,DETAILHISTLEAVE,DHISTLEAVE | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SADLG_CODE |
N |
User Defined |
Leave Code ID |
|
|
SADLG_HOURS_ |
N |
Single |
0.00 |
Leave hours accrued. Can be negative value. |
|
SADLG_HOURS_ |
N |
Single |
0.00 |
Leave hours taken. Can be negative value. |
Detail Historical Taxes
| Table: tblPRHistTaxes | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ADJUSTBALANCE,DETAILHISTTAX,DHISTTAXES | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SADTG_TYPE |
N |
4 |
Valid Tax Types: FIT, SS, MC, FUTA, EIC, SWT, SWT2, SUTA, LWT, and LER. See Table 6. |
|
|
SADTG_JURIS |
Y |
50 |
Required for tax types: LWT, LER, SWT, or SUTA. Must use a two digit state postal abbreviation for SWT and SUTA. |
|
|
SADTG_SUTAWEEKS |
N |
2 |
0 |
SUTA Weeks |
|
SADTG_SUBJEARN |
N |
Currency |
0.00 |
Employee’s Subject Earnings. Can be negative amount. |
|
SADTG_ |
N |
Currency |
0.00 |
Employer-Paid Subject Earnings. Can be negative amount. |
|
SADTG_ |
N |
Currency |
0.00 |
Gross Taxable Earnings. Can be negative amount. |
|
SADTG_EEAMOUNT |
N |
Currency |
0.00 |
Employee Amount. Can be negative amount. |
|
SADTG_ERAMOUNT |
N |
Currency |
0.00 |
Employer Amount. Can be negative amount. |