This dataset has the following 52 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
AccountDescription | accountdescription | text | Medicare Tax Health Insurance W/H Life Insurance W/H Teachers Positional Stipend view top 100 |
AccountStatus | accountstatus | text | Active Inactive view top 100 |
AccountType | accounttype | text | Expense UNKNOWN view top 100 |
BasePay | basepay | number | 0.00 3784.64 4043.42 3655.61 3976.14 view top 100 |
BenefitsAmount | benefitsamount | number | 0.00 3.92 865.20 832.00 895.60 view top 100 |
CharacterCode | charactercode | text | 51 52 00 57 53 view top 100 |
CharacterCodeDescription | charactercodedescription | text | Personal Services UNKNOWN Overtime Undefined Other Expense view top 100 |
CheckNumber | checknumber | number | 0 8267 129090 142688 141705 view top 100 |
Department | department | text | HIGH SCHOOL POLICE DEPARTMENT FIRE DEPARTMENT MIDDLE SCHOOL EARLY CHILDHOOD EDUCATION CENT view top 100 |
DepartmentGroup | departmentgroup | text | view top 100 |
EmployeeId | employeeid | text | 7815 7464 7368 492 7430 view top 100 |
Entity | entity | text | City view top 100 |
FirstName | firstname | text | MICHAEL JOHN JAMES JOSEPH JENNIFER view top 100 |
FiscalPeriod | fiscalperiod | number | 6 1 10 8 7 view top 100 |
FiscalYear | fiscalyear | number | 2023 2022 2021 2024 view top 100 |
FullAccount | fullaccount | text | 1000-900-910-000-000-0000-00-5700-517020- 1000-000-000-000-000-0000-00-0000-215020- 1000-000-000-000-000-0000-00-0000-215040- 1000-200-220-000-000-0000-00-5100-519000- 1000-900-910-000-000-0000-00-5700-517060- view top 100 |
FunctionDescription | functiondescription | text | view top 100 |
FunctionGroup | functiongroup | text | Town-wide Education Public Safety Public Works & Facilities Culture & Recreation view top 100 |
Fund | fund | text | General Fund Police Details School Lunch Revolving Early Childhood Tuition Revolv ESSER III GRANT view top 100 |
FundCode | fundcode | text | 1000 9200 1501 1506 2223 view top 100 |
FundGroup | fundgroup | text | view top 100 |
LastName | lastname | text | SULLIVAN MCCARTHY BAKER JENKINS FEELEY view top 100 |
NameSuffix | namesuffix | text | JR III JR. IV 570 view top 100 |
Object | object | text | Medicare Tax Health Insurance W/H Life Insurance W/H Teachers Positional Stipend view top 100 |
ObjectCode | objectcode | text | 517020 215020 215040 511317 519000 view top 100 |
Organization | organization | text | EmpBen Exp General Bal Sheet Police Wages Fire Wages DPW Wages view top 100 |
OrganizationCode | organizationcode | text | 19105700 1000 12105100 12205100 14205100 view top 100 |
OtherPay | otherpay | number | 0.00 71.15 75.00 78.85 153.85 view top 100 |
OvertimePay | overtimepay | number | 0.00 368.00 44.00 484.80 82.48 view top 100 |
Position | position | text | POLICE OFFICER FIREFIGHTER TEACHER DMS TEACHER DHS 6.0 NON CERTIFIED PARA view top 100 |
PositionType | positiontype | text | FULL TIME PERMANENT BENEFITS ONLY PART TIME PERM NO BENEFITS SEASONAL - TOWN PART TIME PERMANENT BENEFITS view top 100 |
Project | project | text | UNKNOWN FY 22 FY 21 FY 23 FY20 view top 100 |
ProjectCode | projectcode | text | 2022 2021 2023 2020 2024 view top 100 |
Segment2 | segment2 | text | Unclassified Undefined Schools Public Safety Public Works & Facilities view top 100 |
Segment2Code | segment2code | text | 900 000 300 200 400 view top 100 |
Segment3 | segment3 | text | Employee Benefits Undefined Schools Police Fire view top 100 |
Segment3Code | segment3code | text | 910 000 300 210 220 view top 100 |
Segment4 | segment4 | text | Undefined Systemwide High School Middle School ECEC view top 100 |
Segment4Code | segment4code | text | 000 315 304 305 310 view top 100 |
Segment5 | segment5 | text | Undefined Special Education Principal Office Operations Administration view top 100 |
Segment5Code | segment5code | text | 000 355 120 470 572 view top 100 |
Segment6 | segment6 | text | Undefined Classroom Teachers Non-Clerical PP/TA Custodial Services Curriculum Directors view top 100 |
Segment6Code | segment6code | text | 0000 2305 2330 4110 2110 view top 100 |
Segment7 | segment7 | text | Undefined Salaries Professional Salaries Other Salaries Secretarial/Clerical Contract Services view top 100 |
Segment7Code | segment7code | text | 00 01 03 02 04 view top 100 |
Segment8 | segment8 | text | Salary & Wages Expenditures Undefined view top 100 |
Segment8Code | segment8code | text | 5100 5700 0000 view top 100 |
ServiceEndDate | serviceenddate | calendar_date | 2021-08-31T00:00:00.000 2023-06-22T00:00:00.000 2024-01-23T00:00:00.000 2023-08-31T00:00:00.000 2017-06-23T00:00:00.000 view top 100 |
ServiceStartDate | servicestartdate | calendar_date | 2019-09-03T00:00:00.000 2022-09-01T00:00:00.000 2018-09-04T00:00:00.000 2014-09-01T00:00:00.000 2004-09-01T00:00:00.000 view top 100 |
TotalPay | totalpay | number | 3.92 71.15 865.20 832.00 895.60 view top 100 |
TransactionDate | transactiondate | calendar_date | 2021-07-02T00:00:00.000 2022-07-01T00:00:00.000 2020-07-03T00:00:00.000 2023-12-01T00:00:00.000 2023-04-21T00:00:00.000 view top 100 |
UniqueId | uniqueid | text | 10544-7867-T991-97-BE-2021-Jul 3 2020 12:00AM-170.00-0.00-0.00-0.00-1-7204-84563 10544-7867-T991-97-BE-2021-Nov 20 2020 12:00AM-0.00-0.00-0.00-2.47-1-5918-92974 10544-7867-T991-97-BE-2021-Nov 20 2020 12:00AM-170.00-0.00-0.00-0.00-1-7204-92974 10544-7867-T991-97-BE-2021-Nov 27 2020 12:00AM-0.00-0.00-0.00-0.00-1-7204-93861 10544-7867-T991-97-BE-2021-Nov 27 2020 12:00AM-0.00-0.00-8.50-0.00-1-855-93861 view top 100 |