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’ |
...