Query Name | Description | Report(s) Available |
Account Listing | Use this query to get an account listing. |
|
Chartstring Listing | Use this query to get a listing of valid Fund, Department, & Program combinations. |
|
DAA Display Available Amount | Use this query to view program summary information by account for Budget, Actuals, and Commitments as well as balances. | The reports are used for Revenue and Expense accounts ONLY.
|
DAB Display Amount Budget | Use this query for a high level view of your Budget information to date for the current or prior fiscal year. |
|
DFB Display Financial Balance | This report lists the current year and the prior year total Actuals amounts by month. |
|
DFC Display Financial Change | This query lists the Actuals balance for the chartstring(s) selected.The report lists: Balance Forward, Net Change for Period (Period Activity) Balance at the End of the Period selected (Current Balance).
AND lists by account number the balance forward, period activity, and current balance. |
Based on Selection Criteria:
|
DTD Display Transaction Detail | This query is used for viewing Budgeted, Actual, and Commitment journal transactions for a specified chartstring. | Based on Selection Criteria:
|
Department Listing | Use this query to get a department listing |
|
Mycode Listing | Use this query to get a Mycode listing |
|
Non Sponsored Restricted Listing | Use this query to find:
|
Listing of restricted chartstrings |
Program Account Combinations | Use this query to find a list of valid program account combinations for both actuals and budgetary accounts. |
|