TOAD Queries
Please visit bluewhale (the Toad shared drive) for additional canned reports.
Instructions to connect - call Lynn Wrightsman (x6969) for the password
Click the links below to save to your computer and open in Toad
Budget
- Cycle Report
- Transaction Detail
Note: This report takes some time to run (~10-15 min) due to the size of the tables the query accesses. It is only for current fiscal year data. If prior years are needed, please contact Melissa McDonough.
Incomplete Documents(Instructions)
Updated to include Org #'s
Org Maintenance
Human Resources
- Labor Distribution by TKL - This query will show current and future labor distributions for each employee within a user specified TKL.
- Labor Distribution by TKL - Detail - A more in-depth query that displays the same information as the above in addition to rate, FTE, etc. This query will also pull the job TKL data instead of the home TKL (as above).
