This is a quick handy guide to PeopleSoft Application Designer Project Definition References and their key tables. In the document PeopleSoft Object Reference you will find a more extensive break down of the common objects and their table references.
| Object Type |
Object Type Definition |
Meta-Data Record |
| 0 |
Record |
PSRECDEFN |
| 1 |
Index |
PSKEYDEFN |
| 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 |
Business Process Map |
|
| 17 |
Business Process |
PSBUSPROCDEFN |
| 18 |
Activity |
PSACTIVITYDEFN |
| 19 |
Role |
PSROLEDEFN |
| 20 |
Process Definition |
PRCSDEFN |
| 21 |
Process Server Definition |
PS_SERVERDEFN |
| 22 |
Process Type Definition |
PS_PRCSTYPEDEFN |
| 23 |
Process Job Definition |
PS_PRCSJOBDEFN |
| 24 |
Process Recurrence Definition |
PS_PRCSRECUR |
| 25 |
Message Catalog |
PSMSGCATDEFN |
| 26 |
Dimension |
PS_DIMENSION |
| 27 |
Cube Definition |
|
| 28 |
Cube Instance Definition |
|
| 29 |
Business Interlink |
PSIODEFN |
| 30 |
SQL Objects |
PSSQLDESCR |
| 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 |
PSMSGCATDEFN |
| 37 |
Message |
PSMSGDEFN |
| 38 |
Approval rule set |
APPR_RULE_HDR |
| 39 |
Message PeopleCode |
PSPCMPROG |
| 40 |
Subscription PeopleCode |
PSPCMPROG |
| 41 |
N/A |
|
| 42 |
Component Interface PeopleCode |
PSPCMPROG |
| 43 |
Application Engine PeopleCode |
PSPCMPROG |
| 44 |
Page PeopleCode |
PSPCMPROG |
| 45 |
Page Field PeopleCode |
|
| 46 |
Component PeopleCode |
PSPCMPROG |
| 47 |
Component Record PeopleCode |
PSPCMPROG |
| 48 |
Component Record Field PeopleCode |
PSPCMPROG |
| 49 |
Image |
PSCONTDEFN |
| 50 |
Style sheet |
|
| 51 |
HTML |
|
| 52 |
File References |
PSFILEREDEFN |
| 53 |
Permission List |
PSCLASSDEFN |
| 54 |
Portal Registry Definitions |
|
| 55 |
Portal Registry Structure |
PSPRSMDEFN |
| 56 |
URL Definitions |
PSURLDEFN |
| 57 |
Application Packages |
PSPACKAGEDEFN |
| 58 |
Application Package PeopleCode |
PSPCMPROG |
| 59 |
Portal Registry User Homepage |
|
| 60 |
Problem Type |
|
| 61 |
Archive Templates |
|
| 62 |
XSLT |
|
| 63 |
Portal Registry User Favorite |
|
| 64 |
Mobile Page |
PSMPDEFN |
| 65 |
Relationships |
|
| 66 |
Component Interface Property PeopleCode |
|
| 67 |
Optimization Models |
|
| 68 |
File References |
PSFILEREDEFN |
| 69 |
File Type Codes |
PSTYPECODEDEFN |
| 70 |
Archive Object Definitions |
|
| 71 |
Archive Templates – Type 2 |
|
| 72 |
Diagnostic Plug In |
|
| 73 |
Analytic Model |
|
| 79 |
Service |
PSSERVICE |
| 80 |
Service Operation |
PSOPERATION |
| 81 |
Service Operation Handler |
PSOPRHDLR |
| 82 |
Service Operation Ver |
PSOPRVERDFN |
| 83 |
Service Operation Routing |
SIBRTNGDEFN |
| 84 |
Info Broker Queues |
SIBQUEUEINST |
| 85 |
XLMP Template Definition |
|
| 86 |
XLMP Report Definition |
|
| 87 |
XMLP File Definition |
|
| 88 |
XMLP Data Source Definition |
|