Setting Up the Hours Worked by Month Build (P08524)
This section provides an overview of the Hours Worked by Month build and report and discusses how to:
Setup the processing options and data selection for Hours Worked by Month Report (P08424)
Set processing options for Hours Worked by Month Build (P08524).
Run the Hours Worked by Month Build (P08524).
Run the Hours Worked by Month Report (P08424).
Add or update hours-worked-by-month records (P08224).
The Hours Worked by Month Report (P08424) runs automatically if you set the processing option for Hours Worked by Month Build (P08524). If you leave the processing option blank, the build does not produce a report.
Hours Worked by Month
As a Benefits Administrator, you use the Hours Worked by Month Revisions (P08124) to review hours worked by an employee by month and by Home Company.
The Hours Worked by Month Build (P08524) calculates the number of hours that the employee worked in a month, by using the timecard history information that is stored in the Employee Transaction History file (F0618). When you run the build, the system updates the Hours Worked by Month file (F08124).
The Hours Worked by Month report (P08424) prints the information created during the Hours Worked by Month Build (P08524).
The data selection for the report must be setup the same as the data selection for the build in order to see only the records created during the build. This is because the report can be run independently from the build.
To review, add, update and delete the hours-worked-by-month information, you use the Hours Worked by Month Inquiry (P08124), which retrieves the information from the Hours Worked by Month file (F08124). The F08124 file stores the hours worked by calendar month and by company.
Each employee who has to be issued a Form 1095-C must have at least one record in this file to indicate the Home Company employer that is equivalent to the ALE Member under which the employee should be reported. If you do not use JD Edwards Payroll or Time and Labor, then you do not have Employee Transaction History (F0618). This information is used to determine the ALE Member (employer) under which an employee must be reported for each month of the reporting year. At least one record must be added or imported for each employee.
The Hours Worked by Month file (F08124) is used to determine the employer for whom the employee worked for each month of the year. Form 1095-C Offer and Coverage Workfile Build references the Hours Worked by Month to determine the employer. Offer and Coverage Workfile Build considers hours by company based on Tax ID; that is, if an employee has hours in more than one company in a month, the hours are first combined based on Tax ID, and then the hours by Tax ID totals are compared. The Tax ID with the most hours in the month is the ALE Member responsible for reporting the employee for the month. If an employee who is employed in a month does not have any data in the F08124 file for a month, for example, because of a leave of absence, the prior month's F08124 data is used to determine the ALE Member for that month.
According to the IRS Forms 1094-C and 1095-C instructions, if hours are equal for a month, select one. The system will select the lowest numbered company.
You can use the Hours Worked by Month Inquiry (P08124) to review, add, delete and update data. Any updates to the F08124 file will be overridden when the Hours Worked by Month Build (P08524) is processed again.
If you do not have Employee Transaction History file (F0618) data from which to build the Hours Worked by Month file, you can use the Hours Worked by Month batch import program (P08124Z) for importing grid data to import an employee's hours-worked history from a spreadsheet or a comma-delimited file.
Running the Hours Worked by Month Build (P08524)
The Hours Worked by Month build is run from menu G08AIR.
Navigation
From Human Resources (G08), choose Affordable Care Act
From Affordable Care Act (G08ACA), select ACA Information Returns
From ACA Information Returns (G08AIR), select Hours Worked by Month Build
Running the Hours Worked by Month Report (P08424)
The Hours Worked by Month report is run as part of the build process, if a version is specified in the processing options for the build job. It can also be run independently from the build from the reports menu (G08ACAR).
Sample Hours Worked by Month Report
Setting Processing Options for Hours Worked by Month Build (P08524)
Adding or Updating Hours Worked by Month Records
Navigation
From Human Resources (G08), choose Affordable Care Act
From Affordable Care Act (G08ACA), enter 29
From ACA Information Returns Setup (G08ACA41), select Hours Worked by Month Inquiry
In the Hours Worked by Month Inquiry (P08224), complete the following fields:
Field | Description |
|---|---|
Reporting Year | The calendar year for which the ACA Health Coverage Information Return is being produced. |
Employer Tax ID | A number that identifies your company to the tax authority. This number can include the tax ID number for an individual, a federal or state corporate tax ID, a sales tax number, and so on. This number has specifically been established for the Payroll system to handle the requirements of taxing authorities that require more than nine positions for the tax identification number. Note: Do not enter hyphens (dashes), slashes, spaces, or other punctuation in the tax identification number. |
Home Company | The company number where the employee records generally reside. |
Months - Jan to Dec | The total hours an employee worked in a specified month. This value accumulates in the Employee Transaction History hours worked based on date worked. |