ADPCode

ADPCode

Default Table Name	ADPCode
Definition	System Setup Table - ADP Export Processing

ADPCode Columns

ColumnName Domain Datatype NULL Definition

PKey (PK) varchar(32) NO
Internal primary key.

CodeType varchar(1) NO
ADP Code type. Valid options are H-Hours, E-Earnings, M-Memo.

Code nvarchar(5) NO
The Hours/Earnings/Memo code as set up by ADP. Codes are Hours 3, Hours 4, Earnings 3, Earnings 4, Earnings 5, and Memo.

Description nvarchar(20) YES
A description of the line, designed for user's information.

FieldID varchar(1) YES
Mapped ADP field identification. Field IDs are Hours 3, Hours 4, Earnings 3, Earnings 4, Earnings 5.

Status varchar(1) YES
Indicates whether the ADP code is included for this payroll export. Valid options are A-Active, I-Inactive.

HoursType varchar(1) YES
The type of hours, when Code is an Hours option. R-Regular, O-Overtime, B-Both.

LaborCodeMask nvarchar(14) YES
Used for Hours type only. The Labor code mask corresponding to the ADP code.

WBS1 nvarchar(30) YES
The project number corresponding to the ADP Code. Used for Hours type only.

WBS2 nvarchar(30) YES
The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in.

WBS3 nvarchar(30) YES
The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in.

Expression nvarchar(1000) YES
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.

RateNumber varchar(1) YES
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.

EMLookupExpr nvarchar(4000) YES

EMWhereClause nvarchar(4000) YES

Company nvarchar(14) YES
Company

ADPCode Primary and Unique Keys

Key Name Key Type Keys

ADPCodePK PrimaryKey PKey

ADPCode Foreign Keys

Parent Relationships:

Table Name Type Cardinality Constraint Name VerbPhrase InversePhrase Foreign Keys Is Supertype Not For Replication

Child Relationships:

Table Name Type Cardinality Constraint Name VerbPhrase InversePhrase Foreign Keys Is Subtype Not For Replication

ColumnName	Domain	Datatype	NULL	Definition
PKey		varchar(32)	NO	Internal primary key.
CodeType		varchar(1)	NO	ADP Code type. Valid options are H-Hours, E-Earnings, M-Memo.
Code		nvarchar(5)	NO	The Hours/Earnings/Memo code as set up by ADP. Codes are Hours 3, Hours 4, Earnings 3, Earnings 4, Earnings 5, and Memo.
Description		nvarchar(20)	YES	A description of the line, designed for user's information.
FieldID		varchar(1)	YES	Mapped ADP field identification. Field IDs are Hours 3, Hours 4, Earnings 3, Earnings 4, Earnings 5.
Status		varchar(1)	YES	Indicates whether the ADP code is included for this payroll export. Valid options are A-Active, I-Inactive.
HoursType		varchar(1)	YES	The type of hours, when Code is an Hours option. R-Regular, O-Overtime, B-Both.
LaborCodeMask		nvarchar(14)	YES	Used for Hours type only. The Labor code mask corresponding to the ADP code.
WBS1		nvarchar(30)	YES	The project number corresponding to the ADP Code. Used for Hours type only.
WBS2		nvarchar(30)	YES	The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in.
WBS3		nvarchar(30)	YES	The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in.
Expression		nvarchar(1000)	YES	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.
RateNumber		varchar(1)	YES	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.
EMLookupExpr		nvarchar(4000)	YES
EMWhereClause		nvarchar(4000)	YES
Company		nvarchar(14)	YES	Company