HRBAIRS Data Dictionary - ORG_NODE

The Berkeley campus organizational unit with which a job is associated. Codes are taken from the campus Organizational Tree. This code is not the same as any component piece of chartstrings that are part of the campus General Ledger.

In the lookup view DEPT_HIERARCHY_LKUP, a single record exists for each ORG_NODE. All levels of the UCB Organizational Tree associated with that ORG_NODE - which may occur at any level between 2 (Control Unit) and 7 (Org Code) - are given on the same row. This allows database joins that can always yield, for example, the Control Unit and Division in which an ORG_NODE occurs on the UCB Organizational Tree. Levels below that which a row in this table describes are populated with null or a placeholder (e.g., double-hyphen).

The DEPT_HIERARCHY_MAP view provides information about parent-nodes of the ORG_NODEs it describes.

Lookup view DEPT_TBL_LKUP provides descriptions for code values.