PORTAL_NAMEPORTAL_REFTYPEC=Content
F=Folder
PORTAL_OBJNAMEPV_ADM_PORTL_VW(SQL View) |
Index Back |
|---|
| SELECT A.PORTAL_NAME , A.PORTAL_REFTYPE , A.PORTAL_OBJNAME , A.PORTAL_URLTEXT , A.PORTAL_PRNTOBJNAME , A.DESCR254 , A.PORTAL_PRODUCT , A.PORTAL_LABEL , B.PORTAL_ATTR_NAM , B.PORTAL_ATTR_VAL , ' ' FROM PSPRSMDEFN A , PSPRSMATTRVAL B WHERE A.PORTAL_REFTYPE = B.PORTAL_REFTYPE (+) AND A.PORTAL_NAME = B.PORTAL_NAME (+) AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME (+) AND A.PORTAL_CREF_URLT = 'UPGE' AND A.PORTAL_NAME = 'EMPLOYEE' |
| # | 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_REFTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Portal Reference Type
C=Content F=Folder |
| 3 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 4 | PORTAL_URLTEXT | Long Character | CLOB | Portal URL Logical Text |
| 5 | PORTAL_PRNTOBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Parent Object Name |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | PORTAL_PRODUCT | Character(4) | VARCHAR2(4) NOT NULL | Product for Foler or Content Reference |
| 8 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 9 | PORTAL_ATTR_NAM | Character(30) | VARCHAR2(30) NOT NULL | The name of the folder or content reference |
| 10 | PORTAL_ATTR_VAL | Long Character | CLOB | The value of the folder or content reference |
| 11 | PV_HTMLAREA | Long Character | CLOB | Used in several places for storing html for HTML Areas |