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