Data Lake Extracts

Overview

This section provides a detailed overview of the data lake extracts used for reporting QMS data. It includes a comprehensive list of available data exports, clear descriptions of each column, and practical example formulas that can be used to calculate key performance metrics. This information is intended to support both analysts and developers in understanding the structure of the data, enabling accurate reporting, troubleshooting, and performance tracking across various processes.

Extracts

• Quotations Extract – Contains all job data from QMS, including pre quotes, quotes, bookings and automation sync data for bookings.
• Quotations Charges Extract - Contains all job charge data from QMS.
• Post-Flight Progress Extract – Contains all automated post flight data
• Invoice Reconciliation Extract – Contains all automated invoice reconciliation data
• Pre-Invoice Processing Extract – Contains all automated pre-invoicing data