PER_SEC_SRCH_VW

(SQL View)
 Index Back

Srch for Workforce Job Summary

PER_SEC_SRCH_VW is used as a search view to select person records for you to use when you access the panel Workforce Job Summary. One row per EMPLID and distinct Search Items. Uses Security Sets PPLPOI and PPLJOB

SELECT DISTINCT OPR.OPRID , SEC.EMPLID ,SEC.EMPL_RCD ,OPR.ROWSECCLASS ,NM.NAME_DISPLAY ,NM.NAME_DISPLAY_SRCH ,NM.LAST_NAME_SRCH ,NM.SECOND_LAST_SRCH ,NM.NAME_AC ,NM.MIDDLE_NAME ,SEC.PER_ORG FROM %Sql(SCRTY_PER_NM_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_NAME) AND (%Sql(SCRTY_WHERE, 'PPLJOB') OR %Sql(SCRTY_WHERE, 'PPLPOI'))

  • Related Language Record: PERSON_NAME_LNG

    • # 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 Record
    4 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    8 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    9 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    11 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest