GPES_SENCALT_VW (SQL View)	Index Back
Seniority calculation type Retrieve seniority earnings and their assigned flat amount if any. Used to check what seniority earnings are calculated based on a flat amount.

GPES_SENCALT_VW

(SQL View)

Seniority calculation type

Retrieve seniority earnings and their assigned flat amount if any. Used to check what seniority earnings are calculated based on a flat amount.

SELECT S.SETID , S.LABOR_AGREEMENT , S.EFFDT , S.GPES_SEN_MEASU , SE.PIN_NUM , S.GPES_SEN_AMT FROM PS_GPES_LBR_SEN S , PS_GPES_SEN_ERN SE WHERE SE.GPES_SEN_MEASU = S.GPES_SEN_MEASU

# 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 GPES_SEN_MEASU Number(2,0) SMALLINT NOT NULL Seniority measurement, i.e. Trienniums

5 GPES_PIN_ER1_NUM Number(8,0) INTEGER NOT NULL Earning Pin Number
Prompt Table: %GP_EDIT_FLD4

6 GPES_SEN_AMT Number(9,2) DECIMAL(8,2) NOT NULL Seniority flat amount

#	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	GPES_SEN_MEASU	Number(2,0)	SMALLINT NOT NULL	Seniority measurement, i.e. Trienniums
5	GPES_PIN_ER1_NUM	Number(8,0)	INTEGER NOT NULL	Earning Pin Number Prompt Table: %GP_EDIT_FLD4
6	GPES_SEN_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Seniority flat amount