SETIDLABOR_AGREEMENTEFFDTGPES_PYMNT_PDGPES_PIN_ER1_NUMPrompt Table: %GP_EDIT_FLD4
A=Active
I=Inactive
Y/N Table Edit
Default Value: N
005=Payment Period
010=Proration Lump Sum
015=Other Period
Default Value: 005
Prompt Table: %GP_EDIT_FLD5
GPES_PRTAPXTAVW(SQL View) |
Index Back |
|---|---|
Extra period prorationRetrieves necesary data for either social security extra period proration or annual extra period proration. |
| SELECT L.SETID , L.LABOR_AGREEMENT , L.EFFDT , A.GPES_PYMNT_PD , B.GPES_PIN_ER1_NUM , L.EFF_STATUS , X.PIN_AA_RATE_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 , A.GPES_XTR_COMP_PD FROM PS_GPES_LBR_AGRMNT L , PS_GPES_LBR_XTR_PD A , PS_GPES_LBR_XTRPER B , PS_GP_PIN_CMPNT 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_NUM = B.GPES_PIN_ER1_NUM |
| # | 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
Prompt Table: %GP_EDIT_FLD4 |
| 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.
Y/N Table Edit Default Value: N |
| 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 Default Value: 005 |
| 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
Prompt Table: %GP_EDIT_FLD5 |
| 18 | GPES_XTR_COMP_PD | Number(2,0) | SMALLINT NOT NULL | Period used to store compensation to be used to pay extra period. |