PTLT_PORTAL_STG - Portal URL Text convert - PeopleTools Table Reference

PTLT_PORTAL_STG	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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

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.