PTCS_QRYNAME_VW (SQL View)	Index Back
PS Query view New view to select PS Queries;

PTCS_QRYNAME_VW

(SQL View)

PS Query view

New view to select PS Queries;

SELECT DISTINCT QRYNAME , DESCR FROM PSQRYDEFN

Related Language Record: PTCS_QRYNAMELVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

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

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