PTFP_USER_SRCH

(SQL View)
 Index Back

Feed Wizard Pers Srch Rec

Search Record for Feed User Personalization

SELECT DISTINCT B.OPRID , A.PTFP_FEED_ID , C.PORTAL_NAME , A.DESCR FROM PSFP_FEED A , PSOPRDEFN B , PSPRDMDEFN C WHERE C.PORTAL_NAME NOT IN ('PORTAL') AND C.PORTAL_TYPE = ' '

  • Related Language Record: PTFP_USER_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PTFP_FEED_ID Character(30) VARCHAR2(30) NOT NULL Feed ID (see PSFP_FEED).

    Prompt Table: PSFP_FEED

    3 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description