PeopleTools

PeopleSoft PeopleTools related articles.

PeopleSoft Object Types Explained

If you ever queried PSPROJECTITEM table (stores PeopleTools project objects) then you have definitely noticed that object types are stored as a number and not with their names. For example, if you have a project with a component then your component on this table will be stored as object type number 7.

So, what are other object types stored as (Pages, Record PeopleCode, Menus....)? Well, the list below is your answer. Please don't hesitate to post a comment and "correct" me if I messed up somewhere while mapping numbers to names!

0 = 'Record'
1 = 'Index'
2 = 'Field'

Extract Project Objects Using an SQL

There have been times where I needed to document objects included in an Application Designer. The process could get very time consuming if you have a project with hundreds of PeopleSoft objects in it. PeopleSoft doesn't provide a "copy paste" type of approach to ease things, so I came up with my own!

The query below will return all the objects inside of an Application Designer project. You can then copy the rows and paste them where ever you'd like.

SELECT (CASE OBJECTTYPE WHEN 0 THEN 'Record'
WHEN 1 THEN 'Index'
WHEN 2 THEN 'Field'
WHEN 3 THEN 'Field Format'

Adding a Sub Record Field into a Grid or Scroll Area

I kept getting this weird PeopleSoft error when trying to drop a sub record field into a Grid or Scroll area on a page. The error was this:

Fields from subrecords are not allowed to be inserted directly into the page. Use Subpage instead.

What? You have to be kidding me! I know this could be done and I don’t need a subpage for this. I’ve seen it done and I’ve actually got it done! This is what I did.