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 NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_REFTYPECharacter(1)VARCHAR2(1) NOT NULLPortal Reference Type
PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
PTLT_PORTAL_URLTXTCharacter(254)VARCHAR2(254) NOT NULLPortal URL Lgcl Txt, first 254
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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, 8.54
PTRef generated on 09-JUN-19