Open a Saved Query
Daily, Weekly and Monthly Load Information for SAAS
MMRS Call Center
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.
|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.