GPES_SENSEG_VW (SQL View)	Index Back
Seniority measurement Segments Seniority measurement Segments

GPES_SENSEG_VW

(SQL View)

Seniority measurement Segments

SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , D.SEQNUM , A.EFF_STATUS , A.GPES_SEN_CONSL , A.GPES_NEXT_EFFDT , A.GPES_PIN_SE1_NUM , X.PIN_NUM , X.PIN_RATE_NUM , D.GPES_SEN_MEASU , D.GPES_SEN_OCCURS , D.GPES_SEN_AMT , D.CURRENCY_CD , D.GPES_SEN_PCT , Z.PIN_AA_RATE_NUM FROM PS_GPES_LBR_AGRMNT A , PS_GPES_LBR_SEN D , PS_GPES_SEN_ERN G , PS_GPES_ERN_RATECD X , PS_GP_PIN_CMPNT Z WHERE A.SETID = D.SETID AND A.LABOR_AGREEMENT = D.LABOR_AGREEMENT AND A.EFFDT = D.EFFDT AND G.GPES_SEN_MEASU = D.GPES_SEN_MEASU AND X.PIN_NUM = G.PIN_NUM AND Z.PIN_NUM = G.PIN_NUM AND X.EFFDT = ( SELECT MAX(X_ED.EFFDT) FROM PS_GPES_ERN_RATECD 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

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

6 GPES_SEN_CONSL Character(1) VARCHAR2(1) NOT NULL Seniority consolidation flag
Y/N Table Edit
Default Value: N

7 GPES_NEXT_EFFDT Date(10) DATE Effective date value of the next row

8 GPES_PIN_SE1_NUM Number(8,0) INTEGER NOT NULL Seniority Calculation rule Pin Number
Prompt Table: %GP_EDIT_FLD3

9 GPES_PIN_ER1_NUM Number(8,0) INTEGER NOT NULL Earning Pin Number

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

11 GPES_SEN_MEASU Number(2,0) SMALLINT NOT NULL Seniority measurement, i.e. Trienniums

12 GPES_SEN_OCCURS Number(2,0) SMALLINT NOT NULL Number of times a seniority segment occurs
Default Value: 99

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

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

15 GPES_SEN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Seniority percentage over a base

16 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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	GPES_SEN_CONSL	Character(1)	VARCHAR2(1) NOT NULL	Seniority consolidation flag Y/N Table Edit Default Value: N
7	GPES_NEXT_EFFDT	Date(10)	DATE	Effective date value of the next row
8	GPES_PIN_SE1_NUM	Number(8,0)	INTEGER NOT NULL	Seniority Calculation rule Pin Number Prompt Table: %GP_EDIT_FLD3
9	GPES_PIN_ER1_NUM	Number(8,0)	INTEGER NOT NULL	Earning Pin Number
10	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate
11	GPES_SEN_MEASU	Number(2,0)	SMALLINT NOT NULL	Seniority measurement, i.e. Trienniums
12	GPES_SEN_OCCURS	Number(2,0)	SMALLINT NOT NULL	Number of times a seniority segment occurs Default Value: 99
13	GPES_SEN_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Seniority flat amount
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
15	GPES_SEN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Seniority percentage over a base
16	PIN_AA_RATE_NUM	Number(8,0)	INTEGER NOT NULL	Element number field