The Unit Hierarchy Database (UHD) defines the organizational structure of the University of Georgia.  It assists OVPR (and UGA) in managing business processes (workflow), produce reports, identify members of organizations (in conjunction with UMD) and can be used for future applications that need electronic access to the organizational hierarchy. UHD is a mission-critical application for OVPR.

UHD provides both identification and hierarchical information about all “units” in the University. A unit is an organizational entity of any type (e.g., centers, departments, colleges, offices), usually with associated human resources. It incorporates but expands on unit codes and hierarchies in BUD_ORG_STRUCTURE, the existing budgetary organization at UGA. Identification includes not only names and budget codes (if assigned) for units, but also the type of unit, the status (official or unofficial) of unit, multiple names and synonyms for unit, and the history of any changes to these identifying attributes (see below).

UHD supports multiple hierarchical reporting structures, and currently includes an Administrative hierarchy (typically recognized as an institution’s org. chart) and Budgetary hierarchy, which incorporates the Accounting Department’s BUD_ORG_STRUCTURE database, updated nightly.

UHD is in the “sixth normal form,” meaning that the status and relationships of the structures are stored and shown in a temporal or historic context. For example, the organizational structure as it was last month can be seen. This temporal context currently reflects only a few months of history, as it begins at the time of UHD’s implementation of the sixth normal form feature.

UHD provides secure web services so that any authorized application can use the capabilities of UHD.

UHD is integrated with other OVPR applications, such as Online Transmittal Form, Unit Membership Database, Service Center Database, and eXtended Property Records.

If you have questions regarding use of the system, please contact Jerry NeSmith at

Brief one-on-one training is available to teach the concepts embedded in UHD, and how to query and/or update the content of UHD. If applications use UHD web services, web developers will need training by one of OVPR’s application developers.

Download the UHD Admin User Guide

Contact to make arrangements for training.

Why would I need to use UHD?

If you use any OVPR applications and databases, you are probably already using UHD without realizing it.

If your organization intends to implement a workflow system that routes tasks, approvals and other business transactions through an organization hierarchy, you may benefit by using programmatic interfaces to UHD, including web service-enabled capabilities. As an example, the online transmittal form that accompanies all proposal submissions through OSP uses UHD for its electronic approval workflow using digital signatures.

How do I access UHD?

Only authorized users may access UHD through the login screen and administrative interface. If your job duties require access to this application, contact Use of UHD by applications can occur by direct query or web services; OVPR can help develop these connections.

How do I login to UHD?

Use your UGA MyID and Password.  If you are an authorized user, you will be granted access to the administrative interface.

Do I need training to use UHD?

You may need a brief one-on-one training in order to learn the concepts embedded in UHD, and how to query and/or update the content of UHD.

If you intend to use UHD web services, your web developers will need training by one of OVPR’s application developers.

Contact to make arrangements for training.

Where do the data in UHD originate?

The Accounting Department’s BUD_ORG_STRUCTURE is the fundamental content, providing the three-tiered budgetary account hierarchy as one of the structures in UHD.  These data are updated nightly.  OVPR currently maintains all other unit identities, attributes, and hierarchies on an “as needed” basis, particularly the Centers, Institutes, Core Facilities, Research Support Services, unofficial groups and OVPR internal reporting structures.

May 7, 2013: Release 1.5 (Improved User Interface)