Make a pivot table to find the highest payment in each year for each employee

#10145

Make a pivot table to find the highest payment in each year for each employee.

Find payment details for 2011, 2012, 2013, and 2014.

Output payment details along with the corresponding employee name.

Order records by the employee name in ascending order

table name: sf_public_salaries


Solution:

with cte as(
select employeename,[2011],[2012],[2013],[2014]
from
(select employeename,totalpay,year from sf_public_salaries) as data1
pivot
( 
	 max(totalpay) for year in ([2011],[2012],[2013],[2014])) as data2

	)
	select employeename,isnull([2011],0) as pay_2011,isnull([2012],0) as pay_2012,
	isnull([2013],0) as pay_2013,isnull([2014],0) as pay_2014 from cte

Output:


SQL Script:

USE [StraScratch]
GO
/****** Object:  Table [dbo].[sf_public_salaries]    Script Date: 26-09-2024 17:13:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_public_salaries](
	[id] [int] NULL,
	[employeename] [varchar](50) NULL,
	[jobtitle] [varchar](50) NULL,
	[basepay] [float] NULL,
	[overtimepay] [float] NULL,
	[otherpay] [float] NULL,
	[benefits] [float] NULL,
	[totalpay] [float] NULL,
	[totalpaybenefits] [float] NULL,
	[year] [int] NULL,
	[notes] [datetime] NULL,
	[agency] [varchar](50) NULL,
	[status] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (120566, N'Teresa L Cavanaugh', N'EMT/Paramedic/Firefighter', 100952.41, 0, 4254.88, 34317.37, 105207.29, 139524.66, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72002, N'Ray Torres', N'Public Service Trainee', 1121.28, 0, 0, 185.77, 1121.28, 1307.05, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (122662, N'Rizaldy T Tabada', N'Deputy Sheriff', 92403.77, 138.18, 2903.94, 33625.27, 95445.89, 129071.16, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140133, N'Gregory B Bovo', N'Firefighter', 23757.5, 0, 0, 9982.21, 23757.5, 33739.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (87502, N'Jason L Landivar', N'EMT/Paramedic/Firefighter', 82115.61, 666.79, 5220.34, 28933.91, 88002.74, 116936.65, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71770, N'Fernando Barajas', N'Public Svc Aide-Public Works', 1585.6, 0, 0, 178.07, 1585.6, 1763.67, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144682, N'George Fudge', N'Transit Operator', 4390.15, 1059.31, 12.11, 2846.74, 5461.57, 8308.31, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148136, N'Jose F Granados', N'Public Svc Aide-Public Works', 661.2, 0, 0, 6.61, 661.2, 667.81, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72175, N'Linda Pizzorno', N'Registered Nurse', 0, 0, 795.01, 230.64, 795.01, 1025.65, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110316, N'Sophia  Wu', N'Public Service Trainee', 295.41, 0, 0, 2.95, 295.41, 298.36, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110441, N'Maria E Zuniga', N'Transit Operator', NULL, 0, 114.54, 0, 114.54, 114.54, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (57726, N'Sara Paredes', N'Registered Nurse', 65061.57, 0, 975, 23477.4, 66036.57, 89513.97, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135711, N'Adina M Diamond', N'Registered Nurse', 52901.45, 3307.79, 2286.95, 19383.18, 58496.19, 77879.37, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (139629, N'Terry L Johnson', N'Transit Operator', 21183.22, 3841.15, 510.61, 13384.77, 25534.98, 38919.75, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64401, N'Sherry Mahoney', N'EMT/Paramedic/Firefighter', 29579, 0, 2402.7, 11785.19, 31981.7, 43766.89, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148022, N'Kari A Johnson', N'Firefighter', 688.71, 0, 0, 143.39, 688.71, 832.1, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (114356, N'Joseph M Salazar', N'Sergeant 3', 124770.09, 14167.98, 7510.15, 40182.2, 146448.22, 186630.42, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (104037, N'Annette  Kess', N'Transit Operator', NULL, 0, 11808, 7959.18, 11808, 19767.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71779, N'Ayala Mirande', N'Special Nurse', 367.73, 942.38, 44.11, 388.96, 1354.22, 1743.18, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143075, N'George L Abrams Jr', N'Transit Operator', 7316.62, 1622.58, 30.95, 4742.85, 8970.15, 13713, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64411, N'Seaborn Chiles', N'EMT/Paramedic/Firefighter', 29579, 551.46, 1626.46, 11871.64, 31756.92, 43628.56, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69659, N'Gwen Ferdinand', N'Transit Operator', 4506.51, 391.87, 46.56, 2806.53, 4944.94, 7751.47, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144573, N'Robert E Lee Jr', N'Transit Operator', 4390.16, 1258.02, 9.08, 2847.85, 5657.26, 8505.11, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72720, N'Andre Thomas', N'Public Svc Aide-Public Works', 155.85, 0, 2.44, 13.84, 158.29, 172.13, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (60447, N'James Lockhart', N'EMT/Paramedic/Firefighter', 58842, 0, 3801.37, 17031.18, 62643.37, 79674.55, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148014, N'Eric J Chen', N'Public Service Trainee', 800.13, 0, 35.66, 8.35, 835.79, 844.14, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109041, N'Paul J Ortiz', N'Special Nurse', 1768.55, 0, 243.6, 451.01, 2012.15, 2463.16, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142145, N'Victor N Yeung', N'Transit Operator', 11889.93, 0, 0, 6285.35, 11889.93, 18175.28, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39463, N'Steven Stocker', N'Sergeant 3', 135977.79, 1044, 12934.3, 36523.7, 149956.09, 186479.79, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (46861, N'Theresa Courtney', N'Deputy Sheriff', 88374, 3897.86, 6778.32, 34097.49, 99050.18, 133147.67, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (83706, N'Donald V Ortiz', N'Deputy Sheriff', 95126.53, 57.21, 6787.65, 33016.42, 101971.39, 134987.81, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (108749, N'Vivian A Showers', N'Transit Operator', 2056.09, 0, 0, 982.35, 2056.09, 3038.44, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (108321, N'Lenora  Hamilton', N'Transit Operator', 2529.28, 0, 0, 1464.59, 2529.28, 3993.87, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (125043, N'Ryan J Jamison', N'EMT/Paramedic/Firefighter', 81789.51, 1750.43, 2791.35, 31039.42, 86331.29, 117370.71, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102647, N'Alvin  Sosa', N'Transit Operator', 19331.12, 484.95, 460.37, 11349.44, 20276.44, 31625.88, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71309, N'Ernanie Rasquero', N'Special Nurse', 1831.8, 0, 61.06, 847.08, 1892.86, 2739.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144513, N'Ben D Malone', N'Transit Operator', 381.69, 0, 8103.54, 196.19, 8485.23, 8681.42, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (67873, N'Niem Tran', N'Transit Operator', 8975.38, 162.14, 51.1, 5794.22, 9188.62, 14982.84, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (66561, N'Nicole Freeney', N'Transit Operator', 9877.98, 2607.74, 3446.78, 6295.89, 15932.5, 22228.39, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (47109, N'Stephen Kendall', N'Deputy Sheriff', 81967.01, 8984.59, 6725.08, 34177.42, 97676.68, 131854.1, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109107, N'Elizabeth J Dayrit', N'Special Nurse', 1783.94, 0, 178.39, 371.87, 1962.33, 2334.2, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (125930, N'Andrew G Chen', N'Estate Investigator', 82052.03, 0, 0, 31796.98, 82052.03, 113849.01, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143254, N'Larry J Davis', N'Transit Operator', 813.86, 0, 11803.87, 418.32, 12617.73, 13036.05, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39456, N'Melonee Alvarez', N'Sergeant 3', 135977.71, 5929.86, 6457.7, 38170.25, 148365.27, 186535.52, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102938, N'Pelzie L Smith', N'Transit Operator', 17563.25, 490.1, 121.01, 10229.59, 18174.36, 28403.95, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (56967, N'Denise Alexander', N'Estate Investigator', 61663.37, 0, 187.2, 30295.13, 61850.57, 92145.7, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71790, N'David Fleming', N'Special Nurse', 1294.4, 0, 63.5, 371.94, 1357.9, 1729.84, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105663, N'Brian E Oconnor', N'Deputy Sheriff', 10433.32, 0, 742.59, 0, 11175.91, 11175.91, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109201, N'Jesus J Aromin', N'Public Svc Aide-Public Works', 2123.47, 0, 0, 21.23, 2123.47, 2144.7, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (68610, N'Liane Angus', N'Registered Nurse', 9456.38, 0, 0, 2042.66, 9456.38, 11499.04, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147868, N'Alma Rosa Garcia', N'Special Nurse', 849.45, 0, 28.32, 191.27, 877.77, 1069.04, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106739, N'Joann G Siobal', N'Registered Nurse', NULL, 0, 0, 7959.18, 0, 7959.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (122121, N'Michael Mason', N'EMT/Paramedic/Firefighter', 79486.03, 11570.7, 7049.8, 33573.17, 98106.53, 131679.7, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72890, N'Grace Salud', N'Special Nurse', 0, 0, 37.36, 8.91, 37.36, 46.27, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135574, N'Raffaella V Wilson', N'Registered Nurse', 60506.68, 701.61, 0, 17555.43, 61208.29, 78763.72, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (120935, N'Lance A Obtinalla Jr', N'Deputy Sheriff', 93795.43, 1738.87, 6970.54, 35014.44, 102504.84, 137519.28, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140150, N'Ryan C Crow', N'Firefighter', 23757.5, 0, 0, 9982.21, 23757.5, 33739.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106686, N'Tracy Y Higgins', N'Transit Operator', NULL, 0, 0, 8014.34, 0, 8014.34, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (120469, N'Alexander M Lamond', N'EMT/Paramedic/Firefighter', 80143, 19393.4, 6783.04, 33498.66, 106319.44, 139818.1, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147667, N'Justina Dizon', N'Special Nurse', 989.1, 0, 164.85, 214.11, 1153.95, 1368.06, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (103394, N'Daniel Phillip Boutote', N'Eligibility Worker', 18943, 0, 967.4, 4468.04, 19910.4, 24378.44, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147540, N'Ivan Y Castillo', N'Public Svc Aide-Public Works', 1597.9, 0, 0, 15.98, 1597.9, 1613.88, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105493, N'Willie  Daigle Jr', N'Transit Operator', 7064.29, 455.11, 32.56, 4364.12, 7551.96, 11916.08, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (66543, N'Margarita Herrera', N'Registered Nurse', 17973.09, 80.08, 21.36, 4245.6, 18074.53, 22320.13, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147284, N'Alan K Tolbert', N'Public Svc Aide-Public Works', 2070.29, 0, 0, 20.7, 2070.29, 2090.99, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (76558, N'Kathryn  Waaland', N'Sergeant 3', 141389.04, 4981.45, 2832.11, 40661.65, 149202.6, 189864.25, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143223, N'Luana D Beavers-Deloach', N'Transit Operator', 7159.17, 1303.18, 39.68, 4640.62, 8502.03, 13142.65, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143124, N'Marie E Monsen', N'Transit Operator', 7316.8, 1426.95, 52.85, 4747.43, 8796.6, 13544.03, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71858, N'Arnitial Donely', N'Public Svc Aide-Public Works', 1506.55, 0, 0, 116.64, 1506.55, 1623.19, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (63919, N'Christopher Wilcox', N'Registered Nurse', 19711.37, 3004.88, 16478.15, 10172.15, 39194.4, 49366.55, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106654, N'Ira  Newman', N'Transit Operator', NULL, 0, 115.72, 7959.18, 115.72, 8074.9, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (70958, N'Mandisa Mabrey', N'Eligibility Worker', 3165.48, 11.22, 109.29, 286.43, 3285.99, 3572.42, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72067, N'Juliet Palarca', N'Special Nurse', 981.72, 0, 0, 283.6, 981.72, 1265.32, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (46086, N'Arnel Maracha', N'Deputy Sheriff', 88374, 0, 12448.42, 36413.52, 100822.42, 137235.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147504, N'Jamie J Dwyer', N'Special Nurse', 1285.05, 0, 63.5, 324.83, 1348.55, 1673.38, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69902, N'Jacquelyn Vassar', N'Transit Operator', 4017.09, 278.96, 16.37, 2641.41, 4312.42, 6953.83, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135122, N'Melinda Wong', N'Junior Administrative Analyst', 53190.53, 0, 0, 27849.12, 53190.53, 81039.65, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (122772, N'Graham P Hoffman', N'EMT/Paramedic/Firefighter', 80031.97, 11455.35, 5163.82, 31853, 96651.14, 128504.14, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71420, N'Kevin Clark', N'Public Svc Aide-Public Works', 2337.75, 0, 0, 204.3, 2337.75, 2542.05, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109069, N'Antionette L Riley', N'Public Svc Aide-Public Works', 2396.21, 0, 0, 23.97, 2396.21, 2420.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (141349, N'Audrey Ngo', N'Registered Nurse', 18725.55, 0, 160.31, 4351.3, 18885.86, 23237.16, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (68980, N'Robert Martinez', N'Registered Nurse', 8862.65, 0, 365.99, 740.47, 9228.64, 9969.11, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148626, N'Renato C Gurion', N'Registered Nurse', 0, 0, 6, 1.24, 6, 7.24, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39539, N'Omar Bueno', N'Sergeant 3', 135967.55, 3237.59, 9032.26, 37389.65, 148237.4, 185627.05, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106805, N'Georgina M Pineda', N'Transit Operator', NULL, 0, 0, 7959.18, 0, 7959.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140237, N'Beverly Bagdorf', N'Registered Nurse', 14958.86, 0, 12311.86, 5538.93, 27270.72, 32809.65, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (141997, N'Emmanuel R Borja', N'Transit Operator', 10841.17, 950.95, 235.79, 7082.09, 12027.91, 19110, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110465, N'Vanessa E Almaguer', N'Special Nurse', 72.98, 0, 0, 15.2, 72.98, 88.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64823, N'Lilly Fung', N'Registered Nurse', 28586.7, 0, 0, 10105.75, 28586.7, 38692.45, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (65683, N'Mo Ching Wan', N'Registered Nurse', 22650, 0, 0, 6714.77, 22650, 29364.77, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (107962, N'Leanne Abrigo  Johnson', N'Registered Nurse', 4015, 0, 0, 876.07, 4015, 4891.07, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (141206, N'Wallina C Pellette', N'Transit Operator', 14872.99, 4598.75, 87.52, 4652.55, 19559.26, 24211.81, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (101991, N'Tretha T Stroughter', N'Eligibility Worker', 24282.43, 2048.88, 1851.05, 10164.46, 28182.36, 38346.82, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109207, N'Yolanda  Ramirez', N'Special Nurse', 1505.7, 0, 239.96, 383.43, 1745.66, 2129.09, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48994, N'Sarah Silva', N'Deputy Sheriff', 78346.64, 7001.85, 4451.18, 33280, 89799.67, 123079.67, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143534, N'Monique C Jacobs', N'Transit Operator', 7781.96, 0, 0, 4026.55, 7781.96, 11808.51, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102585, N'Arturo  Galarza', N'Eligibility Worker', 23928.01, 0, 360, 7988.84, 24288.01, 32276.85, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71498, N'Willie Collins', N'Public Svc Aide-Public Works', 2129.95, 0, 43.92, 190.04, 2173.87, 2363.91, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (133757, N'Kathryn L Fowler', N'Registered Nurse', 61942.6, 0, 1959.8, 22291.87, 63902.4, 86194.27, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72151, N'Jack O''Sullivan', N'Public Service Trainee', 999.36, 0, 2.05, 78.01, 1001.41, 1079.42, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (113634, N'Mark F Obrochta', N'Sergeant 3', 137982.17, 9196.03, 5670.36, 43038.5, 152848.56, 195887.06, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (46516, N'Petra Hahn', N'Deputy Sheriff', 78353.8, 22953.71, 1062.13, 32704.29, 102369.64, 135073.93, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (121337, N'Yvette R Gay', N'Deputy Sheriff', 91439.78, 1048.86, 8289.84, 34442.81, 100778.48, 135221.29, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144559, N'Jarrett L Louie', N'Transit Operator', 4390.16, 1307.11, 9.08, 2848.36, 5706.35, 8554.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64262, N'Emily Anderson', N'EMT/Paramedic/Firefighter', 29175.65, 2139.69, 2169.08, 11825.59, 33484.42, 45310.01, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147049, N'Darryl L Armstrong', N'Transit Operator', 1934.15, 0, 0, 566.71, 1934.15, 2500.86, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109290, N'Claire M Leflore', N'Eligibility Worker', 1994, 0, 0, 19.94, 1994, 2013.94, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102042, N'Mary R Carr', N'Eligibility Worker', 24628.57, 2161.28, 191.17, 10922.03, 26981.02, 37903.05, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71488, N'Maiza Padilla', N'Public Svc Aide-Public Works', 1871.39, 0, 0, 499.62, 1871.39, 2371.01, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72135, N'Joannie Keys', N'Transit Operator', 595.12, 0, 0, 532.1, 595.12, 1127.22, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109293, N'Orlando M Gonzalez', N'Public Svc Aide-Public Works', 1987.09, 0, 0, 19.87, 1987.09, 2006.96, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (100543, N'Kenia C Coronado', N'Eligibility Worker', 37992.28, 909, 765, 15763.21, 39666.28, 55429.49, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (145535, N'Wing C Kwan', N'Transit Operator', 3421.96, 0, 0, 2195.47, 3421.96, 5617.43, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (97613, N'Natalia Y Castillo Villegas', N'Junior Administrative Analyst', 56813.75, 0, 0, 23206.44, 56813.75, 80020.19, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48079, N'Ceasar Garcia', N'Deputy Sheriff', 87677.95, 1035.25, 3699.04, 34871.11, 92412.24, 127283.35, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148357, N'Darrel A Lachapelle', N'Public Service Trainee', 320, 0, 0, 3.2, 320, 323.2, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71849, N'Shickola Ricks', N'Eligibility Worker', 1508.8, 0, 0, 125.89, 1508.8, 1634.69, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (65793, N'Linda Edwards', N'Transit Operator', 16724.27, 1738.13, 243.39, 9592.84, 18705.79, 28298.63, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72341, N'Reuben Reyes', N'Special Nurse', 531.94, 0, 36.64, 157.95, 568.58, 726.53, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (65175, N'Barry Hyun', N'Eligibility Worker', 22931.02, 0, 0, 12170.84, 22931.02, 35101.86, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (145323, N'Heather E Gutierres', N'Eligibility Worker', 6276.49, 0, 0, 62.78, 6276.49, 6339.27, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106404, N'Carolyn E Robinson', N'Transit Operator', 5904, 0, 0, 2771.21, 5904, 8675.21, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64637, N'Matthew Lu', N'Transit Operator', 25938.35, 435.95, 443.99, 14046.65, 26818.29, 40864.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144555, N'Lawrence C Blakes Jr', N'Transit Operator', 4390.16, 1314.78, 9.08, 2848.42, 5714.02, 8562.44, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140998, N'Miguel J Gonzalez Jr', N'Transit Operator', 17505.51, 0, 57.7, 8358.89, 17563.21, 25922.1, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142304, N'Tara A Amado', N'Transit Operator', 11672.8, 0, 46.16, 5552.79, 11718.96, 17271.75, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110444, N'Brighton M Leung', N'Public Svc Aide-Public Works', 104.9, 0, 2.46, 1.07, 107.36, 108.43, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (138094, N'Nicole J Lafata Shark', N'EMT/Paramedic/Firefighter', 40315.5, 0, 2418.93, 13642.43, 42734.43, 56376.86, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142597, N'Ernest E Hayles', N'Firefighter', 11180, 0, 0, 4572.32, 11180, 15752.32, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109955, N'David A Fleming', N'Special Nurse', 618.19, 0, 24.72, 134.27, 642.91, 777.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109056, N'Melinda  Kuoch', N'Eligibility Worker', 1994, 0, 0, 445.06, 1994, 2439.06, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102861, N'Jeanne M D''Arcy', N'Registered Nurse', 5119, 0, 22525.52, 1568.43, 27644.52, 29212.95, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109510, N'Iesha M Jones', N'Public Svc Aide-Public Works', 1542.97, 0, 0, 15.43, 1542.97, 1558.4, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71485, N'Clarence Walker', N'Public Svc Aide-Public Works', 2129.95, 0, 43.92, 201.85, 2173.87, 2375.72, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105484, N'Michaela T Womack', N'Transit Operator', 7239.23, 177.59, 32.02, 4494.45, 7448.84, 11943.29, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135721, N'Mary C Huston', N'Registered Nurse', 58997.59, 50.29, 1868.27, 16918.73, 60916.15, 77834.88, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (138726, N'Christina A Couch', N'EMT/Paramedic/Firefighter', 30732, 1446.58, 2370.77, 13848.34, 34549.35, 48397.69, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71342, N'Roy Hill', N'Public Svc Aide-Public Works', 2461.14, 0, 9.01, 213.86, 2470.15, 2684.01, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147588, N'Jessica H Lee', N'Special Nurse', 1278.2, 0, 0, 238.96, 1278.2, 1517.16, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (70927, N'Kennis Grant', N'Transit Operator', 0, 0, 106.86, 3511.8, 106.86, 3618.66, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69443, N'John Hunt', N'Transit Operator', 6150.2, 1171.18, 537.12, 634.77, 7858.5, 8493.27, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (49188, N'Richard Kendall', N'Deputy Sheriff', 77550.95, 470.78, 10965.66, 33357.41, 88987.39, 122344.8, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72441, N'Marcus Duty', N'Public Svc Aide-Public Works', 519.5, 0, 12.2, 46.49, 531.7, 578.19, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72129, N'Glenn Daniels', N'Public Svc Aide-Public Works', 1026.05, 0, 0, 112.75, 1026.05, 1138.8, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71886, N'David Ayers Jr', N'Public Svc Aide-Public Works', 1428.63, 0, 0, 131.48, 1428.63, 1560.11, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (138822, N'Neal K Rodil', N'EMT/Paramedic/Firefighter', 30732, 1351.53, 1480.38, 13838.47, 33563.91, 47402.38, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110421, N'Blesilda P Huypungco', N'Special Nurse', NULL, 0, 113.94, 24, 113.94, 137.94, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72498, N'Catheryn Williams', N'Special Nurse', 338.51, 0, 33.84, 102.19, 372.35, 474.54, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (139203, N'Merter Bozkurt', N'Transit Operator', 24987.15, 1725.24, 885.43, 15697.82, 27597.82, 43295.64, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72603, N'Connie Love-Miles', N'Special Nurse', 143.65, 0, 14.37, 174.21, 158.02, 332.23, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (84282, N'Jared F Cooper', N'EMT/Paramedic/Firefighter', 87205.86, 2826.74, 10520.93, 31800.92, 100553.53, 132354.45, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71389, N'Alicia Brown', N'Public Svc Aide-Public Works', 2337.75, 0, 48.8, 210.77, 2386.55, 2597.32, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109715, N'Sen Cheong  Lai', N'Transit Operator', 729.44, 0, 30.32, 405.15, 759.76, 1164.91, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110275, N'Graciela M Arevalo', N'Special Nurse', 263.29, 0, 26.33, 60.77, 289.62, 350.39, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147814, N'Iris J Lett', N'Transit Operator', 756.92, 170.31, 0, 223.48, 927.23, 1150.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142199, N'Tim C Ghigliazza', N'Transit Operator', 10305.1, 694.2, 121.82, 6700.23, 11121.12, 17821.35, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148472, N'Jimmy Tang', N'Public Service Trainee', 182.58, 0, 0, 1.83, 182.58, 184.41, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48811, N'Aaron Schmidt', N'Deputy Sheriff', 76558.8, 13435.42, 1909.7, 32108.71, 91903.92, 124012.63, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147204, N'Mario Armbrister', N'Public Svc Aide-Public Works', 2180.13, 0, 47.64, 22.29, 2227.77, 2250.06, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109353, N'Elizabeth M Leahy', N'Firefighter', NULL, 0, 1886.38, 0, 1886.38, 1886.38, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110036, N'Carla R Greenblatt', N'Special Nurse', 494.55, 0, 49.45, 108.2, 544, 652.2, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140786, N'Dhakir R Zaki', N'Transit Operator', 13976.1, 4093.11, 326.18, 9176.93, 18395.39, 27572.32, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147840, N'Alondra Correa Almanza', N'Public Service Trainee', 1074, 0, 32.64, 11.06, 1106.64, 1117.7, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48199, N'Otha Cotton', N'Deputy Sheriff', 87947.57, 501, 4056.2, 34352.07, 92504.77, 126856.84, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39202, N'Lawrence Chan', N'Sergeant 3', 135977.76, 7718.7, 7733.28, 38259.83, 151429.74, 189689.57, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (63024, N'Ying Ying Hui', N'Registered Nurse', 39599.08, 1085.78, 1997.48, 17396.06, 42682.34, 60078.4, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105463, N'Terri L Mathis', N'Transit Operator', 7611.73, 772.69, 60.12, 3579.36, 8444.54, 12023.9, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (139849, N'Sedrick M Mcarthur', N'Transit Operator', 18880.5, 7842.37, 250.28, 9910.61, 26973.15, 36883.76, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (136970, N'Karen M Gomez', N'Registered Nurse', 49186.88, 125.89, 575, 18126.1, 49887.77, 68013.87, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48564, N'Thomas Ro', N'EMT/Paramedic/Firefighter', 74118.62, 15060.35, 7864.68, 28169.55, 97043.65, 125213.2, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (97623, N'Francis J Monsada', N'Junior Administrative Analyst', 53325.01, 1147.97, 0, 25475.22, 54472.98, 79948.2, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69338, N'Samer Bouri', N'Transit Operator', 5997.16, 0, 0, 2797.37, 5997.16, 8794.53, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (87033, N'Robert J Loberg', N'Deputy Sheriff', 83331.6, 4224.52, 1119.79, 30403.68, 88675.91, 119079.59, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72081, N'John Donnelly', N'Special Nurse', 930.75, 0, 31.02, 270.55, 961.77, 1232.32, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110299, N'Silas D Moultrie Jr', N'Public Svc Aide-Public Works', 311.7, 0, 7.32, 3.19, 319.02, 322.21, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (130622, N'Dennis J Gerbino', N'IS Programmer Analyst', 67667.55, 0, 0, 29304.77, 67667.55, 96972.32, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (54798, N'Frankie Johnson', N'Senior Eligibility Worker', 68977.7, 0, 612.6, 31204.72, 69590.3, 100795.02, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69063, N'Nina Davis', N'PS Aide Health Services', 8928.12, 0, 0, 766.22, 8928.12, 9694.34, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (70438, N'Pecola Jones', N'Public Svc Aide-Public Works', 4511.81, 0, 0, 460.53, 4511.81, 4972.34, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (88467, N'Grace  Lin', N'Estate Investigator', 82901.08, 0, 0, 30165.72, 82901.08, 113066.8, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (56140, N'Clark Bell', N'IS Programmer Analyst-Senior', 48945.1, 0, 23100.3, 23354.1, 72045.4, 95399.5, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (714, N'YEVA JOHNSON', N'SENIOR PHYSICIAN SPECIALIST', 177810.58, 0, 950, NULL, 178760.58, 178760.58, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (29865, N'LEA YAMAGATA', N'LIBRARY PAGE', 16863.33, 0, 201.09, NULL, 17064.42, 17064.42, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147636, N'Russell Patrick Mangahas', N'Special Nurse', 0, 0, 1153.78, 277.75, 1153.78, 1431.53, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110161, N'Patrick F Mcpartland', N'Public Service Trainee', 501.13, 0, 0, 5.01, 501.13, 506.14, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (47639, N'Patrick Crane', N'Deputy Sheriff', 84356.51, 5334.96, 5764.75, 34143.72, 95456.22, 129599.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (51908, N'Patrick Martinez', N'Estate Investigator', 77454, 0, 0, 33194.97, 77454, 110648.97, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (85769, N'Patrick T Truong', N'Deputy Sheriff', 86758.9, 877.32, 6484.64, 31360.09, 94120.86, 125480.95, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (115360, N'Patrick Kennedy', N'Sergeant 3', 124770.11, 4709.34, 8031.28, 40093.21, 137510.73, 177603.94, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109179, N'Emilia C Patrick', N'Special Nurse', 1824.38, 0, 0, 373.71, 1824.38, 2198.09, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (125793, N'Patrick S Renshaw', N'EMT/Paramedic/Firefighter', 72637.09, 6033.4, 5105.38, 30691.14, 83775.87, 114467.01, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (133413, N'Emilia C Patrick', N'Registered Nurse', 65992.6, 0, 296.7, 21067.97, 66289.3, 87357.27, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (121116, N'Patrick T Truong', N'Deputy Sheriff', 90269, 4330.78, 7372.09, 34506.78, 101971.87, 136478.65, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (84, N'EDWARD REISKIN', N'GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY', 230827.12, 0, 0, NULL, 230827.12, 230827.12, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (1, N'NATHANIEL FORD', N'GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY', 167411.18, 0, 400184.25, NULL, 567595.43, 567595.43, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (12, N'PATRICIA JACKSON', N'CAPTAIN III (POLICE DEPARTMENT)', 99722, 87082.62, 110804.3, NULL, 297608.92, 297608.92, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (371, N'TERESA BARRETT', N'CAPTAIN III (POLICE DEPARTMENT)', 188328.08, 0, 4586.42, NULL, 192914.5, 192914.5, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (62, N'ANNA BROWN', N'CAPTAIN III (POLICE DEPARTMENT)', 102571.24, 7437, 128543.64, NULL, 238551.88, 238551.88, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (304, N'DOUGLAS MCEACHERN', N'CAPTAIN III (POLICE DEPARTMENT)', 194566.01, 1109.1, 819.03, NULL, 196494.14, 196494.14, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (367, N'JOHN LOFTUS', N'CAPTAIN III (POLICE DEPARTMENT)', 188341.62, 0, 4609.75, NULL, 192951.37, 192951.37, 2011, NULL, N'San Francisco', N'')
GO



Comments (0)
Questions List