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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Department Group Code | department_group_code | department_group_code | Text | The first node in the hierarchy of department codes. All active departments will have at least one row capturing this level, repeating subsequent codes. |
| Section Code | section_code | section_code | Text | The third node down the hierarchy of department codes. A Division may have zero or many Sections. |
| Section Name | section_name | section_name | Text | The name for the section code. |
| Department Code | department_code | department_code | Text | The sixth node down the hierarchy of department codes. A Sub-Unit may have zero or many Departments. |
| Division Code | division_code | division_code | Text | The 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 Code | unit_code | unit_code | Text | The fourth node down the hierarchy of department codes. A Section may have zero or many Units. |
| Unit Name | unit_name | unit_name | Text | The name for the unit code. |
| Department Name | department_name | department_name | Text | The name for the department code. |
| Division Name | division_name | division_name | Text | The name for the division code. |
| Department Group Name | department_group_name | department_group_name | Text | The name associated with the department group code. |
| Sub-Unit Name | sub_unit_name | sub_unit_name | Text | The name for the sub-unit code. |
| Sub-Unit Code | sub_unit_code | sub_unit_code | Text | The fifth node down the hierarchy of department codes. A Unit may have zero or many Sub-Units. |
Upstream Metadata