Skip to content

Data Dictionary

Business Area Lookup

  • Business Area ID: Long *
  • Business Area: Text
  • 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 *

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

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 GIA

  • Front End Version Number: Text *
  • Purple Panel Interview Report File Name: Text

Metrics

  • Metric ID: Long *
  • Metric (PK): Memo
  • Metric Description: Memo
  • Default Metric: Boolean
  • Sort Order: Long
  • SSMA_TimeStamp: Binary *

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

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 *

Purple Panel Extra Notification Usernames

  • Username (PK): Text *
  • SSMA_TimeStamp: Binary *

Purple Panel Report Staging Area

  • Staging ID: Long *
  • Email Address: Text
  • Report Name: Text
  • Company Name: Text
  • SSMA_TimeStamp: Binary *

Purple Panel Score Lookup

  • Purple Panel Score ID: Long *
  • Purple Panel Score: Long
  • Purple Panel Score Description: Text
  • SSMA_TimeStamp: Binary *

Purple Panel Status Lookup

  • Purple Panel Status ID: Long *
  • Purple Panel Status: Text
  • Passed: Boolean
  • SSMA_TimeStamp: Binary *

Purple Panelist Developmental Areas

  • Purple Panelist Developmental Areas ID: Long *
  • Purple Panelist ID: Long
  • Purple Panelist Developmental Areas: Text
  • SSMA_TimeStamp: Binary *

Purple Panelist Strengths

  • Purple Panelist Strengths ID: Long *
  • Purple Panelist ID: Long
  • Purple Panelist Strengths: Text
  • SSMA_TimeStamp: Binary *

Purple Panelists Evidence

  • Purple Panelist Evidence ID: Long *
  • Purple Panelist Score ID: Long
  • Purple Panelist Score Evidence: Text
  • SSMA_TimeStamp: Binary *

Purple Panelists Scores

  • Purple Panelist Score ID: Long *
  • Purple Panelist ID: Long
  • Rubric Metric Template ID: Long
  • Purple Panelist Score: Long
  • DELETE Purple Panelist Score Evidence 1: Text
  • DELETE Purple Panelist Score Evidence 2: Text
  • DELETE Purple Panelist Score Evidence 3: Text
  • DELETE Purple Panelist Score Evidence 4: Text
  • DELETE Purple Panelist Score Evidence 5: Text
  • Unused: Boolean
  • SSMA_TimeStamp: Binary *

Purple Panelists

  • Purple Panelist ID: Long *
  • Purple Panel ID: Long
  • Purple Panelist: Text
  • Business Area: Text
  • Purple Panelist Total Score: Double
  • Possible Total Score: Double
  • Convener: Boolean
  • Questions: Memo
  • Submitted: Boolean
  • SSMA_TimeStamp: Binary *

Purple Panels

  • Purple Panel ID: Long *
  • Purple Panel Date: DateTime
  • Purple Panel Time: DateTime
  • Entrepreneur Company ID: Long
  • Recommended Product: Text
  • Suitabe for Recommended Programme: Long
  • Recommend Suitable Programme: Text
  • Rubric ID: Long
  • Changed Rubric Switch: Boolean
  • Possible Score: Double
  • Average Score: Double
  • Strengths Summary: Memo
  • Developmental Areas Summary: Memo
  • Adjusted Average Score: Double
  • Reason for Score Adjustment: Text
  • Purple Panel Status ID: Long
  • Submitted: Boolean
  • SSMA_TimeStamp: Binary *
  • Panel Feedback to COO: Memo
  • Recommend Suitable Programme ID: Long
  • Recommended Programme NA: Boolean
  • EP Division ID: Long
  • EP Distribution Model ID: Long

Rubric Metric Templates

  • Rubric Metric Template ID: Long *
  • Rubric ID: Long
  • Metric ID: Long
  • Metric Weight: Double
  • SSMA_TimeStamp: Binary *

Rubrics

  • Rubric ID: Long *
  • Rubric (PK): Text
  • SSMA_TimeStamp: Binary *

Temp Individuals in a Company

  • Individuals: Text

Temp Purple Panelists Summary

  • Purple Panelist ID: Long *
  • Purple Panel ID: Long
  • Panelist Number: Long
  • Purple Panelist: Text
  • Business Area: Text
  • Purple Panelist Total Score: Double
  • Possible Total Score: Double
  • Convener: Boolean
  • Questions: Memo

Temp Rubric Metrics NOT in the List

  • Metric ID: Long
  • Metric: Memo
  • Metric Description: Memo
  • Metric Weight: Double
  • Sort Order: Long
  • Add it: Boolean

User Levels

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

vwGIACompanyList

  • Entrepreneur Company ID: Long *
  • Company Name: Text
  • Delivery Location: Text
  • Company Status ID: Long
  • Status: Text
  • Last Process Status ID: Long
  • Entrepreneur Status: Text
  • OwnedBy: Text
  • Delivery Location ID: Long

vwGIAEntrepreneurList

  • Entrepreneur Company ID: Long *
  • Entrepreneur ID: Long
  • First Name: Text
  • Surname: Text
  • Company Name: Text
  • Delivery Location: Text
  • Recommended Product: Text
  • Process Status ID: Long

zstblODBC_db

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

zstblODBC_tables

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