PSPRDMDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name
2	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
3	PORTAL_TEMPL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Template Name
4	PORTAL_REMOTE	Character(1)	VARCHAR2(1) NOT NULL	Portal Remote Flag
5	PORTAL_HOSTNODENAM	Character(30)	VARCHAR2(30) NOT NULL	Portal Host Node Name
6	PORTAL_ISFOLDERNAV	Number(1,0)	SMALLINT NOT NULL	Is Folder Navigation Enabled Default Value: 0
7	PORTAL_FLDR_NAVOBJ	Character(30)	VARCHAR2(30) NOT NULL	Folder Navigation Object Name
8	PT_ABN_CHARTNAVOBJ	Character(30)	VARCHAR2(30) NOT NULL	Chart Navigation Object Name
9	PORTAL_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Portal Type LOC=Local REM=Remote
10	PORTAL_EFFDT	Date(10)	DATE	Portal Effective Date
11	PORTAL_EXPIRE_DT	Date(10)	DATE	Expiration date of folder or content reference
12	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
13	PORTAL_ADMROLE	Character(30)	VARCHAR2(30) NOT NULL	Added in 8.46 as part of Collaborated Workspaces project.
14	PORTAL_ISHPMODFYLK	Number(1,0)	SMALLINT NOT NULL	Whether to display Modify Content/Layout liknks on Portal HomePage . Added in 8.46 as part of Collaborated Workspaces project. Default Value: 0
15	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label
16	PORTAL_CATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Portal Name
17	PORTAL_CREATEDFROM	Character(30)	VARCHAR2(30) NOT NULL	Portal Name
18	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
19	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
20	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
21	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies 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.
22	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.
23	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
24	PORTAL_WELCOMETEXT	Long Character	CLOB	Portal Welcome Text