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