APP_DES_TLS_VW (SQL View)	Index Back
App Designer Objects This SQL view retrieves the DESCR that a user will see, as well as the OBJNAME which will be stored in PSAUTHITEM from PS_APP_DES_OBJECTS where the APP_DES_CATEGORY = 'Objects'. It will be the GRID record in the page where a user assigns access permissions to Objects within Application Designer.

APP_DES_TLS_VW

(SQL View)

App Designer Objects

This SQL view retrieves the DESCR that a user will see, as well as the OBJNAME which will be stored in PSAUTHITEM from PS_APP_DES_OBJECTS where the APP_DES_CATEGORY = 'Objects'. It will be the GRID record in the page where a user assigns access permissions to Objects within Application Designer.

SELECT OBJNAME , DESCR FROM PS_APP_DES_OBJECTS WHERE APP_DES_CATEGORY = '2'

Related Language Record: APP_DES_TLS_VWL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Object Name
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description