| Backdoor Qry Company List |
Select |
Entrepreneur, Entrepreneur Company, Qry Get Last Complete Submission by Company |
| JB Initialize Company Added New Staff |
Update |
Submissions |
| Qry Assigned Companies with No Submissions |
Select |
Submissions, Entrepreneur, Entrepreneurs... |
| Qry Company List |
Select |
MonthLkUp, vwAmberCompanyList |
| Qry Company Submission List |
Select |
vwAmberCompanySubmissionList, MonthLkUp |
| Qry Count Companies Assigned by Bookkeeper |
Select |
Qry Report Companies Assigned, Qry |
| Qry Count ED or SD Companies Bought From by Principal Project |
Select |
by, SubQry Count ED or SD Companies Bought From by Principal Project, SubQry |
| Qry Count Number ED Allocated by Principal Project Pillar |
Select |
Entrepreneur Company Principal Projects, Principal, Principal Project Pillars |
| Qry Count Number SD Allocated by Principal Project Pillar |
Select |
Entrepreneur Company Principal Projects, Principal, Principal Project Pillars |
| Qry Count Pre-Ignition Financial Entries by Company |
Select |
Entrepreneur Company Pre Ignition Financials, Entrepreneur |
| Qry Count Submission Financial Complete Entries by Company |
Select |
Submissions |
| Qry Get Companies Assigned Both Bookkeepers |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, Qry Get Last Submission ID by Company... |
| Qry Get Companies Assigned Raizcorp Bookkeeper |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, Qry Get Last Submission ID by Company... |
| Qry Get Companies for Principal Spend Tracking Report |
Select |
Entrepreneur, Entrepreneur Company, Principal Project Pillars... |
| Qry Get Companies Not Non Graduate |
Select |
Entrepreneur, Entrepreneur Company, Entrepreneur Company Programme Years... |
| Qry Get Delivery Locations for Bookkeeping Compliance Report |
Select |
Delivery Locations, Entrepreneur Company, Delivery... |
| Qry Get Financial Information by Month Number |
Select |
Submissions, MonthLkUp |
| Qry Get Highest Permanent Staff Number |
Select |
Submissions |
| Qry Get Last Complete Submission by Company |
Select |
Submissions, Qry Get Last Complete Submission ID by Company, SubQry Get Last Complete Submission by Company... |
| Qry Get Last Complete Submission ID by Company |
Select |
Submissions, MonthLkUp |
| Qry Get Last Ignition Date by Company |
Select |
Entrepreneur, Entrepreneur Company Programme Years |
| Qry Get Last Month Principal Spend YTD |
Select |
Entrepreneur, Entrepreneur Company, MonthLkUp... |
| Qry Get Last Pre-Ignition Job Entry by Company |
Select |
Qry, Entrepreneur Company Pre Ignition Financials, Qry Get Last Pre-Ignition Month Name Year by Company |
| Qry Get Last Pre-Ignition Month Name Year by Company |
Select |
Qry Get Last Pre-Ignition Month Year by Company, MonthLkUp |
| Qry Get Last Pre-Ignition Month Year by Company |
Select |
Entrepreneur Company Pre Ignition Financials, Entrepreneur, MonthLkUp |
| Qry Get Last Programme Year ID by Company |
Select |
Entrepreneur, Entrepreneur Company Programme Years |
| Qry Get Last Programme Year Pillar by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Programme Years, Entrepreneur Company Principal Projects... |
| Qry Get Last Status Change by Company |
Select |
Submissions, Entrepreneur, Entrepreneur Company |
| Qry Get Last Submission ID by Company |
Select |
Submissions |
| Qry Get Last Submission Job Entry by Company |
Select |
|
| Qry Get Months Included Financial Detail |
Select |
Qry Report Financial Detail, Qry |
| Qry Get Permanent Staff Numbers by Submission Date |
Select |
Submissions, MonthLkUp |
| Qry Get Principal Projects for Principal Spend Tracking Report |
Select |
Entrepreneur, Entrepreneur Company, Principals... |
| Qry Get Principal Projects for Purchased ED vs SD Report |
Select |
Entrepreneur, Entrepreneur Company, Principal Project Pillars... |
| Qry Get Principal Spend by Submission Date |
Select |
Principal Project Pillars, MonthLkUp, Entrepreneur Company Principal Projects... |
| Qry Populate Temp Compliance by Company |
Delete |
Delivery Locations, Qry Get Companies Not Non Graduate, Qry Get Last Submission ID by Company... |
| Qry Pre Ignition List |
Select |
Entrepreneur Company Pre Ignition Financials, Entrepreneur, MonthLkUp |
| Qry Report Bookkeeper Tracker |
Select |
Qry Count Companies Assigned by Bookkeeper, SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper, Qry... |
| Qry Report Bookkeeping Compliance All Delivery Locations |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, Qry Get Last Submission ID by Company... |
| Qry Report Bookkeeping Compliance by Company |
Select |
Temp, Temp Compliance by Company |
| Qry Report Bookkeeping Compliance by Delivery Location |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, Qry Get Last Submission ID by Company... |
| Qry Report Books Not Submitted Both Bookkeepers |
Select |
SubQry, Qry Get Companies Assigned Both Bookkeepers, SubQry Rpt Books Not Submitted Raizcorp Bookkeeper |
| Qry Report Books Not Submitted Raizcorp Bookkeeper |
Select |
Qry, Qry Get Companies Assigned Raizcorp Bookkeeper, SubQry Rpt Books Not Submitted Raizcorp Bookkeeper |
| Qry Report Companies Assigned |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, Qry Get Last Submission ID by Company... |
| Qry Report Current Escalated to PM |
Select |
Submissions, Qry Get Companies Not Non Graduate, MonthLkUp... |
| Qry Report Current Outstanding Submissions |
Select |
Submissions, Qry Get Companies Not Non Graduate, MonthLkUp... |
| Qry Report Current Queries with Entrepreneurs |
Select |
Submissions, Qry Get Companies Not Non Graduate, MonthLkUp... |
| Qry Report ESD ESD Update Tab |
Select |
Qry Sum Total Allocated by Entrepreneur Programme Year, Entrepreneur, Qry Get Last Programme Year Pillar by Principal Project... |
| Qry Report ESD Exits and Replacements Tab |
Select |
NonGraduateReason, CompanyProgrammeYearStatus, Entrepreneur... |
| Qry Report ESD Futures Tab |
Select |
Entrepreneurs, Entrepreneur, Qry Get Last Programme Year Pillar by Principal Project... |
| Qry Report ESD Graduation Likelyhood Tab |
Select |
NonGraduateReason, CompanyProgrammeYearStatus, Entrepreneur... |
| Qry Report Financial Detail |
Select |
Delivery Locations, Entrepreneur, Entrepreneur Company... |
| Qry Report Financial Summary |
Select |
SubQry Company List Criteria, Delivery Locations, Qry Count Submission Financial Complete Entries by Company... |
| Qry Report Principal Projects Purchased ED vs SD S2S |
Select |
Qry Count Number SD Allocated by Principal Project Pillar, SubQry Purchased ED vs SD Report S2S, Qry Count Number ED Allocated by Principal Project Pillar... |
| Qry Report Principal Projects Purchased ED vs SD SDM |
Select |
Qry Count Number SD Allocated by Principal Project Pillar, Qry Count Number ED Allocated by Principal Project Pillar, by... |
| Qry Report Principal Spend by Company |
Select |
Entrepreneur Company, SubQry Rpt Sum Principal Spend by Company, Principals |
| Qry Report Principal Spend by Delivery Location |
Select |
SubQry Rpt Sum Principal Spend by Delivery Location, Delivery Locations, SubQry... |
| Qry Report Principal Spend by Principal and Company One Month |
Select |
Entrepreneur, Entrepreneur Company, Principal Project Pillars... |
| Qry Report Principal Spend by Principal YTD |
Select |
Entrepreneur, Principal Project Pillars, Principals... |
| Qry Report Principal Spend Tracking |
Select |
Submissions, Submissions Principal Spend, MonthLkUp |
| Qry Report SDM Opal Shift |
Select |
SubQry Rpt SDM Opal Shift Get Principals, SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal, SubQry Rpt SDM Opal Shift Sum Current Month Spend by Principal... |
| Qry Report Submission Detail by Company |
Select |
Submissions |
| Qry Submission List |
Select |
Submissions, MonthLkUp, Submission Status |
| Qry SubRpt Submission Status History |
Select |
Submissions, Submissions Status History, Submission Status |
| Qry Sum ED or SD Amount Purchased by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Programme Years, Entrepreneur Company Principal Projects... |
| Qry Sum Pre-Ignition Financials by Company |
Select |
Entrepreneur Company Pre Ignition Financials, Entrepreneur |
| Qry Sum Submission Financials by Company |
Select |
Submissions |
| Qry Sum Total Allocated by Entrepreneur Programme Year |
Select |
Entrepreneur, Entrepreneur Company Principal Projects |
| Qry Sum Total Sponsored by Principal Project |
Select |
Principal, Principal Project Pillars |
| qryLinkODBC |
Select |
zstblODBC_tables, zstblODBC_db |
| SubQry Company List Criteria |
Select |
Amber Distribution Models, Entrepreneur Company, Entrepreneur Company Programme Years... |
| SubQry Count ED or SD Companies Bought From by Principal Project |
Select |
Principal Project Pillars, Entrepreneur Company Programme Years, Entrepreneur Company Principal Projects... |
| SubQry Get Last Complete Submission by Company |
Select |
Submissions, MonthLkUp |
| SubQry Purchased ED vs SD Report S2S Criteria |
Select |
Entrepreneur, Entrepreneur Company, Principals... |
| SubQry Purchased ED vs SD Report S2S |
Select |
SubQry Purchased ED vs SD Report S2S Criteria, SubQry Purchased ED vs SD Report SDM, SubQry |
| SubQry Purchased ED vs SD Report SDM |
Select |
Principals, Principal Project Pillars, Principal... |
| SubQry Rpt Bookkeeping Compliance All Delivery Locations |
Select |
Submissions, MonthLkUp, Submission Status |
| SubQry Rpt Bookkeeping Compliance by Company |
Select |
Submissions, MonthLkUp, Submission Status |
| SubQry Rpt Books Not Submitted Raizcorp Bookkeeper |
Select |
Submissions |
| SubQry Rpt SDM Opal Shift Get Principals |
Select |
|
| SubQry Rpt SDM Opal Shift Sum Current Month Spend by Principal |
Select |
Entrepreneur, Principal Project Pillars, Principals... |
| SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal |
Select |
Entrepreneur, Principal Project Pillars, Principals... |
| SubQry Rpt Sum Principal Spend by Company |
Select |
Principal Project Pillars, Principal Projects, Entrepreneur Company Principal Projects... |
| SubQry Rpt Sum Principal Spend by Delivery Location |
Select |
Entrepreneur Company, Principal Project Pillars, Principal Projects... |
| SubQry Rpt Tracker Count Current Complete Subs by Bookkeeper |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, MonthLkUp... |
| SubQry Rpt Tracker Count Current Incomplete Subs by Bookkeeper |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, MonthLkUp... |
| SubQry Rpt Tracker Count Current Submissions by Bookkeeper |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, MonthLkUp... |
| SubQry Rpt Tracker Count Current Under Query Subs by Bookkeeper |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, MonthLkUp... |
| SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper |
Select |
Delivery Locations, Qry Get Companies Not Non Graduate, MonthLkUp... |