RS_PERS_SRCH_VW

(SQL View)
 Index Back

Search Personal Data

This view is used as a search record for the component RS_CM_PERSONAL.

SELECT EMPLID , CASE WHEN ( SELECT 'Y' FROM PSRECDEFN WHERE RECNAME = 'RS_PREF_WRK') = 'Y' AND ( SELECT 'Y' FROM PS_RS_INSTALLATION WHERE RS_PREFERRED_SW = 'Y') = 'Y' AND KNOWN_NAME <> ' ' THEN KNOWN_NAME ELSE NAME END , NAME_DISPLAY , LAST_NAME_SRCH FROM PS_PERSONAL_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name