TL_ADM_COMP_VW (SQL View)	Index Back
T&L Time Rept Comp Plan View This View hold Time Reporters who have Valid Comp Plans 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_ADM_COMP_VW

(SQL View)

T&L Time Rept Comp Plan View

This View hold Time Reporters who have Valid Comp Plans 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 ROWSECCLASS ,EMPLID ,EMPL_RCD ,NAME FROM PS_TL_TR_COMP_SRCH V WHERE EXISTS ( SELECT 'X' FROM PS_TL_EMPL_COMP E WHERE E.EMPLID=V.EMPLID AND E.EMPL_RCD=V.EMPL_RCD)

# 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 Rcd Nbr

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

#	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 Rcd Nbr
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name