Objects & Related Tables

The PeopleSoft object type field identifies the type of PeopleSoft application designer object. This information can be useful for a few different applications. If auditable is set to Y, then the PeopleTools table contains the last update oprid and last update time fields. If the lockable flag is set, then the object can be locked in Application Designer.

Object Type Value	PeopleSoft Object	PeopleTools Table	Auditable	Lockable
0	Record	PSRECDEFN	Y	Y
1	Index	PSINDEXDEFN	Y	N
2	Field	PSDBFIELD	Y	Y
3	Field Format	PSFIELDFORMATS	Y	N
4	Translate Value	PSXLATITEM	Y	N
5	Panel/Page	PSPNLDEFN	Y	Y
6	Menu	PSMENUDEFN	Y	Y
7	Panel Group/Component	PSPNLGRPDEFN	Y	Y
8	Record PeopleCode	PSPCMPROG	Y	N
9	Menu Item
10	Query	PSQRYDEFN	Y	N
11	??? or depricated
12	Tree	PSTREEDEFN	Y	N
13	Access Group
14	Color
15	Style
16	Not Used
17	Business Process Definition	PSBUSPROCDEFN	Y	Y
18	Workflow Activity	PSACTIVITYDEFN	Y	Y
19	Security Role	PSROLEDEFN	Y	N
20	Process Definition	PS_PRCSDEFN	Y	N
21	Process Scheduler Server Definition	PSSERVERDEFN	Y	N
22	Process Type
23	Job
24	Job schedule
25	Message Catalog Definition	PSMSGCATDEFN	Y	Y
26	Dimension
27	Cube Definition
28	Cube Instance Definition
29	Business Interlink	PSIODEFN	Y	Y
30	SQL Definition	PSSQLDEFN	Y	Y
31	File Layout Definition	PSFLDDEFN	Y	Y
32	Component Interface	PSBCDEFN	Y	Y
33	Application Engine Program	PSAEAPPLDEFN	Y	Y
34	Application Engine Sections	PSAESECTDEFN	Y	N
35	IB Message Node	PSMSGNODEDEFN	Y	N
36	Message Channel/Queue			Y
37	IB Message	PSMSGDEFN	Y
38	Approval Rule Set	PS_APPR_RULE_HDR		Y
39	Unknown: Relates to IB
40	Subscription PeopleCode
41	Unknown
42	Component Interface Method
43	Application Engine PeopleCode	PSPCMPROG	N	N
44	Page PeopleCode	PSPCMPROG	Y	N
45	Page Field PeopleCode	PSPCMPROG	Y	N
46	Component PeopleCode	PSPCMPROG	Y	N
47	Component Record PeopleCode	PSPCMPROG	Y	N
48	Component Record Field PeopleCode	PSPCMPROG	Y	N
49	Image	PSCONTDEFN	Y	Y
50	Portal Style Sheet			Y
51	HTML			Y
52	Not User
53	Permission List	PSCLASSDEFN	Y	N
54	Portal Definition
55	Portal Registry Definition	PSPRSMDEFN	Y	N
56	URL Definitions	PSURLDEFN	Y	N
57	Application Package	PSPACKAGEDEFN	Y	Y
58	Application Package Peoplecode
59	ortal Registry User Homepage
60	Problem Type			Y
61	Archive Templates
62	XLST	PSSQLDEFN	Y	Y
63	Portal Registry User Favorite
64	Mobile Page			N
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
79	Service	PSSERVICE	Y	N
80	Service Operation	PSSERVICEOPR	N	N
81	Service Operation Handler	PSOPRHDLR	Y	N
82	Service Operation Versions	PSOPRVERDFN	Y	N
83	Service Operation Routing	PSIBRTNGDEFN	Y	N
85	XMLP Template Definition	PSXPTMPLDEFN	Y	N
86	XMLP Report Definition	PSXPRPTDEFN	Y	N
87	XMLP File Definition
88	XMLP Data Source Definition	PSXPDATASRC	Y	N
89	WSDL	PSIBWSDLDFN	Y	N
90	Message Version	PSMSGVER	N	N
255	Project