PT_IQ_VWLNG(SQL View) |
Index Back |
|---|
| SELECT D.PORTAL_NAME , D.PORTAL_PRNTOBJNAME , D.PORTAL_OBJNAME , E.LANGUAGE_CD , D.PORTAL_CNTPRV_NAM , D.PORTAL_PRODUCT , D.PORTAL_TEMPL_NAME , D.PORTAL_CREF_URLT , D.PORTAL_CREF_USGT , D.PORTAL_ISPUBLIC , D.OPRID , D.PORTAL_SEQ_NUM , E.PORTAL_LABEL , E.DESCR254 , D.PORTAL_URLTEXT FROM PSPRSMDEFN D , PSPRSMDEFNLANG E WHERE D.PORTAL_REFTYPE = 'C' AND E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_OBJNAME |
| # | 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_PRNTOBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Parent Object Name |
| 3 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | PORTAL_CNTPRV_NAM | Character(30) | VARCHAR2(30) NOT NULL | Content Provider Name |
| 6 | PORTAL_PRODUCT | Character(4) | VARCHAR2(4) NOT NULL | Product for Foler or Content Reference |
| 7 | PORTAL_TEMPL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 8 | 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 |
| 9 | 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 |
| 10 | PORTAL_ISPUBLIC | Number(1,0) | SMALLINT NOT NULL | Is Public |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 12 | PORTAL_SEQ_NUM | Number(4,0) | SMALLINT NOT NULL | Sequence number |
| 13 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 14 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 15 | PORTAL_URLTEXT | Long Character | CLOB | Portal URL Logical Text |