PSQRYDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	QRYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
5	QRYTYPE	Number(1,0)	SMALLINT NOT NULL	Query type field with translates for Query
6	SELCOUNT	Number(2,0)	SMALLINT NOT NULL	Select Count
7	EXPCOUNT	Number(3,0)	SMALLINT NOT NULL	Expression Count
8	BNDCOUNT	Number(3,0)	SMALLINT NOT NULL	Bind Count
9	QRYVALID	Number(1,0)	SMALLINT NOT NULL	Valid Query
10	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.
11	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	DESCRLONG	Long Character	CLOB	Long Description
13	QRYAPPROVED	Character(1)	VARCHAR2(1) NOT NULL	Approved
14	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
15	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
16	APPROVEOPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver's Oper ID
17	APPROVEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Approval
18	EXECLOGGING	Character(1)	VARCHAR2(1) NOT NULL	Flag for Logging Qry Execution
19	QRYDISABLED	Character(1)	VARCHAR2(1) NOT NULL	Query Disabled N=No Y=Yes
20	QRYFOLDER	Character(18)	VARCHAR2(18) NOT NULL	Query Folder
21	QRYJOINOPTIMIZE	Number(1,0)	SMALLINT NOT NULL	Security Join Optimizer Default Value: 0
22	QRYIMGTYPE	Number(1,0)	SMALLINT NOT NULL	Query Image Type