GPES_XTR_FLX_VW

(SQL View)
 Index Back

Extra Pays and Seniority

Extra Pays and Periods regarding with Seniority, used in Tax Calculations

SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , B.GPES_PYMNT_PD , C.GPES_PIN_ER1_NUM , A.EFF_STATUS , B.GPES_XTRPD_FACTOR , B.GPES_YR_PRORATE , B.GPES_PERIOD_FROM , B.GPES_DURATION , C.GPES_EARN_FACTOR , 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SET_LAB_VLD_VW

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 GPES_XTRPD_FACTOR Number(6,2) DECIMAL(5,2) NOT NULL Extra period contribution percentage

Default Value: 100

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_EARN_FACTOR Number(6,2) DECIMAL(5,2) NOT NULL Extra period earning contribution percentage
12 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.