PC_GEOCODE_TEAM (SQL View)	Index Back
Project Team Location Geocodes This view selects project team members and converts their home address into latitude and longitude geocodes.

PC_GEOCODE_TEAM

(SQL View)

Project Team Location Geocodes

This view selects project team members and converts their home address into latitude and longitude geocodes.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , A.NAME , A.PROJ_ROLE , A.COST_RATE , A.CURRENCY_CD , '@TM' , A.FMS_LASTUPDDTTM , A.CITY , A.STATE , A.COUNTRY , A.POSTAL , B.LATITUDE , B.LONGITUDE , %NumToChar(B.LATITUDE) %Concat ' ' %Concat %NumToChar(B.LONGITUDE) FROM PS_PC_TEAM_LOC_VW A , PS_GEOCODE_TBL B WHERE A.CITY = B.CITY AND A.STATE = B.STATE AND A.COUNTRY = B.COUNTRY AND A.POSTAL = B.POSTAL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

6 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

9 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

10 CITY Character(30) VARCHAR2(30) NOT NULL City
Prompt Table: RS_GEOCODE_CITY

11 STATE Character(6) VARCHAR2(6) NOT NULL State

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

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

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

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

16 GEOCODE Character(30) VARCHAR2(30) NOT NULL The geocode of an address, created by concatenating the address latitude, blank space, longitude.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
6	COST_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Rate
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
9	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City Prompt Table: RS_GEOCODE_CITY
11	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
13	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
14	LATITUDE	Signed Number(12,7)	DECIMAL(10,7) NOT NULL	Latitude
15	LONGITUDE	Signed Number(12,7)	DECIMAL(10,7) NOT NULL	Longitude
16	GEOCODE	Character(30)	VARCHAR2(30) NOT NULL	The geocode of an address, created by concatenating the address latitude, blank space, longitude.