BNE_CNTCT_SRCH

(SQL View)
 Index Back

OE Component lookup

Used to search for components that begin with 'BNE'

SELECT PNLGRPNAME , DESCR FROM PSPNLGRPDEFN WHERE PNLGRPNAME LIKE 'BNE_PLAN%' OR PNLGRPNAME = 'BNE_CARD_SUMM_FL' OR PNLGRPNAME ='BNE_SEL_EVENT_FL' OR PNLGRPNAME LIKE 'W3EB%' OR PNLGRPNAME LIKE 'BEN%' AND MARKET='GBL'

  • Related Language Record: BNE_CNTCT_SCH_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description