Name: Hourly Rates Of Pay By Classification And Step
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Hourly Rates Of Pay By Classification And Step

Hourly rates and of pay by classification and step, including information on biweekly minimum, biweekly maximum, title, union code, and effective date (FY12-13 - FY18-19)
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:54.857375

Tables

Table 1

@usgov.city_of_san_francisco_hourly_rates_of_pay_by_classific_4661c074.table_1

481.13 kB
19,562 rows
30 columns

CREATE TABLE table_1 (
  "fiscal_year" VARCHAR,
  "eff_date" TIMESTAMP  -- Eff. Date,
  "job_code" VARCHAR,
  "title" VARCHAR,
  "union_code" VARCHAR,
  "setid" VARCHAR,
  "grade" VARCHAR,
  "biweekly_min" DOUBLE,
  "biweekly_max" DOUBLE,
  "extended_range" DOUBLE,
  "step_1" DOUBLE,
  "step_2" DOUBLE,
  "step_3" DOUBLE,
  "step_4" DOUBLE,
  "step_5" DOUBLE,
  "step_6" DOUBLE,
  "step_7" DOUBLE,
  "step_8" DOUBLE,
  "step_9" DOUBLE,
  "step_10" DOUBLE,
  "step_11" DOUBLE,
  "step_12" DOUBLE,
  "step_13" DOUBLE,
  "step_14" DOUBLE,
  "step_15" DOUBLE,
  "step_16" DOUBLE,
  "step_17" DOUBLE,
  "step_18" DOUBLE,
  "step_19" DOUBLE,
  "step_20" DOUBLE
);