GPES_ANT_AUS_VW (SQL View)	Index Back
Absences that affect seniority Retrieves begin and end dates for employee absences that affects seniority years. Its affect seniority by subtracting the number of days between both dates from the seniority years. This operation is done for all the returned rows. At the end the result will be seniority years less the summ off all days between begin and end date of each row.

GPES_ANT_AUS_VW

(SQL View)

Absences that affect seniority

Retrieves begin and end dates for employee absences that affects seniority years. Its affect seniority by subtracting the number of days between both dates from the seniority years. This operation is done for all the returned rows. At the end the result will be seniority years less the summ off all days between begin and end date of each row.

SELECT A.EMPLID , A.EMPL_RCD , A.BGN_DT , B.PIN_NUM , A.END_DT , B.EFFDT , B.EFF_STATUS FROM PS_GP_ABS_EVENT A , PS_GP_ABS_TAKE B WHERE B.PIN_NUM = A.PIN_TAKE_NUM AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GP_ABS_TAKE WHERE PIN_NUM = B.PIN_NUM AND EFFDT <= A.ORIG_BEGIN_DT) AND B.EFF_STATUS <> 'I' AND B.TAKE_CONFIG4 = '01' AND A.PRC_EVT_ACTN_OPTN = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 BGN_DT Date(10) DATE Begin Date

4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

5 END_DT Date(10) DATE end date

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	BGN_DT	Date(10)	DATE	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
5	END_DT	Date(10)	DATE	end date
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive