Axis Computer Consulting Services, Inc.

I had a big ugly SQL script for extracting PeopleSoft project Information based on the tools table PSPROJECTITEM, I have updated the SQL [here] to use some of the 9i functions so that it is now a single select (instead of a bunch of unioned selects) to pull your project information in a cut and pasteable format (great for documentation). See the rest of the article for a breakdown of the OBJECTTYPE values.
The following list details what the various OPBJECTTYPE numbers represent as far as I could find, only 59 and 61 are unknown as of right now (if you know what they are, please drop me a line):

OBJECTTYPE	Description
0	Record
1	Index
2	Field (if OBJECTID2 is 102, then it is a Field Label)
3	Field Format
4	Translate
5	Page
6	Menu
7	Component
8	Record PeopleCode
9	Menu PeopleCode
10	Query
11	Tree Structure
12	Tree
13	Access Group
14	Color
15	Style
16	Business Process Map
17	Business Process
18	Activity
19	Role
20	Process Definition
21	Server Definition
22	Process Type Definition
23	Job Definition
24	Recurrence Definition
25	Message Catalog Entry
26	Dimension
27	Cube Definition
28	Cube Instance Definition
29	Business Interlink
30	SQL Object
31	File Layout Definition
32	Component Interface
33	Process Engine Program
34	Process Engine Section
35	Message Node
36	Message Channel
37	Message
38	Approval Rule Set
39	Message PeopleCode
40	Subscription PeopleCode
41	Channel PeopleCode
42	Component Interface PeopleCode
43	Application Engine PeopleCode
44	Page PeopleCode
45	Page Field PeopleCode
46	Component PeopleCode
47	Component Record PeopleCode
48	Component Record Field PeopleCode
49	Image
50	Style Sheet
51	HTML
52	File Reference
53	Permission List
54	Portal Registry Definition
55	Portal Registry Structure - OBJECTVALUE2 - when it is 'C' this is a Content Reference, when it is 'F' this is a Folder)
56	URL Definition
57	Application Package
58	Application Package PeopleCode
59	n/a (59)
60	Problem Type
61	n/a (61)
62	XSLT
63	Portal Registry User Favorites
64	Mobile Page
65	Relationship