WHEREUSEDOBJTBL

(SQL Table)
 Index Back

Where Used Object Type Tbl

Object types used in app designer projects.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WHEREUSEDOBJTYPE Signed Number(4,0) DECIMAL(3) NOT NULL Where Used Object Type. This includes non copyable objects which are represented by negative numbers.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 ABBREV_3 Character(3) VARCHAR2(3) NOT NULL Three Letter Abbreviation
4 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
5 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
6 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
7 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1