FO_TL_EMPLID_VW (SQL View)	Index Back
Admin/Manager Search Vw Prompt view assigned to EMPLID field on Staffing Rapid Time component. Narrows entries down to those with data in the FO_EMPL_XREF table. 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. 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.

FO_TL_EMPLID_VW

(SQL View)

Admin/Manager Search Vw

Prompt view assigned to EMPLID field on Staffing Rapid Time component. Narrows entries down to those with data in the FO_EMPL_XREF table. 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. 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 DISTINCT OPR1.OPRID , O.CLASSID , E.EMPLID , P.NAME , P.LAST_NAME_SRCH FROM PSCLASSDEFN O , PSOPRDEFN OPR1 , PS_TL_EMPL_DATA E , PS_FO_EMPL_XREF X , PS_PERSON_NAME P WHERE E.EMPLID = X.EMPLID AND E.EMPLID = P.EMPLID AND ((EXISTS ( SELECT 'X' FROM PS_TL_GRP_SECURITY S WHERE S.ROWSECCLASS = O.CLASSID) AND E.EMPLID IN ( SELECT F.EMPLID FROM PS_TL_GRP_SECURITY S , PS_TL_GROUP_DTL F WHERE S.GROUP_ID = F.GROUP_ID AND F.EMPLID = E.EMPLID AND F.EMPL_RCD = E.EMPL_RCD AND S.ROWSECCLASS = O.CLASSID)) OR (NOT EXISTS ( SELECT 'X' FROM PS_TL_GRP_SECURITY S WHERE S.ROWSECCLASS = O.CLASSID) AND E.EMPLID IN ( SELECT SEC.EMPLID FROM %Sql(SCRTY_PER_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_WHERE, 'PPLJOB') AND E.EMPLID = SEC.EMPLID AND E.EMPL_RCD = SEC.EMPL_RCD AND OPR.ROWSECCLASS = OPR1.ROWSECCLASS AND OPR.OPRID = OPR1.OPRID))) AND E.EFFDT = ( SELECT MAX(E1.EFFDT) FROM PS_TL_EMPL_DATA E1 WHERE E1.EMPLID = E.EMPLID AND E1.EMPL_RCD = E.EMPL_RCD AND E1.EFFDT <= %CurrentDateIn) AND EXISTS ( SELECT 'X' FROM PS_JOB J WHERE J.EMPLID = E.EMPLID AND J.EMPL_RCD = E.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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

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

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

5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last 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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name