EMPLMT_SRCH_QRY

(SQL View)
 Index Back

Core VW: Empl Search for QRY

EMPLMT_SRCH_GBL is an Employment Search record containing all of the localized alternate search keys. None of the localized search keys are maked as alternate searches. However, it's easy for a customer to mark any/all of them as alternate search keys if they choose to. Use it to select employee records for you to use when you access a panel. This view shows you records only for employees in departments that your operator class is allowed to access. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches.

SELECT DISTINCT OPR.OPRID , SEC.EMPLID , SEC.EMPL_RCD FROM %Sql(SCRTY_PER_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND SEC.FUTURE_FLG <> 'Y' AND %Sql(SCRTY_WHERE, 'PPLJOB')

# 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