Search results for query: *

Here you go DECODE("PS_EMPLOYMENT"."REHIRE_DT",NULL, "PS_EMPLOYMENT"."HIRE_DT","PS_EMPLOYMENT"."REHIRE_DT" ) Copy and paste Artie Dunnings ADTECH Consulting Inc HRIS Functional & Technical Trainer Alpharetta, GA

I would create a new RS report using the Job / Jobcode_tbl and just include the Jobcode in the report. Employment table for your term date as well as a selection for it being 2 dates. Derived fields for Terms and one for active and one to get the turnover percent. Sum(Decode Job Status...

Not possible with in a Columnar report. It has to be two field or you can jion the side by side with a space inbetween, but RS will not make it one with 2 rows. It would have to be a master detail report to get two with the 1st report returning the 1st Date and the 2nd report returning the 2nd...

I do not have a pcpw database but this is the formula you need. Change the "PS_AL_CHK_DED"."AL_DEDCD" to your table & field as well as the 2nd "PS_AL_CHK_DED"."AL_AMOUNT" and the 'V' to your value. Make the fields with in the table that you are using in the derived field formula Query Only and...

This is a new version of RS that adp is now offering. I would check with the adp RS support log a case and then have them exculated to tier III. They will probally be the only ones with it. Is there something in particular you are trying to accomplish. I am sure I can help... Artie Dunnings...

Question. Are you an oracle or sql_server database client? I would format the date field within the derived field, either using the TO_CHAR or the compatible sql_server function under the Date selection. Copy you derived field and place it in the reply. I will forward the formula...... Artie...

I know this is from april but if your still having problems, I would do it as a Master Detail where you can conbind multiple reports within one. Call me if this is still a problem. 678-772-3058. Be glad to help out... Artie Dunnings ADTECH Consulting Inc HRIS Functional & Technical Trainer...

You must be a PCPW client with the report catolog installed. Meaning all users only have access to there own reports. Call the local RS hub and they can remove the catolog and that way you will be able to see the reports and simply copy and paste the reports to the desired directory and other...

If you can call me I can walk you through it in less then 10 minutes. You have allot going on. You need outer joins between the Check_Data and Chk_DED tables and your probally loosing people that don't have any deductions for take pay_date There are 6 link between the two and well as the...

You are probally using Decode in the formula with out Sum(Distinct in front of it. If so, highlite the formula and change String Functions to Summary and double click Sum(Distinct. This will put the function in the formula correctly. Then go to table and make sure the Earning Code and Earnings...

You probally using the PS_BEN_PROG_PARTIC TABLE. You want to assign the table an alais of "A". In selection, insert an selection that states: Data Field EVENT_DT TO FORMULA. Click on the line at the end and copy and paste the below statement. (SELECT MAX(B.EVENT_DT) FROM PS_BEN_PROG_PARTIC B...

I have table & view info that I have put together in a word doc I can email to you. It's not the whole data dic but it's contains the most freq used tables. I have this info for Enterprise / HR & Payroll and also CSS paycheck (payroll) info. Inform on with app you are using. adunnings1@comcast.net