Skip to content

Data Dictionary

ActionPriorityLookup

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

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

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

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

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 Purple Ops Meeting

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

ProcessStep

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

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

Purple Meeting Actions

  • Purple Meeting Action ID: Long *
  • Date Created: DateTime
  • Principal Project Pillar ID: Long
  • Priority: Text
  • Department: Text
  • Action: Text
  • Due Date: DateTime
  • Date Completed: DateTime

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

vwPurpleCountActiveAllocatedCompaniesbyPrinProjPillar

  • Principal Project Pillar ID: Long
  • Number Active Allocated Companies: Long

vwPurpleCountExitedCompaniesbyPrincipalProjectPillar

  • Principal Project Pillar ID: Long
  • Number Exited Companies: Long

vwPurpleCountExitedNeedReplacementbyPrincipalProjectPillar

  • Principal Project Pillar ID: Long
  • Number of Replacements Needed: Long
  • Company Programme Year Status ID: Long

vwPurpleCountUnallocatedCompaniesbyPrincipalProjectRec

  • Recommended Principal Project ID: Long
  • Unallocated Companies: Long

vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar

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

vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar

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

vwPurpleSumTotalSponsorshipbyPrincipalProjectPillar

  • Principal Project Pillar ID: Long
  • Total Sponsorship Amt: Double

vwPurpleWeavePrincipalProjectPillarList

  • Principal Project Pillar ID: Long *
  • Principal Project ID: Long
  • Principal: Text
  • Project Name: Text
  • BBBEE Pillar: Text
  • Number of Companies Required: Double
  • Principal Project Status ID: Long
  • Status: Text
  • Scout: Text
  • Solutions Architect: Text
  • Principal Project Pillar Urgency: Byte *
  • Amount Sponsored: Double
  • Unallocated Companies: Long
  • Number Exited Companies: Long
  • Number Active Allocated Companies: Long
  • Total Sponsorship Amt: Double
  • Number of Replacements Needed: Long
  • Key Account Manager: Text
  • Date Principal Requires Packs: DateTime
  • Lump Sum Allocation: Boolean

vwPurpleWeaveSumTotalNeedsRepBilledToDatebyPPPCriteria

  • Principal Project Pillar ID: Long
  • Entrepreneur Company Principal Project ID: Long *
  • Needs Replacement Billed to Date: Double

vwPurpleWeaveSumTotalReplacementAllocatedbyPPP

  • Principal Project Pillar ID: Long
  • Replacement Status: Text
  • Replacement Allocated: Double

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 *