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 NameField TypeColumn TypeDescription
    PTPPB_PAGELET_IDCharacter(30)VARCHAR2(30) NOT NULLPagelet ID
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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_1Character(97)VARCHAR2(97) NOT NULLCharacter Field 1
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19