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