| Find duplicates for Engage UUID |
Select |
Engage UUID, Engage |
| Find duplicates for Entrepreneurs |
Select |
Entrepreneurs |
| Find duplicates for Qry Report Termination Analysis Data |
Select |
Qry, Qry Report Termination Analysis Data |
| JB Digital Process Status |
Select |
ProcessStatus |
| JB Entrepreneurs With No Pipeline |
Select |
ProcessStatus, Entrepreneurs |
| JB Qry Example of Report |
Select |
ProcessStatus, Entrepreneurs, Pipelines |
| JB Qry Initialise UUID |
Delete |
Entrepreneurs |
| JB Qry Not Digital Pipeline |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs... |
| JB Qry Raizcorpossibles with terminated or unqualified EPs |
Select |
CompanyStatus, Entrepreneur Company, ProcessStatus... |
| JB Reactivated EPs |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| JB SubQry Get Ready For Allocation without History |
Select |
Entrepreneur Status History, Entrepreneur |
| JB Update Date Status Changed Unallocated |
Update |
Entrepreneur, Entrepreneur Company, Entrepreneurs |
| JB Update DO NOT USE IN DIGITAL |
Update |
Lead Types, Lead |
| JBQry Current Raizcorp Possibles by Delivery Location |
Select |
Qry Get Division Dist Model Del Loc and Rec Info by Company, Entrepreneur Company, Delivery... |
| Jo Qry Uncontacted Followup Ready for Allocation |
Select |
Entrepreneurs, Jo Qry Uncontacted Unfollow Reeady for Allocation, Jo |
| Qry Application Versions |
Select |
|
| Qry Calculate Percent Headhunted Qualified by OwnedBy Date Range |
Select |
Qry, Qry Count Headhunted Qualified by OwnedBy Date Range, Qry Count Headhunted by OwnedBy Date Range |
| Qry Count Active Allocated Companies by Principal Project Pillar |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years... |
| Qry Count Companies by PP Pillar Principal Report |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Companies by Principal Project Principal Report |
Select |
vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport |
| Qry Count Current Active Allocated Companies On Pgm by Prin Proj |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Current Active Companies by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Current Active Companies Total |
Select |
SubQry, SubQry Count Current Active Companies Total |
| Qry Count Current Active Entrepreneurs by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Current Active Entrepreneurs Total |
Select |
SubQry, SubQry Count Current Active Entrepreneurs Total |
| Qry Count Current Entrepreneurs Allocated for Purple |
Select |
Entrepreneur Company, Entrepreneurs |
| Qry Count Current Entrepreneurs by Step for Purple |
Select |
ProcessStatus, Entrepreneurs |
| Qry Count Current Exited Companies by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Current Exited Entrepreneurs by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Current Part Sponsorship by Delivery Location And Type |
Select |
Delivery, Qry Report Part Sponsorship, Delivery Locations |
| Qry Count Current Part Sponsorship by Delivery Location |
Select |
Delivery, Qry Report Part Sponsorship, Delivery Locations |
| Qry Count Current Raizcorp Possibles by Delivery Location |
Select |
Qry Get Division Dist Model Del Loc and Rec Info by Company, Entrepreneur Company, Delivery... |
| Qry Count Delivery Locations Allowed by Principal Project |
Select |
Qry Get Delivery Locations Allowed by Principal Project, Qry |
| Qry Count Entrepreneur Moved Last Week Digital Process |
Select |
SubQry Get Entrepreneur Moved Last Week, SubQry |
| Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca |
Select |
SubQry Get Entrepreneur Moved Last Week, SubQry |
| Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location |
Select |
SubQry Get Entrepreneur Moved Last Week, SubQry |
| Qry Count Entrepreneur Moved Last Week Manual Process |
Select |
SubQry Get Entrepreneur Moved Last Week, SubQry |
| Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location |
Select |
vwPurpleGetEntrepreneursSteps1to7 |
| Qry Count Entrepreneur Steps 1 to 7 Digital Process |
Select |
vwPurpleGetEntrepreneursSteps1to7 |
| Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location |
Select |
vwPurpleGetEntrepreneursSteps1to7 |
| Qry Count Entrepreneur Steps 1 to 7 Manual Process |
Select |
vwPurpleGetEntrepreneursSteps1to7 |
| Qry Count Entrepreneurial Assessment Results |
Select |
Entrepreneurs |
| Qry Count Entrepreneurial Assessment Retake Results |
Select |
Entrepreneurs |
| Qry Count Entrepreneurs by Company for Projile |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneurs |
| Qry Count Entrepreneurs by PP Pillar Principal Report |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Entrepreneurs by Principal Project Principal Report |
Select |
SubQry Count Entrepreneurs by Principal Project Principal Report, SubQry |
| Qry Count Entrepreneurs Pipeline Phase 1 by Delivery Location |
Select |
ProcessStep, ProcessStatus, Entrepreneurs |
| Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location |
Select |
ProcessStep, ProcessStatus, Entrepreneurs |
| Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location |
Select |
ProcessStep, ProcessStatus, Entrepreneurs |
| Qry Count Entreprenur Steps Total at 1 and 2 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 1 and 3 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 1 and 4 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 1 and 7 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 1 and 8 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 1 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 2 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 3 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 4 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 7 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Entreprenur Steps Total at 8 |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Count Exited Companies by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Exited Need Replacement by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Count Headhunted by OwnedBy Date Range |
Select |
SubQry, SubQry Count Headhunted by OwnedBy Date Range Criteria |
| Qry Count Headhunted Qualified by OwnedBy Date Range |
Select |
SubQry, SubQry Count Headhunted by OwnedBy Date Range Criteria |
| Qry Count Purple Panel Results Date Range |
Select |
Entrepreneurs |
| Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc |
Select |
Temp Entrepreneur Steps, Entrepreneur Company, Temp... |
| Qry Count Total Assessments Passed by Scout |
Select |
SubQry, SubQry Rpt Assessment Panel Passes per Scout |
| Qry Count Total Assessments Taken by Scout |
Select |
SubQry, SubQry Rpt Assessment Panel Passes per Scout |
| Qry Count Total Panels Held by Scout |
Select |
SubQry, SubQry Rpt Assessment Panel Passes per Scout |
| Qry Count Total Panels Passed by Scout |
Select |
SubQry, SubQry Rpt Assessment Panel Passes per Scout |
| Qry Count Unallocated Companies by EP Delivery Location |
Select |
Entrepreneur, Entrepreneur Company, Qry Get Division Dist Model and Rec Info by Company |
| Qry Count Unallocated Companies by Principal Project Recommended |
Select |
Qry, Entrepreneur Company, Qry Get Division Dist Model and Rec Info by Company |
| Qry Digital Stats Report |
Select |
|
| Qry Duplicate Entrepreneurs |
Select |
SubQry Duplicate Entrepreneurs Alt, Lead Types, ProcessStatus... |
| Qry Entrepreneur Company List Principal Projects |
Select |
vwPurpleEntrepreneurCompanyListPrincipalProjects |
| Qry Entrepreneur Company List |
Select |
Entrepreneur, Entrepreneur Company |
| Qry Entrepreneur Digital Selection List |
Select |
vwPurpleEntrepreneurList |
| Qry Entrepreneur List Company Commodity |
Select |
vwPurpleEntrepreneurListCompanyCommodity |
| Qry Entrepreneur List Current Principal Projects |
Select |
vwPurpleEntrepreneurListCurrentPrincipalProjects, vwPurpleGetCurrentContractInfobyCompany |
| Qry Entrepreneur List Ignition Dashboard |
Select |
vwPurpleEntrepreneurListIgnitionDashboard |
| Qry Entrepreneur List Part Sponsorship |
Select |
vwPurpleEntrepreneurListPartSponsorship, Qry, Qry Sum Total Allocated Amt by Company |
| Qry Entrepreneur List Purple Meeting |
Select |
Principal Projects, Temp, Temp Purple Meeting Status... |
| Qry Entrepreneur List |
Select |
vwPurpleEntrepreneurList |
| Qry Entrepreneurs in a Company List |
Select |
Entrepreneurs |
| Qry Export Blue Eagle Entrepreneurs |
Select |
Entrepreneurs |
| Qry Export Daily Lead Summary Leads Less Than 48 Hours |
Select |
Lead Types, Entrepreneur Company, ProcessStatus... |
| Qry Export Daily Lead Summary Leads More Than 48 Hours |
Select |
Lead Types, Entrepreneur Company, ProcessStatus... |
| Qry Export Entrepreneurs All Lead Types |
Select |
Lead Types, Entrepreneur Company, TerminationReason... |
| Qry Export Entrepreneurs by Lead Type |
Select |
Lead Types, Temp Lead Type for Lead Report, Entrepreneur Company... |
| Qry Export Temp Entrepreneur Steps |
Select |
|
| Qry Get BEE and Tax Clearance Alerts |
Select |
vwPurpleGetBEEAndTaxClearanceAlerts |
| Qry Get Current Contract Info by Company |
Select |
Qry, Qry Sum Total Allocated Amt by Company, vwPurpleGetCurrentContractInfobyCompany |
| Qry Get Del Loc Raizcorpossibles Part Sponsorship |
Select |
|
| Qry Get Delivery Locations Allowed by Principal Project |
Select |
Principal Project Pillars, Principal, Principal Project Pillar Delivery Location |
| Qry Get Delivery Locations Quartz Lead Phase Report |
Select |
|
| Qry Get Division Dist Model and Rec Info by Company |
Select |
Entrepreneurs |
| Qry Get Division Dist Model Del Loc and Rec Info by Company |
Select |
Entrepreneurs |
| Qry Get Entrepreneur Info for Projile Merge |
Select |
Entrepreneurs |
| Qry Get Entrepreneur Recommended Information |
Select |
Lead Types, Principal Projects, Products... |
| Qry Get Entrepreneur Steps by Delivery Location |
Select |
vwPurpleGetEntrepreneurSteps, SubQry, SubQry Get Entrepreneur Steps Delivery Location Criteria |
| Qry Get Entrepreneur Steps by Lead Type |
Select |
vwPurpleGetEntrepreneurSteps, SubQry, SubQry Get Entrepreneur Steps Lead Type Criteria |
| Qry Get Entrepreneur Steps by Owned By |
Select |
vwPurpleGetEntrepreneurSteps, SubQry, SubQry Get Entrepreneur Steps Owned by Criteria |
| Qry Get Entrepreneur Steps by Recommended Principal Project |
Select |
vwPurpleGetEntrepreneurSteps, SubQry, SubQry Get Entrepreneur Steps Recommended Principal Project Crit |
| Qry Get Entrepreneur Steps Date Range |
Select |
Entrepreneur Status History, SubQry Get Entrepreneur Steps Date Range Criteria, SubQry... |
| Qry Get Entrepreneur Steps For Summary |
Select |
SubQry, SubQry Get Entrepreneur Steps For Summary Criteria |
| Qry Get Entrepreneurs Modified Pipeline 1 Prin Proj Date Range |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs... |
| Qry Get Entrepreneurs Modified Pipeline Date Range |
Select |
Entrepreneur Status History, SubQry Get Entrepreneurs Modified Pipeline Date Range Crit, SubQry... |
| Qry Get Entrepreneurs Modified Pipeline Last 6 Months |
Select |
Entrepreneur Status History, SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit, ProcessStatus... |
| Qry Get Entrepreneurs Reactivated for Summary |
Select |
SubQry, SubQry Get Entrepreneur Steps For Summary Criteria |
| Qry Get Entrepreneurs Steps Modified by Owned By Date Range |
Select |
Entrepreneur Status History, SubQry, SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit... |
| Qry Get Last Note by Entrepreneur |
Select |
Entrepreneur Notes, Qry Get Last Note Date by Entrepreneur, Qry |
| 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 |
NonGraduateReason, Products, Qry... |
| Qry Get Lead Types for Passed Panel Entrepreneurs |
Select |
Lead Types, ProcessStatus, Entrepreneurs |
| Qry Get Owned By Panels Passed by Scout |
Select |
|
| Qry Get OwnedBy for Selection Team Target Report |
Select |
Temp Entrepreneur Steps, Temp |
| Qry Get Pipeline Steps Between 1 and 8 |
Select |
Pipelines Detail, Pipelines, ProcessStatus |
| Qry Get Raizcorp Possibles Moved Last Week |
Select |
CompanyStatus, SubQry Get Raizcorp Possibles Position, Entrepreneur Company Status History |
| Qry Get Sheet Names for Conpany Profiles |
Select |
Qry Count Entrepreneurs by Company for Projile, Qry |
| Qry Lead Type List |
Select |
Lead Types, Principal Projects, Principals... |
| Qry Notifications Sent by Entrpreneur |
Select |
Entrepreneur, Entrepreneur Notifications Sent |
| Qry Pipeline Detail List |
Select |
Pipelines Detail, Pipelines, ProcessStatus |
| Qry Possible Date Created |
Select |
Entrepreneurs |
| Qry Principal List |
Select |
Principals |
| Qry Process Status List Digital Pipelines |
Select |
Pipelines Detail, Pipelines, ProcessStatus |
| Qry Process Status NOT in Pipeline List |
Select |
SubQry Process Status NOT in Pipeline List, ProcessStatus |
| Qry Product Distribution Model List |
Select |
Products, Product Distribution Models, Distribution Models |
| Qry Product Division List |
Select |
Products, Product Divisions, Divisions |
| Qry Product List |
Select |
Products, Pipelines |
| Qry Report Active Companies Email |
Select |
Entrepreneur Company, Entrepreneurs, Distribution Models |
| Qry Report Allocation Export Graduated Companies |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| Qry Report Allocation Export Non Graduate Companies |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, NonGraduateReason... |
| Qry Report Allocation Export On Programme Companies |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| Qry Report Arize First Meeting |
Select |
Success, Products, Entrepreneur Company... |
| Qry Report Average Days Per Step |
Select |
SubQry, SubQry Rpt Average Days Per Step Sum Days, SubQry Rpt Average Days Per Step Get DL and Owner... |
| Qry Report Average Time Through Pipeline by Distribution Model |
Select |
SubQry, MonthLkUp, SubQry Rpt Average Time Through Pipeline Criteria |
| Qry Report Avg Time Through Pipeline by Delivery Loc |
Select |
SubQry, SubQry Rpt Average Time Through Pipeline by Delivery Location |
| Qry Report Avg Time Through Pipeline Trend by Delivery Location |
Select |
|
| Qry Report Blank Owned By |
Select |
Lead Types, Products, Entrepreneur Company... |
| Qry Report Blue Heart Email Not Sent |
Select |
DatabaseUsers, ProcessStatus, Entrepreneurs |
| Qry Report Company Profile Merge Data |
Select |
Entrepreneur, Qry Get Entrepreneur Info for Projile Merge, Entrepreneur Company... |
| Qry Report Contract End Date Expire |
Select |
CompanyStatus, Entrepreneur Company, Qry Get Last Programme Year ID by Company... |
| Qry Report Contract not Printed or VA Packs not Delivered |
Select |
vwPurpleReportContractnotPrintedorVAPacksnotDelivered |
| Qry Report Current Pipeline EP Detail by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| Qry Report Days in Pipeline Detail |
Select |
|
| Qry Report Detailed Movement by Date Range |
Select |
SubQry Rpt Detailed Movement Date Range, Lead Types, Entrepreneur Company... |
| Qry Report Detailed Movement by Owned By |
Select |
Lead Types, Entrepreneur Company, Entrepreneurs... |
| Qry Report Detailed Movement by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Lead Types... |
| Qry Report Detailed Movement by Recommended Principal Project |
Select |
SubQry Rpt Detailed Movement Date Range, Lead Types, Entrepreneur Company... |
| Qry Report Detailed Movement Pipeline by Date Range |
Select |
Lead Types, Entrepreneur Company, Entrepreneurs... |
| Qry Report Entrepreneur List Principal Projects |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Lead Types... |
| Qry Report Entrepreneur List |
Select |
Lead Types, Principal Projects, Products... |
| Qry Report Entrepreneur Summary by Distribution Model |
Select |
vwPurpleReportEntrepreneurSummary |
| Qry Report Entrepreneur Summary by Principal Project |
Select |
vwPurpleReportEntrepreneurSummary |
| Qry Report Entrepreneurial Profiles |
Select |
SubQry Rpt Entrepreneurial Profiles, CompanyStatus, Principal Projects... |
| Qry Report Entrepreneurs by Lead Type |
Select |
Lead Types, Entrepreneur Company, TerminationReason... |
| Qry Report Entrepreneurs Invoice Requested |
Select |
Products, Entrepreneur Company, Entrepreneurs... |
| Qry Report Entrepreneurs Modified by Date Range |
Select |
Entrepreneur Edit History, Lead Types, Entrepreneur Company... |
| Qry Report EOI Entrepreneur |
Select |
CountryLookup, Entrepreneurs, Divisions |
| Qry Report Headhunting by Owned By |
Select |
SubQry Rpt Headhunting Count Qualified by Owned By, SubQry, SubQry Rpt Headhunting Count Total by Owned By |
| Qry Report Lead Daily Breakdown |
Select |
SubQry Rpt Lead Daily Breakdown Count Total Leads, SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads, SubQry... |
| Qry Report Lead Type to Principal Allocation |
Select |
SubQry, SubQry Rpt Lead Type to Principal Allocation Criteria |
| Qry Report Marketing EOI to Passed Panel |
Select |
SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel, Lead Types, SubQry Rpt Marketing EOI to Passed Panel Count Qualified... |
| Qry Report Marketing Leads by Date |
Select |
SubQry Rpt Count Total Leads Generated by Date, SubQry, SubQry Rpt Count Qualified Leads by Date |
| Qry Report Marketing Leads Version Two |
Select |
SubQry Rpt Count Uncontacted Leads, SubQry Rpt Count Unqualified Leads, SubQry Rpt Count Followed Up Leads... |
| Qry Report Marketing Leads |
Select |
SubQry Rpt Count Exited Leads, SubQry Rpt Count Passed Panel Leads, SubQry... |
| Qry Report Marketing Pre-Unqualified Leads |
Select |
UnqualifiedReason, Lead Types, ProcessStatus... |
| Qry Report More Than 3 Follow Ups |
Select |
SubQry Rpt More Than 3 Follow Ups Count, Lead Types, Entrepreneur Company... |
| Qry Report Opal Prin Proj Summary Company Contracts by End Date |
Select |
SubQry Rpt Opal Principal Project Summary Criteria |
| Qry Report Opal Prin Proj Summary Weighted Companies |
Select |
SubQry Rpt Opal Principal Project Summary Criteria, SubQry |
| Qry Report Opal Prin Proj Summary Weighted EPs and Comp by DL |
Select |
SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc, SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc, SubQry |
| Qry Report Opal Principal Project Companies Required |
Select |
Qry Get Delivery Locations Allowed by Principal Project, Principal Projects, Qry Sum Companies Required by Principal Project... |
| Qry Report Opal Principal Project Count Comp Req _1 Del Loc |
Select |
SubQry, SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc |
| Qry Report Opal Principal Project Sum Comp Req _1 Del Loc |
Select |
SubQry, SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc |
| Qry Report Opal Principal Project Sum Comp Required 1 Del Loc |
Select |
Qry Get Delivery Locations Allowed by Principal Project, Qry Count Delivery Locations Allowed by Principal Project, Principal Projects... |
| Qry Report Opal Principal Projects by Industry |
Select |
Qry Sum Total Sponsorship by Principal Project, Qry Sum Total Spend by Principal Project, Qry Count Current Active Allocated Companies On Pgm by Prin Proj... |
| Qry Report Opal Raizcorpossibles and Part Sponsorship |
Select |
Qry Get Del Loc Raizcorpossibles Part Sponsorship, Qry Count Current Part Sponsorship by Delivery Location, Qry... |
| Qry Report P3 Graduates Not Active Exited 5 Months Ago |
Select |
Entrepreneur, CompanyStatus, Entrepreneur Company... |
| Qry Report Panel Passes per Scout |
Select |
Qry Count Total Panels Held by Scout, Qry Count Total Panels Passed by Scout, Qry Count Total Assessments Passed by Scout... |
| Qry Report Part Sponsorship Entrepreneurs |
Select |
vwPurpleReportPartSponsorshipEntrepreneurs |
| Qry Report Part Sponsorship |
Select |
SubQry, SubQry Rpt Part Sponsorship |
| Qry Report Partner Elite Get Status Step 1 |
Select |
Qry Report Partner Elite Pipeline Step 1, Qry |
| Qry Report Partner Elite Get Steps 2-7 |
Select |
Qry, Qry Report Partner Elite Pipeline Step 2-7 |
| Qry Report Partner Elite Pipeline Get Lead Types |
Select |
|
| Qry Report Partner Elite Pipeline Step 1 |
Select |
Lead Types, ProcessStatus, Entrepreneurs |
| Qry Report Partner Elite Pipeline Step 2-7 |
Select |
ProcessStep, Lead Types, ProcessStatus... |
| Qry Report Partner Elite Pipeline Unqualified or Terminated |
Select |
Lead Types, ProcessStatus, Entrepreneurs |
| Qry Report Partner Elite Summary |
Select |
Qry Get Last Note by Entrepreneur, Entrepreneur Company, IndustryLookup... |
| Qry Report Percent Dropoff After 1st Meeting |
Select |
SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2, SubQry, SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2... |
| Qry Report Percentage Moved Last Week Digital |
Select |
Qry Count Entrepreneur Moved Last Week Digital Process, SubQry, SubQry Rpt Percentage Moved Last Week Digital... |
| Qry Report Percentage Moved Last Week Manual |
Select |
Qry Count Entrepreneur Steps 1 to 7 Manual Process, Qry Count Entrepreneur Moved Last Week Manual Process, Qry... |
| Qry Report Pipeline List |
Select |
Pipelines Detail, Pipelines, ProcessStatus |
| Qry Report Principal Project Allocation by Entrepreneur |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| Qry Report Principal Project Information |
Select |
Client Tiers, PrincipalProjectStatus, Principal... |
| Qry Report Process Status All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry Report Process Status by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry Report Process Status by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry Report Process Status by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry Report Purple Panelists Summary |
Select |
SubQry Rpt Purple Panelists Sum Scores, SubQry Rpt Purple Panelists Summary, SubQry... |
| Qry Report Quartz Leads by Phase |
Select |
Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location, Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location, Qry Count Unallocated Companies by EP Delivery Location... |
| Qry Report RAG |
Select |
vwPurpleReportRAG, vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar, vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar |
| Qry Report Raizcorp Possibilities |
Select |
ProcessStatus, vwPurpleReportRaizcorpPossibilities |
| Qry Report Raizcorpossible Companies Email |
Select |
Entrepreneur Company, Entrepreneurs, Distribution Models |
| Qry Report Recommended Principal Project Allocation |
Select |
Principal Projects, Products, SubQry Rpt Recommended Principal Project Allocation... |
| Qry Report Selection Daily Team Activity by Delivery Location |
Select |
SubQry Rpt Count Unqualified by Del Loc, SubQry Rpt Count Meetings by Del Loc, SubQry Rpt Count Terminations by Del Loc... |
| Qry Report Selection Daily Team Activity |
Select |
SubQry Rpt Count Entrepreneurs With Pipeline Moves, SubQry Rpt Get Owned By, SubQry Rpt Count Meetings by Owned By... |
| Qry Report Selection Team Activity Summary |
Select |
SubQry Rpt Selection Team Summary Total Passed Panel, SubQry Rpt Selection Team Summary Total Graduated Off, SubQry Rpt Selection Team Summary Total On Programme... |
| Qry Report Selection Team Activity Times by Delivery Location |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs... |
| Qry Report Selection Team Activity Times by Modified By |
Select |
Entrepreneur Status History, ProcessStatus |
| Qry Report Selection Team Call Activity |
Select |
SubQry Rpt Get Modified By, SubQry Rpt Count Unqualified by Modified By, SubQry... |
| Qry Report Selection Team Targets |
Select |
Qry Count Entreprenur Steps Total at 8, Qry Count Entreprenur Steps Total at 1 and 4, Qry Count Entreprenur Steps Total at 1 and 3... |
| Qry Report Step Movement |
Select |
|
| Qry Report Steps Skipped Error Report |
Select |
|
| Qry Report Termination Analysis Data |
Select |
vwPurpleReportTerminationAnalysisData |
| Qry Report Termination Analysis Successful Data |
Select |
vwPurpleReportTerminationAnalysisSuccessfulData |
| Qry Report User Permissions |
Select |
DatabaseUsers, DatabaseUsers Module Permissions |
| Qry Report VA Packs Required in Four Weeks |
Select |
Principal Projects, Principals |
| Qry Report VA Packs Required in Two Weeks |
Select |
Principal Projects, Principals |
| Qry Report Workshop Attendance Register |
Select |
Entrepreneur Company, Entrepreneurs, ProcessStatus |
| Qry Report Writer |
Select |
vwPurpleGetLastNotebyEntrepreneur, Lead Types, Principal Projects... |
| QRY Restore Deleted leads |
Delete |
Restore, Restore Deleted Leads |
| Qry SubFrm Principal Project Pillar Supporting Documents |
Select |
Principal Project Pillars, Principal |
| Qry SubRpt Allocation by Principal Project |
Select |
vwPurpleSubRptAllocationbyPrincipalProject, Qry Sum Total Replaced Billed to Date by Principal Project, Qry Count Companies by Principal Project Principal Report... |
| Qry SubRpt Allocation Replaced by Principal Project |
Select |
Qry Sum Total Spend by Principal Project, Qry, vwPurpleSubRptAllocationReplacedbyPrincipalProject |
| Qry SubRpt BEE Certificate Blank |
Select |
Product Divisions, CompanyStatus, Divisions... |
| Qry SubRpt Company Principal Project by Programme Year |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Principal Projects... |
| Qry SubRpt Count Records Created by Del Loc |
Select |
SubQry Count Records Created Dist Model Criteria, SubQry, Delivery Locations |
| Qry SubRpt Count Records Created |
Select |
SubQry Count Records Created Criteria, SubQry |
| Qry SubRpt Count Step 1 Status by Del Loc |
Select |
SubQry, SubQry Count Step 1 Status Dist Model Criteria, Delivery Locations |
| Qry SubRpt Count Step 1 Status |
Select |
SubQry, SubQry Count Step 1 Status Criteria |
| Qry SubRpt Daily Lead Summary Delivery RC Poss All Divs |
Select |
Qry Get Division Dist Model and Rec Info by Company, Products, Entrepreneur Company... |
| Qry SubRpt Daily Lead Summary Follow Up All Divisions |
Select |
Entrepreneurs, Distribution Models, Delivery Locations |
| Qry SubRpt Daily Lead Summary Follow Up One Division |
Select |
Entrepreneurs, Distribution Models, Delivery Locations |
| Qry SubRpt Daily Lead Summary Leads Less Than 48 Hours All Divs |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary Leads More Than 48 Hours All Divs |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary New Leads All Divisions |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary New Leads by Lead Type All Divs |
Select |
Lead Types, Entrepreneurs |
| Qry SubRpt Daily Lead Summary New Leads by Lead Type One Div |
Select |
Lead Types, Entrepreneurs |
| Qry SubRpt Daily Lead Summary New Leads One Division |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary Pipeline All Divisions |
Select |
ProcessStatus, Entrepreneurs, Distribution Models... |
| Qry SubRpt Daily Lead Summary Pipeline One Division |
Select |
ProcessStatus, Entrepreneurs, Distribution Models... |
| Qry SubRpt Daily Lead Summary Raizcorp Possibles All Divs |
Select |
vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs |
| Qry SubRpt Daily Lead Summary Uncontacted All Divisions |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary Uncontacted One Division |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary Uncontacted PnP All Divisions |
Select |
Entrepreneurs |
| Qry SubRpt Daily Lead Summary Uncontacted PnP One Division |
Select |
Entrepreneurs |
| Qry SubRpt Entrepreneur Edit History |
Select |
Entrepreneur Edit History, Entrepreneur |
| Qry SubRpt Entrepreneur Edit Status History |
Select |
Entrepreneur Status History, Entrepreneur, ProcessStatus |
| Qry SubRpt Entrepreneur Profile Merge Data |
Select |
Products, ProcessStatus, Entrepreneurs... |
| Qry SubRpt Entrepreneurial Assessment Results List |
Select |
Entrepreneur Company, Entrepreneurs, Delivery Locations |
| Qry SubRpt Entrepreneurial Assessment Results |
Select |
Qry Count Entrepreneurial Assessment Results, Entrepreneurs |
| Qry SubRpt Entrepreneurial Assessment Retake Results List |
Select |
Entrepreneur Company, Entrepreneurs, Delivery Locations |
| Qry SubRpt Entrepreneurial Assessment Retake Results |
Select |
Qry Count Entrepreneurial Assessment Retake Results, Entrepreneurs |
| Qry SubRpt EOI Entrepreneur Company |
Select |
IndustryLookup, Entrepreneur, Entrepreneur Company |
| Qry SubRpt Exec Lead Summary Headhunted Single Date All Divs |
Select |
Entrepreneurs |
| Qry SubRpt Exec Lead Summary Headhunted Single Date One Div |
Select |
Entrepreneurs |
| Qry SubRpt Lead Delivery Location All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Lead Delivery Location by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Lead Delivery Location by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Lead Process Status All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Lead Process Status by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry SubRpt Lead Process Status by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Lead Process Status by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Lead Summary Headhunted Date Range |
Select |
Entrepreneurs |
| Qry SubRpt Lead Summary Referred to Prosperator Date Range |
Select |
Entrepreneur Status History, Entrepreneurs, Delivery Locations |
| Qry SubRpt Lead Unqualified All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Lead Unqualified by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry SubRpt Lead Unqualified by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Lead Unqualified by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Lead Unqualified Reason All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Lead Unqualified Reason by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry SubRpt Lead Unqualified Reason by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Lead Unqualified Reason by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Pipeline Process Status All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Pipeline Process Status by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry SubRpt Pipeline Process Status by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Pipeline Process Status by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Pipeline Terminated All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Pipeline Terminated by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry SubRpt Pipeline Terminated by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Pipeline Terminated by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Pipeline Termination Reason All Lead Types |
Select |
SubQry, SubQry Count Process Status All Lead Types Criteria |
| Qry SubRpt Pipeline Termination Reason by Delivery Location |
Select |
SubQry, SubQry Count Process Status by Delivery Location Criteria |
| Qry SubRpt Pipeline Termination Reason by Lead Type |
Select |
SubQry, SubQry Count Process Status by Lead Type Criteria |
| Qry SubRpt Pipeline Termination Reason by Principal Project |
Select |
SubQry, SubQry Count Process Status by Principal Project Criteria |
| Qry SubRpt Principal Project Allocation Audit Replaced Companies |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| Qry SubRpt Principal Project Pillar Delivery Locations |
Select |
|
| Qry SubRpt Principal Project Pillars |
Select |
Principal Project Pillars, Principal |
| Qry SubRpt Products Sold by Principal Project |
Select |
Principal, Principal Project Products Sold |
| Qry SubRpt Progress Category Mktg by Principal Project |
Select |
SubQry, SubQry Count Progress Category RM by Principal Project Criteria |
| Qry SubRpt Progress Category Sup List by Principal Project |
Select |
SubQry Count Progress Category SL by Principal Project Criteria, SubQry |
| Qry SubRpt Purple Panel Results Date Range |
Select |
Qry, Entrepreneurs, Qry Count Purple Panel Results Date Range |
| Qry SubRpt Purple Panel Results List Date Range |
Select |
Entrepreneur Company, Entrepreneurs, Delivery Locations |
| Qry SubRpt Sponsorship Elements by Principal Project |
Select |
Qry Sum Sponsor Elements Payments by Company, vwPurpleSubRptSponsorshipbyPrincipalProject, Qry Sum Total Sponsor Elements by Principal Project... |
| Qry SubRpt Termination Marketing by Principal Project |
Select |
vwPurpleSubRptTerminatedMarketingbyPrincipalProject |
| Qry SubRpt Termination Reasons Marketing by Principal Project |
Select |
vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject |
| Qry SubRpt Termination Reasons Supplier Lst by Principal Project |
Select |
vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj |
| Qry SubRpt Termination Supplier List by Principal Project |
Select |
vwPurpleSubRptTerminatedSupplierListbyPrincipalProject |
| Qry SubRpt Unqualified Marketing by Principal Project |
Select |
vwPurpleSubRptUnqualifiedMarketingbyPrincipalProject |
| Qry SubRpt Unqualified Reasons Marketing by Principal Project |
Select |
vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject |
| Qry SubRpt Unqualified Reasons Supplier Lst by Principal Project |
Select |
vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj |
| Qry SubRpt Unqualified Supplier List by Principal Project |
Select |
vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject |
| Qry Sum Companies Required by Principal Project |
Select |
Principal Project Pillars, Principal |
| Qry Sum Sponsor Elements Payments by Company |
Select |
Entrepreneur, Entrepreneur Company Extra Sponsor Payments |
| Qry Sum Total Allocated Amt by Company |
Select |
Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Sum Total Replaced Billed to Date by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company Monthly Billings... |
| Qry Sum Total Replaced Selection Fee by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| Qry Sum Total Spend by Principal Project |
Select |
Principal Project Pillars, Principal |
| Qry Sum Total Sponsor Elements by Principal Project |
Select |
Principal Project Pillar Sponsor Elements, Principal, Principal Project Pillars |
| Qry Sum Total Sponsor Elements Spend by Principal Project |
Select |
Principal Project Pillar Sponsor Elements, Entrepreneur, Principal Project Pillars... |
| Qry Sum Total Sponsorship by Principal Project Pillar |
Select |
Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Sum Total Sponsorship by Principal Project |
Select |
Principal Project Pillars, Entrepreneur, Entrepreneur Company Principal Projects |
| Qry User List |
Select |
DatabaseUsers |
| Qry User Module List |
Select |
DatabaseUsers, DatabaseUsers Module Permissions |
| Qry View Entrepreneur Digital First Meeting |
Select |
Entrepreneurs |
| qryLinkODBC |
Select |
zstblODBC_tables, zstblODBC_db |
| SubQry Count Companies by Principal Project Principal Report |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| SubQry Count Current Active Companies Total |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| SubQry Count Current Active Entrepreneurs Total |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| SubQry Count Entrepreneurs by Principal Project Principal Report |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, Entrepreneur Company... |
| SubQry Count EPs With Pipeline Moves Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Count EPs With Pipeline Moves Dist Model Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Count First Meeting Setup Criteria |
Select |
Entrepreneur Status History, Entrepreneurs, Delivery Locations |
| SubQry Count Followed Up Criteria |
Select |
Entrepreneur Status History, Entrepreneurs, Delivery Locations |
| SubQry Count Headhunted by OwnedBy Date Range Criteria |
Select |
ProcessStatus, Entrepreneurs |
| SubQry Count Meetings Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Count Meetings Dist Model Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Count Process Status All Lead Types Criteria |
Select |
Lead Types, TerminationReason, UnqualifiedReason... |
| SubQry Count Process Status by Delivery Location Criteria |
Select |
Lead Types, TerminationReason, UnqualifiedReason... |
| SubQry Count Process Status by Lead Type Criteria |
Select |
Lead Types, Temp Lead Type for Lead Report, TerminationReason... |
| SubQry Count Process Status by Principal Project Criteria |
Select |
Temp Principal Project for Lead Report, Lead Types, TerminationReason... |
| SubQry Count Progress Category RM by Principal Project Criteria |
Select |
vwPurpleCountProgressCategoryRMbyPrinProjCriteria |
| SubQry Count Progress Category SL by Principal Project Criteria |
Select |
vwPurpleCountProgressCategorySLbyPrinProjCriteria |
| SubQry Count Records Created Criteria |
Select |
Entrepreneurs |
| SubQry Count Records Created Dist Model Criteria |
Select |
Entrepreneurs |
| SubQry Count Step 1 Status Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Count Step 1 Status Dist Model Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Count Terminations Criteria |
Select |
Entrepreneur Status History, Entrepreneurs |
| SubQry Count Terminations Dist Model Criteria |
Select |
Entrepreneur Status History, Entrepreneurs |
| SubQry Count Unqualified Criteria |
Select |
Entrepreneur Status History, Entrepreneurs, Delivery Locations |
| SubQry Count Unqualified Dist Model Criteria |
Select |
Entrepreneur Status History, Entrepreneurs |
| SubQry Duplicate Entrepreneurs Alt |
Select |
Entrepreneurs |
| SubQry Duplicate Entrepreneurs |
Select |
Entrepreneurs |
| SubQry Export Entrepreneur Information for Contract Mail Merge |
Select |
Principal Project Pillars, BBBEEPillarLookup, Entrepreneur Company Principal Projects... |
| SubQry Get Entrepreneur Moved Last Week Criteria |
Select |
Entrepreneur Status History, Entrepreneur, ProcessStatus... |
| SubQry Get Entrepreneur Moved Last Week |
Select |
SubQry Get Entrepreneur Moved Last Week Criteria, SubQry |
| SubQry Get Entrepreneur Steps Date Range Criteria |
Select |
Entrepreneur Status History, ProcessStatus |
| SubQry Get Entrepreneur Steps Delivery Location Criteria |
Select |
|
| SubQry Get Entrepreneur Steps For Summary Criteria |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Get Entrepreneur Steps Lead Type Criteria |
Select |
vwPurpleGetEntrepreneurStepsCriteria |
| SubQry Get Entrepreneur Steps Owned by Criteria |
Select |
vwPurpleGetEntrepreneurStepsCriteria |
| SubQry Get Entrepreneur Steps Recommended Principal Project Crit |
Select |
vwPurpleGetEntrepreneurStepsCriteria |
| SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit |
Select |
Entrepreneur Status History, ProcessStatus, Entrepreneurs |
| SubQry Get Entrepreneurs Modified Pipeline Date Range Crit |
Select |
Entrepreneur Status History, Entrepreneur, ProcessStatus... |
| SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit |
Select |
Entrepreneur Status History, Entrepreneur, ProcessStatus... |
| SubQry Get EPs Modified Pipeline 1 Prin Proj Date Range Crit |
Select |
Entrepreneur Status History, Principal Project Pillars, Entrepreneur Company Principal Projects... |
| SubQry Get Last Programme Year for Exited Companies |
Select |
Principal Projects, Entrepreneur Company, Principals... |
| SubQry Get Moved Last Week to Active PP Allocated Exited |
Select |
vwPurpleGetMovedLastWeektoActivePPAllocatedExited |
| SubQry Get Raizcorp Possibles Position |
Select |
SubQry Get Moved Last Week to Active PP Allocated Exited, SubQry, Entrepreneur Company Status History |
| SubQry Process Status NOT in Pipeline List |
Select |
Pipelines Detail, Pipelines |
| SubQry Rpt Assessment Panel Passes per Scout |
Select |
Entrepreneurs |
| SubQry Rpt Average Days Per Step Count EPs |
Select |
SubQry, SubQry Rpt Average Days Per Step |
| SubQry Rpt Average Days Per Step Get DL and Owner |
Select |
SubQry, SubQry Rpt Average Days Per Step |
| SubQry Rpt Average Days Per Step Sum Days |
Select |
SubQry, SubQry Rpt Average Days Per Step |
| SubQry Rpt Average Days Per Step |
Select |
Temp Entrepreneur Steps, ProcessStatus, Entrepreneurs... |
| SubQry Rpt Average Time Through Pipeline by Delivery Location |
Select |
SubQry, SubQry Rpt Average Time Through Pipeline Criteria |
| SubQry Rpt Average Time Through Pipeline Criteria |
Select |
Temp, Pipelines, Temp Entrepreneur Steps... |
| SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc |
Select |
ProcessStatus, Entrepreneurs |
| SubQry Rpt Count Entrepreneurs In the Pipeline |
Select |
ProcessStatus, Entrepreneurs |
| SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc |
Select |
SubQry Count EPs With Pipeline Moves Dist Model Criteria, SubQry |
| SubQry Rpt Count Entrepreneurs With Pipeline Moves |
Select |
SubQry, SubQry Count EPs With Pipeline Moves Criteria |
| SubQry Rpt Count Exited Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count First Meeting Setup by Modified By |
Select |
SubQry Count First Meeting Setup Criteria, SubQry |
| SubQry Rpt Count Followed Up by Modified By |
Select |
SubQry, SubQry Count Followed Up Criteria |
| SubQry Rpt Count Followed Up Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Meetings by Del Loc |
Select |
SubQry, SubQry Count Meetings Dist Model Criteria |
| SubQry Rpt Count Meetings by Owned By |
Select |
SubQry Count Meetings Criteria, SubQry |
| SubQry Rpt Count On Hold Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Passed Panel Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Qualified Leads by Date |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Qualified Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Terminated Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Terminations by Del Loc |
Select |
SubQry Count Terminations Dist Model Criteria, SubQry |
| SubQry Rpt Count Terminations by Owned By |
Select |
SubQry Count Terminations Criteria, SubQry |
| SubQry Rpt Count Total Leads Generated by Date |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Total Leads Generated |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Uncontacted Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Count Unqualified by Del Loc |
Select |
SubQry Count Unqualified Dist Model Criteria, SubQry |
| SubQry Rpt Count Unqualified by Modified By |
Select |
SubQry, SubQry Count Unqualified Criteria |
| SubQry Rpt Count Unqualified by Owned By |
Select |
SubQry, SubQry Count Unqualified Criteria |
| SubQry Rpt Count Unqualified Leads |
Select |
SubQry Rpt Marketing Leads Criteria, SubQry |
| SubQry Rpt Detailed Movement Date Range Criteria |
Select |
Entrepreneur Status History, Entrepreneur |
| SubQry Rpt Detailed Movement Date Range |
Select |
SubQry Rpt Detailed Movement Date Range Criteria, SubQry |
| SubQry Rpt Detailed Movement Owned by Criteria |
Select |
Entrepreneur Status History, Entrepreneurs |
| SubQry Rpt Detailed Movement Owned By |
Select |
SubQry, SubQry Rpt Detailed Movement Owned by Criteria |
| SubQry Rpt Detailed Movement Pipeline Date Range Criteria |
Select |
Entrepreneur Status History, Entrepreneur, ProcessStatus |
| SubQry Rpt Detailed Movement Pipeline Date Range |
Select |
SubQry, SubQry Rpt Detailed Movement Pipeline Date Range Criteria |
| SubQry Rpt Entrepreneurial Profiles |
Select |
|
| SubQry Rpt Get Modified By |
Select |
|
| SubQry Rpt Get Owned By |
Select |
|
| SubQry Rpt Headhunting by Owned By Date Range Criteria |
Select |
Entrepreneurs |
| SubQry Rpt Headhunting Count Qualified by Owned By |
Select |
SubQry Rpt Headhunting by Owned By Date Range Criteria, SubQry |
| SubQry Rpt Headhunting Count Total by Owned By |
Select |
SubQry Rpt Headhunting by Owned By Date Range Criteria, SubQry |
| SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads |
Select |
SubQry Rpt Lead Daily Breakdown Criteria, SubQry |
| SubQry Rpt Lead Daily Breakdown Count Qualified Leads |
Select |
SubQry Rpt Lead Daily Breakdown Criteria, SubQry |
| SubQry Rpt Lead Daily Breakdown Count Total Leads |
Select |
SubQry Rpt Lead Daily Breakdown Criteria, SubQry |
| SubQry Rpt Lead Daily Breakdown Criteria |
Select |
Lead Types, ProcessStatus, Entrepreneurs |
| SubQry Rpt Lead Type to Principal Allocation Criteria |
Select |
vwPurpleRptLeadTypetoPrincipalAllocationCriteria |
| SubQry Rpt Marketing EOI to Passed Panel Count EOI |
Select |
Temp, Entrepreneurs, Temp Lead Type for Lead Report |
| SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel |
Select |
Temp, Entrepreneurs, Temp Lead Type for Lead Report |
| SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit |
Select |
Entrepreneur Status History, Entrepreneurs, Temp Lead Type for Lead Report... |
| SubQry Rpt Marketing EOI to Passed Panel Count Qualified |
Select |
SubQry, SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit |
| SubQry Rpt Marketing Leads Criteria |
Select |
Entrepreneur Company, Lead Types, ProcessStatus... |
| SubQry Rpt More Than 3 Follow Ups Count |
Select |
Entrepreneur Status History, Entrepreneur |
| SubQry Rpt Opal Prin Proj Summary Comp Required _1 Del Loc |
Select |
Principal, Qry Sum Companies Required by Principal Project, Principal Projects... |
| SubQry Rpt Opal Prin Proj Summary Count Active Comp |
Select |
SubQry Rpt Opal Principal Project Summary Criteria, SubQry |
| SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc |
Select |
SubQry Rpt Opal Principal Project Summary Criteria, SubQry |
| SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc |
Select |
SubQry Rpt Opal Principal Project Summary Criteria, SubQry, Entrepreneurs |
| SubQry Rpt Opal Principal Project Summary Criteria |
Select |
vwPurpleRptOpalPrincipalProjectSummaryCriteria |
| SubQry Rpt Opal Principal Projects by Industry |
Select |
Principal Project Pillars, Principal, Principal Projects... |
| SubQry Rpt Part Sponsorship |
Select |
vwPurpleReportPartSponsorship, Qry, Qry Sum Total Allocated Amt by Company |
| SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2 |
Select |
SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2, SubQry |
| SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2 |
Select |
SubQry, SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2 |
| SubQry Rpt Percent Dropoff After 1st Meeting Count 1st Meeting |
Select |
SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs, SubQry |
| SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs |
Select |
Entrepreneur Status History, Entrepreneur |
| SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2 |
Select |
SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs, SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2, SubQry... |
| SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2 |
Select |
Entrepreneur Status History, SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs, SubQry... |
| SubQry Rpt Percent Raizcorp Possibles Moved Last Week |
Select |
Qry, Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc, Qry Count Current Raizcorp Possibles by Delivery Location... |
| SubQry Rpt Percentage Moved Last Week Digital |
Select |
Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location, Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca, Qry |
| SubQry Rpt Percentage Moved Last Week Manual |
Select |
Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location, Qry, Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location |
| SubQry Rpt Purple Panelists Attended |
Select |
SubQry, SubQry Rpt Purple Panelists Summary Criteria |
| SubQry Rpt Purple Panelists Convened |
Select |
SubQry, SubQry Rpt Purple Panelists Summary Criteria |
| SubQry Rpt Purple Panelists Sum Scores |
Select |
SubQry, SubQry Rpt Purple Panelists Summary Criteria |
| SubQry Rpt Purple Panelists Summary Criteria |
Select |
Entrepreneur, Entrepreneurs, Entrepreneur Purple Panelists |
| SubQry Rpt Purple Panelists Summary |
Select |
|
| SubQry Rpt RAG Criteria |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| SubQry Rpt Recommended Principal Project Allocation |
Select |
Principal Project Pillars, Entrepreneur Company Principal Projects, CompanyStatus... |
| SubQry Rpt Selection Team Activity Summary Criteria |
Select |
Entrepreneur Company, CompanyProgrammeYearStatus, ProcessStatus... |
| SubQry Rpt Selection Team Summary Total Graduated Off |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| SubQry Rpt Selection Team Summary Total Leads Generated |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| SubQry Rpt Selection Team Summary Total Non Graduate |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| SubQry Rpt Selection Team Summary Total On Programme |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| SubQry Rpt Selection Team Summary Total Passed Assessment |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| SubQry Rpt Selection Team Summary Total Passed Panel |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| SubQry Rpt Selection Team Summary Total Qualified |
Select |
SubQry Rpt Selection Team Activity Summary Criteria, SubQry |
| TestQuery |
Select |
|