Garnet Module - Queries
Documentation Files
- _summary
- JB Check Company Allocations
- JB Issue with Monthly Billings
- JB Qry Reverse Sept Monthly Billings
- Qry Add Allocation Principal Project List
- Qry Application Versions
- Qry Calcluate Extra Sponsor Element Amount Remaining
- Qry Company Entrepreneur Ignition List
- Qry Company List
- Qry Company Lump Sum Allocation List
- Qry Company Monthly Billing List Temp
- Qry Company Monthly Billing List
- Qry Company Needs Replacement List
- Qry Company Principal Project List
- Qry Company Raizcorpossibles List
- Qry Count Active Allocated Companies by Principal Project Pillar
- Qry Count Companies by Principal Project Allocation Report
- Qry Count Current Blank Year Companies by Principal Project
- Qry Count Current Blank Year Entrepreneurs by Principal Project
- Qry Count Current Future Year Companies by Principal Project
- Qry Count Current Future Year Entrepreneurs by Principal Project
- Qry Count Current Graduated Companies by Principal Project
- Qry Count Current Graduated Entrepreneurs by Principal Project
- Qry Count Current On Programme Companies by Principal Project
- Qry Count Current On Programme EPs by Principal Project
- Qry Count Exited Companies by Principal Project Pillar
- Qry Count Exited Need Replacement by Principal Project Pillar
- Qry Count Number Months Billed by Company PP and Project Pillar
- Qry Count Principal Projects by Company
- Qry Count Total Companies Allocated Lump Sum 1 Principal Project
- Qry Count Unallocated Companies by Principal Project Recommended
- Qry Entrepreneur Company Extra Sponsor Amount List
- Qry Entrepreneur Company Sub Products
- Qry Export Certificate Mail Merge Information
- Qry Export Commitment Fee Information for Invoice
- Qry Export Contract Mail Merge Information
- Qry Get Amount Remaining by Principal Project Pillar
- Qry Get Companies for Certificate Mail Merge
- Qry Get Companies for Lump Sum Allocation
- Qry Get Current Contract Info by Company
- Qry Get Division Dist Model and Rec Info by Company
- Qry Get Entrepreneur Recommended Information
- Qry Get Entrepreneur Sourced From by Principal Project
- Qry Get Entrepreneurs for Contract Mail Merge
- Qry Get Last Billing Date by EP Company Principal Project
- Qry Get Last Note by Entrepreneur
- Qry Get Last Note Date by Entrepreneur
- Qry Get Last Programme Year ID by Company
- Qry Get Last Programme Year Info by Company
- Qry Get Last Programme Year Info for Report Writer
- Qry Get Monthly Billing Information
- Qry Get Principal Projects for Finance Audit Report
- Qry Get Principal Projects for Finance Report
- Qry Opal Scorecard Count Companies by Pgm Yr Status Not On Pgm
- Qry Opal Scorecard Count Eligible for Graduation All Products
- Qry Opal Scorecard Count Graduated Off D
- Qry Opal Scorecard Count Graduated Off E
- Qry Opal Scorecard Count Graduated Off M
- Qry Opal Scorecard Count Graduated On E
- Qry Opal Scorecard Count Graduated On M
- Qry Opal Scorecard Count Total D Eligible for Graduation
- Qry Opal Scorecard Count Total E Eligible for Graduation
- Qry Opal Scorecard Count Total Eligible for Graduation
- Qry Opal Scorecard Count Total M Eligible for Graduation
- Qry Opal Scorecard Get Active Companies Continued
- Qry Opal Scorecard Get Active Companies New
- Qry Opal Scorecard Get Active Companies Stopped
- Qry Opal Tag Programme Yr and Eligible for Graduation
- Qry Principal List
- Qry Principal Project List Allocation
- Qry Principal Project List Main Dashboard
- Qry Principal Project List
- Qry Principal Project Pillar List
- Qry Principal Project Sub Products
- Qry Report Active Companies Email
- Qry Report Active Entrepreneurs by Delivery Location
- Qry Report Companies Allocated Date Range
- Qry Report Companies Left Programme Date Range
- Qry Report Companies Needs Replacement
- Qry Report Companies Started Programme Date Range
- Qry Report Company Totals by Delivery Location
- Qry Report Delivery vs Exited Entrepreneurs Summary
- Qry Report Delivery vs Exited Entrepreneurs
- Qry Report Number Companies Ignited by Product
- Qry Report Part Sponsorship Entrepreneurs
- Qry Report Part Sponsorship History
- Qry Report Part Sponsorship
- Qry Report Principal Project Allocation Audit
- Qry Report Principal Project Allocation for Finance Blank Year
- Qry Report Principal Project Allocation for Finance Future Year
- Qry Report Principal Project Allocation for Finance Graduated
- Qry Report Principal Project Allocation for Finance Nongraduate
- Qry Report Principal Project Allocation for Finance On Programme
- Qry Report Principal Project Product Totals by Delivery Location
- Qry Report Principal Project Totals by Delivery Location
- Qry Report Principal Quarterly Reports
- Qry Report Principal SD Letter New Allocation
- Qry Report RAG
- Qry Report Raizcorp Possibilities
- Qry Report Raizcorpossible Companies Email
- Qry Report SD Alocations Not Notified
- Qry Report Summarised Deferred Income
- Qry Report Writer
- Qry SubFrm Principal Project Pillar Supporting Documents
- Qry SubRpt Companies in Principal SD Letter
- Qry SubRpt Entrepreneurs in Principal SD Letter
- Qry SubRpt Principal Project Allocation Audit Replaced Companies
- Qry SubRpt Principal Project Pillar Delivery Locations
- Qry Sum Extra Sponsor Element Allocated
- Qry Sum Extra Sponsor Element Payments by Company
- Qry Sum Replacement Amount Allocated by Replacement For
- Qry Sum Total Allocated Amt by Company
- Qry Sum Total Billed by Company and Project Pillar
- Qry Sum Total Billed by Company PP and Project Pillar
- Qry Sum Total Billed by Principal Project
- Qry Sum Total Spend by Principal Project
- Qry Sum Total Sponsorship by Principal Project Pillar
- Qry Update Certificate Printed Box
- Qry Update Commitment Fee Invoiced Box
- Qry Update Contract Printed Box
- Qry Update SD Alocations Notified
- qryLinkODBC
- SubQry Company Needs Replacement List
- SubQry Export Commitment Fee Information for Notification
- SubQry Get Principal Projects for Finance Report
- SubQry Opal Scorecard Get Active Companies Stopped
- SubQry Opal Scorecard Source
- SubQry Rpt Companies Needs Replacement
- SubQry Rpt Delivery vs Exited Entrepreneurs
- SubQry Rpt EP Counts by Principal Project Delivery Location
- SubQry Rpt EP Names by Company by Delivery Location
- SubQry Rpt Part Sponsorship History
- SubQry Rpt Part Sponsorship
- SubQry Rpt Principal Project Allocation for Finance Criteria
- SubQry Sum Current On Prog by Prosperator Principal Proj Product
- SubQry Sum Total Replaced Billed to Date by Prin Project Pillar
- SubQry Sum Total Replaced Selection Fee by Prin Project Pillar