PTPPB_USER_LANG

index back

Pagelet Wizard Person Srch Lng

Related Language Search Record for Pagelet Wizard Personalization
SELECT DISTINCT B.OPRID , A.PTPPB_PAGELET_ID , A1.LANGUAGE_CD , A1.DESCR FROM PS_PTPPB_PAGELET A , PSOPRDEFN B , PS_PTPPB_PGLT_PRMS C , PS_PTPPB_PGLT_LANG A1 WHERE A.PTPPB_PAGELET_ID = C.PTPPB_PAGELET_ID AND A.PTPPB_PAGELET_ID = A1.PTPPB_PAGELET_ID AND C.PTPPB_USAGE_TYPE = 'USE'

  • Related language record for PTPPB_USER_SRCH
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PTPPB_PAGELET_IDCharacter(30)VARCHAR2(30) NOT NULLPagelet ID

    Prompt Table: PTPPB_PAGELET
    Set Control Field: PTPPB_PAGELET_ID

    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