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 | |||