PORTAL_NAMEPORTAL_OBJNAMEPTAL_FREF_PVW(SQL View) |
Index Back |
|---|---|
Folder Prompt |
| SELECT PORTAL_NAME , PORTAL_OBJNAME , PORTAL_LABEL FROM %Table(PSPRSMDEFN) WHERE PORTAL_REFTYPE = 'F' AND PORTAL_OBJNAME NOT IN ('PORTAL_BASE_DATA', 'PORTAL_HP_TAB', 'PORTAL_PAGELETS', 'MYFAVORITES') AND PORTAL_PRNTOBJNAME NOT IN ('PORTAL_BASE_DATA', 'PORTAL_HP_TAB', 'PORTAL_PAGELETS') AND (PORTAL_PRODUCT <> 'CFAN' OR PORTAL_PRNTOBJNAME = 'CO_NAVIGATION_COLLECTIONS') |
| # | 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 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |