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 FROM PS_PERSONAL_DATA A , 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
X=Indeterminate/Intersex/Unspec
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
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