GPES_ABSEVT_VW (SQL View)	Index Back
Absence Takes ESP This view retrieves the absence takes for 'CUIDADO MENOR' needed for Extra Payments in GP Spain.

GPES_ABSEVT_VW

(SQL View)

Absence Takes ESP

This view retrieves the absence takes for 'CUIDADO MENOR' needed for Extra Payments in GP Spain.

SELECT A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM , A.END_DT , B.ABS_TYPE_OPTN FROM PS_GP_ABS_EVENT A , PS_GP_ABS_TAKE B WHERE A.PIN_TAKE_NUM = B.PIN_NUM

# 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 NOT NULL Begin Date

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

5 END_DT Date(10) DATE NOT NULL end date

6 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type

#	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 NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
5	END_DT	Date(10)	DATE NOT NULL	end date
6	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type