Skip to content

Data Dictionary

BBBEEPillarLookup

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

Client Tiers

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

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

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 *

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

  • Front End Version Number: 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

Marketing Budget Non Principal Project

  • Marketing Budget ID: Long *
  • Date Budget Created: DateTime
  • Marketing Budget Status ID: Long
  • Budget Year: Long
  • Budget Description: Text
  • Budget Amount: Double
  • SSMA_TimeStamp: Binary *

Marketing Campaign Category LookUp

  • Marketing Campaign Category ID: Long *
  • Marketing Campaign Category: Text

Marketing Campaign Commodities

  • Marketing Campaign Commodity ID: Long *
  • Marketing Campaign ID: Long
  • Commodity: Text

Marketing Campaign Lead Types

  • Marketing Campaign Lead Type ID: Long *
  • Marketing Campaign ID: Long
  • Lead Type ID: Long

Marketing Campaigns

  • Marketing Campaign ID: Long *
  • Marketing Campaign: Text
  • Principal Project ID: Long
  • Job Number: Text
  • Marketing Campaign Category: Text
  • Marketing Campaign Status ID: Long
  • Notes: Text

Marketing Channel LookUp

  • Marketing Channel ID: Long *
  • Marketing Channel: Text

Marketing Sub Campaign Lead Types

  • Marketing Sub Campaign Lead Type ID: Long *
  • Marketing Sub Campaign ID: Long
  • Lead Type ID: Long

Marketing Sub Campaign Locations

  • Marketing Sub Campaign Location ID: Long *
  • Marketing Sub Campaign ID: Long
  • Delivery Location ID: Long

Marketing Sub Campaigns

  • Marketing Sub Campaign ID: Long *
  • Marketing Campaign ID: Long
  • Marketing Channel: Text
  • Marketing Sub Campaign Start Date: DateTime
  • Marketing Sub Campaign End Date: DateTime
  • Marketing Sub Campaign Spend: Double
  • SSMA_TimeStamp: Binary *

MarketingBudgetStatus

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

MarketingCampaignStatus

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

ModulePermissionLookup

  • Permission ID: Long *
  • Module Permission: Text

NonGraduateReason

  • Non Graduate Reason ID: Long *
  • Non Graduate Reason: 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 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

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

Reporting Frequency

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

StatusActiveLookup

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

Temp Lead Type for Lead Report

  • Lead Type ID: Long

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 *

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

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 *