sfgov/reference-department-code-list-j2hz-23ps
Icon for Socrata external plugin
 
Preview
  • reference_department_code_list
     
 
Readme
Updated 3 days ago
Indexed 1 hour ago

Reference: Department Code List

These department codes are maintained in the City's financial system of record. Department Groups, Divisions, Sections, Units, Sub Units and Departments are nested in the dataset from left to right. Each nested unit has both a code and an associated name.

The dataset represents a flattened tree (hierarchy) so that each leaf on the tree has it's own row. Thus certain rows will have repeated codes across columns.

Data changes as needed.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Department Group Codedepartment_group_codedepartment_group_codeTextThe first node in the hierarchy of department codes. All active departments will have at least one row capturing this level, repeating subsequent codes.
Section Codesection_codesection_codeTextThe third node down the hierarchy of department codes. A Division may have zero or many Sections.
Section Namesection_namesection_nameTextThe name for the section code.
Department Codedepartment_codedepartment_codeTextThe sixth node down the hierarchy of department codes. A Sub-Unit may have zero or many Departments.
Division Codedivision_codedivision_codeTextThe second node down the hierarchy of department codes. A Department Group may have one or many Divisions. For smaller departments, there will be one department group code and one division code.
Unit Codeunit_codeunit_codeTextThe fourth node down the hierarchy of department codes. A Section may have zero or many Units.
Unit Nameunit_nameunit_nameTextThe name for the unit code.
Department Namedepartment_namedepartment_nameTextThe name for the department code.
Division Namedivision_namedivision_nameTextThe name for the division code.
Department Group Namedepartment_group_namedepartment_group_nameTextThe name associated with the department group code.
Sub-Unit Namesub_unit_namesub_unit_nameTextThe name for the sub-unit code.
Sub-Unit Codesub_unit_codesub_unit_codeTextThe fifth node down the hierarchy of department codes. A Unit may have zero or many Sub-Units.
Upstream Metadata