System Configuration

Overview

System Configuration is the foundational module that controls all aspects of Municipality Gateway setup and administration. This comprehensive configuration framework enables municipalities to customize the system to match their specific operational requirements, policies, and integration needs.

Core Configuration Areas

Municipal Setup and Organization

Purpose: Define the basic organizational structure and operational parameters for the municipality.

Key Configuration Elements:

• Municipal Identity: Official name, registration numbers, contact information

• Organizational Structure: Departments, divisions, and reporting hierarchies

• Service Areas: Geographic boundaries and service delivery zones

• Operational Parameters: Business hours, holiday schedules, emergency procedures

• Legal and Regulatory: Compliance requirements and regulatory frameworks

User Management and Security

Purpose: Comprehensive user access control and security configuration.

Security Framework Components:

• Role-Based Access Control (RBAC): Granular permission management

• User Authentication: Multiple authentication methods and policies

• Session Management: Timeout policies and concurrent session controls

• Audit and Compliance: Complete activity logging and compliance reporting

• Data Protection: GDPR compliance and data privacy controls

Integration Configuration

Purpose: Setup and management of all external system connections.

Integration Categories:

• Government Systems: National Registry, Tax Authority, Local authentication

• Financial Systems: Banking, payment processors, accounting systems

• Municipal Systems: Property management, utilities, permits

• Third-Party Services: Communication platforms, reporting tools

• Legacy System Integration: Mainframe and older system connections

Detailed Configuration Management

Municipal Organization Setup

Company Information Configuration

Navigation Path: System Configuration → Organization → Company Information

Required Configuration Fields:

[Screenshot: Company Information setup form showing all required fields with validation indicators]

Departmental Structure Configuration

Purpose: Define organizational hierarchy and responsibility areas.

Department Configuration Process:

1. Create Department Hierarchy:

   • Navigate to System Configuration → Organization → Departments

   • Define parent-child relationships between departments

   • Assign department codes and descriptions

   • Set up budget and financial reporting structures

2. Department-Specific Settings:

   Department: Recreation Services
   - Code: REC
   - Manager: Jón Jónsson
   - Budget Center: 1200
   - Service Areas: Sports, Youth Programs, Senior Activities
   - Locations: Municipal Sports Center, Community Centers
   - Contact Information: rec@municipality.is, +354-555-0123
   

3. Responsibility Assignment:

   • Service Delivery: Which services each department provides

   • Financial Authority: Spending limits and approval requirements

   • User Access: Which system modules each department can access

   • Reporting Structure: Hierarchical reporting relationships

Geographic and Service Area Configuration

Advanced Geographic Setup:

• Postal Code Management: Define service areas by postal codes

• District Boundaries: Map municipal districts and neighborhoods

• Service Delivery Zones: Areas for different service levels

• Emergency Response Zones: Critical service area definitions

• Demographic Classifications: Population density and service needs

User Management and Security Configuration

Role-Based Access Control (RBAC) Setup

Permission Architecture:

Super Administrator
├── System Administrator
│   ├── User Administrator
│   ├── Integration Administrator
│   └── Security Administrator
├── Department Administrator
│   ├── Recreation Administrator
│   ├── Finance Administrator
│   └── Permits Administrator
├── Service Staff
│   ├── Recreation Staff
│   ├── Customer Service
│   └── Cashier
└── Read-Only Users
    ├── Auditor
    ├── Reporting User
    └── Guest User

Detailed Role Configuration:

1. Super Administrator:

• System Access: Full system access and configuration

• User Management: Create/modify all user accounts and roles

• Integration Management: Configure all external system connections

• Security Control: Manage security policies and audit logs

• Financial Authority: Unlimited financial transaction authority

2. Department Administrator (Example: Recreation Administrator):

• Module Access: Full access to Recreation & Grant Management

• User Management: Create/modify users within department

• Financial Authority: Department budget limits (e.g., 500,000 ISK)

• Reporting Access: Department and cross-departmental reports

• Configuration: Department-specific settings and parameters

3. Service Staff (Example: Recreation Staff):

• Module Access: Recreation program management and enrollment

• Data Entry: Create and modify program applications

• Customer Service: Handle customer inquiries and support

• Financial Authority: Limited transaction authority (e.g., 50 EUR)

• Reporting Access: Operational reports within responsibility area

[Screenshot: Role configuration interface showing permission matrices and inheritance structures]

User Account Management

User Creation Process:

1. Basic User Information:

   • Navigate to System Configuration → Security → Users

   • Enter user personal information (name, email, phone)

   • Assign unique username and temporary password

   • Set account activation and expiration dates

2. Role Assignment:

   • Select primary role from configured role hierarchy

   • Add secondary roles if needed (principle of least privilege)

   • Configure department and location assignments

   • Set up delegation and substitute user relationships

3. Security Configuration:

   • Password Policy: Complexity requirements and expiration

   • Multi-Factor Authentication: SMS, email, or authenticator app

   • Session Management: Timeout settings and concurrent session limits

   • IP Restrictions: Limit access to specific IP ranges if needed

   • Time Restrictions: Limit access to specific days/hours

4. Integration Access:

   • API Access: Generate API keys for system integration

   • External Systems: Configure access to connected systems

   • Mobile Access: Enable/disable mobile application access

   • Portal Access: Configure customer portal administration rights

Authentication and Security Policies

Password Policy Configuration:

Password Requirements:
- Minimum Length: 12 characters
- Character Classes: Upper, lower, numeric, special (3 of 4 required)
- Dictionary Check: Prevent common passwords
- History: Cannot reuse last 12 passwords
- Expiration: 90 days (configurable)
- Lockout: 5 failed attempts, 30-minute lockout
- Complexity Score: Minimum score of 3/4

Multi-Factor Authentication (MFA) Setup:

• SMS Authentication: Integration with SMS service providers

• Email Authentication: Secure email-based second factor

• Authenticator Apps: Support for Google Authenticator, Microsoft Authenticator

• Hardware Tokens: Support for FIDO2/WebAuthn hardware keys

• Biometric Authentication: Mobile device biometric integration

Session Security Configuration:

• Session Timeout: Configurable inactivity timeout (default 120 minutes)

• Concurrent Sessions: Maximum simultaneous sessions per user

• Session Encryption: All session data encrypted in transit and storage

• Session Monitoring: Real-time monitoring of active sessions

• Force Logout: Administrative capability to terminate user sessions

Application Type and Service Configuration

Web Application Type Setup

Purpose: Configure the various services offered by the municipality.

Application Type Configuration Process:

1. Basic Type Information:

• Navigate to System Configuration → Applications → Application Types

• Create new application type or modify existing

• Configure basic information:

  Type Code: REC2024
  Description: Recreation Programs 2024
  Category: Recreation Services
  Department: Recreation Services
  Active: Yes
  Registration Period: 01/01/2024 - 03/31/2024
  Service Period: 04/01/2024 - 06/30/2024
  

2. Eligibility and Restrictions:

• Age Restrictions: Minimum and maximum age requirements

• Residency Requirements: Municipal resident vs. non-resident policies

• Prerequisites: Required previous participation or qualifications

• Medical Requirements: Health clearances or medical documentation

• Capacity Limits: Maximum number of participants

• Geographic Restrictions: Service delivery area limitations

3. Financial Configuration:

• Posting Type: How financial transactions are processed

  • Invoice: Generate sales invoices for services

  • Period Invoice: Create recurring billing

  • Journal: Post to general ledger

  • Bank Transfer: Direct bank account transactions

  • Support: Grant/subsidy processing

• Account Configuration:

  SQL

  Revenue Account: 4010 - Recreation Program Revenue
  Receivables Account: 1300 - Accounts Receivable
  Discount Account: 4090 - Recreation Discounts
  VAT Configuration: 24% Standard Rate
  Payment Terms: NET 30 Days
  

[Screenshot: Application Type configuration showing all setup tabs including eligibility, financial, and workflow settings]

Line Type Configuration

Purpose: Define specific services within each application category.

Detailed Line Type Setup:

Service Definition:

Line Type: SWIM_ADULT
Description: Adult Swimming Lessons
Category: Aquatic Programs
Base Price: 25,000 ISK
Capacity: 12 participants per session
Duration: 8 weeks, 1 session per week
Prerequisites: Basic swimming ability recommended
Equipment: Swimming attire required, equipment provided
Age Range: 18-65 years

Advanced Features Configuration:

• Multi-Level Programs: Progressive skill-based advancement

• Package Deals: Combined services with special pricing

• Season Passes: Unlimited access programs

• Equipment Rentals: Additional equipment and gear services

• Professional Services: Private lessons and coaching options

Capacity and Scheduling Management:

• Dynamic Capacity: Adjust capacity based on demand

• Waitlist Management: Automatic waitlist processing

• Schedule Templates: Reusable scheduling patterns

• Holiday Adjustments: Automatic holiday schedule modifications

• Make-up Sessions: Policies for weather or facility cancellations

Discount Rules and Pricing Configuration

Comprehensive Discount System Setup

Navigation Path: System Configuration → Pricing → Discount Rules

Discount Rule Categories:

1. Family Discounts:

Discount Rule: FAMILY_SIBLING
Name: Family Sibling Discount
Type: Percentage
Structure:
  First Child: 0% (full price)
  Second Child: 25% discount
  Third Child: 40% discount
  Fourth+ Children: 50% discount
Maximum Family Discount: 60% of total
Eligibility:
  - Same family unit (verified via National Registry)
  - Same program type
  - Concurrent enrollment
Effective Period: 01/01/2024 - 12/31/2024

2. Age-Based Discounts:

Age Discount Categories:
  Children (0-12):
    - Base Discount: 30% off adult pricing
    - Senior Child (10-12): 20% off adult pricing
  Youth (13-17):
    - Standard Youth: 15% off adult pricing
    - Student ID Required: Additional 5% discount
  Adults (18-66):
    - Standard Pricing: No discount
    - Municipal Employee: 10% discount
  Seniors (67+):
    - Senior Discount: 25% off standard pricing
    - Disability Additional: 15% additional discount

3. Geographic and Economic Discounts:

• Residency-Based Pricing:

  Local Residents (Municipal postal codes): Standard pricing
  Regional Residents (Neighboring areas): 10% surcharge
  Non-Residents: 25% surcharge
  Tourist Rates: 50% surcharge
  

• Income-Based Assistance:

  Low Income (Verified): Up to 80% discount
  Moderate Income: Up to 40% discount
  Unemployment Assistance: Special consideration process
  Student/Senior Fixed Income: Sliding scale pricing
  

[Screenshot: Discount rule configuration wizard showing percentage settings, eligibility criteria, and validation rules]

Integration and External System Configuration

National Registry (RSK) Integration Setup

Purpose: Configure real-time data verification and synchronization.

Integration Configuration Steps:

1. Technical Setup:

• Navigate to System Configuration → Integrations → National Registry

• Configure connection parameters:

  Service Endpoint: https://api.rsk.is/v2/
  Authentication Method: X.509 Certificate
  Certificate Path: /certificates/rsk-production.pfx
  Service Timeout: 30 seconds
  Retry Policy: 3 attempts, exponential backoff
  Rate Limiting: 1000 requests per hour
  

2. Data Synchronization Settings:

• Real-Time Lookups: Person and address verification

• Batch Updates: Daily address and status synchronization

• Data Retention: Cache personal data for 24 hours maximum

• Privacy Compliance: GDPR-compliant data handling

• Error Handling: Fallback procedures for service unavailability

3. Service Usage Configuration:

RSK Services Enabled:
  Person Lookup: 
    - Enabled: Yes
    - Purpose: Application eligibility verification
    - Data Fields: Name, Address, Birth Date, Family Relations
    - Usage Limit: 500 lookups per day
    
  Address Validation:
    - Enabled: Yes
    - Purpose: Residence verification for discount eligibility
    - Auto-Update: Yes
    - Update Frequency: Daily
    
  Death Registry:
    - Enabled: Yes
    - Purpose: Automatic account status updates
    - Notification: Email to administrators
    - Action: Mark accounts inactive

Local authentication - Government Integration

Purpose: Connect with national government services and grant systems.

Service Integration Configuration:

1. Authentication Setup:

OAuth 2.0 Configuration:
- Client ID: [Assigned by Island.is]
- Client Secret: [Secure storage in key vault]
- Scope: grants.read grants.write identity.read documents.read
- Token Endpoint: https://auth.island.is/oauth2/token
- Redirect URI: https://municipality.is/auth/callback
- Grant Type: authorization_code

2. Grant System Integration:

Recreation Grants:
  API Endpoint: https://api.island.is/grants/recreation
  Automatic Submission: Yes
  Real-time Status Check: Yes
  Document Upload: Automatic
  Payment Processing: Direct to municipal account
  Compliance Reporting: Automatic quarterly reports
  
Service Integration:
  Digital Identity: Citizen authentication
  Document Services: Official document requests
  Notification Services: Government communications
  License Management: Municipal permit integration

3. Data Synchronization Rules:

• Grant Applications: Submit within 24 hours of municipal approval

• Status Updates: Check grant status daily

• Payment Notifications: Real-time payment receipt processing

• Document Management: Secure document exchange

• Audit Trail: Complete interaction logging

[Screenshot: Island.is integration dashboard showing connected services, status indicators, and configuration options]

Payment System Integration

Purpose: Configure multiple payment processors and financial institutions.

Multi-Provider Configuration:

1. Credit Card Processing:

Primary Processor: Borgun (Icelandic)
  Merchant ID: [Assigned ID]
  Terminal ID: [Terminal assignment]
  Currency: ISK
  Supported Cards: Visa, Mastercard, American Express
  Transaction Limits: 
    Single Transaction: 500,000 ISK
    Daily Limit: 5,000,000 ISK
  Settlement: Next business day
  Fees: 1.8% + 5 ISK per transaction

Secondary Processor: Stripe (International)
  Account ID: [Stripe account ID]
  Supported Cards: International cards
  Currency Conversion: Automatic
  Transaction Limits:
    Single Transaction: €2,000 equivalent
    Daily Limit: €20,000 equivalent
  Settlement: T+2 business days
  Fees: 2.9% + €0.30 per transaction

2. Bank Integration Configuration:

Primary Bank: Landsbankinn
  Account Number: [Municipal account]
  IBAN: IS14 0159 2600 7654 5510 7303 39
  SWIFT Code: LANXIS22
  File Format: Icelandic standard
  Processing Schedule: Daily at 14:00
  Authorization: Digital signature required
  
Direct Debit Configuration:
  Mandate Management: Digital consent system
  Processing Frequency: Monthly
  Notification Period: 10 days advance notice
  Failure Handling: Automatic retry after 3 days
  Compliance: SEPA and local regulations

3. Payment Method Routing:

Routing Rules:
  Amount < 10,000 ISK: Primary processor (lower fees)
  Amount >= 10,000 ISK: Route to bank for direct processing
  International Cards: Secondary processor
  Recurring Payments: Direct debit system
  Failed Transactions: Failover to secondary processor
  
Settlement Configuration:
  Reconciliation: Automatic daily
  G/L Posting: Automatic to configured accounts
  Dispute Management: Automated dispute handling
  Reporting: Real-time transaction reporting

Advanced System Configuration

Workflow and Approval Configuration

Purpose: Define business process workflows and approval hierarchies.

Workflow Types and Configuration:

1. Application Approval Workflow:

Workflow: Recreation Application Approval
Trigger: New application submitted
Conditions:
  - Application amount > 50,000 ISK: Requires supervisor approval
  - Applicant age < 18: Requires guardian verification
  - Special needs accommodation: Requires department head approval
  - Grant funding requested: Requires financial approval
  
Approval Steps:
  1. Automatic Validation:
     - Check eligibility criteria
     - Verify capacity availability
     - Calculate pricing and discounts
     
  2. Staff Review:
     - Assign to available staff member
     - Review application completeness
     - Verify supporting documentation
     
  3. Supervisor Approval (if required):
     - Financial threshold exceeded
     - Policy exception requested
     - Special circumstances noted
     
  4. Final Processing:
     - Generate invoice/receipt
     - Send confirmation to applicant
     - Update capacity tracking
     - Trigger payment processing

2. Financial Approval Limits:

Approval Authority Matrix:
  Staff Level:
    Single Transaction: 10,000 ISK
    Daily Limit: 50,000 ISK
    Special Approvals: None
    
  Supervisor Level:
    Single Transaction: 100,000 ISK
    Daily Limit: 500,000 ISK
    Special Approvals: Policy exceptions up to 25,000 ISK
    
  Department Head:
    Single Transaction: 500,000 ISK
    Daily Limit: 2,000,000 ISK
    Special Approvals: Policy exceptions up to 100,000 ISK
    
  Municipal Manager:
    Single Transaction: 2,000,000 ISK
    Daily Limit: No limit
    Special Approvals: All policy exceptions

Notification and Communication Configuration

Purpose: Configure automated communications and alerts.

Communication Channel Setup:

1. Email Configuration:

SMTP Server Configuration:
  Server: smtp.municipality.is
  Port: 587 (STARTTLS)
  Authentication: username/password
  Encryption: TLS 1.2
  Connection Pool: 10 connections
  Timeout: 30 seconds
  
Email Templates:
  Application Confirmation:
    Subject: "Application Received - {ApplicationNumber}"
    Body: HTML template with application details
    Attachments: Application summary PDF
    Language: Auto-detect (Icelandic/English)
    
  Payment Reminder:
    Subject: "Payment Due - {InvoiceNumber}"
    Body: Payment instructions and due date
    Frequency: 7 days, 3 days, 1 day before due
    Escalation: Department notification after 30 days overdue

2. SMS Integration:

SMS Provider: Nova Iceland
  API Endpoint: https://sms.nova.is/api/v1/
  Authentication: API key
  Character Limit: 160 characters
  Rate Limit: 100 messages per minute
  
SMS Notifications:
  Payment Confirmation: "Payment received for {ServiceName}. Amount: {Amount} ISK"
  Application Status: "Application {Number} status: {Status}"
  Appointment Reminder: "Reminder: {ServiceName} on {Date} at {Time}"
  Emergency Alerts: "URGENT: {Message}"

3. Mobile App Push Notifications:

Push Notification Service: Firebase Cloud Messaging
  Project ID: municipality-app
  Server Key: [Secure key storage]
  
Notification Types:
  Application Updates: Real-time status changes
  Payment Reminders: Due date notifications
  Service Alerts: Schedule changes or cancellations
  General Announcements: Municipal news and updates

[Screenshot: Communication configuration panel showing email templates, SMS settings, and push notification management]

Performance and Monitoring Configuration

Purpose: Configure system monitoring, alerting, and performance optimization.

Monitoring Configuration:

1. Performance Metrics:

System Metrics:
  CPU Usage: Alert at 80% sustained for 5 minutes
  Memory Usage: Alert at 85% sustained for 3 minutes
  Disk Space: Alert at 90% usage
  Network Latency: Alert at 500ms average response time
  Database Performance: Alert at 2 second average query time
  
Application Metrics:
  API Response Time: Target < 200ms, Alert > 1 second
  Transaction Success Rate: Target > 99%, Alert < 95%
  User Session Length: Monitor for optimization
  Error Rates: Alert at > 1% error rate
  Integration Health: Monitor all external connections

2. Alert Configuration:

Alert Levels:
  INFO: Log only, no notification
  WARNING: Email to administrators
  ERROR: Email + SMS to on-call staff
  CRITICAL: Email + SMS + Phone call escalation
  
Alert Recipients:
  System Administrators: All system alerts
  Department Managers: Department-specific alerts
  On-Call Staff: Critical alerts only
  Municipal Manager: Daily summary + critical alerts
  
Escalation Rules:
  Level 1: Initial alert to primary contact
  Level 2: After 15 minutes, alert backup contact
  Level 3: After 30 minutes, alert department manager
  Level 4: After 60 minutes, alert municipal manager

3. Performance Optimization:

Database Optimization:
  Index Maintenance: Weekly automated rebuild
  Statistics Update: Daily automated update
  Query Optimization: Monthly performance review
  Archive Policy: Archive data older than 7 years
  
Caching Configuration:
  Application Cache: 4GB memory allocation
  Database Cache: 8GB buffer pool
  Web Cache: 2GB for static content
  Session Cache: Redis cluster for session data
  
Load Balancing:
  Web Servers: 2 active, 1 standby
  Database: Primary/secondary with automatic failover
  File Storage: Distributed across 3 nodes
  Backup Systems: Daily incremental, weekly full

Security and Compliance Configuration

Data Protection and Privacy

Purpose: Ensure GDPR compliance and data security.

Data Protection Configuration:

1. Data Classification:

Public Data:
  - Municipal contact information
  - Public service descriptions
  - General announcements
  Retention: Indefinite
  Access: Public
  
Internal Data:
  - Employee information
  - Financial records
  - System configurations
  Retention: 7 years after employment/relevance ends
  Access: Role-based
  
Personal Data:
  - Citizen applications
  - Payment information
  - Communication records
  Retention: 5 years after service completion
  Access: Need-to-know basis
  
Sensitive Personal Data:
  - Medical information
  - Social security numbers
  - Financial details
  Retention: Minimum required period
  Access: Highly restricted

2. Data Processing Controls:

• Purpose Limitation: Data only used for stated purposes

• Data Minimization: Collect only necessary information

• Accuracy: Regular data verification and correction

• Storage Limitation: Automatic deletion after retention periods

• Integrity and Confidentiality: Encryption and access controls

3. Citizen Rights Management:

GDPR Rights Implementation:
  Right of Access:
    - Self-service portal for data viewing
    - Automated data export functionality
    - Response time: Within 30 days
    
  Right of Rectification:
    - Online correction requests
    - Verification process for changes
    - Automatic update propagation
    
  Right of Erasure:
    - Data deletion request workflow
    - Legal basis verification
    - Complete data removal across all systems
    
  Right of Portability:
    - Standardized data export formats
    - Secure data transfer mechanisms
    - Verification of recipient systems

[Screenshot: Data protection dashboard showing data categories, retention policies, and citizen rights management interface]

Audit and Compliance Configuration

Purpose: Comprehensive audit trails and regulatory compliance.

Audit Configuration:

1. Activity Logging:

Logged Activities:
  User Actions:
    - Login/logout events
    - Data access and modifications
    - System configuration changes
    - Report generation and export
    
  System Events:
    - Integration activities
    - Batch processing results
    - Error conditions and recovery
    - Performance threshold breaches
    
  Financial Transactions:
    - Payment processing
    - Invoice generation
    - Refund processing
    - Financial report access
    
Data Retention:
  Activity Logs: 7 years
  System Logs: 3 years  
  Error Logs: 5 years
  Financial Logs: 10 years

2. Compliance Reporting:

Automated Reports:
  GDPR Compliance:
    - Data processing activities register
    - Privacy impact assessments
    - Data breach notifications
    - Citizen rights fulfillment
    
  Financial Compliance:
    - Transaction audit trails
    - Revenue reconciliation
    - Tax reporting data
    - Grant compliance reporting
    
  Operational Compliance:
    - Service level achievement
    - User access reviews
    - System security assessments
    - Integration health reports

Best Practices and Advanced Configuration

Configuration Management Best Practices

Version Control and Change Management

Configuration Versioning:

• Version Control: All configuration changes tracked and versioned

• Change Approval: Multi-level approval for configuration changes

• Rollback Capability: Ability to revert to previous configurations

• Documentation: Complete documentation of all configuration changes

• Testing: Configuration changes tested in sandbox environment first

Backup and Disaster Recovery

Configuration Backup Strategy:

Backup Schedule:
  Configuration Data: Daily incremental, weekly full
  User Data: Real-time replication + daily backup
  System Settings: Weekly full backup
  Integration Configurations: Daily backup
  
Recovery Procedures:
  Configuration Recovery: 15 minutes (automated)
  Full System Recovery: 4 hours (manual process)
  Data Recovery: 1 hour (automated from replicas)
  Integration Recovery: 30 minutes (automated failover)

Performance Tuning and Optimization

System Performance Configuration

Resource Allocation:

• Memory Management: Optimal memory allocation for different services

• CPU Utilization: Load balancing and processing optimization

• Storage Performance: SSD allocation for high-performance requirements

• Network Optimization: Bandwidth allocation and traffic prioritization

Database Performance Optimization

Database Configuration:

-- Index optimization for common queries
CREATE INDEX IX_WebApplication_Status_Date 
ON SveSwa_WebApplication(Status, ApplicationDate);

CREATE INDEX IX_WebBatch_ProcessingDate 
ON SveSwa_WebBatch(ProcessedDate, Status);

-- Partitioning strategy for large tables
CREATE PARTITION FUNCTION PF_ApplicationDate (DATETIME)
AS RANGE RIGHT FOR VALUES 
('2024-01-01', '2024-04-01', '2024-07-01', '2024-10-01');

-- Performance monitoring queries
CREATE VIEW v_SystemPerformance AS
SELECT 
    'Applications' as TableName,
    COUNT(*) as RecordCount,
    MAX(CreatedDate) as LastRecord
FROM SveSwa_WebApplication
UNION ALL
SELECT 
    'Batches',
    COUNT(*),
    MAX(ProcessedDate)
FROM SveSwa_WebBatch;

Next: Reports & Analytics - Comprehensive reporting and data analysis capabilities