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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PTFP_FEED_IDCharacter(30)VARCHAR2(30) NOT NULLFeed ID (see PSFP_FEED).

    Prompt Table: PSFP_FEED
    Set Control Field: PTFP_FEED_ID

    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19