Gov Event Management Data Model v1.1.0.0

---

Release notes for Gov Event Management data model v1.1.0.0

November 12, 2024

This major release significantly expands the Event Management data model to support complex multi-day conferences, comprehensive participant management, financial tracking, and document management capabilities.

New Tables

• Event Type: Reference table for event categorization
  • Fields: Name
• Event Sponsor: Tracks organizational sponsors providing funding or support
  • Fields: Name, Event, Funding, Funding (Base), Currency, Exchange Rate, Organization, Organization Contact
• Event Session: Represents sessions within events (workshops, presentations, breakouts)
  • Fields: Name, Event, Description, Start Date Time, End Date Time, Room, Session Type, Parent Event Session
• Event Participant: Captures specialized roles like speakers, judges, presenters
  • Fields: Name, Event, Person
• Event Session Participant: Tracks participation in specific event sessions
  • Fields: Name, Event Session, Person
• Event Entry: Represents event entries or registrations
  • Fields: Name, Event
• Event Request: Manages requests related to events
  • Fields: Name, Event
• Event Track: Provides thematic organization for large conferences
  • Fields: Name, Event
• Document: Manages event-related documents
  • Fields: Name
• Location: Represents event venues and locations
  • Fields: Name

Enhanced Tables

• Event: Significantly expanded with comprehensive event management capabilities
  • Added: Event Category (picklist), Event Type (lookup), Event Location (lookup)
  • Added: Registration Start/End Date Time, Documents Required (picklist), Commitment Status (picklist)
  • Added: Document Management - Agenda Document, Terms and Conditions Document, CDA/NDA Document, FAQ Document, Volunteer Document
  • Added: Visual Elements - Event Logo (image), Event Image (image)
  • Added: Financial Tracking - Total Funding Available, Total Funding Remaining, Total Funding Used (with base currency variants)
  • Added: Registration Management - Total Planned Registration, Total Registered Participants
  • Added: Currency support with Currency and Exchange Rate fields

Breaking Changes

• Event Type field changed from picklist to lookup relationship with new Event Type table
• Enhanced model complexity requires careful migration planning for existing implementations

This release transforms the Event Management module from a basic scheduling tool into a comprehensive event planning and execution platform suitable for everything from simple meetings to complex multi-day government conferences with hundreds of participants, multiple sponsors, and detailed financial tracking.