EID_USER_VW

(SQL View)
 Index Back

Endeca

Endeca User Profile

SELECT B.OPRID , B.EMAILID , A.FIRST_NAME , A.MIDDLE_NAME , A.LAST_NAME , A.NAME_PREFIX , A.NAME_SUFFIX , A.SEX , A.BIRTHDATE , C.BUSINESS_TITLE , A.COUNTRY_CODE , D.COUNTRY_2CHAR , B.LANGUAGE_CD , %Substring(E.ISO_LOCALE, 1, 2) FROM PS_PERSONAL_DATA A INNER JOIN PS_EMPLOYMENT C ON A.EMPLID = C.EMPLID INNER JOIN PSOPRDEFN B ON A.EMPLID = B.EMPLID LEFT OUTER JOIN PS_COUNTRY_TBL D ON A.COUNTRY = D.COUNTRY LEFT OUTER JOIN PSLANGUAGES E ON B.LANGUAGE_CD = E.LANGUAGE_CD

# 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 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
8 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
9 BIRTHDATE Date(10) DATE Date of Birth
10 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
13 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
14 ISO_LOCALE Character(5) VARCHAR2(5) NOT NULL ISO Locale