PTFP_USER_LANG

(SQL View)
 Index Back

Feed Wizard Pers Srch Lng

Related Language Search Record for Feed User Personalization

SELECT DISTINCT B.OPRID , A.PTFP_FEED_ID , C.PORTAL_NAME , A1.LANGUAGE_CD , A1.DESCR FROM PSFP_FEED A , PSOPRDEFN B , PSPRDMDEFN C , PSFP_PARMS D , PSFP_PARMS_LANG A1 WHERE A.PTFP_FEED_ID = D.PTFP_FEED_ID AND A.PTFP_FEED_ID = A1.PTFP_FEED_ID AND D.PTFP_USAGE_TYPE = 'USR' AND C.PORTAL_NAME NOT IN ('PORTAL') AND C.PORTAL_TYPE = ' '

  • Related Language Record for PTFP_USER_SRCH

    • # 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
    Set Control Field: PTFP_FEED_ID

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