PTWSRPPRODUCERNAMEPTWSRPPORTLETNAMEPT_WSRP_PORT_VW(SQL View) |
Index Back |
|---|
| SELECT PTWSRPPRODUCERNAME , PTWSRPPORTLETNAME , PTWSRP_PLTTITLE , PTWSRP_PLTDESCR FROM PSWSRPPLTDEFN WHERE STATUS = 'A' |
| # | 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 | PTWSRP_PLTTITLE | Character(64) | VARCHAR2(64) NOT NULL | WSRP Portlet Title |
| 4 | PTWSRP_PLTDESCR | Character(254) | VARCHAR2(254) NOT NULL | WSRP Portlet Description |