Hello,
I am using ADP PCPW V 5.1, and ReportSmith V 4.2.2002/Oracle.
Acording to ADP, "period begin" date is calculated and not stored, therefore, this date is not available in tables. I'm thinking that a derived field can calculate period begin from either paydate-12 or period end - 13. There is a catch. We use "pay group" to identify the period end for hourly versus salary employees. This field is just a radio buttion, which I believe triggers a calc during transmission of the payroll. In text terms, this is what I'm trying to accomplish:
(Our hourly employees are paid one week in arrears, while salary employees are paid current. For example, salary employee's period begin date is 03/16/08 and ends on 03/29/08 Hourly's begin date is 03/10/08 and ends on 03/23/08. The pay date 03/28/08 is the same for both groups.)
RateType = H, paydate minus 18
RateType = S, paydate minus 12
Any assistance would appreciated.
I am using ADP PCPW V 5.1, and ReportSmith V 4.2.2002/Oracle.
Acording to ADP, "period begin" date is calculated and not stored, therefore, this date is not available in tables. I'm thinking that a derived field can calculate period begin from either paydate-12 or period end - 13. There is a catch. We use "pay group" to identify the period end for hourly versus salary employees. This field is just a radio buttion, which I believe triggers a calc during transmission of the payroll. In text terms, this is what I'm trying to accomplish:
(Our hourly employees are paid one week in arrears, while salary employees are paid current. For example, salary employee's period begin date is 03/16/08 and ends on 03/29/08 Hourly's begin date is 03/10/08 and ends on 03/23/08. The pay date 03/28/08 is the same for both groups.)
RateType = H, paydate minus 18
RateType = S, paydate minus 12
Any assistance would appreciated.