UNION_CDEFFDTDefault Value: %date
PIN_NUMPrompt Table: GPBR_PIN_NM_DVW
A=Attribute
D=Dimension
M=Measure
Prompt Table: GP_ENT_SOVR4_VW
Default Value: N
GPBR_NRP_SVL_VW(SQL View) |
Index Back |
|---|---|
Values for Supporting ElementsOverride values for supporting elements. |
| SELECT UNION_CD , EFFDT , PIN_NUM + 50000000 , ELEMENT_TYPE , GPBR_VAL_CHAR , GPBR_VAL_DT , GPBR_VAL_NUM , DEFAULT_IND FROM PS_GPBR_SOVR_VAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UNION_CD |
Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPBR_PIN_NM_DVW |
| 4 | ELEMENT_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Element Type
A=Attribute D=Dimension M=Measure Prompt Table: GP_ENT_SOVR4_VW |
| 5 | GPBR_VAL_CHAR | Character(25) | VARCHAR2(25) NOT NULL | Character Value |
| 6 | GPBR_VAL_DT | Date(10) | DATE | Date Value |
| 7 | GPBR_VAL_NUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Numeric Value |
| 8 | DEFAULT_IND | Character(1) | VARCHAR2(1) NOT NULL |
An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.
Default Value: N |