For each extant value of ORG_NODE, this table provides corresponding code and description values of each organizational Level in the campus hierarchy (Levels 1-7 correspond to Campus, Control Unit, Division, Department, Discipline/Group, Sub-Unit, and Organization Code). This view only shows the CURRENT organizational hierarchy.
Contains fields:L1_NODE |
The Level 1 node (Campus level) in which the Org_Node described by this row of lookup table data occurs. |
L1_NODE_DESC |
The description of the Level 1 node (Campus level) in which the Org_Node described by this row of lookup table data occurs. |
L2_NODE |
The Level 2 node (Control Unit level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Control Unit, this field will be empty or blank.) |
L2_NODE_DESC |
The description of the Level 2 node (Control Unit level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Control Unit, this field will be empty or blank.) |
L3_NODE |
The Level 3 node (Division level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Division, this field will be empty or blank.) |
L3_NODE_DESC |
The description of the Level 3 node (Division level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Division, this field will be empty or blank.) |
L4_NODE |
The Level 4 node (Department level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Department, this field will be empty or blank.) |
L4_NODE_DESC |
The description of the Level 4 node (Department level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Department, this field will be empty or blank.) |
L5_NODE |
The Level 5 node (Discipline/Group level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Discipline/Group, this field will be empty or blank.) |
L5_NODE_DESC |
The description of the Level 5 node (Discipline/Group level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Discipline/Group, this field will be empty or blank.) |
L6_NODE |
The Level 6 node (Subunit level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Subunit, this field will be empty or blank.) |
L6_NODE_DESC |
The description of the Level 6 node (Subunit level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Subunit, this field will be empty or blank.) |
L7_NODE |
The Level 7 node (Organization level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Organization, this field will be empty or blank.) |
L7_NODE_DESC |
The description of the Level 7 node (Organization level) in which the Org_Node described by this row of lookup table data occurs. (If the Org_Node described by this row is higher in the hierarchy than Organization, this field will be empty or blank.) |
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. |