PAY_ENTITYPrompt Table: GP_PYENT
EFFDTDefault Value: %date
GPDE_BV_PRVDR_NBRGPDE_BV_TYPEP=Pension Fund
U=Support Fund
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GPDE_AL_PE_BVDT(SQL Table) |
Index Back |
|---|---|
BVV Insurance Data DetailsBVV Insurance Data Details for Pay Entity |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPDE_BV_PRVDR_NBR |
Number(4,0) | SMALLINT NOT NULL | BVV Provider Number |
| 4 | GPDE_BV_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Fund Type (Pension/Relief Fund)
P=Pension Fund U=Support Fund |
| 5 | GPDE_BV_N_TRFF_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | EE + ER Percent Tariff N |
| 6 | GPDE_BV_DFLT_PRVDR | Character(1) | VARCHAR2(1) NOT NULL |
Default Provider
Y/N Table Edit Default Value: N |
| 7 | GPDE_AL_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Indicator
Y/N Table Edit Default Value: N |
| 8 | GPDE_BV_SORT_KEY | Character(36) | VARCHAR2(36) NOT NULL | BVV Sort Key |
| 9 | GPDE_BV_SORT_LEN | Character(4) | VARCHAR2(4) NOT NULL | BVV Sort Key Length |
| 10 | GPDE_BV_SORTV_KEY | Character(36) | VARCHAR2(36) NOT NULL | BVV Insurance Sort Key |
| 11 | GPDE_BV_SORTV_LEN | Character(4) | VARCHAR2(4) NOT NULL | BVV Sort Key Length |
| 12 | GPDE_BV_SORTV_ROW1 | Character(30) | VARCHAR2(30) NOT NULL | BVV Sort Key Z1 |
| 13 | GPDE_BV_SORTV_ROW2 | Character(30) | VARCHAR2(30) NOT NULL | BVV Sort Key Z2 |
| 14 | GPDE_BV_SORTV_ROW3 | Character(30) | VARCHAR2(30) NOT NULL | BVV Sort Key Z3 |
| 15 | GPDE_BV_SORTV_ROW4 | Character(30) | VARCHAR2(30) NOT NULL | BVV Sort Key Z4 |