PSBINDRULE (SQL Table)	Index Back
Bind Table Rule Object: table used to store the names and indices of the rule's bind variables.

PSBINDRULE

(SQL Table)

Bind Table

Rule Object: table used to store the names and indices of the rule's bind variables.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OBJECTID1 Number(5,0) INTEGER NOT NULL Object Id 1
1=Record
2=Field
3=Menu
4=Bar Name
5=Item Name
9=Page
10=Component
12=Event
20=Database Type
21=Effective Date
39=Market
60=Message
66=Application Engine Program
74=Component Interface
77=Section
78=Step
87=Subscription
104=Application Package
105=Class
106=Class
107=Class

2 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1

3 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1

4 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2

5 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1

6 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3

7 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1

8 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4

9 OBJECTID5 Number(5,0) INTEGER NOT NULL Object Id 5, as OBJECTID1

10 OBJECTVALUE5 Character(30) VARCHAR2(30) NOT NULL Object Value 5

11 BINDNAME Long Character CLOB Rule Object: Name of bind variable.

12 BINDINDEX Number(3,0) SMALLINT NOT NULL Rule Object: Index of bind variable. Used to determine index of this bind variable in the runtime bind variable array used by the rule object.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OBJECTID1	Number(5,0)	INTEGER NOT NULL	Object Id 1 1=Record 2=Field 3=Menu 4=Bar Name 5=Item Name 9=Page 10=Component 12=Event 20=Database Type 21=Effective Date 39=Market 60=Message 66=Application Engine Program 74=Component Interface 77=Section 78=Step 87=Subscription 104=Application Package 105=Class 106=Class 107=Class
2	OBJECTVALUE1	Character(100)	VARCHAR2(100) NOT NULL	Object Value 1
3	OBJECTID2	Number(5,0)	INTEGER NOT NULL	Object Id 2, as OBJECTID1
4	OBJECTVALUE2	Character(100)	VARCHAR2(100) NOT NULL	Object Value 2
5	OBJECTID3	Number(5,0)	INTEGER NOT NULL	Object Id 3, as OBJECTID1
6	OBJECTVALUE3	Character(30)	VARCHAR2(30) NOT NULL	Object Value 3
7	OBJECTID4	Number(5,0)	INTEGER NOT NULL	Object Id 4, as OBJECTID1
8	OBJECTVALUE4	Character(30)	VARCHAR2(30) NOT NULL	Object Value 4
9	OBJECTID5	Number(5,0)	INTEGER NOT NULL	Object Id 5, as OBJECTID1
10	OBJECTVALUE5	Character(30)	VARCHAR2(30) NOT NULL	Object Value 5
11	BINDNAME	Long Character	CLOB	Rule Object: Name of bind variable.
12	BINDINDEX	Number(3,0)	SMALLINT NOT NULL	Rule Object: Index of bind variable. Used to determine index of this bind variable in the runtime bind variable array used by the rule object.