PeopleSoft Chartfield Prototype

1
PeopleSoft Chartfield Prototype

• Chart of Account
• Design

2
PeopleSoft Chartfield Prototype

• Chartfields
• Fund 5 digits
• Account 6 digits
• Department (Banner Org) 4 digits
• Program (Optional) 3 digits
• Class (Optional) 5 digits
• Project / Grant (Optional) 6 digits

3
Chart of Account DesignFund Chartfield

• General Fund (Structure)
• 1st 3rd Digits General Fund Type
• 100 General Fund Expense
• 101 General Fund Revenue Transfer-In
• 102 General Fund Reimbursed Activities
  Expense
• 103 General Fund Reimbursed Activities
  Revenue
• 4th 5th Digits Fiscal Year
• 01 Fiscal Year 2001-02
• 02 Fiscal Year 2002-03

4
Chart of Account DesignFund Chartfield

• General Fund (Examples)
• 10002 General Fund Expense 2002-03
• 10001 General Fund Expense 2001-02
• 10102 General Fund Rev Trans-In 2002-03
• 10101 General Fund Rev Trans-In 2001-02
• 10202 General Fund Reimb Act Exp 2002-03
• 10201 General Fund Reimb Act Exp 2001-02
• 10302 General Fund Reimb Act Rev 2002-03
• 10301 General Fund Reimb Act Rev 2001-02

5
Chart of Account DesignFund Chartfield

• Higher Ed Fees (Structure)
• 1st 3rd Digits Higher Ed Fund Type
• 106 Higher Ed Transfer-Out
• 107 Higher Ed Fees Income
• 4th 5th Digits Fiscal Year
• 01 Fiscal Year 2001-02
• 02 Fiscal Year 2002-03

6
Chart of Account DesignFund Chartfield

• Higher Ed (Examples)
• 10602 Higher Ed Transfer-Out 2002-03
• 10601 Higher Ed Transfer-Out 2001-02
• 10702 Higher Ed Fees Income 2002-03
• 10701 Higher Ed Fees Income 2001-02

7
Chart of Account DesignFund Chartfield

• Other Funds (Structure)
• 1st 3rd Digits CSU Fund
• 4th 5th Digits Sequentially assigned

8
Chart of Account DesignFund Chartfield

• Other Funds (Examples)
• SM CSU
• 18101 181 Continuing Ed Rev Fund
• 26301 263 Auxiliaries Facilities Rev
• 26401 264 Dorm Rev Student Union
• 31801 318 Trust 98 HECO 574
• 31802 318 Trust 98 Minor Cap
• 42401 424 Trust Cal Grants

9
Chart of Account DesignAccount Chartfield

• Account (Structure)
• 1st 3rd Digits Firms Object Code
• 4th Digit 8 Designates Campus Account
• 5th 6th Digits Sequentially assigned

10
Chart of Account DesignAccount Chartfield

• Account (Examples)
• 101001 General Cash
• 504801 Parking Permits Faculty/Staff
• 504802 Parking Permits Student
• 601201 Salaries MPP
• 601300 Salaries Support Staff
• 606001 Travel-In State
• 606002 Travel-Out of State

11
Chart of Account DesignDepartment Chartfield

• Department (Structure)
• 1st Digit Begins with 1
• 2nd 4th Digits Sequentially assigned

12
Chart of Account DesignDepartment Chartfield

• Department (Examples)
• 1034 College of Education Deans Office
• 1039 Extended Ed Deans Office
• 1043 Finance Business Services AVP
• 1051 Finance Admin Services VP
• 1084 Student Affairs Deans Office

13
Chart of Account DesignProgram Chartfield

• Program (Structure)
• 3 Digits Numerically Assigned

14
Chart of Account DesignProgram Chartfield

• Program (Examples)
• 101 Fall Semester
• 102 Winter Session
• 103 Spring Semester
• 104 Summer Session
• 105 Orientation
• 106 Training
• 107 Academic Personnel Development
• 108 Academic Advising

15
Chart of Account DesignClass Chartfield

• Class (Structure)
• 1st 3rd Digits Last three digits of Depart
• 4th 5th Digits Sequentially assigned

16
Chart of Account DesignClass Chartfield

• Class (Examples)
• Extended Education
• 03901 ExtEd CERF Exec Dev Program
• 03902 ExtEd Distance Learning
• 03903 ExtEd Non-Credit Administration
• 03904 ExtEd Non-Credit Programs
• College of Education
• 03401 COE Math Professional Dev Inst
• 03402 COE Prof Dev Inst English Lang
• 03403 COE Teacher Diversity Scholarship

17
Chart of Account DesignProject/Grant Chartfield

• Project/Grant (Structure)
• 1st Digit Designates Project or Grant
• 1 Project
• 2 Grant
• 2nd Digit Type of Project/Grant Program
• 3rd 6th Digits Sequentially assigned

18
Chart of Account DesignProject/Grant Chartfield

• Project Examples
• 11XXXX Major Capital Outlay
• 12XXXX Minor Capital Outlay
• 13XXXX Special Repair
• 14XXXX Deferred Maintenance
• 15XXXX Group II Equipment
• 16XXXX Miscellaneous

19
Chart of Account DesignProject/Grant Chartfield

• Grant Examples
• 21XXXX Faculty Development Grants
• 22XXXX Other Campus Grants
• 23XXXX PELL Grants
• 24XXXX Cal Grants
• 25XXXX SEOG Grant
• 26XXXX Cops Grants

20
Chart of Account DesignChartfield String

• Fund Account Dept Prog Class Project
• 10003 606001 1034
• 10003 660003 1034 03402
• 44101 601201 1039 101 03909
• 31001 607006 1117
  110004