TRW_SEC_SRCH_LV

(SQL View)
 Index Back

Administer Total Rewards Lng

TRW_SEC_SRCH_LV is related language record for TRW_SEC_SRCH_VW for Global Names in future.

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