PSPRUFDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	PORTAL_REFTYPE	Character(1)	VARCHAR2(1) NOT NULL	Portal Reference Type C=Content F=Folder
4	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label
5	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
6	PORTAL_OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Object Name
7	PORTAL_PRNTLABEL	Character(30)	VARCHAR2(30) NOT NULL	Parent Folder
8	PORTAL_SEQ_NUM	Number(4,0)	SMALLINT NOT NULL	Sequence number
9	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.
10	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.
11	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
12	PORTAL_URLTEXT	Long Character	CLOB	Portal URL Logical Text