RS_GEOCODE_VW

(SQL View)
Index Back

SELECT %Substring(RS_LOCATION_DESCR, 1, 30) , POSTAL FROM PS_RS_GEOCODE_CITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
2 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal