PSPTCS_USRPRSNL

#	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_OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Object Name
3	ITEMNAME	Character(30)	VARCHAR2(30) NOT NULL	Item Name
4	PTCS_MAPPEDFLD	Character(254)	VARCHAR2(254) NOT NULL	Mapped To
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	PTCS_ISHIDDEN	Character(1)	VARCHAR2(1) NOT NULL	Hidden Default Value: N
7	PTCS_MENUTYPE	Character(4)	VARCHAR2(4) NOT NULL	Menu Display Type FLDM=Field Menu MMNU=Drop-Down Menu PGBM=Pivot grid Bulk Menu RCF=Related Content Frame RCMU=Related Content Menu
8	PTCS_SERVICEID	Character(30)	VARCHAR2(30) NOT NULL	Services ID (see PSPTCSSRVDEFN).
9	PTCS_INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	Instance ID
10	PTCS_SRVCATTR	Character(4)	VARCHAR2(4) NOT NULL	Template Based
11	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
12	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.
13	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.
14	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
15	PTCS_SEQNUM_MMNU	Number(3,0)	SMALLINT NOT NULL	Sequence Number