PSQRYBIND

#	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	BNDNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Bind Name
4	BNDNUM	Number(3,0)	SMALLINT NOT NULL	Bind Number
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	HDGTYPE	Number(1,0)	SMALLINT NOT NULL	Heading Type
7	HEADING	Character(30)	VARCHAR2(30) NOT NULL	Field Heading
8	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
9	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
10	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
11	FORMAT	Number(2,0)	SMALLINT NOT NULL	Field Format 0= If Fieldtype=0 (Character) then Upper Case If Fieldtype=6 (DateTime) then HH:MM 1=Name 2=Phone Number North American (mandatory length 12 characters) 3=Zip/Postal Code North American (mandatory length 10 characters) 4=US Social Security Number (mandatory length 9 characters) 5= 6=Mixed Case 7=Raw/Binary 8=Numbers only 9=SIN (mandatory length 9 characters) 10=International Phone Number 11=Zip/Postal Code International 12=Time HH:MM:SS 13=Time HH:MM:SS.999999 14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)
12	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table
13	USECOUNT	Number(3,0)	SMALLINT NOT NULL	Use Count
14	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
15	QRYREQUIREDPROMPT	Character(1)	VARCHAR2(1) NOT NULL	Optional N=Optional Y=Required Default Value: Y
16	QRYPROMPTDEFAULT	Character(254)	VARCHAR2(254) NOT NULL	Default Value