STATE_TBL

(SQL Table)
 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.

  • Related Language Record: STATE_TBL_LANG

  • Parent Record Of CAN_YE_PROVZ_VW CAN_YE_PROV_VW CAN_YE_STATE_VW CITY_TBL_ITA PY_JUR_STATE_VW PY_STATE_US_VW STATE_INST_VW STATE_NM_CAN_VW STATE_NM_USA_VW STATE_NM_US_VW STATE_US_SRCH STATE_US_VW TL_US_STATE_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 NUMERIC_CD Character(2) VARCHAR2(2) NOT NULL Numeric Code
    5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Char Description