PORTAL_OBJNAMEPORTAL_NAMEROLENAMELANGUAGE_CDFRMT=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
PTUN_ROLQRYLANG(SQL View) |
Index Back |
|---|
| SELECT A.PORTAL_OBJNAME ,A.PORTAL_NAME ,%Upper(C.ROLENAME) ,D.LANGUAGE_CD ,D.PORTAL_LABEL ,A.PORTAL_CNTPRV_NAM ,A.PORTAL_PRNTOBJNAME ,C.ROLENAME ,A.PORTAL_CREF_USGT FROM PSPRSMDEFNLANG D , PSPRSMDEFN A ,PSPRSMPERM B ,PSROLECLASS C WHERE A.PORTAL_NAME= B.PORTAL_NAME AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PORTAL_REFTYPE='C' AND A.PORTAL_REFTYPE = B.PORTAL_REFTYPE AND C.CLASSID = B.PORTAL_PERMNAME AND A.PORTAL_URI_SEG1 <> ' ' AND A.PORTAL_URI_SEG2 <> ' ' AND A.PORTAL_URI_SEG3 <> ' ' AND A.PORTAL_NAME= D.PORTAL_NAME AND A.PORTAL_OBJNAME = D.PORTAL_OBJNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 2 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 3 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 6 | PORTAL_CNTPRV_NAM | Character(30) | VARCHAR2(30) NOT NULL | Content Provider Name |
| 7 | PORTAL_PRNTOBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Parent Object Name |
| 8 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 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 |