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.

File Format

Extract File Format:

{extract-type}_{qms-instance}_{date}.csv

Extract-Type

• Quotations
• Quotations_charges
• ProgressUpdater
• Reconciliation
• PreInvoice

QMS-Instance

The instance of QMS it's come from. As there is multiple for different brands.

Date

Date of the extract

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