Table: dbo.Graduated_Payroll_Item_Tier
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Graduated_Payroll_Item_Tier | graduated_payroll_item_tier_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Graduated_Payroll_Item_Tier__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |