STATE_NAMES_TBL (SQL View)	Index Back
State Codes/Names w/in Country 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.

STATE_NAMES_TBL

(SQL View)

State Codes/Names w/in Country

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 COUNTRY , STATE , NUMERIC_CD , DESCR , DESCR_AC FROM PS_STATE_TBL

Parent Record Of STATE_US_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table: COUNTRY_TBL

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

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

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

5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL
2	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
3	NUMERIC_CD	Character(2)	VARCHAR2(2) NOT NULL	Numeric Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCR_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Description