Home > Projects > Municipal Applications > Development Tracking Configuration  
Case Study:

Regional Municipality of Ottawa-Carleton - Development Tracking Configuration

Other work with the Regional Municipality of Ottawa-Carleton entailed configuring MAP to support Regional Development Charges (RDC). An example of the activities completed include the following tasks:

  • Configuration of RDC fee types
  • Configuration of fees received, account allocations
  • Developed process for calculating area specific development charges
  • Configuration of area specific development charges calculation
  • Configuration of system for development charge exemptions
  • Creation of custom SQL statements for the creation of the calculations and allocation summaries to be used in reporting
  • Creation of Crystal Reports for:
    • Daily Journal & GL summary
    • Monthly Journal and GL summary
    • RDC Revenue by application
    • RDC Revenue by Municipality - Residential
    • RDC Revenue by Municipality - Non-Residential
    • Total Collection by Municipality - Year to Date