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.
|
|