PSWSRPPLTDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTWSRPPRODUCERNAME	Character(25)	VARCHAR2(25) NOT NULL	WSRP Producer Name (see PSWSRPPRDDEFN).
2	PTWSRPPORTLETNAME	Character(25)	VARCHAR2(25) NOT NULL	Portlet Name (PS table key)
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
4	PTWSRPLASTREFRESH	DateTime(26)	TIMESTAMP	Date/Time when GetServiceDescription was issued last time
5	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
6	PTWSRPISOBSOLETE	Number(1,0)	SMALLINT NOT NULL	Is Portlet obsolete - i.e. not any more in the list of offered portlets
7	PTWSRP_PLTDESCR	Character(254)	VARCHAR2(254) NOT NULL	WSRP Portlet Description
8	PTWSRP_PLTSHORTITL	Character(64)	VARCHAR2(64) NOT NULL	WSRP Portlet Description
9	PTWSRP_PLTTITLE	Character(64)	VARCHAR2(64) NOT NULL	WSRP Portlet Title
10	PTWSRP_PLTDISPNAME	Character(64)	VARCHAR2(64) NOT NULL	WSRP Portlet Display Name
11	PTWSRP_ISEDITMODE	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet OnlySecure
12	PTWSRP_ISHELPMODE	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet OnlySecure
13	PTWSRP_ISMETHODGET	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet usesMethodGet
14	PTWSRP_ISDFMKSECUR	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet DefaultMarkupSecure
15	PTWSRP_ISONLYSECUR	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet OnlySecure
16	PTWSRP_ISUSRCTXSTR	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet userContextStoredInSession
17	PTWSRP_ISTMPLTSSTR	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet TemplatesStoredInSession
18	PTWSRP_ISUSRSPECST	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet HasUserSpecificState
19	PTWSRP_ISURLTMPROC	Number(1,0)	SMALLINT NOT NULL	WSRP Portlet doesUrlTemplateProcessing
20	PTWSRP_PLTHANDLE	Character(254)	VARCHAR2(254) NOT NULL	WSRP Portlet Handle (255 chars max)
21	PTWSRP_PLTHANDLE1	Character(1)	VARCHAR2(1) NOT NULL	WSRP Portlet Handle (255 chars max)
22	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
23	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.
24	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.