STATE_NAMES_OTH

(SQL View)
 Index Back

States and Provinces

STATE_NAMES_OTH is a view of 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.

SELECT A.COUNTRY ,A.STATE ,A.NUMERIC_CD ,A.DESCR FROM PS_STATE_NAMES_TBL A

  • Related Language Record: STATE_N_OTH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Default Value: INSTALLATION.COUNTRY

    Prompt Table: COUNTRY_TBL

    2 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other
    3 NUMERIC_CD Character(2) VARCHAR2(2) NOT NULL Numeric Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description