purple - Technical Architecture

Data Model

Tables (152)

Archive Entrepreneur Data

Primary Key: Entrepreneur

Fields: - Entrepreneur Archive ID: Long - Entrepreneur ID: Long - 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 - SSMA_TimeStamp: Binary

Archive Entrepreneur Purple Panelists

Primary Key: Archive

Fields: - Archive Entrepreneur Purple Panelist ID: Long - Entrepreneur ID: Long - Purple Panelist: Text - Purple Panelist Score: Double - Convener: Boolean - SSMA_TimeStamp: Binary

AreasofOperationLookup

Primary Key: Area

Fields: - Area of Operation ID: Long - Area of Operation: Text

AssessmentMarkerLookup

Primary Key: Assessment

Fields: - Assessment Marker ID: Long - Assessment Marker: Text - Active: Boolean - SSMA_TimeStamp: Binary

BBBEEPillarLookup

Primary Key: BBBEE

Fields: - BBBEE Pillar ID: Long - BBBEE Pillar Description: Text - BBBEE Pillar: Text

BusinessPremisesLookup

Primary Key: ID

Fields: - ID: Long (PK) - Business Premises: Text

Channel Partners

Primary Key: Channel

Fields: - Channel Partner ID: Long - Channel Partner: Text - Active: Boolean - SSMA_TimeStamp: Binary

Client Tiers

Primary Key: Client

Fields: - Client Tier ID: Long - Client Tier: Text - Client Tier Range: Text

CompanyProgrammeYearStatus

Primary Key: Company

Fields: - Company Programme Year Status ID: Long - Programme Year Status: Text - Active: Boolean - Sort Order: Double - SSMA_TimeStamp: Binary

CompanyStatus

Primary Key: Company

Fields: - Company Status ID: Long - Status: Text - Active: Boolean - Sort Order: Double - SSMA_TimeStamp: Binary

ContractTypeLookup

Primary Key: Contract

Fields: - Contract Type ID: Long - Contract Type: Text

CountryLookup

Primary Key: Country

Fields: - Country ID: Long - Country: Text (PK) - Country Code: Text - Active: Boolean - SSMA_TimeStamp: Binary

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

DepartmentLookup

Primary Key: ID

Fields: - ID: Long (PK) - Department: Text

DevelopmentLookup

Primary Key: ID

Fields: - ID: Long (PK) - Development: Text

Distribution Models

Primary Key: Distribution

Fields: - Distribution Model ID: Long - Distribution Model: Text - Distribution Model Code: Text - Active: Boolean - SSMA_TimeStamp: Binary

Divisions

Primary Key: Division

Fields: - Division ID: Long - Division: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary

Engage UUID

Primary Key: Key

Fields: - Key ID: Long - REMS ID: Long - UUID: Text - Source: Text

EnterpriseTypeLookup

Primary Key: ID

Fields: - ID: Long (PK) - EnterpriseType: Text

Entrepreneur Arize First Meeting Candidate Recommendations

Primary Key: Entrepreneur

Fields: - Entrepreneur Candidate Recommendation ID: Long - Entrepreneur Arize First Meeting ID: Long - Date Recommended: DateTime - Candidate Name: Text - Candidate Company: Text - Candidate Contact Number: Text - Candidate Email: Text

Entrepreneur Arize First Meeting

Primary Key: Entrepreneur

Fields: - Entrepreneur Arize First Meeting ID: Long - Entrepreneur ID: Long - Date Interviewed: DateTime - Interviewed By: Text - Arize First Meeting Notes: Memo - Part I Q1 Share a Bit: Memo - Part I Q2 Belief System: Memo - Part I Q3 Vision: Memo - Part I Q4 Working Well: Memo - Part I Q5 Greatest Stress: Memo - Part I Q6 How Can Help: Memo - Part I Q7 Other Incubator: Boolean - Part I Q7 Other Incubator Text: Text - Part I Q8 Time Committment: Boolean - Part I Q8 Time Committment Text: Memo - Part I Q9A Attending Sessions: Boolean - Part I Q9A Attending Sessions Text: Memo - Part I Q9B Submitting Assignments: Boolean - Part I Q9B Submitting Assignments Text: Memo - Part I Q9C Paying Fee: Boolean - Part I Q9C Paying Fee Text: Memo - Part I Q10 Willing to Give Up: Memo - Part I Q11 Cover Business: Memo - OK to Continue: Boolean - Part II Q1 Biggest Purchases 1: Text - Part II Q1 Biggest Purchases 2: Text - Part II Q1 Biggest Purchases 3: Text - Part II Q2 Biggest Invoices 1: Text - Part II Q2 Biggest Invoices 2: Text - Part II Q2 Biggest Invoices 3: Text - Part II Q3 Greatest Challenge: Memo - Part II Q4 Sustain Business: Memo - Part II Q5 Who Do You Go To: Memo - Part II Q6 Current Weaknesses: Memo - Part II Q7 Overcome Weaknesses: Memo - Part II Q8 Current Strengths: Memo - Part II Q9 Achieve Success: Memo - Part II Q10 Learned From Success: Memo - Part III Q1 Type of Language: Long - Part III Q1 Type of Language Text: Memo - Part III Q2 Desire New Clients: Long - Part III Q2 Desire New Clients Text: Memo - Part III Q3 Level of Certainty: Long - Part III Q3 Level of Certainty Text: Memo - Part III Q4 Level of Blame: Long - Part III Q4 Level of Blame Text: Memo - Part III Q5 Raizcorp as Saviour: Long - Part III Q5 Raizcorp as Saviour Text: Memo - Part III Q6 Compelling Vision: Long - Part III Q6 Compelling Vision Text: Memo - Part IV Scouts Recommendation: Boolean - Part IV Scouts Recommendation Text: Memo - SSMA_TimeStamp: Binary - Part V Researched Applicants Website: Long - Part V Applicant Does Not Compete as an Incubator: Boolean - Part V Applicant Does Not Train Business Courses: Boolean - Part V Applicant Does Not Do Business Coaching: Boolean - Part V Applicant Has No Intention To Compete: Boolean - Part V Applicant Does Not Have Website: Boolean - Part V Unearth Potential Conflicts: Boolean - Part FC FF Q1A Do To Build Business Strategy: Memo - Part FC FF Q1B How Do You Document Business Strategy: Memo - Part FC FF Q2A Prepared to Spend Time On Business: Memo - Part FC FF Q2B How Do We Know You Will: Memo - Part FC FF Q3A Work Life Balance: Long - Part FC FF Q3B Work Life Balance Reason: Memo - Part FC FF Q4A Good Bad Managers: Long - Part FC FF Q4B Good Bad Managers Reason: Memo - Part FC FF Q5 Tell About A Process: Memo - Part FC FF Q6 Someone Not Performing: Memo - Part FC FF Q7 Clients Only Want You: Memo - Part FC FF Q8 Do Something Properly: Memo

Entrepreneur Business Partners

Primary Key: Entrepreneur

Fields: - Entrepreneur Partner ID: Long - Entrepreneur ID: Long - Child Entrepreneur ID: Long

Entrepreneur Company Areas of Operation

Primary Key: Entrepreneur

Fields: - Entrepreneur Area of Operation ID: Long - Entrepreneur Company ID: Long - Area of Operation: Text

Entrepreneur Company Commodities

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Commodity ID: Long - Entrepreneur Company ID: Long - Commodity: Text

Entrepreneur Company Extra Sponsor Elements

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Extra Sponsor Element ID: Long - Principal Project Pillar Sponsor Element ID: Long - Entrepreneur Company ID: Long - Extra Sponsorship Amount: Double

Entrepreneur Company Extra Sponsor Payments

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Extra Sponsor Payment ID: Long - Entrepreneur Company Extra Sponsor Element ID: Long - Payment Date: DateTime - Payment Amount: Double

Entrepreneur Company Monthly Billings

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Billings ID: Long - Billing Date: DateTime - Entrepreneur Company Principal Project ID: Long - Principal Project Pillar ID: Long - Billing Amount: Double - Billing Description: Text - SSMA_TimeStamp: Binary

Entrepreneur Company Non Participant Shareholders

Primary Key: Non

Fields: - Non Participant Shareholder ID: Long - Entrepreneur Company ID: Long - Non Participant Shareholder First Name: Text - Non Participant Shareholder Surname: Text - Non Participant Shareholder Telephone Number: Text - Non Participant Shareholder Email: Text - SSMA_TimeStamp: Binary

Entrepreneur Company Principal Projects

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Principal Project ID: Long - Date Allocation Created: DateTime - Entrepreneur Company Programme Years ID: Long - Principal Project Pillar ID: Long - Allocated Amount: Double - Monthly Allocated Amount: Double - Selection Fee: Double - Selection Fee Type: Text - Replacement Status: Text - Lump Sum Allocation: Boolean - Replacement For: Long - EP Replaced By: Long - EP Replacement For: Long - Contract Printed: Boolean - Date Contract Signed: DateTime - VA Packs Delivered: DateTime - Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - Element Type: Text - Extra Sponsorship Amount: Double - Frequency of Payments: Text - Payment Amount: Double - VA Pack Audit Status ID: Long - Date VA Pack Audit Status Changed: DateTime - VA Pack Audit Status Changed By: Text - VA Pack Audit Score: Double - SA SDM Notified: Boolean

Entrepreneur Company Programme Year Status History

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Programme Year Status ID: Long - Entrepreneur Company Programme Years ID: Long - Company Programme Year Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text

Entrepreneur Company Programme Years

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Programme Years ID: Long - Entrepreneur Company ID: Long - Company Programme Year Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text - Non Graduate Reason ID: Long - Product ID: Long - Programme Year: Text - Total Programme Amount: Double - Contract Start Date: DateTime - Contract End Date: DateTime - Committment Fee: Double - Committment Fee Invoiced: Boolean - Monthly or Annually: Text - Strategic or Nonstrategic: Text - Ignition Date: DateTime - Certificate Printed: Boolean - Certificate Number: Text - SSMA_TimeStamp: Binary - Total Selection Fee: Double - Break Start Date: DateTime - Primary Tenant: Memo - Secondary Tenant: Memo

Entrepreneur Company Status History

Primary Key: Entrepreneur

Fields: - Entrepreneur Company Status ID: Long - Entrepreneur Company ID: Long - Company Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text

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 Edit History

Primary Key: Entrepreneur

Fields: - Entrepreneur Edit ID: Long - Entrepreneur ID: Long - Modified By: Text - Date Modified: DateTime

Entrepreneur Notes

Primary Key: Entrepreneur

Fields: - Entrepreneur Note ID: Long - Entrepreneur ID: Long - Note Date: DateTime - Notes: Text

Entrepreneur Notifications Sent

Primary Key: Notification

Fields: - Notification ID: Long - Entrepreneur ID: Long - Notification Type: Text - Notification Date: DateTime

Entrepreneur Profile Presented To

Primary Key: Entrepreneur

Fields: - Entrepreneur Profile Presented To ID: Long - Entrepreneur ID: Long - Principal Project ID: Long - Solutions Architect: Text - Date Presented: DateTime - Result Date: DateTime - Result: Text

Entrepreneur Purple Panelists

Primary Key: Entrepreneur

Fields: - Entrepreneur Purple Panelist ID: Long - Entrepreneur ID: Long - Purple Panelist: Text - Purple Panelist Score: Double - Convener: Boolean - SSMA_TimeStamp: Binary

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

Entrepreneur Style Questionnaire

Primary Key: Entrepreneur

Fields: - Entrepreneur Styles Questionnaire ID: Long - Entrepreneur ID: Long - Date Completed: DateTime - Sales Style: Long - Planning Style: Long - Focus Style: Long - Leadership Style: Long - Self Belief Style: Long - Employment Style: Long - Work Style: Long - Sentence Style: Long - Profit Style: Long - Balance Style: Long - Reading Style: Long - Self Development Style: Long - Growth Style: Long - SSMA_TimeStamp: Binary

Entrepreneur Year One Profile

Primary Key: Entrepreneur

Fields: - Entrepreneur Year One Profile ID: Long - Entrepreneur ID: Long - Strengths From Psych Assessment: Memo - RESN Notes: Memo - SSMA_TimeStamp: Binary

EntrepreneurProfilePresentedToResultLookup

Primary Key: Entrepreneur

Fields: - Entrepreneur Profile Present Result ID: Long - Entrepreneur Profile Present Result: Text

Entrepreneurs Test

Primary Key: Not defined

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

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

Export Information

Primary Key: Allocation

Fields: - Allocation Template File Name: Text

FullPartLookup

Primary Key: ID

Fields: - ID: Long (PK) - FullPart: Text

GenderLookup

Primary Key: ID

Fields: - ID: Long (PK) - Gender: Text

General Purple

Primary Key: Front

Fields: - Front End Version Number: Text - Kill File Name: Text - Allocation Template File Name: Text - Contract Mail Merge File Name: Text - Style Questionnaire Total Score: Long - SSMA_TimeStamp: Binary

ImportEntrepreneurs

Primary Key: Not defined

Fields: - First Name:: Text - Last Name:: Text - Gender: Text - Racial Group:: Text - Are you a South African citizen?: Text - Phone Number:: Double - Cell Number:: Double - Email Address:: Text - Company Name: Text - Industry:: Text - Province:: Text - Delivery Location:: Text - Average monthly turnover/ income for the last six months:: Text - Years in business:: Text - How did you hear about this opportunity?: Text - Custom field 1: Text - Custom field 2: Text - Custom field 3: Text - Custom field 4: Text - Custom field 5: Text

ImportTemplateLookup

Primary Key: Import

Fields: - Import Template ID: Long - Import Template: Text - Import Procedure: 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

ModuleLevelsLookup

Primary Key: Module

Fields: - Module Level ID: Long - Module Permission: Text - Level: Text

ModulePermissionLookup

Primary Key: Permission

Fields: - Permission ID: Long - Module Permission: Text

MonthLkUp

Primary Key: Month

Fields: - Month Number: Long - Month Name: Text - Last Day: Integer

NonGraduateReason

Primary Key: Non

Fields: - Non Graduate Reason ID: Long - Non Graduate Reason: Text

PersonalAuditResultLookup

Primary Key: Personal

Fields: - Personal Audit Result ID: Long - Personal Audit Result: Text - Personal Audit Min: Long - Personal Audit Max: Long

Pipelines Detail

Primary Key: Pipeline

Fields: - Pipeline Detail ID: Long - Pipeline ID: Long - Process Status ID: Long

Pipelines

Primary Key: Pipeline

Fields: - Pipeline ID: Long - Pipeline: Text (PK) - Selection Type: Long

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 Pillar Sponsor Elements

Primary Key: Principal

Fields: - Principal Project Pillar Sponsor Element ID: Long - Principal Project Pillar ID: Long - Element Type: Text - Sponsorship Amount: Double - Admin Fee: Double - Number of Entrepreneurs: Long - Frequency of Payments: Text - Once Off Payment Date: DateTime - Monthly Day of Month: Text - Payment Amount: Double

Principal Project Pillar Sub Products

Primary Key: Principal

Fields: - Principal Project Pillar Sub Product ID: Long - Principal Project Pillar ID: Long - Sub Product ID: Long - Sponsorship Amount: Double - Number of Entrepreneurs: Long - Frequency: Text - SSMA_TimeStamp: Binary

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

Principal Report Stage Information

Primary Key: Stage

Fields: - Process Category: Text - Stage: Text (PK) - Stage Name: Text - Explanation: Text

Principal Report Text

Primary Key: Not defined

Fields: - Opening Paragraph: Memo - SSMA_TimeStamp: Binary

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

ProcessStep

Primary Key: Step

Fields: - Step Number: Long - Process Step: Text - Phase: Text - Last Modified By: Text - Date Modified: DateTime

Product Distribution Models

Primary Key: Product

Fields: - Product Distribution Model ID: Long - Product ID: Long - Distribution Model ID: Long

Product Divisions

Primary Key: Product

Fields: - Product Division ID: Long - Product ID: Long - Division ID: Long - BEE Certificate Required: Boolean - SSMA_TimeStamp: Binary

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

ProgressCategory

Primary Key: Progress

Fields: - Progress Category ID: Long - Progress Category: Text - Sort Order: Long - Last Modified By: Text - Date Modified: DateTime

ProvinceLookup

Primary Key: Province

Fields: - Province ID: Long - Province: Text (PK) - Active: Boolean - SouthAfrican: Boolean - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary

RaceLookup

Primary Key: Race

Fields: - Race ID: Long - Race: Text (PK) - Active: Boolean - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary

ReferenceNumbersImported

Primary Key: Reference

Fields: - Reference Number: Long

ReplacementStatusLookup

Primary Key: Replacement

Fields: - Replacement Status ID: Long - Replacement Status: Text

Report Writer Included Field Names

Primary Key: ID

Fields: - ID: Long (PK) - Description: Text - Include Field Name: Text - Sort Order: Long

Reporting Frequency

Primary Key: Reporting

Fields: - Reporting Frequency ID: Long - Reporting Frequency: Text - Reporting Frequency Description: Text

Restore Deleted Leads

Primary Key: Not defined

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 - 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

RoleLookup

Primary Key: Role

Fields: - Role ID: Long - Role: Text (PK)

Scouts

Primary Key: Scout

Fields: - Scout ID: Long - Scout First Name: Text - Scout Surname: Text

SourceCategoryLookup

Primary Key: Source

Fields: - Source Category ID: Long - Source Category: Text - Active: Boolean - Last Modified By: Text - Date Modified: Text - SSMA_TimeStamp: Binary

SourceDetailLookup

Primary Key: Source

Fields: - Source Detail ID: Long - Source Detail: Text - Last Modified By: Text - Date Modified: DateTime - Active: Boolean - SSMA_TimeStamp: Binary

StatusActiveLookup

Primary Key: ID

Fields: - ID: Long (PK) - Status: Text

Style Questions and Weighting

Primary Key: Style

Fields: - Style Question ID: Long - Style Name: Text - Option Number: Long - Option Description: Text - Weighting: Long - SSMA_TimeStamp: Binary

StypeQuestionnaireResultLookup

Primary Key: Style

Fields: - Style Questionnaire Result ID: Long - Style Questionnaire Result: Text - Style Questionnaire Min: Double - Style Questionnaire Max: Double - SSMA_TimeStamp: Binary

Sub Products

Primary Key: Sub

Fields: - Sub Product ID: Long - Sub Product: Text - BBBEE Pillar: Text - Frequency: Text - Active: Boolean - SSMA_TimeStamp: Binary

Table1

Primary Key: ID

Fields: - ID: Long (PK)

Teams Targets

Primary Key: ID

Fields: - ID: Long (PK) - Team Target 1: Text - Team Target 2: Text - Team Target 3: Text - Team Target 4: Text - Team Target 5: Text - Team Target 6: Text

Temp Entrepreneur Steps

Primary Key: Record

Fields: - Record ID: Long - OwnedBy: Text - Entrepreneur ID: Long - Entrepreneur Company ID: Long - Pipeline ID: Long - Reactivated: Boolean - Steps Skipped: Boolean - Date Record Created: DateTime - Step 0 Last Date: DateTime - Step 1 Last Date: DateTime - Step 2 Last Date: DateTime - Step 3 Last Date: DateTime - Step 4 Last Date: DateTime - Step 5 Last Date: DateTime - Step 6 Last Date: DateTime - Step 7 Last Date: DateTime - Step 8 First Date: DateTime - Step 8 Last Date: DateTime

Temp Lead Type for Lead Report

Primary Key: Not defined

Fields: - Lead Type ID: Long

Temp Principal Project for Lead Report

Primary Key: Not defined

Fields: - Principal Project ID: Long

Temp Purple Meeting Status

Primary Key: Record

Fields: - Record ID: Long - Recommended Principal Project ID: Long - Step 2: Long - Step 3: Long - Step 4: Long - Step 5: Long - Step 6: Long - Step 7: Long - Step 8 (Ready for Allocation): Long - Not Allocated (Companies): Long - Allocated (Companies): Long

TempLeadsReport

Primary Key: ID

Fields: - ID: Long (PK) - Date Record Created: DateTime - Termination Reason: Text - Entrepreneur ID: Long - Personal Audit Score: Long - Personal Audit Results: Text - Urgency Results: Text - Style Questionnaire Score: Long - Style Questionnaire Results: Text - Blue Heart Score Calculated: Long - Digital Comodities: Memo - SharePoint Link: Text - Date Modified: DateTime - DateFrom: DateTime - DateTo: DateTime - Entrepreneurial Assessment Results: Long - Status: Long - SharePoint Status: Text

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

TurnoverCategoriesLookup

Primary Key: Turnover

Fields: - Turnover Category ID: Long - Turnover Category: Text - Active: Boolean - Last Modified By: Text - Date Modified: DateTime - 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

UrgencyResultLookup

Primary Key: Urgency

Fields: - Urgency Result ID: Long - Urgency Result: Text - Urgency Audit Min: Long - Urgency Audit Max: Long

User Levels

Primary Key: Level

Fields: - Level ID: Long - Level: Text (PK) - Level Description: Text

vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport

Primary Key: Not defined

Fields: - Principal Project ID: Long - Entrepreneur Company ID: Long

vwPurpleCountProgressCategoryRMbyPrinProjCriteria

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Date Record Created: DateTime - Lead Source: Text - Company Name: Text - Recommended Principal Project ID: Long - Principal Project ID: Long - Process Status: Text - Company Status: Text - Progress Category: Text - Progress Category Sort: Long - Company Status Sort: Double

vwPurpleCountProgressCategorySLbyPrinProjCriteria

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Date Record Created: DateTime - Lead Source: Text - Company Name: Text - Recommended Principal Project ID: Long - Principal Project ID: Long - Process Status: Text - Company Status: Text - Progress Category: Text - Progress Category Sort: Long - Company Status Sort: Double

vwPurpleEntrepreneurCompanyListPrincipalProjects

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - First Name: Text - Surname: Text - Email Address: Text - Delivery Location: Text - Entrepreneur Company ID: Long - Company Name: Text - Company Status ID: Long - Status: Text - Sort Order: Double - Status Modified By: Text - Date Status Changed: DateTime - OwnedBy: Text - Industry: Text - Product: Text - Recommended Product: Text - Programme Year: Text - Contract Start Date: DateTime - Contract End Date: DateTime - Ignition Date: DateTime - Contract Printed: Boolean - Committment Fee: Double - Ring Fencing: Boolean - Date Contract Signed: DateTime - VA Packs Delivered: DateTime - Principal: Text - Project Name: Text - Recommended Principal: Text - Recommended Project Name: Text

vwPurpleEntrepreneurList

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Company Status ID: Long - Student ID: Text - First Name: Text - Surname: Text - Company Name: Text - Step: Long - Status: Text - Sort Order: Double - Date Status Changed: DateTime - Lead Type: Text - Province: Text - Industry: Text - Division: Text - Delivery Location: Text - OwnedBy: Text - Process Status ID: Long - Date Record Created: DateTime - Date Modified: DateTime - Last Modified By: Text - Principal: Text - Project Name: Text - Process Date: DateTime - Recommended Product: Text - Email Address: Text - Selection Type: Long

vwPurpleEntrepreneurListCompanyCommodity

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Student ID: Text - First Name: Text - Surname: Text - Company Name: Text - Step: Long - Status: Text - Sort Order: Double - Date Status Changed: DateTime - Lead Type: Text - Province: Text - Industry: Text - Delivery Location: Text - OwnedBy: Text - Process Status ID: Long - Date Record Created: DateTime - Date Modified: DateTime - Last Modified By: Text - Principal: Text - Project Name: Text - Process Date: DateTime - Recommended Product: Text - Email Address: Text - Commodity: Text

vwPurpleEntrepreneurListCurrentPrincipalProjects

Primary Key: Not defined

Fields: - Process Status ID: Long - Entrepreneur Company ID: Long - Entrepreneur ID: Long - First Name: Text - Surname: Text - Company Name: Text - Company Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text - Status: Text - Lead Type: Text - Province: Text - Industry: Text - Division: Text - Delivery Location: Text - OwnedBy: Text - Date Record Created: DateTime - Date Modified: DateTime - Last Modified By: Text - Principal: Text - Project Name: Text - Process Date: DateTime - Ring Fencing: Boolean - Recommended Product: Text - Email Address: Text

vwPurpleEntrepreneurListIgnitionDashboard

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Student ID: Text - Entrepreneur Company ID: Long - Entrepreneur Company Programme Years ID: Long - Entrepreneur Company Principal Project ID: Long - Ignition Date: DateTime - First Name: Text - Surname: Text - Company Name: Text - Company Status ID: Long - Status: Text - Date Status Changed: DateTime - Status Modified By: Text - Province: Text - Industry: Text - Delivery Location: Text - OwnedBy: Text - Process Status ID: Long - Date Record Created: DateTime - Principal: Text - Project Name: Text - Process Date: DateTime - Product: Text - Programme Year: Text - Contract Start Date: DateTime - Contract End Date: DateTime - Contract Printed: Boolean - Committment Fee: Double - Ring Fencing: Boolean - Date Contract Signed: DateTime - VA Packs Delivered: DateTime - Email Address: Text

vwPurpleEntrepreneurListPartSponsorship

Primary Key: Not defined

Fields: - Process Status ID: Long - Entrepreneur Company Programme Years ID: Long - Lump Sum Allocation: Boolean - Entrepreneur Company ID: Long - Entrepreneur ID: Long - Company Status ID: Long - OwnedBy: Text - Status: Text - Date Status Changed: DateTime - Delivery Location: Text - Company Name: Text - First Name: Text - Surname: Text - Industry: Text - Total Programme Amount: Double - Principal: Text - Project Name: Text - Recommended Product: Text - Yr: Text

vwPurpleGetBEEAndTaxClearanceAlerts

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Process Status: Text - Company Status: Text - Process Status ID: Long - Company Status ID: Long - Date Record Created: DateTime - Delivery Location ID: Long - Delivery Location: Text - First Name: Text - Surname: Text - Company Name: Text - BEE Certificate Expire Date: DateTime - Tax Clearance Expire Date: DateTime - OwnedBy: Text

vwPurpleGetCurrentContractInfobyCompany

Primary Key: Not defined

Fields: - Entrepreneur Company ID: Long - Entrepreneur Company Programme Years ID: Long - Division ID: Long - Programme Year: Text - Principal Project ID: Long - Project Name: Text - Principal: Text - Product ID: Long - Product: Text - Contract Start Date: DateTime - Contract End Date: DateTime - Total Programme Amount: Double - Allocated Amount: Double - BBBEE Pillar: Text - Date Contract Signed: DateTime - VA Packs Delivered: DateTime

vwPurpleGetEntrepreneursSteps1to7

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Delivery Location ID: Long - Distribution Model: Text - Delivery Location: Text - Selection Type: Long

vwPurpleGetEntrepreneurSteps

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Date Status Changed: DateTime - Step Number: Long

vwPurpleGetEntrepreneurStepsCriteria

Primary Key: Not defined

Fields: - Delivery Location ID: Long - Lead Type ID: Long - Recommended Principal Project ID: Long - OwnedBy: Text - Step Number: Long - Pipeline ID: Long - Entrepreneur ID: Long

vwPurpleGetLastNotebyEntrepreneur

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Note Date: DateTime - Notes: Text

vwPurpleGetMovedLastWeektoActivePPAllocatedExited

Primary Key: Not defined

Fields: - Entrepreneur Company ID: Long - Pipeline ID: Long - Date Status Changed: DateTime - Company Status ID: Long

vwPurpleReportContractnotPrintedorVAPacksnotDelivered

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Principal: Text - Project Name: Text - OwnedBy: Text - Process Status ID: Long - First Name: Text - Surname: Text - Company Name: Text - Company Status ID: Long - Date Contract Signed: DateTime - VA Packs Delivered: DateTime

vwPurpleReportEntrepreneurSummary

Primary Key: Not defined

Fields: - Distribution Model: Text - Delivery Location: Text - Process Step: Text - Step Number: Long - Entrepreneur ID: Long - The Principal Project ID: Long - The Product: Text - Weighted EP: Double - Distribution Model ID: Long

vwPurpleReportPartSponsorship

Primary Key: Not defined

Fields: - Lump Sum Allocation: Boolean - Entrepreneur Company Programme Years ID: Long - Entrepreneur Company ID: Long - Company Status ID: Long - Company Programme Year Status ID: Long - Company Status: Text - Programme Year Status: Text - Date Status Changed: DateTime - Status Modified By: Text - Company Delivery Location ID: Long - Delivery Location: Text - Company Name: Text - Industry: Text - Percentage Black Owned: Double - Percentage Women Black Owned: Double - Brief Description of Business: Memo - Product: Text - Total Programme Amount: Double - Total Selection Fee: Double - Programme Year: Text - Contract End Date: DateTime

vwPurpleReportPartSponsorshipEntrepreneurs

Primary Key: Not defined

Fields: - Process Status ID: Long - Entrepreneur Company ID: Long - First Name: Text - Surname: Text - Principal: Text - Project Name: Text - Profile Created: Boolean - Date of Birth: DateTime - Gender: Text - Location: Text

vwPurpleReportRAG

Primary Key: Not defined

Fields: - Principal Project Pillar ID: Long - Principal Project Status ID: Long - Lump Sum Allocation: Boolean - Principal Project ID: Long - Principal: Text - Project Name: Text - BBBEE Pillar: Text - Brief Date: DateTime - Number of Companies Required: Double - Entrepreneur Delivery Date: DateTime - Amount Sponsored: Double - Total Sponsorship Amt: Double - Number Exited Companies: Long - Unallocated Companies: Long - Number of Replacements Needed: Long - Number Active Allocated Companies: Long

vwPurpleReportRaizcorpPossibilities

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Entrepreneur Company ID: Long - Company Status ID: Long - Process Status ID: Long - Delivery Location ID: Long - Location: Text - Status: Text - Date Status Changed: DateTime - Delivery Location: Text - Company Name: Text - First Name: Text - Surname: Text - Telephone Number: Text - Date of Birth: DateTime - Gender: Text - Email Address: Text - Industry: Text - Brief Description of Business: Memo - Percentage Black Owned: Double - Percentage Women Black Owned: Double - Principal: Text - Project Name: Text - Product: Text - Profile Created: Boolean - Note Date: DateTime - Notes: Text - Product Pgm Yr: Memo - Date Pgm Yr Status Changed: DateTime

vwPurpleReportTerminationAnalysisData

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Entrepreneur Company ID: Long - Date Status Changed: DateTime - Process Status ID: Long - Step Number: Long - Status: Text - History Date Status Changed: DateTime - First Name: Text - Surname: Text - Company Name: Text - Lead Type: Text - Industry: Text - Principal: Text - Project Name: Text - Recommended Product: Text - Termination Reason: Text

vwPurpleReportTerminationAnalysisSuccessfulData

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Entrepreneur Company ID: Long - Date Status Changed: DateTime - Process Status ID: Long - Step Number: Long - Status: Text - First Name: Text - Surname: Text - Company Name: Text - Lead Type: Text - Industry: Text - Principal: Text - Project Name: Text - Recommended Product: Text

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

vwPurpleRptOpalPrincipalProjectSummaryCriteria

Primary Key: Not defined

Fields: - Entrepreneur Company ID: Long - Distribution Model ID: Long - Company Programme Year Status ID: Long - Company Delivery Location ID: Long - Delivery Location: Text - Principal Project ID: Long - Principal: Text - Project Name: Text - Total Programme Amount: Double - Allocated Amount: Double - Contract End Date: DateTime

vwPurpleSubRptAllocationbyPrincipalProject

Primary Key: Not defined

Fields: - Principal Project ID: Long - BBBEE Pillar Description: Text - Company Status ID: Long - Status: Text - Programme Year Status: Text - Ring Fencing: Boolean - Principal: Text - Project Name: Text - Company Name: Text - Replacement Status: Text - BBBEE Pillar: Text - Contract End Date: DateTime - Programme Year: Text - Product: Text - Delivery Location: Text - Allocated Amount: Double - Selection Fee: Double - Amount Sponsored: Double - PPP Principal Project ID: Long

vwPurpleSubRptAllocationReplacedbyPrincipalProject

Primary Key: Not defined

Fields: - BBBEE Pillar Description: Text - Company Status ID: Long - Status: Text - Programme Year Status: Text - Principal: Text - Project Name: Text - Principal Project ID: Long - Company Name: Text - Replacement Status: Text - BBBEE Pillar: Text - Contract End Date: DateTime - Programme Year: Text - Product: Text - Delivery Location: Text - Allocated Amount: Double - Selection Fee: Double - Amount Sponsored: Double

vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs

Primary Key: Not defined

Fields: - Distribution Model: Text - Delivery Location: Text - Company Status ID: Long - Entrepreneur Company ID: Long - Product ID: Long - Recommended Product ID: Long - Product: Text - Recommended Product: Text

vwPurpleSubRptSponsorshipbyPrincipalProject

Primary Key: Not defined

Fields: - Principal Project ID: Long - Entrepreneur Company Extra Sponsor Element ID: Long - Company Name: Text - BBBEE Pillar: Text - Extra Sponsorship Amount: Double - Element Type: Text

vwPurpleSubRptTerminatedMarketingbyPrincipalProject

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Process Status ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject

Primary Key: Not defined

Fields: - Process Status ID: Long - Termination Reason: Text - Entrepreneur ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj

Primary Key: Not defined

Fields: - Process Status ID: Long - Termination Reason: Text - Entrepreneur ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptTerminatedSupplierListbyPrincipalProject

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Process Status ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptUnqualifiedMarketingbyPrincipalProject

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Process Status ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject

Primary Key: Not defined

Fields: - Process Status ID: Long - Unqualified Reason: Text - Entrepreneur ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj

Primary Key: Not defined

Fields: - Process Status ID: Long - Unqualified Reason: Text - Entrepreneur ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject

Primary Key: Not defined

Fields: - Entrepreneur ID: Long - Process Status ID: Long - Recommended Principal Project ID: Long - Principal Project ID: Long - Lead Source: Text

vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar

Primary Key: Not defined

Fields: - Principal Project Pillar ID: Long - Total Rep Billed to Date: Double

vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar

Primary Key: Not defined

Fields: - Principal Project Pillar ID: Long - Total Rep Selection Fee: Double

YearsinBusinessLookup

Primary Key: Years

Fields: - Years in Business ID: Long - Years in Business: Text - Active: Boolean - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary

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 (112)

Module	Type	Lines	Procedures
Form_Add and Edit Areas of Operation	Form	60	3
Form_Add and Edit Assessment Marker	Form	60	3
Form_Add and Edit Business Premises	Form	62	3
Form_Add and Edit Channel Partners	Form	70	3
Form_Add and Edit Contract Type	Form	62	3
Form_Add and Edit Country	Form	20	1
Form_Add and Edit Delivery Location	Form	75	4
Form_Add and Edit Distribution Model	Form	76	3
Form_Add and Edit Division	Form	72	3
Form_Add and Edit Entrepreneur Arize First Meeting	Form	103	8
Form_Add and Edit Entrepreneur Candidate Recommendation	Form	63	4
Form_Add and Edit Entrepreneur Company	Form	54	3
Form_Add and Edit Entrepreneurs	Form	543	23
Form_Add and Edit Lead Format	Form	62	3
Form_Add and Edit Lead Source	Form	62	3
Form_Add and Edit Lead Type	Form	31	3
Form_Add and Edit Personal Audit Result	Form	60	3
Form_Add and Edit Pipeline	Form	160	9
Form_Add and Edit Principal Project Status	Form	40	3
Form_Add and Edit Principal Project	Form	39	3
Form_Add and Edit Principal	Form	29	3
Form_Add and Edit Process Status	Form	20	1
Form_Add and Edit Process Step	Form	75	4
Form_Add and Edit Product	Form	34	3
Form_Add and Edit Progress Category	Form	75	4
Form_Add and Edit Province	Form	66	4
Form_Add and Edit Race	Form	66	4
Form_Add and Edit Source Category	Form	66	4
Form_Add and Edit Source Detail	Form	67	4
Form_Add and Edit Style Questions Weighting	Form	66	4
Form_Add and Edit Termination Reason	Form	67	4
Form_Add and Edit Turnover Category	Form	67	4
Form_Add and Edit Unqualified Reason	Form	67	4
Form_Add and Edit Urgency Result	Form	60	3
Form_Add and Edit User Modules	Form	30	3
Form_Add and Edit Users	Form	85	4
Form_Add and Edit Years in Business	Form	67	4
Form_Add Pipeline Name Dialog	Form	78	2
Form_Alerts List	Form	25	2
Form_Alerts Report Dialog	Form	44	3
Form_Change Password	Form	138	5
Form_Check Duplicates	Form	108	5
Form_Detailed Movement Report Dialog	Form	68	3
Form_Edit Entrepreneur Status	Form	470	8
Form_Edit Second Entrepreneur	Form	359	20
Form_Entrepreneur Active List	Form	254	13
Form_Entrepreneur Company List	Form	160	11
Form_Entrepreneur Digital Selection List	Form	382	16
Form_Entrepreneur Graduating List	Form	263	13
Form_Entrepreneur Ignition List	Form	273	13
Form_Entrepreneur List Report Dialog	Form	1013	10
Form_Entrepreneur List	Form	478	22
Form_Entrepreneur Part Sponsorship List	Form	254	13
Form_Entrepreneur Pipeline List	Form	382	16
Form_Entrepreneur Purple List	Form	101	6
Form_Entrepreneur Raizcorpossibles List	Form	253	13
Form_Entrepreneur Summary Report Dialog	Form	55	4
Form_Import Entrepreneur Dialog	Form	1626	18
Form_Lead Detail Report Date Dialog	Form	298	4
Form_Lead Report Date Dialog	Form	141	3
Form_Lead Type List	Form	92	6
Form_Lead Type Principal Project Report Dialog	Form	45	3
Form_Maintenance Menu	Form	158	35
Form_Marketing Lead Report Date Dialog	Form	106	3
Form_Opening Dialog	Form	112	4
Form_Pipeline Movement Report Dialog	Form	50	2
Form_Principal List	Form	104	9
Form_Principal Project Report Dialog	Form	46	3
Form_Principal Project Status Report Dialog	Form	45	3
Form_Principal Report Date Dialog	Form	79	4
Form_Product List	Form	99	6
Form_Recommended Principal Report Dialog	Form	53	3
Form_Report Menu	Form	489	68
Form_Report Writer Dialog Sales	Form	289	6
Form_Report Writer Dialog	Form	368	7
Form_Reports Date Dialog	Form	60	2
Form_Reports Date Distribution Model Dialog	Form	49	2
Form_Reports Print Digital Process Single Date Dialog	Form	49	2
Form_Reports Print Export Date Dialog	Form	55	2
Form_Reports Print Export Dialog	Form	42	2
Form_Reports Print Export Single Date Dialog	Form	49	2
Form_Reports Single Date Dialog	Form	45	2
Form_Reports Single Date Division Dialog	Form	51	2
Form_Selection Team Targets Report Dialog	Form	632	6
Form_Selection Team Time Report Dialog	Form	62	3
Form_Step Movement Report Dialog	Form	147	5
Form_User List	Form	164	14
Form_View Entrepreneur Digital First Meeting	Form	31	3
Form_View Entrepreneur Digital Style Questionnaire	Form	31	3
Form_View Entrepreneur Edit History	Form	20	1
Form_Workshop Attendance Register Report Dialog	Form	50	3
Form_SubFrm Entrepreneur Company Areas of Operation	Form	41	2
Form_SubFrm Entrepreneur Company Commodities	Form	41	2
Form_SubFrm Entrepreneur Company Ignition Dates Display Only	Form	54	2
Form_SubFrm Entrepreneur Company Non Participant Shareholders	Form	20	1
Form_SubFrm Entrepreneur Company	Form	24	1
Form_SubFrm Entrepreneur First Meeting Date	Form	41	2
Form_SubFrm Entrepreneur Notes	Form	41	2
Form_SubFrm Entrepreneur Profile Presented To	Form	45	3
Form_SubFrm Entrepreneur Purple Panelists	Form	41	2
Form_SubFrm Principal Project Pillar Sponsor Elements	Form	32	4
Form_SubFrm Principal Project Pillar Sub Products	Form	24	2
Form_SubFrm Principal Project Pillars	Form	50	2
Form_SubFrm Product Distribution Models	Form	20	1
Form_SubFrm Product Divisions	Form	20	1
basRelink	Standard	604	5
ExportModule	Standard	341	12
Global	Standard	100	4
Mod Export Excel	Standard	5438	29
Mod Populate Temp Table	Standard	341	5
Mod Utilities	Standard	282	11
Module1	Standard	1	0

Forms (117)

Form	Record Source	Controls	Has Code
Add and Edit Areas of Operation	AreasofOperationLookup	11	Yes
Add and Edit Assessment Marker	AssessmentMarkerLookup	13	Yes
Add and Edit Business Premises	BusinessPremisesLookup	11	Yes
Add and Edit Channel Partners	Channel Partners	13	Yes
Add and Edit Contract Type	ContractTypeLookup	11	Yes
Add and Edit Country	CountryLookup	14	Yes
Add and Edit Delivery Location	Delivery Locations	27	Yes
Add and Edit Distribution Model	Distribution Models	15	Yes
Add and Edit Division	Divisions	13	Yes
Add and Edit Entrepreneur Arize First Meeting	Entrepreneur Arize First Meeting	325	Yes
Add and Edit Entrepreneur Candidate Recommendation	Entrepreneur Arize First Meeting Candidate Recommendations	15	Yes
Add and Edit Entrepreneur Company	Entrepreneur Company	121	Yes
Add and Edit Entrepreneurs	Entrepreneurs	279	Yes
Add and Edit Lead Format	LeadFormatLookup	11	Yes
Add and Edit Lead Source	LeadSourceLookup	11	Yes
Add and Edit Lead Type	Lead Types	28	Yes
Add and Edit Personal Audit Result	PersonalAuditResultLookup	11	Yes
Add and Edit Pipeline	Pipelines	25	Yes
Add and Edit Principal Project Status	PrincipalProjectStatus	18	Yes
Add and Edit Principal Project	Principal Projects	55	Yes
Add and Edit Principal	Principals	34	Yes
Add and Edit Process Status	ProcessStatus	21	Yes
Add and Edit Process Step	ProcessStep	18	Yes
Add and Edit Product	Products	24	Yes
Add and Edit Progress Category	ProgressCategory	17	Yes
Add and Edit Province	ProvinceLookup	19	Yes
Add and Edit Race	RaceLookup	17	Yes
Add and Edit Source Category	SourceCategoryLookup	17	Yes
Add and Edit Source Detail	SourceDetailLookup	17	Yes
Add and Edit Style Questions Weighting	Style Questions and Weighting	16	Yes
Add and Edit Termination Reason	TerminationReason	19	Yes
Add and Edit Turnover Category	TurnoverCategoriesLookup	17	Yes
Add and Edit Unqualified Reason	UnqualifiedReason	19	Yes
Add and Edit Urgency Result	UrgencyResultLookup	11	Yes
Add and Edit User Modules	DatabaseUsers Module Permissions	12	Yes
Add and Edit Users	DatabaseUsers	26	Yes
Add and Edit Years in Business	YearsinBusinessLookup	17	Yes
Add Pipeline Name Dialog	Unbound	6	Yes
Alerts List	Unbound	10	Yes
Alerts Report Dialog	Unbound	6	Yes
Change Password	Unbound	19	Yes
Check Duplicates	Unbound	11	Yes
Detailed Movement Report Dialog	Unbound	19	Yes
Edit Entrepreneur Status	Unbound	15	Yes
Edit Second Entrepreneur	Entrepreneurs	213	Yes
Entrepreneur Active List	DatabaseUsers	38	Yes
Entrepreneur Company List	Unbound	14	Yes
Entrepreneur Digital Selection List	DatabaseUsers	45	Yes
Entrepreneur Graduating List	DatabaseUsers	38	Yes
Entrepreneur Ignition List	DatabaseUsers	39	Yes
Entrepreneur List Report Dialog	Unbound	7	Yes
Entrepreneur List	DatabaseUsers	52	Yes
Entrepreneur Part Sponsorship List	DatabaseUsers	38	Yes
Entrepreneur Pipeline List	DatabaseUsers	45	Yes
Entrepreneur Purple List	DatabaseUsers	30	Yes
Entrepreneur Raizcorpossibles List	DatabaseUsers	38	Yes
Entrepreneur Summary Report Dialog	Unbound	11	Yes
Import Entrepreneur Dialog	Unbound	9	Yes
Lead Detail Report Date Dialog	Unbound	23	Yes
Lead Report Date Dialog	Unbound	27	Yes
Lead Type List	Unbound	11	Yes
Lead Type Principal Project Report Dialog	Unbound	7	Yes
Maintenance Menu	Unbound	34	Yes
Marketing Lead Report Date Dialog	Unbound	14	Yes
Opening Dialog	Unbound	13	Yes
Pipeline Movement Report Dialog	Unbound	14	Yes
Principal List	Unbound	13	Yes
Principal Project Report Dialog	Unbound	7	Yes
Principal Project Status Report Dialog	Unbound	7	Yes
Principal Report Date Dialog	Unbound	10	Yes
Product List	Unbound	16	Yes
Recommended Principal Report Dialog	Unbound	11	Yes
Report Menu	Unbound	66	Yes
Report Writer Dialog Sales	Unbound	22	Yes
Report Writer Dialog	Unbound	22	Yes
Reports Date Dialog	Unbound	6	Yes
Reports Date Distribution Model Dialog	Unbound	8	Yes
Reports Print Digital Process Single Date Dialog	Unbound	12	Yes
Reports Print Export Date Dialog	Unbound	10	Yes
Reports Print Export Dialog	Unbound	7	Yes
Reports Print Export Single Date Dialog	Unbound	9	Yes
Reports Single Date Dialog	Unbound	6	Yes
Reports Single Date Division Dialog	Unbound	9	Yes
Selection Team Targets Report Dialog	Unbound	10	Yes
Selection Team Time Report Dialog	Unbound	12	Yes
Step Movement Report Dialog	Unbound	18	Yes
User List	Unbound	19	Yes
View Entrepreneur Digital First Meeting	Qry View Entrepreneur Digital First Meeting	64	Yes
View Entrepreneur Digital Style Questionnaire	Entrepreneur Style Questionnaire	102	Yes
View Entrepreneur Edit History	Entrepreneurs	5	Yes
Workshop Attendance Register Report Dialog	Unbound	9	Yes
SubFrm Entrepreneur Company Allocation	Entrepreneur Company	9	No
SubFrm Entrepreneur Company Areas of Operation	Entrepreneur Company Areas of Operation	7	Yes
SubFrm Entrepreneur Company Commodities	Entrepreneur Company Commodities	7	Yes
SubFrm Entrepreneur Company Ignition Dates Display Only	Entrepreneur Company Programme Years	14	Yes
SubFrm Entrepreneur Company Non Participant Shareholders	Entrepreneur Company Non Participant Shareholders	14	Yes
SubFrm Entrepreneur Company Premises	Entrepreneur Company	70	No
SubFrm Entrepreneur Company Principal Projects Display Only	Entrepreneur Company Principal Projects	11	No
SubFrm Entrepreneur Company Programme Years Display Only	Entrepreneur Company Programme Years	32	No
SubFrm Entrepreneur Company Supporting Documents	Entrepreneur Company	29	No
SubFrm Entrepreneur Company	Entrepreneur Company	50	Yes
SubFrm Entrepreneur Edit History	Entrepreneur Edit History	8	No
SubFrm Entrepreneur First Meeting Date	Entrepreneur Arize First Meeting	7	Yes
SubFrm Entrepreneur Notes	Entrepreneur Notes	9	Yes
SubFrm Entrepreneur Profile Presented To	Entrepreneur Profile Presented To	15	Yes
SubFrm Entrepreneur Purple Panelists	Entrepreneur Purple Panelists	10	Yes
SubFrm Entrepreneur Status History	Entrepreneur Status History	12	No
SubFrm Principal Project Pillar Commodities	Principal Project Pillar Commodities	6	No
SubFrm Principal Project Pillar Delivery Location	Principal Project Pillar Delivery Location	6	No
SubFrm Principal Project Pillar Sourced From	Principal Project Pillar Sourced From	6	No
SubFrm Principal Project Pillar Sponsor Elements	Principal Project Pillar Sponsor Elements	22	Yes
SubFrm Principal Project Pillar Sub Products	Principal Project Pillar Sub Products	14	Yes
SubFrm Principal Project Pillar Supporting Documents	Qry SubFrm Principal Project Pillar Supporting Documents	5	No
SubFrm Principal Project Pillars	Principal Project Pillars	35	Yes
SubFrm Principal Project Products Sold	Principal Project Products Sold	6	No
SubFrm Product Distribution Models	Product Distribution Models	7	Yes
SubFrm Product Divisions	Product Divisions	9	Yes

Reports (162)

Report	Record Source	Sections
Calibri	TempLeadReports	2
Calibri	Unbound	2
Calibri	Qry Get BEE and Tax Clearance Alerts	2
Calibri	Qry Report Arize First Meeting	2
Calibri	Qry Report Average Days Per Step	2
Calibri	Qry Report Avg Time Through Pipeline by Delivery Loc	2
Calibri	Qry Get BEE and Tax Clearance Alerts	2
Calibri	Qry Report Blank Owned By	2
Calibri	Qry Report Contract End Date Expire	2
Calibri	Qry Report Contract not Printed or VA Packs not Delivered	2
Calibri	Qry Report Current Pipeline EP Detail by Principal Project	2
Calibri	Unbound	2
Calibri	Qry Report Days in Pipeline Detail	2
Calibri	Qry Report Detailed Movement by Date Range	2
Calibri	Qry Report Detailed Movement by Owned By	2
Calibri	Qry Report Detailed Movement by Principal Project	2
Calibri	Qry Report Detailed Movement by Recommended Principal Project	2
Calibri	Qry Report Detailed Movement Pipeline by Date Range	2
Calibri	Qry Entrepreneur List Part Sponsorship	2
Calibri	Qry Report Entrepreneur List Principal Projects	2
Calibri	Qry Entrepreneur List Purple Meeting	2
Calibri	Qry Report Entrepreneur List	2
Calibri	Qry Report Entrepreneur Summary by Distribution Model	2
Calibri	Qry Report Entrepreneur Summary by Principal Project	2
Calibri	Unbound	2
Calibri	Qry Report Entrepreneurial Profiles	2
Calibri	Qry Report Entrepreneurs by Lead Type	2
Calibri	Qry Report Entrepreneurs Modified by Date Range	2
Calibri	Qry Report EOI Entrepreneur	2
Calibri	Unbound	2
Calibri	Unbound	2
Calibri	Qry Report Lead Daily Breakdown	2
Calibri	Unbound	2
Calibri	Qry Report Marketing Leads Version Two	2
Calibri	Qry Report Marketing Leads	2
Calibri	Qry Report More Than 3 Follow Ups	2
Calibri	Qry Report P3 Graduates Not Active Exited 5 Months Ago	2
Calibri	Qry Report Panel Passes per Scout	2
Calibri	Unbound	2
Calibri	Qry Report Pipeline List	2
Calibri	Unbound	2
Calibri	Qry Report Principal Project Allocation by Entrepreneur	2
Calibri	Qry Report Principal Project Information	2
Calibri	Unbound	2
Calibri	Qry Report Process Status All Lead Types	2
Calibri	Qry Report Process Status by Delivery Location	2
Calibri	Qry Report Process Status by Lead Type	2
Calibri	Qry Report Process Status by Principal Project	2
Calibri	Unbound	2
Calibri	Qry Report Purple Panelists Summary	2
Calibri	Qry Report Recommended Principal Project Allocation	2
Calibri	Qry Report Selection Daily Team Activity by Delivery Location	2
Calibri	Qry Report Selection Daily Team Activity	2
Calibri	Qry Report Selection Team Activity Summary	2
Calibri	Qry Report Selection Team Activity Times by Delivery Location	2
Calibri	Qry Report Selection Team Activity Times by Modified By	2
Calibri	Qry Report Selection Team Call Activity	2
Calibri	Qry Report Step Movement	2
Calibri	Qry Report Step Movement	2
Calibri	Qry Report Step Movement	2
Calibri	Qry Report Step Movement	2
Calibri	Qry Report Steps Skipped Error Report	2
Calibri	Qry Report User Permissions	2
Calibri	Qry Report VA Packs Required in Four Weeks	2
Calibri	Qry Report VA Packs Required in Two Weeks	2
Calibri	Qry SubRpt Allocation by Principal Project	2
Calibri	Qry SubRpt Allocation Replaced by Principal Project	2
Calibri	Qry Report Arize First Meeting	2
Calibri	Qry Report Arize First Meeting	2
Calibri	Qry Report Arize First Meeting	2
Calibri	Qry Report Arize First Meeting	2
Calibri	Qry SubRpt BEE Certificate Blank	0
Calibri	Qry SubRpt Company Principal Project by Programme Year	0
Calibri	Qry SubRpt Count Records Created by Del Loc	0
Calibri	Qry SubRpt Count Records Created	0
Calibri	Qry SubRpt Count Step 1 Status by Del Loc	0
Calibri	Qry SubRpt Count Step 1 Status	0
Calibri	Qry SubRpt Daily Lead Summary Delivery RC Poss All Divs	0
Calibri	Qry SubRpt Daily Lead Summary Follow Up All Divisions	0
Calibri	Qry SubRpt Daily Lead Summary Follow Up One Division	0
Calibri	Qry SubRpt Daily Lead Summary Leads Less Than 48 Hours All Divs	0
Calibri	Qry SubRpt Daily Lead Summary Leads More Than 48 Hours All Divs	0
Calibri	Qry SubRpt Daily Lead Summary New Leads All Divisions	0
Calibri	Qry SubRpt Daily Lead Summary New Leads by Lead Type All Divs	0
Calibri	Qry SubRpt Daily Lead Summary New Leads by Lead Type One Div	0
Calibri	Qry SubRpt Daily Lead Summary New Leads One Division	0
Calibri	Qry SubRpt Daily Lead Summary Pipeline All Divisions	0
Calibri	Qry SubRpt Daily Lead Summary Pipeline One Division	0
Calibri	Qry SubRpt Daily Lead Summary Raizcorp Possibles All Divs	0
Calibri	Qry SubRpt Daily Lead Summary Uncontacted All Divisions	0
Calibri	Qry SubRpt Daily Lead Summary Uncontacted One Division	0
Calibri	Qry SubRpt Daily Lead Summary Uncontacted PnP All Divisions	0
Calibri	Qry SubRpt Daily Lead Summary Uncontacted PnP One Division	0
Calibri	Entrepreneur Company Commodities	0
Calibri	Qry SubRpt Entrepreneur Edit History	0
Calibri	Qry SubRpt Entrepreneur Edit Status History	0
Calibri	Qry SubRpt Entrepreneur Edit Status History	0
Calibri	Qry SubRpt Entrepreneur Edit Status History	0
Calibri	Qry SubRpt Entrepreneur Edit Status History	0
Calibri	Entrepreneur Notes	0
Calibri	Qry SubRpt Entrepreneurial Assessment Results List	0
Calibri	Qry SubRpt Entrepreneurial Assessment Results	0
Calibri	Qry SubRpt Entrepreneurial Assessment Retake Results List	0
Calibri	Qry SubRpt Entrepreneurial Assessment Retake Results	0
Calibri	Entrepreneur Company Areas of Operation	0
Calibri	Entrepreneur Company Commodities	0
Calibri	Qry SubRpt EOI Entrepreneur Company	0
Calibri	Entrepreneur Purple Panelists	0
Calibri	Qry SubRpt Exec Lead Summary Headhunted Single Date All Divs	0
Calibri	Qry SubRpt Exec Lead Summary Headhunted Single Date One Div	0
Calibri	Qry SubRpt Lead Delivery Location All Lead Types	0
Calibri	Qry SubRpt Lead Delivery Location by Lead Type	0
Calibri	Qry SubRpt Lead Delivery Location by Principal Project	0
Calibri	Qry SubRpt Lead Process Status All Lead Types	0
Calibri	Qry SubRpt Lead Process Status by Delivery Location	0
Calibri	Qry SubRpt Lead Process Status by Lead Type	0
Calibri	Qry SubRpt Lead Process Status by Principal Project	0
Calibri	Qry SubRpt Lead Summary Headhunted Date Range	0
Calibri	Qry SubRpt Lead Summary Referred to Prosperator Date Range	0
Calibri	Qry SubRpt Lead Unqualified All Lead Types	0
Calibri	Qry SubRpt Lead Unqualified by Delivery Location	0
Calibri	Qry SubRpt Lead Unqualified by Lead Type	0
Calibri	Qry SubRpt Lead Unqualified by Principal Project	0
Calibri	Qry SubRpt Lead Unqualified Reason All Lead Types	0
Calibri	Qry SubRpt Lead Unqualified Reason by Delivery Location	0
Calibri	Qry SubRpt Lead Unqualified Reason by Lead Type	0
Calibri	Qry SubRpt Lead Unqualified Reason by Principal Project	0
Calibri	Qry Report Percentage Moved Last Week Digital	2
Calibri	Qry Report Percentage Moved Last Week Manual	2
Calibri	Qry SubRpt Pipeline Process Status All Lead Types	0
Calibri	Qry SubRpt Pipeline Process Status by Delivery Location	0
Calibri	Qry SubRpt Pipeline Process Status by Lead Type	0
Calibri	Qry SubRpt Pipeline Process Status by Principal Project	0
Calibri	Principal Report Stage Information	0
Calibri	Qry SubRpt Pipeline Terminated All Lead Types	0
Calibri	Qry SubRpt Pipeline Terminated by Delivery Location	0
Calibri	Qry SubRpt Pipeline Terminated by Lead Type	0
Calibri	Qry SubRpt Pipeline Terminated by Principal Project	0
Calibri	Qry SubRpt Pipeline Termination Reason All Lead Types	0
Calibri	Qry SubRpt Pipeline Termination Reason by Delivery Location	0
Calibri	Qry SubRpt Pipeline Termination Reason by Lead Type	0
Calibri	Qry SubRpt Pipeline Termination Reason by Principal Project	0
Calibri	Qry SubRpt Principal Project Allocation Audit Replaced Companies	0
Calibri	Qry SubRpt Principal Project Pillar Delivery Locations	0
Calibri	Principal Project Pillar Sourced From	0
Calibri	Principal Project Pillars	0
Calibri	Qry SubRpt Principal Project Pillars	0
Calibri	Qry SubRpt Products Sold by Principal Project	0
Calibri	Qry SubRpt Progress Category Mktg by Principal Project	0
Calibri	Qry SubRpt Progress Category Sup List by Principal Project	0
Calibri	Qry SubRpt Purple Panel Results List Date Range	0
Calibri	Qry SubRpt Purple Panel Results Date Range	0
Calibri	Principal Project Pillars	0
Calibri	Qry SubRpt Sponsorship Elements by Principal Project	2
Calibri	Qry SubRpt Termination Marketing by Principal Project	0
Calibri	Qry SubRpt Termination Reasons Marketing by Principal Project	0
Calibri	Qry SubRpt Termination Reasons Supplier Lst by Principal Project	0
Calibri	Qry SubRpt Termination Supplier List by Principal Project	0
Calibri	Qry SubRpt Unqualified Marketing by Principal Project	0
Calibri	Qry SubRpt Unqualified Reasons Marketing by Principal Project	0
Calibri	Qry SubRpt Unqualified Reasons Supplier Lst by Principal Project	0
Calibri	Qry SubRpt Unqualified Supplier List by Principal Project	0

Queries (447)

Query	Type	Tables
Find duplicates for Engage UUID	Select	Engage UUID, Engage
Find duplicates for Entrepreneurs	Select	Entrepreneurs
Find duplicates for Qry Report Termination Analysis Data	Select	Qry, Qry Report Termination Analysis Data
JB Digital Process Status	Select	ProcessStatus
JB Entrepreneurs With No Pipeline	Select	ProcessStatus, Entrepreneurs
JB Qry Example of Report	Select	ProcessStatus, Entrepreneurs
JB Qry Initialise UUID	Delete	Entrepreneurs
JB Qry Not Digital Pipeline	Select	Entrepreneur Status History, ProcessStatus
JB Qry Raizcorpossibles with terminated or unqualified EPs	Select	CompanyStatus, Entrepreneur Company
JB Reactivated EPs	Select	Entrepreneur Status History, ProcessStatus
JB SubQry Get Ready For Allocation without History	Select	Entrepreneur Status History, Entrepreneur
JB Update Date Status Changed Unallocated	Update	Entrepreneur, Entrepreneur Company
JB Update DO NOT USE IN DIGITAL	Update	Lead Types, Lead
JBQry Current Raizcorp Possibles by Delivery Location	Select	Qry Get Division Dist Model Del Loc and Rec Info by Company, Entrepreneur Company
Jo Qry Uncontacted Followup Ready for Allocation	Select	Entrepreneurs, Jo Qry Uncontacted Unfollow Reeady for Allocation
Qry Application Versions	Select
Qry Calculate Percent Headhunted Qualified by OwnedBy Date Range	Select	Qry, Qry Count Headhunted Qualified by OwnedBy Date Range
Qry Count Active Allocated Companies by Principal Project Pillar	Select	Entrepreneur, Entrepreneur Company
Qry Count Companies by PP Pillar Principal Report	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Companies by Principal Project Principal Report	Select	vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport
Qry Count Current Active Allocated Companies On Pgm by Prin Proj	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Current Active Companies by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Current Active Companies Total	Select	SubQry, SubQry Count Current Active Companies Total
Qry Count Current Active Entrepreneurs by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Current Active Entrepreneurs Total	Select	SubQry, SubQry Count Current Active Entrepreneurs Total
Qry Count Current Entrepreneurs Allocated for Purple	Select	Entrepreneur Company, Entrepreneurs
Qry Count Current Entrepreneurs by Step for Purple	Select	ProcessStatus, Entrepreneurs
Qry Count Current Exited Companies by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Current Exited Entrepreneurs by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Current Part Sponsorship by Delivery Location And Type	Select	Delivery, Qry Report Part Sponsorship
Qry Count Current Part Sponsorship by Delivery Location	Select	Delivery, Qry Report Part Sponsorship
Qry Count Current Raizcorp Possibles by Delivery Location	Select	Qry Get Division Dist Model Del Loc and Rec Info by Company, Entrepreneur Company
Qry Count Delivery Locations Allowed by Principal Project	Select	Qry Get Delivery Locations Allowed by Principal Project, Qry
Qry Count Entrepreneur Moved Last Week Digital Process	Select	SubQry Get Entrepreneur Moved Last Week, SubQry
Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca	Select	SubQry Get Entrepreneur Moved Last Week, SubQry
Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location	Select	SubQry Get Entrepreneur Moved Last Week, SubQry
Qry Count Entrepreneur Moved Last Week Manual Process	Select	SubQry Get Entrepreneur Moved Last Week, SubQry
Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location	Select	vwPurpleGetEntrepreneursSteps1to7
Qry Count Entrepreneur Steps 1 to 7 Digital Process	Select	vwPurpleGetEntrepreneursSteps1to7
Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location	Select	vwPurpleGetEntrepreneursSteps1to7
Qry Count Entrepreneur Steps 1 to 7 Manual Process	Select	vwPurpleGetEntrepreneursSteps1to7
Qry Count Entrepreneurial Assessment Results	Select	Entrepreneurs
Qry Count Entrepreneurial Assessment Retake Results	Select	Entrepreneurs
Qry Count Entrepreneurs by Company for Projile	Select	Entrepreneur, Entrepreneur Company
Qry Count Entrepreneurs by PP Pillar Principal Report	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Entrepreneurs by Principal Project Principal Report	Select	SubQry Count Entrepreneurs by Principal Project Principal Report, SubQry
Qry Count Entrepreneurs Pipeline Phase 1 by Delivery Location	Select	ProcessStep, ProcessStatus
Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location	Select	ProcessStep, ProcessStatus
Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location	Select	ProcessStep, ProcessStatus
Qry Count Entreprenur Steps Total at 1 and 2	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 1 and 3	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 1 and 4	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 1 and 7	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 1 and 8	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 1	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 2	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 3	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 4	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 7	Select	Temp Entrepreneur Steps, Temp
Qry Count Entreprenur Steps Total at 8	Select	Temp Entrepreneur Steps, Temp
Qry Count Exited Companies by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Exited Need Replacement by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Count Headhunted by OwnedBy Date Range	Select	SubQry, SubQry Count Headhunted by OwnedBy Date Range Criteria
Qry Count Headhunted Qualified by OwnedBy Date Range	Select	SubQry, SubQry Count Headhunted by OwnedBy Date Range Criteria
Qry Count Purple Panel Results Date Range	Select	Entrepreneurs
Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc	Select	Temp Entrepreneur Steps, Entrepreneur Company
Qry Count Total Assessments Passed by Scout	Select	SubQry, SubQry Rpt Assessment Panel Passes per Scout
Qry Count Total Assessments Taken by Scout	Select	SubQry, SubQry Rpt Assessment Panel Passes per Scout
Qry Count Total Panels Held by Scout	Select	SubQry, SubQry Rpt Assessment Panel Passes per Scout
Qry Count Total Panels Passed by Scout	Select	SubQry, SubQry Rpt Assessment Panel Passes per Scout
Qry Count Unallocated Companies by EP Delivery Location	Select	Entrepreneur, Entrepreneur Company
Qry Count Unallocated Companies by Principal Project Recommended	Select	Qry, Entrepreneur Company
Qry Digital Stats Report	Select
Qry Duplicate Entrepreneurs	Select	SubQry Duplicate Entrepreneurs Alt, Lead Types
Qry Entrepreneur Company List Principal Projects	Select	vwPurpleEntrepreneurCompanyListPrincipalProjects
Qry Entrepreneur Company List	Select	Entrepreneur, Entrepreneur Company
Qry Entrepreneur Digital Selection List	Select	vwPurpleEntrepreneurList
Qry Entrepreneur List Company Commodity	Select	vwPurpleEntrepreneurListCompanyCommodity
Qry Entrepreneur List Current Principal Projects	Select	vwPurpleEntrepreneurListCurrentPrincipalProjects, vwPurpleGetCurrentContractInfobyCompany
Qry Entrepreneur List Ignition Dashboard	Select	vwPurpleEntrepreneurListIgnitionDashboard
Qry Entrepreneur List Part Sponsorship	Select	vwPurpleEntrepreneurListPartSponsorship, Qry
Qry Entrepreneur List Purple Meeting	Select	Principal Projects, Temp
Qry Entrepreneur List	Select	vwPurpleEntrepreneurList
Qry Entrepreneurs in a Company List	Select	Entrepreneurs
Qry Export Blue Eagle Entrepreneurs	Select	Entrepreneurs
Qry Export Daily Lead Summary Leads Less Than 48 Hours	Select	Lead Types, Entrepreneur Company
Qry Export Daily Lead Summary Leads More Than 48 Hours	Select	Lead Types, Entrepreneur Company
Qry Export Entrepreneurs All Lead Types	Select	Lead Types, Entrepreneur Company
Qry Export Entrepreneurs by Lead Type	Select	Lead Types, Temp Lead Type for Lead Report
Qry Export Temp Entrepreneur Steps	Select
Qry Get BEE and Tax Clearance Alerts	Select	vwPurpleGetBEEAndTaxClearanceAlerts
Qry Get Current Contract Info by Company	Select	Qry, Qry Sum Total Allocated Amt by Company
Qry Get Del Loc Raizcorpossibles Part Sponsorship	Select
Qry Get Delivery Locations Allowed by Principal Project	Select	Principal Project Pillars, Principal
Qry Get Delivery Locations Quartz Lead Phase Report	Select
Qry Get Division Dist Model and Rec Info by Company	Select	Entrepreneurs
Qry Get Division Dist Model Del Loc and Rec Info by Company	Select	Entrepreneurs
Qry Get Entrepreneur Info for Projile Merge	Select	Entrepreneurs
Qry Get Entrepreneur Recommended Information	Select	Lead Types, Principal Projects
Qry Get Entrepreneur Steps by Delivery Location	Select	vwPurpleGetEntrepreneurSteps, SubQry
Qry Get Entrepreneur Steps by Lead Type	Select	vwPurpleGetEntrepreneurSteps, SubQry
Qry Get Entrepreneur Steps by Owned By	Select	vwPurpleGetEntrepreneurSteps, SubQry
Qry Get Entrepreneur Steps by Recommended Principal Project	Select	vwPurpleGetEntrepreneurSteps, SubQry
Qry Get Entrepreneur Steps Date Range	Select	Entrepreneur Status History, SubQry Get Entrepreneur Steps Date Range Criteria
Qry Get Entrepreneur Steps For Summary	Select	SubQry, SubQry Get Entrepreneur Steps For Summary Criteria
Qry Get Entrepreneurs Modified Pipeline 1 Prin Proj Date Range	Select	Entrepreneur Status History, ProcessStatus
Qry Get Entrepreneurs Modified Pipeline Date Range	Select	Entrepreneur Status History, SubQry Get Entrepreneurs Modified Pipeline Date Range Crit
Qry Get Entrepreneurs Modified Pipeline Last 6 Months	Select	Entrepreneur Status History, SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit
Qry Get Entrepreneurs Reactivated for Summary	Select	SubQry, SubQry Get Entrepreneur Steps For Summary Criteria
Qry Get Entrepreneurs Steps Modified by Owned By Date Range	Select	Entrepreneur Status History, SubQry
Qry Get Last Note by Entrepreneur	Select	Entrepreneur Notes, Qry Get Last Note Date by Entrepreneur
Qry Get Last Note Date by Entrepreneur	Select	Entrepreneur Notes, Entrepreneur
Qry Get Last Programme Year ID by Company	Select	Entrepreneur, Entrepreneur Company Programme Years
Qry Get Last Programme Year Info by Company	Select	NonGraduateReason, Products
Qry Get Lead Types for Passed Panel Entrepreneurs	Select	Lead Types, ProcessStatus
Qry Get Owned By Panels Passed by Scout	Select
Qry Get OwnedBy for Selection Team Target Report	Select	Temp Entrepreneur Steps, Temp
Qry Get Pipeline Steps Between 1 and 8	Select	Pipelines Detail, Pipelines
Qry Get Raizcorp Possibles Moved Last Week	Select	CompanyStatus, SubQry Get Raizcorp Possibles Position
Qry Get Sheet Names for Conpany Profiles	Select	Qry Count Entrepreneurs by Company for Projile, Qry
Qry Lead Type List	Select	Lead Types, Principal Projects
Qry Notifications Sent by Entrpreneur	Select	Entrepreneur, Entrepreneur Notifications Sent
Qry Pipeline Detail List	Select	Pipelines Detail, Pipelines
Qry Possible Date Created	Select	Entrepreneurs
Qry Principal List	Select	Principals
Qry Process Status List Digital Pipelines	Select	Pipelines Detail, Pipelines
Qry Process Status NOT in Pipeline List	Select	SubQry Process Status NOT in Pipeline List, ProcessStatus
Qry Product Distribution Model List	Select	Products, Product Distribution Models
Qry Product Division List	Select	Products, Product Divisions
Qry Product List	Select	Products, Pipelines
Qry Report Active Companies Email	Select	Entrepreneur Company, Entrepreneurs
Qry Report Allocation Export Graduated Companies	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Allocation Export Non Graduate Companies	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Allocation Export On Programme Companies	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Arize First Meeting	Select	Success, Products
Qry Report Average Days Per Step	Select	SubQry, SubQry Rpt Average Days Per Step Sum Days
Qry Report Average Time Through Pipeline by Distribution Model	Select	SubQry, MonthLkUp
Qry Report Avg Time Through Pipeline by Delivery Loc	Select	SubQry, SubQry Rpt Average Time Through Pipeline by Delivery Location
Qry Report Avg Time Through Pipeline Trend by Delivery Location	Select
Qry Report Blank Owned By	Select	Lead Types, Products
Qry Report Blue Heart Email Not Sent	Select	DatabaseUsers, ProcessStatus
Qry Report Company Profile Merge Data	Select	Entrepreneur, Qry Get Entrepreneur Info for Projile Merge
Qry Report Contract End Date Expire	Select	CompanyStatus, Entrepreneur Company
Qry Report Contract not Printed or VA Packs not Delivered	Select	vwPurpleReportContractnotPrintedorVAPacksnotDelivered
Qry Report Current Pipeline EP Detail by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Days in Pipeline Detail	Select
Qry Report Detailed Movement by Date Range	Select	SubQry Rpt Detailed Movement Date Range, Lead Types
Qry Report Detailed Movement by Owned By	Select	Lead Types, Entrepreneur Company
Qry Report Detailed Movement by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Detailed Movement by Recommended Principal Project	Select	SubQry Rpt Detailed Movement Date Range, Lead Types
Qry Report Detailed Movement Pipeline by Date Range	Select	Lead Types, Entrepreneur Company
Qry Report Entrepreneur List Principal Projects	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Entrepreneur List	Select	Lead Types, Principal Projects
Qry Report Entrepreneur Summary by Distribution Model	Select	vwPurpleReportEntrepreneurSummary
Qry Report Entrepreneur Summary by Principal Project	Select	vwPurpleReportEntrepreneurSummary
Qry Report Entrepreneurial Profiles	Select	SubQry Rpt Entrepreneurial Profiles, CompanyStatus
Qry Report Entrepreneurs by Lead Type	Select	Lead Types, Entrepreneur Company
Qry Report Entrepreneurs Invoice Requested	Select	Products, Entrepreneur Company
Qry Report Entrepreneurs Modified by Date Range	Select	Entrepreneur Edit History, Lead Types
Qry Report EOI Entrepreneur	Select	CountryLookup, Entrepreneurs
Qry Report Headhunting by Owned By	Select	SubQry Rpt Headhunting Count Qualified by Owned By, SubQry
Qry Report Lead Daily Breakdown	Select	SubQry Rpt Lead Daily Breakdown Count Total Leads, SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads
Qry Report Lead Type to Principal Allocation	Select	SubQry, SubQry Rpt Lead Type to Principal Allocation Criteria
Qry Report Marketing EOI to Passed Panel	Select	SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel, Lead Types
Qry Report Marketing Leads by Date	Select	SubQry Rpt Count Total Leads Generated by Date, SubQry
Qry Report Marketing Leads Version Two	Select	SubQry Rpt Count Uncontacted Leads, SubQry Rpt Count Unqualified Leads
Qry Report Marketing Leads	Select	SubQry Rpt Count Exited Leads, SubQry Rpt Count Passed Panel Leads
Qry Report Marketing Pre-Unqualified Leads	Select	UnqualifiedReason, Lead Types
Qry Report More Than 3 Follow Ups	Select	SubQry Rpt More Than 3 Follow Ups Count, Lead Types
Qry Report Opal Prin Proj Summary Company Contracts by End Date	Select	SubQry Rpt Opal Principal Project Summary Criteria
Qry Report Opal Prin Proj Summary Weighted Companies	Select	SubQry Rpt Opal Principal Project Summary Criteria, SubQry
Qry Report Opal Prin Proj Summary Weighted EPs and Comp by DL	Select	SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc, SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc
Qry Report Opal Principal Project Companies Required	Select	Qry Get Delivery Locations Allowed by Principal Project, Principal Projects
Qry Report Opal Principal Project Count Comp Req _1 Del Loc	Select	SubQry, SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc
Qry Report Opal Principal Project Sum Comp Req _1 Del Loc	Select	SubQry, SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc
Qry Report Opal Principal Project Sum Comp Required 1 Del Loc	Select	Qry Get Delivery Locations Allowed by Principal Project, Qry Count Delivery Locations Allowed by Principal Project
Qry Report Opal Principal Projects by Industry	Select	Qry Sum Total Sponsorship by Principal Project, Qry Sum Total Spend by Principal Project
Qry Report Opal Raizcorpossibles and Part Sponsorship	Select	Qry Get Del Loc Raizcorpossibles Part Sponsorship, Qry Count Current Part Sponsorship by Delivery Location
Qry Report P3 Graduates Not Active Exited 5 Months Ago	Select	Entrepreneur, CompanyStatus
Qry Report Panel Passes per Scout	Select	Qry Count Total Panels Held by Scout, Qry Count Total Panels Passed by Scout
Qry Report Part Sponsorship Entrepreneurs	Select	vwPurpleReportPartSponsorshipEntrepreneurs
Qry Report Part Sponsorship	Select	SubQry, SubQry Rpt Part Sponsorship
Qry Report Partner Elite Get Status Step 1	Select	Qry Report Partner Elite Pipeline Step 1, Qry
Qry Report Partner Elite Get Steps 2-7	Select	Qry, Qry Report Partner Elite Pipeline Step 2-7
Qry Report Partner Elite Pipeline Get Lead Types	Select
Qry Report Partner Elite Pipeline Step 1	Select	Lead Types, ProcessStatus
Qry Report Partner Elite Pipeline Step 2-7	Select	ProcessStep, Lead Types
Qry Report Partner Elite Pipeline Unqualified or Terminated	Select	Lead Types, ProcessStatus
Qry Report Partner Elite Summary	Select	Qry Get Last Note by Entrepreneur, Entrepreneur Company
Qry Report Percent Dropoff After 1st Meeting	Select	SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2, SubQry
Qry Report Percentage Moved Last Week Digital	Select	Qry Count Entrepreneur Moved Last Week Digital Process, SubQry
Qry Report Percentage Moved Last Week Manual	Select	Qry Count Entrepreneur Steps 1 to 7 Manual Process, Qry Count Entrepreneur Moved Last Week Manual Process
Qry Report Pipeline List	Select	Pipelines Detail, Pipelines
Qry Report Principal Project Allocation by Entrepreneur	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Report Principal Project Information	Select	Client Tiers, PrincipalProjectStatus
Qry Report Process Status All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry Report Process Status by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry Report Process Status by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry Report Process Status by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry Report Purple Panelists Summary	Select	SubQry Rpt Purple Panelists Sum Scores, SubQry Rpt Purple Panelists Summary
Qry Report Quartz Leads by Phase	Select	Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location, Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location
Qry Report RAG	Select	vwPurpleReportRAG, vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar
Qry Report Raizcorp Possibilities	Select	ProcessStatus, vwPurpleReportRaizcorpPossibilities
Qry Report Raizcorpossible Companies Email	Select	Entrepreneur Company, Entrepreneurs
Qry Report Recommended Principal Project Allocation	Select	Principal Projects, Products
Qry Report Selection Daily Team Activity by Delivery Location	Select	SubQry Rpt Count Unqualified by Del Loc, SubQry Rpt Count Meetings by Del Loc
Qry Report Selection Daily Team Activity	Select	SubQry Rpt Count Entrepreneurs With Pipeline Moves, SubQry Rpt Get Owned By
Qry Report Selection Team Activity Summary	Select	SubQry Rpt Selection Team Summary Total Passed Panel, SubQry Rpt Selection Team Summary Total Graduated Off
Qry Report Selection Team Activity Times by Delivery Location	Select	Entrepreneur Status History, ProcessStatus
Qry Report Selection Team Activity Times by Modified By	Select	Entrepreneur Status History, ProcessStatus
Qry Report Selection Team Call Activity	Select	SubQry Rpt Get Modified By, SubQry Rpt Count Unqualified by Modified By
Qry Report Selection Team Targets	Select	Qry Count Entreprenur Steps Total at 8, Qry Count Entreprenur Steps Total at 1 and 4
Qry Report Step Movement	Select
Qry Report Steps Skipped Error Report	Select
Qry Report Termination Analysis Data	Select	vwPurpleReportTerminationAnalysisData
Qry Report Termination Analysis Successful Data	Select	vwPurpleReportTerminationAnalysisSuccessfulData
Qry Report User Permissions	Select	DatabaseUsers, DatabaseUsers Module Permissions
Qry Report VA Packs Required in Four Weeks	Select	Principal Projects, Principals
Qry Report VA Packs Required in Two Weeks	Select	Principal Projects, Principals
Qry Report Workshop Attendance Register	Select	Entrepreneur Company, Entrepreneurs
Qry Report Writer	Select	vwPurpleGetLastNotebyEntrepreneur, Lead Types
QRY Restore Deleted leads	Delete	Restore, Restore Deleted Leads
Qry SubFrm Principal Project Pillar Supporting Documents	Select	Principal Project Pillars, Principal
Qry SubRpt Allocation by Principal Project	Select	vwPurpleSubRptAllocationbyPrincipalProject, Qry Sum Total Replaced Billed to Date by Principal Project
Qry SubRpt Allocation Replaced by Principal Project	Select	Qry Sum Total Spend by Principal Project, Qry
Qry SubRpt BEE Certificate Blank	Select	Product Divisions, CompanyStatus
Qry SubRpt Company Principal Project by Programme Year	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry SubRpt Count Records Created by Del Loc	Select	SubQry Count Records Created Dist Model Criteria, SubQry
Qry SubRpt Count Records Created	Select	SubQry Count Records Created Criteria, SubQry
Qry SubRpt Count Step 1 Status by Del Loc	Select	SubQry, SubQry Count Step 1 Status Dist Model Criteria
Qry SubRpt Count Step 1 Status	Select	SubQry, SubQry Count Step 1 Status Criteria
Qry SubRpt Daily Lead Summary Delivery RC Poss All Divs	Select	Qry Get Division Dist Model and Rec Info by Company, Products
Qry SubRpt Daily Lead Summary Follow Up All Divisions	Select	Entrepreneurs, Distribution Models
Qry SubRpt Daily Lead Summary Follow Up One Division	Select	Entrepreneurs, Distribution Models
Qry SubRpt Daily Lead Summary Leads Less Than 48 Hours All Divs	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary Leads More Than 48 Hours All Divs	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary New Leads All Divisions	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary New Leads by Lead Type All Divs	Select	Lead Types, Entrepreneurs
Qry SubRpt Daily Lead Summary New Leads by Lead Type One Div	Select	Lead Types, Entrepreneurs
Qry SubRpt Daily Lead Summary New Leads One Division	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary Pipeline All Divisions	Select	ProcessStatus, Entrepreneurs
Qry SubRpt Daily Lead Summary Pipeline One Division	Select	ProcessStatus, Entrepreneurs
Qry SubRpt Daily Lead Summary Raizcorp Possibles All Divs	Select	vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs
Qry SubRpt Daily Lead Summary Uncontacted All Divisions	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary Uncontacted One Division	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary Uncontacted PnP All Divisions	Select	Entrepreneurs
Qry SubRpt Daily Lead Summary Uncontacted PnP One Division	Select	Entrepreneurs
Qry SubRpt Entrepreneur Edit History	Select	Entrepreneur Edit History, Entrepreneur
Qry SubRpt Entrepreneur Edit Status History	Select	Entrepreneur Status History, Entrepreneur
Qry SubRpt Entrepreneur Profile Merge Data	Select	Products, ProcessStatus
Qry SubRpt Entrepreneurial Assessment Results List	Select	Entrepreneur Company, Entrepreneurs
Qry SubRpt Entrepreneurial Assessment Results	Select	Qry Count Entrepreneurial Assessment Results, Entrepreneurs
Qry SubRpt Entrepreneurial Assessment Retake Results List	Select	Entrepreneur Company, Entrepreneurs
Qry SubRpt Entrepreneurial Assessment Retake Results	Select	Qry Count Entrepreneurial Assessment Retake Results, Entrepreneurs
Qry SubRpt EOI Entrepreneur Company	Select	IndustryLookup, Entrepreneur
Qry SubRpt Exec Lead Summary Headhunted Single Date All Divs	Select	Entrepreneurs
Qry SubRpt Exec Lead Summary Headhunted Single Date One Div	Select	Entrepreneurs
Qry SubRpt Lead Delivery Location All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Lead Delivery Location by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Lead Delivery Location by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Lead Process Status All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Lead Process Status by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry SubRpt Lead Process Status by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Lead Process Status by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Lead Summary Headhunted Date Range	Select	Entrepreneurs
Qry SubRpt Lead Summary Referred to Prosperator Date Range	Select	Entrepreneur Status History, Entrepreneurs
Qry SubRpt Lead Unqualified All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Lead Unqualified by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry SubRpt Lead Unqualified by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Lead Unqualified by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Lead Unqualified Reason All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Lead Unqualified Reason by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry SubRpt Lead Unqualified Reason by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Lead Unqualified Reason by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Pipeline Process Status All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Pipeline Process Status by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry SubRpt Pipeline Process Status by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Pipeline Process Status by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Pipeline Terminated All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Pipeline Terminated by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry SubRpt Pipeline Terminated by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Pipeline Terminated by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Pipeline Termination Reason All Lead Types	Select	SubQry, SubQry Count Process Status All Lead Types Criteria
Qry SubRpt Pipeline Termination Reason by Delivery Location	Select	SubQry, SubQry Count Process Status by Delivery Location Criteria
Qry SubRpt Pipeline Termination Reason by Lead Type	Select	SubQry, SubQry Count Process Status by Lead Type Criteria
Qry SubRpt Pipeline Termination Reason by Principal Project	Select	SubQry, SubQry Count Process Status by Principal Project Criteria
Qry SubRpt Principal Project Allocation Audit Replaced Companies	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry SubRpt Principal Project Pillar Delivery Locations	Select
Qry SubRpt Principal Project Pillars	Select	Principal Project Pillars, Principal
Qry SubRpt Products Sold by Principal Project	Select	Principal, Principal Project Products Sold
Qry SubRpt Progress Category Mktg by Principal Project	Select	SubQry, SubQry Count Progress Category RM by Principal Project Criteria
Qry SubRpt Progress Category Sup List by Principal Project	Select	SubQry Count Progress Category SL by Principal Project Criteria, SubQry
Qry SubRpt Purple Panel Results Date Range	Select	Qry, Entrepreneurs
Qry SubRpt Purple Panel Results List Date Range	Select	Entrepreneur Company, Entrepreneurs
Qry SubRpt Sponsorship Elements by Principal Project	Select	Qry Sum Sponsor Elements Payments by Company, vwPurpleSubRptSponsorshipbyPrincipalProject
Qry SubRpt Termination Marketing by Principal Project	Select	vwPurpleSubRptTerminatedMarketingbyPrincipalProject
Qry SubRpt Termination Reasons Marketing by Principal Project	Select	vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject
Qry SubRpt Termination Reasons Supplier Lst by Principal Project	Select	vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj
Qry SubRpt Termination Supplier List by Principal Project	Select	vwPurpleSubRptTerminatedSupplierListbyPrincipalProject
Qry SubRpt Unqualified Marketing by Principal Project	Select	vwPurpleSubRptUnqualifiedMarketingbyPrincipalProject
Qry SubRpt Unqualified Reasons Marketing by Principal Project	Select	vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject
Qry SubRpt Unqualified Reasons Supplier Lst by Principal Project	Select	vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj
Qry SubRpt Unqualified Supplier List by Principal Project	Select	vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject
Qry Sum Companies Required by Principal Project	Select	Principal Project Pillars, Principal
Qry Sum Sponsor Elements Payments by Company	Select	Entrepreneur, Entrepreneur Company Extra Sponsor Payments
Qry Sum Total Allocated Amt by Company	Select	Entrepreneur, Entrepreneur Company Principal Projects
Qry Sum Total Replaced Billed to Date by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Sum Total Replaced Selection Fee by Principal Project	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
Qry Sum Total Spend by Principal Project	Select	Principal Project Pillars, Principal
Qry Sum Total Sponsor Elements by Principal Project	Select	Principal Project Pillar Sponsor Elements, Principal
Qry Sum Total Sponsor Elements Spend by Principal Project	Select	Principal Project Pillar Sponsor Elements, Entrepreneur
Qry Sum Total Sponsorship by Principal Project Pillar	Select	Entrepreneur, Entrepreneur Company Principal Projects
Qry Sum Total Sponsorship by Principal Project	Select	Principal Project Pillars, Entrepreneur
Qry User List	Select	DatabaseUsers
Qry User Module List	Select	DatabaseUsers, DatabaseUsers Module Permissions
Qry View Entrepreneur Digital First Meeting	Select	Entrepreneurs
qryLinkODBC	Select	zstblODBC_tables, zstblODBC_db
SubQry Count Companies by Principal Project Principal Report	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
SubQry Count Current Active Companies Total	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
SubQry Count Current Active Entrepreneurs Total	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
SubQry Count Entrepreneurs by Principal Project Principal Report	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
SubQry Count EPs With Pipeline Moves Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Count EPs With Pipeline Moves Dist Model Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Count First Meeting Setup Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Count Followed Up Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Count Headhunted by OwnedBy Date Range Criteria	Select	ProcessStatus, Entrepreneurs
SubQry Count Meetings Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Count Meetings Dist Model Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Count Process Status All Lead Types Criteria	Select	Lead Types, TerminationReason
SubQry Count Process Status by Delivery Location Criteria	Select	Lead Types, TerminationReason
SubQry Count Process Status by Lead Type Criteria	Select	Lead Types, Temp Lead Type for Lead Report
SubQry Count Process Status by Principal Project Criteria	Select	Temp Principal Project for Lead Report, Lead Types
SubQry Count Progress Category RM by Principal Project Criteria	Select	vwPurpleCountProgressCategoryRMbyPrinProjCriteria
SubQry Count Progress Category SL by Principal Project Criteria	Select	vwPurpleCountProgressCategorySLbyPrinProjCriteria
SubQry Count Records Created Criteria	Select	Entrepreneurs
SubQry Count Records Created Dist Model Criteria	Select	Entrepreneurs
SubQry Count Step 1 Status Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Count Step 1 Status Dist Model Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Count Terminations Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Count Terminations Dist Model Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Count Unqualified Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Count Unqualified Dist Model Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Duplicate Entrepreneurs Alt	Select	Entrepreneurs
SubQry Duplicate Entrepreneurs	Select	Entrepreneurs
SubQry Export Entrepreneur Information for Contract Mail Merge	Select	Principal Project Pillars, BBBEEPillarLookup
SubQry Get Entrepreneur Moved Last Week Criteria	Select	Entrepreneur Status History, Entrepreneur
SubQry Get Entrepreneur Moved Last Week	Select	SubQry Get Entrepreneur Moved Last Week Criteria, SubQry
SubQry Get Entrepreneur Steps Date Range Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Get Entrepreneur Steps Delivery Location Criteria	Select
SubQry Get Entrepreneur Steps For Summary Criteria	Select	Entrepreneur Status History, ProcessStatus
SubQry Get Entrepreneur Steps Lead Type Criteria	Select	vwPurpleGetEntrepreneurStepsCriteria
SubQry Get Entrepreneur Steps Owned by Criteria	Select	vwPurpleGetEntrepreneurStepsCriteria
SubQry Get Entrepreneur Steps Recommended Principal Project Crit	Select	vwPurpleGetEntrepreneurStepsCriteria
SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit	Select	Entrepreneur Status History, ProcessStatus
SubQry Get Entrepreneurs Modified Pipeline Date Range Crit	Select	Entrepreneur Status History, Entrepreneur
SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit	Select	Entrepreneur Status History, Entrepreneur
SubQry Get EPs Modified Pipeline 1 Prin Proj Date Range Crit	Select	Entrepreneur Status History, Principal Project Pillars
SubQry Get Last Programme Year for Exited Companies	Select	Principal Projects, Entrepreneur Company
SubQry Get Moved Last Week to Active PP Allocated Exited	Select	vwPurpleGetMovedLastWeektoActivePPAllocatedExited
SubQry Get Raizcorp Possibles Position	Select	SubQry Get Moved Last Week to Active PP Allocated Exited, SubQry
SubQry Process Status NOT in Pipeline List	Select	Pipelines Detail, Pipelines
SubQry Rpt Assessment Panel Passes per Scout	Select	Entrepreneurs
SubQry Rpt Average Days Per Step Count EPs	Select	SubQry, SubQry Rpt Average Days Per Step
SubQry Rpt Average Days Per Step Get DL and Owner	Select	SubQry, SubQry Rpt Average Days Per Step
SubQry Rpt Average Days Per Step Sum Days	Select	SubQry, SubQry Rpt Average Days Per Step
SubQry Rpt Average Days Per Step	Select	Temp Entrepreneur Steps, ProcessStatus
SubQry Rpt Average Time Through Pipeline by Delivery Location	Select	SubQry, SubQry Rpt Average Time Through Pipeline Criteria
SubQry Rpt Average Time Through Pipeline Criteria	Select	Temp, Pipelines
SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc	Select	ProcessStatus, Entrepreneurs
SubQry Rpt Count Entrepreneurs In the Pipeline	Select	ProcessStatus, Entrepreneurs
SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc	Select	SubQry Count EPs With Pipeline Moves Dist Model Criteria, SubQry
SubQry Rpt Count Entrepreneurs With Pipeline Moves	Select	SubQry, SubQry Count EPs With Pipeline Moves Criteria
SubQry Rpt Count Exited Leads	Select	SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count First Meeting Setup by Modified By	Select	SubQry Count First Meeting Setup Criteria, SubQry
SubQry Rpt Count Followed Up by Modified By	Select	SubQry, SubQry Count Followed Up Criteria
SubQry Rpt Count Followed Up Leads	Select	SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Meetings by Del Loc	Select	SubQry, SubQry Count Meetings Dist Model Criteria
SubQry Rpt Count Meetings by Owned By	Select	SubQry Count Meetings Criteria, SubQry
SubQry Rpt Count On Hold Leads	Select	SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Passed Panel Leads	Select	SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Qualified Leads by Date	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 Terminations by Del Loc	Select	SubQry Count Terminations Dist Model Criteria, SubQry
SubQry Rpt Count Terminations by Owned By	Select	SubQry Count Terminations Criteria, SubQry
SubQry Rpt Count Total Leads Generated by Date	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 by Del Loc	Select	SubQry Count Unqualified Dist Model Criteria, SubQry
SubQry Rpt Count Unqualified by Modified By	Select	SubQry, SubQry Count Unqualified Criteria
SubQry Rpt Count Unqualified by Owned By	Select	SubQry, SubQry Count Unqualified Criteria
SubQry Rpt Count Unqualified Leads	Select	SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Detailed Movement Date Range Criteria	Select	Entrepreneur Status History, Entrepreneur
SubQry Rpt Detailed Movement Date Range	Select	SubQry Rpt Detailed Movement Date Range Criteria, SubQry
SubQry Rpt Detailed Movement Owned by Criteria	Select	Entrepreneur Status History, Entrepreneurs
SubQry Rpt Detailed Movement Owned By	Select	SubQry, SubQry Rpt Detailed Movement Owned by Criteria
SubQry Rpt Detailed Movement Pipeline Date Range Criteria	Select	Entrepreneur Status History, Entrepreneur
SubQry Rpt Detailed Movement Pipeline Date Range	Select	SubQry, SubQry Rpt Detailed Movement Pipeline Date Range Criteria
SubQry Rpt Entrepreneurial Profiles	Select
SubQry Rpt Get Modified By	Select
SubQry Rpt Get Owned By	Select
SubQry Rpt Headhunting by Owned By Date Range Criteria	Select	Entrepreneurs
SubQry Rpt Headhunting Count Qualified by Owned By	Select	SubQry Rpt Headhunting by Owned By Date Range Criteria, SubQry
SubQry Rpt Headhunting Count Total by Owned By	Select	SubQry Rpt Headhunting by Owned By Date Range Criteria, SubQry
SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads	Select	SubQry Rpt Lead Daily Breakdown Criteria, SubQry
SubQry Rpt Lead Daily Breakdown Count Qualified Leads	Select	SubQry Rpt Lead Daily Breakdown Criteria, SubQry
SubQry Rpt Lead Daily Breakdown Count Total Leads	Select	SubQry Rpt Lead Daily Breakdown Criteria, SubQry
SubQry Rpt Lead Daily Breakdown Criteria	Select	Lead Types, ProcessStatus
SubQry Rpt Lead Type to Principal Allocation Criteria	Select	vwPurpleRptLeadTypetoPrincipalAllocationCriteria
SubQry Rpt Marketing EOI to Passed Panel Count EOI	Select	Temp, Entrepreneurs
SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel	Select	Temp, Entrepreneurs
SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit	Select	Entrepreneur Status History, Entrepreneurs
SubQry Rpt Marketing EOI to Passed Panel Count Qualified	Select	SubQry, SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit
SubQry Rpt Marketing Leads Criteria	Select	Entrepreneur Company, Lead Types
SubQry Rpt More Than 3 Follow Ups Count	Select	Entrepreneur Status History, Entrepreneur
SubQry Rpt Opal Prin Proj Summary Comp Required _1 Del Loc	Select	Principal, Qry Sum Companies Required by Principal Project
SubQry Rpt Opal Prin Proj Summary Count Active Comp	Select	SubQry Rpt Opal Principal Project Summary Criteria, SubQry
SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc	Select	SubQry Rpt Opal Principal Project Summary Criteria, SubQry
SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc	Select	SubQry Rpt Opal Principal Project Summary Criteria, SubQry
SubQry Rpt Opal Principal Project Summary Criteria	Select	vwPurpleRptOpalPrincipalProjectSummaryCriteria
SubQry Rpt Opal Principal Projects by Industry	Select	Principal Project Pillars, Principal
SubQry Rpt Part Sponsorship	Select	vwPurpleReportPartSponsorship, Qry
SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2	Select	SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2, SubQry
SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2	Select	SubQry, SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2
SubQry Rpt Percent Dropoff After 1st Meeting Count 1st Meeting	Select	SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs, SubQry
SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs	Select	Entrepreneur Status History, Entrepreneur
SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2	Select	SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs, SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2
SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2	Select	Entrepreneur Status History, SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs
SubQry Rpt Percent Raizcorp Possibles Moved Last Week	Select	Qry, Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc
SubQry Rpt Percentage Moved Last Week Digital	Select	Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location, Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca
SubQry Rpt Percentage Moved Last Week Manual	Select	Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location, Qry
SubQry Rpt Purple Panelists Attended	Select	SubQry, SubQry Rpt Purple Panelists Summary Criteria
SubQry Rpt Purple Panelists Convened	Select	SubQry, SubQry Rpt Purple Panelists Summary Criteria
SubQry Rpt Purple Panelists Sum Scores	Select	SubQry, SubQry Rpt Purple Panelists Summary Criteria
SubQry Rpt Purple Panelists Summary Criteria	Select	Entrepreneur, Entrepreneurs
SubQry Rpt Purple Panelists Summary	Select
SubQry Rpt RAG Criteria	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
SubQry Rpt Recommended Principal Project Allocation	Select	Principal Project Pillars, Entrepreneur Company Principal Projects
SubQry Rpt Selection Team Activity Summary Criteria	Select	Entrepreneur Company, CompanyProgrammeYearStatus
SubQry Rpt Selection Team Summary Total Graduated Off	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
SubQry Rpt Selection Team Summary Total Leads Generated	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
SubQry Rpt Selection Team Summary Total Non Graduate	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
SubQry Rpt Selection Team Summary Total On Programme	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
SubQry Rpt Selection Team Summary Total Passed Assessment	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
SubQry Rpt Selection Team Summary Total Passed Panel	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
SubQry Rpt Selection Team Summary Total Qualified	Select	SubQry Rpt Selection Team Activity Summary Criteria, SubQry
TestQuery	Select