PeopleSoft Archive

Creating a SQL view/record for PSQuery

Have you every been annoyed by creating a query in PIA, using PSQuery? The easier way to do it is to create a new record, turn that into a view, and then query the record in PSQuery. Instructions are below. PSQuery – View Step 1 Open up app designer

PS – Move/Copy a Query to a new Database

Here are instructions for moving/copying queries back and forth between different PeopleSoft databases. PeopleSoft Database Queries This includes moving between different versions of PeopleTools. Step 1 Launch App Designer on the server you are wanting to move/copy your queries from. Step 2 Go to “File > New > Project”

Masking SSN in PeopleSoft

I was looking for this in the PeopleBooks and could not find it. Also after searching Google for a bit, I also came up empty. So I thought I would share this with you to save you some time. Masking SSN PeopleSoft does have a Social Security Number (or