HCIEOADDRFMTLVW

(SQL View)
 Index Back

Address fields

This interface related language view is a listing of the distinct address fields that are used in the makeup of the address.

SELECT A.COUNTRY ,A.EO_ADDRESS_FIELD ,A.LANGUAGE_CD ,A.EO_ADDR_FLD_LBL FROM %Table(EO_ADDRFMT_LANG) A

  • Related Language Record for HCI_EOADDRFMTVW

  • Parent record: COUNTRY_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 EO_ADDRESS_FIELD Character(18) VARCHAR2(18) NOT NULL Address field
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EO_ADDR_FLD_LBL Character(30) VARCHAR2(30) NOT NULL Address 2 Label Object Owner ID marked as SCC