USA_STATE_VW (SQL View)	Index Back
State Codes/Names w/in USA STATE_NAMES_TBL is delivered pre-loaded with both character and numeric codes for U.S. states and Canadian provinces. The high-order key to the table is COUNTRY. The data in a similar table, STATE_NAMES_OTH, is identical to STATE_NAMES_TBL. The difference is STATE_NAMES_TBL is the edit table for the STATE field and STATE_NAMES_OTH is the edit table for the STATE_OTHER field. If you need a table with state/province names without COUNTRY, use STATE_NAMES_VW.

USA_STATE_VW

(SQL View)

State Codes/Names w/in USA

STATE_NAMES_TBL is delivered pre-loaded with both character and numeric codes for U.S. states and Canadian provinces. The high-order key to the table is COUNTRY. The data in a similar table, STATE_NAMES_OTH, is identical to STATE_NAMES_TBL. The difference is STATE_NAMES_TBL is the edit table for the STATE field and STATE_NAMES_OTH is the edit table for the STATE_OTHER field. If you need a table with state/province names without COUNTRY, use STATE_NAMES_VW.

SELECT state ,numeric_cd ,descr FROM PS_STATE_NAMES_TBL WHERE country = 'USA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NUMERIC_CD Character(2) VARCHAR2(2) NOT NULL Numeric Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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