TL_ADMD_SRCH_VW (SQL View)	Index Back
Self Service Search Vw Search view intended for use by administrative operators such as data entry clerks or with Manager events. The view returns the employee names and job titles for each employee and job that the operator has access to, as well as all dates in the TL_DATES table. 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. This date driven view is used by events that need a date (possibly different from the current date) to determine the correct date range to display and update data. The Manage Weekly Time event is a good example.

TL_ADMD_SRCH_VW

(SQL View)

Self Service Search Vw

Search view intended for use by administrative operators such as data entry clerks or with Manager events. The view returns the employee names and job titles for each employee and job that the operator has access to, as well as all dates in the TL_DATES table. 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. This date driven view is used by events that need a date (possibly different from the current date) to determine the correct date range to display and update data. The Manage Weekly Time event is a good example.

SELECT A.ROWSECCLASS , A.EMPLID , A.EMPL_RCD , %DateIn(%Date('1900-01-01')) , A.NAME , A.JOBCODE , A.JOBCODE_DESCR , A.TL_SYSTEM_DT FROM PS_TL_ADM_SRCH_VW A

Related Language Record: TL_ADMD_SRCH_LG

# 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
Prompt Table: TL_ADM_NAME_VW

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: TL_ADM_EERCD_VW

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

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

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

8 TL_SYSTEM_DT Date(10) DATE TL System Date

#	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 Prompt Table: TL_ADM_NAME_VW
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: TL_ADM_EERCD_VW
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date. Default Value: %Date
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
7	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
8	TL_SYSTEM_DT	Date(10)	DATE	TL System Date