ABCDEFGHIJK
1
This worksheet provides an overview of the Financial System General Ledger ChartFields. The data begins at cell A3. COA Google Sheet Tips
2
Financial System General Ledger ChartFields
3
FundDeptIDProgram PCBUProjectActivityAccountFinEmplIDCF1CF2CS
4
(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 (which aligns with a function), for example, credit instruction, outreach. Program is required whenever Project is not applicable. Alphanumeric 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 alphanumeric) 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
5
Required AllRequired AllRequired Non-Sponosred and Cost ShareRequired Sponsored and Cost ShareRequired Sponsored and Cost ShareRequired Sponsored and Cost ShareRequired AllConditional/ OptionalConditional/ OptionalConditional/ OptionalRequired Cost Share
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
Non-sponsored
9
FundDeptIDProgramPCBUProjectActivityAccountFinEmplIDCF1CF2CS
10
✓ Required✓ Required✓ RequiredN/AN/AN/A✓ RequiredConditional/
Optional		Conditional/
Optional		Conditional/
Optional		N/A
11
Sponsored
12
FundDeptIDProgramPCBUProjectActivityAccountFinEmplIDCF1CF2CS
13
✓ Required✓ RequiredN/A✓ Required✓ Required✓ Required✓ RequiredConditional/
Optional		Conditional/
Optional		Conditional/
Optional		N/A
14
Cost Share
15
FundDeptIDProgramPCBUProjectActivityAccountFinEmplIDCF1CF2CS
16
✓ Required✓ Required✓ Required✓ Required✓ Required✓ Required✓ RequiredConditional/
Optional		Conditional/
Optional		Conditional/
Optional		✓ Required
17
Controller's Office | Financial Training • controller.umn.edu/training
18
Financial Helpline: controller@umn.edu