Periods of Employment

As a Benefits Administrator, you use the Periods of Employment report to review which months an employee was employed or not employed during the reporting year.

The Periods of Employment report helps to identify gaps in offers of health coverage for a month, if the gap is due to the employee not being employed during the month. This information is required to correctly report Form 1095-C Part II Employee Offer and Coverage codes.

The Periods of Employment (R08118) batch version processes the employee's employment period information from the HR History table (F08042) and updates it in the Periods Of Employment table (F08118). The Periods of Employment report (R08118) finds occurrences of Date Started and Date Terminated for an employee and sequences them according to effective date to construct a history of an employee's employment periods.

Note:

The Periods of Employment report (R08118) processes employees based on HR History and occurrences of Date Started and
Date Terminated. If the employee does not have any tracked records for Start Date and/or Termination Date in the HR History table (F08042), then the employee's Start Date and/or Termination Date is retrieved from the Employee Master table (F060116)
to update the F08118 table.

When the Form 1095-C Offer and Coverage Workfile Build (R08119) runs, it refers to the Periods Of Employment table (F08118). If no records are found for an employee in the F08118 table, the Form 1095-C Offer and Coverage Workfile Build retrieves the current Start Date and Termination Date value from the Employee Master table (F060116).

You can use the Work With Periods of Employment program (P08118) to review the periods of employment information. This program retrieves the information from the Periods Of Employment table (F08118). You can use the Work With Periods of Employment program (P08118) to review, add, delete, and update data. Any updates to the F08118 table including imported records will be overridden when the R08118 report is processed again.

If you are not using the HR History table, you can use the standard functionality for importing grid data to import existing periods of employment data from a spreadsheet or a comma-delimited file into the Work With Periods of Employment program.