The Zodiac Data System is our comprehensive data management solution designed to streamline volunteer coordination and session management. This wiki serves as the central knowledge base for all system-related documentation.

Zodiac uses a hybrid architecture that combines the power of Microsoft's business solutions with custom mobile development:

• Microsoft Power Apps - Core data system and business logic
• Dataverse - Underlying database structure
• Power Automate - Workflow automation

• Power Pages - Primary web portal for administrators and volunteers
• Flutter Application - Cross-platform mobile experience for on-the-go access

The system is built around four primary tables with the following relationships:

┌──────────┐       ┌─────────┐       ┌─────────┐
│  Contact │◄──────┤ Session │◄──────┤  Funds  │
└────┬─────┘       └─────────┘       └─────────┘
     │
     │               ┌────────┐
     └───────────────┤  User  │
                     └────────┘

• Contact

  • Contains all stakeholder information
  • Differentiates between volunteer contacts and parent contacts
  • One volunteer can manage multiple sessions
  • Parent contacts may be associated with volunteer contacts

• Session

  • Tracks individual program sessions
  • Contains session metadata (time, location, status)
  • Connected to specific volunteers (Contact)
  • Links to associated funding

• Funds

  • Manages financial data associated with sessions
  • Tracks donations, expenses, and allocations

• User

  • System authentication and authorization
  • User preferences and system settings
  • Role-based permissions

• Contact to Session - One-to-many relationship where a single volunteer (Contact) can be associated with multiple Sessions
• Parent to Volunteer - Parent Contacts can be associated with Volunteer Contacts
• Session to Funds - Sessions can be linked to specific funding records

• Admin Portal - admin.zodicdatasystem.org (Power Pages)
• Volunteer Portal - volunteers.zodiacdatasystem.org (Power Pages)
• Mobile App - Available for iOS and Android (Flutter)

• System Architecture - Detailed technical implementation
• Data Dictionary - Complete field-level documentation
• User Guides - Role-based instruction manuals
• Development Guidelines - For technical contributors
• API Documentation - Integration endpoints and protocols
• Troubleshooting - Common issues and solutions

• New Administrators: Begin with the Admin Onboarding Guide
• New Volunteers: Check the Volunteer Quick Start
• Developers: See the Development Environment Setup

Last updated: May 3, 2025

Need help? Contact the system administrators at [email protected]

The Zodiac Data System is our comprehensive data management solution designed to streamline volunteer coordination and session management. This wiki serves as the central knowledge base for all system-related documentation.

Zodiac uses a hybrid architecture that combines the power of Microsoft's business solutions with custom mobile development:

• Microsoft Power Apps - Core data system and business logic
• Dataverse - Underlying database structure
• Power Automate - Workflow automation

• Power Pages - Primary web portal for administrators and volunteers
• Flutter Application - Cross-platform mobile experience for on-the-go access

The system is built around four primary tables with the following relationships:

┌──────────┐       ┌─────────┐       ┌─────────┐
│  Contact │◄──────┤ Session │◄──────┤  Funds  │
└────┬─────┘       └─────────┘       └─────────┘
     │
     │               ┌────────┐
     └───────────────┤  User  │
                     └────────┘

• Contact

  • Contains all stakeholder information
  • Differentiates between volunteer contacts and parent contacts
  • One volunteer can manage multiple sessions
  • Parent contacts may be associated with volunteer contacts

• Session

  • Tracks individual program sessions
  • Contains session metadata (time, location, status)
  • Connected to specific volunteers (Contact)
  • Links to associated funding

• Funds

  • Manages financial data associated with sessions
  • Tracks donations, expenses, and allocations

• User

  • System authentication and authorization
  • User preferences and system settings
  • Role-based permissions

• Contact to Session - One-to-many relationship where a single volunteer (Contact) can be associated with multiple Sessions
• Parent to Volunteer - Parent Contacts can be associated with Volunteer Contacts
• Session to Funds - Sessions can be linked to specific funding records

• Admin Portal - [admin.zodicdatasystem.org](https://admin.zodicdatasystem.org) (Power Pages)
• Volunteer Portal - [volunteers.zodiacdatasystem.org](https://volunteers.zodiacdatasystem.org) (Power Pages)
• Mobile App - Available for iOS and Android (Flutter)

• System Architecture - Detailed technical implementation
• Data Dictionary - Complete field-level documentation
• User Guides - Role-based instruction manuals
• Development Guidelines - For technical contributors
• API Documentation - Integration endpoints and protocols
• Troubleshooting - Common issues and solutions

• New Administrators: Begin with the Admin Onboarding Guide
• New Volunteers: Check the Volunteer Quick Start
• Developers: See the Development Environment Setup

Last updated: May 3, 2025

Need help? Contact the system administrators at [email protected]