GPES_XTR_ERN_VW(SQL View) |
Index Back |
|---|---|
Extra period earningsRetrieves extra period earnings in order to resolve all of them at the begining of the extra period process. This is necessary for extra periods defined as 'extra period prorration lump sum' and being is paid at extra period timeframe end period. |
| SELECT X.SETID , X.LABOR_AGREEMENT , X.EFFDT , P.GPES_PYMNT_PD , P.GPES_PIN_ER1_NUM , X.EFF_STATUS , L.GPES_PERIOD_FROM , L.GPES_DURATION , P.GPES_EARN_TYPE , %Round (P.GPES_EARN_FACTOR / 100, 2) , P.GPES_PIN_AC1_NUM , C.PIN_RATE_NUM , B.PIN_AA_RATE_NUM FROM PS_GPES_LBR_AGRMNT X , PS_GPES_LBR_XTR_PD L , PS_GPES_LBR_XTRPER P , PS_GP_ERN_DED C , PS_GP_PIN_CMPNT B WHERE X.SETID = P.SETID AND X.LABOR_AGREEMENT = P.LABOR_AGREEMENT AND X.EFFDT = P.EFFDT AND P.SETID = L.SETID AND P.LABOR_AGREEMENT = L.LABOR_AGREEMENT AND P.EFFDT = L.EFFDT AND P.GPES_PYMNT_PD = L.GPES_PYMNT_PD AND P.GPES_PIN_AC1_NUM <> 0 AND P.GPES_PIN_ER1_NUM = C.PIN_NUM AND B.PIN_NUM = C.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_14 |
| 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 | GPES_PIN_ER1_NUM |
Number(8,0) | INTEGER NOT NULL |
Earning Pin Number
Prompt Table: %GP_EDIT_FLD4 |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 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_EARN_TYPE | Character(20) | VARCHAR2(20) NOT NULL |
Earning type: Absorbable complement, transportatio complement or seniority.
Y/N Table Edit Default Value: N |
| 10 | GPES_EARN_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL |
Extra period earning contribution percentage
Default Value: 100 |
| 11 | GPES_PIN_AC1_NUM | Number(8,0) | INTEGER NOT NULL |
Accumulator Pin Number
Prompt Table: %GP_EDIT_FLD5 |
| 12 | PIN_RATE_NUM | Number(8,0) | INTEGER NOT NULL | PinNumber Rate |
| 13 | PIN_AA_RATE_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |