GPES_SENBSE_VW (SQL View)	Index Back
Seniority base earnings Seniority base earnings Retrieves the value of each earning rate component that contributes to the seniority base. This is intended to avoid absences and to get the base amount for the month in process

GPES_SENBSE_VW

(SQL View)

Seniority base earnings

Seniority base earnings Retrieves the value of each earning rate component that contributes to the seniority base. This is intended to avoid absences and to get the base amount for the month in process

SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , X.PIN_RATE_NUM , A.EFF_STATUS , B.PIN_NUM , Y.PIN_AA_RATE_NUM FROM PS_GPES_LBR_AGRMNT A , PS_GPES_SEN_BSE_ER B , PS_GP_ERN_DED X , PS_GP_PIN_CMPNT Y WHERE A.SETID = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = B.EFFDT AND X.PIN_NUM = B.PIN_NUM AND Y.PIN_NUM = B.PIN_NUM AND X.EFFDT = ( SELECT MAX(X_ED.EFFDT) FROM PS_GP_ERN_DED X_ED WHERE X_ED.PIN_NUM = X.PIN_NUM AND X_ED.EFFDT <= %CurrentDateIn)

# 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 NOT NULL Effective Date
Default Value: %date

4 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

7 PIN_AA_RATE_NUM Number(8,0) INTEGER NOT NULL Element number field

#	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 NOT NULL	Effective Date Default Value: %date
4	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
7	PIN_AA_RATE_NUM	Number(8,0)	INTEGER NOT NULL	Element number field