Select Page
Posted 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 MorePosted by Steven Alexander | Mar 7, 2010 | Algorithms |
Some people use the term “rounding error” to indicate that an answer is right enough, although not perfectly right. Those people think “accurate” and “precise” are two different concepts. ...
Read More
Recent Comments