Importing Earning Codes

The following table shows examples of data fields used in the Earning Codes section of the MasterPR.DEF file:

Table: tblPREarnCode
Context Section: CONTEXT,EARNINGCODE,HEADER,HEARN
Field ID Req'd Field Length Default Value Notes

PREC_CODE

Y

User Defined

 

Earning Code ID

PREC_STATUS

N

1

A

A (Active), I (Inactive), or D (Discontinued)

PREC_TITLE

Y

User Defined

 

Earning Code Title

PREC_EXPENSE_
ACCOUNT

Y

User Defined

 

Must be set up using Maintain>Chart of Accounts Codes.

PREC_TRACK_LABOR_
HRS

N

1

1

0 = No; 1 = Yes

PREC_CONT_NET_PAY_
ONLY

N

1

0

0 = No; 1 = Yes

PREC_W2_BOX_NUM

N

2

 

W-2 Box Number, if any

PREC_W2_BOX_CODE

N

5

 

W-2 Box Code, if any

PREC_CALC_METHOD

Y

2

ER

Valid Calculation Methods: ER, RM, FH, FA, RT, and AT. See Table 3.

PREC_AMOUNT

Y

Currency

0.0000

Required if calculation method of FH or FA.

PREC_RATE

Y

5

0.0000

Required if calculation method of RT or RM.

PREC_FED_FIT

N

2

 

0 = No; 1 = Yes

PREC_FED_SOCIAL_
SEC

N

2

 

0 = No; 1 = Yes

PREC_FED_MEDICARE

N

2

 

0 = No; 1 = Yes

PREC_FED_FUTA

N

2

 

0 = No; 1 = Yes

PREC_STATE_SWT

N

2

 

0 = No; 1 = Yes

PREC_STATE_SUTA

N

2

 

0 = No; 1 = Yes

PREC_LOCAL_LWT

N

2

 

0 = No; 1 = Yes

PREC_LOCAL_
EMPLOYER

N

2

 

0 = No; 1 = Yes