AGC_HPG_VW (SQL View)	Index Back
AGC Homepage View Activity Guide Composer Homepage View

AGC_HPG_VW

(SQL View)

AGC Homepage View

Activity Guide Composer Homepage View

SELECT PORTAL_OBJNAME , PORTAL_LABEL FROM PSPRSMDEFN WHERE PORTAL_CREF_USGT = 'GRPT' AND OBJECTOWNERID <> 'PPT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name

2 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PORTAL_OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Object Name
2	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label