GPDE_BK_XFERDTA(SQL Table) | 
Index Back | 
|---|---|
Deposit Transfer Data TableThis record contains the criteria on how to organize or store bank transfer data into physical devices ( i.e. magnetic tape, diskettes, etc.) | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Date(10) | DATE | Current Pay End Date | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Transfer Sequence | |
| 3 | GPDE_BK_XFER_BASIS | Character(1) | VARCHAR2(1) NOT NULL | 
Transfer Basis
 C=Clearing bank H=Source Bank  | 
| 4 | GPDE_BK_XFER_TYPE | Number(10,0) | DECIMAL(10) NOT NULL | Transfer Type | 
| 5 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | 
Source Bank ID
 Prompt Table: SRC_BANK  | 
| 6 | DEP_SCHED_ID | Character(10) | VARCHAR2(10) NOT NULL | 
Deposit Schedule
 Prompt Table: DEP_SCHED  | 
| 7 | DEPOSIT_DATE | Date(10) | DATE | 
Deposit Date
 Default Value: %date  | 
| 8 | GPDE_BK_LST_UPD | Date(10) | DATE | Last Updated | 
| 9 | GPDE_BK_GEN_DT | Date(10) | DATE | Generation Date | 
| 10 | GPDE_BK_XFER_DT | Date(10) | DATE | File Creation Date | 
| 11 | GPDE_BK_T_WAGES | Character(1) | VARCHAR2(1) NOT NULL | 
Wages and Salaries
 Y/N Table Edit Default Value: N  | 
| 12 | GPDE_BK_T_CAP_ACC | Character(1) | VARCHAR2(1) NOT NULL | 
Capital Accumulation Benefits
 Y/N Table Edit Default Value: N  | 
| 13 | GPDE_BK_T_DIR_LIFE | Character(1) | VARCHAR2(1) NOT NULL | 
Direct Life Insurance
 Y/N Table Edit Default Value: N  | 
| 14 | GPDE_BK_T_GARN | Character(1) | VARCHAR2(1) NOT NULL | 
Garnishments
 Y/N Table Edit Default Value: N  | 
| 15 | GPDE_BK_T_EXT_XFER | Character(1) | VARCHAR2(1) NOT NULL | 
External Transfers
 Y/N Table Edit Default Value: N  | 
| 16 | GPDE_BK_T_TAXES | Character(1) | VARCHAR2(1) NOT NULL | 
Income Tax and Church Tax
 Y/N Table Edit Default Value: N  | 
| 17 | GPDE_BK_T_SI | Character(1) | VARCHAR2(1) NOT NULL | 
Social Insurance Contributions
 Y/N Table Edit Default Value: N  | 
| 18 | GPDE_BK_T_ADVANCES | Character(1) | VARCHAR2(1) NOT NULL | 
Advance Payments
 Y/N Table Edit Default Value: N  | 
| 19 | GPDE_BK_T_BVV | Character(1) | VARCHAR2(1) NOT NULL | 
BVV
 Y/N Table Edit Default Value: N  | 
| 20 | GPDE_BK_T_UMLAGE | Character(1) | VARCHAR2(1) NOT NULL | 
Sick and Maternity Leave
 Y/N Table Edit Default Value: N  |