If you are wondering what Object Types are they are nothing but your usual objects that you create through the application designer or the PIA.

You might be wondering okay so why am I writing a blog on this.

Well here's why. Have you ever wondered how PeopleSoft stores the records, fields, pages, componets etc in the database. In an earlier blog I had mentioned about where PeopleSoft stores all your projects and objects that belong to your project.

Object Types in the peoplesoft are stored as numbers where each number stands for a certain object.

After snooping around in the database as well as google I have finally managed to collate a list of almost all the object types that are generally used.

The list is available here.

I had always wondered how does peoplesoft store projects created through the application designer.

Here I was with an interesting problem. So how did I go about finding out which are the tables where PeopleSoft stores all its projects?

Well, in my current assignment almost all computers have a local instance of PeopleSoft Vanilla installed. This vanilla instance runs on an SQL Server Database. SQL Server...yuppie good news for me. Why you might ask?

SQL Server has its own profiler tool which can be used to watch all database level accesses that happen in realtime.

So here's what I did to find out which tables are populated when one saves a project or accesses a project using the application designer.

I started the profiler. Opened the application designer. Opened an existing project and bang I got my answers straight away.

The tables which are of interest to us are:-

PSPROJECTDEFN

PSPROJECTITEM

PSPROJECTMSG

So what do each of these tables store.

PSPROJECTDEFN - seems to store the project name and description of the project.

PSPROJECTITEM - seems to store the individual objects in the project.

PSPROJECTMSG - seems to store a short description of the very same objects which are present in the previous table.

In my next post I will highlight some of the object types that I managed to reverse Engineer from various sources including the net and by joining the tables PSPROJECTITEM and PSPROJECTMSG.

Till then hold on to your horses.

In this section I will be sharing some gyan that I have about this beautiful ERP package called PeopleSoft.

For all those who are new to ERP and do not know what it is, ERP stands for Enterprise Resource Planning. Its a packaged application that lets you manage your business/organization in a much more organized manner. Unlike a custom application where one needs to start from scratch a packaged applicaton can be used right out of the box (well almost) with some configuration changes.

A packaged application allows some level of customization and PeopleSoft is no exception. I have even heard my clients and many other folks in the ERP business saying quite openly that PeopleSoft is the easiest and fastest ERP which can be customized and that's what makes it a hot ERP.

Enough talk. I will be splitting this topic into multiple categories so watch out for updates. If any of you would like to request for some topics do let me know so that I can add that as well...that is provided I know enough about the topis to write about it.