Employees Direct Deposit Table Formats (EMDirectDeposit)
Follow Vision specifications for preparing a file containing employees 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 |