PRT_ATTR_LNG_VW

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 Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_ATTR_NAM Character(30) VARCHAR2(30) NOT NULL The name of the folder or content reference
PORTAL_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence number
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
PORTAL_ATTR_VAL Long Character CLOB The value of the folder or content reference
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19