PTAI_PUBPGLTLVW

index back

SELECT A.PTPPB_PAGELET_ID , B.LANGUAGE_CD , B.DESCR , B.DESCR254 , A.CREATEOPRID , A.LASTUPDOPRID , %Substring(B1.PTPPB_VALUE, 1, 97) FROM PS_PTPPB_PAGELET A , PS_PTPPB_PGLT_LANG B , PS_PTPPB_PGLT_PRMS B1 WHERE A.PTPPB_DATATYPE_ID = 'ACTIVITY_GUIDE' AND B1.PTPPB_PAGELET_ID = A.PTPPB_PAGELET_ID AND B1.PTPPB_FIELDNAME = '.TEMPLATE_ID'

  • Related language record for PTAI_PUBPGLTSVW
  • PeopleSoft Field Name Field Type Column Type Description
    PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    PTPPB_CHAR_1 Character(97) VARCHAR2(97) NOT NULL Character Field 1
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19