Recently Updated Pages
Event Notification and Output to a Window
With the help of Real time event notification server and notifyToWindow method in PeopleSoft we c...
Tables
The following is a list of some of the key campus solutions records grouped by functional area. T...
Distribution
The following tables store information about the distribution of process scheduler output to user...
System Process Requests
System Process Requests is a component (PRCSMULTI) located under: PeopleTools > Process Sch...
Compliling
Compiling COBOL locally can save you considerable time during the development/troubleshooting sta...
PeopleTools Tables
PeopleTools tables are the tables in your PeopleSoft environment that store PeopleTools meta-data...
Formatting SQL in Notepad++
Suppose you have the following text in your editor: select FIELD1, FIELD2, FIELD3 from TABLE1; ...
Text Editors
As a software developer, your text editor is your number one go to tool and the one you'll be in ...
Browser Compare Reports
I find that browser compare reports are a lot easier to use than standard compare reports as they...
Hiding Portal Folders
A common security requirement is to hide a portal folder in the left hand navigation menu from us...
Structure of a Rowset-Based Message
The SQL below will return the structure of your message if it is rowset based (uses PeopleSoft re...
Terminology
Integration broker is one of those areas of PeopleSoft that introduces a lot of terminology (jarg...
Password Controls
If you are using internal PeopleSoft authentication (not 3rd party LDAP), then PeopleSoft provide...
Search Message Catalog Explain Text
The following PL/SQL is my attempt to search the message catalog for a particular piece of text s...
%TextIn
%TextIn is a Meta-SQL construct which is used for inserting data into PeopleSoft Long Character t...
%SelectAll
If you ever need to create a view that selects all fields from a particular record, then you shou...
Date and Time in Meta-SQL
The Meta-SQL date/time constructs you should know about are: For input/output of the current dat...
%Coalesce Meta-SQL
If you're like me, you might first wonder what the word Coalesce even means? Well in terms of SQL...
Regex for Meta-SQL Conversion
I've come up with the following regular expressions to add or remove %Table() meta-sql construct....
%EffdtCheck
There is a very handy meta-sql element called %EffdtCheck which writes effective date logic for y...