GPES_NRP_XT2_VW(SQL View) |
Index Back |
|---|---|
Extra period definitionExtra period definition, for non-rule packager export view. |
| SELECT SETID ,LABOR_AGREEMENT ,EFFDT ,GPES_PYMNT_PD ,DESCR ,GPES_PERIOD_FROM ,GPES_DURATION ,GPES_YR_PRORATE ,GPES_XTRPD_FACTOR ,GPES_PIN_ER2_NUM + 50000000 ,GPES_XTR_ADV_PYMNT ,GPES_XTR_CALC_OPTN ,GPES_XTR_COMP_PD FROM PS_GPES_LBR_XTR_PD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: EMPL_CTG |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | GPES_PYMNT_PD |
Number(2,0) | SMALLINT NOT NULL | Extra period payment period |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | GPES_PERIOD_FROM | Number(2,0) | SMALLINT NOT NULL | Extra period beginning period |
| 7 | GPES_DURATION | Number(2,0) | SMALLINT NOT NULL | Extra period timeframe duration in months |
| 8 | GPES_YR_PRORATE | Character(1) | VARCHAR2(1) NOT NULL |
Prorated extra period flag
Y/N Table Edit Default Value: N |
| 9 | GPES_XTRPD_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL |
Extra period contribution percentage
Default Value: 100 |
| 10 | GPES_PIN_ER2_NUM | Number(8,0) | INTEGER NOT NULL |
Earning Pin Num.
Prompt Table: %GP_EDIT_FLD4 |
| 11 | GPES_XTR_ADV_PYMNT | Character(1) | VARCHAR2(1) NOT NULL |
Stats if the extra period payment period is paid before the extra period timeframe end date.
Y/N Table Edit Default Value: N |
| 12 | GPES_XTR_CALC_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Extra period calculation option
005=Payment Period 010=Proration Lump Sum 015=Other Period Default Value: 005 |
| 13 | GPES_XTR_COMP_PD | Number(2,0) | SMALLINT NOT NULL | Period used to store compensation to be used to pay extra period. |