amber - Technical Architecture
Data Model
Tables (44)
Amber Distribution Models
Primary Key: Amber
Fields: - Amber Distribution Models ID: Long - Distribution Model ID: Long
Amber Products
Primary Key: Amber
Fields: - Amber Products ID: Long - Product ID: Long
Archive Entrepreneur Company Pre Ignition Financials
Primary Key: Pre
Fields: - Pre Ignition ID: Long - Entrepreneur Company ID: Long - Date Created: DateTime - Submission Month: Text - Submission Year: Long - Bookkeeper: Text - Turnover: Double - Cost of Sales: Double - Direct Labour Costs: Double - Expenses Salary: Double - Other Income: Double - Salaries: Double - Net Asset Value: Double - Directors: Long - Permanent Staff: Long - Contract Staff: Long - SSMA_TimeStamp: Binary
Archive Submissions Financial Data Edit History
Primary Key: Submission
Fields: - Submission Edit History ID: Long - Entrepreneur Company ID: Long - Record Type: Text - Field Modified: Text - New Value: Double - Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
Archive Submissions Principal Spend
Primary Key: Principal
Fields: - Principal Spend ID: Long - Submission ID: Long - Entrepreneur Company Principal Project ID: Long - Principal Spend: Double - SSMA_TimeStamp: Binary
Archive Submissions Status History
Primary Key: Submission
Fields: - Submission Status History ID: Long - Submission ID: Long - Submission Status ID: Long - Submission Status Notes: Text - Date Status Changed: DateTime - Status Modified By: Text
Archive Submissions
Primary Key: Submission
Fields: - Submission ID: Long - Entrepreneur Company ID: Long - Date Created: DateTime - Date Books Submitted: DateTime - Submission Month: Text - Submission Year: Long - Bookkeeper: Text - Submission Status ID: Long - Submission Status Notes: Text - Quality Score: Double - Reviewed by Guide: Boolean - Turnover: Double - Cost of Sales: Double - Direct Labour Costs: Double - Expenses Salary: Double - Other Income: Double - Salaries: Double - Net Asset Value: Double - Directors: Long - Permanent Staff: Long - Contract Staff: Long - Date Status Changed: DateTime - Status Modified By: Text - SSMA_TimeStamp: Binary
BookkeeperAssignedDeliveryLocations
Primary Key: Assigned
Fields: - Assigned Delivery Location ID: Long - Username: Text - Delivery Location ID: Long
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
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
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
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 Pre Ignition Financials
Primary Key: Pre
Fields: - Pre Ignition ID: Long - Entrepreneur Company ID: Long - Date Created: DateTime - Submission Month: Text - Submission Year: Long - Bookkeeper: Text - Turnover: Double - Cost of Sales: Double - Direct Labour Costs: Double - Expenses Salary: Double - Other Income: Double - Salaries: Double - Net Asset Value: Double - Directors: Long - Permanent Staff: Long - Contract Staff: Long - 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 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
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
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 Amber
Primary Key: Front
Fields: - Front End Version Number: Text - Financial Import File Location: Text
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
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 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
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
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
Submission Status
Primary Key: Submission
Fields: - Submission Status ID: Long - Submission Status: Text - Own Bookkeeper Only: Boolean - Sort Order: Long - Active: Boolean - SSMA_TimeStamp: Binary
Submissions Financial Data Edit History
Primary Key: Submission
Fields: - Submission Edit History ID: Long - Entrepreneur Company ID: Long - Record Type: Text - Field Modified: Text - New Value: Double - Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
Submissions Principal Spend
Primary Key: Principal
Fields: - Principal Spend ID: Long - Submission ID: Long - Entrepreneur Company Principal Project ID: Long - Principal Spend: Double - SSMA_TimeStamp: Binary
Submissions Status History
Primary Key: Submission
Fields: - Submission Status History ID: Long - Submission ID: Long - Submission Status ID: Long - Submission Status Notes: Text - Date Status Changed: DateTime - Status Modified By: Text - SSMA_TimeStamp: Binary
Submissions
Primary Key: Submission
Fields: - Submission ID: Long - Entrepreneur Company ID: Long - Date Created: DateTime - Date Books Submitted: DateTime - Submission Month: Text - Submission Year: Long - Bookkeeper: Text - Submission Status ID: Long - Submission Status Notes: Text - Quality Score: Double - Reviewed by Guide: Boolean - Turnover: Double - Cost of Sales: Double - Direct Labour Costs: Double - Expenses Salary: Double - Other Income: Double - Salaries: Double - Net Asset Value: Double - Directors: Long - Permanent Staff: Long - Contract Staff: Long - Date Status Changed: DateTime - Status Modified By: Text - SSMA_TimeStamp: Binary - YTD Turnover: Double - YTD Cost of Sales: Double - YTD Direct Labour Costs: Double - YTD Expenses Salary: Double - YTD Other Income: Double - YTD Salaries: Double - YTD Net Asset Value: Double - Issue New Permanent Staff: Boolean - Issue YTD Does Not Match: Boolean
Temp Companies Principal Projects
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Entrepreneur Company Principal Project ID: Long - Company Total: Double
Temp Compliance by Company
Primary Key: Not defined
Fields: - Delivery Location ID: Long - Delivery Location: Text - RC Bookkeeper Assigned: Text - Entrepreneur Company ID: Long - Company Name: Text - Their Own Bookkeeper: Text - SubmissionDate: DateTime - Submission Status: Text - Issue New Permanent Staff: Boolean - Issue YTD Does Not Match: Boolean
Temp Month Year
Primary Key: Month
Fields: - Month Year ID: Long - Crit Submission Month: Text - Crit Submission Year: Long
Temp Principal Spend
Primary Key: Temp
Fields: - Temp ID: Long - Principal Spend ID: Long - Submission ID: Long - Entrepreneur Company Principal Project ID: Long - Principal Spend: Double - Delete it: Boolean
vwAmberCompanyList
Primary Key: Not defined
Fields: - Company Programme Year Status ID: Long - Distribution Model ID: Long - Company Status ID: Long - Entrepreneur Company ID: Long - Company Name: Text - Programme Year: Text - Product: Text - Delivery Location: Text - RC Bookkeeper Assigned: Text - Own Bookkeeper: Boolean - Last Ignition Date: DateTime - Last Complete Submission Month: Text - Last Complete Submission Year: Long - Last Submission Month: Text - Last Submission Year: Long
vwAmberCompanySubmissionList
Primary Key: Not defined
Fields: - Company Programme Year Status ID: Long - Company Status ID: Long - Entrepreneur Company ID: Long - Company Name: Text - Programme Year: Text - Product: Text - Delivery Location: Text - RC Bookkeeper Assigned: Text - Own Bookkeeper: Boolean - Last Ignition Date: DateTime - Last Status Change: DateTime - Submission Status: Text - Last Submission Month: Text - Last Submission Year: Long
vwAmberGetCompaniesNotNonGraduate
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Company Delivery Location ID: Long - Company Status ID: Long - Company Name: Text - Own Bookkeeper: Boolean - Date RC Bookkeeper Assigned: DateTime - RC Bookkeeper Assigned: Text - Company Programme Year Status ID: Long
vwAmberLastSubmissionIDbyCompany
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Last Submission ID: Long
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 (34)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Backdoor Frm Add and Edit Financial Data | Form | 196 | 16 |
| Form_Backdoor Frm Add and Edit Pre Ignition Financials | Form | 124 | 4 |
| Form_Backdoor Frm Company List | Form | 120 | 13 |
| Form_Add and Edit Amber Distribution Models | Form | 56 | 3 |
| Form_Add and Edit Amber Products | Form | 56 | 3 |
| Form_Add and Edit Bookkeeper Assigned Delivery Locations | Form | 56 | 3 |
| Form_Add and Edit Pre Ignition Financials | Form | 179 | 4 |
| Form_Add and Edit Submission Status | Form | 35 | 2 |
| Form_Add Submission | Form | 79 | 4 |
| Form_Alerts List | Form | 20 | 1 |
| Form_Archive Submissions Dialog | Form | 215 | 3 |
| Form_Assign Bookkeeper | Form | 74 | 6 |
| Form_Change Password | Form | 138 | 5 |
| Form_Company List | Form | 318 | 21 |
| Form_Edit Financial Data | Form | 556 | 24 |
| Form_Edit Submission | Form | 340 | 22 |
| Form_ESD Report Principal Project Dialog | Form | 44 | 3 |
| Form_Maintenance Menu | Form | 40 | 6 |
| Form_Opening Dialog | Form | 125 | 5 |
| Form_Report Menu | Form | 120 | 18 |
| Form_Reports Bookkeeper Dialog | Form | 42 | 2 |
| Form_Reports Books Not Submitted Dialog | Form | 60 | 3 |
| Form_Reports Company Dialog | Form | 42 | 2 |
| Form_Reports Date Dialog | Form | 85 | 3 |
| Form_Reports Delivery Location Company Month Year Dialog | Form | 111 | 6 |
| Form_Reports Delivery Location Dialog | Form | 42 | 2 |
| Form_Reports Month Year Dialog | Form | 70 | 3 |
| Form_Reports Principal Project Dialog | Form | 41 | 3 |
| Form_Reports Year Dialog | Form | 48 | 2 |
| Form_SubFrm Submission Principal Spend | Form | 39 | 4 |
| basRelink | Standard | 604 | 7 |
| Mod Export to Excel | Standard | 2632 | 14 |
| Mod Import Excel | Standard | 183 | 1 |
| Mod Utilities | Standard | 158 | 9 |
Forms (31)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Backdoor Frm Add and Edit Financial Data | Unbound | 53 | Yes |
| Backdoor Frm Add and Edit Pre Ignition Financials | Unbound | 55 | Yes |
| Backdoor Frm Company List | Unbound | 22 | Yes |
| Add and Edit Amber Distribution Models | Amber Distribution Models | 11 | Yes |
| Add and Edit Amber Products | Amber Products | 11 | Yes |
| Add and Edit Bookkeeper Assigned Delivery Locations | BookkeeperAssignedDeliveryLocations | 13 | Yes |
| Add and Edit Pre Ignition Financials | Unbound | 55 | Yes |
| Add and Edit Submission Status | Submission Status | 16 | Yes |
| Add Submission | Unbound | 19 | Yes |
| Alerts List | Unbound | 9 | Yes |
| Archive Submissions Dialog | Unbound | 9 | Yes |
| Assign Bookkeeper | Entrepreneur Company | 30 | Yes |
| Change Password | Unbound | 19 | Yes |
| Company List | Unbound | 39 | Yes |
| Edit Financial Data | Unbound | 87 | Yes |
| Edit Submission | Unbound | 25 | Yes |
| ESD Report Principal Project Dialog | Unbound | 8 | Yes |
| Maintenance Menu | Unbound | 6 | Yes |
| Opening Dialog | Unbound | 14 | Yes |
| Report Menu | Unbound | 15 | Yes |
| Reports Bookkeeper Dialog | Unbound | 6 | Yes |
| Reports Books Not Submitted Dialog | Unbound | 14 | Yes |
| Reports Company Dialog | Unbound | 5 | Yes |
| Reports Date Dialog | Unbound | 7 | Yes |
| Reports Delivery Location Company Month Year Dialog | Unbound | 18 | Yes |
| Reports Delivery Location Dialog | Unbound | 6 | Yes |
| Reports Month Year Dialog | Unbound | 14 | Yes |
| Reports Principal Project Dialog | Unbound | 5 | Yes |
| Reports Year Dialog | Unbound | 9 | Yes |
| SubFrm Submission Principal Spend | SELECT [Temp Principal Spend].[Temp ID], [Temp Principal Spend].[Principal Spend | 6 | Yes |
| SubFrm Submission Status History | Submissions Status History | 13 | No |
Reports (13)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Report Bookkeeper Tracker | 2 |
| Calibri | Qry Report Bookkeeping Compliance All Delivery Locations | 2 |
| Calibri | Qry Report Bookkeeping Compliance by Delivery Location | 2 |
| Calibri | Qry Report Books Not Submitted Both Bookkeepers | 2 |
| Calibri | Qry Report Books Not Submitted Raizcorp Bookkeeper | 2 |
| Calibri | Qry Report Companies Assigned | 2 |
| Calibri | Qry Report Current Escalated to PM | 2 |
| Calibri | Qry Report Current Outstanding Submissions | 2 |
| Calibri | Qry Report Current Queries with Entrepreneurs | 2 |
| Calibri | Qry Report Principal Spend by Delivery Location | 2 |
| Calibri | Qry Report Principal Spend by Company | 2 |
| Calibri | Qry Report Submission Detail by Company | 2 |
| Calibri | Qry SubRpt Submission Status History | 0 |
Queries (89)
| Query | Type | Tables |
|---|---|---|
| Backdoor Qry Company List | Select | Entrepreneur, Entrepreneur Company |
| JB Initialize Company Added New Staff | Update | Submissions |
| Qry Assigned Companies with No Submissions | Select | Submissions, Entrepreneur |
| Qry Company List | Select | MonthLkUp, vwAmberCompanyList |
| Qry Company Submission List | Select | vwAmberCompanySubmissionList, MonthLkUp |
| Qry Count Companies Assigned by Bookkeeper | Select | Qry Report Companies Assigned, Qry |
| Qry Count ED or SD Companies Bought From by Principal Project | Select | by, SubQry Count ED or SD Companies Bought From by Principal Project |
| Qry Count Number ED Allocated by Principal Project Pillar | Select | Entrepreneur Company Principal Projects, Principal |
| Qry Count Number SD Allocated by Principal Project Pillar | Select | Entrepreneur Company Principal Projects, Principal |
| Qry Count Pre-Ignition Financial Entries by Company | Select | Entrepreneur Company Pre Ignition Financials, Entrepreneur |
| Qry Count Submission Financial Complete Entries by Company | Select | Submissions |
| Qry Get Companies Assigned Both Bookkeepers | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| Qry Get Companies Assigned Raizcorp Bookkeeper | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| Qry Get Companies for Principal Spend Tracking Report | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Companies Not Non Graduate | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Delivery Locations for Bookkeeping Compliance Report | Select | Delivery Locations, Entrepreneur Company |
| Qry Get Financial Information by Month Number | Select | Submissions, MonthLkUp |
| Qry Get Highest Permanent Staff Number | Select | Submissions |
| Qry Get Last Complete Submission by Company | Select | Submissions, Qry Get Last Complete Submission ID by Company |
| Qry Get Last Complete Submission ID by Company | Select | Submissions, MonthLkUp |
| Qry Get Last Ignition Date by Company | Select | Entrepreneur, Entrepreneur Company Programme Years |
| Qry Get Last Month Principal Spend YTD | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Last Pre-Ignition Job Entry by Company | Select | Qry, Entrepreneur Company Pre Ignition Financials |
| Qry Get Last Pre-Ignition Month Name Year by Company | Select | Qry Get Last Pre-Ignition Month Year by Company, MonthLkUp |
| Qry Get Last Pre-Ignition Month Year by Company | Select | Entrepreneur Company Pre Ignition Financials, Entrepreneur |
| Qry Get Last Programme Year ID by Company | Select | Entrepreneur, Entrepreneur Company Programme Years |
| Qry Get Last Programme Year Pillar by Principal Project | Select | Principal Project Pillars, Entrepreneur Company Programme Years |
| Qry Get Last Status Change by Company | Select | Submissions, Entrepreneur |
| Qry Get Last Submission ID by Company | Select | Submissions |
| Qry Get Last Submission Job Entry by Company | Select | |
| Qry Get Months Included Financial Detail | Select | Qry Report Financial Detail, Qry |
| Qry Get Permanent Staff Numbers by Submission Date | Select | Submissions, MonthLkUp |
| Qry Get Principal Projects for Principal Spend Tracking Report | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Principal Projects for Purchased ED vs SD Report | Select | Entrepreneur, Entrepreneur Company |
| Qry Get Principal Spend by Submission Date | Select | Principal Project Pillars, MonthLkUp |
| Qry Populate Temp Compliance by Company | Delete | Delivery Locations, Qry Get Companies Not Non Graduate |
| Qry Pre Ignition List | Select | Entrepreneur Company Pre Ignition Financials, Entrepreneur |
| Qry Report Bookkeeper Tracker | Select | Qry Count Companies Assigned by Bookkeeper, SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper |
| Qry Report Bookkeeping Compliance All Delivery Locations | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| Qry Report Bookkeeping Compliance by Company | Select | Temp, Temp Compliance by Company |
| Qry Report Bookkeeping Compliance by Delivery Location | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| Qry Report Books Not Submitted Both Bookkeepers | Select | SubQry, Qry Get Companies Assigned Both Bookkeepers |
| Qry Report Books Not Submitted Raizcorp Bookkeeper | Select | Qry, Qry Get Companies Assigned Raizcorp Bookkeeper |
| Qry Report Companies Assigned | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| Qry Report Current Escalated to PM | Select | Submissions, Qry Get Companies Not Non Graduate |
| Qry Report Current Outstanding Submissions | Select | Submissions, Qry Get Companies Not Non Graduate |
| Qry Report Current Queries with Entrepreneurs | Select | Submissions, Qry Get Companies Not Non Graduate |
| Qry Report ESD ESD Update Tab | Select | Qry Sum Total Allocated by Entrepreneur Programme Year, Entrepreneur |
| Qry Report ESD Exits and Replacements Tab | Select | NonGraduateReason, CompanyProgrammeYearStatus |
| Qry Report ESD Futures Tab | Select | Entrepreneurs, Entrepreneur |
| Qry Report ESD Graduation Likelyhood Tab | Select | NonGraduateReason, CompanyProgrammeYearStatus |
| Qry Report Financial Detail | Select | Delivery Locations, Entrepreneur |
| Qry Report Financial Summary | Select | SubQry Company List Criteria, Delivery Locations |
| Qry Report Principal Projects Purchased ED vs SD S2S | Select | Qry Count Number SD Allocated by Principal Project Pillar, SubQry Purchased ED vs SD Report S2S |
| Qry Report Principal Projects Purchased ED vs SD SDM | Select | Qry Count Number SD Allocated by Principal Project Pillar, Qry Count Number ED Allocated by Principal Project Pillar |
| Qry Report Principal Spend by Company | Select | Entrepreneur Company, SubQry Rpt Sum Principal Spend by Company |
| Qry Report Principal Spend by Delivery Location | Select | SubQry Rpt Sum Principal Spend by Delivery Location, Delivery Locations |
| Qry Report Principal Spend by Principal and Company One Month | Select | Entrepreneur, Entrepreneur Company |
| Qry Report Principal Spend by Principal YTD | Select | Entrepreneur, Principal Project Pillars |
| Qry Report Principal Spend Tracking | Select | Submissions, Submissions Principal Spend |
| Qry Report SDM Opal Shift | Select | SubQry Rpt SDM Opal Shift Get Principals, SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal |
| Qry Report Submission Detail by Company | Select | Submissions |
| Qry Submission List | Select | Submissions, MonthLkUp |
| Qry SubRpt Submission Status History | Select | Submissions, Submissions Status History |
| Qry Sum ED or SD Amount Purchased by Principal Project | Select | Principal Project Pillars, Entrepreneur Company Programme Years |
| Qry Sum Pre-Ignition Financials by Company | Select | Entrepreneur Company Pre Ignition Financials, Entrepreneur |
| Qry Sum Submission Financials by Company | Select | Submissions |
| Qry Sum Total Allocated by Entrepreneur Programme Year | Select | Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Sum Total Sponsored by Principal Project | Select | Principal, Principal Project Pillars |
| qryLinkODBC | Select | zstblODBC_tables, zstblODBC_db |
| SubQry Company List Criteria | Select | Amber Distribution Models, Entrepreneur Company |
| SubQry Count ED or SD Companies Bought From by Principal Project | Select | Principal Project Pillars, Entrepreneur Company Programme Years |
| SubQry Get Last Complete Submission by Company | Select | Submissions, MonthLkUp |
| SubQry Purchased ED vs SD Report S2S Criteria | Select | Entrepreneur, Entrepreneur Company |
| SubQry Purchased ED vs SD Report S2S | Select | SubQry Purchased ED vs SD Report S2S Criteria, SubQry Purchased ED vs SD Report SDM |
| SubQry Purchased ED vs SD Report SDM | Select | Principals, Principal Project Pillars |
| SubQry Rpt Bookkeeping Compliance All Delivery Locations | Select | Submissions, MonthLkUp |
| SubQry Rpt Bookkeeping Compliance by Company | Select | Submissions, MonthLkUp |
| SubQry Rpt Books Not Submitted Raizcorp Bookkeeper | Select | Submissions |
| SubQry Rpt SDM Opal Shift Get Principals | Select | |
| SubQry Rpt SDM Opal Shift Sum Current Month Spend by Principal | Select | Entrepreneur, Principal Project Pillars |
| SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal | Select | Entrepreneur, Principal Project Pillars |
| SubQry Rpt Sum Principal Spend by Company | Select | Principal Project Pillars, Principal Projects |
| SubQry Rpt Sum Principal Spend by Delivery Location | Select | Entrepreneur Company, Principal Project Pillars |
| SubQry Rpt Tracker Count Current Complete Subs by Bookkeeper | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| SubQry Rpt Tracker Count Current Incomplete Subs by Bookkeeper | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| SubQry Rpt Tracker Count Current Submissions by Bookkeeper | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| SubQry Rpt Tracker Count Current Under Query Subs by Bookkeeper | Select | Delivery Locations, Qry Get Companies Not Non Graduate |
| SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper | Select | Delivery Locations, Qry Get Companies Not Non Graduate |