Organization Tree Reports
Two types of organization tree reports are available for download.
Manually-Produced Excel Reports
These files have changed as of January 2013. Both the BU 10000 and BU J0000 files now include separate worksheets containing a flat version of the data and a pivot table of the data for easier viewing. The Business Unit 10000 contains flat and pivot worksheets for the currently effective BFS Master Org Tree and the FY13 Legacy Master Org Tree (as of 6-38-2013). A third file is also provided which provides the list of Journal Source IDs and the associated routing org nodes.
Please note that Org Node (L2, L3, L4, L5 & L6) and DeptID (L7) descriptions were updated effective August 1, 2013.
- Business Unit 10000 Org Trees - Current and Legacy Trees (updated August 2017)
- Business Unit J0000 Org Tree (updated August 2017)
- Journal Source ID Table (updated March 2017)
Production-Based Tree Reports
Tree reports are generated weekly from the production database and are available by selecting one of the links below. Reports are based on data which is current as of the run date. A report can be run for the entire Organization tree with links to the individual units. Separate tree reports are also available for each Control Unit. To find a specific department within any of the reports, type Ctrl+F and search by keywords.
|Report||HTML Page||Text File
(semicolon-delimited for download to Excel)
|Master Organization Tree||HTML||Text|
|COLLE - Colleges||HTML||Text|
|COLLS - College of Letters & Science||HTML||Text|
|SCHOL - Schools||HTML||Text|
|OACAD - Other Academic||HTML||Text|
|VCRES - Research, Policy, Planning & Adm||HTML||Text|
|CAMSU - Campus Support||HTML||Text|
|CENLD - Central Ledger||HTML||Text|
|FOUND - BU F - UCB Foundation||HTML||Text|
|OTHR2 - Loc J - Non UCB Operations||HTML||Text|
|OTHRH - BU H - Non UCB - UCOP Ops||HTML||Text|
To Convert Text Files to Excel Format
- Open Excel. From the Excel File menu, select Open…
- In the Open dialogue box, click on the drop-down list for Files of type and select Text Files. Navigate to the text file and open it. The Text Import Wizard will open.
- Choose Delimited instead of Fixed Width. Click Next.
- Uncheck the Tab delimiter. Check Semicolon as the Delimiter. Click Next.
- Choose Text as the Column Data Format. Click Finish.
- Choose Save As from the File menu. Select Save as type from the drop-down menu and choose Excel Workbook.