Name: City Employment Compensation Plan
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

City Employment Compensation Plan

Hourly rate steps for all stepped salary plans. See the City Employment Classification Definitions dataset for job descriptions and minimum qualifications for each position.
Organization: City of San Francisco
Last updated: 2021-12-11T16:15:54.895693
Tags: city-employees, employment, jobs

Tables

Table 1

@usgov.city_of_san_francisco_dhr_city_employment_compensation_plan.table_1

333.56 KB
15408 rows
32 columns


CREATE TABLE table_1 (
  "effectivedate" TIMESTAMP,
  "gradeid" VARCHAR,
  "jobcode" VARCHAR,
  "title" VARCHAR,
  "setid" VARCHAR,
  "step1" DOUBLE,
  "step2" DOUBLE,
  "step3" DOUBLE,
  "step4" DOUBLE,
  "step5" DOUBLE,
  "step6" DOUBLE,
  "step7" DOUBLE,
  "step8" DOUBLE,
  "step9" DOUBLE,
  "step10" DOUBLE,
  "step11" DOUBLE,
  "step12" DOUBLE,
  "step13" DOUBLE,
  "step14" DOUBLE,
  "step15" DOUBLE,
  "step16" DOUBLE,
  "step17" DOUBLE,
  "step18" DOUBLE,
  "step19" DOUBLE,
  "step20" DOUBLE,
  "rangeamin" DOUBLE,
  "rangeamax" DOUBLE,
  "rangebmin" DOUBLE,
  "rangebmax" DOUBLE,
  "rangecmin" DOUBLE,
  "rangecmax" DOUBLE,
  "notes" VARCHAR
);