SETIDLABOR_AGREEMENTPrompt Table: EMPL_CTG
EFFDTDefault Value: %date
GPES_PYMNT_PDGPES_PIN_ER1_NUMPrompt Table: %GP_EDIT_FLD4
A=Active
I=Inactive
GPES_LBRXTRP_VW(SQL View) |
Index Back |
|---|---|
Eligible earnings for Xtra PdsEligible earnings for Xtra Pds. Only earning rate components just to get the monthly value without absences.. |
| SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , B.GPES_PYMNT_PD , B.GPES_PIN_ER1_NUM , A.EFF_STATUS , X.PIN_NUM , %Round(B.GPES_EARN_FACTOR / 100, 2) , B.GPES_PIN_AC1_NUM FROM PS_GPES_LBR_AGRMNT A , PS_GPES_LBR_XTRPER B , PS_GP_PIN X WHERE A.SETID = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = B.EFFDT AND X.PIN_PARENT_NUM = B.GPES_PIN_ER1_NUM AND X.AUTO_ASSIGNED_TYPE = 'RT' |
| # | 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
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 |
| 7 | PIN_RATE_NUM | Number(8,0) | INTEGER NOT NULL | PinNumber Rate |
| 8 | GPES_EARN_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period earning contribution percentage |
| 9 | GPES_PIN_AC1_NUM | Number(8,0) | INTEGER NOT NULL | Accumulator Pin Number |