02 - 022 General Coding Conventions
General Coding Conventions
-
All funds have 6 characters
-
Character value, see full description below:
- Campus designation in first character.
- Fund type designation in second character.
- Third character is campus designated
- For sponsored programs funds, the second and third character provide recognition of the sponsor (See Procedure 02-023 USNH Grant Fund Coding Conventions for more details).
- Be mindful that sort sequence will advantage/disadvantage users when using desktop applications (Excel) to manipulate down loaded data.
- Try to avoid data entry gremlins such as:
- # 0 vs. letter O
- # 1 vs. I vs. letter l
- E as the only character in the code, meaning all the other elements in the code are numeric (Excel thinks this is an exponential number)
- Thorough coding conventions, enable efficient Banner look-ups/queries (use of % for wildcarding)
Fund Coding Conventions by character
First character of the fund = Campus:
|
Value |
Campus |
|---|---|
|
1 |
University of New Hampshire - Durham (UNH) |
|
1 |
University of New Hampshire - Manchester (UNHM) |
| 1 | University of New Hampshire - School of Law (UNHL) |
|
4 |
University of New Hampshire - Foundation (UNHF) |
|
5 |
Keene State College (KSC) |
|
6 |
Plymouth State University (PSU) |
|
7 |
Granite State College (GSC) |
|
9 |
Chancellor's Office (SYS) |
|
|
Second character of the fund = Fund Group:
|
Value |
Fund Grouping |
|---|---|
|
U |
Educational and General Funds (E&G) |
|
D |
Internally Designated Funds |
|
A |
Auxiliary Funds |
|
00-9Z |
Sponsored Programs |
|
G |
Restricted Gift/Payout Funds |
|
L |
Loan Funds |
|
M |
Life Income and Annuity Funds |
|
N |
Net Invested in Plant |
|
Q |
Quasi Endowment Funds |
|
T |
True Endowment Funds |
|
X |
Unexpended Plant Funds |
|
Z |
Agency Funds |
|
BK |
Bank Fund (Banner Use Only) |
Third character of the fund = Campus Defined Values:
For UNH, the third character will represent RC unit for general funds, internally designated funds, auxiliary funds, and gift/payout funds:
|
Value |
BSC Unit |
|---|---|
|
A |
Academic Affairs |
|
B |
College of Life Sciences and Agriculture |
|
C |
College of Liberal Arts |
|
D |
College of Engineering and Physical Sciences |
|
E |
Peter Paul College of Business and Economics |
|
F |
College of Health and Human Services |
|
G |
Central Administration |
|
?H |
?UNH School of Law |
|
J |
Student Affairs |
|
K |
Computing and Information Systems |
|
L |
Library |
|
M |
UNH at Manchester |
|
Q |
Business Affairs |
|
R |
Research and Public Service |
|
S |
Intercollegiate Athletics |
|
T |
Facilities |
|
U |
Institutional |
|
X |
Cooperative Extension |
|
Z |
Institute of Earth, Oceans and Space (EOS) |
For KSC, the third character will represent major administrative unit for general funds, internally designated funds, auxiliary funds, and gift/payout funds:
|
Value |
KSC Area |
|---|---|
|
A |
Academic Affairs |
|
D |
Financial Aid |
|
E |
Executive |
|
F |
Finance and Planning |
|
G |
General Institutional |
|
H |
Arts and Humanities |
|
J |
Athletics |
|
L |
Library |
|
P |
Professional and Graduate Studies |
|
R |
Student Affairs and Enrollment Management |
|
S |
Sciences |
|
T |
Physical Plant |
For PSU , the third character will represent major administrative unit for general funds, internally designated funds, auxiliary funds, and gift/payout funds:
|
Value |
PSU Area |
|---|---|
|
A |
Academic Affairs |
|
B |
Administrative Services |
|
C |
College Relations |
|
F |
Financial Management |
|
G |
General Institutional |
|
H |
Intercollegiate Athletics |
|
I |
Graduate Studies & Community Outreach |
|
P |
President |
|
S |
Student Affairs |
|
T |
Student Activities Accounting |
GSC has chosen not to specify the use of the third character.
The official version of this information will only be maintained in an on-line web format. Any and all printed copies of this material are dated as of the print date. Please make certain to review the material on-line prior to placing reliance on a dated printed version.