PTUN_TAGQRYLANG

(SQL View)

SELECT A.PORTAL_OBJNAME , A.PORTAL_NAME , B.PORTAL_ATTR_NAM , C.LANGUAGE_CD , C.PORTAL_LABEL , A.PORTAL_CNTPRV_NAM , A.PORTAL_PRNTOBJNAME , B.PORTAL_ATTR_VAL , A.PORTAL_CREF_USGT , A.PORTAL_REFTYPE , A.VERSION , A.LASTUPDDTTM FROM PSPRSMDEFNLANG C , PSPRSMDEFN A , PSPRSMSYSATTRVL B WHERE A.PORTAL_NAME= B.PORTAL_NAME AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PORTAL_OBJNAME = C.PORTAL_OBJNAME AND A.PORTAL_NAME= C.PORTAL_NAME

Related Language Record for PTUN_TAGQRY

# 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 PORTAL_ATTR_NAM Character(30) VARCHAR2(30) NOT NULL The name of the folder or content reference

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 PORTAL_ATTR_VAL Long Character CLOB The value of the folder or content reference

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

10 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder

11 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	PORTAL_ATTR_NAM	Character(30)	VARCHAR2(30) NOT NULL	The name of the folder or content reference
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	PORTAL_ATTR_VAL	Long Character	CLOB	The value of the folder or content reference
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
10	PORTAL_REFTYPE	Character(1)	VARCHAR2(1) NOT NULL	Portal Reference Type C=Content F=Folder
11	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.