ACH Table Load

...

DataStage(ETL) procedure will process the payroll file, updating/inserting ACH Payee Account records. It uses userid ACH_UAT_USR_RO.

A reject file will be produced for any errors and emailed to AP_Vend_Coord@uconn.edu. The file will be timestamped when stored on a server. Each row on the file will duplicate the input file plus an additional field that contains the reject code. The Bank account number will be masked except for the last four digits. Errors may include the following:

...

Schema – prod: kfs_prd

Userid - prod: ACH_UAT_USR_RO

Field Name	Data Type	Description
BNK_RTNG_NBR	VARCHAR2(9 BYTE)	Bank Routing Number
ACTV_IND	VARCHAR2(1 BYTE)	Active indicator = ‘Y’

...

Field Name	Pos	Data Type	Description
emplid	1	Char 6
EffDate	2	Date
AccountNum	3	Char 17	Must mask, leaving last four characters showing
AcctType	4	Char 1
RoutNum	5	Char 11
AmountPct	6	Double 5.2
ReasonCode	7	String