garnet - Technical Architecture
Data Model
Tables (106)
BBBEEPillarLookup
Primary Key: BBBEE
Fields: - BBBEE Pillar ID: Long - BBBEE Pillar Description: Text - BBBEE Pillar: Text
Channel Partners
Primary Key: Channel
Fields: - Channel Partner ID: Long - Channel Partner: Text - Active: Boolean - SSMA_TimeStamp: Binary
Client Tiers
Primary Key: Client
Fields: - Client Tier ID: Long - Client Tier: Text - Client Tier Range: Text
CompanyProgrammeYearStatus
Primary Key: Company
Fields: - Company Programme Year Status ID: Long - Programme Year Status: Text - Active: Boolean - Sort Order: Double - SSMA_TimeStamp: Binary
CompanyStatus
Primary Key: Company
Fields: - Company Status ID: Long - Status: Text - Active: Boolean - Sort Order: Double - SSMA_TimeStamp: Binary
ContractTypeLookup
Primary Key: Contract
Fields: - Contract Type ID: Long - Contract Type: Text
DatabaseUsers Module Permissions
Primary Key: Module
Fields: - Module Permission ID: Long - Username: Text - Module Permission: Text - LEVEL: Text - Role: Text
DatabaseUsers
Primary Key: Username
Fields: - User ID: Long - Username: Text (PK) - 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
Primary Key: Not defined
Fields: - Application: Memo - Version: Memo
dbo_ApplicationVersions1
Primary Key: Not defined
Fields: - Application: Memo - Version: Memo
Delivery Locations
Primary Key: Delivery
Fields: - 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
Primary Key: Distribution
Fields: - Distribution Model ID: Long - Distribution Model: Text - Distribution Model Code: Text - Active: Boolean - SSMA_TimeStamp: Binary
Divisions
Primary Key: Division
Fields: - Division ID: Long - Division: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary
Email Recipient List
Primary Key: Email
Fields: - Email Recipient ID: Long - Email Function Name: Text - Email Recipient: Text
EmailFunctionLookup
Primary Key: Email
Fields: - Email Function ID: Long - Email Function Name: Text
Entrepreneur Company Areas of Operation
Primary Key: Entrepreneur
Fields: - Entrepreneur Area of Operation ID: Long - Entrepreneur Company ID: Long - Area of Operation: Text
Entrepreneur Company Commodities
Primary Key: Entrepreneur
Fields: - Entrepreneur Company Commodity ID: Long - Entrepreneur Company ID: Long - Commodity: Text
Entrepreneur Company Extra Sponsor Elements
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - Entrepreneur Company Extra Sponsor Payment ID: Long - Entrepreneur Company Extra Sponsor Element ID: Long - Payment Date: DateTime - Payment Amount: Double
Entrepreneur Company Monthly Billings
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Entrepreneur
Fields: - Entrepreneur Edit ID: Long - Entrepreneur ID: Long - Modified By: Text - Date Modified: DateTime
Entrepreneur Notes
Primary Key: Entrepreneur
Fields: - Entrepreneur Note ID: Long - Entrepreneur ID: Long - Note Date: DateTime - Notes: Text
Entrepreneur Status History
Primary Key: Entrepreneur
Fields: - Entrepreneur Status ID: Long - Entrepreneur ID: Long - Process Status ID: Long - Process Status Notes: Text - Date Status Changed: DateTime - Status Modified By: Text
Entrepreneurs
Primary Key: Entrepreneur
Fields: - 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
Primary Key: Front
Fields: - Front End Version Number: Text - Contract Mail Merge File Name: Text - Notification File Name: Text - Certificate Mail Merge File Name: Text
IndustryLookup
Primary Key: Industry
Fields: - Industry ID: Long - Industry: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary - Blue Heart Pass at 45: Boolean
Lead Types
Primary Key: Lead
Fields: - 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
Primary Key: Month
Fields: - Month Number: Long - Month Name: Text - Last Day: Integer
NonGraduateReason
Primary Key: Non
Fields: - Non Graduate Reason ID: Long - Non Graduate Reason: Text
PrimaryTenants
Primary Key: ID
Fields: - ID: Long (PK) - PrimaryTenant: Text
Principal Project Pillar Commodities
Primary Key: Principal
Fields: - Principal Project Pillar Commodity ID: Long - Principal Project Pillar ID: Long - Commodity: Text
Principal Project Pillar Delivery Location
Primary Key: Principal
Fields: - Principal Project Pillar Delivery Location ID: Long - Principal Project Pillar ID: Long - Delivery Location: Text - Delivery Location Other: Text
Principal Project Pillar Sourced From
Primary Key: Principal
Fields: - Principal Project Pillar Source ID: Long - Principal Project Pillar ID: Long - Entrepreneur Sourced: Text
Principal Project Pillar Sponsor Elements
Primary Key: Principal
Fields: - 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
Primary Key: Principal
Fields: - 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
Primary Key: Principal
Fields: - 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
Primary Key: Principal
Fields: - Principal Project Product Sold ID: Long - Principal Project ID: Long - Product: Text
Principal Projects
Primary Key: Principal
Fields: - 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
Primary Key: Principal
Fields: - Principal Project Status ID: Long - Status: Text - Active: Boolean - Sort Order: Long - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
Principals
Primary Key: Principal
Fields: - Principal ID: Long - Second Principal ID: Long - First Principal ID: Long - Principal: Text (PK) - 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
Primary Key: Process
Fields: - 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
Primary Key: Product
Fields: - Product Distribution Model ID: Long - Product ID: Long - Distribution Model ID: Long
Product Divisions
Primary Key: Product
Fields: - Product Division ID: Long - Product ID: Long - Division ID: Long - BEE Certificate Required: Boolean - SSMA_TimeStamp: Binary
Products
Primary Key: Product
Fields: - Product ID: Long - Product: Text (PK) - 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
Primary Key: Programme
Fields: - Programme Year: Text - Sort Order: Long
ProgressCategory
Primary Key: Progress
Fields: - Progress Category ID: Long - Progress Category: Text - Sort Order: Long - Last Modified By: Text - Date Modified: DateTime
ReplacementStatusLookup
Primary Key: Replacement
Fields: - Replacement Status ID: Long - Replacement Status: Text
Report Writer Garnet Included Field Names
Primary Key: ID
Fields: - ID: Long (PK) - Description: Text - Include Field Name: Text - Sort Order: Long
Reporting Frequency
Primary Key: Reporting
Fields: - Reporting Frequency ID: Long - Reporting Frequency: Text - Reporting Frequency Description: Text
SecondaryTenants
Primary Key: ID
Fields: - ID: Long (PK) - SecondaryTenant: Text
SelectionFeeTypeLookup
Primary Key: Selection
Fields: - Selection Fee Type ID: Long - Selection Fee Type: Text
Sub Products
Primary Key: Sub
Fields: - Sub Product ID: Long - Sub Product: Text - BBBEE Pillar: Text - Frequency: Text - Active: Boolean - SSMA_TimeStamp: Binary
Temp Entrepreneur Companies for Opal Scorecard
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Recommended Product ID: Long
Temp Entrepreneur Company Monthly Billings
Primary Key: Not defined
Fields: - Entrepreneur Company Principal Project ID: Long - Principal Project Pillar ID: Long - Billing Amount: Double
Temp Entrepreneur ID for Contract Mail Merge
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - Principal Project ID: Long - Principal Project: Text - Total Spend: Double
TerminationReason
Primary Key: Termination
Fields: - 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
Primary Key: Unqualified
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - Company Status ID: Long - Company Delivery Location ID: Long - Number Active Companies: Long
vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Division ID: Long - Division: Text - Distribution Model ID: Long - Distribution Model: Text
vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - Principal Project ID: Long - NR Total Balance: Double
vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship
Primary Key: Not defined
Fields: - Principal Project ID: Long - Future Yr Total Sponsorship: Double
vwGarnetReportSumDeferredIncomeNGSelectionFeeandBilledDate
Primary Key: Not defined
Fields: - Principal Project ID: Long - NG Total Selection Fee: Double - NG Total Billed To Date: Double
vwGarnetReportSumDeferredIncomeOBBalance
Primary Key: Not defined
Fields: - Principal Project ID: Long - On P Blank Total Balance: Double
vwGarnetReportSumDeferredIncomeOGBSelectionFeeandBilledDate
Primary Key: Not defined
Fields: - Principal Project ID: Long - On P Grad Blank Total Sponsorship: Double - OGB Total Selection Fee: Double - OGB Total Billed To Date: Double
vwGarnetReportSumDeferredIncomeSEDSpend
Primary Key: Not defined
Fields: - Principal Project ID: Long - BBBEE Pillar: Text - SED Spend: Double
vwGarnetReportSumDeferredIncomeTotalSponsorshipNonGraduate
Primary Key: Not defined
Fields: - Principal Project ID: Long - NonGrad Total Sponsorship: Double
vwGarnetRptAllocationExportGraduatedCompanies
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - Principal Project ID: Long - Company Delivery Location ID: Long - Total Billed: Double
vwPurpleGetCurrentContractInfobyCompany
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: Not defined
Fields: - 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
Primary Key: DBID
Fields: - DBID: Long (PK) - SelectDB: Boolean - ServerName: Text - DBName: Text - Authentication: Text - UID: Text - PWD: Text - Driver: Text - DateAdded: DateTime
zstblODBC_tables
Primary Key: TableID
Fields: - TableID: Long (PK) - Link: Boolean - Hidden: Boolean - TableName: Text - SourceTableName: Text - AfterDDL: Text - Comment: Text - DateAdded: DateTime
Code Components
Modules (59)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Add and Edit Company Programme Year Status | Form | 20 | 1 |
| Form_Add and Edit Company Programme Year | Form | 151 | 9 |
| Form_Add and Edit Company Status | Form | 20 | 1 |
| Form_Add and Edit Entrepreneur Company Sub Products | Form | 23 | 2 |
| Form_Add and Edit Entrepreneur Company | Form | 54 | 3 |
| Form_Add and Edit Non Graduate Reason | Form | 70 | 3 |
| Form_Add and Edit Primary Tenant | Form | 60 | 3 |
| Form_Add and Edit Principal Project | Form | 39 | 3 |
| Form_Add and Edit Principal | Form | 29 | 3 |
| Form_Add and Edit Replacement Status | Form | 60 | 3 |
| Form_Add and Edit Secondary Tenant | Form | 60 | 3 |
| Form_Add Company Extra Sponsor Element | Form | 43 | 5 |
| Form_Add Company Monthly Billing | Form | 35 | 3 |
| Form_Certificate Mail Merge | Form | 301 | 6 |
| Form_Change Password | Form | 138 | 5 |
| Form_Company Add Allocation List | Form | 195 | 10 |
| Form_Company Graduating List | Form | 216 | 12 |
| Form_Company Ignition List | Form | 216 | 12 |
| Form_Company List | Form | 236 | 16 |
| Form_Company On Programme List | Form | 218 | 13 |
| Form_Company Raizcorpossible List | Form | 191 | 13 |
| Form_Contract Mail Merge | Form | 401 | 6 |
| Form_Delivery vs Exited Report Dialog | Form | 49 | 2 |
| Form_Edit Company Allocation | Form | 160 | 12 |
| Form_Edit Company Extra Sponsor Element | Form | 49 | 4 |
| Form_Edit Company Monthly Billing | Form | 25 | 2 |
| Form_Edit Company Programme Year Status | Form | 167 | 5 |
| Form_Edit Company Status | Form | 130 | 4 |
| Form_Edit Email Recipient List | Form | 62 | 4 |
| Form_Lump Sum Allocation Dialog | Form | 79 | 3 |
| Form_Lump Sum Allocation | Form | 246 | 6 |
| Form_Maintenance Menu | Form | 53 | 9 |
| Form_Monthly Billings Date Dialog | Form | 85 | 3 |
| Form_Monthly Billings Menu | Form | 30 | 3 |
| Form_Monthly Billings | Form | 203 | 7 |
| Form_Opal Scorecard Report Dialog | Form | 581 | 4 |
| Form_Opening Dialog | Form | 160 | 4 |
| Form_Part Sponsorship History Reports Date Dialog | Form | 50 | 3 |
| Form_Principal List | Form | 104 | 9 |
| Form_Principal Project List | Form | 183 | 15 |
| Form_Principal Project Status Report Dialog | Form | 45 | 3 |
| Form_Principal Report Date Dialog | Form | 61 | 4 |
| Form_Report Menu | Form | 728 | 37 |
| Form_Report Writer Dialog | Form | 321 | 7 |
| Form_Reports Date Dialog | Form | 56 | 2 |
| Form_Reports Print Export Dialog | Form | 44 | 2 |
| Form_View and Edit Monthly Billings | Form | 89 | 8 |
| Form_SubFrm Edit Company Principal Project | Form | 297 | 11 |
| Form_SubFrm Entrepreneur Company Areas of Operation | Form | 41 | 2 |
| Form_SubFrm Entrepreneur Company Commodities | Form | 41 | 2 |
| Form_SubFrm Entrepreneur Company Extra Sponsor Payments | Form | 22 | 1 |
| Form_SubFrm Principal Project Pillar Sponsor Elements | Form | 32 | 4 |
| Form_SubFrm Principal Project Pillar Sub Products | Form | 24 | 2 |
| Form_SubFrm Principal Project Pillars | Form | 50 | 2 |
| Form_SubFrm Total Billed To Date by Company PP | Form | 20 | 1 |
| basRelink | Standard | 604 | 7 |
| Mod Export Excel | Standard | 5938 | 22 |
| Mod Send Outlook Message | Standard | 53 | 1 |
| Mod Utilities | Standard | 140 | 8 |
Forms (64)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Add and Edit Company Programme Year Status | CompanyProgrammeYearStatus | 13 | Yes |
| Add and Edit Company Programme Year | Entrepreneur Company Programme Years | 63 | Yes |
| Add and Edit Company Status | CompanyStatus | 13 | Yes |
| Add and Edit Entrepreneur Company Sub Products | Entrepreneur Company Sub Products | 14 | Yes |
| Add and Edit Entrepreneur Company | Entrepreneur Company | 118 | Yes |
| Add and Edit Non Graduate Reason | NonGraduateReason | 11 | Yes |
| Add and Edit Primary Tenant | PrimaryTenants | 11 | Yes |
| Add and Edit Principal Project | Principal Projects | 55 | Yes |
| Add and Edit Principal | Principals | 34 | Yes |
| Add and Edit Replacement Status | ReplacementStatusLookup | 11 | Yes |
| Add and Edit Secondary Tenant | SecondaryTenants | 11 | Yes |
| Add Company Extra Sponsor Element | Entrepreneur Company Extra Sponsor Elements | 21 | Yes |
| Add Company Monthly Billing | Entrepreneur Company Monthly Billings | 24 | Yes |
| Certificate Mail Merge | Unbound | 13 | Yes |
| Change Password | Unbound | 19 | Yes |
| Company Add Allocation List | Unbound | 27 | Yes |
| Company Graduating List | DatabaseUsers | 32 | Yes |
| Company Ignition List | DatabaseUsers | 33 | Yes |
| Company List | Unbound | 41 | Yes |
| Company On Programme List | DatabaseUsers | 32 | Yes |
| Company Raizcorpossible List | Unbound | 33 | Yes |
| Contract Mail Merge | Unbound | 13 | Yes |
| Delivery vs Exited Report Dialog | Unbound | 12 | Yes |
| Edit Company Allocation | Entrepreneur Company | 38 | Yes |
| Edit Company Extra Sponsor Element | Entrepreneur Company Extra Sponsor Elements | 25 | Yes |
| Edit Company Monthly Billing | Entrepreneur Company Monthly Billings | 19 | Yes |
| Edit Company Programme Year Status | Unbound | 13 | Yes |
| Edit Company Status | Unbound | 11 | Yes |
| Edit Email Recipient List | Email Recipient List | 13 | Yes |
| Lump Sum Allocation Dialog | Unbound | 7 | Yes |
| Lump Sum Allocation | Unbound | 33 | Yes |
| Maintenance Menu | Unbound | 10 | Yes |
| Monthly Billings Date Dialog | Unbound | 7 | Yes |
| Monthly Billings Menu | Unbound | 4 | Yes |
| Monthly Billings | Unbound | 15 | Yes |
| Opal Scorecard Report Dialog | Unbound | 7 | Yes |
| Opening Dialog | Unbound | 14 | Yes |
| Part Sponsorship History Reports Date Dialog | Unbound | 6 | Yes |
| Principal List | Unbound | 13 | Yes |
| Principal Project List | Unbound | 34 | Yes |
| Principal Project Status Report Dialog | Unbound | 7 | Yes |
| Principal Report Date Dialog | Unbound | 10 | Yes |
| Report Menu | Unbound | 32 | Yes |
| Report Writer Dialog | Unbound | 22 | Yes |
| Reports Date Dialog | Unbound | 6 | Yes |
| Reports Print Export Dialog | Unbound | 7 | Yes |
| View and Edit Monthly Billings | Unbound | 14 | Yes |
| SubFrm Company Programme Year Status History | Entrepreneur Company Programme Year Status History | 10 | No |
| SubFrm Company Status History | Entrepreneur Company Status History | 10 | No |
| SubFrm Edit Company Principal Project | Entrepreneur Company Principal Projects | 46 | Yes |
| SubFrm Entrepreneur Company Areas of Operation | Entrepreneur Company Areas of Operation | 7 | Yes |
| SubFrm Entrepreneur Company Commodities | Entrepreneur Company Commodities | 7 | Yes |
| SubFrm Entrepreneur Company Extra Sponsor Payments | Entrepreneur Company Extra Sponsor Payments | 10 | Yes |
| SubFrm Entrepreneur Company Supporting Documents | Entrepreneur Company | 29 | No |
| SubFrm Entrepreneur Recommended Information | Qry Get Entrepreneur Recommended Information | 14 | No |
| SubFrm Principal Project Pillar Commodities | Principal Project Pillar Commodities | 6 | No |
| SubFrm Principal Project Pillar Delivery Location | Principal Project Pillar Delivery Location | 6 | No |
| SubFrm Principal Project Pillar Sourced From | Principal Project Pillar Sourced From | 6 | No |
| SubFrm Principal Project Pillar Sponsor Elements | Principal Project Pillar Sponsor Elements | 22 | Yes |
| SubFrm Principal Project Pillar Sub Products | Principal Project Pillar Sub Products | 14 | Yes |
| SubFrm Principal Project Pillar Supporting Documents | Qry SubFrm Principal Project Pillar Supporting Documents | 5 | No |
| SubFrm Principal Project Pillars | Principal Project Pillars | 35 | Yes |
| SubFrm Principal Project Products Sold | Principal Project Products Sold | 6 | No |
| SubFrm Total Billed To Date by Company PP | Qry Sum Total Billed by Company PP and Project Pillar | 5 | Yes |
Reports (12)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Report Delivery vs Exited Entrepreneurs | 2 |
| Calibri | Qry Report Principal Project Allocation Audit | 2 |
| Calibri | vwGarnetRptPrincipalProjectAllocation | 2 |
| Calibri | Qry Report Principal Quarterly Reports | 2 |
| Calibri | Qry Report Principal SD Letter New Allocation | 0 |
| Calibri | Qry Report SD Alocations Not Notified | 2 |
| Calibri | Qry SubRpt Companies in Principal SD Letter | 0 |
| Calibri | Qry Get Current Contract Info by Company | 0 |
| Calibri | Qry SubRpt Entrepreneurs in Principal SD Letter | 0 |
| Calibri | Qry SubRpt Principal Project Allocation Audit Replaced Companies | 0 |
| Calibri | Principal Project Pillars | 0 |
| Calibri | Principal Project Products Sold | 0 |
Queries (136)
| Query | Type | Tables |
|---|---|---|
| JB Check Company Allocations | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| JB Issue with Monthly Billings | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| JB Qry Reverse Sept Monthly Billings | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Add Allocation Principal Project List | Select | |
| Qry Application Versions | Select | dbo_ApplicationVersions |
| Qry Calcluate Extra Sponsor Element Amount Remaining | Select | Qry Sum Extra Sponsor Element Allocated, Principal |
| Qry Company Entrepreneur Ignition List | Select | vwGarnetCompanyEntrepreneurIgnitionList |
| Qry Company List | Select | vwGarnetCompanyList |
| Qry Company Lump Sum Allocation List | Select | Delivery Locations, Entrepreneur Company |
| Qry Company Monthly Billing List Temp | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Company Monthly Billing List | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Company Needs Replacement List | Select | SubQry Company Needs Replacement List, SubQry |
| Qry Company Principal Project List | Select | vwGarnetCompanyPrincipalProjectList, vwGarnetGetEPReadyforAllocationInfobyCompany |
| Qry Company Raizcorpossibles List | Select | vwGarnetCompanyRaizcorpossiblesList |
| Qry Count Active Allocated Companies by Principal Project Pillar | Select | Entrepreneur, Entrepreneur Company |
| Qry Count Companies by Principal Project Allocation Report | Select | Entrepreneur Company Programme Years, Principal |
| Qry Count Current Blank Year Companies by Principal Project | Select | Entrepreneur Company Programme Years, Principal |
| Qry Count Current Blank Year Entrepreneurs by Principal Project | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Count Current Future Year Companies by Principal Project | Select | Entrepreneur Company Programme Years, Principal |
| Qry Count Current Future Year Entrepreneurs by Principal Project | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Count Current Graduated Companies by Principal Project | Select | Entrepreneur Company Programme Years, Principal |
| Qry Count Current Graduated Entrepreneurs by Principal Project | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Count Current On Programme Companies by Principal Project | Select | Entrepreneur Company Programme Years, Principal |
| Qry Count Current On Programme EPs by Principal Project | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Count Exited Companies by Principal Project Pillar | Select | Entrepreneur, Entrepreneur Company |
| Qry Count Exited Need Replacement by Principal Project Pillar | Select | Entrepreneur, Entrepreneur Company |
| Qry Count Number Months Billed by Company PP and Project Pillar | Select | Entrepreneur, Entrepreneur Company Monthly Billings |
| Qry Count Principal Projects by Company | Select | Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Count Total Companies Allocated Lump Sum 1 Principal Project | Select | Principal Project Pillars, Entrepreneur |
| Qry Count Unallocated Companies by Principal Project Recommended | Select | |
| Qry Entrepreneur Company Extra Sponsor Amount List | Select | Qry Sum Extra Sponsor Element Payments by Company, Principal Project Pillars |
| Qry Entrepreneur Company Sub Products | Select | Entrepreneur, Sub Products |
| Qry Export Certificate Mail Merge Information | Select | Temp, Temp Entrepreneur ID for Contract Mail Merge |
| Qry Export Commitment Fee Information for Invoice | Select | SubQry Export Commitment Fee Information for Notification, Temp Entrepreneur ID for Contract Mail Merge |
| Qry Export Contract Mail Merge Information | Select | vwGarnetExportEntrepreneurInformationforContractMailMerge, Temp Entrepreneur ID for Contract Mail Merge |
| Qry Get Amount Remaining by Principal Project Pillar | Select | Principal, Principal Project Pillars |
| Qry Get Companies for Certificate Mail Merge | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Companies for Lump Sum Allocation | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Current Contract Info by Company | Select | |
| Qry Get Division Dist Model and Rec Info by Company | Select | Entrepreneurs |
| Qry Get Entrepreneur Recommended Information | Select | Entrepreneurs, Principal Projects |
| Qry Get Entrepreneur Sourced From by Principal Project | Select | Principal Project Pillars, Principal Project Pillar Sourced From |
| Qry Get Entrepreneurs for Contract Mail Merge | Select | Entrepreneurs, Entrepreneur Company Programme Years |
| Qry Get Last Billing Date by EP Company Principal Project | Select | Entrepreneur, Entrepreneur Company Monthly Billings |
| Qry Get Last Note by Entrepreneur | Select | |
| Qry Get Last Note Date by Entrepreneur | Select | Entrepreneur Notes, Entrepreneur |
| Qry Get Last Programme Year ID by Company | Select | Entrepreneur, Entrepreneur Company Programme Years |
| Qry Get Last Programme Year Info by Company | Select | Entrepreneur Company Programme Years, NonGraduateReason |
| Qry Get Last Programme Year Info for Report Writer | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Get Monthly Billing Information | Select | Entrepreneur Company Programme Years, Qry Sum Total Billed by Company PP and Project Pillar |
| Qry Get Principal Projects for Finance Audit Report | Select | Qry, Qry Count Total Companies Allocated Lump Sum 1 Principal Project |
| Qry Get Principal Projects for Finance Report | Select | SubQry Get Principal Projects for Finance Report, Qry Sum Total Spend by Principal Project |
| Qry Opal Scorecard Count Companies by Pgm Yr Status Not On Pgm | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Eligible for Graduation All Products | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Graduated Off D | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Graduated Off E | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Graduated Off M | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Graduated On E | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Graduated On M | Select | |
| Qry Opal Scorecard Count Total D Eligible for Graduation | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Total E Eligible for Graduation | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Total Eligible for Graduation | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Count Total M Eligible for Graduation | Select | SubQry, SubQry Opal Scorecard Source |
| Qry Opal Scorecard Get Active Companies Continued | Select | Entrepreneurs, Entrepreneur Company Status History |
| Qry Opal Scorecard Get Active Companies New | Select | Entrepreneurs, Entrepreneur Company Status History |
| Qry Opal Scorecard Get Active Companies Stopped | Select | SubQry, Entrepreneur Company |
| Qry Opal Tag Programme Yr and Eligible for Graduation | Select | Entrepreneur, Entrepreneur Company |
| Qry Principal List | Select | Principals |
| Qry Principal Project List Allocation | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Principal Project List Main Dashboard | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Principal Project List | Select | Qry Sum Total Billed by Principal Project, Principals |
| Qry Principal Project Pillar List | Select | Principal Project Pillars, Principals |
| Qry Principal Project Sub Products | Select | Principal Project Pillar Sub Products, Principal Project Pillars |
| Qry Report Active Companies Email | Select | Entrepreneurs, Entrepreneur Company |
| Qry Report Active Entrepreneurs by Delivery Location | Select | vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation, vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation |
| Qry Report Companies Allocated Date Range | Select | vwGarnetReportCompaniesAllocated |
| Qry Report Companies Left Programme Date Range | Select | vwGarnetReportCompaniesLeftProgramme |
| Qry Report Companies Needs Replacement | Select | |
| Qry Report Companies Started Programme Date Range | Select | vwGarnetReportCompaniesStartedProgramme |
| Qry Report Company Totals by Delivery Location | Select | vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects |
| Qry Report Delivery vs Exited Entrepreneurs Summary | Select | Qry Report Delivery vs Exited Entrepreneurs, Qry |
| Qry Report Delivery vs Exited Entrepreneurs | Select | |
| Qry Report Number Companies Ignited by Product | Select | Entrepreneur, Entrepreneur Company Programme Years |
| Qry Report Part Sponsorship Entrepreneurs | Select | vwPurpleReportPartSponsorshipEntrepreneurs |
| Qry Report Part Sponsorship History | Select | vwGarnetRptPartSponsorshipHistory |
| Qry Report Part Sponsorship | Select | SubQry, SubQry Rpt Part Sponsorship |
| Qry Report Principal Project Allocation Audit | Select | vwGarnetRptPrincipalProjectAllocationAudit, Qry Sum Total Spend by Principal Project |
| Qry Report Principal Project Allocation for Finance Blank Year | Select | Qry Count Current Blank Year Companies by Principal Project, Qry Count Current Blank Year Entrepreneurs by Principal Project |
| Qry Report Principal Project Allocation for Finance Future Year | Select | Qry Count Current Future Year Entrepreneurs by Principal Project, Qry Sum Total Billed by Company PP and Project Pillar |
| Qry Report Principal Project Allocation for Finance Graduated | Select | Qry Count Current Graduated Entrepreneurs by Principal Project, Qry Sum Total Billed by Company PP and Project Pillar |
| Qry Report Principal Project Allocation for Finance Nongraduate | Select | Qry Sum Total Billed by Company PP and Project Pillar, vwGarnetRptPrincipalProjectAllocationforFinance |
| Qry Report Principal Project Allocation for Finance On Programme | Select | Qry Count Current On Programme EPs by Principal Project, Qry Sum Total Billed by Company PP and Project Pillar |
| Qry Report Principal Project Product Totals by Delivery Location | Select | SubQry Sum Current On Prog by Prosperator Principal Proj Product, SubQry |
| Qry Report Principal Project Totals by Delivery Location | Select | vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects, SubQry |
| Qry Report Principal Quarterly Reports | Select | vwGarnetRptPrincipalQuarterlyReports |
| Qry Report Principal SD Letter New Allocation | Select | DatabaseUsers, Principals |
| Qry Report RAG | Select | vwPurpleReportRAG, SubQry Sum Total Replaced Billed to Date by Prin Project Pillar |
| Qry Report Raizcorp Possibilities | Select | vwPurpleReportRaizcorpPossibilities, ProcessStatus |
| Qry Report Raizcorpossible Companies Email | Select | Entrepreneurs, Entrepreneur Company |
| Qry Report SD Alocations Not Notified | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry Report Summarised Deferred Income | Select | vwGarnetReportSumDeferredIncomeOBBalance, Temp Principal Projects for Finance Report |
| Qry Report Writer | Select | Entrepreneurs, IndustryLookup |
| Qry SubFrm Principal Project Pillar Supporting Documents | Select | Principal Project Pillars, Principal |
| Qry SubRpt Companies in Principal SD Letter | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry SubRpt Entrepreneurs in Principal SD Letter | Select | Entrepreneurs |
| Qry SubRpt Principal Project Allocation Audit Replaced Companies | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| Qry SubRpt Principal Project Pillar Delivery Locations | Select | Delivery Locations, Principal Project Pillar Delivery Location |
| Qry Sum Extra Sponsor Element Allocated | Select | Entrepreneur Company Extra Sponsor Elements, Entrepreneur |
| Qry Sum Extra Sponsor Element Payments by Company | Select | Entrepreneur, Entrepreneur Company Extra Sponsor Payments |
| Qry Sum Replacement Amount Allocated by Replacement For | Select | Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Sum Total Allocated Amt by Company | Select | Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Sum Total Billed by Company and Project Pillar | Select | Entrepreneur, Entrepreneur Company Programme Years |
| Qry Sum Total Billed by Company PP and Project Pillar | Select | Entrepreneur, Entrepreneur Company Programme Years |
| Qry Sum Total Billed by Principal Project | Select | Principal Project Pillars, Entrepreneur |
| Qry Sum Total Spend by Principal Project | Select | Principal Project Pillars, Principal |
| Qry Sum Total Sponsorship by Principal Project Pillar | Select | Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Update Certificate Printed Box | Update | Entrepreneur Company Programme Years, Temp Entrepreneur ID for Contract Mail Merge |
| Qry Update Commitment Fee Invoiced Box | Update | Entrepreneur Company Programme Years, Temp Entrepreneur ID for Contract Mail Merge |
| Qry Update Contract Printed Box | Update | Entrepreneur Company Principal Projects, Temp Entrepreneur ID for Contract Mail Merge |
| Qry Update SD Alocations Notified | Update | Qry Report SD Alocations Not Notified, Qry |
| qryLinkODBC | Select | zstblODBC_db, zstblODBC_tables |
| SubQry Company Needs Replacement List | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| SubQry Export Commitment Fee Information for Notification | Select | Entrepreneur Company Programme Years, Delivery Locations |
| SubQry Get Principal Projects for Finance Report | Select | |
| SubQry Opal Scorecard Get Active Companies Stopped | Select | Entrepreneurs, Entrepreneur Company Status History |
| SubQry Opal Scorecard Source | Select | Entrepreneur Company Programme Years, NonGraduateReason |
| SubQry Rpt Companies Needs Replacement | Select | Entrepreneur Company Programme Years, Principal Project Pillars |
| SubQry Rpt Delivery vs Exited Entrepreneurs | Select | Entrepreneur, Entrepreneur Company Status History |
| SubQry Rpt EP Counts by Principal Project Delivery Location | Select | vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects |
| SubQry Rpt EP Names by Company by Delivery Location | Select | vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects |
| SubQry Rpt Part Sponsorship History | Select | Entrepreneur Company Programme Years, Entrepreneurs |
| SubQry Rpt Part Sponsorship | Select | Qry Sum Total Allocated Amt by Company, Qry |
| SubQry Rpt Principal Project Allocation for Finance Criteria | Select | Entrepreneur Company Programme Years, Principal |
| SubQry Sum Current On Prog by Prosperator Principal Proj Product | Select | vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit, vwGarnetSumTotalBilledbyPrincipalProjectDeliveryLocation |
| SubQry Sum Total Replaced Billed to Date by Prin Project Pillar | Select | Entrepreneur Company Programme Years, Entrepreneur Company |
| SubQry Sum Total Replaced Selection Fee by Prin Project Pillar | Select | Entrepreneur, Entrepreneur Company |