Employees Direct Deposit Table Formats (EMDirectDeposit)

Follow DPS specifications for preparing a file containing direct deposit information.

Field Name	Data Type	Length	Notes
Employee	varchar	20	Employee number; required field; must exist in EM
Seq	int	4	Internal sequence number; required field
BankID	varchar	8	Bank identification number; required field; only allows 8 numbers, the 9th is calculated
Account	varchar	17	Bank account number; required field
AccountType	varchar	1	Variable indicating the bank account type; required field; valid options are C (Checking) or S (Savings)
Method	smallint	1	Variable indicating the method for allocating the direct deposit payroll amount to the account; valid options are A (Amount), P (Percentage), S (Remainder), or N (None)
AmtPct	decimal	9	Amount or percentage of net pay to allocate to the employee's bank account
Status	varchar	1	Variable indicating the employee's direct deposit status; valid options are A (Add), W (Wait), or Y (Active)
CurrentAmt	numeric	9	Total current amount to be allocated to the account
Override	varchar	1	Variable indicating whether the current amount is a user-keyed override; default is N
exMethod	varchar	1	Variable indicating the method for allocating the direct deposit employee expense reimbursement amount to the account; valid options are A (Amount), P (Percentage), S (Remainder), or N (None)
exAmtPct	decimal	9	Amount or percentage of employee expense reimbursement to allocate to the employee's bank account