SQL To Identify Actual Customized PeopleCode

For some reason, the demo environment is not up to date with all the patches and bundles applied to production.

I need to do a full compare of all the PeopleCode in the system and I need to identify which ones are actual customizations vs patches.

1. Create the compare report.
2. Run this SQL.

Top 10 Awesome Meta-SQL

Here is a list of my top 10 awesome meta-sql that makes my lazy life easier.

%EffdtCheck
%InsertSelect
%InsertValues
%Join
%KeyEqual
%SQL
%SelectAll
%SelectDistinct
%SelectByKey
%SelectByKeyEffDt

Now for some examples...

Create Tooltips + Hyperlink To Another Component

I need two things today.

1. Create a link for every row in the grid. Each link will transfer the page to a new component and use the search keys automatically.
2. Create a hover or mouseover label for the links.

Step by step guide below.

Complete List of PeopleTools Object Types

PeopleTools Object Type Reference

Jump to see the entire list.

Read Multiple Files Using App Engine and FileLayout

I want to process several files using PeopleSoft's filelayout.

Assuming you have created your Application Engine, here's a step by step guide.

SQL to get Child Records

I want a list of PS_JOB's child record.

SELECT RECNAME 
FROM PSRECDEFN
CONNECT BY PRIOR RECNAME = PARENTRECNAME
START WITH PARENTRECNAME = 'Record Name Here';