PAY_ENTITYEMPLIDEMPL_RCDGPAU_BANK_DB_TYPE10=Group Tax
20=Net Payment
30=Recipient
Default Value: %date
GPAU_EFT_SB_TMP(SQL Table) |
Index Back |
|---|---|
EFT Source Bank Temp TableThis table tracks source banks by employee level to allow faster process ing in the AE program GPAU_EFT_CMX. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | GPAU_BANK_DB_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
This field distinguishes debit types and is used in the AE program GPAU_EFT_CMX.
10=Group Tax 20=Net Payment 30=Recipient |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | ORG_LINK_UNIT | Character(12) | VARCHAR2(12) NOT NULL | Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID |
| 7 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 8 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |