| JB Check Company Allocations |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Principal Projects... |
| JB Issue with Monthly Billings |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Principal Projects... |
| JB Qry Reverse Sept Monthly Billings |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Principal Projects... |
| 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, Principal Project Pillars... |
| Qry Company Entrepreneur Ignition List |
Select |
vwGarnetCompanyEntrepreneurIgnitionList |
| Qry Company List |
Select |
vwGarnetCompanyList |
| Qry Company Lump Sum Allocation List |
Select |
Delivery Locations, Entrepreneur Company, Temp... |
| Qry Company Monthly Billing List Temp |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Temp Entrepreneur Company Monthly Billings... |
| Qry Company Monthly Billing List |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Delivery Locations... |
| Qry Company Needs Replacement List |
Select |
SubQry Company Needs Replacement List, SubQry, Qry Sum Total Billed by Company PP and Project Pillar... |
| 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, Entrepreneur Company Programme Years... |
| Qry Count Companies by Principal Project Allocation Report |
Select |
Entrepreneur Company Programme Years, Principal, Principal Project Pillars... |
| Qry Count Current Blank Year Companies by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal, Principal Project Pillars... |
| Qry Count Current Blank Year Entrepreneurs by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Entrepreneurs... |
| Qry Count Current Future Year Companies by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal, Principal Project Pillars... |
| Qry Count Current Future Year Entrepreneurs by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Entrepreneurs... |
| Qry Count Current Graduated Companies by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal, Principal Project Pillars... |
| Qry Count Current Graduated Entrepreneurs by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Entrepreneurs... |
| Qry Count Current On Programme Companies by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal, Principal Project Pillars... |
| Qry Count Current On Programme EPs by Principal Project |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Entrepreneurs... |
| Qry Count Exited Companies by Principal Project Pillar |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years... |
| Qry Count Exited Need Replacement by Principal Project Pillar |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years... |
| Qry Count Number Months Billed by Company PP and Project Pillar |
Select |
Entrepreneur, Entrepreneur Company Monthly Billings, Entrepreneur Company Principal Projects |
| 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, Principal Projects... |
| 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, Principal Projects... |
| Qry Entrepreneur Company Sub Products |
Select |
Entrepreneur, Sub Products, Principal Project Pillar Sub Products... |
| Qry Export Certificate Mail Merge Information |
Select |
Temp, Temp Entrepreneur ID for Contract Mail Merge, vwGarnetExportCompanyInformationforCertificateMailMerge |
| Qry Export Commitment Fee Information for Invoice |
Select |
SubQry Export Commitment Fee Information for Notification, Temp Entrepreneur ID for Contract Mail Merge, Temp |
| Qry Export Contract Mail Merge Information |
Select |
vwGarnetExportEntrepreneurInformationforContractMailMerge, Temp Entrepreneur ID for Contract Mail Merge, Temp |
| Qry Get Amount Remaining by Principal Project Pillar |
Select |
Principal, Principal Project Pillars, SubQry Sum Total Replaced Billed to Date by Prin Project Pillar... |
| Qry Get Companies for Certificate Mail Merge |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years |
| Qry Get Companies for Lump Sum Allocation |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneurs |
| 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, Lead Types... |
| Qry Get Entrepreneur Sourced From by Principal Project |
Select |
Principal Project Pillars, Principal Project Pillar Sourced From, Principal |
| Qry Get Entrepreneurs for Contract Mail Merge |
Select |
Entrepreneurs, Entrepreneur Company Programme Years, Entrepreneur Company... |
| 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... |
| Qry Get Last Programme Year Info for Report Writer |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Entrepreneurs... |
| Qry Get Monthly Billing Information |
Select |
Entrepreneur Company Programme Years, Qry Sum Total Billed by Company PP and Project Pillar, Qry Get Last Billing Date by EP Company Principal Project... |
| Qry Get Principal Projects for Finance Audit Report |
Select |
Qry, Qry Count Total Companies Allocated Lump Sum 1 Principal Project, Principal Projects... |
| Qry Get Principal Projects for Finance Report |
Select |
SubQry Get Principal Projects for Finance Report, Qry Sum Total Spend by Principal Project, Qry |
| 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, Entrepreneur Company |
| Qry Opal Scorecard Get Active Companies New |
Select |
Entrepreneurs, Entrepreneur Company Status History, Entrepreneur Company |
| Qry Opal Scorecard Get Active Companies Stopped |
Select |
SubQry, Entrepreneur Company, Entrepreneur Company Status History... |
| Qry Opal Tag Programme Yr and Eligible for Graduation |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years |
| Qry Principal List |
Select |
Principals |
| Qry Principal Project List Allocation |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, CompanyProgrammeYearStatus... |
| Qry Principal Project List Main Dashboard |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, CompanyProgrammeYearStatus... |
| Qry Principal Project List |
Select |
Qry Sum Total Billed by Principal Project, Principals, Principal Projects... |
| Qry Principal Project Pillar List |
Select |
Principal Project Pillars, Principals, Principal Projects |
| Qry Principal Project Sub Products |
Select |
Principal Project Pillar Sub Products, Principal Project Pillars, Principal Projects... |
| Qry Report Active Companies Email |
Select |
Entrepreneurs, Entrepreneur Company, Distribution Models |
| 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, Products |
| 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 Sum Total Billed by Company PP and Project Pillar... |
| 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 Count Current Future Year Companies by Principal Project... |
| 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 Count Current Graduated Companies by Principal Project... |
| 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 Count Current On Programme Companies by Principal Project... |
| 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, SubQry Rpt EP Counts by Principal Project Delivery Location |
| Qry Report Principal Quarterly Reports |
Select |
vwGarnetRptPrincipalQuarterlyReports |
| Qry Report Principal SD Letter New Allocation |
Select |
DatabaseUsers, Principals, Principal Projects... |
| Qry Report RAG |
Select |
vwPurpleReportRAG, SubQry Sum Total Replaced Billed to Date by Prin Project Pillar, SubQry Sum Total Replaced Selection Fee by Prin Project Pillar |
| Qry Report Raizcorp Possibilities |
Select |
vwPurpleReportRaizcorpPossibilities, ProcessStatus |
| Qry Report Raizcorpossible Companies Email |
Select |
Entrepreneurs, Entrepreneur Company, Distribution Models |
| Qry Report SD Alocations Not Notified |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Principal Projects... |
| Qry Report Summarised Deferred Income |
Select |
vwGarnetReportSumDeferredIncomeOBBalance, Temp Principal Projects for Finance Report, vwGarnetReportSumDeferredIncomeTotalSponsorshipNonGraduate... |
| Qry Report Writer |
Select |
Entrepreneurs, IndustryLookup, Delivery Locations... |
| 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, CompanyProgrammeYearStatus... |
| 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, Delivery Locations... |
| Qry SubRpt Principal Project Pillar Delivery Locations |
Select |
Delivery Locations, Principal Project Pillar Delivery Location, Principal |
| 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, Entrepreneur Company Monthly Billings... |
| Qry Sum Total Billed by Company PP and Project Pillar |
Select |
Entrepreneur, Entrepreneur Company Programme Years, Entrepreneur Company Monthly Billings... |
| Qry Sum Total Billed by Principal Project |
Select |
Principal Project Pillars, Entrepreneur, Entrepreneur Company Monthly Billings |
| 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, Temp |
| Qry Update Commitment Fee Invoiced Box |
Update |
Entrepreneur Company Programme Years, Temp Entrepreneur ID for Contract Mail Merge, Temp |
| Qry Update Contract Printed Box |
Update |
Entrepreneur Company Principal Projects, Temp Entrepreneur ID for Contract Mail Merge, Temp |
| 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, Principal Projects... |
| SubQry Export Commitment Fee Information for Notification |
Select |
Entrepreneur Company Programme Years, Delivery Locations, Entrepreneur Company... |
| SubQry Get Principal Projects for Finance Report |
Select |
|
| SubQry Opal Scorecard Get Active Companies Stopped |
Select |
Entrepreneurs, Entrepreneur Company Status History, Entrepreneur Company |
| SubQry Opal Scorecard Source |
Select |
Entrepreneur Company Programme Years, NonGraduateReason, Delivery Locations... |
| SubQry Rpt Companies Needs Replacement |
Select |
Entrepreneur Company Programme Years, Principal Project Pillars, Entrepreneur Company... |
| 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, IndustryLookup... |
| SubQry Rpt Part Sponsorship |
Select |
Qry Sum Total Allocated Amt by Company, Qry, vwPurpleReportPartSponsorship |
| SubQry Rpt Principal Project Allocation for Finance Criteria |
Select |
Entrepreneur Company Programme Years, Principal, Principal Project Pillars... |
| 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, Entrepreneur Company Monthly Billings... |
| SubQry Sum Total Replaced Selection Fee by Prin Project Pillar |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years... |