Chart of Accounts: Project

The Project chartfield is a 7-character alphanumeric value which assists in uniquely identifying and tracking charges to a discrete set of activities, initiatives or projects. The focus of a Project is tracking an activity or a specified purpose. The Project is often associated with a person that is responsible or accountable for the activity. It is a required field on revenue, expense, and transfer transactions.

Projects should not be confused with Funds. The Fund chartfield identifies the source, whereas a Project allows tracking for a particular activity or purpose (how a department uses funds). A Project usually has a specific beginning and ending date.

Generally, a new Project may be established:

  • To track a discrete activity, initiative, or project that falls within a predefined list of uses
  • Generally, for activities that have a specific beginning and ending date
  • To track activities for contracts, grants, gifts, and endowment income

Multiple Separate Projects versus Single Shared Project

  • Multiple Separate Projects

In many cases, the activity that is tracked by the Project is unique and assigned to an owner or person accountable or responsible. In this case, multiple separate Projects are utilized, and an owner is assigned to each one. For example, individual separate Projects are used with contracts, grants, gifts, recharges and discretionary projects. Multiple separate Projects have an expected end date, which can be changed.

  • Single Shared Projects:

It is recognized that some activities are similar across multiple departments. The department chartfield can identify who is performing the activity and the Project itself is the same. For example, many departments have a need to track the fundraising activity within their department. In order to prevent a proliferation of projects which are essentially for the same Project (in this case, fundraising), a single shared “fundraising” Project is set up. Where possible, Projects representing a common activity are shared among multiple departments using a single Project. Because of the shared nature, shared Projects do not have owners and are not assigned to a person. They relate to a departmental activity which is shared across multiple departments. The PI/manager/owner for a shared Project is “Department/Division”. The end date for single shared Projects is 12/31/2099.

Materiality

A Project should be set up only for activities where there is a definite reporting need and where revenues and/or expenses are material.

Purpose/Use

A new Project chartfield may be established for the following purposes:

Project Use: Sponsored Projects (contracts and grants)

Description

A sponsored project is defined as any externally funded research or scholarly activity that has a defined scope of work or set of objectives, which provides a basis for sponsor expectations. This more specifically involves research, demonstration, professional development, instruction, training, curriculum development, community and public service, or other scholarly activity involving funds, materials, other forms of compensation, or exchanges of in-kind efforts under awards or agreements.

Sponsored awards are made to the University on behalf of the principal investigator (PI), who is primarily responsible for carrying out the requirements of the award. The PI may also be referred to as the project director. The few exceptions are certain awards that may be made to individuals, such as some faculty fellowships.

Sponsored projects include extramural grants, contracts and clinical trials. Sponsored projects will have multiple Project IDs.

Currently, sponsored projects (RAS) use the PeopleSoft Projects module to track award/grant setup, detail project activities, and billing activities. The PeopleSoft Projects module works in conjunction with the financial systems, but is focused on project management and billing. A RAS project is established in the PeopleSoft Project module first. Upon saving, its information will be synchronized with PeopleSoft General Ledger’s Project chartfield table. The user can use the Project chartfield page to view the RAS Project but not change its data.

Not all Projects generated in RAS fall into the sponsored projects (contracts and grants) project use category. Some of the Projects generated in RAS belong in the affiliation agreements and contracts or in other project use categories.

Examples

Project Use Project Project Name

Sponsored projects

Separate projects with a unique award ID attribute

Grant for ABC research

Sponsored projects

Separate projects with a unique award ID attribute

Contract for DEF research

Sponsored projects

Separate projects with a unique award ID attribute

Clinical trial GHI research

Project Use: Capital Construction Projects

Description

(See Section 4.1.9 on Capital Accounting)

Capital Accounting consists of Capital Projects and Capital Asset Management. Capital Accounting performs the accounting and reporting functions for capital projects and equipment, software and library collections that have service lives longer than one year.

The UCOP Accounting Manual specifies that new construction remains as construction-in-progress until the project is 90% complete. Twice per year the expenses of all new construction projects that are 90% complete and over $35,000 are capitalized as a capital asset. Thereafter, any additional construction expenses are capitalized semi- annually until the project is complete.

Capital projects will have separate Projects for each capital project.

Examples

Project Use Project Project Name

Capital construction

Separate projects

Renovation of ABC 3rd floor

Capital construction

Separate projects

New building DEF

Capital construction

Separate projects

Construction in GHI lab

Project Use: General

Description

General contains projects that do not fall into any of the other categories. General projects are divided into four main groups:

  1. Gifts and endowments that have no specific intended use when received have separate Projects, one for each gift/endowment received.
  2. A single shared General Project is for money received by a department (other than from than gifts and endowments) which has no specific project use. The General Project can also be used as a default when a project is required (see Mandatory Use). The single shared General Project will have a Project ID of “1111111”.
  3. Where activities are similar across multiple departments, a single shared Project is set up and the same project is used by the different departments for that activity. The Department chartfield can identify who is performing the activity and the Project itself is the same. Some examples of single shared projects are:
  • Fundraising and development investments which are departmental use specific. This is not to be used by University Development and Alumni Relations.
  • A single shared Project is used by multiple departments for continuing medical education.
  • A single shared Project is used by multiple departments for SFGH professional clinical fees at SFGH which are not part of the SFGH affiliation agreement.
  • A single shared Project is used by clinical service centers/labs (e.g. in Dentistry and Nursing) for professional clinical fees generated at UCSF.
  • A single shared Project is used for UCSF clinic resident support (same parent/award ID as UCSF clinical.
  • A single shared Project is used across multiple departments for earned income from consulting and expert witness fees.
  1. Separate Projects which need to be tracked and reported separately from the General unspecific Project. These Projects are subject to Control Point and central review.

Examples

Project Use Project Project Name

General

Separate projects with a unique award ID attribute

New gift ABC with no specific intended use when received

General

Single shared project

General

General

Single shared project

Fundraising / development

General

Single shared project

Continuing medical education

General

Single shared project

SFGH professional fees

General

Single shared project

UCSF clinical (for clinics/labs)

General

Single shared project

UCSF residents (same award/parent ID as UCSF clinical

General

Single shared project

Outside income/consulting

Project Use: Faculty/PI/Owner Activity

Description

A Project may be set up if it is decided to track the discretionary revenues and expenses of an individual faculty member or other owner of discretionary activities.

It is important to distinguish between faculty/PI/owner activity versus department discretionary. Each faculty/owner discretionary activity Project is assigned to an individual owner.

If substantial, a need may exist to create separate Projects for consulting revenues per faculty/PI name. Faculty/PI/owner activity includes discretionary research, allocation to an individual, clinical trial residuals, academic enrichment, royalty/inventor share or symposiums that an individual is accountable for. It also includes gift and endowment projects that an individual is accountable for.

Faculty/PI/owner activity projects have separate Projects with a unique Faculty/PI/owner name attribute.

Examples

Project Use Project Project Name

Faculty/PI/owner activity

Separate projects for each faculty/owner/PI

Research – Dr. Smith

Faculty/PI/owner activity

Separate projects for each faculty/owner/PI

Research – Bill Jones

Project Use: Recruitment/Faculty Start-up

Description

A reporting need often exists to track recruitment faculty start-ups. Typically costs are aligned with the offer letter or other formal or informal initial employment agreement. Expenses would include salary support that is part of the recruitment package. Endowed chairs should be captured as part of recruitment if they are assigned for that purpose. Capital is included in the recruitment project until the department is ready to spend on the capital, at which point these dollars are transferred to the capital project. Housing loans are part of recruitment / start-up packages.

Faculty recruitment start-up packages have separate projects with a unique Faculty/PI name attribute.

Examples

Project Use Project Project Name

Recruitment faculty start-up

Separate projects for each start-up

Dr. Smith recruitment

Recruitment faculty start-up

Separate projects for each start-up

Dr. Jones start-up

Recruitment faculty start-up

Separate projects for each start-up

Endowed chair recruitment

Project Use: Retention

Description

All junior faculty hired in a medical school have committed substantial time and effort in education and training and are recognized as having the potential to succeed in an academic environment on the basis of demonstrated excellence in research, clinical practice, and/or teaching. Given the long training periods for such faculty— often 15 years or more of higher education and training for clinical scientists—the societal investment in these individuals is substantial. Recruiting these individuals as junior medical school faculty represents a significant level of institutional commitment and resources. Facilitating success for such faculty represents a positive return on that investment. Faculty who fail or leave the institution represent a negative return and drain scarce resources when replacements need to be recruited.

Retention packages may be offered to a faculty/PI along with a retention letter. Expenses include salary support which is part of the retention package and bridge funding if for the purpose of retention.

Faculty/PI retention packages have separate projects with a unique Faculty/PI name attribute.

Examples

Project Use Project Project Name

Retention

Separate projects for each retention package

Dr. Smith retention

Retention

Separate projects for each retention package

Dr. Jones retention

Project Use: Medical Center Activity

Description

There is a close relationship between the UCSF campus and the UCSF Medical Center. Campus clinical departments provide medical direction, out-reach services and extended coverage to the Medical Center. Because of the collaborative relationship, the Medical Center also provides strategic support to the campus and invests in clinical program development by paying for start-up - “back-stops” - costs including physician compensation and administrative costs. A reporting need exists to track the revenues and expenses between the campus and Medical Center.

Medical Center projects can be divided into three main groups:

  1. Medical Center clinical care has a single shared Project. This includes Medical Center Professional Service Agreement revenues and expenses, Medical Center purchased services and Medical Center strategic support.
  2. Medical Center residents have a single shared Project. This includes revenues and expenses related to training residents at the Medical Center.
  3. Other special agreements/joint ventures between the Medical Center and independent clinical facilities have separate Projects for each special agreement.

Examples

Project Use Project Project Name

Medical Center activity

Single shared project MC professional clinical care (includes MC purchased services & MC strategic support)

Medical Center activity

Single shared project

Medical Center residents

Medical Center activity

Separate projects for each special agreement/joint venture

Radiology PET-CT/spint joint venture

Medical Center activity

Separate projects for each non-clinical agreement

Audit service charge to Medical Center

Project Use: Affiliation Agreement/Contract

Description

Affiliation agreements and contracts can be for any material agreement with an entity outside of UCSF.

Affiliation agreement and contract Projects can be divided into three main groups:

  1. Hospital affiliation agreements will have a single shared Project for each hospital (SFGH, VAMC, etc.). Hospital and the associated resident Projects will share the same award ID.
  2. Agreements for residents will have a single shared Project for each hospital (SFGH, VAMC, etc.). Resident and the associated hospital Projects will share the same award ID attribute.
    • Other sales and service agreements and contracts will have multiple Projects for each affiliation agreement and contract.

Examples

Project Use Project Project Name

Affiliation agreement/ contract

Single shared project which has the same award ID as “Residents – SFGH”

SFGH affiliation agreement

Affiliation agreement/ contract

Single shared project which has the same award ID as “SFGH affiliation agreement”

SFGH residents

Affiliation agreement/ contract

Separate projects for each agreement

Hemophilia program (shared between Medicine and Pediatrics)

Project Use: Recharge

Description

(See section on Recharges)

Throughout the campus, organizational units use a variety of products or services to perform their activities. When these products or services are provided by organizational units within the University, the units providing the products or services function as non-profit businesses, and charge for their products or services.

The University provides an internal mechanism for charging organizational units for support services wherein all allowable costs associated with providing these products or services are included. This mechanism is called a “recharge,” which is the activity used to recover expenses incurred in providing products or services based on an approved recharge rate. Recharges should not be confused with expense transfers or External Sales and Service of Education Related Activities (fee for service).

The Project chartfield will be used to uniquely identify each distinct recharge activity. The Project will be used to match all expenses directly attributable to providing the products, services, and management of the recharge activity with the revenue that is generated by charging internal and external customers. Recharge Projects can be set up for each recharge activity.

For recharges, if a decision is made to temporarily prevent a department from charging to a recharge revenue account, the recharge Project attribute can be temporarily changed from “Active” to “Inactive”. Once the recharge Project is available to recharges again, the attribute can be changed back to “Active”.

Award/parent ID is a Project attribute that enables linking of multiple related recharge Projects for different service lines within one recharge operation for reporting. Award/parent ID is an alpha-numeric field that will be assigned in PeopleSoft in the initial project setup process. For all Project uses except RAS-generated sponsored projects, if the user indicates this is a parent Project, the award/parent ID attribute is the same as the initial Project. If the user indicates this is a sub-project, the award/parent ID can be changed to that of the parent Project. This will allow for roll-up reporting of Projects which are grouped together through the award/parent ID. Below is an example of how a recharge may use parent and sub-projects that are linked together using the award/parent ID attribute. The user will use the same award/parent ID as the parent Project for the related sub-projects.

Project

Project Name

Project

Award/parent ID

Parent

ITS voice recharge

1245555

1245555

Sub-project

ITS Joint costs (records all joint costs for projects 2120000-21200004)

2120000

1245555

Sub-project

Toll Calls

2120001

1245555

Sub-project

Voicemail

2120002

1245555

Sub-project

Dial tone

2120003

1245555

Sub-project

Moves, adds, changes

2120004

1245555

Examples

Project Use Project Project Name
Recharge Separate projects for each recharge activity Printing services recharge
Recharge Separate projects for each recharge activity Micro CT scanner recharge

Project Use: Sales and Service Agreements

Description

Sales and service agreement Projects are for activities which provide products and/or services to external customers only.

Project Use: Programmatic Investment

Description

Departments may decide to put aside money for a specific program or initiative, such as for teaching support or program development. This project use may also include gifts or endowments that benefit a particular program or initiative. The PI/manager/owner could be an individual or Department/Division.

Programmatic investment projects can be divided into three main groups:

  1. Programs that are shared across multiple departments will have a single shared Project. An example is the Grand Rounds program. The Department ID chartfield can identify the specific department.
  2. Programs that are unique to a specific department will have separate Projects for each program.
  3. Research funded by gifts and endowments will have separate Projects for each research activity.

Examples

Project Use Project Project Name

Programmatic investments

Single shared project

Grand Rounds program

Programmatic investments

Separate projects

Scholars program

Programmatic investments

Separate projects with unique award/parent ID attribute for the gift/endowment

Dr. Ross research program

Project Use: Costed Central Activity

Description

Costed central activities are basic central campus functions (e.g. HR, basic police services, internal audit services, payroll, ITS administrative computing) which are funded by allocation of costs to self-supporting auxiliary enterprises (e.g. Campus Life Services).

Project Use Project Project Name

Costed central activity

Separate projects

AS-mainframe applications

Costed central activity

Separate projects

Controller shared expense

Project Use: Loan (student/faculty/staff)

Description

There are separate Projects for each loan to students, faculty and staff. Loan Projects are primarily set up centrally by Student Accounts.

Project Attributes:

Certain Project attributes apply to all Project uses, while other attributes are specific to a particular Project use.

The list of Sponsored projects (grants and contracts) attributes is maintained in the PeopleSoft Projects module and cannot be changed in the General Ledger chartfield table.

The Project attributes which apply to all Project uses include:

  • Effective Status – A Project is either in Active or Inactive status at any point in time. It can be changed from Inactive back to Active.
  • Start and End Dates –The start date is the date of setup and the end date is the estimated end date. The end date can be changed on a Project. The end date for shared Projects with no readily-determinable end date is 12/31/2099.
  • Award/Parent ID – This field is used to report multi-project activities from the same original parent Project. In the initial Project setup, the award/parent ID is the same as the Project. When sub-projects of an existing Project are set up, the award/parent ID is the same as on the parent Project. This allows for the linking of related Projects.
  • Parent Project – A Project is either a parent Project or a sub-project of an already existing one. If the Project is a sub-project of an existing Project, the person setting up the Project should use the same award/parent ID as the parent Project.
  • Principal Investigator / Owner – This is the employee ID of the person who is has the principal responsibility and accountability for the Project. During the Project setup, validation of the employee ID with the use of a lookup table is recommended.

Some of the Project attributes which apply to sponsored projects and are optional for other types of project use are:

  • Type of Lab – This is a whether a lab is a Wet, Dry or Other lab. It is used on sponsored projects in order to link a PI to the type of lab for ICR benchmarking.
  • Lab Location – Building – This is the building or CAAN number of the lab and is used on sponsored projects in order to link a PI to the type of lab for ICR benchmarking.
  • Lab Location – Room – Depending on the selection for the lab location – building attribute, there will be a drop-down box to select the room within the building.

The Project attributes are listed in the table below. Relevant Project attributes for each type of project are indicated. The Project category abbreviations are:

  • SP – Sponsored projects
  • CP – Capital Projects
  • RC – Recharges
  • G – Gift
  • E – Endowment
  • OT – All others

(O = Optional)

Field Name Type Length Description SP CP RC G E OT

Set ID

AN

5

See Set ID description in Account chartfield attribute.

X X X X X X

Project

AN

7

An alphanumeric value assigned to a project.

X X X X X X

Description

AN

30

30-character project description

X X X X X X

Project Nickname

AN

50

Secondary description, or nickname for a project

O O O O O O

Effective Status

AN

1

Project status:

  • A = Active
  • I = Inactive
X X X X X X

Start Date

Date

 

The date when project starts

X X X X X X

End Date

Date

 

The date when project ends. Shared projects which are set up centrally have an end date of 12/31/2099.

X X X X X X

Project Use

AN

2

Name indicating the use of the project

  • 1 = Affiliation agreement/contract
  • 2 = Capital/plant
  • 3 = Costed central activity
  • 4 = Faculty/PI/owner activity
  • 5 = General
  • 6 = Loan (student/faculty/staff)
  • 7 = Medical Center activity
  • 8 = Programmatic investment
  • 9 = Recharge
  • 10 = Sales and Service Agreements
  • 11 = Recruitment/faculty start-up
  • 12 = Retention
  • 13 = Sponsored project
X X X X X X

PI/manager/owner

AN

9

Employee ID of the person responsible and accountable for the project. For projects for which there is no individual owner, department/division is an option

X X X X X X

Gift/Endowment Type

AN

1
  • Indication if the source of the project is a gift, Regents endowment income, Foundation endowment income, endowment principal or none of these Gift
  • Endowment income – Regents
  • Endowment income – Foundation
  • Endowment principal
  • None of these
  X X X X X

Parent Project

AN

1

Y/N value, indicating if this is a parent project or a sub-project of a parent project

  • Y = Parent Project
  • N = Sub-Project of a parent project
X X X X X X

Award /Parent ID

AN

7

The award/parent ID is used to group like projects together for reporting.

X X X X X X

UCOP Fund

AN

6

The UCOP fund number that provides the funding to the project.

- - -   O O

Endowment Restriction Code

AN

5

Code indicating the restrictions as to general use, specific purpose and campus locations placed upon endowment income by the donor or the Regents.

- - - - X -

Capital Class

AN

1

Required for capital construction project to distinguish different classifications:

  • 1 = Major
  • 2 = Minor
  • 3 = Study
- X - - - -

Capital Category

AN

1

Required for capital construction project to provide detail categorization. See section 4.1.7 Capital for more details.

- X - - - -

Capital Sub-category

AN

2

Depending on the capital category to provide granular level of sub-category. See section 4.1.7 Capital for more details.

- X - - - -

Federal Funds Allowed

AN

1

Y/N value, indicating if the project is being set up for recharge activity where federal funds are allowed

  • Y = federal funds are allowed
  • N = federal funds are not allowed
- - X - - -

Indirect Cost Rate

N

4

Rate used to calculate indirect cost. See section 4.1.16 Indirect Cost for details.

X - X - - O

Indirect Cost Base

AN

1

Code identifies the direct cost base on which the indirect cost rate will be calculated. See section 4.1.16 Indirect Cost for details.

X - X - - O

STIP ID

AN

7

TBD – depending on STIP re-design

X O O O O O

On/Off Campus

AN

1
  • 1 = On Campus (default)
  • 2 = Off Campus
X O O O O O

Type of Lab

AN

1

Code indicating whether a lab is a Wet or Dry lab.

  • W = Wet
  • D = Dry
  • O = Other
X O O O O O

Lab Location - Building

AN

4

Building or CAAN number of the lab. Used for ICR benchmarking.

X O O O O O

Lab Location - Room

AN

4

Room in the building where the lab is located. Used for ICR benchmarking.

X O O O O O

Lab Owner

AN

9

Employee ID of the lab owner

X O O O O O

Sponsor Category

AN

2

Required for sponsored projects and gifts, to provide a general classification of the sponsor providing the funding.

X - - X - -

Sponsor Code

AN

4

Required for sponsored projects and gifts, identifies the specific Federal, State, or private agency providing the funding. UCOP maintains a complete list of all sponsor codes and names.

X - - X - -

Federal Flow Through Code

AN

1

Code indicating the nature of sponsored projects (gift, contract, or grant) actually paid for by Federal funds but with the monies received from a non-Federal (State, local, or private) source.

O - - X - -

Agency Code

AN

4

For Federal funding only. Identifies the Federal agency source of the funding.

O

-

- - - -

CFDA

AN

6

Code indicating the program in the Catalog of Federal Domestic Assistance assigned by the Federal agencies

O - - - - -

Payment Method

AN

2

Code indicating the manner in which sponsored funds are paid to the University

O - - - - -

Electronic Verify Flag

AN

1

Y/N value, indicating if E-Verify (internet-based employment eligibility verification) is required for the project (in RAS)

  • Y = E-Verify is required
  • N = E-Verify is not required
X - - - - -

Salary Cap

   

Applies only to RAS projects – indicates if a salary cap applies or not

X          

Current Cap Rate

   

Applies only to RAS projects – the cap rate

X          

Current Cap Effective Date

   

Applies only to RAS projects – the effective date of the salary cap rate

X          

UCSF Fund

   

Certain projects have an associated UCSF Fund value for UCOP reporting

X     X X  

Loan Program

   

This attribute applies only to Loan projects and identifies the source of funding for the loan (see White Paper on Student Accounts)

           

Numbering Convention

Careful consideration will be given to not duplicate any of the existing numbers used in RAS for sponsored projects.

Not all Projects generated in RAS fall into the sponsored projects (contracts and grants) Project use category. Some of the Projects generated in RAS belong in the affiliation agreements and contracts, or in other Project use categories.

Before the new COA, Project is a chartfield used solely by RAS. A RAS project id is generated by the system based on the Award ID. To allow multiple Projects for an award, the system uses the following numbering convention to generate the project ID for an award:

  1. First 6-character of a project ID is the 6-digit of its Award ID. Award ID is a 7-character alphanumeric value. It always starts with A and follows by a 6-digit numbers, e.g., A117088. The first 6-character of the project id is its Award’s 6-digit number, e.g., 117088.
  2. The last character of a project ID is always an alpha, starting from A to Z, but skips I and O (to reduce confusion with 1 or 0) for multiple projects associated to the same award. For example, 117088A, 117088B, 117088C … etc.
  3. If an award has more than 24 projects, the 1st character of the project id will be changed to B. If more than 48 projects, the 1st character of the project id will be changed to C … etc. For example, B17088A, B17088B … B17088Z, C17088A, C17088B, … etc. So far, the award has the most projects is A106017 with 246 projects (106017A … L06017K).

A RAS project id will still follow the above numbering convention for sponsored projects only.

We will have a special numbering convention for project for the following project uses:

  • Loan (student/faculty/staff) 6000000-6199999
  • Gifts 7000000-7499999
  • Endowment income, Regents 7500000-7699999
  • Endowment income, Foundation 7700000-7899999
  • Endowment principal 7900000-7949999
  • Recharge 8000000-8499999
  • Sales and Service Agreements 8500000-8799999
  • Costed central activity 8800000-8999999
  • Capital/plant 9xxxxxx

For all other Projects, the project id will be a sequential 7-character alphanumeric value.

Changes in Project Use

The Projects in the Project use categories of capital/plant, costed central activity, loan, or recharge will not be able to change to a different Project use category. Attempts by the user to make prohibited changes in Project use would be met with an error message: “This change in project use is not allowed.” If a user needs to initiate a change in these Project use categories, he has to inactivate the Project and re-journal any transactions which have already been made.

Project use can be changed for any other Project (but not to capital/plant, costed central activity, loan, or recharge).

For example, new gifts and endowments which have no specific intended use when received are put into the “General” Project use category, and then may be moved into another Project use category once they are designated for a specific purpose.

A gift or endowment project is received from the UCSF Foundation with the Project use General. The award/parent ID attribute is the same as the gift or endowment Project.

Project

Project Name

Award/Parent ID

Project Use

PI/Owner

3753980

Dean’s Office Dentistry Gift

3753980

General

0267xxxx(Dr. Jones)

The department may then reclassify the Project use as appropriate.

Project

Project Name

Award/Parent ID

Project Use PI/Owner

3753980

Dean’s Office Dentistry Gift

3753980

Discretionary activities (faculty/staff/PI)

0267xxxx(Dr. Jones)

In order to track the Project use for a gift or endowment, there is a Project attribute to indicate whether the project source of funds is a gift, endowment income (Regent or Foundation), endowment principal, or none of these. This attribute will not change during the life of the Project. Also the initial award/parent ID attribute on the gift or endowment project will not change during the life of the Project. This will allow for the tracking of how gifts and endowments are used.

The department may decide to keep some of the gift or endowment income in the general Project use category and create new sub-projects with various Project uses. The award/parent ID links the Projects together and allows the grouping of the related Projects for reporting purposes.

Project Project Name Award/parent ID Project Use PI/Owner

3753980

Dean’s Office Dentistry Gift

3753980

General

0267xxxx(Dr. Jones)

3806464

Gingivitis Research

3753980

Discretionary Activities (faculty/staff/PI)

0201xxxxx(Dr. Nesmith)

3850005

Undergraduate & Professional Scholarship

3753980

Programmatic Investments

0294xxxx(Dr. Tork)

Project Initial Setup Workflow

Project initial setup rules:

Project Use Initial Setup Review and Approval Final Validation and Setup

Sponsored Projects

Not set up in GL chartfield table; attribute values are populated from RAS

Department can change project use

N/A

Control Point or delegate

Controller’s Office

Controller’s Office

Sponsored Projects

(not in RAS)

Extramural Funds

N/A

Controller’s Office

Capital Projects

CPFM Accounting

N/A

Controller’s Office

Recharge Projects

Budget Office Recharge Unit

Campus Life Services for CLS Recharges

N/A

Controller’s Office

General Projects – Gifts and Endowments

Foundation Accounting

Departments can change project use and set up gift subprojects

N/A

Control Point or delegate

Controller’s Office

Controller’s Office

Loan Projects

(student/faculty/staff)

Student Accounts

N/A

Controller’s Office

All other Projects

Department

Control Point or delegate

Controller’s Office

* Currently, sponsored projects (RAS) uses the PeopleSoft Projects module to track award/grant setup, detail project activities, and billing activities. The PeopleSoft Projects module works in conjunction with the financial systems, but is focused on project management and billing. A RAS project is established in the PeopleSoft Project module first. Upon saving, its information will be synchronized with PeopleSoft General Ledger’s project chartfield table. The user can use the Project chartfield page to view but not change its data.

** Capital construction projects are set up centrally and department users can use the project chartfield page to view but not change its data.

Establishing New Project Values

Refer to the Guidelines for New Project Set-Up job aid for an overview of guidelines and step-by-step instructions on establishing a new Project in PeopleSoft.  The Project/Flexfield Approval Procedures job aid describes actions taken by Chartfield Approvers in PeopleSoft.  View the Chart of Accounts Project Set-Up Guide for a table of Project Use, Project Name, and Project Description that indicates whether a user can add a non-shared Project.

Values

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