EO_ADDR_SUBPAGE

(SQL View)
 Index Back

Address subpage

Used on the address format page to select valid subpages for editing an address Object Owner ID marked as SCC

SELECT DISTINCT A.SUBPNLNAME , B.DESCR FROM PSPNLFIELD A , PSPNLDEFN B WHERE A.PNLNAME = 'ADDRESS_SBP' AND A.SUBPNLNAME <> ' ' AND B.PNLNAME = A.SUBPNLNAME UNION SELECT PNLNAME , DESCR FROM PSPNLDEFN WHERE PNLNAME = 'EO_ADDR_GBL_SEC'

  • Related Language Record: EO_ADDR_SUBPGLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description