Calculating Time-to-Gross

Time-to-Gross translates the employee’s hours worked to gross pay based on the employee’s associated pay rate(s). This process performs the following:

  1. The system establishes the current pay period (based on the Pay Period (PERD) table) and verifies that dates entered in the timesheets fall within the current pay period. It also verifies the employee is eligible to be paid (for example, the employee is active versus inactive without pay). In addition, it verifies the hours entered into the timesheet and verifies that the Event Type and override accounting distribution information is valid.

  2. The system multiplies the time by the appropriate pay rate hourly wage to calculate gross pay and updates the summary tables for leave activity. The system also processes leave details. For leave events with pay, it processes both the leave usage and calculates associated pay. The process checks the Pay Policy Event Type (PPET) table to verify that the employee’s pay policy includes the recorded pay event and checks the minimum and maximum daily information and increments to make sure the amount entered is within these parameters. It also calculates component pay using the Pay Policy Event Type (PPET) table and uses the factor amount. In addition, entries in the Pending Payment (PEND) page are created.

  3. When the Parameter Value for the MULTI_STATE_TAX Application Parameter (APPCTRL) is set to Y, the Time-to-Gross (TTG) process  populates State ID and Local ID on pending payments for Timesheet (TIMEI), Timesheet Adjustment (TADJ), Overload Payment Generator (OPAY) and One-Time Payment (OTPAY) transactions, using the following hierarchy:

  1. When a Schedule Location is populated on the transaction, the State ID and Local ID on the pending payment is populated with the State and Locality associated with the Schedule Location on the Location (LOCA) reference page.

  2. When a Schedule Location is not populated on the transaction, the State ID on the pending payment is populated with the State ID on the employee’s active state tax enrollment that has Primary Tax Location selected. Local ID will not be populated.

  3. When a Schedule Location is not populated on the transaction, and the employee does not have an active state tax enrollment, State ID and Local ID will not be populated on pending payments.

  4. When the Feature ID Exception Pay Work Hour Rate is enabled on the Offline Process Configuration (OPROC) reference page,

  5. If a pay event with Work Hour Calculation field set as Work Schedule on the Pay and Leave Events (EVNT) reference page is reported on a time transaction, the Time-to-Gross (TTG) process uses the employee's work schedule hours as defined by the work schedule hierarchy to calculate the pay rate.

  • If the employee's work schedule is changed in the middle of the pay period, TTG process calculates the total scheduled work hours as the total hours from the work schedule from the first timeslice of the employee's assignment added to the total hours from the work schedule from the second timeslice of employee's assignment.

  • If the employee had a mid-pay period termination, hire or re-hire, then the scheduled work hours are calculated based on the work schedule for the active timeslice of the employee's assignment.

  • If the employee has multiple exception-paid appointments, then the scheduled work hours are calculated for each appointment based on the work schedule associated with the appointment.

  • If the employee's calculated salary is changed in mid-pay period, then the pay rate is calculated based on each applicable timeslice of the assignment within the pay period.

  1. If the Work Hour Calculation field is set as Calendar Day on the EVNT reference page, TTG process calculates the scheduled work hours as (number of days in calendar month * 8)/2.

  2. If the Work Hour Calculation field is set as Pay Class or blank on the EVNT reference page, TTG process uses the pay period hours from the employee’s pay class as the scheduled work hours.

  3. If a pay event with Use Standard Pay Class Hours field set as Yes on the EVNT reference page is reported on a time transaction, FLSA Pay amount is calculated based on the formula, [Pay Period Calculated Salary / PYCL Standard Pay Period Hours] * (Input Amount/60) * Pay Type Factor Amount * % Pay Included in FLSA.

When the Parameter Value for the MULTI_STATE_TAX APPCTRL entry is set to N, State ID and Local ID will not be populated on pending payments.

After Time-to-Gross, a report is generated that indicates which transactions were accepted and which transactions were rejected. It is important to review this report and incorporate any changes prior to processing payroll. The following transactions are processed by Time-to-Gross.

  • Timesheet Adjustment (TADJ) is used to enter hours worked or leave taken in a prior pay period and to record actual hours for positive-paid employees and exception events for exception-paid employees.

  • Leave Accrual (LEAV) is used to manually accrue leave.

  • Automatic Leave Accrual (AACC) is used to enter automated leave accruals.

  • External Adjustments (EADJ) is used to enter activity that adjusts existing balances.

Output from Time-to-Gross

When Time-to-Gross runs successfully, the following output is prepared for running a pay cycle: timesheets are converted to gross pay, outside adjustments are incorporated, and detail and summary leave tables are updated.

  1. When timesheet entries are converted to gross pay, the rate of pay is determined and multiplied by the time listed for each pay event. Pending payments are created and placed on the Pending Payment (PEND) table.

  2. Outside adjustments are incorporated by processing External Adjustment (EADJ) transactions. This transaction is used to enter external activity in order to correct existing balances.

  3. Detailed and summary leave tables are updated directly with all manual leave accruals and leave taken during this pay cycle. Automated accruals are updated when the pay cycle is run.