XML_PERSDATA_VW

(SQL View)
 Index Back

View XML Personal Data

View XML Personal Data

SELECT DISTINCT A.EMPLID , A.NAME , A.FIRST_NAME , A.LAST_NAME , A.SECOND_LAST_NAME , A.SEX , A.BIRTHDATE , A.BIRTHCOUNTRY , A.ADDR_FIELD1 %Concat ' ' %Concat A.ADDRESS1 %Concat ', ' %Concat A.ADDR_FIELD2 , A.ADDRESS1 , A.PHONE , A.STATE , A.CITY , A.POSTAL , A.COUNTRY FROM PS_PERSONAL_DATA A

# 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 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
7 BIRTHDATE Date(10) DATE Date of Birth
8 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
9 ADDRESS100 Character(100) VARCHAR2(100) NOT NULL Address 1
10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
11 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
12 STATE Character(6) VARCHAR2(6) NOT NULL State
13 CITY Character(30) VARCHAR2(30) NOT NULL City
14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country