TRW_SEC_SRCH_VW

(SQL View)
 Index Back

Administer Total Rewards Srch

TRW_SEC_SRCH_VW is used as a search view to select employee records for you to use when you access Administer Total Rewards. One row per EMPLID and distinct Search Items. Uses Security Sets PPLPOI and PPLJOB

SELECT DISTINCT OPR.OPRID ,OPR.ROWSECCLASS ,SEC.EMPLID ,SEC.EMPL_RCD ,NM.NAME_DISPLAY ,NM.NAME_DISPLAY_SRCH ,NM.LAST_NAME_SRCH ,NM.SECOND_LAST_SRCH ,NM.FIRST_NAME ,NM.LAST_NAME ,NM.SECOND_LAST_NAME ,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'))

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
11 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
12 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
13 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
14 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