HCTS_HPG_VW (SQL View)	Index Back
HCTS Homepage View Employee Snapshot Homepage View

HCTS_HPG_VW

(SQL View)

HCTS Homepage View

Employee Snapshot Homepage View

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

# 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