Select Page
Posted by Steven Alexander | Oct 16, 2011 | Uncategorized |
Please come back on Tuesday, October 18, 2011 for an exciting announcement. I am changing jobs again, and changing careers. I have spent the last 18 months working for a consulting firm, applying my PeopleSoft and SQR skills to...
Read MorePosted by Steven Alexander | Apr 4, 2010 | Uncategorized |
Please come back on Tuesday, April 6, 2010 for an exciting announcement. I have a new job. I gave notice last Friday and told my co-workers on Monday. I will miss my old employer; they’ve treated me well and given me...
Read MorePosted by Steven Alexander | Mar 28, 2010 | Peoplesoft Specific, SQL |
Last week we discussed finding the best Peoplesoft page, and the menu path to that page, for viewing and updating a particular database table. We have a similar need to find the menu path to the run control page for a...
Read MorePosted by Steven Alexander | Mar 21, 2010 | Peoplesoft Specific, SQL |
When I discuss data with my colleagues in the Human Resources and Payroll departments, we speak different languages. I talk about tables and columns. They talk about menus, tabs, and pages. “You need to change EEO4CODE...
Read MorePosted by Steven Alexander | Mar 14, 2010 | Peoplesoft Specific, SQL |
PS_EMPLOYMENT used to be a SQL table. Now it is a SQL view that joins PS_PER_ORG_ASGN, PS_PER_ORG_INST, and PS_JOB. Of course, PS_JOB has two subselects to pick a single value of EFFDT and EFFSEQ for each value of EMPL_RCD. ...
Read More
Recent Comments