Chart of Accounts: Dept ID

Questions? Contact Accounting and Reporting

Overview

Dept ID chartfield is a 6-character alphanumeric value which identifies the organizational unit involved in transaction or responsible for resource.

Departments are seen as “Cost Centers” whose managers are responsible for all its associated costs and for ensuring adherence to its budgets. It is a required field on revenue, expense, and transfer transactions.

A Department is defined as a distinctly identifiable department, division, or unit of an organization whose managers are responsible for all its associated costs and for ensuring adherence to its budgets

It represents an entity or activity with a defined business objective. Typically, a Department functions as an organized group of employees with a leader (director, chair, manager) who is accountable for the use of an operational budget. A Department can encompass multiple programs/projects and, in most cases, is assigned physical space.

A Department may indicate how an organization is set up. For example, if there are three centers within a department, then each center might be assigned a unique Department to differentiate its activities. A Department designates ownership or stewardship of a transaction or a funding allocation. Funds are common across the campus, but are divided into individual pots of money by Department. For instance, most departments have funding from General Funds, so the Department separates the School of Pharmacy’s share of General Funds from the School of Nursing’s.

A Department should not be established to limit security access. It also may not reflect the same human resources structure.

Purpose/Use

Department chartfield should be used in a way to mimic how you manage your business. It aids in tracking, reporting, and accountability. A new Department may be established when:

  • A new organization has been established as a cost center to track activities separately from existing Departments
  • The new organization needs separate accountability or reporting

Department trees

Departments will be organized into tree levels in PeopleSoft to facilitate reporting and accountability. Financial postings always occur at the lowest level. Depending on the size and breadth of the organization, the lowest level may differ across units. For example, School of Pharmacy may have a control point level 1 roll-up department called School of Pharmacy, and may have direct posting-level departments that report to the School of Pharmacy. In this example, financial posting occurs at level 2. On the other hand, Financial and Administrative Services (FAS) may have a control point level 1 roll-up Department, followed by a level 2 roll-up division for campus life services, followed by a level 3 roll-up Department for facilities management, followed by the posting-level Department for facilities maintenance. In this example, financial posting occurs at level 4. Differentiation between posting-level Departments and roll-up (reporting) level Departments are distinguished using an attribute.

The Department posting and roll-up/parent concept is demonstrated as follows:

Attributes

Field NameTypeLengthDescription
Set IDAN5See Set ID description in Account chartfield attribute.
DepartmentAN6An alphanumeric value assigned to a department.
Effective DateDate The date that the attributes and definitions associated with a department go into effect.
Effective StatusAN1

Department status as of Effective Date:

  • A = Active
  • I = Inactive
DescriptionAN3030-character department description
Short DescriptionAN1010-character department short description
Budgetary OnlyAN1Y/N value, indicate whether the department value is to be used for budgetary purposes only. A budgetary department will not be available for recording financial (i.e., actuals) transactions.
Posting LevelAN1Y/N value; indicates whether the department is allowed to have transactions posted to it. A posting level has no children departments.
FillerAN1Y/N value; indicates whether the department is a filler level department to be used to build a department tree.
SiteAN3-4Code and Description of Site attributes are identified in table below.
Department TypeAN1

An optional field used by School of Medicine (and potentially by other schools) to capture the type of department:

B – Basic Science

C – Clinical

D – Dean’s Office

I – Interdisciplinary Program

O – Organized Research Unit

Site

Site is a department chartfield attribute with the following codes and descriptions:

CodeDescriptionSource of Request

PARN

ParnassusFAS

VAMC

Veterans Affairs Medical CenterFAS/SOM

LHTS

Laurel HeightsFAS

ZION

Mt. ZionFAS

SFGH

San Francisco General HospitalFAS/SOM

MCB

Mission Center BuildingFAS

MBAY

Mission BayFAS

OYST

Oyster PointFAS

MONT

Montgomery StreetFAS

REMO

RemoteFAS

CORE

Core CampusSOM

FRES

FresnoSOM

Numbering Convention

There is no numbering convention in the Department field. It will be a Controller’s Office generated 6-character alphanumeric value. A department tree will be built to roll up department to reflect organizational hierarchy.

Campus vs. Medical Center Dept ID Design

Due to Hyperion reporting limitations and configuration requirements it will be necessary to require unique field values for Dept ID. Thus, Dept ID will only be configured under a single SetID with each value unique.

The Medical Center team has confirmed they will work with (and around) the required Dept ID values that are required for OSHPD reporting.

Values

Refer to the Inquiry Reports for a list of valid values.