FS Course 402 - Learning the Data in the FS Query Data Base
What do I need to know about the data to build a successful ad-hoc query?
Learning about the data objects and their attributes
These are the Overhead Rate data attributes that are available for performing local ad-hoc queries. Review the data
reminders and querying hints before trying the hands-on exercise below. See the
Data Dictionary for detail definitions.
Data Reminders - Querying Hints
This data object is a "current" table that does not contain any "historical" data.
It always reflects the current information residing on the Financial System
Overhead Rate Description Table as of the end of the preceding business
day. For prior years use the history data base FS-QDB_h.
This data object does not contain hierarchical codes,
i.e. department or
organization. To qualify the department code, the Overhead Rate object can
be linked to either the account object or the fund object. The results using the
account department will be all the acct/cc-funds for the given department
code. The results using the fund department will be all the account/cc linked
to the funds of the given department code, possibly including some acct/cc
that belong to other departments.
General Steps to Complete the Hands-on Exercise
- Get a blank FS Query Data Model Worksheet and think about which objects and attributes are required to complete
this exercise, one part at a time.
- Put a check-mark next to the appropriate attributes and note any necessary qualifications.
- Bring up the Hummingbird BI-Query User FS QDB Model, choose the appropriate object(s), then
fill in the selection screen.
- Check your column order and sort order before submitting you query.
Submit your query.
Hands-on Exercise No. 12: Complete an ad-hoc query that lists the overhead rates and overhead base codes being applied
to the account/funds within department 0965. Include the Fund Type title. [Solution]
[Back to data objects index]
©Copyright 1996 - Regents of the University of California;
Prepared by Greg Partipilo and Terri Kirkman; updated 09/10/03