PEOPLE_GLB_SRCH

(SQL View)
 Index Back

People Global Search View

This view is used to display the search results on the panel via the global people search process.

SELECT A.OPRCLASS , A.EMPLID , B.EFFDT , C.COUNTRY , C.NATIONAL_ID_TYPE , C.NID_DESCRSHORT , C.NATIONAL_ID , C.NATIONAL_ID_MSK , A.BIRTHDATE , A.BIRTHDATE_MSK , A.SEX , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , A.CAMPUS_ID , B.NAME_TYPE , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH FROM PS_PEOPLE_SRCH A , PS_HCR_PER_NAME_I B , PS_PERS_NID_MSK_VW C WHERE A.OPRCLASS = C.OPRCLASS AND B.EMPLID = A.EMPLID AND B.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 EFFDT Date(10) DATE Effective Date
4 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
5 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
6 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
9 BIRTHDATE Date(10) DATE Date of Birth
10 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
11 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
12 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
14 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
15 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
16 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

Prompt Table: NAME_TYPE_TBL

17 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
18 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name