GPDE_BV_CLASSEFFDTDefault Value: %date
GPDE_BV_TO_DMCURRENCY_CDPrompt Table: CURRENCY_CD_TBL
GPDE_BV_RT(SQL Table) |
Index Back |
|---|---|
BVV Contribution ClassesThe Field BVV_CLASS is not required for the entry of Contribution Class 0. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_BV_CLASS |
Number(2,0) | SMALLINT NOT NULL | BVV Contribution Class |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPDE_BV_TO_DM |
Number(8,2) | DECIMAL(7,2) NOT NULL | BVV Class Limit Amount |
| 4 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 5 | GPDE_BV_TOTAL_DM | Number(8,2) | DECIMAL(7,2) NOT NULL | BVV Total Contribution |
| 6 | GPDE_BV_ER_DM | Number(8,2) | DECIMAL(7,2) NOT NULL | BVV Employer Contribution |
| 7 | GPDE_BV_EE_DM | Number(8,2) | DECIMAL(7,2) NOT NULL | BVV Employee Contribution |