Revenues & Benefits: Data Cleanse - Consultancy

Service Features

• Initial Assessment: Evaluate the current database and provide reports that will help customers decide on the system start date.
• Planning: Develop a detailed project plan outlining the steps, timelines, and resources required for the data cleanse.
• Data Cleansing: Account records removed if prior to SSD, or liabilities will be adjusted if the account occupancies straddle the SSD. Housing benefits claims retained based on application date, assessment lines, and subsidy records.
• Reports: Standard Pre-SSD data reports account and balance export can be provided in csv format. Additional reports and data retention process can be undertaken based on customer requirements, costed and quoted separately. 

Benefits of the Service

• Improved System Performance: Enhances the performance of the new system by removing outdated or irrelevant data.
• Data Integrity: Ensures that only relevant and accurate data is retained, maintaining data integrity.
• Compliance: Helps in meeting regulatory requirements by ensuring proper data management practices.

Key Considerations

•  System Start Date (SSD) Determination: The customer needs to decide on the SSD based on the need to delete data versus the operational impact of removing that data. The SSD must be 1st April for the specific year, with the restriction that the Benefits system start date cannot be prior to the Council Tax system start date. For the Business Rates application, the start date should be aligned to a rating list year (e.g., start of the previous list year, 01.04.2017).
• Data Security: Ensure that all data cleansing processes comply with data protection regulations.
• Stakeholder Communication: Maintain clear communication with stakeholders throughout the cleansing process.
  •    Risk Management: Identify potential risks and develop mitigation strategies to address them.