Search results for query: *

I need to add a row of compensation Data to my report. I have a basic roster with current Hrly rate. I need to add Hrly rate when hired or as of the job title change that matches the current job title. Seems tricky to me, but it is really late...help, please. ADP Enterprise-Oracle

Charles, I have some random people falling off, and I'm not sure why. Do you know if changing tables from PS to PV would effect the data? I did not think it would, I have full access to all the tables, but this is the only thing I can think of.

Charles, Thank you, it worked. I hit another wall, if course. My report is pulling in based on process date in order to capture the most recent balance. Some of our employee's don't qualify for PTO so they have nothing on the pv_al_ytd_cntl_hrs table. Is their a magic way to put them in? I...

I need some help, I have a basic roster report that I need to add PTO balance to. I have the table added, my problem is once I added the pv_al_ytd_cntl_hrs, I only get people who qualify for PTO...how can I get everyone reguardless if they have control hours 1 if I only want to see control hrs...

I have a copy of the data dictionary in a .pdf file, I can send to you if you would like. **need e-mail address.

I have the max for Processed Date, how do I get the max for the Year? I need to run a YTD Accum rpt, but want to pull in the max processed for the year (2006), is this possible? [ponytails]

Wait, I got it. But its only pulling the Max for the pay group just processed. I'm thinking I need to add an any statement to get the max of all paygroups??? FYI- This is how I got it it work (SELECT MAX (AL_PROCESS_EFFDT) FROM SYSADM.PS_AL_YTD_CNTL_HRS A WHERE FILE_NBR=A.FILE_NBR) Were on...

The control hrs table does not contain emplid. I changed to File_nbr, but am getting a missing expression message. Any suggestions? I would paste a copy of my selection, but not sure how to do that. [ponder]

Good afternood; I have a report bulit to give me Ctrl Hrs 1, currently I have to type in the Process effective date. I would like to automate this process to pull in the Max process effdt. Does anyone know how to do this? -Enterprise V3. Table I'm using is...

It worked, I also added the selection of Any for my action, and action reason. Good to go...Thank you!

I'm pulling a rpt together of all employee(s) who have an indicator in HR_User_Data 1 and 2. Of those people, I need to list all New Hires, Rehires, Terms Action=PAY, Action Reason=PRO. I only need to see 'Action_Reason' = 'PRO' under the 'Action'= 'Pay'. Seems confusing...I'm going cross...

Charles, I don't know if anyone told you this lately, but you "ROCK"!! Everything worked perfectly! [smarty]

I have a basic rehire/Term report. I need to only pull anyone who was rehired with in 14 days of termination. The thing is that we have people who have been termed and rehired more then once....Any suggestions? I'm on Enterprise 3. [ponytails]