Does anyone know how to link job requisitions within PSoft HR? We want to trace the domino effect that happens with internal postings. For example, an employee...
Greetings to the group.. I'm working on some SQL statements dealing with employees and departments. I've been asked to set up a query that, if the query is ...
Hi Bob. The min(effdt) where dept = current dept will work, but as you say, may not cater for the example of, eg 01/Jan/2004 dept A 10/Jan/2004 dept B ...
Maybe I'm not fully understanding your intent, but if you're working with the HR product, there is a field on the JOB record called DEPT_ENTRY_DT that...
I would try joining the job table to itself and find the date where the deptid changed. The SQL for joining a table to itself can get cumbersome, especially...
Kevin Lee
rklee@...
Mar 1, 2004 5:35 pm
31266
If you're doing it in SQR or PeopleCode, it wouldn't kill you to read through all the rows in order. If you have to do it in one statement, look for the...
I'm looking for best practices for pay advices. We recently turned on ePay, giving employees the opportunity to view their payslips on-line as soon as a...
A SAN is a Storage Area Network (http://www.webopedia.com/TERM/S/SAN.html). That has nothing to do with your application or DB, but is a way of storing your...
Hello Ramesh, Could you please elaborate on the subject of the Hash command? What does it do? I tried to search the web about it, but cannot find a good...
We are trying to implement HireRight on PeopleSoft 8.8. We are not having much luck getting them through the firewall to post background check status ...
We are setting up Kronos clocks on our PeopleSoft 8.8 system. Has anyone else done this sucessfully? The Kronos server is dumping a bunch of VB errors in the...
Hello guys, Some wierd problem here. Is there anything specific which needs to be done when there is a chage in Paygroup for an employee?? This is my case:In...
Hi, I am drawing a blank... I have some radio buttons in a group box. Based on another value on the page (basic IF statement) I want to hide some of the radio...
Yes. I am working with Peoplesoft 7.0. Record Field Peoplecode: GVT_JOB.EMPLID.RowInit I have done the following for debugging: 1. Put useful WinMessage...
I am trying to hide a hyperlink on a page at level 0 based on a value in a field on level 1. I have placed the code on level 1, account, rowinit but it keeps...
There is a user profile component interface you can use, USER_PROFILE. Robert ... __________________________________ Do you Yahoo!? Get better spam protection...
Was the effective date of the paygroup change after Feb. 1st? If so, and the person is salaried, that could cause the problem. siddhu_ns <siddhu_ns@...>...
I am trying to modify a Crystal 7.0 to 8.0., so I did a workstation install on my workstation from the 8.4 config mgr. It now brings up Crystal 8.0. when I...
The following peoplesoft-fans poll is now closed. Here are the final results: POLL QUESTION: Which DB2 is your PeopleSoft HR or Financial is installed on DB2...
peoplesoft-fans@yahoo...
Mar 2, 2004 8:59 am
31280
I would start at the PAY_CHECK record and look for non zero amounts in Total Earnings, Deductions and Taxes. This should tell you where your Net Pay is coming...
Our company is looking for a source where we can get periodically updated tables of worldwide secondary education institutions, degrees, and majors. We also...
Is there a way to load multiple photos into the database at once instead of using Application Designer to create 1 image definition at a time? If so is there...
Hi all, Regarding the two firts month of production, our system is growing a lot. The database grows from 5Go to 15Go. The table GP_GL_DATA is one of the most...
nope...it was 1st feb when the paygroup change occured ... __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for...
We got rid of a dental plan this year...when I went to the Benefit Plan page to make in inactive, there does not seem to be a way to do that. Would it be ok to...
Somehow I missed this poll, but for whoever requested it we are using both HRMS and Financials on DB2 Unix, AIX to be exact, and have been for over 6 years...
Peoplesoft uses "Next" thoughout to create record ID's. Is this documented anywhere so you don't miss any pieces? My colleague is creating a "bolt on" ...
I agree, I do not want to delete it. OK, so in all of the Benefit Programs, I just need to remove the rows associated with the plan we no longer use? T ... do ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
