HCR_ADDRTYP_LNI

(SQL View)
 Index Back

Address Type Inteface Vw - lng

Interface View for ADDRESS_TYP_LNG - related language record of ADDRESS_TYP_TBL Use to store types of Addresses that a Person can have and the order they should be displayed in.

SELECT A.ADDRESS_TYPE ,A.LANGUAGE_CD ,A.ADDR_TYPE_DESCR ,A.ADDR_TYPE_SHORT FROM PS_ADDRESS_TYP_LNG A

  • Related Language Record for HCR_ADDR_TYP_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ADDR_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Address Type
    4 ADDR_TYPE_SHORT Character(15) VARCHAR2(15) NOT NULL Short Address Type