GPNZ_ABS_ACC (SQL View)	Index Back
Absence Event Definition. Absence Event Definition - Main Record.

GPNZ_ABS_ACC

(SQL View)

Absence Event Definition.

Absence Event Definition - Main Record.

SELECT A.EMPLID ,A.EMPL_RCD ,A.BGN_DT ,A.END_DT ,A.ORIG_BEGIN_DT ,B.ABS_TYPE_OPTN FROM PS_GP_ABS_EVENT A , PS_GP_ABS_TAKE B WHERE B.ABS_TYPE_OPTN = 'ACC' AND A.PIN_TAKE_NUM = B.PIN_NUM AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GP_ABS_TAKE C WHERE C.PIN_NUM = B.PIN_NUM AND B.EFFDT <= %CurrentDateIn)

# 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 END_DT Date(10) DATE end date

5 ORIG_BEGIN_DT Date(10) DATE original begin date
Default Value: GP_ABS_EVENT.BGN_DT

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	END_DT	Date(10)	DATE	end date
5	ORIG_BEGIN_DT	Date(10)	DATE	original begin date Default Value: GP_ABS_EVENT.BGN_DT
6	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type