Data Lake Extracts: Difference between revisions
David.weller (talk | contribs) |
David.weller (talk | contribs) No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
== Extracts == | == Extracts == | ||
* [[Quotations Extract]] – Contains all job data from QMS, including pre quotes, quotes, bookings and automation sync data for bookings. | * [[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. | * [[Quotations Charges Extract]] - Contains all job charge data from QMS. | ||
* [[Post-Flight Progress Extract]] – Contains all automated post flight data | * [[Post-Flight Progress Extract]] – Contains all automated post flight data | ||
* [[Invoice Reconciliation Extract]] – Contains all automated invoice reconciliation data | * [[Invoice Reconciliation Extract]] – Contains all automated invoice reconciliation data | ||
* [[Pre-Invoice Processing Extract]] – Contains all automated pre-invoicing 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 | |||
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