Skip to content

An Application Engine process to list all of the objects included in a PSPROJECTITEM plus additional details about those items. The repository also includes a spreadsheet of all the objects types and the main source table.

Notifications You must be signed in to change notification settings

hoskinsconsulting/peoplesoft_project_listing

Repository files navigation

PeopleSoft Project Object Listing Utility

An Application Engine process to write a list of objects contained within a project. This includes the object type, object name, type, description (if applicable), and action.

Files contained in this git:

  • .zip file is the complete PeopleSoft project including the application engine, run control page, etc, ready to be imported. This has been exported with PeopleTools 8.56.
  • .txt file is the PeopleCode listing alone.
  • .xls file is a sample of the output from the process

And here is the object type mapping I've been able to pull together, so far:

Object Type Object Description Source Table
0 Record PSRECDEFN
1 Index PSINDEXDEFN
2 Field PSDBFIELD
3 Field Format PSFMTDEFN
4 Translate Value PSXLATITEM
5 Page PSPNLDEFN
6 Menu PSMENUDEFN
7 Component PSPNLGRPDEFN
8 Record PeopleCode PSPCMPROG
9 Menu PeopleCode PSPCMPROG
10 Query PSQRYDEFN
11 Tree Structure PSTREESTRCT
12 Tree PSTREEDEFN
13 Access Group PS_ACCESS_GRP_TBL
14 Color PSCOLORDEFN
15 Style PSSTYLEDEFN
16 Not Used -
17 Business Process PSBUSPROCDEFN
18 Activity PSACTIVITYDEFN
19 Roles PSROLEDEFN
20 Process Definitions PS_PRCSDEFN
21 Servers PS_SERVERDEFN
22 Process Types PS_PRCSTYPEDEFN
23 Job Definitions PS_PRCSJOBDEFN
24 Recurrences PS_PRCSRECUR
25 Message Catalog PSMSGCATDEFN
26 Dimension PS_DIMENSION
27 Cube Definition PSACECUBE
28 Cube Instance PS_ANALYSIS_DB
29 Business Interlink PSIODEFN
30 SQL PSSQLDEFN
31 File Layout PSFLDDEFN
32 Component Interface PSBCDEFN
33 Application Engine Program PSAEAPPLDEFN
34 Application Engine Section PSAESECTDEFN
35 Message Node PSMSGNODEDEFN
36 Message Channel PSMSGDEFN
37 Message PSMSGDEFN
38 Approval Rule Set PS_APPR_RULE_HDR
39 Message PeopleCode PSPCMPROG
40 Subscription PeopleCode PSPCMPROG
41 Not Used -
42 Component Interface PeopleCode PSPCMPROG
43 Application Engine PeopleCode PSPCMPROG
44 Page PeopleCode PSPCMPROG
45 Page Field PeopleCode PSPCMPROG
46 Component PeopleCode PSPCMPROG
47 Component Record PeopleCode PSPCMPROG
48 Component Rec Field PeopleCode PSPCMPROG
49 Image PSCONTDEFN
50 Style Sheet STYLESHEETTYPE
51 HTML PSCONTDEFN
52 Not Used -
53 Permission List PSCLASSDEFN
54 Portal Registry Definition PSPRDMDEFN
55 Portal Registry Structure PSPRSMDEFN
56 URL Definition PSURLDEFN
57 Application Package PSPACKAGEDEFN
58 Application Package PeopleCode PSPCMPROG
59 Portal Registry User Homepage PSPRUHDEFN
60 Analytic Type PSOPTPRBTYPE
61 Archive Template PS_ARCH_PROJ
62 XSLT PSSQLDEFN
63 Portal Registry User Favorite PSPRUFDEFN
64 Mobile Page PSMPDEFN
65 Relationships PSRELATIONSHIP
66 Component Interface Property PeopleCode PSPCMPROG
67 Optimization Model PSOPTMODEL
68 File References PSFILEREDEFN
69 File Type Codes PSTYPECODEDEFN
70 Archive Object PSARCHOBJDEFN
71 Archive Templates (Type 2) PSARCHTEMPLATE
72 Diagnostic Plug-ins PSDIAGREG
73 Analytic Model PSACEMDLDEFN
74 Not Used -
75 Java Portlet User Preferences TBD
76 WSRP Remote Producers PSWSRPPRDDEFN
77 WSRP Remote Portlets PSWSRPPLTDEFN
78 WSRP Cloned Portlet Handles TBD
79 Service PSSERVICE
80 Service Operation PSOPERATION
81 Service Operation Handler PSOPRHDLR
82 Service Operation Version PSOPRVERDFN
83 Service Operation Routing PSIBRTNGDEFN
84 IB Queues PSQUEUEDEFN
85 BIP Template Definition PSXPTMPLDEFN
86 BIP Report Definition PSXPRPTDEFN
87 BIP File Definition PSFILEDEFN
88 BIP Data Source Definitions PSXPDATASRC
89 WSDL PSIBWSDLDFN
90 Message Schema PSIBSCMADFN
91 Connected Query PSCONQRSDEFN
92 Logical Schema TBD
93 XML Schema TBD
94 Relational Schema TBD
95 Dependency Document TBD
96 Document Schema PSLSDEFN
97 Essbase Cube Dimension TBD
98 Essbase Cube Outline TBD
99 Essbase Cube Connection TBD
100 Essbase Cube Template TBD
101 Delimited Schema TBD
102 Positional Schema TBD
103 Data Set Definition PSADSDEFN
104 Test PSPTTSTDEFN
105 Test Case PSPTTSTCASE
106 Application Data Set Binding PSPROJBINDITEM
107 Feed Definition PSFP_FEED
108 Feed Category PSFP_CATEGORY
109 Feed Data Type PSFP_DATATYPE
110 JSON Document TBD
111 Related Content Definition PSPTCSSRVDEFN
112 Related Content Services PSPTCS_SRVCFG
113 Related Content Configuration TBD
114 Related Content Layout TBD
115 Search Attribute PSPTSF_ATTRS
116 Search Definition PSPTSF_SD
117 Search Category PSPTSF_SRCCAT
118 Search Context TBD
119 Integration Group PSIBGROUPDEFN
120 XML Documents TBD
121 MAP Layouts PSDOCLODEFN
122 MAP Template TBD
123 Composite Query PSCPQDEFN
125 MAP Admin PSMAPMDEFN
126 MAP Store PSMAPSDEFN

About

An Application Engine process to list all of the objects included in a PSPROJECTITEM plus additional details about those items. The repository also includes a spreadsheet of all the objects types and the main source table.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published