Process scheduler status is stored as numeric values behind the RUNSTATUS field. So, here are the values corresponding to each value.
FIELDVALUE XLATSHORTNAME ---------- ------------- 1 Cancel 2 Delete 3 Error 4 Hold 5 Queued 6 Initiated 7 Processing 8 Cancelled 9 Success 10 No Success 11 Posted 12 Not Posted 13 Resend 14 Posting 15 Generated 16 Pending
In this post I will attempt to explain how to dynamically assign a prompt table depending on a drop down value (see image below)

The table behind the grid is PORTAL_SECDYVW and as you can see from the image below, the PORTAL_AUTHNAME field has %EDITTABLE defined as a prompt table. The PORTAL_AUTHNAME is the "Name" column you see on the grid.

A very simple yet very useful code to give users the option to delete all grid rows on a page at once. I've implemented such a requirement by placing a "Delete all" button above a grid to give PeopleSoft users the option to delete all rows at once instead of clicking the "-" grid button. If the gird has, lets say, 20 rows, then a user will have to click the "-" delete grid button 20 times to delete all rows, compared to one click on the "Delete all" button.
Place the code below behind a field change event.
A straight forward SQL to get edit tables behind field(s) for a specific record. The SQL execludes any edit tables that start with "%" as those are dynamic edit tables with values populated by PeopleCode at run time and thus will not be of a good use in this query.
SELECT R.FIELDNAME , R.EDITTABLE FROM PSRECFIELDDB R , PSDBFIELD F WHERE R.RECNAME = :RecordName AND SUBSTR(R.EDITTABLE,1,1) <> '%' AND R.EDITTABLE <> ' ' AND R.FIELDNAME = F.FIELDNAME AND F.FLDNOTUSED = 0;
A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page. Example, Add Update/Display and so forth.
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.
| Title | Under | Posted on |
|---|---|---|
| Abs Mgmt: How can Abs rule pro-rate contractor's last month's entitlement (need help urgently) | PeopleSoft Functional | 03/10/2010 - 9:21pm |
| Can we user LONG datatype as a search option in PeopleSoft | PeopleSoft Technical | 03/10/2010 - 11:22am |
| special caracters are not translated correctly when ftp from windows to unix | Programming | 03/09/2010 - 3:23pm |
| How to view the employees from particular country in peoplesoft? | PeopleSoft Technical | 03/03/2010 - 1:56am |
Recent comments
4 hours 48 min ago
1 day 21 hours ago
6 days 8 hours ago
1 week 11 hours ago
1 week 11 hours ago
1 week 13 hours ago
1 week 1 day ago
1 week 1 day ago
1 week 1 day ago
1 week 1 day ago