vanadium - Technical Architecture
Data Model
Tables (53)
dbo_Guide Management
Primary Key: Guide
Fields: - Guide Management ID: Long - Session Type: Text - Session Name: Text - Number: Long - Hours: Currency - Sort Order: Long
dbo_Guiding Sessions
Primary Key: Guiding
Fields: - Guiding Session ID: Long - Session Type: Text - Session Name: Text - Number: Long - Hours: Currency - Sort Order: Long
dbo_Learning Sessions
Primary Key: Learning
Fields: - Learning Session ID: Long - Session Type: Text - Session Name: Text - Number: Long - Hours: Currency - Sort Order: Long
dbo_Lookups
Primary Key: Id
Fields: - Id: Long (PK) - ShortNme: Text - Nme: Text - Descr: Text - Grp: Long - Active: Integer - Def: Integer - Sorting: Long - ValLnk1: Long - ValLnk2: Long - ValLnk3: Long - ValLnk4: Long - ValLnk5: Long - ValLnk6: Long - ValLnk7: Long - ValLnk8: Long - ValLnk9: Long - ValDte1: DateTime - ValDte2: DateTime - ValDte3: DateTime - ValBln1: Integer - ValBln2: Integer - ValBln3: Integer - ValBln4: Integer - ValBln5: Integer - ValCurr1: Currency - ValCurr2: Currency - ValCurr3: Currency - ValTxt1: Text - ValTxt2: Text - ValTxt3: Text - ValTxt4: Text - ValTxt5: Text - ValTxt6: Text - ValTxt7: Text - ValTxt8: Text - ValTxt9: Text - ValMem1: Memo - Blob: OLE - ValBln6: Integer - ValBln7: Integer - ValBln8: Integer - ValBln9: Integer - ValBln10: Integer - ValCurr4: Currency - ValCurr5: Currency - ValCurr6: Currency - ValCurr7: Currency - ValCurr8: Currency - ValCurr9: Currency
dbo_Notification Emails
Primary Key: ID
Fields: - ID: Long (PK) - Channel Partner Notification Email: Long - Channel Partner Email Subject: Long - Channel Partner Email Body: Text - Price List Notification Email: Text - Price List Email Subject: Text - Price List Email Body: Text - Solutions Architect Notification Email: Text - Solutions Architect Email Subject: Text - Solutions Architect Email Body: Text - Proposal Writer Notification Email: Text - Proposal Writer Email Subject: Text - Proposal Writer Email Body: Text
dbo_Product Assignment Management
Primary Key: Product
Fields: - Product Assignment Management ID: Long - Product ID: Long - Course: Text - Assignment Assessment: Long - Assignment Moderation: Currency
dbo_Product Baseline Audits
Primary Key: Product
Fields: - Product Baseline Audit ID: Long - Product ID: Long - Phase Number: Long - Baseline Audit: Text
dbo_Product BBBEE Pillars
Primary Key: Product
Fields: - Product BBBEE Pillar ID: Long - Product ID: Long - BBBEE Pillar: Text - Target NPAT %: Currency
dbo_Product Business Growth Criteria
Primary Key: Product
Fields: - Product Business Growth Criteria ID: Long - Product ID: Long - Business Growth Criteria ID: Long - Business Growth Phase 1: Integer - Business Growth Phase 2: Integer - Business Growth Phase 3: Integer - nBusiness Growth Criteria ID: Long
dbo_Product Catering Options
Primary Key: Product
Fields: - Product Catering Options ID: Long - Product ID: Long - Catering Options: Text
dbo_Product Development Continuums
Primary Key: Product
Fields: - Product Development Continuum ID: Long - Product ID: Long - Development Continuum: Text
dbo_Product Distribution Models
Primary Key: Product
Fields: - Product Distributions ID: Long - Product ID: Long - Distribution Model ID: Long - nDistribution Model ID: Long
dbo_Product Divisions
Primary Key: Product
Fields: - Product Division ID: Long - Product ID: Long - Division ID: Long - nDivision ID: Long
dbo_Product Entrepreneur Access
Primary Key: Product
Fields: - Product Entrepreneur Access ID: Long - Product ID: Long - Entrepreneur Access: Text
dbo_Product Entrepreneur Committment Fees
Primary Key: Product
Fields: - Product Programme Fee ID: Long - Product ID: Long - Payment Term: Text - EP Committment Fee Phase 1: Long - EP Committment Fee Phase 2: Long - EP Committment Fee Phase 3: Long
dbo_Product Entrepreneurial Development Continuum
Primary Key: Entrepreneurial
Fields: - Entrepreneurial Development Continuum ID: Long - Product ID: Long - EP Development ID: Long - EP Development SubID: Long - nEP Development ID: Long
dbo_Product Entrepreneurial Growth Criteria
Primary Key: Product
Fields: - Product Entrepreneurial Growth Criteria ID: Long - Product ID: Long - Entrepreneurial Growth Criteria ID: Long - EP Growth Phase 1: Currency - EP Growth Phase 2: Currency - EP Growth Phase 3: Currency - nEntrepreneurial Growth Criteria ID: Long
dbo_Product Financial Growth Criteria
Primary Key: Product
Fields: - Product Financial Growth Criteria ID: Long - Product ID: Long - Financial Growth Criteria ID: Long - Financial Growth Phase 1: Text - Financial Growth Phase 2: Text - Financial Growth Phase 3: Text - nFinancial Growth Criteria ID: Long
dbo_Product Graduation Ceremony Locations
Primary Key: Product
Fields: - Product Graduation Ceremony Location ID: Long - Product Graduation Ceremony ID: Long - Where Ceremony Held: Text - nProduct Graduation Ceremony ID: Long
dbo_Product Graduation Ceremony
Primary Key: Product
Fields: - Product Graduation Ceremony ID: Long - Product ID: Long - Phase Number: Long - Graduation Occurs: Text - Gowns Required: Long - Certificates to be Issued: Long - Awards Required: Long - Types of Awards: Text - Specify Custom Awards: Text - Graduation Duration: Long - Where Ceremony Held: Text - Where Ceremony Held Other: Text
dbo_Product Guide Management
Primary Key: Product
Fields: - Product Guide Management ID: Long - Product ID: Long - Phase Number: Long - Guide Management ID: Long - Guide Other Specify: Text - Number of Sessions: Text - Hours per Session: Currency - Month 1: Integer - Month 2: Integer - Month 3: Integer - Month 4: Integer - Month 5: Integer - Month 6: Integer - Month 7: Integer - Month 8: Integer - Month 9: Integer - Month 10: Integer - Month 11: Integer - Month 12: Integer - nGuide Management ID: Long
dbo_Product Guiding Sessions
Primary Key: Product
Fields: - Product Guiding Session ID: Long - Product ID: Long - Phase Number: Long - Guiding Session ID: Long - Number of Sessions: Long - Hours per Session: Currency - Month 1: Integer - Month 2: Integer - Month 3: Integer - Month 4: Integer - Month 5: Integer - Month 6: Integer - Month 7: Integer - Month 8: Integer - Month 9: Integer - Month 10: Integer - Month 11: Integer - Month 12: Integer - nGuiding Session ID: Long
dbo_Product Ignition Activities
Primary Key: Product
Fields: - Product Ignition Activity ID: Long - Product ID: Long - Ignition Activity ID: Long - Ignition Activity Type Phase 1: Text - Ignition Activity Type Phase 2: Text - Ignition Activity Type Phase 3: Text - nIgnition Activity ID: Long
dbo_Product Industrys
Primary Key: Product
Fields: - Product Industry ID: Long - Product ID: Long - Industry ID: Long - nIndustry ID: Long
dbo_Product Jade Custom Ignition Box
Primary Key: Product
Fields: - Product Ignition Custom Item ID: Long - Product ID: Long - Ignition Custom Item: Text - Ignition Custom Item Other: Text - Phase Number: Long
dbo_Product Jade Process
Primary Key: Product
Fields: - Product Jade Process ID: Long - Product ID: Long - Jade Process Step ID: Long - Step Number: Long - Jade Process Step Details: Memo - nJade Process Step ID: Long
dbo_Product Learning Sessions
Primary Key: Product
Fields: - Product Learning Session ID: Long - Product ID: Long - Phase Number: Long - Learning Session ID: Long - Number of Sessions: Long - Hours per Session: Currency - Month 1: Integer - Month 2: Integer - Month 3: Integer - Month 4: Integer - Month 5: Integer - Month 6: Integer - Month 7: Integer - Month 8: Integer - Month 9: Integer - Month 10: Integer - Month 11: Integer - Month 12: Integer - Catering: Integer - nLearning Session ID: Long
dbo_Product Managed By
Primary Key: Product
Fields: - Product Managed By ID: Long - Product ID: Long - Managed By: Text
dbo_Product Marketing Blue Ocean
Primary Key: Product
Fields: - Product Marketing Blue Ocean ID: Long - Product ID: Long - Product Offering Blue Ocean: Text - Elaborate Blue Ocean: Text
dbo_Product Marketing Elements
Primary Key: Product
Fields: - Product Marketing Element ID: Long - Product ID: Long - Marketing Element: Text
dbo_Product Marketing Media Types Customer
Primary Key: Product
Fields: - Product Marketing Media Types ID: Long - Product ID: Long - Media Customer Consume: Text - Media Customer Consume Notes: Text
dbo_Product Marketing Media Types Entrepreneur
Primary Key: Product
Fields: - Product Marketing Media Types ID: Long - Product ID: Long - Media Entrepeneur Consume: Text - Media Entrepeneur Consume Notes: Text
dbo_Product Marketing Media Types Principal
Primary Key: Product
Fields: - Product Marketing Media Types ID: Long - Product ID: Long - Media Principal Consume: Text - Media Principal Consume Notes: Text
dbo_Product Principal Acquisition Process
Primary Key: Product
Fields: - Product Principal Acquisition Process ID: Long - Product ID: Long - Principal Acquisition Process Step ID: Long - Step Number: Long - nPrincipal Acquisition Process Step ID: Long
dbo_Product Principal Journey
Primary Key: Product
Fields: - Product Principal Journey ID: Long - Product ID: Long - Principal Journey Step ID: Long - Month Number: Long - Step Number: Long - nPrincipal Journey Step ID: Long
dbo_Product Principal Reports Sent
Primary Key: Product
Fields: - Product Principal Reports Sent ID: Long - Product ID: Long - Principal Reports Sent ID: Long - nPrincipal Reports Sent ID: Long
dbo_Product Principal Reports Structure
Primary Key: Product
Fields: - Product Principal Reports Structure ID: Long - Product ID: Long - Principal Reports Structure ID: Long - nPrincipal Reports Structure ID: Long
dbo_Product Principal Retention Process
Primary Key: Product
Fields: - Product Principal Retention Process ID: Long - Product ID: Long - Principal Retention Process Step ID: Long - Month Number: Long - Step Number: Long - nPrincipal Retention Process Step ID: Long
dbo_Product Purple Process
Primary Key: Product
Fields: - Product Purple Process ID: Long - Product ID: Long - Purple Process Step ID: Long - Step Number: Long - Conditional on Step: Text - Purple Process Step Details: Memo - nPurple Process Step ID: Long
dbo_Product Selection Criteria and Assessment
Primary Key: Product
Fields: - Product Selection Criteria ID: Long - Product ID: Long - Phase Number: Long - Learning Session ID: Long - Minimum Age: Text - Minimum Age Other: Text - Minimum BBBEE: Text - Location Requirement: Text - Level of Participation: Text - Credit Check Permission Required: Long - Criminal Check Permission Required: Long - Gender Specific: Long - Cell Phone Required: Long - Computer Resource: Text - Transport Resource: Text - Minimum Time in Business: Long - Financial Records Months: Long - Financial Records Audited: Long - Minimum Average Turnover per Month: Long - Other Business Criteria NA: Integer - Other Business Criteria: Text - Current Industry Operating NA: Integer - Current Industry Operating: Text - Experience in Industry NA: Integer - Experience in Industry: Text - Interest in Industry NA: Integer - Interest in Industry: Text - Maths NQF Level NA: Integer - Maths NQF Level: Text - English NQF Level NA: Integer - English NQF Level: Text - Other NQF Level NA: Integer - Other NQF Level: Text - Other Qualification NA: Integer - Other Qualification: Text - Jocky-Horse Scale ID: Long - Baseline Audit Principal Requirements: Text - nJocky-Horse Scale ID: Long - nPhase Number: Long
dbo_Product Selection Tests
Primary Key: Product
Fields: - Product Selection Test ID: Long - Product ID: Long - Phase Number: Long - Selection Test: Text - Gate: Long - Percentage to Pass: Text - Average: Integer
dbo_Product Sold Bys
Primary Key: Product
Fields: - Product Sold By ID: Long - Product ID: Long - Sold By: Text
dbo_Product Specific Efficacy Data
Primary Key: Product
Fields: - Product Specific Efficacy Data ID: Long - Product ID: Long - Product Specific Efficacy Data: Text
dbo_Product Status History
Primary Key: Product
Fields: - Product Status History ID: Long - Product ID: Long - Product Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text
dbo_Product Sub-Divisions
Primary Key: Product
Fields: - Product Sub-Divisions ID: Long - Product ID: Long - Sub-Division: Text
dbo_Product Supplier Development
Primary Key: Product
Fields: - Product Supplier Development ID: Long - Product ID: Long - Phase Number: Long - Supplier Development ID: Long - Supplier Development Hours: Long - Month 1: Integer - Month 2: Integer - Month 3: Integer - Month 4: Integer - Month 5: Integer - Month 6: Integer - Month 7: Integer - Month 8: Integer - Month 9: Integer - Month 10: Integer - Month 11: Integer - Month 12: Integer
dbo_Product Who Must Be Trained
Primary Key: Product
Fields: - Product Who Must Be Trained ID: Long - Product ID: Long - Who Must Be Trained: Text
dbo_Product Who Will Provide Traning
Primary Key: Product
Fields: - Product Who Will Provide Training ID: Long - Product ID: Long - Who Will Provide Training: Text
dbo_Products
Primary Key: Product
Fields: - Product ID: Long - Reference Number: Text - Product State: Text - Version Number: Currency - Been Through Gateway: Integer - Been Revised: Integer - Date Created: DateTime - Product Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text - Product: Text (PK) - Product Description: Memo - Purpose: Memo - Client Pain: Memo - User Pain: Memo - Phase 1 Duration Weeks: Long - Phase 1 Duration Months: Long - Phase 1 Duration Years: Long - Phase 2 Duration Weeks: Long - Phase 2 Duration Months: Long - Phase 2 Duration Years: Long - Phase 3 Duration Weeks: Long - Phase 3 Duration Months: Long - Phase 3 Duration Years: Long - EP Delivery Phase 1 Hours: Currency - EP Delivery Phase 2 Hours: Currency - EP Delivery Phase 3 Hours: Currency - EP Learning Phase 1 Hours: Currency - EP Learning Phase 2 Hours: Currency - EP Learning Phase 3 Hours: Currency - EP Group Guiding Phase 1 Hours: Currency - EP Group Guiding Phase 2 Hours: Currency - EP Group Guiding Phase 3 Hours: Currency - EP Individual Guiding Phase 1 Hours: Currency - EP Individual Guiding Phase 2 Hours: Currency - EP Individual Guiding Phase 3 Hours: Currency - EP Delivery Phase 1 Notional Hours: Currency - EP Delivery Phase 2 Notional Hours: Currency - EP Delivery Phase 3 Notional Hours: Currency - EP Learning Phase 1 Notional Hours: Currency - EP Learning Phase 2 Notional Hours: Currency - EP Learning Phase 3 Notional Hours: Currency - EP Group Guiding Phase 1 Notional Hours: Currency - EP Group Guiding Phase 2 Notional Hours: Currency - EP Group Guiding Phase 3 Notional Hours: Currency - EP Individual Guiding Phase 1 Notional Hours: Currency - EP Individual Guiding Phase 2 Notional Hours: Currency - EP Individual Guiding Phase 3 Notional Hours: Currency - RC Delivery Phase 1 Hours: Currency - RC Delivery Phase 2 Hours: Currency - RC Delivery Phase 3 Hours: Currency - RC Learning Phase 1 Hours: Currency - RC Learning Phase 2 Hours: Currency - RC Learning Phase 3 Hours: Currency - RC Group Guiding Phase 1 Hours: Currency - RC Group Guiding Phase 2 Hours: Currency - RC Group Guiding Phase 3 Hours: Currency - RC Individual Guiding Phase 1 Hours: Currency - RC Individual Guiding Phase 2 Hours: Currency - RC Individual Guiding Phase 3 Hours: Currency - Delivery Susceptibility NA: Integer - Delivery Susceptibility: Text - Is There a Principal Guarantee: Long - Principal Guarantee: Long - Principal Guarantee Profit Increase: Currency - Is There a Selection Guarantee: Long - Selection Guarantee: Long - Programme Timing: Text - Scalability of Programme: Text - Number of Months From Start Date: Long - Indefinite Months From Start Date: Integer - Programme Type: Text - Part Sponsorship Percentage: Currency - Minimum Cohort Size NA: Integer - Minimum Cohort Size: Long - Maximum Cohort Size NA: Integer - Maximum Cohort Size: Long - Sales Process: Text - New Sales Process: Text - Channel Partners Need Notified: Long - Solutions Architects Need Notified: Long - Price List Need Updated: Long - Create Product Summary: Long - Programme Notes NA: Integer - Programme Notes: Memo - Assessment Fee NA: Integer - Assessment Fee Phase 1: Long - Assessment Fee Phase 2: Long - Assessment Fee Phase 3: Long - Find and Filter Fee NA: Integer - Find and Filter Fee Phase 1: Currency - Find and Filter Fee Phase 2: Currency - Find and Filter Fee Phase 3: Currency - Filter Only Fee NA: Integer - Filter Only Fee Phase 1: Currency - Filter Only Fee Phase 2: Currency - Filter Only Fee Phase 3: Currency - Monthly Programme Fee NA: Integer - Monthly Programme Fee Zone A Phase 1: Currency - Monthly Programme Fee Zone A Phase 2: Currency - Monthly Programme Fee Zone A Phase 3: Currency - Monthly Programme Fee Zone B Phase 1: Currency - Monthly Programme Fee Zone B Phase 2: Currency - Monthly Programme Fee Zone B Phase 3: Currency - Monthly Programme Fee Zone C Phase 1: Currency - Monthly Programme Fee Zone C Phase 2: Currency - Monthly Programme Fee Zone C Phase 3: Currency - Capital Expenditure NA: Integer - Capital Expenditure Phase 1: Currency - Capital Expenditure Phase 2: Currency - Capital Expenditure Phase 3: Currency - Technical Coordination Fee NA: Integer - Technical Coordination Fee Phase 1: Currency - Technical Coordination Fee Phase 2: Currency - Technical Coordination Fee Phase 3: Currency - Technical Incubation Fee NA: Integer - Technical Incubation Fee Phase 1: Currency - Technical Incubation Fee Phase 2: Currency - Technical Incubation Fee Phase 3: Currency - Other Fee NA: Integer - Other Decription: Text - Other Phase 1: Currency - Other Phase 2: Currency - Other Phase 3: Currency - Stipend Mgmt Fee Percentage: Currency - Stipend Mgmt Fee Other: Text - Commitment Duration Min Max Fixed: Long - Commitment Duration Min: Long - Commitment Duration Max: Long - Commitment Duration Fixed: Long - Stipend NA: Integer - Stipend Phase 1: Currency - Stipend Phase 2: Currency - Stipend Phase 3: Currency - Stipend Based on EP Compliance: Long - Stipend Remains Constant: Long - Stipend Payable Amounts: Text - Why Name Choosen: Memo - Target Market: Memo - Who Will Be Using: Memo - Big Promise: Memo - Compelling to Buy: Memo - Ideal Tagline: Memo - Tagline Dovetail: Memo - First Top Competitor: Text - Second Top Competitor: Text - Third Top Competitor: Text - Product USP: Memo - Done the Research: Long - The Research: Text - Market Positioning: Memo - Conduct a Survey Principal: Long - The Principal Survey: Text - Conduct a Survey Entrepreneur: Long - The Entrepreneur Survey: Text - Conduct a Survey Customer: Long - The Customer Survey: Text - Specialised Graphics Notes: Text - Specialised Application Form Notes: Text - Other Corporate Sponsor Benefits: Text - Phased Selection: Long - Selection Phase 1: Integer - Selection Phase 2: Integer - Selection Phase 3: Integer - Must Overall Percentage: Long - Overall Percentage: Currency - Average Gate: Currency - Purple Panel Rubric: Text - Base Rubric NA: Integer - Base Rubric: Text - Other Metrics NA: Integer - Other Metrics: Text - Additional Notes NA: Integer - Additional Notes: Text - Case Study: Text - Ignition Session Month Phase 1: Long - Ignition Session Duration Phase 1: Long - Ignition Session Month Phase 2: Long - Ignition Session Duration Phase 2: Long - Ignition Session Month Phase 3: Long - Ignition Session Duration Phase 3: Long - Ignition Box Standard Items Phase 1: Text - Ignition Box Other Item Phase 1: Text - Ignition Box Standard Items Phase 2: Text - Ignition Box Other Item Phase 2: Text - Ignition Box Standard Items Phase 3: Text - Ignition Box Other Item Phase 3: Text - Principal Attend Ignition: Long - Who Must Attend: Text - Ignition Date Communicate: Text - Ignition Date Communicate Other: Text - Learning Considerations: Text - Catering Options Other: Text - Guiding Considerations: Text - Standard GPS Template Phase 1: Long - Standard GPS Template Specify Phase 1: Text - Standard GPS Template Phase 2: Long - Standard GPS Template Specify Phase 2: Text - Standard GPS Template Phase 3: Long - Standard GPS Template Specify Phase 3: Text - Additions to Include: Text - Are Group Indigos Permitted: Long - Product Considerations: Text - Are SD Interventions Required: Long - Funding Available: Long - Funding Session: Text - Funding Session Other: Text - Bookkeeping Available: Long - Bookkeeping Services: Text - Bookkeeping Transactions: Text - Other Bookkeeping Transactions: Text - Bookkeeping Service Provider: Text - Bookkeeping Service Provider Two: Text - Who Is Principal: Text - Frequency of Reporting: Text - Principal Specified Reports: Text - Additional Terms: Text - Additional Format Detail: Text - Product Specific Efficacy Data Other: Text - Managed By Other: Text - Saphire Week 1: Currency - Saphire Week 2: Currency - Saphire Week 3: Currency - Saphire Week 4: Currency - Amber Week 1: Currency - Amber Week 2: Currency - Amber Week 3: Currency - Amber Week 4: Currency - Training Process: Text - New Training Process: Text - Specialised Documents: Memo - Legal Requirements: Memo
dbo_Programme Hour Multipliers
Primary Key: Programme
Fields: - Programme ID: Long - Programme Name: Text - EP Notional Multiplier: Currency - RC Multiplier: Currency
dbo_Purple Process Steps
Primary Key: Purple
Fields: - Purple Process Step ID: Long - Purple Process Step: Text - Purple Process Step Details: Memo - Conditional on Step: Text - Default Step: Integer - Sort Order: Long
dbo_Supplier Development
Primary Key: Supplier
Fields: - Supplier Development ID: Long - Session Type: Text - Session Name: Text - Number: Long - Hours: Currency - Sort Order: Long
USysRibbons
Primary Key: ID
Fields: - ID: Long (PK) - RibbonName: Text - RibbonXml: Memo
Code Components
Modules (150)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Add and Edit Baseline Audit | Form | 53 | 3 |
| Form_Add and Edit BBBEE Pillar | Form | 56 | 3 |
| Form_Add and Edit Blue Ocean | Form | 56 | 3 |
| Form_Add and Edit Bookkeeping Services | Form | 56 | 3 |
| Form_Add and Edit Bookkeeping Transactions | Form | 56 | 3 |
| Form_Add and Edit Business Growth Criteria | Form | 70 | 3 |
| Form_Add and Edit Catering Options | Form | 56 | 3 |
| Form_Add and Edit Computer Resources | Form | 56 | 3 |
| Form_Add and Edit Development Continuum | Form | 56 | 3 |
| Form_Add and Edit Distribution | Form | 56 | 3 |
| Form_Add and Edit Division | Form | 70 | 3 |
| Form_Add and Edit Entrepreneur Access | Form | 56 | 3 |
| Form_Add and Edit Entrepreneur Growth Criteria | Form | 70 | 3 |
| Form_Add and Edit Entrepreneurial Development Continuum | Form | 56 | 3 |
| Form_Add and Edit Financial Growth Criteria | Form | 70 | 3 |
| Form_Add and Edit Funding Sessions | Form | 56 | 3 |
| Form_Add and Edit Guide Management Sessions | Form | 70 | 3 |
| Form_Add and Edit Guiding Sessions | Form | 70 | 3 |
| Form_Add and Edit Ignition Activity Type | Form | 56 | 3 |
| Form_Add and Edit Ignition Activity | Form | 70 | 3 |
| Form_Add and Edit Ignition Box Item | Form | 56 | 3 |
| Form_Add and Edit Ignition Custom Item | Form | 56 | 3 |
| Form_Add and Edit Ignition Date Communicate | Form | 56 | 3 |
| Form_Add and Edit Jade Process Steps | Form | 70 | 3 |
| Form_Add and Edit Jocky-Horse Scale | Form | 70 | 3 |
| Form_Add and Edit Learning Sessions | Form | 70 | 3 |
| Form_Add and Edit Level of Participation | Form | 56 | 3 |
| Form_Add and Edit Location Requirement | Form | 56 | 3 |
| Form_Add and Edit Managed By | Form | 56 | 3 |
| Form_Add and Edit Marketing Element | Form | 56 | 3 |
| Form_Add and Edit Media Channel | Form | 56 | 3 |
| Form_Add and Edit Minimum Age | Form | 56 | 3 |
| Form_Add and Edit Minimum BBBEE | Form | 56 | 3 |
| Form_Add and Edit Principal Acquisition Process Steps | Form | 75 | 4 |
| Form_Add and Edit Principal Journey Steps | Form | 74 | 4 |
| Form_Add and Edit Principal Reports Sent | Form | 70 | 3 |
| Form_Add and Edit Principal Reports Structure | Form | 70 | 3 |
| Form_Add and Edit Principal Retention Process Steps | Form | 74 | 4 |
| Form_Add and Edit Product - Detail Part 1 | Form | 35 | 4 |
| Form_Add and Edit Product - Detail Part 2 | Form | 134 | 15 |
| Form_Add and Edit Product - Distribution Agent Compliance | Form | 35 | 4 |
| Form_Add and Edit Product - Exposure | Form | 47 | 5 |
| Form_Add and Edit Product - Funding and Bookkeeping | Form | 82 | 8 |
| Form_Add and Edit Product - Guiding | Form | 77 | 7 |
| Form_Add and Edit Product - Infrastructure | Form | 35 | 4 |
| Form_Add and Edit Product - Jade | Form | 121 | 10 |
| Form_Add and Edit Product - Learning | Form | 37 | 4 |
| Form_Add and Edit Product - Legal | Form | 35 | 4 |
| Form_Add and Edit Product - Marketing Part 1 | Form | 63 | 11 |
| Form_Add and Edit Product - Marketing Part 2 | Form | 52 | 7 |
| Form_Add and Edit Product - Overview | Form | 57 | 10 |
| Form_Add and Edit Product - Product Fees | Form | 114 | 16 |
| Form_Add and Edit Product - Product Training | Form | 44 | 5 |
| Form_Add and Edit Product - Sales | Form | 57 | 8 |
| Form_Add and Edit Product - Selection | Form | 191 | 12 |
| Form_Add and Edit Product - Yellow | Form | 46 | 5 |
| Form_Add and Edit Product Jade Process | Form | 52 | 4 |
| Form_Add and Edit Product Principal Acquisition Process | Form | 50 | 3 |
| Form_Add and Edit Product Principal Journey | Form | 48 | 3 |
| Form_Add and Edit Product Principal Reports Structure | Form | 53 | 3 |
| Form_Add and Edit Product Principal Retention Process | Form | 48 | 3 |
| Form_Add and Edit Product Purple Process | Form | 49 | 3 |
| Form_Add and Edit Purple Panel Rubric | Form | 56 | 3 |
| Form_Add and Edit Purple Process Steps | Form | 70 | 3 |
| Form_Add and Edit Selection Test | Form | 56 | 3 |
| Form_Add and Edit Sold By | Form | 56 | 3 |
| Form_Add and Edit Specific Efficacy Data | Form | 56 | 3 |
| Form_Add and Edit Sub-Division | Form | 70 | 3 |
| Form_Add and Edit Supplier Development | Form | 70 | 3 |
| Form_Add and Edit Transport Resource | Form | 56 | 3 |
| Form_Add and Edit Types of Awards | Form | 56 | 3 |
| Form_Add and Edit Where Ceremony Held | Form | 56 | 3 |
| Form_Add and Edit Who Must Be Trained | Form | 56 | 3 |
| Form_Add and Edit Who Will Provide Training | Form | 55 | 3 |
| Form_Begin New Product | Form | 186 | 3 |
| Form_Change Password | Form | 138 | 5 |
| Form_Edit Notification Emails | Form | 20 | 1 |
| Form_Edit Product Status | Form | 307 | 4 |
| Form_Maintenance Menu | Form | 220 | 51 |
| Form_Opening Dialog | Form | 74 | 3 |
| Form_Product List | Form | 3754 | 20 |
| Form_mnt Mainform | Form | 156 | 7 |
| Form_mntDefault_subf | Form | 11 | 1 |
| Form_mntEPDev Categories | Form | 11 | 1 |
| Form_mntGeneral_subf | Form | 11 | 1 |
| Form_mntRoot_subf | Form | 14 | 2 |
| Form_mntUsers_subf | Form | 14 | 2 |
| Form_SubFrm Product Assignment Management | Form | 18 | 1 |
| Form_SubFrm Product Baseline Audits Phase 1 | Form | 18 | 1 |
| Form_SubFrm Product Baseline Audits Phase 2 | Form | 18 | 1 |
| Form_SubFrm Product Baseline Audits Phase 3 | Form | 18 | 1 |
| Form_SubFrm Product BBBEE Pillars | Form | 18 | 1 |
| Form_SubFrm Product Business Growth Criteria | Form | 18 | 1 |
| Form_SubFrm Product Catering Options | Form | 25 | 2 |
| Form_SubFrm Product Development Continuums | Form | 18 | 1 |
| Form_SubFrm Product Distribution Models | Form | 18 | 1 |
| Form_SubFrm Product Divisions | Form | 28 | 3 |
| Form_SubFrm Product Entrepreneur Access | Form | 18 | 1 |
| Form_SubFrm Product Entrepreneur Committment Fee | Form | 18 | 1 |
| Form_SubFrm Product Entrepreneurial Development Continuum | Form | 50 | 4 |
| Form_SubFrm Product Entrepreneurial Growth Criteria | Form | 18 | 1 |
| Form_SubFrm Product Financial Growth Criteria | Form | 18 | 1 |
| Form_SubFrm Product Graduation Ceremony Locations | Form | 18 | 1 |
| Form_SubFrm Product Graduation Ceremony Phase 1 | Form | 13 | 1 |
| Form_SubFrm Product Graduation Ceremony Phase 2 | Form | 13 | 1 |
| Form_SubFrm Product Graduation Ceremony Phase 3 | Form | 13 | 1 |
| Form_SubFrm Product Guide Management Phase 1 | Form | 23 | 2 |
| Form_SubFrm Product Guide Management Phase 2 | Form | 23 | 2 |
| Form_SubFrm Product Guide Management Phase 3 | Form | 23 | 2 |
| Form_SubFrm Product Guiding Sessions Phase 1 | Form | 23 | 2 |
| Form_SubFrm Product Guiding Sessions Phase 2 | Form | 23 | 2 |
| Form_SubFrm Product Guiding Sessions Phase 3 | Form | 23 | 2 |
| Form_SubFrm Product Ignition Actvities | Form | 18 | 1 |
| Form_SubFrm Product Industrys | Form | 18 | 1 |
| Form_SubFrm Product Jade Custom Ignition Box Phase 1 | Form | 44 | 4 |
| Form_SubFrm Product Jade Custom Ignition Box Phase 2 | Form | 44 | 4 |
| Form_SubFrm Product Jade Custom Ignition Box Phase 3 | Form | 44 | 4 |
| Form_SubFrm Product Jade Process | Form | 19 | 1 |
| Form_SubFrm Product Learning Sessions Phase 1 | Form | 29 | 3 |
| Form_SubFrm Product Learning Sessions Phase 2 | Form | 28 | 3 |
| Form_SubFrm Product Learning Sessions Phase 3 | Form | 28 | 3 |
| Form_SubFrm Product Managed By | Form | 18 | 1 |
| Form_SubFrm Product Marketing Blue Ocean | Form | 18 | 1 |
| Form_SubFrm Product Marketing Elements | Form | 18 | 1 |
| Form_SubFrm Product Marketing Media Types Customer | Form | 18 | 1 |
| Form_SubFrm Product Marketing Media Types Entrepreneur | Form | 18 | 1 |
| Form_SubFrm Product Marketing Media Types Principal | Form | 18 | 1 |
| Form_SubFrm Product Principal Acquisition Process | Form | 19 | 1 |
| Form_SubFrm Product Principal Journey | Form | 19 | 1 |
| Form_SubFrm Product Principal Reports Sent | Form | 18 | 1 |
| Form_SubFrm Product Principal Reports Structure | Form | 18 | 1 |
| Form_SubFrm Product Principal Retention Process | Form | 19 | 1 |
| Form_SubFrm Product Purple Process | Form | 19 | 1 |
| Form_SubFrm Product Selection Criteria Business Exp Phase 1 | Form | 69 | 8 |
| Form_SubFrm Product Selection Criteria Business Exp Phase 2 | Form | 69 | 8 |
| Form_SubFrm Product Selection Criteria Business Exp Phase 3 | Form | 69 | 8 |
| Form_SubFrm Product Selection Tests Phase 1 | Form | 18 | 1 |
| Form_SubFrm Product Selection Tests Phase 2 | Form | 18 | 1 |
| Form_SubFrm Product Selection Tests Phase 3 | Form | 18 | 1 |
| Form_SubFrm Product Sold Bys | Form | 18 | 1 |
| Form_SubFrm Product Specific Efficacy Data | Form | 18 | 1 |
| Form_SubFrm Product Sub-Divisions | Form | 18 | 1 |
| Form_SubFrm Product Supplier Development Phase 1 | Form | 22 | 2 |
| Form_SubFrm Product Supplier Development Phase 2 | Form | 22 | 2 |
| Form_SubFrm Product Supplier Development Phase 3 | Form | 22 | 2 |
| Form_SubFrm Product Who Must Be Trained | Form | 18 | 1 |
| basDAOTools | Standard | 2261 | 58 |
| Global | Standard | 63 | 1 |
| Mod Send Outlook Message | Standard | 53 | 1 |
| Mod Utilities | Standard | 2048 | 22 |
Forms (162)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Add and Edit Baseline Audit | Baseline Audit LookUp | 12 | Yes |
| Add and Edit BBBEE Pillar | BBBEE Pillar Lookup | 12 | Yes |
| Add and Edit Blue Ocean | Blue Ocean LookUp | 12 | Yes |
| Add and Edit Bookkeeping Services | Bookkeeping Services LookUp | 12 | Yes |
| Add and Edit Bookkeeping Transactions | Bookkeeping Transactions LookUp | 12 | Yes |
| Add and Edit Business Growth Criteria | Business Growth Criteria LookUp | 14 | Yes |
| Add and Edit Catering Options | Catering Options LookUp | 12 | Yes |
| Add and Edit Computer Resources | Computer Resource LookUp | 12 | Yes |
| Add and Edit Development Continuum | Development Continuum LookUp | 12 | Yes |
| Add and Edit Distribution | Distribution Models | 12 | Yes |
| Add and Edit Division | Divisions | 12 | Yes |
| Add and Edit Entrepreneur Access | Entrepreneur Access LookUp | 12 | Yes |
| Add and Edit Entrepreneur Growth Criteria | Entrepreneurial Growth Criteria LookUp | 16 | Yes |
| Add and Edit Entrepreneurial Development Continuum | Entrepreneur Development Continuum LookUp | 14 | Yes |
| Add and Edit Financial Growth Criteria | Financial Growth Criteria LookUp | 14 | Yes |
| Add and Edit Funding Sessions | Funding Session Lookup | 12 | Yes |
| Add and Edit Guide Management Sessions | Guide Management | 20 | Yes |
| Add and Edit Guiding Sessions | Guiding Sessions | 19 | Yes |
| Add and Edit Ignition Activity Type | Ignition Activity Type LookUp | 12 | Yes |
| Add and Edit Ignition Activity | Ignition Activity LookUp | 12 | Yes |
| Add and Edit Ignition Box Item | Ignition Box Item LookUp | 12 | Yes |
| Add and Edit Ignition Custom Item | Ignition Custom Item LookUp | 12 | Yes |
| Add and Edit Ignition Date Communicate | Ignition Date Communicate LookUp | 12 | Yes |
| Add and Edit Jade Process Steps | Jade Process Steps | 16 | Yes |
| Add and Edit Jocky-Horse Scale | Jocky-Horse Scale Lookup | 14 | Yes |
| Add and Edit Learning Sessions | Learning Sessions | 19 | Yes |
| Add and Edit Level of Participation | Level of Participation LookUp | 12 | Yes |
| Add and Edit Location Requirement | Location Requirement LookUp | 12 | Yes |
| Add and Edit Managed By | Managed By LookUp | 12 | Yes |
| Add and Edit Marketing Element | Marketing Element LookUp | 12 | Yes |
| Add and Edit Media Channel | Media Channel LookUp | 12 | Yes |
| Add and Edit Minimum Age | Minimum Age LookUp | 12 | Yes |
| Add and Edit Minimum BBBEE | Minimum BBBEE LookUp | 12 | Yes |
| Add and Edit Principal Acquisition Process Steps | Principal Acquisition Process Steps | 16 | Yes |
| Add and Edit Principal Journey Steps | Principal Journey Steps | 16 | Yes |
| Add and Edit Principal Reports Sent | Principal Reports Sent Lookup | 16 | Yes |
| Add and Edit Principal Reports Structure | Principal Reports Structure Lookup | 16 | Yes |
| Add and Edit Principal Retention Process Steps | Principal Retention Process Steps | 16 | Yes |
| Add and Edit Product - Detail Part 1 | Products | 20 | Yes |
| Add and Edit Product - Detail Part 2 | Products | 136 | Yes |
| Add and Edit Product - Distribution Agent Compliance | Products | 33 | Yes |
| Add and Edit Product - Exposure | Products | 24 | Yes |
| Add and Edit Product - Funding and Bookkeeping | Products | 36 | Yes |
| Add and Edit Product - Guiding | Products | 56 | Yes |
| Add and Edit Product - Infrastructure | Products | 13 | Yes |
| Add and Edit Product - Jade | Products | 53 | Yes |
| Add and Edit Product - Learning | Products | 23 | Yes |
| Add and Edit Product - Legal | Products | 15 | Yes |
| Add and Edit Product - Marketing Part 1 | Products | 29 | Yes |
| Add and Edit Product - Marketing Part 2 | Products | 37 | Yes |
| Add and Edit Product - Overview | Products | 44 | Yes |
| Add and Edit Product - Product Fees | Products | 96 | Yes |
| Add and Edit Product - Product Training | Products | 16 | Yes |
| Add and Edit Product - Sales | Products | 45 | Yes |
| Add and Edit Product - Selection | Products | 54 | Yes |
| Add and Edit Product - Yellow | Products | 37 | Yes |
| Add and Edit Product Jade Process | Products | 12 | Yes |
| Add and Edit Product Principal Acquisition Process | Products | 12 | Yes |
| Add and Edit Product Principal Journey | Products | 12 | Yes |
| Add and Edit Product Principal Reports Structure | Products | 13 | Yes |
| Add and Edit Product Principal Retention Process | Products | 12 | Yes |
| Add and Edit Product Purple Process | Products | 12 | Yes |
| Add and Edit Purple Panel Rubric | Purple Panel Rubric LookUp | 12 | Yes |
| Add and Edit Purple Process Steps | Purple Process Steps | 17 | Yes |
| Add and Edit Selection Test | Selection Test LookUp | 12 | Yes |
| Add and Edit Sold By | Sold By LookUp | 12 | Yes |
| Add and Edit Specific Efficacy Data | Specific Efficacy Data LookUp | 12 | Yes |
| Add and Edit Sub-Division | Sub-Division LookUp | 12 | Yes |
| Add and Edit Supplier Development | Supplier Development | 19 | Yes |
| Add and Edit Transport Resource | Transport Resource LookUp | 12 | Yes |
| Add and Edit Types of Awards | Types of Awards LookUp | 12 | Yes |
| Add and Edit Where Ceremony Held | Where Ceremony Held LookUp | 12 | Yes |
| Add and Edit Who Must Be Trained | Who Must Be Trained LookUp | 12 | Yes |
| Add and Edit Who Will Provide Training | Who Will Provide Training LookUp | 12 | Yes |
| Begin New Product | Unbound | 10 | Yes |
| Change Password | Unbound | 19 | Yes |
| Custom Ribbon | USysRibbons | 8 | No |
| Edit Notification Emails | Notification Emails | 32 | Yes |
| Edit Product Status | Unbound | 9 | Yes |
| Maintenance Menu | Unbound | 52 | Yes |
| Opening Dialog | Unbound | 10 | Yes |
| Product List | Unbound | 22 | Yes |
| mnt Mainform | RecSrc | 14 | Yes |
| mntDefault_subf | dbo_Lookups | 27 | Yes |
| mntEPDev Categories | dbo_Lookups | 22 | Yes |
| mntGeneral_subf | dbo_Lookups | 17 | Yes |
| mntRoot_subf | SELECT dbo_Lookups.* FROM dbo_Lookups WHERE (((dbo_Lookups.Grp)=0)) ORDER BY dbo | 26 | Yes |
| mntUsers_subf | dbo_Lookups | 42 | Yes |
| SubFrm Display Product Categories | Qry SubFrm Product Categories | 3 | No |
| SubFrm Display Product Distribution Model | Qry SubRpt Product Distribution Models | 3 | No |
| SubFrm Display Product Sub Division | Product Sub-Divisions | 3 | No |
| SubFrm Product Assignment Management | Product Assignment Management | 11 | Yes |
| SubFrm Product Baseline Audits Phase 1 | SELECT [Product Baseline Audits].[Product Baseline Audit ID], [Product Baseline | 8 | Yes |
| SubFrm Product Baseline Audits Phase 2 | SELECT [Product Baseline Audits].[Product Baseline Audit ID], [Product Baseline | 8 | Yes |
| SubFrm Product Baseline Audits Phase 3 | SELECT [Product Baseline Audits].[Product Baseline Audit ID], [Product Baseline | 8 | Yes |
| SubFrm Product BBBEE Pillars | Product BBBEE Pillars | 9 | Yes |
| SubFrm Product Business Growth Criteria | Product Business Growth Criteria | 14 | Yes |
| SubFrm Product Catering Options | Product Catering Options | 7 | Yes |
| SubFrm Product Development Continuums | Product Development Continuums | 7 | Yes |
| SubFrm Product Distribution Models | Product Distribution Models | 7 | Yes |
| SubFrm Product Divisions | Product Divisions | 7 | Yes |
| SubFrm Product Entrepreneur Access | Product Entrepreneur Access | 6 | Yes |
| SubFrm Product Entrepreneur Committment Fee | Product Entrepreneur Committment Fees | 14 | Yes |
| SubFrm Product Entrepreneurial Development Continuum | Product Entrepreneurial Development Continuum | 9 | Yes |
| SubFrm Product Entrepreneurial Growth Criteria | Product Entrepreneurial Growth Criteria | 16 | Yes |
| SubFrm Product Financial Growth Criteria | Product Financial Growth Criteria | 14 | Yes |
| SubFrm Product Graduation Ceremony Locations | Product Graduation Ceremony Locations | 8 | Yes |
| SubFrm Product Graduation Ceremony Phase 1 | SELECT [Product Graduation Ceremony].[Product Graduation Ceremony ID], [Product | 31 | Yes |
| SubFrm Product Graduation Ceremony Phase 2 | SELECT [Product Graduation Ceremony].[Product Graduation Ceremony ID], [Product | 31 | Yes |
| SubFrm Product Graduation Ceremony Phase 3 | SELECT [Product Graduation Ceremony].[Product Graduation Ceremony ID], [Product | 31 | Yes |
| SubFrm Product Graduation Ceremony | Products | 9 | No |
| SubFrm Product Guide Management Phase 1 | SELECT [Product Guide Management].[Product Guide Management ID], [Product Guide | 39 | Yes |
| SubFrm Product Guide Management Phase 2 | SELECT [Product Guide Management].[Product Guide Management ID], [Product Guide | 39 | Yes |
| SubFrm Product Guide Management Phase 3 | SELECT [Product Guide Management].[Product Guide Management ID], [Product Guide | 39 | Yes |
| SubFrm Product Guiding Sessions Phase 1 | SELECT [Product Guiding Sessions].[Product Guiding Session ID], [Product Guiding | 39 | Yes |
| SubFrm Product Guiding Sessions Phase 2 | SELECT [Product Guiding Sessions].[Product Guiding Session ID], [Product Guiding | 39 | Yes |
| SubFrm Product Guiding Sessions Phase 3 | SELECT [Product Guiding Sessions].[Product Guiding Session ID], [Product Guiding | 39 | Yes |
| SubFrm Product Ignition Actvities | Product Ignition Activities | 15 | Yes |
| SubFrm Product Industrys | Product Industrys | 7 | Yes |
| SubFrm Product Jade Custom Ignition Box Phase 1 | SELECT [Product Jade Custom Ignition Box].[Product Ignition Custom Item ID], [Pr | 7 | Yes |
| SubFrm Product Jade Custom Ignition Box Phase 2 | SELECT [Product Jade Custom Ignition Box].[Product Ignition Custom Item ID], [Pr | 7 | Yes |
| SubFrm Product Jade Custom Ignition Box Phase 3 | SELECT [Product Jade Custom Ignition Box].[Product Ignition Custom Item ID], [Pr | 7 | Yes |
| SubFrm Product Jade Process | Product Jade Process | 12 | Yes |
| SubFrm Product Learning Sessions Phase 1 | SELECT [Product Learning Sessions].[Product Learning Session ID], [Product Learn | 41 | Yes |
| SubFrm Product Learning Sessions Phase 2 | SELECT [Product Learning Sessions].[Product Learning Session ID], [Product Learn | 41 | Yes |
| SubFrm Product Learning Sessions Phase 3 | SELECT [Product Learning Sessions].[Product Learning Session ID], [Product Learn | 41 | Yes |
| SubFrm Product Managed By | Product Managed By | 7 | Yes |
| SubFrm Product Marketing Blue Ocean | Product Marketing Blue Ocean | 10 | Yes |
| SubFrm Product Marketing Elements | Product Marketing Elements | 6 | Yes |
| SubFrm Product Marketing Media Types Customer | Product Marketing Media Types Customer | 10 | Yes |
| SubFrm Product Marketing Media Types Entrepreneur | Product Marketing Media Types Entrepreneur | 10 | Yes |
| SubFrm Product Marketing Media Types Principal | Product Marketing Media Types Principal | 10 | Yes |
| SubFrm Product Pricing Header Display | Qry SubFrm Product Pricing Header Display | 15 | No |
| SubFrm Product Principal Acquisition Process | Product Principal Acquisition Process | 10 | Yes |
| SubFrm Product Principal Journey | Product Principal Journey | 12 | Yes |
| SubFrm Product Principal Reports Sent | Product Principal Reports Sent | 9 | Yes |
| SubFrm Product Principal Reports Structure | Qry Product Principal Reports Structure | 11 | Yes |
| SubFrm Product Principal Retention Process | Product Principal Retention Process | 12 | Yes |
| SubFrm Product Purple Process | Product Purple Process | 14 | Yes |
| SubFrm Product Selection Assessment Phase 1 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 9 | No |
| SubFrm Product Selection Assessment Phase 2 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 9 | No |
| SubFrm Product Selection Assessment Phase 3 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 9 | No |
| SubFrm Product Selection Assessment | Products | 9 | No |
| SubFrm Product Selection Criteria Business Exp Phase 1 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 45 | Yes |
| SubFrm Product Selection Criteria Business Exp Phase 2 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 45 | Yes |
| SubFrm Product Selection Criteria Business Exp Phase 3 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 45 | Yes |
| SubFrm Product Selection Criteria Business Exp | Products | 9 | No |
| SubFrm Product Selection Criteria EP Resource Phase 1 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 40 | No |
| SubFrm Product Selection Criteria EP Resource Phase 2 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 40 | No |
| SubFrm Product Selection Criteria EP Resource Phase 3 | SELECT [Product Selection Criteria and Assessment].[Product Selection Criteria I | 40 | No |
| SubFrm Product Selection Criteria EP Resource | Products | 9 | No |
| SubFrm Product Selection Tests Phase 1 | SELECT [Product Selection Tests].[Product Selection Test ID], [Product Selection | 15 | Yes |
| SubFrm Product Selection Tests Phase 2 | SELECT [Product Selection Tests].[Product Selection Test ID], [Product Selection | 15 | Yes |
| SubFrm Product Selection Tests Phase 3 | SELECT [Product Selection Tests].[Product Selection Test ID], [Product Selection | 15 | Yes |
| SubFrm Product Sold Bys | Product Sold Bys | 7 | Yes |
| SubFrm Product Specific Efficacy Data | Product Specific Efficacy Data | 7 | Yes |
| SubFrm Product Status History | Product Status History | 8 | No |
| SubFrm Product Sub-Divisions | Product Sub-Divisions | 7 | Yes |
| SubFrm Product Supplier Development Phase 1 | SELECT [Product Supplier Development].[Product Supplier Development ID], [Produc | 39 | Yes |
| SubFrm Product Supplier Development Phase 2 | SELECT [Product Supplier Development].[Product Supplier Development ID], [Produc | 39 | Yes |
| SubFrm Product Supplier Development Phase 3 | SELECT [Product Supplier Development].[Product Supplier Development ID], [Produc | 39 | Yes |
| SubFrm Product Who Must Be Trained | Product Who Must Be Trained | 7 | Yes |
Reports (70)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Report Product Sheet | 2 |
| Calibri | Qry Report Product Sheet | 2 |
| Calibri | Qry Report Product Sheet | 2 |
| Calibri | Product Assignment Management | 0 |
| Calibri | SELECT [Product Baseline Audits].[Product ID], [Product Baseline Audits].[Baseli | 0 |
| Calibri | SELECT [Product Baseline Audits].[Product ID], [Product Baseline Audits].[Baseli | 0 |
| Calibri | SELECT [Product Baseline Audits].[Product ID], [Product Baseline Audits].[Baseli | 0 |
| Calibri | SELECT [Product BBBEE Pillars].[Product ID], [Product BBBEE Pillars].[BBBEE Pill | 0 |
| Calibri | Qry SubRpt Product Business Growth Criteria | 0 |
| Calibri | Qry SubFrm Product Categories | 0 |
| Calibri | Product Catering Options | 0 |
| Calibri | Qry SubRpt Product Distribution Models | 0 |
| Calibri | Qry SubRpt Product Divisions | 0 |
| Calibri | Product Entrepreneur Access | 0 |
| Calibri | Product Entrepreneur Committment Fees | 0 |
| Calibri | Qry SubRpt Product Entrepreneurial Development Continuum | 0 |
| Calibri | Qry SubRpt Product Entrepreneurial Growth Criteria | 0 |
| Calibri | Qry SubRpt Product Financial Growth Criteria | 0 |
| Calibri | SELECT [Product Graduation Ceremony].[Product Graduation Ceremony ID], [Product | 0 |
| Calibri | SELECT [Product Graduation Ceremony].[Product Graduation Ceremony ID], [Product | 0 |
| Calibri | SELECT [Product Graduation Ceremony].[Product Graduation Ceremony ID], [Product | 0 |
| Calibri | Product Graduation Ceremony Locations | 0 |
| Calibri | Qry SubRpt Product Guiding Management Phase 1 | 0 |
| Calibri | Qry SubRpt Product Guiding Management Phase 2 | 0 |
| Calibri | Qry SubRpt Product Guiding Management Phase 3 | 0 |
| Calibri | Qry SubRpt Product Guiding Sessions Phase 1 | 0 |
| Calibri | Qry SubRpt Product Guiding Sessions Phase 2 | 0 |
| Calibri | Qry SubRpt Product Guiding Sessions Phase 3 | 0 |
| Calibri | Qry SubRpt Product Ignition Activities | 0 |
| Calibri | Qry SubRpt Product Industrys | 0 |
| Calibri | SELECT [Product Jade Custom Ignition Box].[Product ID], [Product Jade Custom Ign | 0 |
| Calibri | SELECT [Product Jade Custom Ignition Box].[Product ID], [Product Jade Custom Ign | 0 |
| Calibri | SELECT [Product Jade Custom Ignition Box].[Product ID], [Product Jade Custom Ign | 0 |
| Calibri | Qry SubRpt Product Jade Process | 0 |
| Calibri | Qry SubRpt Product Learning Sessions Phase 1 | 0 |
| Calibri | Qry SubRpt Product Learning Sessions Phase 2 | 0 |
| Calibri | Qry SubRpt Product Learning Sessions Phase 3 | 0 |
| Calibri | Product Managed By | 0 |
| Calibri | Product Marketing Blue Ocean | 0 |
| Calibri | Product Marketing Elements | 0 |
| Calibri | Product Marketing Media Types Entrepreneur | 0 |
| Calibri | Product Marketing Media Types Principal | 0 |
| Calibri | Qry SubRpt Product Principal Acquisition Process | 0 |
| Calibri | Qry SubRpt Product Principal Journey | 0 |
| Calibri | Qry SubRpt Product Principal Reports Sent | 0 |
| Calibri | Qry SubRpt Product Principal Reports Structure | 0 |
| Calibri | Qry SubRpt Product Principal Retention Process | 0 |
| Calibri | Products | 0 |
| Calibri | Products | 0 |
| Calibri | Products | 0 |
| Calibri | Qry SubRpt Product Purple Process | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Assessment].[Product ID], [Qry SubRpt Produ | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Assessment].[Product ID], [Qry SubRpt Produ | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Assessment].[Product ID], [Qry SubRpt Produ | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Criteria Business Exp].[Product ID], [Qry S | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Criteria Business Exp].[Product ID], [Qry S | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Criteria Business Exp].[Product ID], [Qry S | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Criteria EP Resource].[Product ID], [Qry Su | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Criteria EP Resource].[Product ID], [Qry Su | 0 |
| Calibri | SELECT [Qry SubRpt Product Selection Criteria EP Resource].[Product ID], [Qry Su | 0 |
| Calibri | Qry SubRpt Product Selection Tests Phase 1 | 0 |
| Calibri | Qry SubRpt Product Selection Tests Phase 2 | 0 |
| Calibri | Qry SubRpt Product Selection Tests Phase 3 | 0 |
| Calibri | Product Sold Bys | 0 |
| Calibri | Product Specific Efficacy Data | 0 |
| Calibri | Product Sub-Divisions | 0 |
| Calibri | Qry SubRpt Product Supplier Development Phase 1 | 0 |
| Calibri | Qry SubRpt Product Supplier Development Phase 2 | 0 |
| Calibri | Qry SubRpt Product Supplier Development Phase 3 | 0 |
| Calibri | Product Who Must Be Trained | 0 |
Queries (170)
| Query | Type | Tables |
|---|---|---|
| aa | Select | dbo_Product Marketing Media Types Principal, dbo_Product Selection Tests |
| Baseline Audit LookUp | Select | dbo_Lookups |
| BBBEE Pillar Lookup | Select | dbo_Lookups |
| Blue Ocean LookUp | Select | dbo_Lookups |
| Bookkeeping Services LookUp | Select | dbo_Lookups |
| Bookkeeping Transactions LookUp | Select | dbo_Lookups |
| Business Growth Criteria LookUp | Select | dbo_Lookups |
| Catering Options LookUp | Select | dbo_Lookups |
| Computer Resource LookUp | Select | dbo_Lookups |
| DatabaseUsersVanadium | Select | dbo_Lookups |
| Development Continuum LookUp | Select | dbo_Lookups |
| Development Continuum SubItm LookUp | Select | dbo_Lookups |
| Distribution Models | Select | dbo_Lookups |
| Divisions | Select | dbo_Lookups |
| Entrepreneur Access LookUp | Select | dbo_Lookups |
| Entrepreneur Development Continuum LookUp | Select | dbo_Lookups |
| Entrepreneurial Growth Criteria LookUp | Select | dbo_Lookups |
| EP RC Hour Type LookUp | Select | dbo_Lookups |
| Financial Growth Criteria LookUp | Select | dbo_Lookups |
| Funding Session Lookup | Select | dbo_Lookups |
| General Vanadium | Select | dbo_Lookups |
| Guide Management | Select | dbo_Lookups |
| Guiding Session Types | Select | dbo_Lookups |
| Guiding Sessions | Select | dbo_Guiding, dbo_Guiding Sessions |
| Ignition Activity LookUp | Select | dbo_Lookups |
| Ignition Activity Type LookUp | Select | dbo_Lookups |
| Ignition Box Item LookUp | Select | dbo_Lookups |
| Ignition Custom Item LookUp | Select | dbo_Lookups |
| Ignition Date Communicate LookUp | Select | dbo_Lookups |
| IndustryLookup | Select | dbo_Lookups |
| Jade Process Steps | Select | dbo_Lookups |
| JB Qry Append Graduation Ceremony Locations | Delete | Product Graduation Ceremony, Product |
| Jocky-Horse Scale Lookup | Select | dbo_Lookups |
| Learning Session Types | Select | dbo_Lookups |
| Learning Sessions | Select | dbo_Learning Sessions, dbo_Learning |
| Level of Participation LookUp | Select | dbo_Lookups |
| Location Requirement LookUp | Select | dbo_Lookups |
| Managed By LookUp | Select | dbo_Lookups |
| Marketing Element LookUp | Select | dbo_Lookups |
| Media Channel LookUp | Select | dbo_Lookups |
| Minimum Age LookUp | Select | dbo_Lookups |
| Minimum BBBEE LookUp | Select | dbo_Lookups |
| Payment Term LookUp | Select | dbo_Lookups |
| Phase Lookup | Select | dbo_Lookups |
| Principal Acquisition Process Steps | Select | |
| Principal Journey Steps | Select | |
| Principal Reports Sent Lookup | Select | dbo_Lookups |
| Principal Reports Structure Lookup | Select | dbo_Lookups |
| Principal Retention Process Steps | Select | |
| Product Assignment Management | Select | dbo_Product Assignment Management, dbo_Product |
| Product Baseline Audits | Select | dbo_Product, dbo_Product Baseline Audits |
| Product BBBEE Pillars | Select | dbo_Product BBBEE Pillars, dbo_Product |
| Product Business Growth Criteria | Select | dbo_Product, dbo_Product Business Growth Criteria |
| Product Catering Options | Select | dbo_Product Catering Options, dbo_Product |
| Product Development Continuums | Select | dbo_Product Development Continuums, dbo_Product |
| Product Distribution Models | Select | dbo_Product, dbo_Product Distribution Models |
| Product Divisions | Select | dbo_Product, dbo_Product Divisions |
| Product Entrepreneur Access | Select | dbo_Product Entrepreneur Access, dbo_Product |
| Product Entrepreneur Committment Fees | Select | dbo_Product Entrepreneur Committment Fees, dbo_Product |
| Product Entrepreneurial Development Continuum | Select | dbo_Product Entrepreneurial Development Continuum, dbo_Product |
| Product Entrepreneurial Growth Criteria | Select | dbo_Product, dbo_Product Entrepreneurial Growth Criteria |
| Product Financial Growth Criteria | Select | dbo_Product Financial Growth Criteria, dbo_Product |
| Product Graduation Ceremony Locations | Select | dbo_Product Graduation Ceremony Locations, dbo_Product |
| Product Graduation Ceremony | Select | dbo_Product, dbo_Product Graduation Ceremony |
| Product Guide Management | Select | dbo_Product, dbo_Product Guide Management |
| Product Guiding Sessions | Select | dbo_Product Guiding Sessions, dbo_Product |
| Product Ignition Activities | Select | dbo_Product Ignition Activities, dbo_Product |
| Product Industrys | Select | dbo_Product Industrys, dbo_Product |
| Product Jade Custom Ignition Box | Select | |
| Product Jade Process | Select | dbo_Product, dbo_Product Jade Process |
| Product Learning Sessions | Select | dbo_Product Learning Sessions, dbo_Product |
| Product Managed By | Select | dbo_Product, dbo_Product Managed By |
| Product Marketing Blue Ocean | Select | dbo_Product Marketing Blue Ocean, dbo_Product |
| Product Marketing Elements | Select | dbo_Product Marketing Elements, dbo_Product |
| Product Marketing Media Types Customer | Select | dbo_Product, dbo_Product Marketing Media Types Customer |
| Product Marketing Media Types Entrepreneur | Select | dbo_Product, dbo_Product Marketing Media Types Entrepreneur |
| Product Marketing Media Types Principal | Select | dbo_Product Marketing Media Types Principal, dbo_Product |
| Product Principal Acquisition Process | Select | dbo_Product, dbo_Product Principal Acquisition Process |
| Product Principal Journey | Select | dbo_Product Principal Journey, dbo_Product |
| Product Principal Reports Sent | Select | dbo_Product, dbo_Product Principal Reports Sent |
| Product Principal Reports Structure | Select | dbo_Product Principal Reports Structure, dbo_Product |
| Product Principal Retention Process | Select | dbo_Product, dbo_Product Principal Retention Process |
| Product Purple Process | Select | dbo_Product, dbo_Product Purple Process |
| Product Selection Criteria and Assessment | Select | dbo_Product, dbo_Product Selection Criteria and Assessment |
| Product Selection Tests | Select | dbo_Product Selection Tests, dbo_Product |
| Product Sold Bys | Select | dbo_Product, dbo_Product Sold Bys |
| Product Specific Efficacy Data | Select | dbo_Product Specific Efficacy Data, dbo_Product |
| Product Status History | Select | dbo_Product Status History, dbo_Product |
| Product Status | Select | dbo_Lookups |
| Product Sub-Divisions | Select | dbo_Product, dbo_Product Sub-Divisions |
| Product Supplier Development | Select | dbo_Product, dbo_Product Supplier Development |
| Product Who Must Be Trained | Select | dbo_Product, dbo_Product Who Must Be Trained |
| Product Who Will Provide Traning | Select | dbo_Product Who Will Provide Traning, dbo_Product |
| Products | Select | dbo_Products |
| Programme Hour Multipliers | Select | dbo_Programme, dbo_Programme Hour Multipliers |
| Purple Panel Rubric LookUp | Select | dbo_Lookups |
| Purple Process Steps | Select | dbo_Purple Process Steps, dbo_Purple |
| Qry Get Multiple Zones by Product | Select | Distribution Models, Product |
| Qry Get Programme Type by Product | Select | BBBEE, BBBEE Pillar Lookup |
| Qry Principal Acquisition Process Steps NOT in Process | Select | |
| Qry Principal Acquisition Process Steps | Select | Principal Acquisition Process Steps, Product |
| Qry Principal Journey Steps NOT in Process | Select | |
| Qry Principal Journey Steps | Select | Product Principal Journey, Principal Journey Steps |
| Qry Principal Retention Process Steps NOT in Process | Select | |
| Qry Principal Retention Process Steps | Select | Product Principal Retention Process, Principal Retention Process Steps |
| Qry Product Guiding Sessions | Select | Guiding, Guiding Sessions |
| Qry Product Jade Process Steps NOT in Process | Select | |
| Qry Product Jade Process Steps | Select | Product, Product Jade Process |
| Qry Product Learning Sessions | Select | Learning, Learning Sessions |
| Qry Product List | Select | Product Status, Products |
| Qry Product Principal Reports Structure NOT Included | Select | SubQry Product Principal Reports Structure NOT Included, SubQry |
| Qry Product Principal Reports Structure | Select | Product Principal Reports Structure, Principal Reports Structure Lookup |
| Qry Product Purple Process Steps NOT in Process | Select | SubQry, SubQry Product Purple Process Steps NOT in Process |
| Qry Product Purple Process Steps | Select | Product Purple Process, Purple Process Steps |
| Qry Report Product Sheet | Select | Products |
| Qry SubFrm Product Categories | Select | |
| Qry SubFrm Product Pricing Header Display | Select | Products |
| Qry SubRpt Product Business Growth Criteria | Select | Product Business Growth Criteria, Product |
| Qry SubRpt Product Distribution Models | Select | Distribution Models, Product |
| Qry SubRpt Product Divisions | Select | Product Divisions, Divisions |
| Qry SubRpt Product Entrepreneurial Development Continuum | Select | Entrepreneur Development Continuum LookUp, Entrepreneur |
| Qry SubRpt Product Entrepreneurial Growth Criteria | Select | Product Entrepreneurial Growth Criteria, Product |
| Qry SubRpt Product Financial Growth Criteria | Select | Financial Growth Criteria LookUp, Product Financial Growth Criteria |
| Qry SubRpt Product Guiding Management Phase 1 | Select | Guide Management, Guide |
| Qry SubRpt Product Guiding Management Phase 2 | Select | Guide Management, Guide |
| Qry SubRpt Product Guiding Management Phase 3 | Select | Guide Management, Guide |
| Qry SubRpt Product Guiding Sessions Phase 1 | Select | Product, Guiding Sessions |
| Qry SubRpt Product Guiding Sessions Phase 2 | Select | Product, Guiding Sessions |
| Qry SubRpt Product Guiding Sessions Phase 3 | Select | Product, Guiding Sessions |
| Qry SubRpt Product Ignition Activities | Select | Product Ignition Activities, Product |
| Qry SubRpt Product Industrys | Select | Product Industrys, IndustryLookup |
| Qry SubRpt Product Jade Process | Select | Jade Process Steps, Product Jade Process |
| Qry SubRpt Product Learning Sessions Phase 1 | Select | Learning Sessions, Product |
| Qry SubRpt Product Learning Sessions Phase 2 | Select | Learning Sessions, Product |
| Qry SubRpt Product Learning Sessions Phase 3 | Select | Learning Sessions, Product |
| Qry SubRpt Product Principal Acquisition Process | Select | Principal Acquisition Process Steps, Product |
| Qry SubRpt Product Principal Journey | Select | Product Principal Journey, Principal Journey Steps |
| Qry SubRpt Product Principal Reports Sent | Select | Product, Product Principal Reports Sent |
| Qry SubRpt Product Principal Reports Structure | Select | Product Principal Reports Structure, Principal Reports Structure Lookup |
| Qry SubRpt Product Principal Retention Process | Select | Product Principal Retention Process, Principal Retention Process Steps |
| Qry SubRpt Product Purple Process | Select | Product Purple Process, Purple Process Steps |
| Qry SubRpt Product Selection Assessment | Select | Product, Product Selection Criteria and Assessment |
| Qry SubRpt Product Selection Criteria Business Exp | Select | Product, Product Selection Criteria and Assessment |
| Qry SubRpt Product Selection Criteria EP Resource | Select | Product, Product Selection Criteria and Assessment |
| Qry SubRpt Product Selection Tests Phase 1 | Select | Product, Product Selection Tests |
| Qry SubRpt Product Selection Tests Phase 2 | Select | Product, Product Selection Tests |
| Qry SubRpt Product Selection Tests Phase 3 | Select | Product, Product Selection Tests |
| Qry SubRpt Product Supplier Development Phase 1 | Select | Supplier Development, Product |
| Qry SubRpt Product Supplier Development Phase 2 | Select | Supplier Development, Product |
| Qry SubRpt Product Supplier Development Phase 3 | Select | Supplier Development, Product |
| Qry Sum Guiding Session Types by Type Phase and Product | Select | Product, Guiding Sessions |
| Qry Sum Learning Session Types by Type Phase and Product | Select | Learning Sessions, Product |
| Qry Sum LMS Session Types by Phase and Product | Select | Learning Sessions, Product |
| Qry Sum Principal Participation Session by Phase and Product | Select | Supplier Development, Product |
| Selection Test LookUp | Select | dbo_Lookups |
| Sold By LookUp | Select | dbo_Lookups |
| Specific Efficacy Data LookUp | Select | dbo_Lookups |
| Sub-Division LookUp | Select | dbo_Lookups |
| SubQry Principal Acquisition Process Steps NOT in Process | Select | |
| SubQry Principal Journey Steps NOT in Process | Select | Product Principal Journey, Product |
| SubQry Principal Retention Process Steps NOT in Process | Select | Product Principal Retention Process, Product |
| SubQry Product Jade Process Steps NOT in Process | Select | Product, Product Jade Process |
| SubQry Product Principal Reports Structure NOT Included | Select | Product Principal Reports Structure, Product |
| SubQry Product Purple Process Steps NOT in Process | Select | Product Purple Process, Product |
| Supplier Development | Select | dbo_Supplier Development, dbo_Supplier |
| Transport Resource LookUp | Select | dbo_Lookups |
| Types of Awards LookUp | Select | dbo_Lookups |
| Where Ceremony Held LookUp | Select | dbo_Lookups |
| Who Must Be Trained LookUp | Select | dbo_Lookups |
| Who Will Provide Training LookUp | Select | dbo_Lookups |
Macros (19)
| Macro | Type | Actions | Forms |
|---|---|---|---|
| Mac RibOpenFormCompliance | UI | 2 | Frm Product List, Frm Add and Edit Product - Distribution Agent Compliance |
| Mac RibOpenFormDetailPart1 | UI | 2 | Frm Product List, Frm Add and Edit Product - Detail Part 1 |
| Mac RibOpenFormDetailPart2 | UI | 2 | Frm Product List, Frm Add and Edit Product - Detail Part 2 |
| Mac RibOpenFormExposure | UI | 2 | Frm Product List, Frm Add and Edit Product - Exposure |
| Mac RibOpenFormFundingBookkeeping | UI | 2 | Frm Product List, Frm Add and Edit Product - Funding and Bookkeeping |
| Mac RibOpenFormGuiding | UI | 2 | Frm Add and Edit Product - Guiding, Frm Product List |
| Mac RibOpenFormInfrastructure | UI | 2 | Frm Product List, Frm Add and Edit Product - Infrastructure |
| Mac RibOpenFormJade | UI | 2 | Frm Product List, Frm Add and Edit Product - Jade |
| Mac RibOpenFormLearning | UI | 2 | Frm Product List, Frm Add and Edit Product - Learning |
| Mac RibOpenFormLegal | UI | 2 | Frm Product List, Frm Add and Edit Product - Legal |
| Mac RibOpenFormMarketingPart1 | UI | 2 | Frm Product List, Frm Add and Edit Product - Marketing Part 1 |
| Mac RibOpenFormMarketingPart2 | UI | 2 | Frm Product List, Frm Add and Edit Product - Marketing Part 2 |
| Mac RibOpenFormOverview | UI | 2 | Frm Add and Edit Product - Overview, Frm Product List |
| Mac RibOpenFormProductPricing | UI | 2 | Frm Product List, Frm Add and Edit Product - Product Fees |
| Mac RibOpenFormProductTraining | UI | 2 | Frm Add and Edit Product - Product Training, Frm Product List |
| Mac RibOpenFormReporting | UI | 2 | Frm Product List, Frm Add and Edit Product - Reporting |
| Mac RibOpenFormSales | UI | 2 | Frm Product List, Frm Add and Edit Product - Sales |
| Mac RibOpenFormSelection | UI | 2 | Frm Product List, Frm Add and Edit Product - Selection |
| Mac RibOpenFormYellow | UI | 2 | Frm Product List, Frm Add and Edit Product - Yellow |