HR_TBH_ADFMTVW

(SQL View)
 Index Back

Address Section Prompt View

View for prompting of valid address format values for Address Sections.

SELECT A.COUNTRY , A.DESCR , A.DESCRSHORT FROM PS_COUNTRY_TBL A , PS_EO_ADDR_SUBPAGE B WHERE A.COUNTRY = %Substring(B.PNLNAME, 9, 3) UNION SELECT FIELDVALUE , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME = 'MARKET' AND FIELDVALUE = 'GBL'

  • Related Language Record: HR_TBH_ADFMTVWL

    • # 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description