Based on Hours Worked (HRLY)

The Based on Hours Worked routine takes a specific dollar amount per hour.  The hourly rate is stored in the flat deduction amount fields on the Deduction Plan (DPLN) page (e.g., Weekly Amount or Bi-Weekly Amount) and can be overridden on the employee's record (for example, using the Miscellaneous Deductions (MISC) page).  Advantage HRM multiplies the number of hours for the subject gross by the hourly amount.  The subject gross hours are indicated in the same way as the subject gross amount on the DPLN page.

If the Special Routine ID is SRFM Special Routine then the following fields on DPLN must be set:

• Amount/Percent 1: Value denoting how the Subject Gross is utilized in the calculation and if it should be added to / subtracted from the formula identified in Amount/Percent 1.

• 0 = Subject Gross is not used

• 1 = Calculated Subject Gross value is added

• 2 = Calculated Subject Gross value is subtracted

• Amount/Percent 2: Percent to be divided by 100 and then multiplied by Subject Gross for use in the calculation (for example 22.75 / 100 = .2275).

• Amount/Percent 3: Threshold which the calculated deduction must be greater than in order for it to be taken.

• Amount/Percent 4: Override Deduction Amount to be used if the calculated deduction amount is less than or equal to the Threshold value in Amount/Percent 4.

• Amount/Percent 5-10: Not used

Using the Formula ID field value, the system performs a look up to SRFM to get the formula components (each Formula ID on SRFM must be setup with the unique set of components for that routine).  

• If Amount/Percent 1 value is 1, the system takes (Subject Gross * Amount/Percent 2) value and then add/subtract all amounts from SRFM components to arrive at the calculated deduction amount.  

• If Amount/Percent 1 value is 2, the system takes the negative of (Subject Gross * Amount/Percent 2) and then add/subtract all amounts from SRFM components.

• If Amount/Percent 1 value is 0, then Amount/Percent 1 and Amount/Percent 2 are not used, and the deduction is calculated solely by adding/subtracting amounts from SRFM components.

• If the resulting calculated amount is not greater than the threshold specified in Amount/Percent 3, it will override the calculated deduction amount with the value from Amount/Percent 4.  Otherwise, it will set the deduction amount to the calculated value.