PORTAL_NAMEPORTAL_TEMPOBJNAMEFRMT=Frame template
GRPT=Fluid Homepage
HPGC=Pagelet
HPGT=Homepage tab
HTMT=HTML template
IFRM=Inline frame template
LINK=Content Reference Link
SECT=Section template
TARG=Target
PORTAL_TEMP_VW(SQL View) |
Index Back |
|---|
| SELECT PORTAL_PRNTOBJNAME , PORTAL_NAME , PORTAL_OBJNAME , PORTAL_LABEL , PORTAL_CREF_USGT FROM PSPRSMDEFN WHERE PORTAL_PRNTOBJNAME = 'PORTAL_TEMPLATES' AND PORTAL_CREF_USGT IN('HTMT', 'FRMT', 'IFRM') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_PRNTOBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Parent Object Name |
| 2 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 3 | PORTAL_TEMPOBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 4 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Label |
| 5 | PORTAL_CREF_USGT | Character(4) | VARCHAR2(4) NOT NULL |
Usage Type
FRMT=Frame template GRPT=Fluid Homepage HPGC=Pagelet HPGT=Homepage tab HTMT=HTML template IFRM=Inline frame template LINK=Content Reference Link SECT=Section template TARG=Target |