graduated_payroll_item_tier_KEY | int (4) | NOT NULL | Primary key of this table. |
client_payroll_item_KEY | int (4) | NOT NULL | Parent client payroll item record. |
lower_bound_percentage_or_amount | decimal (9, 5) | NOT NULL | The lower bound of the tier. The limit calculation type stored in the client payroll item determines whether we interpret the value in this field as an amount or as a percentage. |
upper_bound_percentage_or_amount | decimal (9, 5) | NOT NULL | The upper bound of the tier. The limit calculation type stored in the client payroll item determines whether we interpret the value in this field as an amount or as a percentage. |
payroll_item_percentage_or_amount | decimal (9, 5) | NOT NULL | The amount or percentage associated with the range of values defined by the tier. The calculation type stored in the client payroll item determines whether we interpret the data in this field as an amount or as a percentage. |