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 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
X=Indeterminate/Intersex/Unspec
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