PTLT_PORTAL_STG (SQL Table)	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.

PTLT_PORTAL_STG

(SQL Table)

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 PeopleSoft Field Type Database Column Type Description

1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

2 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder

3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name

4 PTLT_PORTAL_URLTXT Character(254) VARCHAR2(254) NOT NULL Portal URL Lgcl Txt, first 254

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).
2	PORTAL_REFTYPE	Character(1)	VARCHAR2(1) NOT NULL	Portal Reference Type C=Content F=Folder
3	PORTAL_OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Object Name
4	PTLT_PORTAL_URLTXT	Character(254)	VARCHAR2(254) NOT NULL	Portal URL Lgcl Txt, first 254
5	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.