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

469.85 KB
19562 rows
30 columns


CREATE TABLE table_1 (
  "fiscal_year" VARCHAR,
  "eff_date" TIMESTAMP,
  "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
);