Overview

---

The department table stores information about the official hierarchy of departments and units within departments at UC San Diego. You will most often see department when it is a reference field associated with a customer contact or a case.

 

Fields on the Department Table

---

Table name: cmn_department

There are 5 levels of official UCSD departments according to EAH Departments. Most departments that employees work for are levels 3-5. Level 2 is the VC area, and Level 1 is either the campus or the medical center. Because this is a hierarchy, departments contain two fields that are of interest to agents: the parent field, and the member of field.

• The parent field is the direct parent of the department. For example, INFORMATION TECHNOLOGY SVCS, a level 3 department, has VC-CHIEF FINANCIAL OFFICER as the parent, a level 2 department. This field is often useful if you want to narrow down your results to a specific level of departments underneath a parent.
• The member of field contains the parent department, and any parents of parents. For example, INFORMATION TECHNOLOGY SVCS, a level 3 department, has both VC-CHIEF FINANCIAL OFFICER and CAMPUS, level 2 and level 1 departments, respectively, listed in the "member of" field. This field is often useful if you want to cast a wide net and see everything under a particular vice-chancellor's area of responsibility.
• Here is an example of how the table is organized.

 

Common Filters

Filter	Example
Cases from customers that are part of a department. Start your report on the case table. Expand the fields under "Contact (Customer)" Select "Department" Enter the department you wish to show cases for
Cases from customers that are underneath a VC Area Start your report on the case table Expand the fields under "Contact (Customer)" Expand the fields under "Department" Select "Member of" Enter the VC's department.

 

Department Table Fields

Relevant Fields