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

Change Logo & Header – PeopleTools 8.50

This tutorial is on changing the default logo and header in PeopleSoft on PeopleTools version 8.50 or higher. Changing the default logo and header in PeopleSoft on PeopleTools 8.50 Step 1 Open up App Designer. Step 2 Go to File > Open. Step 3 Select definition as Image and

PS Shortcut Key – See Menu + Component

FireFox and IE [vb]SHIFT + CTRL + J[/vb] When you are on a page in PIA, you can use SHIFT + CTRL + J to bring up the page which shows the component name, page name, and menu name. This is very useful for when you are trying to