pdpEmployeeACHAccountLoadJob

Overview

The pdpEmployeeACHAccountLoadJob is used to add, update and inactivate employee ACH information contained in the Payee ACH Account table. Things to know: 

• The file should contain only employee ach payees:
  • If the file contains any records with a Payee Identifier Type Code other than E, the job will fail and log an error message.
  • Records in the file, but not in the table are added to the table
  • Records in the file and in the table, are updated with any differences
  • Records in the table, not in the file are inactivated
  • Records in the table without a matching Person record are not added to the table.
  • Records can be bypassed by setting the Batch Bypass Indicator = Y. Doing so will bypass all changes, if a Record's By Pass flag = Y in the table, and the Payee  is not in the file, the Payee will not be updated and will need to be inactivated manually. 
• The file and an empty .done file of the same name will be processed by the job when loaded into the staging/pdp/employeeACHAccountLoad directory

PDP Employee ACH Account Upload Format - sample file below - All fields are required

Name	Type	Max Size	Notes
Bank Routing Number	Number	9
Bank Account Number	Alphanumeric	25
Payee ID Number	Character	21
Payee Identifier Type Code	Character	1	E - Employee  NOTE: Other values will cause the job to fail.
ACH Transaction Type	Character	4	PRAP
Bank Account Type Code	Numeric	2	22 - Checking 32 - Savings
Standard Entry Class	Character	3	CCD CTX PPD
Active	Character	1	Y (yes) or N (no)
Bypass Feed Update Indicator	Character	1	Y (yes) or N (no) NOTE: This field will only be set when a record is added. Future updates to this field will need to be made via the Payee ACH Account maintenance document.

Sample File

<?xml version="1.0" encoding="utf-8"?> <PayeeACHAccountLoad xmlns="https://github.com/KualiCo/financials-schemas/tree/main/PayeeACHAccountLoad/v2" xsi:schemaLocation="https://github.com/KualiCo/financials-schemas/tree/main/PayeeACHAccountLoad/v2 schema.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <payeeACHAccount> <bankRoutingNumber>999999999</bankRoutingNumber> <bankAccountNumber>FAKE.ACCOUNT.NUMBER</bankAccountNumber> <payeeIdNumber>123456789</payeeIdNumber> <payeeIdentifierTypeCode>E</payeeIdentifierTypeCode> <achTransactionType>PRAP</achTransactionType> <bankAccountTypeCode>22</bankAccountTypeCode> <standardEntryClass>CCD</standardEntryClass> <active>Y</active> <bypassFeedUpdateIndicator>N</bypassFeedUpdateIndicator> </payeeACHAccount>