CHART OF ACCOUNTS CAMPUS USER TRAINING MANUAL

You don't have the latest version of Adobe Flash Player.

Please update your flash player.

Please login or register to make a comment!

...Description...... more. less.

9s the Difference?.................................... 31 4. UNCG Budget Queries Versus FGIBDST Versus FGIBAVL........................... 33 F. FTIFATA Form - Signature Authority and ........................................................... 34 Other Fund Attributes ............................................................................................. 34 G. Exercises................................................................................................................... 40 OVERVIEW After months of hard work, the Banner Finance project team is preparing for the campus- wide roll-out of the SunGard Higher Education Banner Finance System. The scheduled go- live date is July 1, 2006. Banner Finance replaces UNCG 9s current financial system (FRS), which has been in place for more than twenty years. Banner Finance will be integrated with our existing Banner Student, Financial Aid, and Alumni systems. Users will notice improvements in the effectiveness of financial processing across campus. Once in place, the Banner Finance System will replace existing financial system applications, which include general accounting, capital accounting, budgeting, requisitioning and purchasing, accounts payable and cash disbursements, fixed assets and bar coding, reporting, and multiple interfaces with other administrative system applications. The UNCG Banner Finance Overview 3 Chart of Accounts workbook purpose is to educate campus users on the new system. Comparisons between FRS and Banner, crosswalks between different components of the two systems and a glance at Banner Fund attributes are just a few of the items we want to share with you in this workbook. In this workshop, you will learn the Banner Finance basics! What is a FOAPAL? Why is the Chart of Accounts so important in Banner? What are the relationships between FRS and Banner Finance - the good, the bad and the ugly! Do I have an FRS account in Banner? How do I find my FRS equivalent account in Banner? In FRS, I use screens - what forms will I use in Banner Finance? Come join us for a scavenger hunt through Banner Finance to answer all of these questions and more. Don't forget - this workshop is a pre-requisite to all of the other Banner Finance Workshops!! Key of Banneropoly icons used through out this workbook: Caution Info Reminder Idea 4 A. Banner Finance Databases - Overview At UNCG, multiple Banner databases exist. These databases include BANPRD (production or live data), UGVAL7 (Training database for Go-Live Banner Finance Training) and UGVAL3 (pre-production database). During this training workshop today, you will be in UGVAL7. After September 1, 2006, training will most likely occur in another database. The data in UGVAL7 is similar to the data in BANPRD but it is not the same data. UGVAL7 is a cpoint in time d or snapshot of the data in BANPRD as of June 30, 2005. Many fund, org and other chart of account changes may have occurred since June 30, 2005. These changes will probably not exist in UGVAL7 but should exist in BANPRD. BANPRD is being updated on a regular basis to reflect the changes that have occurred in FRS since June 30, 2005. If you have any questions about the data in BANPRD or UGVAL7, please send these questions to finance@uncg.edu . Currently, you cannot see the data in BANPRD with the crosswalks illustrated in this workbook. These crosswalks point only to UGVAL7. 5 B. BANNER CROSSWALKS in UGVAL7 1. Overview How do I find my Banner Finance equivalent to my FRS account? Where do I find my new FRS object code in Banner? What is an Org Code? As part of implementing Banner Finance at UNCG, we have developed some pretty nifty tools to help you crosswalk information from FRS to the new Banner equivalent components in the new system. At this point in time, four crosswalks exist that you can access from the internet: 1 FRS to BANNER Crosswalks 3 UNCG 2 BANNER to FRS Crosswalks 3 UNCG 3 BANNER FUND BY ORG CODE 4 FRS to BANNER Crosswalks 3 All Charts As Banner Finance is rolled out to the campus community, we hope to create additional cpublic d tools for our campus users. 6 2. Finding the Banner Crosswalks on the Internet Three ways exist to get to the Banner Crosswalks in UGVAL7: 1) If you are viewing this file as a PDF, click on Banner Crosswalks or 2) Type the following in the Microsoft Internet Explorer browser http://prdwebfoc2.uncg.edu/ibi_apps/Controller?WORP_REQUEST_TYPE= WORP_INIT_VIEW&WORP_MPV=public& or 3) Follow this path in Microsoft Internet Explorer: a. Type in following in the Microsoft Internet Explorer browser http://prdwebfoc2.uncg.edu/ibi_apps/homepage.jsp then b. click on Business Intelligence Dashboard Public Views c. click on General Public View d. choose your crosswalk selection 7 3. FRS to Banner Crosswalks - UNCG The FRS to Banner Crosswalks - UNCG lists all of major components of the Banner Finance chart of account elements by FRS components. This is one of the most useful crosswalks available to campus users. Use this Comparison Chart and the FRS to Banner Crosswalks 3 UNCG tool to find your Banner Chart of Account (COA) Codes. 1) Click on FRS to Banner Crosswalks - UNCG 8 3. FRS to Banner Crosswalks 3 UNCG, cont. 2) From the ELEMENT drop down box, choose FRS ACCOUNT, FRS DEPARTMENT, FRS OBJECT CODE 3 GL or FRS OBJECT CODE 3 SL depending on which FRS number you want to crosswalk to the Banner Finance COA code. 3) Enter the FRS number in the FRS CODE (DEPENDS ON SELECTION ABOVE) box. In the example below, we are querying on the FRS Account number 201275 to find the Banner Fund Code. 9 3. FRS to Banner Crosswalks - UNCG, cont. 4) At the bottom of your parameter window, you have several options. a. The button runs the query and returns the element(s) requested. b. The button refreshes the form so that a new query or request can be entered. c. The button clears the data on the right side of the form. d. The button runs the output data in a new window. Check the button first, then click on the button to run the query in a new window. The best way to quickly print the output of a query is to run the query as HTML and then follow step d. above. Next, go under Page Setup under the File menu, and choose landscape under the Orientation box near the bottom left. Click OK. Unfortunately, on all pages after page 1, the report title will not always print at the top. If you have pop-blockers enabled, hold the <Ctrl> key and then click on the execute query button 10 a. FRS Account to Banner Fund Code Example 5) A sample of the output of the query for FRS account 201275 looks like: From this example, the Banner Fund Code is 110044 Biology and is the equivalent to the FRS Account number 201275 Biology. 6) The Effective Date is the date that the fund code can be used in the system for transactions. For all funds that were cmigrated d over from FRS, an effective date of 7/1/1990 was used to specifically identify this data. When new funds are set up in BANPRD, the effective date will be July 1 plus the fiscal year of the new fund creation. For example, if a request for a new fund is dated 10/01/2006, the effective date for this fund will be 2006/07/01. What is the effective date of a new fund requested from a department to Accounting Services on 2/1/2007? The effective date is 2006/07/01. 7) The BANNER Chart of Accounts code G is for UNCG. This is the chart code that the majority of campus will use. Other Chart of Accounts codes exist in BANPRD but these codes are reserved for Foundations. 8) BANNER Status of A indicates this Fund is active. If the status is an cI d then the Fund is inactive and no transactions can occur in the system against this fund. 11 b. FRS Department to Banner Org Code Example 1) From the ELEMENT drop down box, choose FRS DEPARTMENT. Next enter 225 in the FRS CODE (DEPENDS ON SELECTION ABOVE) box. 2) Hit the <Enter> key or the button. A sample of the output of the query for FRS Department 225 looks like: a. From this example, the Banner Org code is 12001 Dean 9s Office School of Education for FRS Department number 225. 12 c. FRS Object Code - SL to Banner Account Code Example 1) From the ELEMENT drop down box, choose FRS OBJECT CODE - SL. Next enter 3% in the FRS CODE (DEPENDS ON SELECTION ABOVE) box. This query will list all of your Banner Account equivalents to FRS Object Codes 3 SL 3XXX. 2) Hit the <Enter> key or the button. A sample of the output of the query for FRS object Code 3% looks like: Notice the column BANNER Pool. This is similar to an FRS Budget Pool. The similarities and differences between FRS Budget Codes and Banner Finance Pool Account codes will be taught in the Banner Finance Budget Overview Workshop. 13 4. BANNER to FRS Crosswalks - UNCG The BANNER to FRS Crosswalks - UNCG lists all of major components of FRS by the Banner chart of account elements. There may be times when you want to see your FRS equivalent of a Banner COA Element. Again, the chart below may be helpful in remembering the relationship between FRS and Banner Finance. 1) Click on BANNER to FRS Crosswalks - UNCG 14 4. BANNER to FRS Crosswalks 3 UNCG, cont. 2) From the ELEMENT drop down box, choose BANNER FUND, BANNER ORG, BANNER ACCOUNT 3 GL, BANNER ACCOUNT - SL depending on which Banner Finance COA code you want to crosswalk to which FRS number. 3) Enter the Banner Fund code in the BANNER CODE (DEPENDS ON SELECTION ABOVE) box. In the example below, we are querying on the Banner Fund Code 110044. We want to find the FRS Account number equivalent. 15 4. BANNER to FRS Crosswalks 3 UNCG, cont. 4) At the bottom of your parameter window, you have several options. a. The button runs the query and returns the output. b. The button refreshes the form so that a new query or request can be entered. c. The button clears the data on the right side of the form. d. The button runs the output data in a new window. Check the button first, then click on the button to run the query in a new window. The best way to quickly print the output of a query is to run the query as HTML and then follow step d. above. Next, go under Page Setup under the File menu, and choose landscape under the Orientation box near the bottom left. Click OK. Unfortunately, on all pages after page 1, the report title will not always print at the top. If you have pop-blockers enabled, hold the <Ctrl> key and then click on run query button. 16 a. Banner Fund Code to FRS Account Example 5) A sample of the output of the query for Banner Fund code 110044 is FRS Account 201275 Biology. 6) The Effective Date is the date that the fund code can be used in the system for transactions. For all funds that were cmigrated d over from FRS, an effective date of 7/1/1990 was used to specifically identify this data. When new funds are set up in BANPRD, the effective date will be July 1 plus the fiscal year of the new fund creation. For example, if a request for a new fund is dated 10/01/2006, the effective date for this fund will be 2006/07/01. What is the effective date of a new fund requested from a department to Accounting Services on 2/1/2007? The effective date is 2006/07/01. 7) The BANNER Chart of Accounts code G is for UNCG. This is the chart code that the majority of campus will use. Other Chart of Accounts codes exist in BANPRD but these codes are reserved for Foundations. 8) BANNER Status of A indicates this Fund is active. If the status is an cI d then the Fund is inactive and no transactions can occur in the system against this fund. 17 b. Banner Org to FRS Department Example 1) From the ELEMENT drop down box, choose BANNER ORG. Next enter 12001 in the BANNER CODE (DEPENDS ON SELECTION ABOVE) box. 2) Hit the <Enter> key or the button. A sample of the output of the query for Banner Org Code 12001 looks like: a. From this example, the Banner Org code is 12001 Dean 9s Office School of Education for FRS Department number 225. 18 c. Banner Account - SL Code to FRS Object Code Example 1) From the ELEMENT drop down box, choose BANNER ACCOUNT - SL. Next enter 223% in the BANNER CODE (DEPENDS ON SELECTION ABOVE) box. This query will list all of your FRS Object Code equivalents to Banner Account Codes 223XXX. 2) Hit the <Enter> key or the button. A sample of the output of the query for SL Banner Accounts 223% looks like: Notice the column BANNER Pool. This is similar to an FRS Budget Pool. The similarities and differences between FRS Budget Codes and Banner Finance Pool Account codes will be taught in the Banner Finance Budget Overview Workshop. 19 5. BANNER FUND BY ORG CODE CROSSWALK The BANNER FUND BY ORG CODE CROSSWALK lists all of your Banner Funds by Organization (Org) Code. Remember, in Banner, the Org Code is similar to the department number in FRS. For Example, FRS department number 100 Office of the Provost is equivalent to Banner Org Code 10101 Office of the Provost. In another example, department 525 Office of Accounting Services is equivalent to org code 56202 Accounting Services. In order to use this crosswalk, you must know the Banner Org code first. If you don 9t know your Banner Org Code, use the FRS to BANNER Crosswalk 3 UNCG , choose FRS DEPARTMENT under the ELEMENT drop-down menu and then enter your FRS department number in the FRS CODE (DEPENDS ON SELECTION ABOVE]. Write down your Banner org code, return to BANNER FUND BY ORG CODE CROSSWALK and follow the instructions below: 1) Click on BANNER FUND BY ORG CODE 20 5. BANNER FUND BY ORG CODE CROSSWALK, cont. 2) Now Enter your Org Code. In this example, our org code is 10101 3 Office of the Provost 3) Don 9t forget, you can choose your display output as HTML, PDF, EXCEL 2000 or EXCEL Formula. Play around with the different outputs. 21 5. BANNER FUND BY ORG CODE CROSSWALK, cont. 4) At the bottom of your parameter window, you have several options. a. The button runs the query and returns a list of funds with the chosen org code. b. The button refreshes the from so that a new query or request can be entered. c. The button clears the data on the right side of the form. d. The button runs the output data in a new window. Check the button first, then click on the button to run the query in a new window. The best way to quickly print the output of a query is to run the query as HTML and then follow step d. above. Next, go under Page Setup under the File menu, and choose landscape under the Orientation box near the bottom left. Click OK. Unfortunately, on all pages after page 1, the report title will not always print at the top. You can also run this query in Excel 2000 or Excel Formula. Save the file and then manually format the file for printing. Don 9t forget PDF is also an option. If you have pop-blockers enabled, hold the <Ctrl> key and then click on the run query button. 22 5. BANNER FUND BY ORG CODE CROSSWALK, cont. 5) A sample of the output of the query for Org code 10101 looks like: 6) The Effective Date is the date that the fund code can be used in the system for transactions. For all funds that were cmigrated d over from FRS, an effective date of 7/1/1990 was used to specifically identify this data from new funds set up in the system after July 1, 2006. When new funds are set up in BANPRD, the effective date will be July 1 plus the fiscal year of the new fund creation. For example, if a request for a new fund is dated 10/01/2006, the effective date for this fund will be 2006/07/01. What is the effective date of a new fund requested from a department to Accounting Services on 2/1/2007? The effective date is 2006/07/01. 7) The Next Change Date is an indicator of changes made to chart of account elements in the system. The Next Change Date of 2099/12/31 indicates that this is the most current record in Banner Finance. 8) This Banner Fund was migrated from FRS and no new changes have been made to this fund since it was migrated from FRS to Banner Finance. 23 C. LOGIN INTO UGVAL7 Follow the steps below to log into the UGVAL7 database: 1. Login into the UNCG Network using your Novell username and password. All of computers in the training labs are set up to prompt you to login at the start up of the machines. 2. Once you have logged into Novell, click on Microsoft Internet Explorer icon: 3. Click on Internet Banner Access or enter X:\BannerAccess\BannerAccess.html in the address toolbar in Internet Explorer. (Note: X:\BannerAccess\BannerAccess.html is a temporary website) 4. We are going to click on UGVAL7 in the Non-Production Banner Environments (Note: You may have to hold the CTRL key when clicking on UGVAL7 if pop-ups are blocked or better yet, turn your blockers off) 24 C. LOGIN INTO UGVAL7, cont. 5. The next window looks like: 6. Click on INB Forms 7. Wait a moment for the program to load. 25 C. LOGIN INTO UGVAL7, cont. 8. A Logon box will appear 3 " Enter your UGVAL7 Username; press TAB . " Enter your Password. " Leave Database field blank. " Click on Connect or hit Enter key. The Banner username and password are not the same as your Novell username and password. The username may be the same as your Novell account but the passwords are separate and distinct; changing one will not automatically change the other. You may also have different passwords for different Internet Native Banner (INB) databases. For example, your UGVAL7 password may or may not be the same as your BANPRD password. The GUAPSWD form is where the database password is reset. 26 C. LOGIN INTO UGVAL7, cont. 9. Once you have logged in, the system will take you to the General Menu Form. Enter either the form name in the Go To&: box and then <Enter> or search for forms in the tree menu by double clicking on the cFinancial Systems [ *FINANCE] d folder. OR 10. Let 9s go play in the new system! 27 D. Index Code = Fund Code = Grant Code Banner Finance is a system full of codes, records, tables, etc& At UNCG, we decided to populate another table called FTMACCI or Account Index to facilitate data entry from a campus user perspective. With an account index code - the fund, org and program codes are automatically defaulted for any transaction in the system. How do you know what your account index code is? The account index is equal to the fund code. The fund code is currently also the same as the grant code. At UNCG, we use the Account Index to populate the Fund, Org and Program code. Even though this is called an Account Index, the Index is actually equal to the fund; therefore, we call this the Index or Index code. For all transactions including purchase orders, invoices and Journal Vouchers, all you need to know is the Index/Fund Code and the Banner Account Code. In FRS, you needed a FRS Account and FRS Object Code for a transaction. Even though Banner Finance requires up to a 36 character string record (FOAPAL), with the use of the index, you only have to know your Banner Index/Fund and Account Code. As we navigate through some of the most popular forms in Banner, we will use the Index for our queries. Notice how the Index defaults in Org and Program. Also, don 9t forget Banner 9s Account Logic: 28 E. Fund Inquiry Forms in Banner Finance 1. FGIBDST (Organization Budget Status) Form 3 Like Screen 19 in FRS The FGIBDST (Organization Budget Status) Form is similar to Screen 19 in FRS. Below is a screenshot of FGIBDST for Banner Fund 117028. This form shows actual revenues and expenditures in the system. FGIBDST is also the form where you can query on specific transactions that have posted to individual funds. Click on the account code you want to query transactions in the bottom block of the form. Next, click on the Options tab near the top, left of the Oracle window and choose cTransaction Detail Information [FGITRND] d listing. 29 2. FGIBAVL (Budget Availability Status) Form 3 Be Careful!! The FGIBAVL (Budget Availability Status) Form is similar to Screen 19 in FRS and Banner Form FGIBDST except for one major difference. FGIBAVL shows actual revenues and expenses that have posted to the system and shows how much budget has been allocated to pending transactions in the system. This is very different than FRS. Below is a screenshot of FGIBAVL for Banner Fund 117028. Notice this form is very similar to numbers in the FGIBDST form. At this point in time, there are no pending transactions in the system for Fund 117028 so the totals on the forms look alike. For the account code, always enter 101010 on the form FGIBDST to see all the account codes with activity in the Fund. You can also limit the account codes you view on this form based on your Account code query. For example, if you entered 140210 for the account code on this fund, you would not see activity for account codes 101010, 101110 or 101210 but you would see activity for all of the sequential account codes after 140210. 30 3. FGIBDST Versus FGIBAVL - What 9s the Difference? So how is the FGIBDST form different from the FGIBAVL form? If a requisition has been started in the system but has not been completed then the FGIBAVL form will reflect this difference. This form shows how much of the budget pool is held or reserved for pending transactions. Here 9s the kicker. If this purchase order stays in an incomplete or suspended state, you will not be able to use the budget that is being held from this transaction for other transactions. You must either complete the requisition or delete the requisition in order to get your budget dollars back. At UNCG, we plan on deleting suspended documents on a regular basis. A regular basis could be as quick as every three days or sooner depending on the month end schedule. Make sure your requisitions, Purchase Orders and other documents are not incomplete or suspended for longer than three days or it may be deleted. To learn more about requisition and purchase orders in Banner Finance, make sure you take our Banner Finance Purchasing Workshop. Other suspended documents that can creserve d or hold your budgets include incomplete or suspended Journal Vouchers (this is the same as a JE or Journal Entry in FRS), purchase orders and/or unpaid invoices. Let 9s look at an example for fund 110001 where a suspended JV has reserved $350.00 in telephone charges. This JV has been entered but has not been completed and is in a suspended or incomplete state. The Banner account code for FRS Object Code 3 SL 3220 Postal charges is 234210 and belongs to Banner Budget Pool 234000. After this JV is suspended, FGIBDST and FGIBAVL will look different for this object code 234210. See the next page for the comparison between FGIBDST and FGIBAVL for fund 110001 with a suspended or pending JV of $350.00 in a telephone charge. A budget of $500.00 had been entered for Purchased Services Budget pool account 230000 in this example. Below shows the JV that is in suspense: 31 3. FGIBDST Versus FGIBAVL - What 9s the Difference?, cont. Below is a comparison between FGIBDST and FGIBAVL for fund 110001 with a suspended or pending JV of $350.00 in a telephone charge. A budget of $500.00 had been entered for Purchased Services Budget pool account 230000 in Banner. The FGIBDST form does not reflect the pending transaction of $350.00 since this transaction has not posted to the system. FGIBDST form However, look at FGIBAVL form below. The FGIBAVL form tells a different story. Even though this charge has not been posted to the system, the budget for fund 110001 is reserved based on the incomplete transaction. The department only has $150.00 available for spending not the $350.00 as reflected on the FGIBDST form. The only way the department can have the 230000 budget account balance available for spending, again, is if the JV is deleted. If the JV is completed successfully and posts to the system, then the FGIBAVL form will once again look like the FGIBDST form. FGIBAVL form 32 4. UNCG Budget Queries Versus FGIBDST Versus FGIBAVL At UNCG, we have developed an application in Self Service or UNCGenie called UNCG Budget Queries. This budget query shows all of your budget pools and available balances and is similar to the FGIBDST form except better because it shows you remaining budget balances. However, this query does not show reserved or held budget pools from suspended documents. What you see in this query may not reflect your available balance in the system. Below is what the query for Fund 110001 for Budget pool 230000 shows as available in UNCGenie: However, FGIBAVL only reflects $150.00 available for expenditures. The department will only be able to spend $150.00, not the $500.00 the above query shows because of the suspended JV in the system. Make sure you attend Banner Finance Budget Overview and UNCGenie 3 Bringing It All Together to learn about UNCG Budget Queries. This is one of the most powerful features of Banner Finance. In this application, you can drill down to see you documents, export the information to MS Excel and custom create queries for multiple funds based on org codes. 33 F. FTIFATA Form - Signature Authority and Other Fund Attributes In FRS, characteristics associated with FRS accounts are entered on various screens. These characteristics are called attributes. For example, FRS account 270525 has attributes on screen 006 that indicate this is a state account with a budget code of 16040 and it has a short title. Responsible person(s) are also listed on screen 006. Of course, it is this field that gives an account holder signature authority for expenditures in FRS. In FRS, the responsible person fields are so many characters wide. As long as you can fit a name(s) in the fields, you can identify responsible persons for the FRS account. In Banner Finance, attributes also exist but look much different. These attributes are also attached to the fund code. Attributes are pre-defined in Banner and only three responsible persons or signature authority email addresses can be attached to a fund at one time. The fund attributes also indicate whether or not a fund is a state or a trust fund. Lots of other attributes are also attached to funds in Banner. Let 9s go explore the world of attributes in Banner Finance. You will use the Form FTIFATA. First, using the crosswalks, find the Banner Fund for FRS Account 270525. The Banner Fund is 117028 Accounting Services. Below is a screen shot of the Banner Form FTIFATA 9s top block. Before you cblock next d, a decision needs to be made. Do you want to query cBy Attribute Types d or query cBy Sets of Attribute Types d. My personal favorite is cBy Sets of Attribute Types d. The cBy Attribute Types d is the defaulted value, so you must click the cBy Sets of Attribute Types d for this query example: 34 F. FTIFATA Form - Signature Authority and Other Fund Attributes , cont. Now, block next. Ways to block next include: 1) <Ctrl><Page Down> (hold the <Ctrl> key and toggle with your middle finger on the <Page Down> key) 2) Click on the block next icon at the top of the Banner toolbar: 3) Click on the Next under the Block title on the menu bar: In the Fund Code cell, type 117028 and the hit the <F8> key. <F8> queries all of the attributes associated with the fund code 117028. This is screen shot of FTIFATA for Fund 117028 in the cBy Sets of Attribute Types d query mode: 35 F. FTIFATA Form - Signature Authority and Other Fund Attributes , cont. Notice in the top block of this form, the row with Fund Code 117028 and Set Code AUTHORIT is highlighted. If you look in the bottom block, then you will see how responsible persons are listed. Can you identify the two responsible persons for Fund 117028? At UNCG, responsible person information includes the job description of the responsible person and email address. Who are the three responsible persons for Fund Code 110001 Office of the Provost? 36 F. FTIFATA Form - Signature Authority and Other Fund Attributes , cont. Let 9s look at other fund attributes for Fund 117028. To enter a new fund to query, click on the roll back button at the top of the form. Enter Fund Code 117028 and hit the <F8> key. Use the down arrow key to highlight the Set Code BUDGET row. In the bottom block, the Attribute Value of P is indicated. This fund is budgeted by pool accounts. 37 F. FTIFATA Form - Signature Authority and Other Fund Attributes , cont. Use the down arrow key and highlight the row for Set Code ENDOW. No Endowment attributes exist for this fund. Use the down arrow key and highlight the row for Set Code GENERAL. 38 F. FTIFATA Form - Signature Authority and Other Fund Attributes , cont. Now, let 9s query on Fund Code 117028 using the cBy Attribute Types d selection: 1) To enter a new fund to query by, click on the roll back button at the top of the form. 2) Block Next 3) Enter Fund Code 117028 then <F8> 4) This query shows all of the Attributes for Fund 17028 cBy Attribute Types d in Set Code Order. Fund Code 110001 attributes cBy Attribute Type d selection: 39 G. Exercises Questions Chapter? 1. Is the data in UGVAL7 the same as in BANPRD? A. Banner Finance Databases - Overview 5 2. What is the difference? A. Banner Finance Databases - Overview 5 3. Which database has the most up-to-date COA elements. A. Banner Finance Databases - Overview 5 4. Go find the Banner Fund and Title of an FRS Account you use on a regular basis. If you don't have an FRS account, find the Banner Fund for FRS Account 550110. C. BANNER CROSSWALKS in UGVAL7 10 5. How would you find all of the Banner Funds associated with FRS Accounts 5XXXXX using the crosswalks? Which crosswalk would you use? List the first 3 Banner Funds that crosswalk to these FRS accounts. C. BANNER CROSSWALKS in UGVAL7 10 6. Are the Banner Funds that start with 11XXXX state funds or trust funds? How did you know that? C. BANNER CROSSWALKS in UGVAL7 10 40 G. Exercises, cont. 7. What are the first 6 Funds that belong to Org Code 10101? C. BANNER CROSSWALKS in UGVAL7 10 9. What is the index code for FRS account 321520 D. Index Code = Fund Code = Grant Code 28 10. What is the index code for Banner Fund 110001? D. Index Code = Fund Code = Grant Code 28 11. What are the other COA elements that Index Fund is equivalent to in Banner Finance? D. Index Code = Fund Code = Grant Code 28 12. Name the three most popular forms you can inquire on the Index or Fund Code in Banner? E. Fund Inquiry Forms in Banner Finance 29 13. What is the difference between FGIBDST and FGIBAVL? E. Fund Inquiry Forms in Banner Finance 29 14. Why would a difference exist between FGIBDST and FGIBAVL. E. Fund Inquiry Forms in Banner Finance 29 15. What should you do if you notice a difference between FGIBDST and FGIBAVL? E. Fund Inquiry Forms in Banner Finance 29 16. Find a Banner Fund by your org and identify the responsible persons using the FTIFATA form. F. FTIFATA Form - Signature Authority and Other Fund Attributes 34 41

less