Employees Direct Deposit Table Formats (EMDirectDeposit)

Follow Vantagepoint 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
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)
AmtPct	decimal	9	Amount or percentage of net pay to allocate to the employee's bank account
BankID	varchar	8	Bank identification number; required field; only allows 8 numbers, the 9th is calculated
EmployeeCompany	nvarchar
exAmtPct	decimal	9	Amount or percentage of employee expense reimbursement to allocate to the employee's bank account
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)
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)
Override	varchar	1	Variable indicating whether the current amount is a user-keyed override; default is N
Status	varchar	1	Variable indicating the employee's direct deposit status; valid options are A (Add), W (Wait), or Y (Active)