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.

    1. Business Unit 10000 Org Trees - Current and Legacy Trees (updated August 2017)
    2. Business Unit J0000 Org Tree (updated August 2017)
    3. Journal Source ID Table (updated March 2017)
  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.

    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

    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.

Back to Chart of Accounts Structure