SCC_STATE_NM_VW

(SQL View)
Index Back

State Names for Australia

No related language view can be created because the basis of this view, STATE_NAMES_TBL, has no related language table.

SELECT STATE ,DESCR , NUMERIC_CD FROM PS_STATE_NAMES_TBL WHERE COUNTRY = 'AUS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STATE Character(6) VARCHAR2(6) NOT NULL State
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 NUMERIC_CD Character(2) VARCHAR2(2) NOT NULL Numeric Code