MA ICESA - Hours Worked is inflated

4500 hours are reporting for Hours Worked in MA ICESA when Accumulators shows 300. 

• Payroll
• Massachusetts
• MA ICESA Employment Wage and Detail Report

UOM in Pay Master = D-Days

When UOM = Days, program attempts to convert days to hours for an accurate Hours Worked.

Review setup. 

In some cases, the UOM on the Pay Master can be updated.  If the pay is used for both hourly and daily employees, the correction requires additional analysis.  For example, is it possible to create distinct pay types for hourly versus daily/salary employees?  Please contact Payroll Support if additional assistance is needed. 

• Hours Worked is reported in Columns 132-134 on the S Record
• Generate sums Hours from the Quarterly Pay records in Employee Accumulators, excluding any Pays defined on the Generate as Excluded or Excluded for Hours Only.

• If Pay Master UOM for the Pay in Accumulators is “D – Daily”, Hours Worked is the number of hours per day the employee works multiplied by the number of days reflected in the Hours field on the Accumulator record.

  • Hours per Day is pulled from Employee Job/Salary using the following hierarchy:
    • The Primary Job for the specific Pay code
    • If no record is found on the first attempt, the program looks for the specific Pay code for any Job.
    • If no record is found on the second attempt, the program will use the Hours/Day value from the primary base pay record.
• Master Article - MA ICESA Employment Wage and Detail Report