PSWSRPPLTDEFN |
index back |
|---|---|
Remote WSRP Portlet Definition |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
PTWSRPPRODUCERNAME |
Character(25) | VARCHAR2(25) NOT NULL | WSRP Producer Name (see PSWSRPPRDDEFN). |
PTWSRPPORTLETNAME |
Character(25) | VARCHAR2(25) NOT NULL | Portlet Name (PS table key) |
| STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| PTWSRPLASTREFRESH | DateTime(26) | TIMESTAMP | Date/Time when GetServiceDescription was issued last time |
| CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
| PTWSRPISOBSOLETE | Number(1,0) | SMALLINT NOT NULL | Is Portlet obsolete - i.e. not any more in the list of offered portlets |
| PTWSRP_PLTDESCR | Character(254) | VARCHAR2(254) NOT NULL | WSRP Portlet Description |
| PTWSRP_PLTSHORTITL | Character(64) | VARCHAR2(64) NOT NULL | WSRP Portlet Description |
| PTWSRP_PLTTITLE | Character(64) | VARCHAR2(64) NOT NULL | WSRP Portlet Title |
| PTWSRP_PLTDISPNAME | Character(64) | VARCHAR2(64) NOT NULL | WSRP Portlet Display Name |
| PTWSRP_ISEDITMODE | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet OnlySecure |
| PTWSRP_ISHELPMODE | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet OnlySecure |
| PTWSRP_ISMETHODGET | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet usesMethodGet |
| PTWSRP_ISDFMKSECUR | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet DefaultMarkupSecure |
| PTWSRP_ISONLYSECUR | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet OnlySecure |
| PTWSRP_ISUSRCTXSTR | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet userContextStoredInSession |
| PTWSRP_ISTMPLTSSTR | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet TemplatesStoredInSession |
| PTWSRP_ISUSRSPECST | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet HasUserSpecificState |
| PTWSRP_ISURLTMPROC | Number(1,0) | SMALLINT NOT NULL | WSRP Portlet doesUrlTemplateProcessing |
| PTWSRP_PLTHANDLE | Character(254) | VARCHAR2(254) NOT NULL | WSRP Portlet Handle (255 chars max) |
| PTWSRP_PLTHANDLE1 | Character(1) | VARCHAR2(1) NOT NULL | WSRP Portlet Handle (255 chars max) |
| VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 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. |
| 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. |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |