Data Lake Extracts: Difference between revisions
David.weller (talk | contribs) Created page with "== 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 trackin..." |
David.weller (talk | contribs) |
||
| Line 5: | Line 5: | ||
* [[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. | |||
* [[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 | ||
Revision as of 13:25, 17 September 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