Financial Management System (FMS) Document Index

Document	Last Updated (mm/dd/yyyy)
State Auditor's Data Download 2020-2021	07/27/2021
FMS and Spring Quarter 2020 Start Date Change	03/27/2020
IRS 1098T Access Database	11/27/2019
Credit Card Encryption Process	12/08/2009
FMS Frequently Asked Questions (FAQs)
Handling Net-Negative Contributions	02/26/2009
Student Tuition Easy Payment Plan (STEPP) Instructions	04/09/2008

FMS Query is an MS Access front-end reporting tool that provides financial reports such as Budget Status, Expense, Payroll, Revenue, Grants and Contracts. These data are refreshed nightly with information from the HP3000. FMS Query also allows for ad hoc query writing. Below are links to setup instructions, job scheduling instructions and the vanilla version of the FMS Query MS Access database reporting tool.

FMS Query is not an official SBCTC-ITD module, and therefore is not subject to SBCTC-ITD college-based customization. However, SBCTC-ITD does maintain a vanilla version of the database and supporting DataExpress procedures that colleges may opt to customize to meet their needs.

If you have questions or need assistance setting up or using FMS Query, contact SBCTC-ITD at support@sbctc.edu or call the support line at 360-704-4357.

Document	Last Updated (mm/dd/yyyy)
Setting Up FMS Query Instructions for setting up the FMS Query tool using SQL Server for storing the data extracts. Extracts are created by scheduling the DataExpress ZX2113J job. MS Access is then used as the front end tool to access the information in a user-friendly manner.
FMS Query Job Scheduling Instructions Instructions for using ZX2113J to schedule the DataExpress procedures that extract data to populate the FMS Query database.	08/28/2019
FMS Query Access Database V3.0 (SID) Version 3.0 of the FMS Query tool. This version contains the update from EMP-ID (SSN) to employee SID.
FMS Query SID Change Information Describes the changes made to tables, queries, reports, and forms to update the FMS Query tool to remove EMP-ID and replace with SID.
DataExpress FM2006R2 Notification Notification change for DataExpress procedure FM2006R2 (replaces FM2006R). This report extracts SID instead of EMP-ID.

Document	Last Updated (mm/dd/yyyy)
Jan. 30, 2009 General Implementation	01/28/2009
May 21, 2004 Hot Implementation
Aug. 16, 2002 Table 3 Implementation
July 11, 2002 General Implementation
July 16, 2001 General Implementation
June 8, 2001 Table 3 Implementation
April 27, 2001 General Implementation
July 14, 2000 General Implementation