PRT_ATTR_LNG_VW(SQL View) |
Index Back |
---|---|
Portal Attr Value Tbl (Trans)Lang view to retrieve translated portal object attributes. |
SELECT PORTAL_NAME , PORTAL_REFTYPE , PORTAL_OBJNAME , PORTAL_ATTR_NAM , PORTAL_SEQ_NUM , LANGUAGE_CD , PORTAL_ATTR_VAL FROM PSPRSMATTRVALNG WHERE PORTAL_ATTR_NAM IN ('Keyword','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 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
7 | PORTAL_ATTR_VAL | Long Character | CLOB | The value of the folder or content reference |