SCC_CNTY_AV_VW

(SQL View)
 Index Back

County values

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 , County 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 COUNTY Character(30) VARCHAR2(30) NOT NULL County