GPNL_PS_SEC_TMP (SQL Table)	Index Back
Search Subrecord Dept Security in reports. Cloned from the FAST_PERSGL_VW2 record, using the PERS_SGBL_SBR subrecord. Original definition of the PERS_SGBL_SBR subrecord: PERS_SGBL_SBR is used in the PERS_SRCH views holding all basic search fields. Additional fields can be added to the view itself.

GPNL_PS_SEC_TMP

(SQL Table)

Search Subrecord

Dept Security in reports. Cloned from the FAST_PERSGL_VW2 record, using the PERS_SGBL_SBR subrecord. Original definition of the PERS_SGBL_SBR subrecord: PERS_SGBL_SBR is used in the PERS_SRCH views holding all basic search fields. Additional fields can be added to the view itself.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr