TL_ADMD_SRCH_LG (SQL View)	Index Back
T&L EMPL_RCD F4 prompt view This view is a clone of TL_ADM_SRCH_VW with EMP_RCD set as a key. Access is determined by the TL Group Security defined for the Operator's Row Security Class. When the Operator's Row Security Class has no specific Group Security, HR Department Security is used to determine access.

TL_ADMD_SRCH_LG

(SQL View)

T&L EMPL_RCD F4 prompt view

This view is a clone of TL_ADM_SRCH_VW with EMP_RCD set as a key. Access is determined by the TL Group Security defined for the Operator's Row Security Class. When the Operator's Row Security Class has no specific Group Security, HR Department Security is used to determine access.

SELECT A.ROWSECCLASS , A.EMPLID , A.EMPL_RCD , %DateIn(%Date('1900-01-01')) , A.LANGUAGE_CD , A.JOBCODE_DESCR FROM PS_TL_ADM_EERCDLNG A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

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

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

4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
Default Value: %Date

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date. Default Value: %Date
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description