View: dbo.Graduated_Payroll_Item_Tier_Full_View
View definition
-- View that encapsulates a client payroll items graduated payroll item tier and
-- orders the records by row number, upper_bound_percentage_or_amount and pk.
create view dbo.Graduated_Payroll_Item_Tier_Full_View
as
select
graduated_payroll_item_tier_KEY
, client_payroll_item_KEY
, lower_bound_percentage_or_amount
, upper_bound_percentage_or_amount
, payroll_item_percentage_or_amount
, row_number() over (partition by client_payroll_item_KEY
order by
upper_bound_percentage_or_amount
, graduated_payroll_item_tier_KEY) as sequence_number
from
dbo.Graduated_Payroll_Item_Tier