Department Names and Codes
The City and County of San Francisco is made up of many organizations that perform work and deliver services according to the charter and administrative codes of the City.
These organizations have common names, but also codes that are used in accounting for the work and services performed. The Controller's Office maintains these codes in the Executive Information System (EIS) where department staff maintain records related to spending, revenue and budget among other things. Other enterprise systems use these codes to link administrative data among departments.
|Dataset||Description and Constraints||Reference Columns|
|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.
|Nested (right to left):