gia - Technical Architecture
Data Model
Tables (36)
Business Area Lookup
Primary Key: Business
Fields: - Business Area ID: Long - Business Area: Text - 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
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 Purple Panelists
Primary Key: Entrepreneur
Fields: - Entrepreneur Purple Panelist ID: Long - Entrepreneur ID: Long - Purple Panelist: Text - Purple Panelist Score: Double - Convener: Boolean - SSMA_TimeStamp: Binary
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 GIA
Primary Key: Front
Fields: - Front End Version Number: Text - Purple Panel Interview Report File Name: Text
Metrics
Primary Key: Metric
Fields: - Metric ID: Long - Metric: Memo (PK) - Metric Description: Memo - Default Metric: Boolean - Sort Order: Long - SSMA_TimeStamp: Binary
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
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
Purple Panel Extra Notification Usernames
Primary Key: Username
Fields: - Username: Text (PK) - SSMA_TimeStamp: Binary
Purple Panel Report Staging Area
Primary Key: Staging
Fields: - Staging ID: Long - Email Address: Text - Report Name: Text - Company Name: Text - SSMA_TimeStamp: Binary
Purple Panel Score Lookup
Primary Key: Purple
Fields: - Purple Panel Score ID: Long - Purple Panel Score: Long - Purple Panel Score Description: Text - SSMA_TimeStamp: Binary
Purple Panel Status Lookup
Primary Key: Purple
Fields: - Purple Panel Status ID: Long - Purple Panel Status: Text - Passed: Boolean - SSMA_TimeStamp: Binary
Purple Panelist Developmental Areas
Primary Key: Purple
Fields: - Purple Panelist Developmental Areas ID: Long - Purple Panelist ID: Long - Purple Panelist Developmental Areas: Text - SSMA_TimeStamp: Binary
Purple Panelist Strengths
Primary Key: Purple
Fields: - Purple Panelist Strengths ID: Long - Purple Panelist ID: Long - Purple Panelist Strengths: Text - SSMA_TimeStamp: Binary
Purple Panelists Evidence
Primary Key: Purple
Fields: - Purple Panelist Evidence ID: Long - Purple Panelist Score ID: Long - Purple Panelist Score Evidence: Text - SSMA_TimeStamp: Binary
Purple Panelists Scores
Primary Key: Purple
Fields: - Purple Panelist Score ID: Long - Purple Panelist ID: Long - Rubric Metric Template ID: Long - Purple Panelist Score: Long - DELETE Purple Panelist Score Evidence 1: Text - DELETE Purple Panelist Score Evidence 2: Text - DELETE Purple Panelist Score Evidence 3: Text - DELETE Purple Panelist Score Evidence 4: Text - DELETE Purple Panelist Score Evidence 5: Text - Unused: Boolean - SSMA_TimeStamp: Binary
Purple Panelists
Primary Key: Purple
Fields: - Purple Panelist ID: Long - Purple Panel ID: Long - Purple Panelist: Text - Business Area: Text - Purple Panelist Total Score: Double - Possible Total Score: Double - Convener: Boolean - Questions: Memo - Submitted: Boolean - SSMA_TimeStamp: Binary
Purple Panels
Primary Key: Purple
Fields: - Purple Panel ID: Long - Purple Panel Date: DateTime - Purple Panel Time: DateTime - Entrepreneur Company ID: Long - Recommended Product: Text - Suitabe for Recommended Programme: Long - Recommend Suitable Programme: Text - Rubric ID: Long - Changed Rubric Switch: Boolean - Possible Score: Double - Average Score: Double - Strengths Summary: Memo - Developmental Areas Summary: Memo - Adjusted Average Score: Double - Reason for Score Adjustment: Text - Purple Panel Status ID: Long - Submitted: Boolean - SSMA_TimeStamp: Binary - Panel Feedback to COO: Memo - Recommend Suitable Programme ID: Long - Recommended Programme NA: Boolean - EP Division ID: Long - EP Distribution Model ID: Long
Rubric Metric Templates
Primary Key: Rubric
Fields: - Rubric Metric Template ID: Long - Rubric ID: Long - Metric ID: Long - Metric Weight: Double - SSMA_TimeStamp: Binary
Rubrics
Primary Key: Rubric
Fields: - Rubric ID: Long - Rubric: Text (PK) - SSMA_TimeStamp: Binary
Temp Individuals in a Company
Primary Key: Not defined
Fields: - Individuals: Text
Temp Purple Panelists Summary
Primary Key: Purple
Fields: - Purple Panelist ID: Long - Purple Panel ID: Long - Panelist Number: Long - Purple Panelist: Text - Business Area: Text - Purple Panelist Total Score: Double - Possible Total Score: Double - Convener: Boolean - Questions: Memo
Temp Rubric Metrics NOT in the List
Primary Key: Not defined
Fields: - Metric ID: Long - Metric: Memo - Metric Description: Memo - Metric Weight: Double - Sort Order: Long - Add it: Boolean
User Levels
Primary Key: Level
Fields: - Level ID: Long - Level: Text (PK) - Level Description: Text
vwGIACompanyList
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Company Name: Text - Delivery Location: Text - Company Status ID: Long - Status: Text - Last Process Status ID: Long - Entrepreneur Status: Text - OwnedBy: Text - Delivery Location ID: Long
vwGIAEntrepreneurList
Primary Key: Not defined
Fields: - Entrepreneur Company ID: Long - Entrepreneur ID: Long - First Name: Text - Surname: Text - Company Name: Text - Delivery Location: Text - Recommended Product: Text - Process Status ID: Long
zstblODBC_db
Primary Key: DBID
Fields: - DBID: Long (PK) - SelectDB: Boolean - DatabaseName: Text - 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 - DatabaseName: Text - TableName: Text - SourceTableName: Text - AfterDDL: Text - Comment: Text - DateAdded: DateTime
Code Components
Modules (34)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Add and Edit Metrics | Form | 34 | 3 |
| Form_Add and Edit Purple Panel Extra Notification Users | Form | 60 | 3 |
| Form_Add and Edit Purple Panels | Form | 95 | 3 |
| Form_Add and Edit Rubrics | Form | 25 | 2 |
| Form_Adjust Purple Panel Score | Form | 53 | 4 |
| Form_Change Password | Form | 138 | 5 |
| Form_Change Rubric | Form | 134 | 2 |
| Form_Company List | Form | 487 | 15 |
| Form_Display Confidentiality Statement | Form | 20 | 1 |
| Form_Edit Purple Panel Convener Summary | Form | 469 | 11 |
| Form_Edit Purple Panelists Rubric Metric Scores | Form | 216 | 8 |
| Form_Edit Rubric Metric Weight | Form | 25 | 2 |
| Form_Edit Rubric Metrics Template | Form | 52 | 2 |
| Form_Maintenance Menu | Form | 32 | 4 |
| Form_Opening Dialog | Form | 109 | 4 |
| Form_Rubric List | Form | 114 | 8 |
| Form_View Purple Panelists Rubric Metric Scores | Form | 31 | 3 |
| Form_SubFrm DatabaseUsers Module Permissions | Form | 20 | 1 |
| Form_SubFrm Metrics | Form | 55 | 2 |
| Form_SubFrm Purple Panel Developmental Areas Summary | Form | 20 | 1 |
| Form_SubFrm Purple Panel Strengths Summary | Form | 20 | 1 |
| Form_SubFrm Purple Panelist Developmental Areas | Form | 20 | 1 |
| Form_SubFrm Purple Panelist Metric Scores | Form | 66 | 6 |
| Form_SubFrm Purple Panelist Score Evidence | Form | 22 | 2 |
| Form_SubFrm Purple Panelist Strengths | Form | 20 | 1 |
| Form_SubFrm Purple Panelists | Form | 51 | 2 |
| Form_SubFrm View Purple Panelist Score Evidence | Form | 22 | 2 |
| Form_ZZZ Save Frm Edit Purple Panel Convener Summary | Form | 179 | 6 |
| Form_ZZZ Save Frm Edit Purple Panelists Rubric Metric Scores | Form | 179 | 7 |
| Form_ZZZ Save SubFrm Purple Panelist Metric Scores | Form | 51 | 6 |
| basRelink | Standard | 562 | 6 |
| Mod Send Outlook Message | Standard | 53 | 1 |
| Mod Update Evidence | Standard | 43 | 1 |
| Mod Utilities | Standard | 177 | 11 |
Forms (37)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Add and Edit Metrics | SELECT [Metric ID], [Metric], [Metric Description], [Default Metric], [Sort Order] FROM Metrics; | 11 | Yes |
| Add and Edit Purple Panel Extra Notification Users | Purple Panel Extra Notification Usernames | 10 | Yes |
| Add and Edit Purple Panels | Purple Panels | 25 | Yes |
| Add and Edit Rubrics | Rubrics | 10 | Yes |
| Adjust Purple Panel Score | Unbound | 18 | Yes |
| Change Password | Unbound | 19 | Yes |
| Change Rubric | Unbound | 9 | Yes |
| Company List | Unbound | 26 | Yes |
| Display Confidentiality Statement | Unbound | 5 | Yes |
| Edit Purple Panel Convener Summary | Purple Panels | 60 | Yes |
| Edit Purple Panelists Rubric Metric Scores | Qry Edit Purple Panelists Main Form | 35 | Yes |
| Edit Rubric Metric Weight | Rubric Metric Templates | 13 | Yes |
| Edit Rubric Metrics Template | Unbound | 8 | Yes |
| Maintenance Menu | Unbound | 5 | Yes |
| Opening Dialog | Unbound | 14 | Yes |
| Rubric List | Unbound | 14 | Yes |
| View Purple Panelists Rubric Metric Scores | Qry View Purple Panelists Rubric Metric Scores | 16 | Yes |
| SubFrm DatabaseUsers Module Permissions | DatabaseUsers Module Permissions | 7 | Yes |
| SubFrm Display Purple Panelist Score and Summary Panelist 1 | SELECT [Temp Purple Panelists Summary].[Panelist Number], [Temp Purple Panelists | 9 | No |
| SubFrm Display Purple Panelist Score and Summary Panelist 2 | SELECT [Temp Purple Panelists Summary].[Panelist Number], [Temp Purple Panelists | 9 | No |
| SubFrm Display Purple Panelist Score and Summary Panelist 3 | SELECT [Temp Purple Panelists Summary].[Panelist Number], [Temp Purple Panelists | 7 | No |
| SubFrm Metric Description | Metrics | 2 | No |
| SubFrm Metrics | SELECT Metrics.[Metric ID], Metrics.Metric, Metrics.[Metric Description], Metric | 11 | Yes |
| SubFrm Purple Panel Developmental Areas Summary | Purple Panel Developmental Areas Summary | 7 | Yes |
| SubFrm Purple Panel Strengths Summary | Purple Panel Strengths Summary | 7 | Yes |
| SubFrm Purple Panelist Developmental Areas | Purple Panelist Developmental Areas | 7 | Yes |
| SubFrm Purple Panelist Metric Scores | Qry Edit Purple Panelists Rubric Metric Scores | 9 | Yes |
| SubFrm Purple Panelist Score Evidence | Unbound | 8 | Yes |
| SubFrm Purple Panelist Strengths | Purple Panelist Strengths | 7 | Yes |
| SubFrm Purple Panelists | Purple Panelists | 13 | Yes |
| SubFrm Rubric Metrics NOT in List | Temp Rubric Metrics NOT in the List | 11 | No |
| SubFrm Temp Purple Panelist Developmental Areas | Temp Purple Panelist Developmental Areas | 6 | No |
| SubFrm Temp Purple Panelist Strengths | Temp Purple Panelist Strengths | 6 | No |
| SubFrm View Purple Panelist Score Evidence | Purple Panelists Evidence | 7 | Yes |
| ZZZ Save Frm Edit Purple Panel Convener Summary | Purple Panels | 50 | Yes |
| ZZZ Save Frm Edit Purple Panelists Rubric Metric Scores | Qry Edit Purple Panelists Main Form | 41 | Yes |
| ZZZ Save SubFrm Purple Panelist Metric Scores | Qry Edit Purple Panelists Rubric Metric Scores | 8 | Yes |
Reports (4)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Report Purple Panel Feedback to COO | 2 |
| Calibri | Qry Report Purple Panel Results Successful | 2 |
| Calibri | Qry Report Purple Panel Results Unsuccessful | 2 |
| Calibri | Qry SubRpt Panelists | 0 |
Queries (28)
| Query | Type | Tables |
|---|---|---|
| JB Qry Compression Rubric | Select | Rubric Metric Templates, Rubrics |
| Qry Company List | Select | vwGIACompanyList, Purple Panel Status Lookup |
| Qry Edit Purple Panelists Main Form | Select | Purple Panelists, Purple Panels |
| Qry Edit Purple Panelists Rubric Metric Scores | Select | Purple Panelists Scores, Rubric Metric Templates |
| Qry Entrepreneur and Company Status List | Select | |
| Qry Get Competent Purple Panelists | Select | DatabaseUsers Module Permissions, DatabaseUsers |
| Qry Get Developmental Areas by Purple Panel | Select | Purple Panelists, Purple Panels |
| Qry Get Email Address COO | Select | DatabaseUsers Module Permissions, DatabaseUsers |
| Qry Get Email Address Owned By | Select | vwGIACompanyList, DatabaseUsers |
| Qry Get Email Addresses Extra | Select | Purple, DatabaseUsers |
| Qry Get Email Addresses Purple Panelists | Select | Purple Panelists, DatabaseUsers |
| Qry Get Email Addresses Regular Report | Select | |
| Qry Get Purple Panel Convener Name by Purple Panel | Select | Purple Panelists, Purple |
| Qry Get Recommended Product by Company | Select | Products, Entrepreneurs |
| Qry Get Strengths by Purple Panel | Select | Purple Panelists, Purple Panels |
| Qry Get Unused Metrics by Purple Panelist | Select | Purple Panelists Scores, Rubric Metric Templates |
| Qry Purple Panelist List | Select | Purple Panelists, Purple |
| Qry Report Purple Panel Feedback to COO | Select | Temp Individuals in a Company, SubQry Report Purple Panel Results |
| Qry Report Purple Panel Results Successful | Select | Temp Individuals in a Company, SubQry Report Purple Panel Results |
| Qry Report Purple Panel Results Unsuccessful | Select | Temp Individuals in a Company, SubQry Report Purple Panel Results |
| Qry Rubric Metric Templates List | Select | Rubric Metric Templates, Rubric |
| Qry Rubric Metrics NOT in the List | Delete | SubQry Rubric Metrics NOT in the List, Metrics |
| Qry SubRpt Panelists | Select | Purple Panelists, Purple |
| Qry Sum Total Scores by Purple Panelist | Select | Qry, Qry Edit Purple Panelists Rubric Metric Scores |
| Qry View Purple Panelists Rubric Metric Scores | Select | Purple Panelists Scores, Rubric Metric Templates |
| qryLinkODBC | Select | zstblODBC_tables, zstblODBC_db |
| SubQry Report Purple Panel Results | Select | vwGIAEntrepreneurList, Qry Get Purple Panel Convener Name by Purple Panel |
| SubQry Rubric Metrics NOT in the List | Select | Rubric Metric Templates, Rubric |