PTPPB_USER_LANG

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID

    Prompt Table: PTPPB_PAGELET
    Set Control Field: PTPPB_PAGELET_ID

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description