PTLT_PORTAL_TMP

index back

Portal URL Text convert

Used by the Application Engine PTLT_SETUP to temporarily store the first 254 characters of the field PSPRSMDEFN.PORTAL_URLTEXT. Reducing to 254 chars is required on Oracle database platforms when the field is to be used in a SQL "where" clause, as is the case in the Application Engine PTLT_SETUP.

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PTLT_PORTAL_URLTXT Character(254) VARCHAR2(254) NOT NULL Portal URL Lgcl Txt, first 254
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19