FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

FMQuery – Payroll

Updated: March 23, 2018 – View Changes

Applicable to

State agencies


FMQuery is a business intelligence tool for authorized users of the statewide financial systems. It is part of the Comptroller’s initiative to establish an enterprise warehouse for the state’s data.

FMQuery – Payroll draws payroll information from the Uniform Statewide Payroll/Personnel System (USPS) and the Standardized Payroll/Personnel Reporting System (SPRS).

Users with security access can pose their own queries against their agency’s data.

For more information, see Overview of FMQuery – Payroll.


Log in to FMQuery – Payroll

NOTE: FMQuery users select “Enterprise” Authentication when logging in.


Overview of FMQuery – Payroll

SPRS Mapping Documents PDF

USPS Mapping Documents PDF


Training Center

FMQuery – Ad Hoc Web-based training


Questions about training for FMQuery – Payroll:

Contact your USPS or SPRS representative or call the Help Desk at (512) 463-4008.

Log on security or password reset:

Email, and a member of the Security Staff will provide assistance.

Changes to this Document
03/23/2018 Updated reference to training and FMQuery upgrade
04/16/2015 Added note about FMQuery upgrade delay
04/02/2015 Added information on Quick Start to Business Objects 4.1 class
05/19/2014 Updated to reflect current security requirements
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy