GP_PKG_IDSETIDLABOR_AGREEMENTEFFDTGPES_PYMNT_PD005=Payment Period
010=Proration Lump Sum
015=Other Period
GPES_NRP_XT2_AD(SQL Table) |
Index Back |
|---|---|
Extra period definitionExtra period timeframe and payment definition. It also includes the earning used to pay extra periods not earned at termination. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | GPES_PYMNT_PD |
Number(2,0) | SMALLINT NOT NULL | Extra period payment period |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | GPES_PERIOD_FROM | Number(2,0) | SMALLINT NOT NULL | Extra period beginning period |
| 8 | GPES_DURATION | Number(2,0) | SMALLINT NOT NULL | Extra period timeframe duration in months |
| 9 | GPES_YR_PRORATE | Character(1) | VARCHAR2(1) NOT NULL | Prorated extra period flag |
| 10 | GPES_XTRPD_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period contribution percentage |
| 11 | GPES_PIN_ER2_NUM | Number(8,0) | INTEGER NOT NULL | Earning Pin Num. |
| 12 | 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. |
| 13 | GPES_XTR_CALC_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Extra period calculation option
005=Payment Period 010=Proration Lump Sum 015=Other Period |
| 14 | GPES_XTR_COMP_PD | Number(2,0) | SMALLINT NOT NULL | Period used to store compensation to be used to pay extra period. |