GES Trip Report Template s2

GES Trip Report Template s2

Finance Technical Training Class Notes

Class Notes for Finance Tech Training

Product Table Owners

General GENERAL

General Person SATURN

Finance FIMSMGR

Accounts Receivable TAISMGR

Position Control POSNCTL

Payroll PAYROLL

Student SATURN

Financial Aid FAISMGR

Alumni ALUMNI

Security BANSECR

REMINDER: The Reports and Processes Chapter of the General Technical Reference Manual discusses 3 critical tools.

1. Generating a Data Element Dictionary (DED) with GURPDED.pc. The DED lists each table and each field on each table with a description as to the use of the field. This report is critical in understanding the tables in Banner for modification and support purposes.

2. Generating a report of all HELP Documentation with GURHELP.pc.

3. Generating a report of all Reports and their parameters with GJRRPTS.pc

In addition to the tools listed above, you can use the gindex.sql script stored in the /banner/general/plus directory to generate a report of Indexes. Index knowledge is critical when writing reports and in passing/identifying key parameters to increase reporting performance. In the later releases of Banner, a listing for each product is delivered along with the script as findex.txt or index.txt within the doc directory.

GURDDOC.sql gives you a listing of all functions, packages, and procedures following standard documentation nomenclature. Finance and AR are the only two products at this time guaranteed to follow this format.

Banner General Person

Ø SPRIDEN Table: Name data, multiple rows, but only one “active” where spriden_change_ind is null.

Ø SPRADDR Table: Address data, multiple rows identified by Address Types and sequence numbers. Telephone information is obsolete in this table. 1 to Many relationship between SPRIDEN and SPRADDR. PIDM being the key link.

Ø SPRTELE Table: Telephone data, multiple rows, may be related to SPRADDR by Address Type. 1 to Many relationship between SPRIDEN and SPRTELE. PIDM being the key link.

Banner Finance System Tables and other Prerequisite Knowledge

Ø We discussed the Vendor Relationships in Finance since the Vendor table FTVVEND is linked to the SPRIDEN table via a PIDM

Ø Key System Forms/Tables

FOASYSC/FOBSYSC - Finance System Control Form. This is where you set System wide global controls within Finance.

Approvals Processing Indicator Values

Y Bypass Approvals

I Implicit Approvals

N Explicit Approvals

FTMSDAT/FTVSDAT - System Data Validation Form - a "Table of Tables"

FTMRUCL/FTVRUCL/FTVEDIT/FTVRULP - define rule class codes used by the posting engine, fgractg.pc.

FOASEQN/FOBSEQN - define one-up starting sequence numbers for Finance documents and other miscellaneous sequence numbers.

FOAFSEQ/FOBFSEQ – Define one-up starting sequence numbers to use for Finance Interfaces through gurfeed only this uses a two character prefix.

FTMDTYP/FTVDTYP - This is where the document type sequence number is initially stored for each type of document. You should memorize the most commons documents type used:

1 REQ Requisition

2 PO Purchase Order

3 INV Invoices and Credit Memos

5 CCK Canceled Checks

8 CHK Checks

20 JV Journal Vouchers

25 ENC Encumbrances

60 FAA Fixed Asset Accounting Adjustments

74 SUM General Ledger Summary Records

80 DCR Direct Cash Receipts

90 EOC Encumbrance Open/Close Document

The Entity Translation Tables may assist in conversions and interfaces, and act as a place of reference for personnel who remember their legacy values but not the new Banner Chart codes. One may want to consider using these tables as a cross reference for legacy codes to Banner Finance codes. Since this is not really documented anywhere in the User’s Manual in detail, I have included the setup in the tables as an example:

1. On the External Entity Code Maintenance Form (FTMEENT), define a four-byte code for your legacy system, ‘XWLK’ for example. You only need to do this once for your crosswalk. This populates the FTVEENT table. In this form and all following forms, make sure you use the same effective date. Best to pre-date to the date you are pre-dating on your Chart.

2. On the Internal Element Code Maintenance Form (FTMEELC), define each type of Banner Finance Chart Element you will be trying to crosswalk. There are only 5 valid values. Set one up for the value of ‘FUND’, one for the value of ‘ORGN’, one for the value of ‘ACCT’, and one for the value of ‘PROG’. Again, you will only need to do this once. This populates table FTVEELC putting ‘FUND’ into ftveelc_eelc_code. Same for ‘ORGN’, ‘ACCT’, and ‘PROG’.

3. Next you have two choices. On the External Report Code Maintenance Form (FTMEELI) you can enter all of your legacy codes manually or chose to populate the table directly (ftveeli). Put one in manually online so you can ‘see’ what fields you will need to populate. If your G/L code from Legacy actually represents a combination of Fund and Organization in Banner, then you will have to enter it 2 different times, associating it once with the Internal Element code of ‘FUND’ and once with ‘ORGN’. Thus let’s say your acct is 2-33000. Unrestricted funds Controller’s office. Then it would be represented in the table where

Ftveeli_eent_code = ‘XWLK and

Ftveeli_eelc_code = ‘FUND’ and

Ftveeli_eeli_code = ‘233000’ = Unrestricted - Controller’s Office

Then

Ftveeli_eent_code = ‘XWLK’ and

Ftveeli_eelc_code = ‘ORGN’ and

Ftveeli_eeli_code = ‘233000’

Or

Ftveeli_eent_code = ‘XWLK and

Ftveeli_eelc_code = ‘FUND’ and

Ftveeli_eeli_code = ‘260000’ = Unrestricted - President’s Office

Then

Ftveeli_eent_code = ‘XWLK’ and

Ftveeli_eelc_code = ‘ORGN’ and

Ftveeli_eeli_code = ‘260000’

OR

Ftveeli_eent_code = ‘XWLK and

Ftveeli_eelc_code = ‘FUND’ and

Ftveeli_eeli_code = ‘262000’ = Unrestricted - IT Office

Then

Ftveeli_eent_code = ‘XWLK’ and

Ftveeli_eelc_code = ‘ORGN’ and

Ftveeli_eeli_code = ‘262000’

You might create an extract out of your legacy system and use SQL@Loader to populate the FTVEELI table as you can hardcode all values except your legacy code, which is represented in the ftveeli_eeli_code field.

4. Then you have two more choices. On the External Report Translation Code Maintenance Form (FTMEELT) you can manually enter each Banner Finance Code that relates the Legacy Code by type of internal element. Or, you can use a spreadsheet to load the FTVEELT table via SQL@Loader. At the end you would need to ensure that each of the codes were valid, that is why it is preferable to enter the codes online as the system checks this for you. Ultimately a representation would be a follows:

Ftveelt_eent_code = ‘XWLK’ and

Ftveelt_eelc_code = ‘FUND’ and

Ftveelt_eeli_code = ‘233000’ and

Ftveelt_eelt_code = ‘1110’

Then

Ftveeli_eent_code = ‘XWLK’ and

Ftveeli_eelc_code = ‘ORGN’ and

Ftveeli_eeli_code = ‘233000’ and

Ftveelt_eelt_code = ‘11102’

OR

Ftveelt_eent_code = ‘XWLK’ and

Ftveelt_eelc_code = ‘FUND’ and

Ftveelt_eeli_code = ‘260000’ and

Ftveelt_eelt_code = ‘1110’

Then

Ftveeli_eent_code = ‘XWLK’ and

Ftveeli_eelc_code = ‘ORGN’ and

Ftveeli_eeli_code = ‘260000’ and

Ftveelt_eelt_code = ‘10’

Etc.

Now you have successfully populated the crosswalk table. The only tables you need to access for your interfaces or conversions are the FTVEELT table to crosswalk your Legacy Codes to the Banner Codes. The other advantage is that your end users can use the online FTVEELT form, query on an old Legacy value, and see what the new Banner Value(s) are. This is just one example of how you could use these tables.

The basic tables behind Chart of Accounts are: FTVCOAS, FTVFUND, FTVFTYP, FTVORGN, FTVACCT, FTVATYP, FTVPROG, FTVACTV, and FTVLOCN. Remember that the nchg_date represents the most current effective dated record when the date = 31-DEC-2099. There are several tables left in Finance that do not use the 31-DEC-2099 and instead use a null for the next change date. Some of them are FTVTGRP (Tax Group Table), FTVACTL (Control Account Table), FOBSYSC (System Control Table), FTVSDAT (System Data Maintenance Table), FTVDEPR (Depreciation Codes Maintenance), FORAQUS (Approval Queue Definition Table). Also the Entity Translation Tables FTVEENT, FTVEELI, FTVEENC, FTVEELT.

How Effective Date Processing works in detail with the Effective Date, Next Change Date and Timestamps is critical for data integrity. We used the Program Codes to demonstrate how effective date processing works. Just remember that you can never change an effective dated record, you can only create a new record with the same code and a new effective date to "simulate" a change. That is why you learn to perform an INSERT/DUPLICATE (F6/F4) for your changes on Effective Dated forms.

Information in the Fiscal Year Maintenance Form (FTMFSYR supported by tables FTVFSYR and FTVFSPD) and how it works with the transaction date of documents to set the posting period and fiscal year.

Key Ledger Tables

FGBTRNH: Transaction History Table; source accounting data that posting uses

FGBTRND: Transaction Detail Table; explosion of accounting from posting results and the largest table in Banner Finance

FGBGENL: General Ledger; records assets, liabilities, control accounts, and fund balance

FGBOPAL: Operating Ledger

FGBENCP: Encumbrance Ledger

FRRGRNL: Grant Ledger (just like FGBOPAL only based on Grant Year not Fiscal Year)

FGBBAVL: Budget Availability Ledger

FGRBAKO: Budget Availability Posting Backout - where unposted documents are recorded.

General Notes on Ledgers

No “open the year/period” processes - the fiscal year/period table is manually populated

All Ledger Tables (ENCH/ENCD exceptions) manipulated by the Finance posting process (fgractg). Also, FGRGENL, the general ledger roll process directly updates the fgbtrnh, fgbtrnd, and fgbgenl tables.

Non-Banner access to tables should be read-only

The General Ledger Tables form the basis of most reporting requirements

Finance High Level Security Tables

FOBSYSC Finance Global System Control Table

FOBPROF (FOMPROF): the User Profile Maintenance Form:

Invoice Restrictions Indicator Values (since one can never remember them all)

A All

D Direct Pay Invoices only

G General Encumbrances only

P Purchase Orders only

R Purchase Orders and General Encumbrances

E Direct Pay Invoices and General Encumbrances

F Direct Pay Invoices and Purchase Orders

Null No Invoices

Rule Group Security Tables

FTVRUCL Rule Class Validation

FTVEDIT Rule Class Edits

FTVRULP Rule Class Processes

FTVRUGR Rule Group Definition

FTVRGRC Rule Class to Rule Group Security

FTVRRGH Rule Class to Rule Group History (when records removed)

FORPRRG Process/Form to Rule Group Security

FORPRGH Process/Form to Rule Group History (when records removed)

FORUSRG User to Rule Group Security

FORURGH User to Rule Group Security History (when records removed)

NOTE: This still may not be fixed. If using rule group security, you will need to add the delivered rule group DCRG onto process FGADCSR on form FOMPRRG. Also, 3 new rule classes need to be added to the encumbrance rule group. POPN, POCL, RQCL need to be added to ENCG on from FOMRGRC. Then add the ENCG rule group to form FPAEOCD on form FOMPRRG. Or create a new rule group EOCG and add the new rule classes to them.

Fund/Orgn Security

FORUSFN User to Fund/Fund Type Security

FORUFNH User to Fund/Fund Type History (when records removed)

FORUSOR User to Organization Security

FORUORH User to Organization History (when records removed)

Approval Tables

FTVAPPQ Approval Queue Definition

FORAQUS Approval Queue Users

FORAQRC Approval Queue Routings

FOBUAPP Unapproved Documents

FOBAINP Approvals in Progress

FOBAPPH Approval History

FOBAPPD Approved Documents

Requisition Document Tables

FPBREQH Requisition Header

FPRREQD Requisition Detail

FPRREQA Requisition Accounting

FPRRQTX Requisition Taxes

Agreement Tables

FPBAGRH Agreement Header – associated with vendor FTVVEND

FPRAGRD Agreement Detail – associated with commodity FTVCOMM

Purchase Order Document Tables

FPBPOHD Purchase Order Header

FPRPODT Purchase Order Detail

FPRPODA Purchase Order Accounting

FPRPOXT Purchase Order Commodity Tax Table

FTVRQPO Request/PO Relationship

Fixed Assets and Document Adjustment Tables

FFBMAST Asset Master

FFRMASF Asset Accounting Funding Source

FFRMASA Asset Capitalization and Depreciation Accounting

FFRDEPR Asset Depreciation History

FFBADJH Fixed Assets Adjustments Header

FFRADJD Fixed Assets Adjustments Detail

FFRADJA Fixed Assets Adjustments Accounting

FFREXTC Fixed Assets Origination Tag Extraction Collector (not in ERD)

Purchase Order Open Close Document Tables

FPBEOCD Encumbrance Open Close Document Header

FPREOCD Encumbrance Open Close Document Item

FPREOCC Encumbrance Open Close Document Purchase Order/Req Item Table

FPREOCA Encumbrance Open Close Document Accounting Detail Table

Just a note, the FPREOCD_ENCD_TYPE field on the table FPREOCD is not really used for anything based upon my investigations. So please ignore that field when troubleshooting.

Invoice Document Tables

FABINVH Invoice Header

FARINVC Invoice Detail

FARINVA Invoice Accounting

FARINTX Invoice Taxes

Check Document Tables

FABCHKS Check Summary

FABINCK Invoice to Check Relationship

FABCHKA Check/Invoice Detail

FAB1099 1099 Tax Detail

Check Temporary Tables

FATCKNO Batch Check Number Temporary Table

FATCKDT Batch Check/Invoice Detail Temporary Table

FATCKIN Batch Check/Invoice Temporary Table

Journal Voucher Tables

FGBJVCH Journal Voucher Header

FGBJVCD Journal Voucher Detail

Direct Cash Receipt Tables

FGBCSHH Direct Cash Receipt Header

FGBCSHD Direct Cash Receipt Detail

FGRCSHD Direct Cash Receipt Tax and Rebate Table

General Encumbrance Tables

FGBENCH: Encumbrance Header - confusing fields are listed here as a reminder.

Fgbench_status_ind - represents whether encumbrance closed or open

(C)losed

(O)pen

Fgbench_status - represents whether document is completed or incomplete

(C)omplete

(I)ncomplete or null

FGBENCD: Encumbrance Detail

Fgbencd_status_ind - represents if the encumbrance item is postable or in error.

(P)ostable

(E)rror

Fgbencd_status - represents whether encumbrance closed or open

(C)losed

(O)pen

Key Trouble Shooting Areas

Invoices and Checks: Set up a script as follows to review entire posting history of an Invoice. This allows one to determine if an invoice has had a check posted to it as the invoice number is populated into the document reference number when a check is used to pay the invoice. The check number will be the document number.

select fgbtrnh_doc_seq_code DT,

fgbtrnh_doc_code DOC,

fgbtrnh_fsyr_code FY,

fgbtrnh_posting_period PP,

fgbtrnh_reversal_ind R,

fgbtrnh_submission_number SB,

fgbtrnh_item_num ITEM,

fgbtrnh_seq_num SQN,

fgbtrnh_rucl_code RUCL,

fgbtrnh_bank_code BK,

fgbtrnh_trans_amt AMT,

fgbtrnh_dr_cr_ind D,

fgbtrnh_doc_ref_num DOCREF

from fgbtrnh

where fgbtrnh_doc_code = ‘&inv_code’

or fgbtrnh_doc_ref_num = ‘&inv_code’

order by fgbtrnh_doc_seq_code,

fgbtrnh_doc_code,

fgbtrnh_item_num,

fgbtrnh_seq_num;

Then use the check document number to access FABINCK to review the history of the check and whether or not the tables have it listed as canceled. Use the submission number to determine if this may have been a recurring payable invoice. Check the reversal indicator to determine if invoice was canceled or check was canceled. Review doc_seq_code to see if this is the invoice (3), check (8) or canceled check (5). Add more fields to display if necessary. NOTE: invoices established in the prior fiscal year, canceled in the current fiscal year and reestablished in the prior fiscal will cause and out of balance condition in your control report for accounts payable.

Encumbrance: Set up a script as follows to review entire posting history of an Encumbrance.

select fgbtrnh_doc_seq_code DT,

fgbtrnh_doc_code DOC,

fgbtrnh_fsyr_code FY,

fgbtrnh_posting_period PP,

fgbtrnh_reversal_ind R,

fgbtrnh_submission_number SB,

fgbtrnh_item_num ITEM,

fgbtrnh_seq_num SQN,

fgbtrnh_rucl_code RUCL,

fgbtrnh_trans_amt AMT,

fgbtrnh_dr_cr_ind D,

fgbtrnh_encd_num ENC,

fgbtrnh_encd_item_num EITEM,

fgbtrnh_encd_seq_num ESQN

from fgbtrnh

where fgbtrnh_encd_num = ‘&enc’

order by fgbtrnh_doc_seq_code,

fgbtrnh_doc_code,

fgbtrnh_item_num,

fgbtrnh_seq_num;

COMMENTS:

MATERIALS TO READ:

The most important chapters to read in the General Technical Reference Manual are Chapter 1 and Chapter 3. As a Finance technical support person, you should also read the Finance Technical Reference Manual and the Processing Chapter of the Banner Finance Users manual. I recommend that all personnel working in Finance read the Processing Chapter of the Banner Finance User’s manual to gain a base understanding of the Finance product. This can apply to anyone in general who desires to become more knowledgeable within Finance. There are many tools that are well documented in the manuals. Since I have only listed key tables in this class notes report, please use the Banner Finance Technical Training PowerPoint presentation as reference material. There is a tremendous amount of information within this presentation that you will be able to search for and utilize.

Also, it is imperative for the functional personnel to always read the new release guides as there is great amount of documentation in these guides. Also, the upgrade guides can enlighten one more from a technical perspective as to which forms/processes/tables are new, modified or obsolete.

Just a reminder that you will want to verify that all tables entries that are Chart specific in FTVSDAT (key seed data Charts values are 'A' and 'B') have been copied for your own Chart.

LISTS TO BE SUBSCRIBED TO: All Finance technical support personnel should be subscribed to the following lists at Sungard Higher Education:

BORACLE Oracle Technical Discussion List

BFINANCE Finance discussion list

BFIXEDA Finance Fixed Assets discussion list

BGRANTS Finance Grants discussion list

BPURCHASE Finance Purchasing discussion list

BPOST Electronic distribution announcements

BGENERAL Optional; General discussion list

BREPORT Optional; Reporting discussion list

BAR Optional; Banner Accounts Receivable

There are two methods to procure subscription.

On the web, go to site http://lists.sungardhe.com

Or send and email to and in the body of the message type:

Subscribe Bfinance FirstName LastName

REPORTS

Also not discussed in depth but listed here for your convenience is a number of key Finance reports of which some should be run on a nightly basis, the control report, trial balance exception, cash exception reports being a few. These reports disclose the current health of your finance system, and any problems found should be immediately corrected. Others need to be run on a monthly basis for your end users. That is for you to decide. You have already been running some of these on a regular basis. They are listed again here for review.

FGRCTRL - G/L Subsidiary Ledger Control Report

Compares balances of open invoices, operating accts., & open encumbrances to the appropriate general ledger control accts.

Run nightly and prior to distribution of statements

Look for out of balance messages in the far right column

FGRBIEX - Bank Interfund Account Balance Exception Report

Run nightly and prior to distribution of statements

Validates if balances in Bank Interfund accts are in balance

Look for out of balance situations

FGRTBEX - Trial Balance Exception Report

Run nightly and prior to distribution of monthly statements

Are any funds out of balance?

FGRGLEX – Grant Ledger Exception Report

Run nightly and prior to distribution of monthly statements if using Grants.

Finds transactions that exist in FGBTRND but not in the Grant Ledger. Sorted by Grant.

FGRIDOC – Incomplete Documents Report

Run monthly and prior to closing a fiscal period.

Finds all documents in an incomplete status. They should be deleted or completed prior to closing period unless good reasons exist to leave them in the system.

FGROPNE – Open Encumbrances Report

Run monthly and prior to closing a fiscal period.

Finds all open encumbrances. Use to research if encumbrances should be closed.

FGRTBAL - Trial Balance Report

Run monthly after all transactions are processed

List of all accts and their balances--for current period and prior period, totaled by fund

Used by VP for Finance and Controller

FGRGLTA - G/L Transaction Activity Report

Monthly after all transactions are processed

List of all accts and their balances--for current period and prior period, totaled by fund, with the detail

Used by VP for Finance and Controller

FGRBLSH - G/L Balance Sheet Report

Monthly after all transactions are processed and the period is closed

List of all accts and their balances, for the G/L--for current period and prior period, totaled by fund, with the detail

Used by VP for Finance and Controller

FGRCASH - Bank Interfund Account Control Report

Monthly after all transactions are processed and the period is closed

Compares cash interfund for each bank fund to the cash accts of each fund which have a claim on the bank fund

Used by VP for Finance and Controller

FGRBDSC – Budget Status Report

Monthly after all transactions are processed and the period is closed

Shows available budget balance and expenditures by account within an organization (department)

Used by VP for Finance, Controller, Department Managers

FGRODTA – Organization Detail Activity Report

Monthly after all transactions are processed and the period is closed

Shows expenses, budget and encumbrance activity by account and fund within each organization (department)

Used by Department Managers

FGRREOB – Statement of Revenue, Expenditures, Other Changes Report

Monthly after all transactions are processed and the period is closed

Shows year-to-date revenues and expenditures in summary form with a budget variance

Used by President, VP for Finance, Controller, and, perhaps the Board of Trustees

FGRREOC – Statement of Revenue, Expenditures, Other Changes Report

Monthly after all transactions are processed and the period is closed

Shows year-to-date revenues and expenditures in summary form compared to corresponding prior year period

Used by President, VP for Finance, Controller, and, perhaps the Board of Trustees

FGRFPSN – Statement of Financial Position Report

Monthly after all transactions are processed and the period is closed

Report required by FASB (Financial Accounting Standards Board). Shows consolidated change in the financial position by Unrestricted/temporarily restricted/permanently restricted funds.

Used by Auditors, VP for Finance, Controller, and External Agencies

FGRCHNA – Statement of Change in Net Assets Report

Monthly after all transactions are processed and the period is closed

Report required by FASB (Financial Accounting Standards Board). Shows revenues/expenditures/fund/transfers/additions/deductions by unrestricted/temporary restricted/permanently restricted funds

Used by Auditors, VP for Finance, Controller, and External Agencies

FGRCUNA – Changes in Unrestricted Net Assets/Revenues, Expenses and Other Changes

Monthly after all transactions are processed and the period is closed

Report required by FASB (Financial Accounting Standards Board). Shows revenues/expenditures/fund/transfers by unrestricted funds

Used by Auditors, VP for Finance, Controller, and External Agencies

CONCERNS-OBSERVATIONS:

When and if you decentralize any of your functions, it is imperative to have in place an internal HELPLINE that personnel can call to receive assistance if they have any difficulties. Nothing is more upsetting than a frustrated end user unable to complete their work.

You will have to decide who will have update capabilities via SQL into the Production Database. The best structure is for the DBA to maintain responsibilities of installations for Oracle/Banner and to manage all of the upgrades. This person will have their hands quite full with just this job alone. Then have programmer analysts that will have update capabilities into the production database fulfilling requests or assisting the Finance Systems Administrator. If that is not possible in your world, then the next best thing is to have the PAs/FAs write scripts and test them in TEST, then give the DBA the script to run in Production.

The Finance Systems Administrator will be the person responsible for setting the System controls on FOMSYSC, and Finance security for Users (FOMPROF). This includes rule group security and approvals, trouble shooting, checking posting and approvals runs each day, making sure that interfaces ran successfully, and that Finance is still in balance each day. In an ideal world, this person would have assistants to maintain security data while she/he gains a full understanding of the Finance system and aids the programmer analysts in troubleshooting problems that could arise in the system or direct requests for aid in updating tables in Finance.

Also, to prevent queries from “hurting” production, you may want to think about creating a REPORT database that is simply a snapshot of the Production database logs each night and updated into a Report database. Then let everyone loose in the REPORT database, query mode only. Most clients are satisfied with this solution and can handle the 24-hour turnaround. This way there is absolutely no impact on Production when people are trying to use Access, Oracle Reports or SQL*Plus.

NOTE: to make your testing easier, add DATABASE as a valid GTVPRNT printer in the TEST database. Then default that onto your processes for FGRACTG and FORAPPL in GJAJOBS. That way when you submit these processes, you perform a NEXT BLOCK 3 times, then press save. The job is done, and you save a mass amount of paper. IF you allow personnel to use DATABASE, then you will need to periodically run the gdeloutp.sql script to clean out the tables behind this form, guboutp and guroutp based upon some mutually agreed upon number of days, typically 3-5.

DOCUMENTATION: It is extremely important to have your procedures documented that support your business requirements. I can’t emphasize enough the importance of this task. Many times you can do this and turn them into internal training materials. I cannot emphasize enough how important it is to document procedures in Banner Finance for each area. If procedures are not documented, the Institution is at grave risk when someone leaves or is absent for any reason.

Make sure that all Banner Personnel understand how to access the Banner bookshelf. The documentation can be accessed and directly printed out in hardcopy. I advise that a hard copy of the reports and processes chapter of the Finance User Manual be printed out for all Banner Finance Personnel who will be dealing with reports. The reports and processes are well documented and also give you some idea of a picture of the report with the layouts inserted. It is a very simple matter to set up and this make available to your end users. Please do so as it is an invaluable tool.

Finance Technical TrainingConfidential and ProprietaryPage 6 of 11