GPES_EST_XTR_VW

(SQL View)
Index Back

Extra per for Earn&Ded assignm

Extra periods for a earning that is entered through Earnings&Deductions assignment.

SELECT X.SETID , X.LABOR_AGREEMENT , X.EFFDT , X.EFF_STATUS , P.GPES_PYMNT_PD , P.GPES_PIN_ER1_NUM , P.GPES_EARN_FACTOR , P.GPES_PIN_AC1_NUM , L.GPES_YR_PRORATE , L.GPES_PERIOD_FROM , L.GPES_DURATION , L.GPES_XTR_ADV_PYMNT FROM PS_GPES_LBR_AGRMNT X , PS_GPES_LBR_XTRPER P , PS_GPES_LBR_XTR_PD L WHERE X.SETID = P.SETID AND X.LABOR_AGREEMENT = P.LABOR_AGREEMENT AND X.EFFDT = P.EFFDT AND L.SETID = P.SETID AND L.LABOR_AGREEMENT = P.LABOR_AGREEMENT AND L.EFFDT = P.EFFDT AND L.GPES_PYMNT_PD = P. GPES_PYMNT_PD

# 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

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 GPES_PYMNT_PD Number(2,0) SMALLINT NOT NULL Extra period payment period
6 GPES_PIN_ER1_NUM Number(8,0) INTEGER NOT NULL Earning Pin Number
7 GPES_EARN_FACTOR Number(6,2) DECIMAL(5,2) NOT NULL Extra period earning contribution percentage
8 GPES_PIN_AC1_NUM Number(8,0) INTEGER NOT NULL Accumulator Pin Number
9 GPES_YR_PRORATE Character(1) VARCHAR2(1) NOT NULL Prorated extra period flag
10 GPES_PERIOD_FROM Number(2,0) SMALLINT NOT NULL Extra period beginning period
11 GPES_DURATION Number(2,0) SMALLINT NOT NULL Extra period timeframe duration in months
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.