SCC_CITY_AV_VW (SQL View)	Index Back
City codes Used in populating drop downs when dynamic prompts are used in address format setup. This is marked not to be available for selection as a prompt in the address format setup (via EO_ADDR_LKP_VW1).

SCC_CITY_AV_VW

(SQL View)

City codes

Used in populating drop downs when dynamic prompts are used in address format setup. This is marked not to be available for selection as a prompt in the address format setup (via EO_ADDR_LKP_VW1).

SELECT distinct COUNTRY , CITY FROM PS_EO_ADDR_VALIDAT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CITY Character(30) VARCHAR2(30) NOT NULL City

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	CITY	Character(30)	VARCHAR2(30) NOT NULL	City