Web Queries of FRS Data Site Map with definitions

Definitions of the Web Queries of FRS Data

Menu Name Query Name Summary Definitions of the Query

FRS Web Menu Main Menu The main menu that you come to upon a successful authentication.

SL Account Balance Menu
(SL = Subsidiary Ledgers 1-9) Menu Items A menu that allows you to view or download account summaries by department or by responsible person. If you want to query what your balance was as of the last working day, the last fiscal month, or the last fiscal year, use this query.

Account Balances by Department Select a department and a time frame. Bottom line balances of key data for all active accounts within that department will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts.

Account Balances by
Responsible Person Enter a responsible person (as seen on a budget report) and a time frame. Bottom line balances of key data for all active accounts within that department will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts.

Account Balances by Target Code Select a target code and a time frame. Bottom line balances of key data for all active accounts that have your selected target code will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts. This query is typically used to view a group of departments.

Account Balances by Account Range Enter a range of accounts and select all or a specific subcode class.Bottom line balances of key data for all active accounts in your selected range will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts.

Labor Distribution Query
Main Menu Menu Items A menu that has two choices to view/download labor distribution reports. Labor distribution by account or a special access.

Labor Distribution by Account View or download monthly labor distribution reports by account. Enter an account number and select a month.

Labor Distributions by Account
for a department. View or download monthly labor distribution reports for all of the accounts in a department. Select a department and a month from their perspective drop down boxes.

Subsidiary Ledger Transactions Menu Items A menu to view/download transactions by account, by department, or by responsible person. You specify the type of transactions and the time frame.

Transactions by Account View/download transactions in a user specified way. You may select by a specific subcode or a subcode class. You may select all transactions across fiscal years or select only expense transactions for a specific fiscal month. This query provides significant user control on what transactions you want to view/download.

Transactions by Dept. View/download transactions in a user specified way. Select a department. By default, you select all transactions for the date range you specify. You may select a fiscal year or a subcode class to further narrow your query results.

Transactions by Resp Person View/download transactions in a user specified way. Enter a responsible person name in the same format as seen on the budget report.. By default, you select all transactions for the date range you specify. You may select a fiscal year or a subcode class to further narrow your query results.

Transaction by Target Code View/download transactions in a user specified way. Select a target code.. By default, you select all transactions for the date range you specify. You may select a fiscal year or a subcode class to further narrow your query results.

Restricted Award Queries
(5 ledger accounts) Menu Items A menu of special queries designed to help personnel working on grants and contracts be more efficient at performing their finanical related tasks.

Grant & Contract Contact View who to contact in Grant and Contract Accounting for your selected awards by account, by department, or by responsible person.

Accounts Ending by Department View which accounts by department have an end date within a 90 day time frame.

Budget $ Increase/Decrease
(Adds/Mods/Closeouts) View accounts that have had an overall budget increase or decrease in the previous or current fiscal month. You may query by department or by college.

Subagency Report View all accounts associated with a subagency code. Select a subagency code. Every account coded with that subagency code will have its account's budget, expenses, and balances displayed. Project totals are displayed as well.. You may view the report as of the last working day or as of the end of the previous fiscal month.

Cost Share Accounts View cost share accounts by the most recently created or by department.

General Ledger Transactions
(GL = Zero Ledger) Menu Items A menu to view/download transactions by account, by department, or by responsible person.

Transaction by Account View/download transactions in a user specified way. You may select by a specific account control or by account control class.

Transactions by Department View /download transactions in a user specified way. Select a department. By default, you select all transactions for the date range you specify. You may select a fiscal year or an account control class to further narrow your query results.

Transaction by Resp Person View/download transactions in a user specified way. Enter a responsible person. By default, you select all transactions for the date range you specify. You may select a fiscal year or an account control class to further narrow your query results.

SL Special Transaction Query
(SL = Subsidiary Ledger 1-9) Menu Items A menu to view banner detail cash transactions that equate to the summary amounts fed to FRS.

Transactions by First Reference View transactions by the first reference field. Each transaction has a first reference value i.e. purchase order numbers. All transactions that have your entered value in its first reference field will be displayed. Values beginning with A or U will be not work in this query. Transactions back to 7/1/97 will be retrieved.

Transactions by Second Reference View transactions by the second reference field. Each transaction typically has a second reference value. All transactions that have your entered value in its second reference field will be displayed.

Transactions by Batch Id View all transactions that have the batch id value which match you entered value. The transactions are totaled. Batches can be viewed by fiscal year.

Purchasing Card Transactions View all purchasing transactions within your specified date range. You may view by account, by department, or by responsible person.

Query by Amount View transactions by Amount (=, >,<,between are available choices). Enter an amount, select a comparative operator, and specify a date range.

Banner Detail Cash Transactions View Banner Cash transactions by account or by department. These transactions provide the detail needed to reconcile the summarized amounts in their respective FRS transactions.

Query by Vendor Name View all transactions that have in their description field the same alphanumeric string you entered.

Outstanding Encumbrance Queries Menu Items A menu to view a list of outstanding encumbrances by account, by department, or by responsible person.

Outstanding Encumbrances
by Department/Account. Select a department. View a list of outstanding encumbrances of that department's active accounts. The department outstanding encumbrances are tootled at the bottom.

Outstanding Encumbrance
by Responsible Person Enter a responsible person's name. View a list of outstanding encumbrances of that responsible person's accounts. The outstanding encumbrances are tootled at the bottom.

SL Chart of Account Menu Menu Items A menu to view a list of active accounts and accounts deleted in current fiscal year. Key account attributes will be displayed.

SL Chart of Account by Department Select a department. View a list of accounts with their key account attributes.

SL Chart of Account by College or School Select a colleget or school. View a list of accounts with their key account attributes.

Asset Query Menu Menu Items A menu to view individual movable assets valued $5,000 and over. Various data items are displayed such as serial #, vendor, room, building, acquired date, total cost, and what account acquired it.

Asset Information by Asset Number Enter an asset tag number and view relevant asset information

Asset Information by Account Number Enter the acquisition account number and view relevant asset information

Asset Information by Department Select a department and view asset information on their assets

Asset Information by Building Select a building and view asset information in the building

Asset Information by College/School Select a college or school and view asset their information

Vendor/Voucher Query Menu Menu Items A menu to view vendor and voucher information in a varitey of ways. Various data items are displayed such as vendor name, invoice #, amount, due date, check #, and what address the check was mailed to.

Paid and Outstanding voucher by Dept View paid and outstanding vouchers by department

Paid and Outstanding vouchers by College and School View paid and outstanding vouchers by College/School

Paid and Outstanding vouchers by Vendor View paid and outstanding vouchers by Vendor

Endowment Query Menu Menu Items A menu to view endowment account information in a variety of ways. The four sections of information displayed are general, principal, reserve, and budget.

Endowment by Account Description Enter a character string and select appropriate endowment name.

Endowment by Account Number Enter any account associated with an endowment and view all information

Endowment by Department Select a dept and view all endowments for that department.

Endowment by College/School Select a college or school and view all endowments for that College/School

Last Revised: 13 November 2001
Web Queries of FRS Data Authentication Page
Controller's Office Web Page

Menu Name	Query Name	Summary Definitions of the Query
FRS Web Menu	Main Menu	The main menu that you come to upon a successful authentication.
SL Account Balance Menu (SL = Subsidiary Ledgers 1-9)	Menu Items	A menu that allows you to view or download account summaries by department or by responsible person. If you want to query what your balance was as of the last working day, the last fiscal month, or the last fiscal year, use this query.
	Account Balances by Department	Select a department and a time frame. Bottom line balances of key data for all active accounts within that department will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts.
	Account Balances by Responsible Person	Enter a responsible person (as seen on a budget report) and a time frame. Bottom line balances of key data for all active accounts within that department will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts.
	Account Balances by Target Code	Select a target code and a time frame. Bottom line balances of key data for all active accounts that have your selected target code will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts. This query is typically used to view a group of departments.
	Account Balances by Account Range	Enter a range of accounts and select all or a specific subcode class.Bottom line balances of key data for all active accounts in your selected range will be displayed. You will see what your budget is, what has been spent, what is encumbered, and what the balances are for those accounts.
Labor Distribution Query Main Menu	Menu Items	A menu that has two choices to view/download labor distribution reports. Labor distribution by account or a special access.
	Labor Distribution by Account	View or download monthly labor distribution reports by account. Enter an account number and select a month.
	Labor Distributions by Account for a department.	View or download monthly labor distribution reports for all of the accounts in a department. Select a department and a month from their perspective drop down boxes.
Subsidiary Ledger Transactions	Menu Items	A menu to view/download transactions by account, by department, or by responsible person. You specify the type of transactions and the time frame.
	Transactions by Account	View/download transactions in a user specified way. You may select by a specific subcode or a subcode class. You may select all transactions across fiscal years or select only expense transactions for a specific fiscal month. This query provides significant user control on what transactions you want to view/download.
	Transactions by Dept.	View/download transactions in a user specified way. Select a department. By default, you select all transactions for the date range you specify. You may select a fiscal year or a subcode class to further narrow your query results.
	Transactions by Resp Person	View/download transactions in a user specified way. Enter a responsible person name in the same format as seen on the budget report.. By default, you select all transactions for the date range you specify. You may select a fiscal year or a subcode class to further narrow your query results.
	Transaction by Target Code	View/download transactions in a user specified way. Select a target code.. By default, you select all transactions for the date range you specify. You may select a fiscal year or a subcode class to further narrow your query results.
Restricted Award Queries (5 ledger accounts)	Menu Items	A menu of special queries designed to help personnel working on grants and contracts be more efficient at performing their finanical related tasks.
	Grant & Contract Contact	View who to contact in Grant and Contract Accounting for your selected awards by account, by department, or by responsible person.
	Accounts Ending by Department	View which accounts by department have an end date within a 90 day time frame.
	Budget $ Increase/Decrease (Adds/Mods/Closeouts)	View accounts that have had an overall budget increase or decrease in the previous or current fiscal month. You may query by department or by college.
	Subagency Report	View all accounts associated with a subagency code. Select a subagency code. Every account coded with that subagency code will have its account's budget, expenses, and balances displayed. Project totals are displayed as well.. You may view the report as of the last working day or as of the end of the previous fiscal month.
	Cost Share Accounts	View cost share accounts by the most recently created or by department.
General Ledger Transactions (GL = Zero Ledger)	Menu Items	A menu to view/download transactions by account, by department, or by responsible person.
	Transaction by Account	View/download transactions in a user specified way. You may select by a specific account control or by account control class.
	Transactions by Department	View /download transactions in a user specified way. Select a department. By default, you select all transactions for the date range you specify. You may select a fiscal year or an account control class to further narrow your query results.
	Transaction by Resp Person	View/download transactions in a user specified way. Enter a responsible person. By default, you select all transactions for the date range you specify. You may select a fiscal year or an account control class to further narrow your query results.
SL Special Transaction Query (SL = Subsidiary Ledger 1-9)	Menu Items	A menu to view banner detail cash transactions that equate to the summary amounts fed to FRS.
	Transactions by First Reference	View transactions by the first reference field. Each transaction has a first reference value i.e. purchase order numbers. All transactions that have your entered value in its first reference field will be displayed. Values beginning with A or U will be not work in this query. Transactions back to 7/1/97 will be retrieved.
	Transactions by Second Reference	View transactions by the second reference field. Each transaction typically has a second reference value. All transactions that have your entered value in its second reference field will be displayed.
	Transactions by Batch Id	View all transactions that have the batch id value which match you entered value. The transactions are totaled. Batches can be viewed by fiscal year.
	Purchasing Card Transactions	View all purchasing transactions within your specified date range. You may view by account, by department, or by responsible person.
	Query by Amount	View transactions by Amount (=, >,<,between are available choices). Enter an amount, select a comparative operator, and specify a date range.
	Banner Detail Cash Transactions	View Banner Cash transactions by account or by department. These transactions provide the detail needed to reconcile the summarized amounts in their respective FRS transactions.
	Query by Vendor Name	View all transactions that have in their description field the same alphanumeric string you entered.
Outstanding Encumbrance Queries	Menu Items	A menu to view a list of outstanding encumbrances by account, by department, or by responsible person.
	Outstanding Encumbrances by Department/Account.	Select a department. View a list of outstanding encumbrances of that department's active accounts. The department outstanding encumbrances are tootled at the bottom.
	Outstanding Encumbrance by Responsible Person	Enter a responsible person's name. View a list of outstanding encumbrances of that responsible person's accounts. The outstanding encumbrances are tootled at the bottom.
SL Chart of Account Menu	Menu Items	A menu to view a list of active accounts and accounts deleted in current fiscal year. Key account attributes will be displayed.
	SL Chart of Account by Department	Select a department. View a list of accounts with their key account attributes.
	SL Chart of Account by College or School	Select a colleget or school. View a list of accounts with their key account attributes.
Asset Query Menu	Menu Items	A menu to view individual movable assets valued $5,000 and over. Various data items are displayed such as serial #, vendor, room, building, acquired date, total cost, and what account acquired it.
	Asset Information by Asset Number	Enter an asset tag number and view relevant asset information
	Asset Information by Account Number	Enter the acquisition account number and view relevant asset information
	Asset Information by Department	Select a department and view asset information on their assets
	Asset Information by Building	Select a building and view asset information in the building
	Asset Information by College/School	Select a college or school and view asset their information
Vendor/Voucher Query Menu	Menu Items	A menu to view vendor and voucher information in a varitey of ways. Various data items are displayed such as vendor name, invoice #, amount, due date, check #, and what address the check was mailed to.
	Paid and Outstanding voucher by Dept	View paid and outstanding vouchers by department
	Paid and Outstanding vouchers by College and School	View paid and outstanding vouchers by College/School
	Paid and Outstanding vouchers by Vendor	View paid and outstanding vouchers by Vendor
Endowment Query Menu	Menu Items	A menu to view endowment account information in a variety of ways. The four sections of information displayed are general, principal, reserve, and budget.
	Endowment by Account Description	Enter a character string and select appropriate endowment name.
	Endowment by Account Number	Enter any account associated with an endowment and view all information
	Endowment by Department	Select a dept and view all endowments for that department.
	Endowment by College/School	Select a college or school and view all endowments for that College/School