11/22/11

PeopleTools table where user customizations on a PeopleSoft page are saved

There are two places where a user could customize a PeopleSoft page.
1) By clicking the 'Customize Page' link which is at the upper right corner of every page in PIA and
2) The customizations that can be done through the 'Customize' link on a grid's navigation bar.

Both these customization types are stored in PSUSEROBJTYPE record. PSUSEROBJTYPE record has a field named - FIELDTYPE which stores the customization type.



The following observation took me hours to find out, however now it sounds simple.
  • If the FIELDTYPE has a value of -1, then the customization is done from the 'Customize Page' link located at the upper right corner of every page.
  • If the FIELDTYPE has any other numeric value then this customization is done from the 'Customize' link in the grid.
  • The number other than -1 in the FIELDTYPE corresponds to the field number of the grid on that page.
  • The FIELDTYPE value(Except -1) may not be the same as the fieldnum used internally in a grid. Since subpages can also be part of a page, the subpages(subrecords) are expanded, and each of the field in the subpage(subrecord) takes a position in the list of FIELDNUM. For this reason, the FIELDTYPE value and FIELDNUM can be different.

4 comments:

  1. Thanks a lot Shyam. It is definitely a useful peice of information

    ReplyDelete
  2. very very useful

    ReplyDelete
  3. great info! thanks!

    ReplyDelete
  4. Thanks sir! This helped me figure out an issue.

    ReplyDelete

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month