Recently Updated Pages

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...

Resolve Meta-SQL

Meta-SQL is really handy, it lets you write database independent SQL and there are some really ni...

Deleting Definitions

Occasionally you may create definitions in your development environment that you discover you no ...

Back to top