GPCH_BK_PYE_DEF(SQL Table) |
Index Back |
|---|---|
Net DistributionNet Distribution EFFDT and Account level |
| # | 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 | GPCH_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: GPCH_BK_TYPE_VW |
| 4 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |