SETIDLABOR_AGREEMENTEFFDTDefault Value: %date
GPES_PYMNT_PDA=Active
I=Inactive
GPES_EST_ANT_VW(SQL View) |
Index Back |
|---|---|
Payment Period for SeniorityReturn the payment period for the Extra Period with seniority earnings (GPES_EARN_TYPE= '5-ANTIGDAD') |
| SELECT DISTINCT B.SETID , B.LABOR_AGREEMENT , B.EFFDT , B.GPES_PYMNT_PD , A.EFF_STATUS , B.GPES_XTRPD_FACTOR , B.GPES_YR_PRORATE , C.GPES_EARN_FACTOR , B.GPES_PERIOD_FROM , B.GPES_DURATION , B.GPES_XTR_ADV_PYMNT FROM PS_GPES_LBR_AGRMNT A , PS_GPES_LBR_XTR_PD B , PS_GPES_LBR_XTRPER C WHERE A.SETID = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = B.EFFDT AND B.SETID = C.SETID AND B.LABOR_AGREEMENT = C.LABOR_AGREEMENT AND B.EFFDT = C.EFFDT AND B.GPES_PYMNT_PD = C.GPES_PYMNT_PD AND C.GPES_PIN_ER1_NUM IN ( SELECT PIN_NUM FROM PS_GPES_SEN_ERN) |
| # | 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 |
| 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | GPES_XTRPD_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period contribution percentage |
| 7 | GPES_YR_PRORATE | Character(1) | VARCHAR2(1) NOT NULL | Prorated extra period flag |
| 8 | GPES_EARN_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period earning contribution percentage |
| 9 | GPES_PERIOD_FROM | Number(2,0) | SMALLINT NOT NULL | Extra period beginning period |
| 10 | GPES_DURATION | Number(2,0) | SMALLINT NOT NULL | Extra period timeframe duration in months |
| 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. |