HGA_SRCH_EVT_VW (SQL View)	Index Back
Absence Events View Absence Events View

HGA_SRCH_EVT_VW

(SQL View)

Absence Events View

SELECT EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM , END_DT , TRANSACTION_NBR FROM PS_GP_ABS_EVENT

# 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 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

#	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	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.