TL_COMP_EES_SCH (SQL View)	Index Back
T&L TR Comp Bal Srch View Search view intended for use by Selfe Service and by Managers to view Comp Balances. The view returns the employee names and job titles for each employee and job that the operator has access to. This view is a clone of TL_ADM_EERCD_VW with Emplid,Empl_Rcd exists in TL_EMPL_COMP 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_COMP_EES_SCH

(SQL View)

T&L TR Comp Bal Srch View

Search view intended for use by Selfe Service and by Managers to view Comp Balances. The view returns the employee names and job titles for each employee and job that the operator has access to. This view is a clone of TL_ADM_EERCD_VW with Emplid,Empl_Rcd exists in TL_EMPL_COMP 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 V.OPRID ,V.EMPLID ,V.EMPL_RCD ,A.COMP_TIME_PLAN ,V.NAME FROM PS_TL_ESS_SRCH_VW V ,PS_TL_EMPL_COMP A WHERE V.EMPLID=A.EMPLID AND V.EMPL_RCD=A.EMPL_RCD AND 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

4 COMP_TIME_PLAN Character(10) VARCHAR2(10) NOT NULL Compensatory Time Off Plan

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	COMP_TIME_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Compensatory Time Off Plan
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name