PTFP_USER_LANG

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 Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    PTFP_FEED_ID Character(30) VARCHAR2(30) NOT NULL Feed ID (see PSFP_FEED).

    Prompt Table: PSFP_FEED
    Set Control Field: PTFP_FEED_ID

    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19