Organization Tree Reports

Two types of organization tree reports are available for download.

1. 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.

2. 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.

ReportHTML PageText 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

To Convert Text Files to Excel Format

  1. Open Excel. From the Excel File menu, select Open…
  2. 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.
  3. Choose Delimited instead of Fixed Width. Click Next.
  4. Uncheck the Tab delimiter. Check Semicolon as the Delimiter. Click Next.
  5. Choose Text as the Column Data Format. Click Finish.
  6. Choose Save As from the File menu. Select Save as type from the drop-down menu and choose Excel Workbook.