PT_IQ_VW |
index back |
|---|
| SELECT A.PORTAL_NAME , A.PORTAL_PRNTOBJNAME , A.PORTAL_OBJNAME , A.PORTAL_CNTPRV_NAM , A.PORTAL_PRODUCT , A.PORTAL_TEMPL_NAME , A.PORTAL_CREF_URLT , A.PORTAL_CREF_USGT , A.PORTAL_ISPUBLIC , A.OPRID , A.PORTAL_SEQ_NUM , A.PORTAL_LABEL , A.DESCR254 , A.PORTAL_URLTEXT FROM PSPRSMDEFN A WHERE A.PORTAL_REFTYPE = 'C' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| PORTAL_PRNTOBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Parent Object Name |
| PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| PORTAL_CNTPRV_NAM | Character(30) | VARCHAR2(30) NOT NULL | Content Provider Name |
| PORTAL_PRODUCT | Character(4) | VARCHAR2(4) NOT NULL | Product for Foler or Content Reference |
| PORTAL_TEMPL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| PORTAL_CREF_URLT | Character(4) | VARCHAR2(4) NOT NULL |
URL Type
NONE=None UEXT=Non-PeopleSoft URL UGEN=PeopleSoft Generic URL UMPG=PeopleSoft Mobile Page UPGE=PeopleSoft Component UPHP=PeopleSoft Portal Homepage Tab UPTM=PeopleSoft Portal Template USCR=PeopleSoft Script WRKL=PeopleSoft Worklist URL |
| 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 TARG=Target |
| PORTAL_ISPUBLIC | Number(1,0) | SMALLINT NOT NULL | Is Public |
| OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| PORTAL_SEQ_NUM | Number(4,0) | SMALLINT NOT NULL | Sequence number |
| PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| PORTAL_URLTEXT | Long Character | CLOB | Portal URL Logical Text |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |