Name: Management Classification And Compensation Plan Pay Ranges
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Management Classification And Compensation Plan Pay Ranges

Management Classification and Compensation Plan (MCCP) Pay Ranges by Job Code (FY13-14 - FY18-19)
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:45.751894

Tables

Table 1

@usgov.city_of_san_francisco_management_classification_and_co_e48a4701.table_1

37.14 kB
1,510 rows
16 columns

CREATE TABLE table_1 (
  "fiscal_year" VARCHAR,
  "eff_date" TIMESTAMP  -- Eff. Date,
  "group" VARCHAR,
  "job_code" BIGINT,
  "title" VARCHAR,
  "union" BIGINT,
  "setid" VARCHAR,
  "range_a" VARCHAR,
  "range_b" VARCHAR,
  "range_c" VARCHAR,
  "min_a" DOUBLE,
  "max_a" DOUBLE,
  "min_b" DOUBLE,
  "max_b" DOUBLE,
  "min_c" DOUBLE,
  "max_c" DOUBLE
);