Table: dbo.Graduated_Payroll_Item_Tier
Columns
NameTypeConstraintsDescription
graduated_payroll_item_tier_KEYint (4)NOT NULLPrimary key of this table.
client_payroll_item_KEYint (4)NOT NULLParent client payroll item record.
lower_bound_percentage_or_amountdecimal (9, 5)NOT NULLThe 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_amountdecimal (9, 5)NOT NULLThe 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_amountdecimal (9, 5)NOT NULLThe 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
NameColumnsDescription
PK_Graduated_Payroll_Item_Tiergraduated_payroll_item_tier_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Graduated_Payroll_Item_Tier__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)

Schema diagram