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 ctl-finsys@fsu.edu

 

 

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,
budget manager, authorized signer, Hyperion salary preparer, or Hyperion budget preparer.

Dept ID %
Bud Mgr Name %
DDDH Name %
Auth Signer %
Hyp Sal Prep %
Hyp Bud Prep %

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 %

Description

Prompts

Departmental trial balance, includes ACTUALS and ACCRUALS ledgers.

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

Description

Prompts

Departmental trial balance for Foundation Departments / Projects.
NOTE: This query will ONLY RUN FOR FUND 599.

Dept ID %
Fiscal Year
Acct Period
FSUF Project ID %

Description

Prompts

FSU Foundation Project IDs and associated Department IDs.

F Project ID %

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email Financial Systems at ctl-finsys@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

P-Card transaction information for ONLY transactions not yet approved.

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

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 ctl-finsys@fsu.edu.

 

 

Queries for Buying Departments

Description

Prompts

Provides a list of all internal auxiliary category codes to be used with internal auxiliary suppliers.

No prompts

Description

Prompts

Provides a list of requisitions that have been entered for the auxiliary
but not yet approved and where they are in the process.

Dept ID %
Project ID %
Fund %
*From Date Entered
*To Date Entered
*Business Unit
Supplier %

Description

Prompts

Provides a list of all internal auxiliary suppliers.

No prompts

Description

Prompts

Provides the original encumbrance amount, expenses to date
and remaining balance for each line on an internal, auxiliary PO.

PO Number %
Dept ID %
Fund Code %
Project ID %
*Purchase Order Date>
Supplier ID %

Description

Prompts

Provides a sum of expenses for the auxiliary by supplier ID and purchasing category.

Department ID %
Fund Code %
Fiscal Year
Accounting Period - Start
Accounting Period - End
Project %

Description

Prompts

Provides a list of auxiliary invoices that have been charged to a department’s internal, auxiliary PO.

Department %
Fund Code %
Project %
Supplier ID %
Invoice %
PO Number %
*Invoice Date - Start
*Invoice Date - End

 

Queries for Selling Auxiliaries

Description

Prompts

Provides a list of outstanding receivables for auxiliary customers by auxiliary bill source.

*As of Date
Selling Dept ID like %
AUX Customer ID like %

Description

Prompts

Provides a list of items (bills) waiting to be invoiced in OMNI Financials.

Bill Source %

Description

Prompts

Provides a list of items (bills) that have been invoiced in OMNI Financials.

Bill Source %
Customer ID %
*Begin Date
*End Date

Description

Prompts

Provides a list of invoices and payment history for an auxiliary customer.

Customer ID %
*Acctg Date - Start
*Acctg Date - End
Bill Source %

Description

Prompts

Provides a list of all internal auxiliary purchase orders for a specific department
available to be used by internal auxiliary billers.

Dept ID %
*Start PO Date
*End PO Date
Project ID %
Fund %
*Business Unit
Supplier %
Supplier Name %

Description

Prompts

Provides a list of the auxiliary customers in OMNI Financials shared by all departments.

No prompts

Description

Prompts

Provides a list of accounts receivable invoice payments processed for auxiliary customers.

*Entered Date - Start
*Entered Date - End
Deposit ID %
Payment ID %
Customer ID %
Customer Name1 like %
Customer Name2 like %

 

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

 

 

Description

Prompts

Used to review Direct Journal Deposits and ARD Journal history.

*Jrnl Start Date
*Jrnl End Date
Fund %
Dept ID %
Project %
Account %
Journal ID%

Description

Prompts

Used to review payments processed through Transact for eMarket, cashier, and auxiliary customers.

*Cashnet Business Date Start
*Cashnet Business Date End

Description

Prompts

Used to review batches of deposits processed by Deposit Accounting.

*Begin Acct Dt
*End Acct Dt

Description

Prompts

Used to review the current day deposit postings with Chartfield information.

*Journal ID

Description

Prompts

Used to review history for all generated journals with vouchers listed by Chartfields, Journal Date, and Journal ID.

Fund %
Dept ID %
Project %
*Jrnl Start Date
*Jrnl End Date
Account %
Journal ID %
*Business Unit

Description

Prompts

Used to review history for all travel expense journals with Chartfields and Journal Dates.

Dept ID %
Fund %
Project %
*Jrnl Date From
*Jrnl Date To
Journal ID %
*Business Unit
Account %
Report ID %

Description

Prompts

Used to review opem items for open cash advances.

Empl ID like %
Dept like %
Fund like %
Project like %
*Begin Date
*End Date

 

Click on the query name to reveal a description and list of available prompts. Most travel reporting needs are best met through BI or Concur reporting located at https://controller.vpfa.fsu.edu/concur. If you have any questions, please email ctl-finsys@fsu.edu.

 

 

Description

Prompts

Shows ERs that are approved in Concur but have not paid out due to budget error (not including athletics)

 

Description

Prompts

Shows approvers in Concur.

Dept ID %
Fund Code %
Project ID %

Description

Prompts

Shows budget approvers as set up in OMNI(through Budget Office)

Dept ID %

 

Click on the query name to reveal a description and list of available prompts.  If you have any questions, please email ctl-finsys@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 ctl-finsys@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