{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Banner Forms","\"How To\""],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Banner Forms","index":0,"n_rows":154,"n_cols":6,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Form Name","Form Title ","Category ","Module ","Type ","Description/ What Can I Do With This Form"]
["FAICHKH","Check Payment History ","Form","Finance","Accounts Payable ","Displays summary information about check transactions. "]
["FAIINVE","Invoice/Credit Memo","Form ","Finance","Accounts Payable ","Allows you to view a BANNER invoice document, regardless of their completion, approval, or payment status."]
["FAIINVL","Invoice/Credit Memo","Form","Finance","Accounts Payable ","Provides a list of invoice transactions by status (Open, Paid, Suspense, Hold). "]
["FAIOINF","Open Invoices by FOAPAL","Form","Finance","Accounts Payable ","Allows user to view open invoices by budget or FOAPAL (fund, organization, account, program, activity, and location). "]
["FAIVHIS","Vendor History Query ","Form ","Finance","Accounts Payable ","Allows user to display and filter invoice/credit memo history information for a selected vendor by fiscal year. "]
["FAIVNDH","Vendor History Detail","Form ","Finance","Accounts Payable ","Provides an online list of vendor invoice/credit memo/payment transactions for all vendors in the system (includes terminated vendors). "]
["FGAENCB ","General Encumbrance Maintenance  ","Form ","Finance","Encumbrances","Form used to create a general encumbrance. "]
["FGAENCB ","General Encumbrance Maintenance","Form","Finance","Accounting","Form used to create a general encumbrance. "]
["FGAJVCD ","Journal Voucher Entry ","Form","Finance","Journal Voucher Processing ","Form used to create a financial document in Banner."]
["FGAJVCD ","Journal Voucher Entry","Form ","Finance","Encumbrances","Form used to create a financial document in Banner."]
["FGAJVCD ","Journal Voucher Entry ","Form","Finance","Accounting","Form used to create a financial document in Banner."]
["FGAJVCM","Journal Voucher Mass Entry","Form","Finance","Accounting","Allows you to enter multiple journal entries into the Finance ledgers. "]
["FGAJVCQ","Jouranl Voucher Quick","Form","Finance","Accounting ","Allows you to enter journal vouchers quickly. "]
["FGIBAVL","Budget Availability Status ","Form","Finance","Budget","Allows the user to view the budget availability for a selected fund, organization, account, and program "]
["FGIBAVL","Budget Availability Status","Form","Finance","Operations ","Allows the user to view the budget availability for a selected fund, organization, account, and program "]
["FGIBDSR","Executive Summary ","Form","Finance","Budget","Allows you to view a unit's budget activity and transaction details for a FOAPAL by Account. "]
["FGIBDSR","Executive Summary ","Form","Finance","Accounting","Allows you to view a unit's budget activity and transaction details for a FOAPAL by Account. "]
["FGIBDSR","Executive Summary ","Form","Finance","Operations ","Allows you to view a unit's budget activity and transaction details for a FOAPAL by Account. "]
["FGIBDST","Organization Budget Status ","Form","Finance","Budget","Allows you to view a unit's budget activity and transaction details that have posted to that FOAPAL only."]
["FGIBDST","Organization Budget Status","Form","Finance","Operations ","Allows you to view a unit's budget activity and transaction details that have posted to that FOAPAL only."]
["FGIDOCR ","Document Retrieval Inquiry ","Form","Finance","Journal Voucher Processing ","Allows you to verify that a journal voucher has been posted, as well as review any details. "]
["FGIDOCR ","Document Retrieval Inquiry","Form","Finance","Accounting","Allows you to verify that a journal voucher has been posted, as well as review any details. "]
["FGIENCB","Encumbrance List ","Form","Finance","Encumbrances","Allows you to view a list of all general encumbrances in the Banner system, and view whether it is open or closed."]
["FGIENCB","Encumbrance List ","Form","Finance","Purchasing ","Allows you to look up the balances of a purchase order, and change order increases. "]
["FGIENCD ","Detail Encumbrance Activity ","Form ","Finance","Encumbrances","Use this form to review detailed transaction activities involving an encumbrance. "]
["FGIENCD ","Detail Encumbrance Activity ","Form ","Finance","Grants","Allows you to track grant activities as they are posted against an encumbrance. "]
["FGIGLAC","General Ledger Activity ","Form","Finance","General ","Query and display transaction details for specific Funds and Accounts. "]
["FGIGLAC","General Ledger Activity ","Form","Finance","Accounting","Query and display transaction details for specific Funds and Accounts. "]
["FGIJSUM","Journal Voucher Summary ","Form ","Finance","Journal Voucher Processing ","Allows you to review the details of an unposted journal voucher. This will help you to determine if it is postable or suspended. "]
["FGIJSUM","Journal Voucher Summary ","Form","Finance","Accounting","Allows you to review the details of an unposted journal voucher. This will help you to determine if it is postable or suspended. "]
["FGIJVCD","List of Suspended Journal Vouchers","Form ","Finance","Journal Voucher Processing ","Allows you to see only the statuses for journal vouchers that are unposted. "]
["FGIJVCD","List of Suspended Journal Vouchers","Form","Finance","Accounting","Allows you to see only the statuses for journal vouchers that are unposted. "]
["FGIOENC","Organizational Encumbrance List ","Form","Finance","Purchasing","This form displays all open encumbrances by Organization and/or Fund. "]
["FGIOENC","Organizational Encumbrance List ","Form","Finance","Encumbrances","This form displays all open encumbrances by Organization and/or Fund. "]
["FGITBAL","General Ledger Trail Balance Form","Form","Finance","General ","Allows the user to query account balances for a fund. First pages shows assets, liabilities, control accounts and current account balances. "]
["FGITBAL","General Ledger Trial Balance","Form","Finance","Accounting","Allows the user to query account balances for a fund. First pages shows assets, liabilities, control accounts and current account balances. "]
["FGITBSR","Trail Balance Summary ","Form","Finance","General ","Allows the user to see fund balance (balance does not include encumbrances). "]
["FGITBSR","Trial Balance Summary","Form","Finance","Accounting","Allows the user to see fund balance (balance does not include encumbrances). "]
["FGITRND","Detail Transaction Activity","Form","Finance","General ","View a unit's budget activity and transaction details for a FOAPAL by Account (this includes transactions that posted to the FOAPAL and also roll up to that FOAPAL).  "]
["FGITRND","Detail Transaction Activity ","Form","Finance","Accounting","View a unit's budget activity and transaction details for a FOAPAL by Account (this includes transactions that posted to the FOAPAL and also roll up to that FOAPAL).  "]
["FGRIDOC","Incomplete Document Listing","Report ","Finance","General ","Lists incomplete documents for a specified user ID. "]
["FGRIDOC","Incomplete Document Listing","Report ","Finance","Journal Voucher Processing ","Lists incomplete documents for a specified user ID. "]
["FGRORGH","Organizational Hierarchy Report","Report","Finance","General ","Shows your midlevel, roll-up code and budget numers that fall under a specific roll-up code ( 3 digit number) . This helps to determine if budgets are in the correct area. "]
["FOAAINP","Document Approval ","Form ","Finance","General ","Allows the user to locate a document in the approval process and identify who the next approver is."]
["FOAAINP","Document Approval","Form","Finance","Approvals","Allows the user to locate a document in the approval process and identify who the next approver is."]
["FOADOCU","Document By User ","Form","Finance","Journal Voucher Processing ","Allows you to see the statuses of all journal vouchers that you created. If you want to view the status of another Banner user you must enter that user's Vandal ID. "]
["FOADOCU","Document By User ","Form ","Finance","Encumbrances","Allows you to view a list of all encumbrances that you created. If you want to view a list of encumbrances another Banner user created you much enter that user's Vandal ID. "]
["FOADOCU","Document By User ","Form ","Finance","Approvals","Allows the \"originator\" to disapprove a document before it goes through the next approval queue. "]
["FOATEXT","General Text Entry ","Form ","Finance","Journal Voucher Processing ","Allows you to add text to a Banner document "]
["FOATEXT","General Text Entry ","Form ","Finance","General","Allows you to add text to a Banner document "]
["FOATEXT","General Text Entry ","Form","Finance","Purchasing","Allows you to add text to a Banner document "]
["FOAUAPP ","User Approval ","Form ","Finance","General ","Displays all items in an approval queue, and allows you to approve or disapprove a requisition. "]
["FOAUAPP ","User Approval ","Form","Finance","Purchasing","Displays all items in an approval queue, and allows you to approve or disapprove a requisition. "]
["FOAUAPP ","User Approval ","Form","Finance","Approvals","Displays all items in an approval queue, and allows you to approve or disapprove a requisition. "]
["FOIAINP","Approvals Notification ","Form","Finance","Purchasing","Displays all complete requisitions awaiting approval "]
["FOIAINP","Approval Notification","Form","Finance","Approvals","Displays all complete requisitions awaiting approval "]
["FOIAPHT","Approval History ","Form ","Finance","Grants","Displays the document approval history and status of a specific document."]
["FOIAPHT","Approval History","Form ","Finance","Approvals","Displays the document approval history and status of a specific document."]
["FOIAPHT","Approval History","Form","Finance","Purchasing","Displays the document approval history and status of a specific document "]
["FOIAPPH","Document Approval History ","Form ","Finance","Journal Voucher Processing ","Displays the approval or disapproval a document has received. "]
["FOIAPPH","Document Approval History ","Form ","Finance","General","Displays the approval or disapproval a document has received. "]
["FOIAPPH","Document Approval History ","Form ","Finance","Approvals","Displays the approval or disapproval a document has received "]
["FOIAPPH","Document Approval History ","Form ","Finance","Purchasing","Displays the approval or disapproval a document has received. "]
["FOICOMP","Finance Non- Person Search","Form","Finance","Operations ","Allows the user to query all the entities (non-persons) in Banner. "]
["FOIDOCH","Document History ","Form ","Finance","Accounts Payable ","Allows the user to view the status of Purchasing/Accts Payable Transactions and ties associated documents together. "]
["FOIDOCH","Document History ","Form","Finance","Purchasing","Allows the user to view the status of Purchasing/Accts Payable Transactions and ties associated documents together. "]
["FOIDOCH","Document History ","Form","Finance","Receiving ","Allows the user to view the status of Purchasing/Accts Payable Transactions and ties associated documents together. "]
["FOIDOCH","Document History","Form","Finance","Operations ","Allows the user to view the status of Purchasing/Accts Payable Transactions and ties associated documents together. "]
["FOIDOCH","Document History","Form","Finance","Inventory","Allows the user to view the status of Purchasing/Accts Payable Transactions and ties associated documents together. "]
["FOIIDEN","Finance Person Search","Form","Finance","Operations ","Allows the user to query all the persons (non- entities) in Banner. "]
["FPIEOCD","Encumbrance Open/Close ","Form","Finance","Purchasing","Allows user to close an existing purchase order encumbrance. "]
["FPIEOCL","Encumbrance Open/Close ","Form","Finance","Encumbrances","Allows user to close an existing purchase order encumbrance. "]
["FPIOPOF","Open Purchase Orders by FOAPAL","Form","Finance ","Purchasing ","Provides a list of Purchase Orders by budget or FOAPAL."]
["FPIOPOV","Purchase Orders by Vendor","Form","Finance ","Purchasing","Provides a list of Purchase Orders by Vendor. "]
["FPIPURR","Purchase/Blanket/Change Order Query ","Form","Finance","Purchasing","Allows a user to  view a purchase order or change order, no matter what status it is in. "]
["FPIREQN","Requisition Query ","Form","Finance","Purchasing","Allows a user to view a requisition, no matter what status it is in. "]
["FRAGRNT","Grant Maintenance Query ","Form ","Finance","Grants ","Shows all of the basic grant/contract information, including PI, sponsor, responsible department, etc. "]
["FRIASTG","Grant Agency Inquiry","Form","Finance","Grants","Allows you to view all grants associated with an agency."]
["FRIBUDG","Grant Budget Codes Inquiry","Form ","Finance","Grants","Allows you to find the originator and approvers of a document. "]
["FRIGITD","Grant Inception to Date","Form","Finance","Grants","Shows information on all posted budget and expense transactions from the inception of the award. May be narrowed down by the time period "]
["FRIGRNT ","Grant Code Inquiry Form ","Form ","Finance","Grants ","Allows you to query and view certain grant code details. "]
["FRIGTRD","Grant Transaction Detail ","Form","Finance","Grants","Shows detailed information on transactions. Available through the options menu of FRIGITD. "]
["FRIKGNT","Grant Title Search ","Form ","Finance","Grants","Allows you to search for a grant code using any part of the grant's long title."]
["FRIORGH","Grant Organization Inquiry ","Form ","Finance","Grants","Allows you to view the grants associated with a specific unit."]
["FRIPSTG","Grant Personnel Inquiry  ","Form ","Finance","Grants","Find out all the grants that a Principal Investigator has."]
["FRMFUND","Fund Code Maintenance","Form ","Finance","Grants","Allows you to view indirect cost details for a specified fund"]
["FTIBIDS","Request for Bid List Validation","Form","Finance","Purchasing","Provides a list of all unawarded bids in the purchasing system "]
["FTICHKS","Check Number Validation","Form","Finance","Accounts Payable ","Provides an online display of check transaction activity. "]
["FTIIDEN","Entity Name/ID Search","Form","Finance","Chart of Accounts","Allows the user to search the Banner Finance database for specific persons, entities and ID numbers. "]
["FTIIDEN","Entity Name/ID Search","Form","Finance","Operations ","Allows the user to search the Banner Finance database for specific persons, entities and ID numbers. "]
["FTMACCI","Account Index Code Validation ","Form ","Finance","Chart of Accounts","Use to establish an account code that provides a short keying sequence for user- defined FOAPAL combinations. "]
["FTMACCT","Account Code Maintenance","Form","Finance ","Chart of Accounts","Use to establish an object of expenditure accounts. "]
["FTMACTV","Activity Code Maintenance ","Form","Finance ","Chart of Accounts","Use to create activity codes that describe financial activity. "]
["FTMFTYP","Fund Type Maintenance","Form","Finance","Chart of Accounts","Use to define acccount types linked to user-defined account codes. "]
["FTMFSYR","Fiscal Year Maintenance","Form ","Finance","Chart of Accounts","Use to establish your fiscal year accounting periods. "]
["FTMFUND","Fund Code Maintenance","Form","Finance","Chart of Accounts","Allows you to establish fund codes for a specific chart of accounts. "]
["FTMORGN","Organziation Code Maintenance","Form","Finance","Chart of Accounts","Use to establish organization codes representing funcitons and departments within your site. "]
["FTMPROG","Program Code Maintenance","Form","Finance ","Chart of Accounts","Use to establish program codes. "]
["FTVORGN","Organization Code Validation Form - Finance","Form","Finance ","Chart of Accounts","Allows a user to query on all budget numbers (active or inactive), that have been set up for there area. "]
["FWRBAVL","Budget Availablity Report","Report","Finance","Budget","No longer a form used in Chart V.  Argos replacement: Argos>Finance > Prod > Departmental Financial Reporting > Budget to actual using index or FOAPAL "]
["FWRDOAR","Detail by Orgn or Actv Report","Report","Finance ","Budget ","No longer a form used in Chart V.  Argos replacement: Argos>Finance > Prod > Departmental Financial Reporting > Transactions Detail Reports > Chart V"]
["FWRDSTR ","Fund Balance Report ","Report","Finance ","Budget","Not Chart V user friendly. Working on an Argos replacement. "]
["FWRITEM","Itemization Report","Report","Finance","Budget","List of itemized expenditures and payroll by person for specific date range was originally created for grants, but you can now use any budget. "]
["FWRJVPR ","Print Journal Voucher ","Form","Finance","Journal Voucher Processing ","Allows you to print a completed journal voucher; does not have to be posted. "]
["FWROERP","Outstanding Encumbrance Report","Report","Finance","Encumbrances","Shows all outstanding encumbrances for specified budgets "]
["FWRPBSR ","Budget Status By Program ","Report","Finance","Budget ","No longer a form used in Chart V.  Argos replacement: Argos>Finance > Prod > Budget Status Report "]
["FWRPEDR","Payroll Expense Detail ","Report","Finance","Payroll","Shows, by org and pay period, the personnel expenditures, by person. It includes salaries, irregular help, overtime and fringe benefits. "]
["FWRSUMR","Grant Summary Report","Report","Finance","Grants","Summarizes information by grant inception to date through specified end date. "]
["FWRTPEC","Operating Budget/Primary Expense Class ","Form","Finance","Budget","Not Chart V user friendly. Argos Replacement: Finance > Production > Departmental Financial Reporting > Base Budget by Primary Expense Code (FWRTPEC) "]
["GUAMESG","General Message","Form","General","General","Allows you to view all messages sent through Banner. "]
["GUAPMNU","My Personal Menu","Form ","General ","General ","Allows you to input Banner forms and reports for direct access"]
["NBAJOBS","Employee Jobs","Form","Human Resources","Person","Allows the user to check the status of an employee."]
["NBAPBUD","Position Budget ","Report","Human Resources","Payroll","Shows positions (PCN) budgeted amounts and labor distribution. Argos > Human Resources > Production > Departmental Reports > NBAPBUD"]
["NBAPOSN ","Position Definition ","Report","Human Resources","Payroll","Shows title number, page grade, person currently in that position."]
["NBIPINC","Position Incumbent List","Report","Human Resources","Payroll","Shows all individuals who have been appointed to that PCN. "]
["NHIDIST","Labor Distribution Data Inquiry ","Report","Human Resources","Person","Show individual expenditures by earn code and organization "]
["NHIEDST","Employee Distribution Inquiry ","Form","Human Resources","Payroll","Allows you to see payments made for a specific period"]
["NOAAPSM ","Electronic Approval Summary ","Form ","Human Resources","EPAF","Personnel Action (EPAF) approval form. "]
["NOAEPAF","Electronic Personal Action Form ","Form","Human Resources","EPAF","Allows you to view an EPAF for an Individual. For EFAP originating, use VandalWeb. "]
["NTRPCLS","Position Class Rules ","Report","Human Resources","Person","Title (class code) query form "]
["NWRDERP","Departmental Employee Report","Report","Human Resources","Person","Shows various employee information including; job titles, pay rates, employee class, leave balances, etc. "]
["NWRDPOS","Departmental Position Report","Report ","Human Resources","Person","Shows all active and vacant postitions. "]
["NWREMPS ","Employee of Supervisor Report","Report","Human Resources","Payroll","Allows you to see who supervisors are by employee, department or mid- level."]
["NWREMPT","Employee Termination Report","Report","Human Resources","Payroll","Lists by organization roll-up, 01 suffix employees who do not have EPAF termination dates. Report shows terminations after specified date on parameter 1. "]
["NWRPREX","Personnel Expenditures ","Report","Human Resources","Payroll","No longer a form used in Chart V.  Argos replacement: Argos>Finance > Prod > Departmental Financial Reporting > Detailed Payroll Reporting "]
["NWRPYSV","Salary Saving Report","Report","Human Resources","Payroll","Shows, by org, the estimated current fiscal year salary residuals at a point-in-time. Has detail about year-to-date and estimated expenditures, by person. "]
["NWRSERP ","Salary Encumbrance Report ","Report","Human Resources","Person","This report displays YTD salaries paid, encumbered salary amounts and total annual salary that will be paid for the fiscal year and pay period entered. "]
["NWRTBSR","Budgeted Salary Report","Report","Human Resources","Payroll","Shows, by budget, PCN, name, title, classification, FTE %, annual salary, and percentage of salary for that  budget for full time, board appointed positions. "]
["PEAEMPL","Employee History Form","Report","Human Resources","Person","Shows rank and effective dates of faculty."]
["PEAFACT","Faculty Information Form ","Report","Human Resources","Person","Shows rank and effective dates of faculty."]
["PEIJTOT","Job Year to Date Totals ","Report","Human Resources","Person","Shows you the gross earnings by person for a calendar year. "]
["PHILIST ","Pay Event List","Report","Human Resources","Person","Shows list of payments made to that individual. "]
["PWRDIST","Payroll Distribution Detail with Adjustments","Report","Human Resources","Person","This report will display earning codes, payroll salary amounts, and fringe benefit expenses by employee for the date range and Midlevel or Department Code entered. "]
["PWRGREM","Report of Employees Paid from Grant","Report","Human Resources","Person","Shows employees assigned to a budget for a specific fiscal year and whether they are active or terminated. "]
["PWRLEAV","Leave Taken ","Report","Human Resources","Person","This report will display annual, sick and comp time amounts earned and taken for the date range specified. "]
["PWRWTES","Web Time Entry Summary Report","Report","Human Resources","Person","Allows you to see the history or status of a time sheet. Uses legal paper, or do a \"no print\" to view all columns. "]

{"sheet":"\"How To\"","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["In order to use the tool you will need to first \"Enable Macro's\" . "]
["Key "]
[null,"Indicates that this form is used frequently. "]
[null,"Indicates that the form is no longer used. "]