Accounts Receivable Detailed Universe Guide

1
Accounts Receivable Detailed Universe Guide

• December 2005

2
Understanding A/R data
3
Accounts Receivable General information

• Banner Finance data began in July 2003
• There is no longer a separation between Student
  A/R and General A/R. They are co-mingled in
  Banner A/R. Please use/share this data with
  caution as it does not contain FERPA indicators.
• Because there is no longer a seperation between
  SAR GAR, detail codes may be used by either
  type of account.
• There are currently over 8000 detail codes. Use
  them carefully. Limit your transaction rows by
  conditioning on specific detail codes.

4
Business Objects Sample Reports
5
Business Objects Universe Finance Accounts
Receivable

• Accounts Receivable charges, deposits, and
  payments
• 3rd Party Contract data
• Excludes charges to and payments from 3rd Party
  contractors in favor of charges to and payments
  from students. (Leaving both sets of records in
  would have created possibility of doubled totals)

6
Finance Accounts Receivable Intended Uses

• Intended use(s) of this Universe
• Listings of Accounts Receivable transactions by
• Detail code
• By date
• By campus

7
Tips for Utilizing Objects in the Universe

A customer can be a student or a general accounts
receivable customer Transactions that are student
related often include a term code and a campus
code. The campus code is derived from the first
digit of the term code. Online payments are
currently coded to a term code of 888888.
Therefore, online payments have a campus code of
8. There are more than 8000 detail codes. When
looking for a specific set of transactions, it is
often helpful to condition on a specific detail
code. Collection agency information (located
under Customer Account gt Collection Agency) is
currently not in use and therefore will not
return any data. Deposit information in
currently not in use and therefore will not
return any data.
8
Tips for Understanding Objects in the Universe
Toggle this button
When you single click to highlight an object,
there is often a definition of the object as well
as usage tips. (see definition box below). To
reveal this definition box, toggle it open by
pressing the button with the little blue i in
the upper left hand corner of your query panel.
Reveal object definitions usage tips
9
EDW - Finance Accounts Receivable Universe
Example Query

• Business Question I would like a listing of
  receivables transactions with the customer name
  id, detail code, etc

Helpful Hints There are many detail codes. If
you know the one used for your transactions,
place a condition your detail code A/R
Customers can be students or general
customers Customer IDs can begin with the _at_
sign
10
Finance A/R Universe Example
11
Finance A/R Universe Example
12
Finance Ledgers OL GL Universe Example
13
Finance A/R Universe Example
14
Finance A/R Universe Example Results
Dont do it!
15
Finance Accounts Receivable Sample Reports
Want to play with these sample reports? Want
something similar for your use? Then go visit
Query ClearingHouse and get a sample report with
which to begin!
16
What is QCH?

• DS Query Clearinghouse
• A place to share report templates
• Any EDW user can post Business Objects files for
  others to use as a starting point
• Share and work together!
• Query Clearinghouse link https//www.ds.uillinoi
  s.edu/Reports/Authentication/Login.aspx?ReturnUrl
  2freports2fQCH2fQCHBrowser.aspx

17
Query Clearinghouse
18
Appendix DS Resources Contact Information
19
Resources for Data Warehouse Users

• DS Monthly Practice Labs
• Monthly, on each physical campus
• FAC from Student, Finance, and HR present to
  answer questions and provide hands on assistance
  in creation of custom reports
• View Practice Lab dates http//www.ds.uillinois.
  edu/events.asp

20
Resources for Data Warehouse Users
For additional documentation and information
about universes, objects, tables, loading of EDW
data, training, data models, and metadata search,
please visit the DS website http//www.ds.uillin
ois.edu/web/Home/Metadata.aspx
21
How to Contact DS

• By filing an on-line Help Desk case
  http//onlinesupport.uillinois.edu/ds.html. To
  complete the form
• Authenticate via Bluestem
• Click "Start Here" on the left-hand margin
• Select "New Case" 
• Be sure "Decision Support" is listed on Help Desk
  line (first line of New Case entry form). If it
  does not, click "Change Help Desk" and select
  Decision Support from the list of options.
• Enter your contact information and the nature of
  your problem
• Click "Create Case" to submit the case to
  Decision Support for response
• Create a Help Desk Ticket
• Phone the AITS Help Desk
• Chicago [phone]
• Urbana [phone]
• Springfield [phone]
• Email the AITS Help Desk
• helpdesk2_at_uillinois.edu (one address for all 3
  campuses to use)
• If you have access to Clarify,
• Send a Clarify Ticket directly to the Decision
  Support Queuewell take it from there the
  appropriate person will respond.