ETL9.2: The Start Of The Week In The ACA Week Query Is Incorrect.

(Doc ID 2101785.1)

Last updated on FEBRUARY 11, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, TL Installation and Setup

The start of the week in the ACA Week query is incorrect.

The ACA delivered query called ACA WEEK, has a field called ACA_WEEK. When the query is ran the field is populated with a Thursday date for the year 2015. Our week begins on a Monday and ends on a Sunday. All Time and Labor hours are submitted on the timesheet, starting on monday and ending on Sunday. Our time reporting week does not change based upon the calendar year.

Our measurement period is based upon a 52 week look back period and period begins on a Monday to correspond with the time being reported in Time and labor. We have determined our standard measurement period for ongoing employees wiill be approximately October 15 - October 14 of each year.

The IRS does not require the Measurement periods to reflect a Calendar Year. The IRS rules and regulations state "Under the Look-Back measurement method for ongoing employees, an applicable large employer member determines each ongoing employee's full-time employee status by looking back at a standard measurement period of at least three months but not more than 12 months, as determined by the employer. The applicable large employer member determines the months in which the standard measurement period starts and ends" We have determined our standard measurement period for ongoing employees wiill be approximately October 15 - October 14 of each year.

PS may begin the week on a the first day in a calendar year, but we need to be able to calculate average hours based upon our defined Measurement Period and IRS allows measurement periods to vary as long as they meet the minimum requirements as stated in the rules.

Since the IRS allows the period to be determined by the employer I don't understand how this solution supports the IRS rules for calculating payable hours where the period can be determined by the employer.

The query should be changeable to coincide with the weekly period start and end date
The issue can be reproduced at will with the following steps:
1. Navigate to Reporting tools > Query > Query Manager
2. Pull up query ACA_WEEK
3. When it is run the effective date is 01/01/2015 and the start day corresponding to it is a Thursday as opposed to their weekly start day of Monday




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms