PERSONAL_GEO_VW (SQL View)	Index Back
Map Search Result Map Search Result USE PS_PC_GEOCODE_VW instead of PS_GEOCODE_TBL which packaged with Endeca project

PERSONAL_GEO_VW

(SQL View)

Map Search Result

Map Search Result USE PS_PC_GEOCODE_VW instead of PS_GEOCODE_TBL which packaged with Endeca project

SELECT PS.EMPLID , PS.NAME , JB.JOBCODE , PS.PHONE ,PS.COUNTRY , PS.POSTAL , G.LATITUDE , G.LONGITUDE FROM PS_PERSONAL_DATA PS LEFT OUTER JOIN PS_RS_WO_CURJOB_VW JB ON PS.EMPLID = JB.EMPLID LEFT OUTER JOIN PS_PC_GEOCODE_VW G ON (G.COUNTRY = PS.COUNTRY AND G.POSTAL = PS.POSTAL ) WHERE PS.POSTAL <> ' '

# 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 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

4 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

6 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

7 LATITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Latitude

8 LONGITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Longitude

#	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	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
4	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
5	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
6	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
7	LATITUDE	Signed Number(12,7)	DECIMAL(10,7) NOT NULL	Latitude
8	LONGITUDE	Signed Number(12,7)	DECIMAL(10,7) NOT NULL	Longitude