ABE_COUNTRY_VW

(SQL View)
 Index Back

Address Book Country Config

Displays just the fields available for country.

SELECT A.COUNTRY , %subrec(ABE_COUNTRY_SBR,A) FROM %Table(COUNTRY_TBL) A

  • Related Language Record: ABE_COUNTRY_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 ADDR1_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 1 Available

    Y/N Table Edit

    Default Value: Y

    4 ADDR2_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 2 Available

    Y/N Table Edit

    Default Value: Y

    5 ADDR3_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 3 Available

    Y/N Table Edit

    Default Value: Y

    6 ADDR4_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 4 Available

    Y/N Table Edit

    Default Value: Y

    7 CITY_AVAIL Character(1) VARCHAR2(1) NOT NULL City Available

    Y/N Table Edit

    Default Value: Y

    8 NUM1_AVAIL Character(1) VARCHAR2(1) NOT NULL Number 1 Available

    Y/N Table Edit

    Default Value: N

    9 NUM2_AVAIL Character(1) VARCHAR2(1) NOT NULL Number 2 Available

    Y/N Table Edit

    Default Value: N

    10 HOUSE_TYPE_AVAIL Character(1) VARCHAR2(1) NOT NULL House Type Available

    Y/N Table Edit

    Default Value: N

    11 ADDR_FIELD1_AVAIL Character(1) VARCHAR2(1) NOT NULL Address Field 1 Available

    Y/N Table Edit

    Default Value: N

    12 ADDR_FIELD2_AVAIL Character(1) VARCHAR2(1) NOT NULL Address Field 2 Available

    Y/N Table Edit

    Default Value: N

    13 ADDR_FIELD3_AVAIL Character(1) VARCHAR2(1) NOT NULL Address Field 3 Available

    Y/N Table Edit

    Default Value: N

    14 COUNTY_AVAIL Character(1) VARCHAR2(1) NOT NULL County Available

    Y/N Table Edit

    Default Value: Y

    15 STATE_AVAIL Character(1) VARCHAR2(1) NOT NULL State Available

    Y/N Table Edit

    Default Value: Y

    16 POSTAL_AVAIL Character(1) VARCHAR2(1) NOT NULL Postal Available

    Y/N Table Edit

    Default Value: Y

    17 IN_CITY_LIM_AVAIL Character(1) VARCHAR2(1) NOT NULL In City Limit Available

    Y/N Table Edit

    Default Value: N

    18 GEO_CODE_AVAIL Character(1) VARCHAR2(1) NOT NULL Geo Code Availabel

    Y/N Table Edit

    Default Value: N

    19 POST_SRCH_AVAIL Character(1) VARCHAR2(1) NOT NULL Post Search Available

    Y/N Table Edit

    Default Value: Y