HR_GSS_NAME_VW

(SQL View)
 Index Back

Active Employee Dynamic View

Dynamic view used to retrieve active employees current as of a particular date.

SELECT DISTINCT A.NAME_DISPLAY , A.FIRST_NAME_SRCH , A.LAST_NAME_SRCH , A.SECOND_LAST_SRCH , A.FIRST_NAME , A.LAST_NAME , A.SECOND_LAST_NAME FROM PS_PERSON_NAME A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
2 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
4 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name