Skip to main content

Controller's Office

Recommended Queries

A printable version of this list is available here.

 

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email QualityAssurance@admin.fsu.edu

 

 

Description

Prompts


Departments for which an employee is an authorized signer OR Employees who are authorized
signers for a department.


Dept ID %
Last Name

Description

Prompts


Departmental cash balance


Dept ID %
Fund Code %
Business Unit

Description

Prompts


G/L Account names and (for non-Payroll related expense accounts) detailed account use descriptions


Account # %

Description

Prompts


Purchasing Categories and G/L


Purch Exp Account # %

Description

Prompts


Returns department information (description, manager, etc.).


Dept ID %

Description

Prompts


Returns fund information (description, effective date, etc.).


(None)

Description

Prompts


Returns journal Source information.


(None)

Description

Prompts


Annual (for fiscal year, periods 1-12) actual operating expenditure data for Centers & Institutes.


Dept ID %
Fund Code %
Project ID %
Fiscal Year

Description

Prompts


Departments for which an employee is the dean, director, department head, or budget manager OR
Employees who are the dean, director, department head or budget manager for a department.


Dept ID %
Bud Mgr Last Name %
Bud Mgr First Name %
DDDH Last Name %
DDDH First Name %

Description

Prompts


Journal information (Journal ID, Journal Date, Dept, Fund, Project, Account, Amount, Source,
Description, Entered By, etc.).


Journal ID %
Journal Date
Source %
Dept ID %
Fund Code %
Account %
Project ID %
Business Unit

Description

Prompts


Journal information (Journal ID, Journal Date, Dept, Fund, Project, Account, Amount, Source, Description,
Entered By, etc.) – with additional prompts for optional chartfields (1-3).


Journal ID %
Journal Date
Source %
Dept ID %
Fund Code %
Account %
Project ID %
Chartfield 1 %
Chartfield 2 %
Chartfield 3 %

Description

Prompts


List of all valid Optional CFs.


(None)

Description

Prompts


Returns the departmental trial balance.


Role Name %
HR Home DeptID %

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email Quality Assurance at QualityAssurance@admin.fsu.edu

 

 

Description

Prompts


Payment and transaction information, by Check #, for Vouchers, Expense Reports and/or Employee Advances.


Check # %

Description

Prompts


Provides users with information relating to deposit refunds


Begin Date
End Date
Dept ID

Description

Prompts


Open Items (Employee Advance) Balance Information


Empl ID %
HR Home DeptID %
As of Date

Description

Prompts


Open Items (Employee Advance) Activity


Empl ID %
DeptID %
Fund Code %
Project ID %
Accounting Date

Description

Prompts


Vouchers that have not yet been posted


Fund Code %
Dept ID %
Accounting Date

Description

Prompts


Query to determine Departments' FSU_AP_DEF_USER (ePRF final approver), which is defined by range by inputting the lowest DEPTID in the BEG prompt and the highest DEPTID in the END prompt.


Dept from Beg
Dept from End

Description

Prompts


Query to determine Departments' LVL 1 and 2 AP Approvers (ePRF approver), which is defined by individual Department by inputting DEPTID. The prompt can receive a wildcard, so 189% to get 189000-189999 if necessary.


DEPT ID like w/ %

Description

Prompts


Journal and other information (Vendor, Invoice, etc.) for vouchers


Fund Code %
Dept ID %
Project ID %
Journal Date
Account %
Journal ID %
Business Unit

Description

Prompts


Journal and other information (Vendor, Invoice, etc.) for vouchers – with additional prompts for optional chartfields (1-3)


Fund Code %
Dept ID %
Project ID %
Journal Date
Account %
Journal ID %
Chartfield 1 %
Chartfield 2 %
Chartfield 3 %

Description

Prompts


Query to determine workflow of Travel Authorizations and related details w/ prompts.


Business Unit Begin Date
End Date
Dept Like (w %)
Fund Like (w/ %)

Description

Prompts


This query searches for scanned documents by their scan date and returns information relating to the purchase order, invoice, voucher, and supplier.

Users may specify a range of departments in the prompts.


Start Date
Today's Date
DEPTID Start
DEPTID End

Description

Prompts


Detail of P-Card transactions hitting the G/L for a range of Journal Dates


Jrnl Date
Dept ID %
Fund Code %

Description

Prompts


Listing of individuals with a PCard by Department.


Dept ID %
Empl ID %

Description

Prompts


Listing of proxies and cardholders / department(s) they proxy for.


Proxy UserID %
Dept ID %
Proxy Last Name %

Description

Prompts


Detail of the chartfields assigned to PCard transactions on the OMNI PCard Reconcile Statement as well as the chartfields assigned
to these transactions once they have been vouchered.


Empl ID %
Trans Date
Dept ID %

Description

Prompts


P-Card Transaction information by Employee ID, Transaction Dates, and Dept ID./p>


Empl ID %
Trans Date
Dept ID %

Description

Prompts


Purchase Order information (PO #, PO Date, Req ID, Amount, PO Status, Vendor, etc.)


Dept ID %
PO Date
Project ID %
Fund Code %
Business Unit

Description

Prompts


PO Change Order information


Dept ID %
PO Date
Business Unit

Description

Prompts


Purchase Order information, including Receipt, Voucher, and Payment information


PO ID %
Dept ID %
Project ID %
Fund Code %
Account %
PO Date
Business Unit

Description

Prompts


Requisition information


Dept ID %
Project ID %
Fund Code %
Enter Date
Business Unit

Description

Prompts


Voucher information by department and/or Operator ID


Dept ID %
Enter Date
Entered By %
Business Unit

Description

Prompts


Voucher information, including payment and journal data


Dept ID %
Fund ID %
Project ID %
Account %
Acct Date
Voucher ID %
Vendor ID %
Business Unit

Description

Prompts


Vendor info, including Status, Open for PO, Gov Class, Location, Payment Method and Address


Vendor ID %
Vendor Name %

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email Quality Assurance at QualityAssurance@admin.fsu.edu.

 

 

Description

Prompts


Listing of individuals with a TCard by Department


Dept ID %
Empl ID %

Description

Prompts


Travel or Expense Sheet journal information


Dept ID %
Fund Code %
Project ID %
Journal Date
Journal ID %
Business Unit

Description

Prompts


Travel or Expense Sheet journal information


Dept ID %
Fund Code %
Project ID %
Journal Date
Journal ID %
Business Unit

Description

Prompts


T-Card transactions not yet at the Prepay Audit level by Dept ID


Business Unit
Dept ID %

Description

Prompts


ER approval history with reviewer comments


ER Submission Date
Dept ID %
Fund Code %

Description

Prompts


Expense Reports not yet at the Prepay Audit level by Dept ID


Business Unit
Dept ID %

Description

Prompts


Expense Reports in Pending Status by Dept ID


Business Unit
Dept ID %

Description

Prompts


Expense Report by Business Purpose and Type


Dept ID %
Fund Code %
Account %
JRNL Date

Description

Prompts


All departmental travel approvers by Dept ID


Dept ID %
Business Unit

Description

Prompts


Travel Authorization information


Business Unit
Dept ID %
Acct Date
Project ID %
Travel Rep
OPRID %
Traveler Name %

Description

Prompts


Travel Cash Advance information


Dept ID %
Acct Date
Project ID %
Business Unit
Travel Rep
OPRID %
Traveler Name %

Description

Prompts


Travel Expense Report by Department ID


Dept ID %
Acct Date
Project ID %
Account %
Business Unit

Description

Prompts


Travel Expense Report information


Dept ID % Acct Date
Project ID %
Business Unit
Travel Rep
OPRID %
Traveler Name %

Description

Prompts


Travel Expense Report journal information


Dept ID %
PO Date
Business Unit

Description

Prompts


Outstanding My Wallet charges (i.e. TCard charges not yet on an expense report)


HR Home Dept ID %

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email Quality Assurance at QualityAssurance@admin.fsu.edu.

 

 

Description

Prompts


Detailed acquisition and custodial (off-site) information for assets


Dept ID %
Fund ID %
Project ID %
Tag # %
PO ID %
Voucher ID %
Business Unit

Description

Prompts


Assets inventoried in current fiscal year by Department


Business Unit
Last date of prior FY
Dept ID

Description

Prompts


Beginning inventory by Department for current fiscal year


Business Unit
Last date of prior FY
Dept ID

Description

Prompts


Cost adjustments in current fiscal year by Department and Accounting Date


Business Unit
Dept ID
Acct Date

Description

Prompts


In-service assets by Department


Business Unit

Description

Prompts


Non-Capitalized Assets with a value of $4999 or less that were manually added to Asset Management
after 7/1/11 for tracking/inventory purposes only


Dept ID

Description

Prompts


The last inventory date of un-inventoried assets.


Business Unit
Begin Dept
End Dept
Last date of prior FY

Description

Prompts


Information regarding depreciation and net book value for in-service assets


Fiscal Year
Accounting Pd
Dept ID %
Fund Code %
Business Unit

Description

Prompts


Information regarding depreciation and net book value for assets retired from the department/fund(s) selected


Dept ID %
Acct Date
Fund Code %
Business Unit

Description

Prompts


Information regarding depreciation and net book value for assets transferred in to/out of the department/fund(s) selected


Dept ID %
Acct Date
Fund Code %
Business Unit

Description

Prompts


Assets not yet inventoried in the current fiscal year by Department with most recent inventory date


Business Unit
Last date of prior FY
Dept ID

Description

Prompts


Assets located off campus (ER244 on file) by Department


Business Unit
Dept ID

Description

Prompts


Department Area(s) for which an employee is an Inventory Taker, Property Custodian or Property Manager
OR employees who fill these roles for a Department Area.


Department Area %
Employee ID %

Description

Prompts


Assets transferred in/out by Department (Transferring In Dept or Transferring Out Dept) and Transaction Date


Business Unit
Tfr Out
Dept ID
Tfr In
Dept ID
Trans Date

Description

Prompts


Assets transferred or retired by Department and Transaction Date


Business Unit
Dept ID
Trans Date

 

The following queries were developed for Campus Solutions/Student Central.  Remember, these queries will not run in the Financials environment- you must access them from the Student Central portal.

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email Quality Assurance at QualityAssurance@admin.fsu.edu.

 

 

Description

Prompts


Provides accounting entry setup for Item Types.


Dept ID %
Item Type

Description

Prompts


Journal detail of payments on Accounts Receivable charges. DOES NOT include detail
of what specific charges were paid by the payments.


Dept
Fund
Person/Org ID
Journal Date

Description

Prompts


Journal detail of tuition and fee charges, including auxiliary fees.


Dept
Fund
Person/Org ID
Journal Date
Term

Description

Prompts


Journal detail of departmental deposits processed by a given user on a given day. Replaces
CM75 report of KREN Corrections from Legacy.


Journal Date
Deposit ID
Dept
Account
Journal ID

Description

Prompts


Journal detail of any Student Financials-related transaction.


Journal ID
Dept
Fund
Journal Date
Account
Person/Org ID
Project

Description

Prompts


Journal detail of waiver transactions.


Dept
Fund
Person/Org ID
Journal Date
Project

Description

Prompts


Outstanding accounts receivable balances by Person/Organization, Dept, Fund, Project.


Dept
Fund
Person/Org ID
As of Journal

Description

Prompts


Detail by Person/Org, Item Type and Term of all outstanding AR for auxiliary fees (i.e. '2%' Item Types). Note that this
excludes any outstanding tuition / student fees.


Dept
Fund
Person/Org ID

Description

Prompts


Detail of payments on outstanding Accounts Receivable, including specific charges being paid.


Trnx Date
Person/Org ID
Dept
Fund
Person/Org Name

Description

Prompts


Detail of service indicators (aka Holds) by Student and/or type of service indicator.


EmplID
Last Name
First Name
Svc Indicator Code

Description

Prompts


Detail of charges waived during a date range for a particular student and/or Waiver Item Type.
Includes detailed course info.


Trnx Date
Waiver Item Type
Person/Org ID

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email Quality Assurance at QualityAssurance@admin.fsu.edu.

 

 

Description

Prompts


Cashier Entries by Accounting Period


Dept ID %
Fund Code %
Fiscal Year
Acct Period
Business Unit

Description

Prompts


Cash entries from Cashiering


Dept ID %
Fund Code %
Entry Date
Business Unit

Description

Prompts


Non-cash entries from Cashiering


Dept ID %
Fund Code %
Project %
Entry Date
Journal ID %
Business Unit