PERSDATA_ESP_VW

(SQL View)
 Index Back

Personal Data ESP

Personal Data ESP

SELECT DISTINCT A.EMPLID , A.NAME , A.FIRST_NAME , A.LAST_NAME , A.SECOND_LAST_NAME , B.NATIONAL_ID_TYPE , B.NATIONAL_ID , A.SEX , A.BIRTHDATE , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.ADDRESS1 , A.PHONE , A.STATE , A.CITY , A.POSTAL , A.COUNTRY , A.HIGHEST_EDUC_LVL , C.EMAIL_ADDR FROM PS_PERSONAL_DATA A LEFT OUTER JOIN PS_EMAIL_ADDRESSES C ON (A.EMPLID = C.EMPLID AND C.PREF_EMAIL_FLAG = 'Y' ) , PS_PERS_NID B WHERE A.EMPLID = B.EMPLID AND B.PRIMARY_NID = 'Y'

# 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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
6 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
9 BIRTHDATE Date(10) DATE Date of Birth
10 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
11 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

Prompt Table: COUNTRY_TBL

12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
14 STATE Character(6) VARCHAR2(6) NOT NULL State
15 CITY Character(30) VARCHAR2(30) NOT NULL City
16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

18 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level
19 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address