# Objects

> PeopleSoft object reports: customization inventory, cross-database project comparison, and object analysis.

---

Site [llms.txt](/llms.txt)

---

Six reports against PSPROJECTDEFN, PSPROJECTITEM, PSPCMTXT, PSSQLTEXTDEFN, and the per-object definition tables. Use them to inventory customizations, compare a project across two databases, search code and SQL text strings, diff PeopleCode in an uploaded project file against a live database, find every reference to a Message Catalog entry, and identify target projects that are missing or newer before a database refresh.

|                                        Report                                        |                                                                     Description                                                                     |
| ------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Code & SQL Text Search](/docs/reports/objects/code-sql-search/)                           | Searches for a text string across all PeopleCode (PSPCMTXT), standalone SQL Objects (PSSQLTEXTDEFN), and Application Engine SQL (PSAESTMTDEFN)       |
| [Customized Objects Inventory](/docs/reports/objects/objects-customized-inventory/)        | Lists all customized objects by type (records, fields, pages, components, menus, app packages, app engines, SQL objects, service operations, roles) |
| [Message Catalog Usages](/docs/reports/objects/msgcat-usages/)                             | Searches the database and codebase to locate every usage of a specific Message Catalog entry                                                        |
| [Missing Projects Refresh Risk Report](/docs/reports/objects/projects-missing/)            | Finds target database projects updated since a given date that are missing or newer in a production/source database                                 |
| [Project Cross-Database Comparison](/docs/reports/objects/project-compare/)                | Compares a project's definition and items across two databases, showing what exists only in each and where items differ                             |
| [Project Import — PeopleCode Diff vs Database](/docs/reports/objects/project-import-diff/) | For an uploaded project XML, emits per-object file source, database source, and a line-level diff for every PeopleCode program. LLM-friendly.       |

---

Section pages:

- [Customized Objects Inventory](/docs/reports/objects/objects-customized-inventory/): This report provides a complete inventory of all customized PeopleSoft objects across ten major object types.
- [Project Cross-Database Comparison](/docs/reports/objects/project-compare/): This report compares a PeopleSoft project's definition and items across two databases. It identifies:
- [Missing Projects Refresh Risk Report](/docs/reports/objects/projects-missing/): This page documents the report used to audit project risk in a target database before a database refresh.
- [Project Import — PeopleCode Diff vs Database](/docs/reports/objects/project-import-diff/): You uploaded a PeopleSoft project XML on the Project Import page, and you want to know — line-by-line — how every PeopleCode program inside that fi...
- [Message Catalog Usages](/docs/reports/objects/msgcat-usages/): This report searches the entire PeopleSoft database and codebase to locate every usage of a specific Message Catalog entry.
- [Code & SQL Text Search](/docs/reports/objects/code-sql-search/): This report performs text string searches across PeopleCode programs (PSPCMTXT), SQL Objects (PSSQLTEXTDEFN), and Application Engine SQL statements (PSAESTMTDEFN).