REMS - Raizcorp Entrepreneurial Management System

Documentation Generated: 2025-11-30 (Deep Scan) Project Type: Microsoft Access VBA Desktop Database Application Architecture: Monorepo with 11 Interconnected Modules

Executive Summary

REMS (Raizcorp Entrepreneurial Management System) is a comprehensive enterprise management platform built on Microsoft Access with VBA automation. The system manages the complete lifecycle of entrepreneur development programmes, from lead capture and selection through programme delivery, financial tracking, and graduation.

The application is structured as a monorepo containing 11 specialized modules, each handling distinct business domains while sharing common data entities through SQL Server (ODBC) backend connections.

System Architecture

Module Overview

Module	Tables	Business Domain	Core Function
Purple	152	Entrepreneur Selection	Lead management, EA assessments, Purple Panel selection
Garnet	106	Programme Delivery	Principal projects, allocations, billing, contracts
Ruby	112	Human Resources	Recruitment, employee management, training, disciplinary
Emerald	117	Sales & CRM	Proposals, sales briefs, client management
Vanadium	53	Learning & Guiding	Session management, attendance, guide scheduling
Gateway	55	Integration Hub	Cross-module data aggregation
Amber	44	Financial Tracking	Submissions, pre-ignition financials, bookkeeping
Topaz	46	Operations	Delivery locations, user permissions
Gia	36	Company Management	Business area tracking, status management
Purple Weave	35	Action Planning	Priority actions, follow-up management
Audit	23	Compliance	Financial audit, allocation tracking

Total: 779 database tables, 3,562 documented markdown files

Technology Stack

Layer	Technology	Details
Frontend	MS Access Forms	400+ user interface forms
Business Logic	VBA (Visual Basic for Applications)	Event handlers, validation, automation
Database	SQL Server (ODBC)	Backend data storage via linked tables
Reporting	MS Access Reports	100+ financial and operational reports
Integration	Outlook Automation	Email notifications, mail merge
Export	Excel Automation	Data export and reporting

Common VBA Patterns

Actdatabase - Active database connection singleton
RecSet - ADO Recordset for data manipulation
QryDef - Query definition objects
basRelink - ODBC connection management module
Mod Export Excel - Excel export utilities
Mod Send Outlook Message - Email automation

Documentation Index

Module Documentation

Each module has comprehensive documentation including forms, VBA modules, queries, tables, and context files:

Module	Tables	Business Domain	Documentation
Purple	152	Entrepreneur Selection	Lead management, EA assessments, Purple Panel selection
Garnet	106	Programme Delivery	Principal projects, allocations, billing, contracts
Ruby	112	Human Resources	Recruitment, employee management, training, disciplinary
Emerald	117	Sales & CRM	Proposals, sales briefs, client management
Vanadium	53	Learning & Guiding	Session management, attendance, guide scheduling
Amber	44	Financial Tracking	Submissions, pre-ignition financials, bookkeeping
Topaz	46	Operations	Delivery locations, user permissions
Gia	36	Company Management	Business area tracking, status management
Gateway	55	Integration Hub	Cross-module data aggregation
Purple Weave	35	Action Planning	Priority actions, follow-up management
Audit	23	Compliance	Financial audit, allocation tracking

Previously Generated Documentation

Document	Description
Architecture	System architecture, components, and design patterns
Data Model	Complete database schema and entity relationships
VBA Modules	VBA code documentation and function reference
Garnet Module	Allocation Management System details

Key Business Entities

Core Entities (Shared Across Modules)

Entity	Primary Module	Description
`Entrepreneurs`	Purple	Individual entrepreneur records (141 fields)
`Entrepreneur Company`	Purple/Garnet	Company entities linked to entrepreneurs
`Principal Projects`	Garnet	Sponsorship/funding programmes
`Principal Project Pillars`	Garnet	Programme pillars within projects
`Delivery Locations`	All	Geographic service delivery points
`DatabaseUsers`	All	System authentication and permissions
`Products`	Purple/Garnet	Programme products (D, E, M variants)

Entity Lifecycle

Lead → Candidate → Entrepreneur → Company → Programme → Graduation
  ↓        ↓           ↓           ↓          ↓            ↓
Purple  Purple     Purple      Garnet     Garnet       Garnet
(Selection Pipeline)  ←——————→  (Programme Delivery)

Source Documentation Location

All pre-extracted MS Access documentation is located in:

bmad_context/
├── purple/                     # Core selection module
│   ├── tables/                 # 152 table schemas
│   ├── queries/                # SQL query definitions
│   ├── forms/                  # Form structures + VBA
│   ├── reports/                # Report definitions
│   ├── modules/                # VBA code modules
│   ├── dependencies.md         # Module dependencies
│   └── bmad/
│       ├── architect_context.md  # Complete data model
│       ├── po_context.md         # Business logic overview
│       └── dev_context.md        # Developer documentation
├── garnet/                     # Programme delivery
├── ruby/                       # HR & Recruitment
├── emerald/                    # Sales & CRM
├── vanadium/                   # Learning & Guiding
├── amber/                      # Financial submissions
├── topaz/                      # Operations
├── gia/                        # Company management
├── gateway/                    # Integration hub
├── purple_weave/               # Action planning
└── audit/                      # Compliance

Quick Reference

Accessing Module Context

Each module contains three levels of context documentation:

Architect Context (bmad/architect_context.md) - Complete technical data model with all tables, fields, primary keys, and relationships
Product Owner Context (bmad/po_context.md) - Business-focused overview with form descriptions, input fields, and available actions
Developer Context (bmad/dev_context.md) - VBA implementation details, procedures, and code warnings (GoTo statements, SendKeys usage, high branching complexity)

For data model questions → Use architect_context.md
For business process questions → Use po_context.md
For code implementation questions → Use dev_context.md
For cross-module dependencies → Use dependencies.md

Module Business Domains

Purple - Selection Pipeline

Lead capture and qualification
Entrepreneurial Assessment (EA) tracking
Purple Panel evaluation
Pipeline progression management
Candidate recommendation workflow

Garnet - Programme Delivery

Principal project management
Company allocation and billing
Monthly billing processing
Certificate and contract generation
Lump sum allocation management

Ruby - Human Resources

Job application processing
Employee onboarding
Training module tracking
Disciplinary process management
Performance review workflows

Emerald - Sales & CRM

Sales brief creation
Proposal management
Client tier classification
Contract negotiation tracking
Principal contact management

Vanadium - Learning & Guiding

Guiding session scheduling
Learning session management
Attendance tracking
Session hour calculations

Amber - Financial Tracking

Financial submission processing
Pre-ignition financials
Bookkeeper assignment
Principal spend tracking

Topaz - Operations

Delivery location management
User permission configuration
Module access control

Gateway - Integration

Cross-module data views
Company status aggregation
Unified reporting data

Gia - Company Management

Business area classification
Company status workflows

Purple Weave - Action Planning

Priority action tracking
Follow-up management

Audit - Compliance

Allocation auditing
Financial compliance tracking

Scan Metadata

Attribute	Value
Scan Date	2025-11-30
Scan Level	Deep
Scan Mode	Full Rescan
Source Folder	`bmad_context/`
Total Files	3,562
Modules	11

Generated by BMAD Document Project Workflow v1.2.0