Internal primary key.

ADP Code type. Valid options are H-Hours, E-Earnings, M-Memo.

The Hours/Earnings/Memo code as set up by ADP. Codes are Hours 3, Hours 4, Earnings 3, Earnings 4, Earnings 5, and Memo.

A description of the line, designed for user's information.

Mapped ADP field identification. Field IDs are Hours 3, Hours 4, Earnings 3, Earnings 4, Earnings 5.

Indicates whether the ADP code is included for this payroll export. Valid options are A-Active, I-Inactive.

The type of hours, when Code is an Hours option. R-Regular, O-Overtime, B-Both.

Used for Hours type only. The Labor code mask corresponding to the ADP code.

The project number corresponding to the ADP Code. Used for Hours type only.

The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in.

The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in.

The user-defined expression for the Amount of Earnings and Memo types.field It will be mapped to Earnings3/4/5Amt or MemoAmt fields in the ADPExport table.  The expression can be an EM field (e.g. PayRate, JobCostRate), or an expression using EM fields (PayRate+JobCostRate) and must follow SQL syntax.

This is the Paychex Rate Number that can be used to override the Default Rate Number in the Employee Info Center. Valid values are 1, 2, 3, 4, 5, or M.

Company