PROCESS_INSTANCECOMPANYPAYGROUPPAY_END_DTPY_DIRDEP_COMPG(SQL Table) |
Index Back |
|---|---|
Direct Deposit Process paramDirect Deposit Processing Company / Paygroup / Pay End Date parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 4 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 5 | CHECK_DT | Date(10) | DATE | Check date. |
| 6 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 7 | DD_SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Some banks require a single employer to use two different bank transit numbers for one bank account - one transit number for their direct deposit transactions and another transit number for their printed checks. Added DD_SRC_BANK_ID to the PAYGROUP_TBL record to allow for a different Bank ID to be used as the transit number for direct deposits. If the field are left blank, then the system will assume that the user wants to use the SRC_BANK_ID for both checks and direct deposits. This new field will be added to Paygroup Table 8. |
| 8 | IAT_IND | Character(1) | VARCHAR2(1) NOT NULL | International ACH Transaction Bank (or IAT) Indicator |
| 9 | CO_BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank Code |
| 10 | CO_ACCOUNT_NBR | Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 11 | PRENOTE_WAIT_DAYS | Number(3,0) | SMALLINT NOT NULL | Prenote Wait Days (U.S.) |