topaz - Technical Architecture
Data Model
Tables (46)
BBBEEPillarLookup
Primary Key: BBBEE
Fields: - BBBEE Pillar ID: Long - BBBEE Pillar Description: Text - BBBEE Pillar: Text
Client Tiers
Primary Key: Client
Fields: - Client Tier ID: Long - Client Tier: Text - Client Tier Range: Text
ContractTypeLookup
Primary Key: Contract
Fields: - Contract Type ID: Long - Contract Type: Text
DatabaseUsers Module Permissions
Primary Key: Module
Fields: - Module Permission ID: Long - Username: Text - Module Permission: Text - LEVEL: Text - Role: Text
DatabaseUsers
Primary Key: Username
Fields: - User ID: Long - Username: Text (PK) - User Password: Text - LEVEL: Text - ForceChange: Boolean - Delivery Location ID: Long - Department: Text - Email Address: Text - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - First Name: Text - Surname: Text - Cell Phone Number: Text
Delivery Locations
Primary Key: Delivery
Fields: - Delivery Location ID: Long - Delivery Location: Text - Region: Text - Delivery Location Code: Text - Distribution Model ID: Long - Companies Target: Long - Raizcorpossibles Target: Long - Default Bookkeeper: Text - Manager Username: Text - Active: Boolean - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
Entrepreneur Company
Primary Key: Entrepreneur
Fields: - Entrepreneur Company ID: Long - Company Status ID: Long - Exit Notes: Text - Date Status Changed: DateTime - Status Modified By: Text - Company Delivery Location ID: Long - Company Name: Text - Business Address 1: Text - Business Address 2: Text - Business Address 3: Text - Business Postal Code: Text - Website: Text - Industry ID: Long - Brief Description of Business: Memo - Average Monthly Turnover: Text - Years in Business: Text - Date Business Started: DateTime - Permanent Employees: Double - Temporary Employees: Double - Enterprise Type: Text - Trading As: Text - Allocation Notes: Memo - Ring Fencing: Boolean - BEE Level: Long - BEE Certificate Type: Text - BEE Certificate Expire Date: DateTime - CompanyReg: Text - Tax Clearance Expire Date: DateTime - Tax Clearance Certificate Number: Text - Business Registration Date: DateTime - Sworn Affidavit Date: DateTime - VAT Registration Number: Text - Proof of Turnover Letter Date: DateTime - Proof of Turnover Accounting Company Name: Text - Bank Statements Start Date: DateTime - Bank Statements End Date: DateTime - Audited Financials Letter Date: DateTime - Audited Financials Accounting Company Name: Text - Percentage Black Owned: Double - Percentage Women Black Owned: Double - Special Accreditations: Text - Business Premises: Text - Business Premises Other: Text - Monthly Premises Rental: Double - Premises Square Meters: Double - Equipment Insurance: Boolean - Equipment Insurance Amt: Double - Personal Vehicle Insurance: Boolean - Personal Vehicle Insurance Amt: Double - Business Vehicle Insurance: Boolean - Business Vehicle Insurance Amt: Double - Loss of Earnings Insurance: Boolean - Loss of Earnings Insurance Amt: Double - Stock Insurance: Boolean - Stock Insurance Amt: Double - Forex Insurance: Boolean - Forex Insurance Amt: Double - Life Insurance: Boolean - Life Insurance Amt: Double - Personal Medical Aid: Boolean - Personal Medical Aid Amt: Double - Staff Medical Aid: Boolean - Staff Medical Aid Amt: Double - Other Insurance: Boolean - Other Insurance Amt: Double - Other Insurance Explanation: Text - Own Bookkeeper: Boolean - Bookkeeper Avg Monthly Cost: Double - Bookkeeper Rating: Long - Bookkeeper Name: Text - Bookkeeper Software: Text - Other Software Explanation: Text - RC Bookkeeper Assigned: Text - Date RC Bookkeeper Assigned: DateTime - SSMA_TimeStamp: Binary - Override Status Rules: Boolean - FYE Month: Text
Entrepreneur Status History
Primary Key: Entrepreneur
Fields: - Entrepreneur Status ID: Long - Entrepreneur ID: Long - Process Status ID: Long - Process Status Notes: Text - Date Status Changed: DateTime - Status Modified By: Text
Entrepreneurs
Primary Key: Entrepreneur
Fields: - Entrepreneur ID: Long - Reference Number: Long - Date Record Created: DateTime - Lead Type ID: Long - Division ID: Long - Date of Birth: DateTime - First Name: Text - Surname: Text - EOI SA Identity Number: Text - EOI Citizenship Type: Text - EOI Date of Naturalisation: DateTime - EOI Business Name: Text - EOI Business Address 1: Text - EOI Business Address 2: Text - EOI Business Address 3: Text - EOI Business Postal Code: Text - EOI Industry ID: Long - EOI Brief Description of Business: Memo - EOI Enterprise Type: Text - EOI Percent of Ownership: Double - EOI Average Monthly Turnover: Text - EOI Years in Business: Text - EOI Do you have a full time job: Text - Entrepreneur Company ID: Long - Shareholding Percentage: Double - Telephone Number: Text - Second Telephone Number: Text - Email Address: Text - Alternative Email Address: Text - Race: Text - Gender: Text - SA Citizen: Text - Identity Number: Text - SAID: Boolean - Profile Created: Boolean - Full Time: Text - Province: Text - Location: Text - Country: Long - Access to PC: Boolean - Access to Laptop: Boolean - Access to Smartphone: Boolean - Quality of Connectivity: Long - Use Tech Resources For Sessions: Long - Source Category: Text - Source Detail: Text - Process Date: DateTime - Pipeline ID: Long - Process Status ID: Long - Process Status Notes: Text - Date Status Changed: DateTime - Status Modified By: Text - Override Status Rules: Boolean - Distribution Model ID: Long - Delivery Location ID: Long - Termination Reason ID: Long - Unqualified Reason ID: Long - Blue Eagle Recommendation Date: DateTime - Blue Eagle Exported: Boolean - Recommended Principal Project ID: Long - Recommended Product ID: Long - Recommended BBBEE Pillar: Text - Primary Entrepreneur: Text - Notes: Memo - Allocation ID: Long - Student ID: Text - Style Questionnaire Score: Double - Style Questionnaire Results: Text - Personal Audit Score: Double - Personal Audit Results: Text - Urgency Result: Text - Financial Literacy Result: Double - Entrepreneurial Assessment Results: Long - EA Date: DateTime - EA Marker: Text - EA Retake Results: Long - EA Retake Date: DateTime - EA Retake Marker: Text - Purple Panel Score: Double - PP Results: Long - Date Panel Held: DateTime - Certified ID Copy: Boolean - Date ID Certified: DateTime - RSA Naturalisation Certificate: Boolean - RSA Naturalisation Issue Date: DateTime - Home Affairs Doc: Boolean - Date Entered South Africa: DateTime - Other Proof of Naturalisation: Boolean - Other Proof Issue Date: DateTime - Employee Payslips: Boolean - Emplouee Number or Start Date: Text - Employee Contracts: Boolean - Employee Contract Start Date: DateTime - EMP 201: Boolean - EMP 201 Last Payment Date: DateTime - IRP5: Boolean - Tax Reference Number: Text - CIPS Documents: Boolean - Sworn Affidavit BEE: Boolean - BBBEE Certificate Issued: Boolean - Tax Clearance Certificate: Boolean - VAT Registration Document: Boolean - Proof of Turnover: Boolean - Minimum Bank Statements: Boolean - Audited Financials: Boolean - Information 1: Memo - Information 2: Memo - Information 3: Memo - Information 4: Memo - Information 5: Memo - OwnedBy: Text - Headhunted By: Text - Headhunted: Boolean - Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - Date Blue Heart Email Sent: DateTime - Other Incubator: Boolean - Other Incubator Text: Text - Access to Tablet: Boolean - Digital State of Business: Long - Digital Fulltime in Business: Long - Digital More Than One Partner: Long - Digital More Than One Business: Long - Digital Bank Account: Long - Digital Fulltime Employees: Long - Digital Signed Employee Contracts: Long - Digital Currently Incubated: Long - Digital Incubation Type: Long - Digital Comodities: Memo - Digital Motivation: Memo - Blue Heart Score Calculated: Double - Date Digital First Meeting Captured: DateTime - SharePoint Link: Text - EOI Ownership Structure: Text - EOI Citizendship Country: Text
General Topaz
Primary Key: Front
Fields: - Front End Version Number: Text
IndustryLookup
Primary Key: Industry
Fields: - Industry ID: Long - Industry: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary - Blue Heart Pass at 45: Boolean
Lead Types
Primary Key: Lead
Fields: - Lead Type ID: Long - Lead Type: Text - Lead Source: Text - Principal Project ID: Long - Lead Format: Text - Industry ID: Long - Start Date: DateTime - End Date: DateTime - Import Template: Text - Last Modified By: Text - Date Modified: DateTime - Status: Text - Do Not Use in Digital: Boolean - SSMA_TimeStamp: Binary
LeadFormatLookup
Primary Key: Lead
Fields: - Lead Format ID: Long - Lead Format: Text
LeadSourceLookup
Primary Key: ID
Fields: - ID: Long (PK) - Lead Source: Text
Marketing Budget Non Principal Project
Primary Key: Marketing
Fields: - Marketing Budget ID: Long - Date Budget Created: DateTime - Marketing Budget Status ID: Long - Budget Year: Long - Budget Description: Text - Budget Amount: Double - SSMA_TimeStamp: Binary
Marketing Campaign Category LookUp
Primary Key: Marketing
Fields: - Marketing Campaign Category ID: Long - Marketing Campaign Category: Text
Marketing Campaign Commodities
Primary Key: Marketing
Fields: - Marketing Campaign Commodity ID: Long - Marketing Campaign ID: Long - Commodity: Text
Marketing Campaign Lead Types
Primary Key: Marketing
Fields: - Marketing Campaign Lead Type ID: Long - Marketing Campaign ID: Long - Lead Type ID: Long
Marketing Campaigns
Primary Key: Marketing
Fields: - Marketing Campaign ID: Long - Marketing Campaign: Text - Principal Project ID: Long - Job Number: Text - Marketing Campaign Category: Text - Marketing Campaign Status ID: Long - Notes: Text
Marketing Channel LookUp
Primary Key: Marketing
Fields: - Marketing Channel ID: Long - Marketing Channel: Text
Marketing Sub Campaign Lead Types
Primary Key: Marketing
Fields: - Marketing Sub Campaign Lead Type ID: Long - Marketing Sub Campaign ID: Long - Lead Type ID: Long
Marketing Sub Campaign Locations
Primary Key: Marketing
Fields: - Marketing Sub Campaign Location ID: Long - Marketing Sub Campaign ID: Long - Delivery Location ID: Long
Marketing Sub Campaigns
Primary Key: Marketing
Fields: - Marketing Sub Campaign ID: Long - Marketing Campaign ID: Long - Marketing Channel: Text - Marketing Sub Campaign Start Date: DateTime - Marketing Sub Campaign End Date: DateTime - Marketing Sub Campaign Spend: Double - SSMA_TimeStamp: Binary
MarketingBudgetStatus
Primary Key: Marketing
Fields: - Marketing Budget Status ID: Long - Status: Text - Active: Boolean - Sort Order: Double - SSMA_TimeStamp: Binary
MarketingCampaignStatus
Primary Key: Marketing
Fields: - Marketing Campaign Status ID: Long - Status: Text - Active: Boolean - Sort Order: Double - SSMA_TimeStamp: Binary
ModulePermissionLookup
Primary Key: Permission
Fields: - Permission ID: Long - Module Permission: Text
NonGraduateReason
Primary Key: Non
Fields: - Non Graduate Reason ID: Long - Non Graduate Reason: Text
Principal Project Pillar Commodities
Primary Key: Principal
Fields: - Principal Project Pillar Commodity ID: Long - Principal Project Pillar ID: Long - Commodity: Text
Principal Project Pillar Delivery Location
Primary Key: Principal
Fields: - Principal Project Pillar Delivery Location ID: Long - Principal Project Pillar ID: Long - Delivery Location: Text - Delivery Location Other: Text
Principal Project Pillar Sourced From
Primary Key: Principal
Fields: - Principal Project Pillar Source ID: Long - Principal Project Pillar ID: Long - Entrepreneur Sourced: Text
Principal Project Pillars
Primary Key: Principal
Fields: - Principal Project Pillar ID: Long - Principal Project ID: Long - BBBEE Pillar: Text - Amount Sponsored: Double - Number of Companies Required: Double - Does Principal Approve Entrepreneurs: Boolean - Entrepreneur Delivery Date: DateTime - Principal Subsidise Assessment Fee: Long - Subsidised Assessment Amount: Double - Supply Chain Requirement: Text - Supporting Doc Affidavit (EME): Boolean - Supporting Doc BEE Certificate: Boolean - Supporting Doc Certified ID Copy: Boolean - Supporting Doc CK1 Document: Boolean - Supporting Doc EMP201: Boolean - Supporting Doc Employee Payslips: Boolean - Supporting Doc IRP5: Boolean - Supporting Doc VAT Registration: Boolean - Supporting Doc Proof of Turnover: Boolean - Supporting Doc Tax Clearance Certificate: Boolean - Supporting Doc Other: Boolean - Supporting Doc Other Text: Text - Lump Sum Allocation: Boolean - Scout: Text - Marketing Campaign Required: Long - Principal Campaign Branded: Long - Launch Required: Long - Principal Launch Budget: Double - Raizcorp Launch Budget: Double - Who Arranges Launch: Long - PR Type: Text - Info Session Type: Text - SSMA_TimeStamp: Binary - DEL Principal Project Pillar Urgency: Boolean - Principal Project Pillar Urgency: Byte
Principal Project Products Sold
Primary Key: Principal
Fields: - Principal Project Product Sold ID: Long - Principal Project ID: Long - Product: Text
Principal Projects
Primary Key: Principal
Fields: - Principal Project ID: Long - Principal ID: Long - Sales Brief ID: Long - Sales Brief Number: Text - Version Number: Double - Project Name: Text - Solutions Architect: Text - Contract Type: Text - Principal Project Status ID: Long - Brief Date: DateTime - Contract Start Date: DateTime - Contract End Date: DateTime - Contract Number: Text - Client Tier ID: Long - Entity Contracted: Text - Verification Agency Name: Text - Principal Verified Date: DateTime - Date Principal Requires Packs: DateTime - Reporting Frequency ID: Long - Additional Marketing Costs: Double - Standard Marketing Budget: Double - Last Modified By: Text - Date Modified: DateTime - Active: Boolean - SSMA_TimeStamp: Binary - Pricing Mode: Long - Date Principal Needs Spend: DateTime - Procurement Commit to Meeting: Long - Key Account Manager: Text
PrincipalProjectStatus
Primary Key: Principal
Fields: - Principal Project Status ID: Long - Status: Text - Active: Boolean - Sort Order: Long - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
Principals
Primary Key: Principal
Fields: - Principal ID: Long - Second Principal ID: Long - First Principal ID: Long - Principal: Text (PK) - Principal Address 1: Text - Principal Address 2: Text - Principal Address 3: Text - Principal Address 4: Text - Channel Partner ID: Long - Contact First Name: Text - Contact Surname: Text - Contact Email: Text - Marketing Contact First Name: Text - Marketing Contact Surname: Text - Marketing Contact Email: Text - Marketing Contact Phone: Text - Industry ID: Long - Industry Charter: Text - Industry Notes: Text - FYE: Text - Last Modified By: Text - Date Modified: DateTime - Active: Boolean - SSMA_TimeStamp: Binary - Transformation Contact First Name: Text - Transformation Contact Surname: Text - Transformation Contact Position: Text - Transformation Contact Email: Text - Transformation Contact Cell: Text - Procurement Contact First Name: Text - Procurement Contact Surname: Text - Procurement Contact Position: Text - Procurement Contact Email: Text - Procurement Contact Cell: Text
ProcessStatus
Primary Key: Process
Fields: - Process Status ID: Long - Step Number: Long - Progress Category ID: Long - Status: Text - Status Type: Text - Time Unit: Long - Active: Boolean - Sort Order: Double - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - Selection Type: Long
Products
Primary Key: Product
Fields: - Product ID: Long - Product: Text (PK) - Certificate Programme Name: Text - Product Code: Text - Pipeline ID: Long - Last Modified By: Text - Date Modified: DateTime - Active: Boolean - Programme Year Length: Double - SSMA_TimeStamp: Binary
ProgrammeYearLookup
Primary Key: Programme
Fields: - Programme Year: Text - Sort Order: Long
Reporting Frequency
Primary Key: Reporting
Fields: - Reporting Frequency ID: Long - Reporting Frequency: Text - Reporting Frequency Description: Text
StatusActiveLookup
Primary Key: ID
Fields: - ID: Long (PK) - Status: Text
Temp Lead Type for Lead Report
Primary Key: Not defined
Fields: - Lead Type ID: Long
TerminationReason
Primary Key: Termination
Fields: - Termination Reason ID: Long - Termination Reason: Text - Text for External Use: Text - Last Modified By: Text - Date Modified: DateTime - Active: Boolean - SSMA_TimeStamp: Binary
UnqualifiedReason
Primary Key: Unqualified
Fields: - Unqualified Reason ID: Long - Unqualified Reason: Text - Unqualified Text for External Use: Text - Last Modified By: Text - Date Modified: DateTime - Active: Boolean - SSMA_TimeStamp: Binary
vwPurpleRptLeadTypetoPrincipalAllocationCriteria
Primary Key: Not defined
Fields: - Lead Type Principal Project ID: Long - Lead Type: Text - Allocated Principal Project ID: Long - Process Status: Text - Company Status: Text - Entrepreneur ID: Long - Company Name: Text - First Name: Text - Surname: Text - Lead Principal: Text - Lead Project Name: Text - Allocated Principal: Text - Allocated Project Name: Text
zstblODBC_db
Primary Key: DBID
Fields: - DBID: Long (PK) - SelectDB: Boolean - ServerName: Text - DBName: Text - Authentication: Text - UID: Text - PWD: Text - Driver: Text - DateAdded: DateTime
zstblODBC_tables
Primary Key: TableID
Fields: - TableID: Long (PK) - Link: Boolean - Hidden: Boolean - TableName: Text - SourceTableName: Text - AfterDDL: Text - Comment: Text - DateAdded: DateTime
Code Components
Modules (31)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Add and Edit Budget Status | Form | 72 | 3 |
| Form_Add and Edit Campaign Status | Form | 72 | 3 |
| Form_Add and Edit Lead Type | Form | 31 | 3 |
| Form_Add and Edit Marketing Budget Non Principal Project | Form | 30 | 3 |
| Form_Add and Edit Marketing Campaign Category | Form | 61 | 3 |
| Form_Add and Edit Marketing Campaign View Principal Project | Form | 33 | 3 |
| Form_Add and Edit Marketing Campaign | Form | 31 | 3 |
| Form_Add and Edit Marketing Channel | Form | 61 | 3 |
| Form_Add and Edit Marketing Sub Campaign | Form | 30 | 3 |
| Form_Change Password | Form | 138 | 5 |
| Form_Display Marketing Sub Campaigns Expire 2 Days List | Form | 25 | 2 |
| Form_Lead Type List | Form | 92 | 6 |
| Form_Lead Type Principal Project Report Dialog | Form | 45 | 3 |
| Form_Maintenance Menu | Form | 40 | 6 |
| Form_Marketing Campaign List | Form | 284 | 21 |
| Form_Marketing Lead Report Date Dialog | Form | 100 | 3 |
| Form_Opening Dialog | Form | 103 | 4 |
| Form_Principal Projects No Marketing Campaign List | Form | 83 | 6 |
| Form_Report Menu | Form | 63 | 8 |
| Form_Reports Date Dialog | Form | 54 | 2 |
| Form_Reports Print Export Date Dialog | Form | 52 | 2 |
| Form_Reports Print Export Dialog | Form | 44 | 2 |
| Form_SubFrm Marketing Campaign Commodities | Form | 20 | 1 |
| Form_SubFrm Marketing Campaign Lead Types | Form | 20 | 1 |
| Form_SubFrm Marketing Sub Campaign Lead Types | Form | 20 | 1 |
| Form_SubFrm Marketing Sub Campaign Locations | Form | 20 | 1 |
| Form_SubFrm Principal Project Pillar Commodities | Form | 29 | 2 |
| basRelink | Standard | 604 | 7 |
| Mod Export Excel | Standard | 693 | 6 |
| Mod Send Outlook Message | Standard | 53 | 1 |
| Mod Utilities | Standard | 140 | 8 |
Forms (32)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Add and Edit Budget Status | MarketingBudgetStatus | 15 | Yes |
| Add and Edit Campaign Status | MarketingCampaignStatus | 15 | Yes |
| Add and Edit Lead Type | Lead Types | 22 | Yes |
| Add and Edit Marketing Budget Non Principal Project | Marketing Budget Non Principal Project | 17 | Yes |
| Add and Edit Marketing Campaign Category | Marketing Campaign Category LookUp | 11 | Yes |
| Add and Edit Marketing Campaign View Principal Project | Principal Projects | 37 | Yes |
| Add and Edit Marketing Campaign | Marketing Campaigns | 21 | Yes |
| Add and Edit Marketing Channel | Marketing Channel LookUp | 11 | Yes |
| Add and Edit Marketing Sub Campaign | Marketing Sub Campaigns | 16 | Yes |
| Change Password | Unbound | 19 | Yes |
| Display Marketing Sub Campaigns Expire 2 Days List | Unbound | 10 | Yes |
| Lead Type List | Unbound | 11 | Yes |
| Lead Type Principal Project Report Dialog | Unbound | 7 | Yes |
| Maintenance Menu | Unbound | 7 | Yes |
| Marketing Campaign List | Qry Budget Spend Totals | 42 | Yes |
| Marketing Lead Report Date Dialog | Unbound | 14 | Yes |
| Opening Dialog | Unbound | 11 | Yes |
| Principal Projects No Marketing Campaign List | Unbound | 10 | Yes |
| Report Menu | Unbound | 6 | Yes |
| Reports Date Dialog | Unbound | 6 | Yes |
| Reports Print Export Date Dialog | Unbound | 10 | Yes |
| Reports Print Export Dialog | Unbound | 7 | Yes |
| SubFrm Marketing Campaign Commodities | Marketing Campaign Commodities | 8 | Yes |
| SubFrm Marketing Campaign Lead Types | Marketing Campaign Lead Types | 8 | Yes |
| SubFrm Marketing Sub Campaign Lead Types | Marketing Sub Campaign Lead Types | 8 | Yes |
| SubFrm Marketing Sub Campaign Locations | Marketing Sub Campaign Locations | 8 | Yes |
| SubFrm Principal Project Marketing Campaign Budget Data | Qry Budget Spend Totals by Marketing Campaign | 8 | No |
| SubFrm Principal Project Marketing Campaign | Marketing Campaigns | 18 | No |
| SubFrm Principal Project Pillar Commodities | Principal Project Pillar Commodities | 6 | Yes |
| SubFrm Principal Project Pillar Delivery Location | Principal Project Pillar Delivery Location | 6 | No |
| SubFrm Principal Project Pillars | Principal Project Pillars | 44 | No |
| SubFrm Principal Project Products Sold | Principal Project Products Sold | 6 | No |
Reports (4)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Report Marketing Leads Version Two | 2 |
| Calibri | Qry Report Marketing Sub Campaign Spend | 2 |
| Calibri | Qry Report Marketing Sub Campaign Expire 2 Days | 2 |
| Calibri | Qry SubRpt Marketing Sub Campaign Lead Types | 0 |
Queries (39)
| Query | Type | Tables |
|---|---|---|
| Qry Budget Spend Totals by Marketing Campaign | Select | Principal, Principal Projects |
| Qry Budget Spend Totals | Select | Qry Sum Marketing Spend, Qry Sum Marketing Budget Principal Project |
| Qry Get Lead Types for Passed Panel Entrepreneurs | Select | Entrepreneurs, ProcessStatus |
| Qry Get Marketing Sub Campaign Expire 2 Days | Select | Marketing Campaigns, Principal Projects |
| Qry Lead Type List | Select | IndustryLookup, Principal Projects |
| Qry Marketing Budget Non Principal Project List | Select | MarketingBudgetStatus, Marketing Budget Non Principal Project |
| Qry Marketing Campaign List Other | Select | MarketingCampaignStatus, Qry Sum Total Spend by Principal Project |
| Qry Marketing Campaign List | Select | MarketingCampaignStatus, Qry Sum Total Spend by Principal Project |
| Qry Marketing Sub Campaign List | Select | Marketing Sub Campaigns, Marketing |
| Qry Principal Projects No Marketing Campaign | Select | Principal, Principal Projects |
| Qry Report Lead Type to Principal Allocation | Select | SubQry Rpt Lead Type to Principal Allocation Criteria, SubQry |
| Qry Report Marketing EOI to Passed Panel | Select | Temp Lead Type for Lead Report, Temp |
| Qry Report Marketing Leads Version Two | Select | SubQry Rpt Count Uncontacted Leads, SubQry Rpt Count Total Leads Generated |
| Qry Report Marketing Pre-Unqualified Leads | Select | Entrepreneurs, UnqualifiedReason |
| Qry Report Marketing Spend Current Principal Projects | Select | MarketingCampaignStatus, Marketing Campaigns |
| Qry Report Marketing Spend Past Principal Projects | Select | MarketingCampaignStatus, Marketing Campaigns |
| Qry Report Marketing Sub Campaign Expire 2 Days | Select | Marketing, Marketing Campaigns |
| Qry Report Marketing Sub Campaign Spend | Select | Marketing, Marketing Campaigns |
| Qry SubFrm Principal Project Pillar Supporting Documents | Select | Principal Project Pillars, Principal |
| Qry SubRpt Marketing Sub Campaign Lead Types | Select | Marketing Sub Campaign Lead Types, Marketing |
| Qry Sum Marketing Budget Non Principal Project | Select | Marketing Budget Non Principal Project, Marketing |
| Qry Sum Marketing Budget Principal Project | Select | Marketing, Principal Projects |
| Qry Sum Marketing Spend by Campaign | Select | Marketing Sub Campaigns, Marketing |
| Qry Sum Marketing Spend | Select | Marketing Sub Campaigns, Marketing |
| Qry Sum Total Spend by Principal Project | Select | Principal Project Pillars, Principal |
| qryLinkODBC | Select | zstblODBC_db, zstblODBC_tables |
| SubQry Rpt Count Followed Up Leads | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count On Hold Leads | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Qualified Leads | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Terminated Leads | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Total Leads Generated | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Uncontacted Leads | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Unqualified Leads | Select | SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Lead Type to Principal Allocation Criteria | Select | vwPurpleRptLeadTypetoPrincipalAllocationCriteria |
| SubQry Rpt Marketing EOI to Passed Panel Count EOI | Select | Entrepreneurs, Temp Lead Type for Lead Report |
| SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel | Select | Entrepreneurs, Temp Lead Type for Lead Report |
| SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit | Select | Entrepreneurs, Temp Lead Type for Lead Report |
| SubQry Rpt Marketing EOI to Passed Panel Count Qualified | Select | SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit, SubQry |
| SubQry Rpt Marketing Leads Criteria | Select | Entrepreneurs, Entrepreneur Company |
Macros (0)
| Macro | Type | Actions | Forms |
|---|---|---|---|