CURR_STATE_TBL

(SQL View)
 Index Back

State Codes/Names w/in Country

This is a clone to HR's STATE_NAMES_TBL which 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 SAD_TAC_CURR_COUNTRY.

SELECT COUNTRY , STATE , NUMERIC_CD , DESCR , DESCR_AC FROM PS_STATE_TBL

  • Related Language Record: CURR_STATE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_TAC_CURR_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Current 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 Char Description