PeopleSoft Object Types Explained

Your rating: None Average: 4.5 (13 votes)

If you ever queried PSPROJECTITEM table (stores PeopleTools project objects) then you have definitely noticed that object types are stored as a number and not with their names. For example, if you have a project with a component then your component on this table will be stored as object type number 7.

So, what are other object types stored as (Pages, Record PeopleCode, Menus....)? Well, the list below is your answer. Please don't hesitate to post a comment and "correct" me if I messed up somewhere while mapping numbers to names!

0 = 'Record'
1 = 'Index'
2 = 'Field'
3 = 'Field Format'
4 = 'Translate Value'
5 = 'Pages'
6 = 'Menus'
7 = 'Components'
8 = 'Record PeopleCode'
9 = 'Menu PeopleCode'
10 = 'Query'
11 = 'Tree Structures'
12 = 'Trees'
13 = 'Access group'
14 = 'Color'
15 = 'Style'
16 = 'N/A'
17 = 'Business process'
18 = 'Activity'
19 = 'Role'
20 = 'Process Definition'
21 = 'Server Definition'
22 = 'Process Type Definition'
23 = 'Job Definitions'
24 = 'Recurrence Definition'
25 = 'Message Catalog'
26 = 'Dimension'
27 = 'Cube Definitions'
28 = 'Cube Instance Definitions'
29 = 'Business Interlink'
30 = 'SQL'
31 = 'File Layout Definition'
32 = 'Component Interfaces'
33 = 'AE program'
34 = 'AE section'
35 = 'Message Node'
36 = 'Message Channel'
37 = 'Message'
38 = 'Approval rule set'
39 = 'Message PeopleCode'
40 = 'Subscription PeopleCode'
41 = 'N/A'
42 = 'Component Interface PeopleCode'
43 = 'AE PeopleCode'
44 = 'Page PeopleCode'
45 = 'Page Field PeopleCode'
46 = 'Component PeopleCode'
47 = 'Component Record PeopleCode'
48 = 'Component Rec Fld PeopleCode'
49 = 'Image'
50 = 'Style sheet'
51 = 'HTML'
52 = 'Not used'
53 = 'Permission List'
54 = 'Portal Registry Definitions'
55 = 'Portal Registry Structures'
56 = 'URL Definitions'
57 = 'Application Packages'
58 = 'Application Package Peoplecode'
59 = 'Portal Registry User Homepage'
60 = 'Problem Type'
61 = 'Archive Templates'
62 = 'XSLT'
63 = 'Portal Registry User Favorite'
64 = 'Mobile Page'
65 = 'Relationships'
66 = 'Component Interface Property Peoplecode'
67 = 'Optimization Models'
68 = 'File References'
69 = 'File Type Codes'
70 = 'Archive Object Definitions'
71 = 'Archive Templates (Type 2)'
72 = 'Diagnostic Plug In'
73 = 'Analytic Model'

Other useful upgrade action flags
Here are the values for the upgrade action field UPGRADEACTION:
CASE UPGRADEACTION
        WHEN 0 THEN 'Upgrade Action is Copy'
        WHEN 1 THEN 'Upgrade Action is Delete'
        WHEN 2 THEN 'Upgrade Action is None'
        WHEN 3 THEN 'Upgrade Action is CopyProp'
        ELSE UPGRADEACTION
END CASE

And here are the values for the Source status and Target status fields.
CASE SOURCESTATUS
        WHEN 0 THEN 'Unknown'
        WHEN 1 THEN 'Absent'
        WHEN 2 THEN 'Changed'
        WHEN 3 THEN 'Unchanged'
        WHEN 4 THEN '*Changed'
        WHEN 5 THEN '*Unchanged'
        WHEN 6 THEN 'Same'
        ELSE SOURCESTATUS
END CASE
-- TARGETSTATUS values are the save as above

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
prajith's picture
prajith (not verified)
Re: PeopleSoft Object Types Explained

Additions to the object types
85 = 'XMLP Template defn'
86 = 'XMLP Report Defn'
87 = 'XMLP File Defn'
88 = 'XMLP Data src Defn'

Don's picture
Don (not verified)
Re: PeopleSoft Object Types Explained

Here are some more Object Types:
75. Java Portlet user Preferences
76. WSRP Remote Producers
77. WSRP Remote Portlets
78. WSRP Cloned Portlet Handles
79. Services
80. Service Operations
81. Service Operation Handlers
82. Service Operation Versions
83. Service Operation Routings
84. IB Queues
85. XMLP Template Definitions
86. XMLP Report Definitions
87. XMLP File Definitions
88. XMLP Data Source Definitions

lakema's picture
lakema (not verified)
Re: PeopleSoft Object Types Explained

Some more Object Types:
89 WSDL
90 Message Schemas
91 Connected Query Definitions
92 Document
93 XML Document
94 Related Document
95 Dependency Documents
96 Document Schema
97 EssbaseCubeDimensions
98 EssbaseCubeOutlines
99 EssbaseCubeConnections
100 EssbaseCubeTemplates

Guest's picture
Guest
Re: PeopleSoft Object Types Explained

101, 'DelimitedDocuments',
102, 'PositionalDocuments',
103, 'ApplicationDataSetDefinit',
104, 'Tests',
105, 'TestCases',
107, 'FeedDefinitions',
108, 'FeedCategories',
109, 'FeedDataTypes',
110, 'JSONDocuments',
111, 'RelatedContentDefinitions',
112, 'RelatedContentServices',
113, 'RelatedContentConfigurati',
114, 'RelatedContentLayouts',
115, 'SearchAttributes',
116, 'SearchDefinitions',
117, 'SearchCategories',
118, 'SearchContexts',
119, 'IntegrationGroups'

Guest's picture
Guest
Re: PeopleSoft Object Types Explained

Thank you.
Great information.
Much appreciated.

Yvonne

Guest's picture
Guest
Re: PeopleSoft Object Types Explained

amazing , thank you all of you.