Name: Employee_Salaries
Display Field:
Type: Table
Description: <div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">The Employee Salary dataset contains payroll and position data, including: position description, department, FLSA status, pay range, pay grade and step (if applicable), bargaining unit, and base salary information. Each row contains relevant data for a single employee or vacant position. A data dictionary with descriptions of the fields included in the dataset can be <a href="https://webappsprod.bouldercolorado.gov/opendata/employee_salaries_data_dictionary.csv" style="color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;" target="_blank">downloaded here</a>. The core dataset is updated semi-annually and supporting files on an as-needed basis.<br /></div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><br /></div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">Additional supporting files include: </div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><br /></div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">Salary bands for each pay grade and step (if applicable) for the four labor groups:</div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><ul><li><a href="https://webappsprod.bouldercolorado.gov/opendata/salary_schedule_bmea.csv" style="color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;" target="_blank">Boulder Municipal Employee’s Association – BMEA</a> </li><li><a href="https://webappsprod.bouldercolorado.gov/opendata/salary_schedule_iaff.csv" style="color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;" target="_blank">International Association of Fire Fighters – IAFF</a></li><li><a href="https://webappsprod.bouldercolorado.gov/opendata/salary_schedule_bpoa.csv" style="color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;" target="_blank">Boulder Police Officer’s Association – BPOA</a></li><li><a href="https://webappsprod.bouldercolorado.gov/opendata/salary_schedule_mgmt.csv" style="color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;" target="_blank">Management / Non-Union – MGMT</a></li></ul></div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">List of currently used <a href="https://webappsprod.bouldercolorado.gov/opendata/job_classes_by_grade.csv" style="color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;" target="_blank">job classes by labor group and grade</a></div>
Copyright Text:
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: ObjectId
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- Position_Description (type: esriFieldTypeString, alias: Position Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Employee_FLSA_Exempt_Y_N (type: esriFieldTypeString, alias: Employee FLSA Exempt Y/N, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Position_FTE (type: esriFieldTypeDouble, alias: Position FTE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Employee_Annual_Salary (type: esriFieldTypeString, alias: Employee Annual Salary, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Employee_Hourly_Pay_Rate (type: esriFieldTypeString, alias: Employee Hourly Pay Rate, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Bargaining_Unit (type: esriFieldTypeString, alias: Bargaining Unit, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Salary_Grade (type: esriFieldTypeString, alias: Salary Grade, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
- Salary_Step (type: esriFieldTypeInteger, alias: Salary Step, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/19/2022 10:38:01 PM
Schema Last Edit Date: 5/19/2022 10:38:01 PM
Data Last Edit Date: 5/19/2022 10:38:01 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat