PSQRYFIELD

#	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	QRYFLDNAME	Character(30)	VARCHAR2(30) NOT NULL	Source Field
4	SELNUM	Number(2,0)	SMALLINT NOT NULL	Select Number
5	FLDNUM	Number(3,0)	SMALLINT NOT NULL	Field Number
6	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
7	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
8	FLDRCDNUM	Number(2,0)	SMALLINT NOT NULL	Field Record Number
9	FLDEXPNUM	Number(3,0)	SMALLINT NOT NULL	Field Expression Number
10	HDGTYPE	Number(1,0)	SMALLINT NOT NULL	Heading Type
11	HEADING	Character(30)	VARCHAR2(30) NOT NULL	Field Heading
12	COLUMNNUM	Number(3,0)	SMALLINT NOT NULL	Column Number
13	GROUPBYNUM	Number(3,0)	SMALLINT NOT NULL	Group-By Number
14	ORDERBYNUM	Number(3,0)	SMALLINT NOT NULL	Order-By Number
15	ORDERBYDIR	Character(1)	VARCHAR2(1) NOT NULL	Order-By Direction A=Ascending D=Descending
16	TTLTYPE	Number(1,0)	SMALLINT NOT NULL	Title Type
17	SUBTTLNUM	Number(3,0)	SMALLINT NOT NULL	Subtitle Number
18	USECOUNT	Number(3,0)	SMALLINT NOT NULL	Use Count
19	XLATTYPE	Number(1,0)	SMALLINT NOT NULL	Translate Table Type
20	XLATEXPRTYPE	Number(1,0)	SMALLINT NOT NULL	Translate Expression Type
21	XLATFLDNUM	Number(3,0)	SMALLINT NOT NULL	Translate Field Number
22	XLATEXPNUM	Number(3,0)	SMALLINT NOT NULL	Translate Expression Number
23	AGGREGATEFUNC	Character(1)	VARCHAR2(1) NOT NULL	Aggregate Function