Back     Home     Help  

Transparency Mississippi

Pre-Defined Queries

Template Queries

Open a Saved Query

Template Tutorial

Daily, Weekly and Monthly Load Information for SAAS

Mississippi.gov


MMRS Call Center
(601) 359-1343

Comments!
Questions?
Click here to e-mail one of our MMRS Applications Staff.


Template Queries allow you the flexibility to create a new customized report by defining selection criteria (e.g. filter on Budget Year = 1999), grouping or sorting, and choosing desired columns. See the Template Tutorial for online instructions on how to create, modify, and save report templates.

Currently MERLIN.net has 4 areas of Template Queries: Financial, Payroll, Property, Travel.

 Travel
 
If you are using a date field, i.e. Void Date, in your query please be aware that any transactions where this field is blank will show the following entry in the field '12:00:00 am'. This is a system default.
 
 Travel Summary
Agency SPAHRS travel expenditure summary information complete with earning codes and tax codes for each person and trip. This information is updated upon completion of a SPAHRS travel payroll run and is provided as of July 1, 2000.

 Travel Transaction Detail
Agency detail transaction information by accounting coding block (fund number, project code, reporting category code), transaction number, agency, budget year and accounting month. This information is updated upon completion of a SPAHRS travel payroll run. SPAHRS transactions are provided as of July 1, 2000.

  Back     Home     Help