GPES_XTRNABS_VW(SQL View) |
Index Back |
|---|---|
Not Absorbed Extra PeriodsRetrieves extra period definitions that do not contains absorbable complement earning. |
| SELECT L.SETID , L.LABOR_AGREEMENT , L.EFFDT , A.GPES_PYMNT_PD , B.GPES_PIN_ER1_NUM , L.EFF_STATUS , X.PIN_NUM , A.GPES_YR_PRORATE , A.GPES_PERIOD_FROM , A.GPES_DURATION , %Round(A.GPES_XTRPD_FACTOR / 100, 2) , A.GPES_PIN_ER2_NUM , B.GPES_EARN_TYPE , A.GPES_XTR_ADV_PYMNT , A.GPES_XTR_CALC_OPTN , %Round(B.GPES_EARN_FACTOR / 100, 2) , B.GPES_PIN_AC1_NUM FROM PS_GPES_LBR_AGRMNT L , PS_GPES_LBR_XTR_PD A , PS_GPES_LBR_XTRPER B , PS_GP_PIN X WHERE L.SETID = A.SETID AND L.LABOR_AGREEMENT = A.LABOR_AGREEMENT AND L.EFFDT = A.EFFDT AND A.SETID = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = B.EFFDT AND A.GPES_PYMNT_PD = B.GPES_PYMNT_PD AND X.PIN_PARENT_NUM = B.GPES_PIN_ER1_NUM AND X.AUTO_ASSIGNED_TYPE = 'RT' AND NOT EXISTS ( SELECT 'X' FROM PS_GPES_LBR_XTRPER WHERE SETID = B.SETID AND LABOR_AGREEMENT = B.LABOR_AGREEMENT AND EFFDT = B.EFFDT AND GPES_PYMNT_PD = B.GPES_PYMNT_PD AND GPES_EARN_TYPE = '9-COMPABS') |
| # | 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 |
| 4 | GPES_PYMNT_PD | Number(2,0) | SMALLINT NOT NULL | Extra period payment period |
| 5 | GPES_PIN_ER1_NUM | Number(8,0) | INTEGER NOT NULL | Earning Pin Number |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | PIN_RATE_NUM | Number(8,0) | INTEGER NOT NULL | PinNumber Rate |
| 8 | GPES_YR_PRORATE | Character(1) | VARCHAR2(1) NOT NULL | Prorated extra period flag |
| 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_XTRPD_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period contribution percentage |
| 12 | GPES_PIN_ER2_NUM | Number(8,0) | INTEGER NOT NULL | Earning Pin Num. |
| 13 | GPES_EARN_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Earning type: Absorbable complement, transportatio complement or seniority. |
| 14 | 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. |
| 15 | GPES_XTR_CALC_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Extra period calculation option
005=Payment Period 010=Proration Lump Sum 015=Other Period |
| 16 | GPES_EARN_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period earning contribution percentage |
| 17 | GPES_PIN_AC1_NUM | Number(8,0) | INTEGER NOT NULL | Accumulator Pin Number |