Skip to content

Data Dictionary

Archive Entrepreneur Data

  • 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

  • Archive Entrepreneur Purple Panelist ID: Long *
  • Entrepreneur ID: Long
  • Purple Panelist: Text
  • Purple Panelist Score: Double
  • Convener: Boolean
  • SSMA_TimeStamp: Binary *

AreasofOperationLookup

  • Area of Operation ID: Long *
  • Area of Operation: Text

AssessmentMarkerLookup

  • Assessment Marker ID: Long *
  • Assessment Marker: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

BBBEEPillarLookup

  • BBBEE Pillar ID: Long *
  • BBBEE Pillar Description: Text
  • BBBEE Pillar: Text

BusinessPremisesLookup

  • ID (PK): Long *
  • Business Premises: Text

Channel Partners

  • Channel Partner ID: Long *
  • Channel Partner: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Client Tiers

  • Client Tier ID: Long *
  • Client Tier: Text
  • Client Tier Range: Text

CompanyProgrammeYearStatus

  • Company Programme Year Status ID: Long *
  • Programme Year Status: Text
  • Active: Boolean
  • Sort Order: Double
  • SSMA_TimeStamp: Binary *

CompanyStatus

  • Company Status ID: Long *
  • Status: Text
  • Active: Boolean
  • Sort Order: Double
  • SSMA_TimeStamp: Binary *

ContractTypeLookup

  • Contract Type ID: Long *
  • Contract Type: Text

CountryLookup

  • Country ID: Long *
  • Country (PK): Text
  • Country Code: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

DatabaseUsers Module Permissions

  • Module Permission ID: Long *
  • Username: Text *
  • Module Permission: Text
  • LEVEL: Text
  • Role: Text

DatabaseUsers

  • User ID: Long *
  • Username (PK): Text *
  • 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

  • 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

  • ID (PK): Long *
  • Department: Text

DevelopmentLookup

  • ID (PK): Long *
  • Development: Text

Distribution Models

  • Distribution Model ID: Long *
  • Distribution Model: Text
  • Distribution Model Code: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Divisions

  • Division ID: Long *
  • Division (PK): Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Engage UUID

  • Key ID: Long *
  • REMS ID: Long
  • UUID: Text
  • Source: Text

EnterpriseTypeLookup

  • ID (PK): Long *
  • EnterpriseType: Text

Entrepreneur Arize First Meeting Candidate Recommendations

  • 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

  • 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

  • Entrepreneur Partner ID: Long *
  • Entrepreneur ID: Long
  • Child Entrepreneur ID: Long

Entrepreneur Company Areas of Operation

  • Entrepreneur Area of Operation ID: Long *
  • Entrepreneur Company ID: Long
  • Area of Operation: Text

Entrepreneur Company Commodities

  • Entrepreneur Company Commodity ID: Long *
  • Entrepreneur Company ID: Long
  • Commodity: Text

Entrepreneur Company Extra Sponsor Elements

  • 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

  • Entrepreneur Company Extra Sponsor Payment ID: Long *
  • Entrepreneur Company Extra Sponsor Element ID: Long
  • Payment Date: DateTime
  • Payment Amount: Double

Entrepreneur Company Monthly Billings

  • 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

  • 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

  • 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

  • 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

  • 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

  • Entrepreneur Company Status ID: Long *
  • Entrepreneur Company ID: Long
  • Company Status ID: Long
  • Date Status Changed: DateTime
  • Status Modified By: Text

Entrepreneur Company

  • 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

  • Entrepreneur Edit ID: Long *
  • Entrepreneur ID: Long
  • Modified By: Text
  • Date Modified: DateTime

Entrepreneur Notes

  • Entrepreneur Note ID: Long *
  • Entrepreneur ID: Long
  • Note Date: DateTime
  • Notes: Text

Entrepreneur Notifications Sent

  • Notification ID: Long *
  • Entrepreneur ID: Long
  • Notification Type: Text
  • Notification Date: DateTime

Entrepreneur Profile Presented To

  • 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

  • Entrepreneur Purple Panelist ID: Long *
  • Entrepreneur ID: Long
  • Purple Panelist: Text
  • Purple Panelist Score: Double
  • Convener: Boolean
  • SSMA_TimeStamp: Binary *

Entrepreneur Status History

  • 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

  • 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

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

EntrepreneurProfilePresentedToResultLookup

  • Entrepreneur Profile Present Result ID: Long *
  • Entrepreneur Profile Present Result: Text

Entrepreneurs Test

  • 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

  • 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

  • Allocation Template File Name: Text *

FullPartLookup

  • ID (PK): Long *
  • FullPart: Text

GenderLookup

  • ID (PK): Long *
  • Gender: Text

General Purple

  • 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

  • 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

  • Import Template ID: Long *
  • Import Template: Text
  • Import Procedure: Text

IndustryLookup

  • Industry ID: Long *
  • Industry (PK): Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *
  • Blue Heart Pass at 45: Boolean

Lead Types

  • 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

  • Lead Format ID: Long *
  • Lead Format: Text

LeadSourceLookup

  • ID (PK): Long *
  • Lead Source: Text

ModuleLevelsLookup

  • Module Level ID: Long *
  • Module Permission: Text
  • Level: Text

ModulePermissionLookup

  • Permission ID: Long *
  • Module Permission: Text

MonthLkUp

  • Month Number: Long *
  • Month Name: Text
  • Last Day: Integer

NonGraduateReason

  • Non Graduate Reason ID: Long *
  • Non Graduate Reason: Text

PersonalAuditResultLookup

  • Personal Audit Result ID: Long *
  • Personal Audit Result: Text
  • Personal Audit Min: Long
  • Personal Audit Max: Long

Pipelines Detail

  • Pipeline Detail ID: Long *
  • Pipeline ID: Long
  • Process Status ID: Long

Pipelines

  • Pipeline ID: Long *
  • Pipeline (PK): Text
  • Selection Type: Long

Principal Project Pillar Commodities

  • Principal Project Pillar Commodity ID: Long *
  • Principal Project Pillar ID: Long
  • Commodity: Text

Principal Project Pillar Delivery Location

  • Principal Project Pillar Delivery Location ID: Long *
  • Principal Project Pillar ID: Long
  • Delivery Location: Text
  • Delivery Location Other: Text

Principal Project Pillar Sourced From

  • Principal Project Pillar Source ID: Long *
  • Principal Project Pillar ID: Long
  • Entrepreneur Sourced: Text

Principal Project Pillar Sponsor Elements

  • 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

  • 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

  • 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

  • Principal Project Product Sold ID: Long *
  • Principal Project ID: Long
  • Product: Text

Principal Projects

  • 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

  • Process Category: Text
  • Stage (PK): Text *
  • Stage Name: Text
  • Explanation: Text

Principal Report Text

  • Opening Paragraph: Memo *
  • SSMA_TimeStamp: Binary *

PrincipalProjectStatus

  • Principal Project Status ID: Long *
  • Status: Text
  • Active: Boolean
  • Sort Order: Long
  • Last Modified By: Text
  • Date Modified: DateTime
  • SSMA_TimeStamp: Binary *

Principals

  • Principal ID: Long *
  • Second Principal ID: Long *
  • First Principal ID: Long *
  • Principal (PK): Text
  • 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

  • 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

  • Step Number: Long *
  • Process Step: Text
  • Phase: Text
  • Last Modified By: Text
  • Date Modified: DateTime

Product Distribution Models

  • Product Distribution Model ID: Long *
  • Product ID: Long
  • Distribution Model ID: Long

Product Divisions

  • Product Division ID: Long *
  • Product ID: Long
  • Division ID: Long
  • BEE Certificate Required: Boolean
  • SSMA_TimeStamp: Binary *

Products

  • Product ID: Long *
  • Product (PK): Text
  • 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

  • Programme Year: Text *
  • Sort Order: Long

ProgressCategory

  • Progress Category ID: Long *
  • Progress Category: Text
  • Sort Order: Long
  • Last Modified By: Text
  • Date Modified: DateTime

ProvinceLookup

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

RaceLookup

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

ReferenceNumbersImported

  • Reference Number: Long *

ReplacementStatusLookup

  • Replacement Status ID: Long *
  • Replacement Status: Text

Report Writer Included Field Names

  • ID (PK): Long *
  • Description: Text
  • Include Field Name: Text
  • Sort Order: Long

Reporting Frequency

  • Reporting Frequency ID: Long *
  • Reporting Frequency: Text
  • Reporting Frequency Description: Text

Restore Deleted Leads

  • 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

  • Role ID: Long *
  • Role (PK): Text

Scouts

  • Scout ID: Long *
  • Scout First Name: Text
  • Scout Surname: Text

SourceCategoryLookup

  • Source Category ID: Long *
  • Source Category: Text
  • Active: Boolean
  • Last Modified By: Text
  • Date Modified: Text
  • SSMA_TimeStamp: Binary *

SourceDetailLookup

  • Source Detail ID: Long *
  • Source Detail: Text
  • Last Modified By: Text
  • Date Modified: DateTime
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

StatusActiveLookup

  • ID (PK): Long *
  • Status: Text

Style Questions and Weighting

  • Style Question ID: Long *
  • Style Name: Text
  • Option Number: Long
  • Option Description: Text
  • Weighting: Long
  • SSMA_TimeStamp: Binary

StypeQuestionnaireResultLookup

  • Style Questionnaire Result ID: Long *
  • Style Questionnaire Result: Text
  • Style Questionnaire Min: Double
  • Style Questionnaire Max: Double
  • SSMA_TimeStamp: Binary *

Sub Products

  • Sub Product ID: Long *
  • Sub Product: Text
  • BBBEE Pillar: Text
  • Frequency: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Table1

  • ID (PK): Long

Teams Targets

  • ID (PK): Long *
  • 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

  • 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

  • Lead Type ID: Long

Temp Principal Project for Lead Report

  • Principal Project ID: Long

Temp Purple Meeting Status

  • 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

  • ID (PK): Long
  • 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

  • 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

  • Turnover Category ID: Long *
  • Turnover Category: Text
  • Active: Boolean
  • Last Modified By: Text
  • Date Modified: DateTime
  • SSMA_TimeStamp: Binary *

UnqualifiedReason

  • 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

  • Urgency Result ID: Long *
  • Urgency Result: Text
  • Urgency Audit Min: Long
  • Urgency Audit Max: Long

User Levels

  • Level ID: Long *
  • Level (PK): Text
  • Level Description: Text

vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport

  • Principal Project ID: Long
  • Entrepreneur Company ID: Long *

vwPurpleCountProgressCategoryRMbyPrinProjCriteria

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • Entrepreneur ID: Long *
  • Delivery Location ID: Long
  • Distribution Model: Text
  • Delivery Location: Text
  • Selection Type: Long

vwPurpleGetEntrepreneurSteps

  • Entrepreneur ID: Long
  • Date Status Changed: DateTime
  • Step Number: Long

vwPurpleGetEntrepreneurStepsCriteria

  • 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

  • Entrepreneur ID: Long
  • Note Date: DateTime
  • Notes: Text

vwPurpleGetMovedLastWeektoActivePPAllocatedExited

  • Entrepreneur Company ID: Long
  • Pipeline ID: Long
  • Date Status Changed: DateTime
  • Company Status ID: Long

vwPurpleReportContractnotPrintedorVAPacksnotDelivered

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • Entrepreneur ID: Long *
  • Process Status ID: Long
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject

  • Process Status ID: Long
  • Termination Reason: Text
  • Entrepreneur ID: Long *
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj

  • Process Status ID: Long
  • Termination Reason: Text
  • Entrepreneur ID: Long *
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptTerminatedSupplierListbyPrincipalProject

  • Entrepreneur ID: Long *
  • Process Status ID: Long
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptUnqualifiedMarketingbyPrincipalProject

  • Entrepreneur ID: Long *
  • Process Status ID: Long
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject

  • Process Status ID: Long
  • Unqualified Reason: Text
  • Entrepreneur ID: Long *
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj

  • Process Status ID: Long
  • Unqualified Reason: Text
  • Entrepreneur ID: Long *
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject

  • Entrepreneur ID: Long *
  • Process Status ID: Long
  • Recommended Principal Project ID: Long
  • Principal Project ID: Long
  • Lead Source: Text

vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar

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

vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar

  • Principal Project Pillar ID: Long
  • Total Rep Selection Fee: Double

YearsinBusinessLookup

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

zstblODBC_db

  • DBID (PK): Long
  • SelectDB: Boolean
  • ServerName: Text *
  • DBName: Text *
  • Authentication: Text *
  • UID: Text
  • PWD: Text
  • Driver: Text *
  • DateAdded: DateTime *

zstblODBC_tables

  • TableID (PK): Long
  • Link: Boolean
  • Hidden: Boolean
  • TableName: Text
  • SourceTableName: Text
  • AfterDDL: Text
  • Comment: Text
  • DateAdded: DateTime *