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

  1. 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.
  2. Put a check-mark next to the appropriate attributes and note any necessary qualifications.
  3. Bring up the Hummingbird BI-Query User FS QDB Model, choose the appropriate object(s), then fill in the selection screen.
  4. Check your column order and sort order before submitting you query.

  5. 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