GEOG_PREF_TBL

(SQL Table)
 Index Back

Geographic Preference setup

This is the setup table that contains codes of preferred regions to work in.

  • Related Language Record: GEOG_PREF_LANG

  • Parent Record Of GEOG_PREF_LANG JPM_GEOG_PRF_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GEOG_PREFERENCE Character(2) VARCHAR2(2) NOT NULL Geographic Preferences
    C=Canada
    E=East
    I=International
    MW=Midwest
    N=North
    NE=Northeast
    NW=Northwest
    S=South
    SE=Southeast
    SW=Southwest
    W=West
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description