PTUN_TAGQRY

(SQL View)

SELECT A.PORTAL_OBJNAME , A.PORTAL_NAME , B.PORTAL_ATTR_NAM , A.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 PSPRSMDEFN A , PSPRSMSYSATTRVL B WHERE A.PORTAL_NAME= B.PORTAL_NAME AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME

Related Language Record: PTUN_TAGQRYLANG

# 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 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label

5 PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name

6 PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name

7 PORTAL_ATTR_VAL Long Character CLOB The value of the folder or content reference

8 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

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

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

11 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	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label
5	PORTAL_CNTPRV_NAM	Character(30)	VARCHAR2(30) NOT NULL	Content Provider Name
6	PORTAL_PRNTOBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Parent Object Name
7	PORTAL_ATTR_VAL	Long Character	CLOB	The value of the folder or content reference
8	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
9	PORTAL_REFTYPE	Character(1)	VARCHAR2(1) NOT NULL	Portal Reference Type C=Content F=Folder
10	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
11	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.