Data Lake Extracts: Difference between revisions

Latest revision as of 16:21, 17 October 2025

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

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

@@ Line 2: / Line 2: @@
 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
 == File Format ==
 '''Extract File Format:'''
@@ Line 22: / Line 29: @@
 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