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 STIP (Short Term Investment Pool) 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 STIP Description Table as of the end of the preceding business day. For prior years use the history data base FS-QDB_h.

  • When a fund's stip_sign = N, it indicates that the STIP_account will be charged for negative balances.

  • Refer to the data dictionary to identify the values for qualifying stip_sign, stip_fund_notation, and stip_basis code.

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. 13: Complete an ad-hoc query that identifies how STIP +/- will be applied for funds controlled by department 0860. Include all attribute STIP signs and notations. [Solution]

[Back to data objects index]

©Copyright 1996 - Regents of the University of California;
Prepared by Greg Partipilo and Terri Kirkman; updated 09/09/03