My Oracle Support Banner

E1: 07S: SUI Employee Count For The 12th Of The Month (Doc ID 1578099.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne US Payroll - Version 9.0 to 9.1 [Release 9.0 to 9.1]
Information in this document applies to any platform.


The Department of Labor Bureau of Labor Statistics requires that monthly employment data reported on both the quarterly contribution report and multiple worksite report should be a count of all full-time and part-time workers who worked during or received pay subject to unemployment insurance wages for the pay period which includes the 12th day of the month. 

The JD Edwards EnterpriseOne Human Capital Management software has been enhanced to accommodate this requirement. The SUI (State Unemployment Insurance) workfile build process was changed to correctly identify employees who worked during or received pay for the pay periods containing the 12th day of each month within the reporting quarter.

Four processing options were added to the SUI work file build UBE (R078300) to associate  a pay cycle code with each pay frequency.


The pay cycle codes are used to define pay periods that contain the 12th day of each month in the quarter.  The system will determine that the employee worked or was paid on the 12th day of each month (based on the pay frequency) when historical timecards are found in the F0618 (Employee Transaction History) table with the values listed below:

  1. The timecard is assigned a pay period end date matching the end date of the derived pay period containing the 12th of the month
  2. The timecard's gross pay has an effect on both the employee's gross and net pay
If no timecard records are found satisfying this criteria, the system determines the employee did not work or receive pay during the pay period for the 12th of the month.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.