Payroll Earnings

data.framinghamma.gov | Last Updated 17 Jan 2020

Annual employee position earnings from 2013 through 2019. Column TOTAL EARNINGS contains the annual total earnings. The other columns contain the detail earnings by payment type.

Tags: payroll, checks, salary, earnings

This dataset has the following 245 columns:

Column NameAPI Column NameData TypeSample Values
YEARyearnumber
FIRST_NAMEfirst_nametext
LAST_NAMElast_nametext
MIDDLE_INITIALmiddle_initialtext
JOB_CLASS_CODEjob_class_codenumber
JOB_CLASS_DESCjob_class_desctext
FULL_PART_TIMEfull_part_timetext
LOCATION_DEPARTMENTlocation_departmenttext
BARGAIN_UNIT_CODEbargain_unit_codetext
BARGAIN_UNIT_DESCbargain_unit_desctext
TOTAL EARNINGStotal_earningsnumber
DRIVER ADDITIONAL HRS NRdriver_additional_hrs_nrnumber
10 MO SECR VAC PAY RET YES_10_mo_secr_vac_pay_ret_yesnumber
1116 IN LIEU OF OT RN_1116_in_lieu_of_ot_rnnumber
1156WORKING SUPER RY_1156working_super_rynumber
24 HR AVAILABILITY_24_hr_availabilitynumber
ACTING OFFICERacting_officernumber
ADDITIONAL DAYS RET NOadditional_days_ret_nonumber
ADDITIONAL DAYS RET YESadditional_days_ret_yesnumber
ADDITIONAL HOURS RETIREMENT ELadditional_hours_retirement_elnumber
ADDITIONAL HOURS RNadditional_hours_rnnumber
ADJUSTMENT EXEMPT FROM MEDICARadjustment_exempt_from_medicarnumber
ADJUSTMENT REIREMENT YESadjustment_reirement_yesnumber
ATHLETICS CONTIN RET NOathletics_contin_ret_nonumber
ATHLETICS CONTIN RET YESathletics_contin_ret_yesnumber
BAR SUB OTHERbar_sub_othernumber
BAR SUB PERSONALbar_sub_personalnumber
BAR SUB PROF DEVbar_sub_prof_devnumber
BAR SUB SICKbar_sub_sicknumber
BENEFIT REIMBURSEMENTbenefit_reimbursementnumber
BLOCKS SUB OTHERblocks_sub_othernumber
BLOCKS SUB PERSONALblocks_sub_personalnumber
BLOCKS SUB SICKblocks_sub_sicknumber
BRO SUB OTHERbro_sub_othernumber
BRO SUB PERSbro_sub_persnumber
BRO SUB PROFbro_sub_profnumber
BRO SUB SICKbro_sub_sicknumber
BUS DRIVER VAC RET YESbus_driver_vac_ret_yesnumber
CAM SUB OTHERcam_sub_othernumber
CAM SUB PERScam_sub_persnumber
CAM SUB PROFcam_sub_profnumber
CAM SUB SICKcam_sub_sicknumber
CAR ALLOWANCE STIPENDcar_allowance_stipendnumber
CIVIC USE SUB PROFcivic_use_sub_profnumber
CLOALLOWBUILDINGS&GROUNDScloallowbuildings_groundsnumber
CLOTHING ALLOWANCE FOOD SERVclothing_allowance_food_servnumber
COACH SECONDARY RET NOcoach_secondary_ret_nonumber
COACH SECONDARY RET YEScoach_secondary_ret_yesnumber
COMP CASH INcomp_cash_innumber
CONTRACTED SERVICES RET NOcontracted_services_ret_nonumber
CONTRACTED SERVICES RET YEScontracted_services_ret_yesnumber
COURT TIMEcourt_timenumber
COURT TIME FLSAcourt_time_flsanumber
CUST OVERTIME 1x5cust_overtime_1x5number
CUST VACATION NO RETcust_vacation_no_retnumber
CUSTODIAN COVERAGEcustodian_coveragenumber
CUSTODIAN SICK INCENTIVEcustodian_sick_incentivenumber
DEPARTMENT HEAD ELEMdepartment_head_elemnumber
DEPARTMENT HEAD MIDDLE SCHOOLdepartment_head_middle_schoolnumber
DEPT HEADdept_headnumber
DOUBLETIMEdoubletimenumber
DPW 3RD SHIFT DIFFERENTIALdpw_3rd_shift_differentialnumber
DPW EDUCATIONAL 1116dpw_educational_1116number
DPW EDUCATIONAL 1156dpw_educational_1156number
DPW ENGINEERING EDUCATIONALdpw_engineering_educationalnumber
DPW MEALSdpw_mealsnumber
DPW NIGHT DIFFERENTIALdpw_night_differentialnumber
DPW SAT/SUN 1 DAY DIFFERENTIALdpw_sat_sun_1_day_differentialnumber
DPW SICK LEAVE INCENTIVEdpw_sick_leave_incentivenumber
DPW STIPEND PAY RETIRE/OTdpw_stipend_pay_retire_otnumber
DRIVER OT 1x5 OVER 40 HOURSdriver_ot_1x5_over_40_hoursnumber
DRUG ENFORCEMENTdrug_enforcementnumber
DUN SUBS OTHERdun_subs_othernumber
DUN SUBS PERSdun_subs_persnumber
DUN SUBS PROFdun_subs_profnumber
DUN SUBS SICKdun_subs_sicknumber
EDUCATIONeducationnumber
EDUCATION FOR SUPERIOR OFFeducation_for_superior_offnumber
EDUCATION INCREMENT SCHBeducation_increment_schbnumber
EMERGENCY RESPONSE STIPENDemergency_response_stipendnumber
FF CLOTHING NRff_clothing_nrnumber
FF EDUCATIONff_educationnumber
FF HOLIDAYSff_holidaysnumber
FF SHIFT DIFFff_shift_diffnumber
FF SICK TIME INCENTIVEff_sick_time_incentivenumber
FF UNUSED VACATION RETIRE ELIGff_unused_vacation_retire_elignumber
FF WEEKEND GROUP 1ff_weekend_group_1number
FF WEEKEND GROUP 2ff_weekend_group_2number
FF WEEKEND GROUP 3ff_weekend_group_3number
FF WEEKEND GROUP 4ff_weekend_group_4number
FF-DEFRIBULATOR STIPENDff_defribulator_stipendnumber
FF-EMT CERTIFICATEff_emt_certificatenumber
FF-EMTI CERTIFICATEff_emti_certificatenumber
FF-HAZARDOUS DUTY 5%ff_hazardous_duty_5number
FHS SUB OTHERfhs_sub_othernumber
FHS SUB PERSRfhs_sub_persrnumber
FHS SUB PROJfhs_sub_projnumber
FHS SUB SICKfhs_sub_sicknumber
FIRD DEPT HAZ TRAINING 2%fird_dept_haz_training_2number
FIRE DETAIL OUTSIDEfire_detail_outsidenumber
FIRE HOLIDAY DETAILfire_holiday_detailnumber
FIRE SUNDAY DETAILfire_sunday_detailnumber
FOOD SERVICE SUMMERfood_service_summernumber
FOOD SERVICE VAC PAYOUT RYfood_service_vac_payout_rynumber
FUL SUBS OTHERful_subs_othernumber
FUL SUBS PERful_subs_pernumber
FUL SUBS PROFful_subs_profnumber
FUL SUBS SICKful_subs_sicknumber
HAZMAT DRILLShazmat_drillsnumber
HEAD TEACHERhead_teachernumber
HEM SUB OTHERhem_sub_othernumber
HEM SUB PERShem_sub_persnumber
HEM SUB PROFhem_sub_profnumber
HEM SUB SICKhem_sub_sicknumber
HOURLYhourlynumber
HUMAN RESOURCES SUB SYSTEMhuman_resources_sub_systemnumber
INTRAMUR SECONDARY RET YESintramur_secondary_ret_yesnumber
K9 HANDLER OTk9_handler_otnumber
KING SICKking_sicknumber
KING SUBS OTHERking_subs_othernumber
LIB EDUCATIONALlib_educationalnumber
LIBRARY 2ND JOB NO RETIREMENTlibrary_2nd_job_no_retirementnumber
LIBRARY ADDNL NO RETIREMENTlibrary_addnl_no_retirementnumber
LIBRARY SHIFTlibrary_shiftnumber
LIBRARY SHIFT SATlibrary_shift_satnumber
LIBRARY SHIFT SUNlibrary_shift_sunnumber
LICENSE & CERTIFICATION PAYlicense_certification_paynumber
LONGEVITY 1116 SUPERVISORSlongevity_1116_supervisorsnumber
LONGEVITY 1156 DPW &PARKlongevity_1156_dpw_parknumber
LONGEVITY RET NOlongevity_ret_nonumber
LONGEVITY RET YESlongevity_ret_yesnumber
LONGEVITY SCHBlongevity_schbnumber
LONGEVITY TOWN EMPLOYEESlongevity_town_employeesnumber
MCC SUB OTHERmcc_sub_othernumber
MCC SUB PERSmcc_sub_persnumber
MCC SUB PROFmcc_sub_profnumber
MCC SUB SICKmcc_sub_sicknumber
MERIT PAYmerit_paynumber
METER OVERTIMEmeter_overtimenumber
NONCASH INCOMEnoncash_incomenumber
ON CALL PAYon_call_paynumber
ORDERLY RETIREMENTorderly_retirementnumber
OVERTIMEovertimenumber
PAID PERMIT CUST OTpaid_permit_cust_otnumber
PARK AND REC CUST OTpark_and_rec_cust_otnumber
PD DEFRIBULATORpd_defribulatornumber
PD DETAILpd_detailnumber
PD DETAIL HOLIDAYpd_detail_holidaynumber
PD DETAIL HOLIDAY OVER 8 HRSpd_detail_holiday_over_8_hrsnumber
PD DETAIL OVER 8 HOURSpd_detail_over_8_hoursnumber
PD DETAIL SCHOOLSpd_detail_schoolsnumber
PD HOUSING DETAILpd_housing_detailnumber
PD OFFICER HAZARDOUS DUTYpd_officer_hazardous_dutynumber
PD OFFICER PHOTOpd_officer_photonumber
PD OFFICER SPECIALISTpd_officer_specialistnumber
PD OFFICERS ACCREDITATIONpd_officers_accreditationnumber
PD OFFICERS LONGEVITYpd_officers_longevitynumber
PD UNUSED VACATION RETIRE ELGIpd_unused_vacation_retire_elginumber
PD WEEKEND PREMIUM $17pd_weekend_premium_17number
POLICE HOLIDAY PAYpolice_holiday_paynumber
PUB SAFETY HOURLYpub_safety_hourlynumber
POLICE PATROL SHIFT DIFFpolice_patrol_shift_diffnumber
POLL POLICE DETAILpoll_police_detailnumber
POLL SET UPpoll_set_upnumber
POTTER SUB OTHERpotter_sub_othernumber
POTTER SUB PERSpotter_sub_persnumber
POTTER SUB PROFpotter_sub_profnumber
POTTER SUB SICKpotter_sub_sicknumber
PUBLIC SAFETY RYpublic_safety_rynumber
RETRO DOUBLE TIMEretro_double_timenumber
RETRO OTretro_otnumber
RETRO PAYretro_paynumber
SALARYsalarynumber
SALARY - DAILYsalary_dailynumber
SALARY 10 MONTHsalary_10_monthnumber
SCHA SUPER MAXscha_super_maxnumber
SECRETARY SUPERMAXsecretary_supermaxnumber
SEVERANCE NO RETIREMENTseverance_no_retirementnumber
SHIFT DIFFERENTIAL BD SERVCSshift_differential_bd_servcsnumber
SICK LEAVE BUY BACKsick_leave_buy_backnumber
SINGLE TOUR CROSSING GUARDSsingle_tour_crossing_guardsnumber
SNOW & ICE DOUBLE TIMEsnow_ice_double_timenumber
SNOW & ICE REIMBURSABLE MEALSsnow_ice_reimbursable_mealsnumber
SNOW & ICE TIME & 1/2snow_ice_time_1_2number
SPED SUMMER PERSONELsped_summer_personelnumber
STA SUBS OTHERsta_subs_othernumber
STA SUBS PERSsta_subs_persnumber
STA SUBS PROFsta_subs_profnumber
STA SUBS SICKsta_subs_sicknumber
STIPEND NRstipend_nrnumber
STIPEND RETIR YESstipend_retir_yesnumber
STIPEND RETIREMENT NOstipend_retirement_nonumber
STIPEND RETIREMENT YESstipend_retirement_yesnumber
STIPEND SECONDARY RET NOstipend_secondary_ret_nonumber
STIPEND TOWN CLERKstipend_town_clerknumber
STORM WATCH STIPENEDstorm_watch_stipenednumber
STRAIGHT TIMEstraight_timenumber
STUDENT ACT SECONDARY RET NOstudent_act_secondary_ret_nonumber
STUDENT ACT SECONDARY RET YESstudent_act_secondary_ret_yesnumber
SUB NURSE GRTsub_nurse_grtnumber
SUBSTITUTEsubstitutenumber
SUBSTITUTE NURSESsubstitute_nursesnumber
SUMMER PROG RET Nsummer_prog_ret_nnumber
SUMMER PROGRAMS RET NOsummer_programs_ret_nonumber
SUMMER PROGRAMS RET Ysummer_programs_ret_ynumber
SUP DE HOLIDAY OVER8 VENDORsup_de_holiday_over8_vendornumber
SUP DE HOLIDAY VENDORsup_de_holiday_vendornumber
SUP DE VENDOR OVER 8 HRSsup_de_vendor_over_8_hrsnumber
SUP PD DETAIL HOLIDAYsup_pd_detail_holidaynumber
SUP PD DETAIL OVER 8 HOURSsup_pd_detail_over_8_hoursnumber
SUP PD DETAIL SCHOOLSsup_pd_detail_schoolsnumber
SUPERIOR DETAIL VENDOR ONLYsuperior_detail_vendor_onlynumber
SUPERIORS PD DETAILsuperiors_pd_detailnumber
SWEEPING OVERTIME 1x5sweeping_overtime_1x5number
TEAM LEADERteam_leadernumber
TITLE 1 SUPERMAXtitle_1_supermaxnumber
TOOL REIMBURSEMENTStool_reimbursementsnumber
TOWN DETAIL FLSAtown_detail_flsanumber
TOWN DETAIL NOT FLSAtown_detail_not_flsanumber
TOWNDETAILDOUBLE TIMEtowndetaildouble_timenumber
TRAINING PAY NONBARGAININGtraining_pay_nonbargainingnumber
TRANSLATIONS RET YEStranslations_ret_yesnumber
TRANSLATIONS RETIREMENT NOtranslations_retirement_nonumber
TUITION/RECERT/SUPPLY REIMBtuition_recert_supply_reimbnumber
TUTOR RET NOtutor_ret_nonumber
TUTOR RET YEStutor_ret_yesnumber
TWNDTL FLSA OVER 8 HRStwndtl_flsa_over_8_hrsnumber
UNPAID CIVIC USE OT CUSTunpaid_civic_use_ot_custnumber
VACATION - HOURLYvacation_hourlynumber
VACATION PAYOUTvacation_payoutnumber
VACATION PAYOUT-NO RETIREvacation_payout_no_retirenumber
WAL SUB OTHERwal_sub_othernumber
WAL SUB PERSwal_sub_persnumber
WAL SUB PROFwal_sub_profnumber
WAL SUB SICKwal_sub_sicknumber
WILSON SUB OTHERwilson_sub_othernumber
WILSON SUB PERSwilson_sub_persnumber
WILSON SUB PROFwilson_sub_profnumber
WILSON SUB SICKwilson_sub_sicknumber
WORKSHOP RET YESworkshop_ret_yesnumber
WORKSHOP SECONDARY RET NOworkshop_secondary_ret_nonumber
YARD WASTE - DROP OFFyard_waste_drop_offnumber
YARD WASTE - YARDyard_waste_yardnumber
YARD WASTE-HOLIDAYyard_waste_holidaynumber
OTHER EARNINGSother_earningsnumber