Amber Module - Queries

< Back to Amber Module

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