Layers:

Tables:

Employee_Salaries (0)


Name: Employee_Salaries

Display Field:

Type: Table

Description: <div style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, 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:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;"><br /></div><div style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;">Additional supporting files include: </div><div style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;"><br /></div><div style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, 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:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, 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:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, 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:

Name : ObjectId

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