Data Dictionary

BBBEEPillarLookup

• BBBEE Pillar ID: Long *
• BBBEE Pillar Description: Text
• BBBEE Pillar: 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

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

dbo_ApplicationVersions

• Application: Memo
• Version: Memo

dbo_ApplicationVersions1

• Application: Memo
• Version: Memo

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 *

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 *

Email Recipient List

• Email Recipient ID: Long *
• Email Function Name: Text
• Email Recipient: Text

EmailFunctionLookup

• Email Function ID: Long *
• Email Function Name: Text

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

• Entrepreneur Company PP History ID: Long *
• Entrepreneur Company Principal Project ID: Long
• Field Changed: Text
• ValueType: Double
• TextType: Text
• Modified By: Text
• Date Modified: DateTime
• 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 Sub Products

• Entrepreneur Company Sub Product ID: Long *
• Entrepreneur Company ID: Long
• Principal Project Pillar ID: Long
• Sub Product Allocated Amount: Double
• SSMA_TimeStamp: Binary *

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

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

General Allocation

• Front End Version Number: Text *
• Contract Mail Merge File Name: Text
• Notification File Name: Text
• Certificate Mail Merge File Name: 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

MonthLkUp

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

NonGraduateReason

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

PrimaryTenants

• ID (PK): Long
• PrimaryTenant: Text

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

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

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

ReplacementStatusLookup

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

Report Writer Garnet 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

SecondaryTenants

• ID (PK): Long
• SecondaryTenant: Text

SelectionFeeTypeLookup

• Selection Fee Type ID: Long *
• Selection Fee Type: Text

Sub Products

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

Temp Entrepreneur Companies for Opal Scorecard

• Entrepreneur Company ID: Long
• Entrepreneur Company Programme Years ID: Long
• Entrepreneur Company Principal Project ID: Long
• Company Status ID During Range: Long
• Date Status Changed During Range: DateTime
• Contract Ending Within Range: Boolean

Temp Entrepreneur Company ID for Lump Sum Allocation

• Entrepreneur Company ID: Long
• Recommended Product ID: Long

Temp Entrepreneur Company Monthly Billings

• Entrepreneur Company Principal Project ID: Long
• Principal Project Pillar ID: Long
• Billing Amount: Double

Temp Entrepreneur ID for Contract Mail Merge

• Entrepreneur ID: Long
• Entrepreneur Company ID: Long
• Entrepreneur Company Programme Years ID: Long
• Entrepreneur Company Principal Project ID: Long

Temp Principal Projects for Finance Report

• Principal Project ID: Long
• Principal Project: Text
• Total Spend: Double

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 *

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 *

vwGarnetCompanyEntrepreneurIgnitionList

• Entrepreneur Company ID: Long *
• First Name: Text
• Surname: Text
• Company Name: Text
• Delivery Location: Text
• Status: Text
• Principal: Text
• Project Name: Text
• Product: Text
• Programme Year: Text
• Ignition Date: DateTime
• Industry: Text
• Committment Fee: Double
• Date Contract Signed: DateTime
• OwnedBy: Text
• Email Address: Text
• Telephone Number: Text
• Second Telephone Number: Text

vwGarnetCompanyList

• Entrepreneur Company ID: Long *
• Company Name: Text
• Company Delivery Location ID: Long
• Delivery Location: Text
• Company Status ID: Long
• Status: Text
• Sort Order: Double
• Status Change: DateTime

vwGarnetCompanyPrincipalProjectList

• Entrepreneur Company ID: Long *
• Principal Project ID: Long
• Company Name: Text
• Company Delivery Location ID: Long
• Delivery Location: Text
• Company Status ID: Long
• Company Programme Year Status ID: Long
• Status: Text
• Programme Year Status: Text
• Principal: Text
• Project Name: Text
• Sort Order: Double
• Year Status Change: DateTime
• Status Change: DateTime
• Ignition Date: DateTime
• Product: Text
• Programme Year: Text
• Industry: Text
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Committment Fee: Double
• Ring Fencing: Boolean
• Date Contract Signed: DateTime
• VA Packs Delivered: DateTime
• Contract Printed: Boolean

vwGarnetCompanyRaizcorpossiblesList

• Entrepreneur Company ID: Long *
• Process Status ID: Long
• Company Name: Text
• Company Delivery Location ID: Long
• Company Status ID: Long
• Status: Text
• Delivery Location: Text
• Sort Order: Double
• Status Change: DateTime
• First Name: Text
• Surname: Text
• Division: Text
• Distribution Model: Text
• Principal: Text
• Project Name: Text
• Recommended Product: Text

vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation

• Company Status ID: Long
• Company Delivery Location ID: Long
• Number Active Companies: Long

vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation

• Process Status ID: Long
• Company Status ID: Long
• Distribution Model: Text
• Delivery Location ID: Long
• Delivery Location: Text
• Companies Target: Long
• Number Active Entrepreneurs: Long

vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects

• Lump Sum Allocation: Boolean
• Company Status ID: Long
• Company Programme Year Status ID: Long
• Company Delivery Location ID: Long
• Delivery Location: Text
• Entrepreneur Company ID: Long *
• Company Name: Text
• Principal Project ID: Long
• Principal Project: Memo *
• Principal: Text
• Allocated Amount: Double
• Total Spend: Double *

vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects

• Lump Sum Allocation: Boolean
• Process Status ID: Long
• Company Status ID: Long
• Company Programme Year Status ID: Long
• Company Delivery Location ID: Long
• Entrepreneur Company ID: Long *
• Delivery Location: Text
• Company Name: Text
• Entrepreneur: Memo *
• Allocated Weight: Double
• Principal Project ID: Long

vwGarnetExportCompanyInformationforCertificateMailMerge

• Entrepreneur ID: Long *
• Entrepreneur Company ID: Long *
• Entrepreneur Company Programme Years ID: Long
• Company Name: Text
• First Name: Text
• Surname: Text
• Programme Year: Text
• Certificate Programme Name: Text
• Product Code: Text
• Date Status Changed: DateTime
• Delivery Location: Text
• Principal: Text

vwGarnetExportEntrepreneurInformationforContractMailMerge

• Entrepreneur ID: Long *
• Email Address: Text
• Entrepreneur Company Principal Project ID: Long
• Project Name: Text
• Allocated Amount: Double
• Contract Printed: Boolean
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Date Record Created: DateTime
• EA Date: DateTime
• Date Panel Held: DateTime
• First Name: Text
• Surname: Text
• Identity Number: Text
• Company Name: Text
• CompanyReg: Text
• Delivery Location: Text
• Enterprise Type: Text
• Principal: Text
• Committment Fee: Double
• Product: Text
• Programme Year: Text
• Percent Black Owned: Double
• Percent Women Black Owned: Double
• BBBEE Pillar Description: Text
• PP Contact First Name: Text
• Contact Surname: Text
• Business Address 1: Text
• Business Address 2: Text
• Business Address 3: Text
• Business Postal Code: Text
• Trading As: Text
• Ignition Date: DateTime

vwGarnetGetEPReadyforAllocationInfobyCompany

• Entrepreneur Company ID: Long
• Division ID: Long
• Division: Text
• Distribution Model ID: Long
• Distribution Model: Text

vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit

• Distribution Model ID: Long
• Entrepreneur Company ID: Long *
• Company Programme Year Status ID: Long
• Delivery Location: Text
• Company Delivery Location ID: Long
• Principal Project ID: Long
• Company Name: Text
• Principal: Text
• Project Name: Text
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Product ID: Long
• Company Product: Text
• Allocated Weight: Double
• Monthly Allocated Amount: Double

vwGarnetReportCompaniesAllocated

• Date Allocation Created: DateTime
• Lump Sum Allocation: Boolean
• Principal Project: Memo *
• Company Name: Text
• Ignition Date: DateTime
• Product: Text
• Programme Year: Text
• Programme Year Status: Text
• BBBEE Pillar: Text
• Allocated Amount: Double
• Selection Fee: Double
• Total Sponsorship: Double *
• Monthly Allocated Amount: Double
• Delivery Location: Text
• Ring Fence: Text

vwGarnetReportCompaniesLeftProgramme

• Date Status Changed: DateTime
• Company Programme Year Status ID: Long
• Lump Sum Allocation: Boolean
• Principal Project: Memo *
• Company Name: Text
• Company Status: Text
• Product: Text
• Programme Year: Text
• Programme Year Status: Text
• Allocated Amount: Double
• Selection Fee: Double
• Total Sponsorship: Double *
• Monthly Allocated Amount: Double
• Billed to Date: Double
• To Be Billed: Double
• Delivery Location: Text
• Ring Fence: Text
• Months On Programme: Long
• Replacement Status: Text

vwGarnetReportCompaniesNeedToBeAllocated

• Lump Sum Allocation: Boolean
• Principal Project Pillar ID: Long
• Allocated Amount: Double
• Company Programme Year Status ID: Long
• Principal Project: Memo *
• Company Name: Text
• Ignition Date: DateTime
• Product: Text
• Programme Year: Text
• Programme Year Status: Text
• BBBEE Pillar: Text
• Delivery Location: Text

vwGarnetReportCompaniesStartedProgramme

• Date Status Changed: DateTime
• Company Programme Year Status ID: Long
• Lump Sum Allocation: Boolean
• Principal Project: Memo *
• Company Name: Text
• Ignition Date: DateTime
• BBBEE Pillar: Text
• Product: Text
• Programme Year: Text
• Allocated Amount: Double
• Selection Fee: Double
• Total Sponsorship: Double *
• Monthly Allocated Amount: Double
• Delivery Location: Text
• Ring Fence: Text

vwGarnetReportPreBillingException

• Lump Sum Allocation: Boolean
• Company Programme Year Status ID: Long
• Entrepreneur Company ID: Long *
• Company Name: Text
• Delivery Location: Text
• Ignition Date: DateTime
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Principal Project: Memo *
• BBBEE Pillar: Text
• Allocated Amount: Double
• Total Sponsorship: Double *
• Programme Year: Text
• Product: Text
• To Be Billed: Double
• Total Billed: Double

vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement

• Principal Project ID: Long
• NR Total Balance: Double

vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship

• Principal Project ID: Long
• Future Yr Total Sponsorship: Double

vwGarnetReportSumDeferredIncomeNGSelectionFeeandBilledDate

• Principal Project ID: Long
• NG Total Selection Fee: Double
• NG Total Billed To Date: Double

vwGarnetReportSumDeferredIncomeOBBalance

• Principal Project ID: Long
• On P Blank Total Balance: Double

vwGarnetReportSumDeferredIncomeOGBSelectionFeeandBilledDate

• Principal Project ID: Long
• On P Grad Blank Total Sponsorship: Double
• OGB Total Selection Fee: Double
• OGB Total Billed To Date: Double

vwGarnetReportSumDeferredIncomeSEDSpend

• Principal Project ID: Long
• BBBEE Pillar: Text
• SED Spend: Double

vwGarnetReportSumDeferredIncomeTotalSponsorshipNonGraduate

• Principal Project ID: Long
• NonGrad Total Sponsorship: Double

vwGarnetRptAllocationExportGraduatedCompanies

• Entrepreneur ID: Long
• Entrepreneur Company ID: Long *
• Division ID: Long
• Company Status ID: Long
• Company Programme Year Status ID: Long
• Programme Year Status: Text
• Date Graduate: DateTime
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Allocation ID: Long
• Student ID: Text
• Company Name: Text
• Status: Text
• Entrepreneur: Memo *
• Identity Number: Text
• Industry: Text
• Category: Memo *
• Product: Text
• Programme Year: Text
• Total Programme Amount: Double
• Company Delivery Location: Text
• Principal: Text
• Principal Project: Memo *
• Total Allocated Amt: Double
• Years in Business: Text
• Percentage Black Owned: Double
• Percentage Women Black Owned: Double
• Ignition Date: DateTime

vwGarnetRptAllocationExportNonGraduateCompanies

• Entrepreneur ID: Long
• Entrepreneur Company ID: Long *
• Division ID: Long
• Company Status ID: Long
• Company Programme Year Status ID: Long
• Programme Year Status: Text
• Date Non Graduate: DateTime
• Non Graduate Reason: Text
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Allocation ID: Long
• Student ID: Text
• Company Name: Text
• Status: Text
• Entrepreneur: Memo *
• Identity Number: Text
• Industry: Text
• Category: Memo *
• Product: Text
• Programme Year: Text
• Total Programme Amount: Double
• Company Delivery Location: Text
• Principal: Text
• Principal Project: Memo *
• Total Allocated Amt: Double
• Years in Business: Text
• Percentage Black Owned: Double
• Percentage Women Black Owned: Double
• Ignition Date: DateTime

vwGarnetRptAllocationExportOnProgrammeandOthersCompanies

• Entrepreneur ID: Long
• Entrepreneur Company ID: Long *
• Division ID: Long
• Company Status ID: Long
• Company Programme Year Status ID: Long
• Sort Order: Double
• Programme Year Status: Text
• Date On Programme: DateTime
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Allocation ID: Long
• Student ID: Text
• Company Name: Text
• Status: Text
• Entrepreneur: Memo *
• Identity Number: Text
• Industry: Text
• Category: Memo *
• Product: Text
• Programme Year: Text
• Total Programme Amount: Double
• Company Delivery Location: Text
• Principal: Text
• Principal Project: Memo *
• Total Allocated Amt: Double
• Years in Business: Text
• Percentage Black Owned: Double
• Percentage Women Black Owned: Double
• Ignition Date: DateTime

vwGarnetRptPartSponsorshipHistory

• Entrepreneur Company Programme Years ID: Long
• Process Status ID: Long
• Company Status ID: Long
• Delivery Location: Text
• Company Name: Text
• Entrepreneur: Memo *
• Phone: Text
• Email Address: Text
• Industry: Text
• Brief Description of Business: Memo
• Product: Text
• Total Programme Amount: Double
• Total Allocated: Double *
• Amount Needed: Double
• Programme Year: Text
• Contract Start Date: DateTime
• Contract End Date: DateTime

vwGarnetRptPrincipalProjectAllocation

• Company Status ID: Long
• Replacement Status: Text
• Principal Project Status ID: Long
• Lump Sum Allocation: Boolean
• Principal Project: Memo *
• BBBEE Pillar: Text
• Status: Text
• Company Name: Text
• Allocated Amount: Double
• Selection Fee: Double
• Total Sponsorship: Double *
• Sum Tot Sponsorship: Double *
• Amt Sponsored: Double *
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Programme Year: Text
• Product: Text
• Delivery Location: Text
• Ring Fence: Boolean
• Number of Current Companies by Principal Project: Long
• Number of Current Entrepreneurs by Principal Project: Long

vwGarnetRptPrincipalProjectAllocationAudit

• Principal Project ID: Long
• Programme Year Status: Text
• Status: Text
• CompanySortOrder: Double
• ProgrammeYrSortOrder: Double
• Date Status Changed: DateTime
• Replacement Status: Text
• Company Name: Text
• Contract Start Date: DateTime
• Contract End Date: DateTime
• BBBEE Pillar: Text
• Allocated Amount: Double
• Selection Fee: Double
• Programme Year: Text
• Product: Text
• Delivery Location: Text
• Ring Fencing: Boolean

vwGarnetRptPrincipalProjectAllocationforFinance

• Lump Sum Allocation: Boolean
• Company Status ID: Long
• Entrepreneur Company Principal Project ID: Long
• Ring Fencing: Boolean
• Replacement Status: Text
• Date Status Changed: DateTime
• Company Programme Year Status ID: Long
• Entrepreneur Company ID: Long *
• Principal Project Pillar ID: Long
• Principal Project ID: Long
• Delivery Location: Text
• Ignition Date: DateTime
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Company Name: Text
• Project Name: Text
• Principal: Text
• Amount Sponsored: Double
• BBBEE Pillar: Text
• Allocated Amount: Double
• Monthly Allocated Amount: Double
• Selection Fee: Double
• Selection Fee Type: Text
• Total Programme Amount: Double
• Programme Year: Text
• Product: Text
• Pricing Mode: Long

vwGarnetRptPrincipalQuarterlyReports

• Principal Project ID: Long
• Process Status ID: Long
• Division ID: Long
• Principal: Text
• Project Name: Text
• Principal Project Contract End Date: DateTime
• Tier: Text
• Company Status ID: Long
• Date Status Changed: DateTime
• Delivery Location: Text
• Company Name: Text
• First Name: Text
• Surname: Text
• Solutions Architect: Text
• Status: Text
• Contract Start Date: DateTime
• Contract End Date: DateTime
• Ignition Date: DateTime
• Programme Year: Text
• Product: Text

vwGarnetSumTotalBilledbyPrincipalProjectDeliveryLocation

• Principal Project ID: Long
• Company Delivery Location ID: Long
• Total Billed: Double

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

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

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 *