Texas Tech University Health Sciences Center

1. Texas Tech University Health Sciences Center Finance And Administration Banner Chart of Accounts

2. Agenda • Chart of Accounts Development • Proposed HSC Chart of Accounts for Banner Financials • FOAPAL Elements • FOAPAL Level Descriptions • FOAPAL Hierarchy • TFIM to Banner Comparison • Banner Project Testing and Implementation

3. Chart of Accounts Development • Jan/Feb 2006 – Business Affairs and Budget teams ask administrators for reporting needs, both current and future. • March 2006 – Email to Banner Finance subscribers list requesting end user reporting or process input. • May/June 2006 – Core Finance team attends Banner Chart of Accounts training. • Jul/Oct 2006 – Chart of Accounts team develops first draft of Chart of Accounts.

4. Chart of Accounts Development • Oct 2006 – COA team presents proposed COA to representatives from the Schools of Medicine, Nursing, Allied Health, Pharmacy and Graduate School with break out sessions to discuss issues, concerns and requests feedback from attendees for departmental organization and reporting needs.

5. Chart of Accounts Development • Nov 2006 – COA team presents Chart of Accounts to the School of Medicine’s Administrators Group meeting. The team asks for input and suggestions. • Jan 2007 – COA team presents Chart of Accounts at the Finance and Administrator’s Quarterly Update meeting and asks for input and suggestions.

6. Chart of Accounts Development • Feb 2007 – COA team travels to Regional Centers and presents Chart of Accounts followed by discussion of reporting and organizational needs. • Feb/Mar 2007 – First load of HSC proposed Chart of Accounts and initial testing of hierarchy and reporting roll-up. • Mar/April 2007 – Data entry and system assurance testing.

7. Questions?

8. What is a Chart of Accounts? • Numerical elements that represent information that is similar to TechFIM account numbers, Object / Subobject Codes, Revenue Source / Subrevenue Source Codes and Balance Sheet Accounts. • Composed of six elements: Fund, Organization, Account, Program, Activity and Location (FOAPAL).

9. Chart of Accounts H - TTUHSC T - TTU S - TTUSA F O A P A L Field size / Levels Fund Net asset – what is owned – who owns 6 5 Organization Org chart – Div - Department - who spends 6 8 Account Asset, liability, fund balance, revenue, expense 6 4 Program Function – instruction, acad. support, research 6 5 Activity Inter-fund or cross institutional activities 6 0 Location Fixed asset tracking 6 5

10. Fund Hierarchy 1 Fund Class General 10 2 Division Allied Health 10A 3 Campus Lubbock 10A1 4 Department Administration 101AA 5 Sub-Department Graduate Tuition 101001 T1 NACUBO Unrestricted 10 T2 Fund Category E & G 1A

11. Fund Hierarchy 10 – E & G (Fund Class) • 10A – E & G SOAH (Division) • 10A1 – E & G SOAH Lbk (Campus) • 101AA – E & G AH Admin Lbk (Dept) • 101001 – AH Graduate Tuition • 101002 – CSSM Education • 101003 – CPM Education • 101PT – E & G Physical Therapy Lbk • 101122 – Physical Therapy • 101123 – SCD/PT

12. Organization Hierarchy 1 Institution TTUHSC H 2 Division Nursing H35 3 Campus Lubbock H351 4 Sub-division Nursing Lbk 3510 5 Department Administration 35160 6 Sub-department 1 Support Svcs 351600 7 Sub-department 2 IT support 351601 8 Not used -

13. Organization Hierarchy H35 – School of Nursing (Div) • H351 – School of Nursing Lbk (Campus) • 3510 – School of Nursing Lbk (Sub-div) • 35160 – SON Administration Lbk (Dept) • 351600 – Support Services Lbk (Sub-Dept 1) • 351601 – IT Support Lbk • 351602 – Faculty Development Lbk • 351603 – Outcomes Management Lbk • 351640 – Endowments and Scholarships • 351641 – Student Scholarships • 351644 – Professorships Practiceships

14. Account Hierarchy 1 Reporting level 1 Travel 705 2 Reporting level 2 In-state 7050 3 Reporting level 3 Public Trans 77101 4 Reporting level 4 Auto Rental 705000 T1 Reporting type 1 Expenses 70 T2 Reporting type 2 Travel 7B

15. Account Hierarchy 70 - Expenses • 7B - Travel • 705 - Travel • 7050 - In State • 77101 – Public Transportation • 705000 - Auto Rental • 705001 - Airfare • 705003 - Taxi • 77106 – Meals and Lodging • 705010 – Meals • 705011 – Lodging

16. Program Hierarchy 1 NACUBO Function Research 20 2 NACUBO Function Research 200 3 NACUBO Function Research 2000 4 NACUBO Function Research 20000 5 Not used -

17. Program Hierarchy • 10 – Instruction • 100 – Instruction • 1000 – Instruction • 10000- Instruction • 20 – Research • 200 – Research • 2000 – Research • 20000 – Research • 30 – Public Service • 300 – Public Service • 3000 – Public Service • 30000 – Public Service

18. Activity Hierarchy No Hierarchy

19. Location Hierarchy 1 Entity TTUHSC 2 Campus Lubbock 3 Building HSC 4 Floor Second 5 Room 2C174

20. Location Hierarchy • 10 – TTUHSC • 100 – Lubbock • 1001 TTUHSC Main Bldg Lbk • 10010 – TTUHSC Main Bldg Lbk Basement • 100100 – TTUHSC Main Bldg Lbk Bsmnt BA100 • 100110 – TTUHSC Main Bldg Lbk Bsmnt BA110 • 10011 – TTUHSC Main Bldg Lbk1st Floor • 100111 – TTUHSC Main Bldg Lbk 1st Fl 1C100 • 100115 – TTUHSC Main Bldg Lbk 1st Fl 1C105

21. TechFIM to Banner Comparison TechFIM XXXX XX XXXX Fund Area Orgn Banner XXXXXX XXXXXX Fund Orgn

22. TechFIM to Banner Comparison TechFIM XX XXXX XX XXXX Object Sub Revenue Sub Code Object Source Revenue Banner XXXXXX Account

23. Banner Fund, Orgn and Program codes contain the same information that is defined in the following TechFIM Tables • FUND • FUNG • FCAT • FDCL • FTYP • DIVN • COLL • DEPT • RAHC • AREA • ORGN • FUNC • FTCP • PCAT

24. Questions?

25. Banner Project Implementation • Finance Testing • COA 1st Load – March/April 2007 • COA 2nd Load, Finance Processes – May 2007 • Research Accounting Processes – Summer 2007 • Fixed Assets Processes – Summer 2007 • Budget Processes – Summer 2007 • Security, Roles, Rule Groups, Approval Queues – Fall 2007 • Finance Training • Spring / Summer 2008

26. Banner Project Implementation • Go Live for Finance – September 2008 (FY 2009) • Go Live for Student – October 2008 (Application and Enrollment for Spring 2009) • Go Live for HR / Payroll – December 2008 (January 1, 2009 Payroll from Banner)

27. Banner Project Information • www.texas.tech.edu/connectech/ • Application Suite • Project Timeline • Milestones • FAQs • www.fiscal.ttuhsc.edu/bannerfinance/ • Subscriber’s List • Newsletter • Training Documents • Comments

28. Banner Contacts • Mike Crowder: mike.crowder@ttuhsc.edu • Carole Wardroup: carole.wardroup@ttuhsc.edu • Penny Harkey: penny.harkey@ttuhsc.edu • Lesley Wilmeth: lesley.wilmeth@ttuhsc.edu • Patty Conner: patty.conner@ttuhsc.edu • Laree Bomar: laree.bomar@ttuhsc.edu • Denise Sober: denise.sober@ttuhsc.edu

29. Questions?