A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | FINANCIAL SYSTEM GENERAL LEDGER CHARTFIELDS | > Google Sheet Tips | |||||||||
2 | Fund | DeptID | Program | PCBU | Project | Activity | Account | FinEmplID | CF1 | CF2 | CS |
3 | (4 numeric) Identifies source of money and restrictions on use. | (5 numeric) Identifies unit/fiscal area responsible for financial activity. Generally values begin with 1. | (5 numeric)* Describes activity being done, e.g., credit instruction, outreach. Program is required whenever Project is not applicable. *Alpha/numeric values can be requested but use is restricted. Generally values begin with 2 or alpha character. | (5 alpha) Identifies type of project: Sponsored or Construction in Progress. Values: UMSPR, UMCIP | (8 numeric) Identifies sponsored projects and select non-sponsored activities. | (1 numeric) System requires use of this field when Project field is used. Value: 1 | (6 numeric) Identifies nature of transaction (expense, revenue, asset, etc.). | (7 numeric) EmplID used to track activity to employee, required with certain Program values. | (10 alpha/numeric) Centrally-defined field used to track defined strategies. | (10 numeric) User-defined field used to track activity by college or department. | (2 alpha) Identifies cost share transactions on non-sponsored funds. Value: CS |
4 | REQUIRED ON ALL TRANSACTIONS | REQUIRED ON ALL NON-SPONSORED AND COST SHARE TRANSACTIONS | REQUIRED ON ALL SPONSORED TRANSACTIONS | REQUIRED ON ALL TRANSACTIONS | CONDITIONAL / OPTIONAL | ||||||
5 | |||||||||||
6 | Function - An attribute of every Program and Project value. Function identifies the purpose of the Program or Project, for example, instruction or research. | ||||||||||
7 | Required ChartFields per Transaction Type | ||||||||||
8 | |||||||||||
9 | There are three primary types of transactions: Non-sponsored, Sponsored, and Cost Share. Depending on the type of transaction, certain ChartField values must be populated. An example and definition of each type is listed below, and the minimum required fields per transaction type are labeled as "Required." | ||||||||||
10 | |||||||||||
11 | Non-sponsored | ||||||||||
12 | Funds available for use on activities that are not externally-sponsored research (e.g., funds from state appropriations, tuition, auxiliaries). | ||||||||||
13 | Fund | DeptID | Program | PCBU | Project | Activity | Account | FinEmplID | CF1 | CF2 | CS |
14 | Required | Required | Required | N/A | N/A | N/A | Required | Conditional/ Optional | Conditional/ Optional | Conditional/ Optional | N/A |
15 | |||||||||||
16 | Sponsored | ||||||||||
17 | Money received by the University from an external party to fund a sponsored project. Sponsored projects are governed by specific terms and conditions and are separately budgeted and accounted for in accordance with OMB Federal Regulations 2 CFR 200 (also known as Uniform Guidance), University policies governing sponsored projects, and/or the terms of the sponsoring entity. Sponsored funds may include money received to fund grants, contracts, and cooperative agreements for research, training, and other public service activities. | ||||||||||
18 | Fund | DeptID | Program | PCBU | Project | Activity | Account | FinEmplID | CF1 | CF2 | CS |
19 | Required | Required | N/A | Required | Required | Required | Required | Conditional/ Optional | Conditional/ Optional | Conditional/ Optional | N/A |
20 | |||||||||||
21 | Cost Share | ||||||||||
22 | The portion of the sponsored project’s costs that are not paid for by the sponsor. The University (department) typically pays for these costs via a non-sponsored funding source. | ||||||||||
23 | Fund | DeptID | Program | PCBU | Project | Activity | Account | FinEmplID | CF1 | CF2 | CS |
24 | Required | Required | Required | Required | Required | Required | Required | Conditional/ Optional | Conditional/ Optional | Conditional/ Optional | Required |
25 | |||||||||||
26 | Controller's Office | Financial Training • controller.umn.edu/training | 1/8/21 | |||||||||
27 | Financial Helpline: 612-624-1617 or controller@umn.edu |