GPDE_BK_PYE_DEF(SQL Table) |
Index Back |
|---|---|
Source Bank DefaultAccount Bank Information combined with the Source Bank Defaul- ting Information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ACCOUNT_ID |
Number(3,0) | SMALLINT NOT NULL | Account ID |
| 3 | GPDE_AL_PAYMT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
1=Wages and Salaries 3=Taxes 4=Social Insurance 6=Capital Accumulation 7=Direct Life Insurance 8=Garnishments 9=External Transfer B=BVV L=U1/Sick Leave M=U2/Maternity Leave V=Advance Payments Prompt Table: GPDE_BK_TYPE_VW |
| 4 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |