GPDE_SI_PROVEFFDTDefault Value: %date
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table: COUNTRY_TBL
Prompt Table: BANK_EC_TBL
Prompt Table: DEP_SCHED
GPDE_SI_PRV_BNK(SQL Table) |
Index Back |
|---|---|
SI Provider Bank DataSI Provider Bank Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_SI_PROV |
Character(8) | VARCHAR2(8) NOT NULL | Social Insurance Provider |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Country Code
Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL |
| 4 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table: BANK_EC_TBL |
| 5 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 6 | DEP_SCHED_ID | Character(10) | VARCHAR2(10) NOT NULL |
Deposit Schedule
Prompt Table: DEP_SCHED |