Garnet Module
Business Domain: Programme Delivery Tables: 106 Core Function: Principal projects, allocations, billing, contracts
Overview
The Garnet module handles the complete programme delivery lifecycle, including principal project management, company allocation, monthly billing processing, certificate and contract generation, and lump sum allocation management.
Documentation Sections
Context Documentation
High-level documentation for different stakeholder perspectives:
| Document | Description |
|---|---|
| Architect Context | Complete technical data model with tables, fields, and relationships |
| PO Context | Business-focused overview with form descriptions and workflows |
| Dev Context | VBA implementation details, procedures, and code patterns |
Forms
User interface forms for data entry and management:
Company Management
- Add and Edit Entrepreneur Company
- Add and Edit Entrepreneur Company Sub Products
- Add and Edit Company Status
- Add and Edit Company Programme Year
- Add and Edit Company Programme Year Status
- Edit Company Status
- Edit Company Programme Year Status
Company Lists
- Company List
- Company On Programme List
- Company Graduating List
- Company Ignition List
- Company Raizcorpossible List
- Company Add Allocation List
Principal & Project Management
Allocation & Billing
- Edit Company Allocation
- Lump Sum Allocation
- Lump Sum Allocation Dialog
- Monthly Billings
- Monthly Billings Menu
- Monthly Billings Date Dialog
- Add Company Monthly Billing
- Edit Company Monthly Billing
- View and Edit Monthly Billings
Sponsor Elements
Mail Merge & Documents
Reports & Dialogs
- Report Menu
- Report Writer Dialog
- Reports Date Dialog
- Reports Print Export Dialog
- Principal Report Date Dialog
- Principal Project Status Report Dialog
- Opal Scorecard Report Dialog
- Delivery vs Exited Report Dialog
- Part Sponsorship History Reports Date Dialog
Maintenance & Configuration
- Maintenance Menu
- Opening Dialog
- Change Password
- Edit Email Recipient List
- Add and Edit Primary Tenant
- Add and Edit Secondary Tenant
- Add and Edit Non Graduate Reason
- Add and Edit Replacement Status
Subforms
- SubFrm Company Programme Year Status History
- SubFrm Company Status History
- SubFrm Edit Company Principal Project
- SubFrm Entrepreneur Company Areas of Operation
- SubFrm Entrepreneur Company Commodities
- SubFrm Entrepreneur Company Extra Sponsor Payments
- SubFrm Entrepreneur Company Supporting Documents
- SubFrm Entrepreneur Recommended Information
- SubFrm Principal Project Pillars
- SubFrm Principal Project Pillar Commodities
- SubFrm Principal Project Pillar Delivery Location
- SubFrm Principal Project Pillar Sourced From
- SubFrm Principal Project Pillar Sponsor Elements
- SubFrm Principal Project Pillar Sub Products
- SubFrm Principal Project Pillar Supporting Documents
- SubFrm Principal Project Products Sold
- SubFrm Total Billed To Date by Company PP
VBA Modules
Code modules containing business logic and utilities:
Utility Modules
- basRelink - ODBC connection management
- Mod Utilities - General utility functions
- Mod Export Excel - Excel export functionality
- Mod Send Outlook Message - Email automation
Form Code Modules
See the modules directory for form-specific VBA code documentation.
Queries
SQL queries for data retrieval and reporting. Key query categories:
- Company Queries - Company lists, allocations, billing
- Principal Project Queries - Project management and tracking
- Report Queries - Financial and operational reporting
- Opal Scorecard Queries - Graduation tracking and metrics
See the queries directory for the complete list.
Tables
Database tables for data storage:
Core Tables
Billing & Allocation
Lookups & Reference
See the tables directory for the complete schema documentation.
Reports
- Reports - Access report definitions
Dependencies
- Module Dependencies - Cross-module relationships and shared entities
Related Modules
| Module | Relationship |
|---|---|
| Purple | Receives entrepreneurs for programme allocation |
| Amber | Financial tracking integration |
| Vanadium | Session and guiding management |
Part of the REMS (Raizcorp Entrepreneurial Management System) documentation