Skip to content

Data Dictionary

BBBEEPillarLookup

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

Candidates Sourced From LkUp

  • Candidates Sourced From ID: Long *
  • Candidates Sourced From: Text

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 *

Contract Type LkUp

  • 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

Delivery Locations Sales

  • Delivery Location ID: Long *
  • Delivery Location: Text
  • Distribution Model ID: Long

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

Extra Sponsor Element Lookup

  • Extra Sponsor Element ID: Long *
  • Extra Sponsor Element: Text
  • Admin Fee: Double

General Gateway

  • Front End Version Number: Text *

IndustryLookup

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

IndustryLookupSales

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

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

  • Principal Contact ID: Long *
  • Principal ID: Long
  • Contact Type ID: Long
  • Contact First Name: Text
  • Contact Surname: Text
  • Contact Position: Text
  • Contact Email: Text
  • Contact Phone: Text
  • Contact Cell Phone: Text
  • VA Pack Addressee: Boolean

Principals Sales

  • Principal ID: Long *
  • Principal (PK): Text
  • Physical Address 1: Text
  • Physical Address 2: Text
  • Physical Address 3: Text
  • Physical Address 4: Text
  • Company Website: Text
  • Industry ID: Long
  • Industry Charter: Text
  • Financial Year End: Text
  • Client Tier ID: Long
  • Sales Force Principal ID: Text

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

Products Sales

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

ReplacementStatusLookup

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

Reporting Frequency

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

Sales Brief Contract Numbers

  • Sales Brief Contract Numbers ID: Long *
  • Sales Brief ID: Long
  • Contract Number: Text

Sales Brief Extra Sponsor Elements

  • Sales Brief Extra Sponsor Elements ID: Long *
  • Sales Brief ID: Long
  • BBBEE Pillar: Text
  • 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

Sales Brief Revision Edit History

  • Sales Brief Edit ID: Long *
  • Sales Brief ID: Long
  • Field Modified: Text
  • Modified By: Text
  • Date Modified: DateTime

Sales Brief Selection Marketing Candidates Sourced From

  • Candidates Sourced From ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Candidates Sourced From: Text

Sales Brief Selection Marketing Commodities

  • Sales Brief Selection Marketing Commodity ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Commodity: Text

Sales Brief Selection Marketing Products

  • Sales Brief Selection Marketing Products ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Product ID: Long
  • Sponsorship Amount: Double
  • SSMA_TimeStamp: Binary *
  • Sales Brief ID: Long
  • BBBEE Pillar: Text

Sales Brief Selection Marketing Sourced From

  • Sales Brief Selection Marketing Companies Sourced From ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Delivery Location ID: Long
  • Delivery Location Other: Text
  • SSMA_TimeStamp: Binary

Sales Brief Selection Marketing

  • Sales Brief Selection Marketing ID: Long *
  • Sales Brief ID: Long
  • BBBEE Pillar: Text
  • DELETE Product ID: Long
  • DELETE Sponsorship Amount: Double
  • Minimum Companies Required: Long
  • 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
  • Principal Approve Candidate Leads: Long
  • Principal Approve Candidate: Long
  • Cohort Ignition Qtr: Text
  • Cohort Ignition Year: Long
  • 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
  • SSMA_TimeStamp: Binary *
  • Supporting Doc Employee Contract: Boolean

Sales Brief Sub Products

  • Sales Brief Sub Product ID: Long *
  • Sales Brief ID: Long
  • BBBEE Pillar: Text
  • Sub Product ID: Long
  • Sponsorship Amount: Double
  • Number of Entrepreneurs: Long
  • Frequency: Text
  • SSMA_TimeStamp: Binary

Sales Brief

  • Sales Brief ID: Long *
  • Sales Brief Number: Text
  • Version Number: Double
  • Been Through Gateway: Boolean
  • Been Revised: Boolean
  • Date Created: DateTime
  • Sales Brief Status ID: Long
  • Date Status Changed: DateTime
  • Status Modified By: Text
  • Solutions Architect: Text
  • Key Account Manager: Text
  • Sales Manager: Text
  • Principal ID: Long
  • Contract Type: Text
  • Contract Duration: Text
  • Contract Duration Other: Text
  • How Lead Generated: Text
  • Channel Partner: Text
  • Client (Lead Generated): Text
  • Conference (Lead Generated): Text
  • Solution Architect (Lead Generated): Text
  • Marketing Campaign (Lead Generated): Text
  • Which Database (Lead Generated): Text
  • Raizcorp Management (Lead Generated): Text
  • Lead Report Frequency: Text
  • Verification Agency Name: Text
  • Principal Verified Date: DateTime
  • VA Pack Date: DateTime
  • Non Standard Bookkeeping Process: Long
  • Efficacy Non Standard Elements: Long
  • Standard Ignition Apply: Long
  • Ignition Description: Text
  • Reporting Frequency ID: Long
  • Additional Marketing Costs: Double
  • Standard Marketing Budget: Double
  • Total Stipend Costs: Double
  • Funding Fee Percentage: Double
  • Funding Fee Added to Programme Fee: Long
  • Funding Notes: Text
  • Contract Payment Terms: Text
  • Invoice Day of Month: Text
  • Invoice Day of Month Other: Text
  • Once Off Invoice Date: DateTime
  • Entity Contracted: Text
  • Channel Partner Percentage: Double
  • Channel Partner Approved: Long
  • Channel Partner Approver: Text
  • Notes: Memo
  • Modified By: Text
  • Date Modified: DateTime
  • SSMA_TimeStamp: Binary *
  • Pricing Mode: Long
  • Contract Start Date: DateTime
  • Contract End Date: DateTime
  • Date Principal Needs Spend: DateTime
  • Procurement Commit to Meeting: Long
  • Project: Text
  • Special Negotiated Price Notes: Text
  • Contract FYE: Text
  • Verification Year: Long

SelectionFeeTypeLookup

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

Sub Products Sales

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

Sub Products

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

Temp Principal Project Pillar Extra Information

  • Temp ID: Long
  • BBBEE Pillar: Text
  • Entrepreneur Delivery Date: DateTime
  • Lump Sum Allocation: Boolean
  • Scout: Text
  • Sales Brief Selection Marketing ID: Long
  • Principal Project Pillar 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 *