Revenues & Benefits: Bespoke SQL Writing Service - Consultancy

Service Features

• Tailored SQL: Writing SQL queries to retrieve specific datasets based on unique business requirements.
• Databases Covered: Queries can be written against the following MRI databases:
  • hbctlivedb (Housing Benefits & Council Tax)
  • nrlivedb (Non-Domestic Rates)
  • imlivedb (Income Management)
  • crlivedb (Corporate Recovery)
  • sslivedb (Subsidy)
  • MRI EDMS database
• Reports: Designing and developing custom reports using SQL queries.
• Technical Support: Access to our expert team for troubleshooting and resolving SQL-related issues.
  

To ensure the successful development and implementation of SQL scripts, the following pre-requisites must be met:

• Scope Definition: Clearly define the scope of the reporting project, including specific functionalities required.
• Out of scope: SQL that would need complex calculation or processing and where data is not readily available in the database.
• Out of scope: Any request that requires updates to the database (e.g., inserts, updates, deletes).
• Report format: Results will be delivered in .txt format, unless otherwise specified.