PRT_ATTRB_VW(SQL View) |
Index Back |
---|---|
Portal Attr Value TblBase Portal Registry Attribute Value view used in Translate Portal Objects page. |
SELECT PORTAL_NAME , PORTAL_REFTYPE , PORTAL_OBJNAME , PORTAL_ATTR_NAM , PORTAL_SEQ_NUM , PORTAL_ATTR_VAL FROM PSPRSMATTRVAL WHERE PORTAL_ATTR_NAM IN ('Keyword', 'KEYWORD') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). | |
2 | Character(1) | VARCHAR2(1) NOT NULL |
Portal Reference Type
C=Content F=Folder |
|
3 | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name | |
4 | Character(30) | VARCHAR2(30) NOT NULL | The name of the folder or content reference | |
5 | Number(4,0) | SMALLINT NOT NULL | Sequence number | |
6 | PORTAL_ATTR_VAL | Long Character | CLOB | The value of the folder or content reference |