If you use APP ENGINE to report the data from the temp table /staging table on to CSV file using excel format, there is a known issue with fields that have leading zeros. For ex:You have a field of length 6 characters. If the field value is 002123, the excel file removes the leading zeros. But if the requirement is to preserve those leading zeros, we can do something like this.
Update the temp table right before you write out into a file.
The function increments a date field using the AddToDate function and sets a weekday field to the corresponding weekday. You can increment date value by year, month or day.
A function to facilitate the addition of a leading character to a field value. The function takes three parameters:
- &LEADCHAR: The character you want to append to your value.
- &FIELDZISE: The over all size of your value after appending your desired character.
- &FIELDVALUE: The value you want to append the character to.
Another permission list query to list Content References accessed by a specific Permission List.
A query that will list all peopletools objects (Query, Application Designer, Data Mover) that a specific permission list could access.
A query to identify pages that could be accessed by a specific permission list.
In an attempt to recognize quality posts made by our members, users (registered and site visitors) can now vote on posts available on the site. The voting option will be located at the very begining of each post (example picutre below).

Registered users will have a link under their "My account" to easily track posts they voted on and we will be soon adding a page listing top rated nodes!
As always, feedback is always welcome.
A query to help you identify Roles that are assigned to a specific permission list.
A subrecord in PeopleSoft is a way to group fields together and place them on a record, view, or a temp table. Here is a query you can use to identify records that have a specific subrecord.
A query to list all user IDs that are assigned to a specific permission list.
| Title | Under | Posted on |
|---|---|---|
| Regarding Error "SQR 6002) CANNOT OPEN THE PRINTER FILE: " in SQR | PeopleSoft Technical | 11/21/2008 - 1:17am |
| Pay calendar Setup | PeopleSoft Functional | 11/18/2008 - 5:30pm |
| Issue linking to Excel 2007 from PS HRMS 8.8 | PeopleSoft Technical | 11/17/2008 - 9:48am |
| Spreadsheet-Based Control System Analysis and Design | Programming | 11/11/2008 - 5:10am |