Reporting DB
Raw Tables, Columns and Suggested Modelling
To access the reporting database, you will need an account creating. Please follow the correct process and raise a ticket via the helpdesk. They will provide you account, address and access.
The information below has the assumption that you understand databases, and have knowledge in PBI development and data management.
Every Table
Within every table there is 2 consistent columns, to save repeating data - these columns will be shared here.
Columns
| Column Name | Description | Notes |
|---|---|---|
| id | Database id | |
| portal | Which QMS instance the data is from. | Currently to identify, ATC, HAE, ACS, GA ZA, and AirCross. |
Table: dim_cargo_type
Columns:
| Column Name | Description | Notes |
|---|---|---|
| cargo_type_id | cargo type id | used when referenced in other tables. |
| description | description | |
| tariff_service_code | service code that can be linked to the cargo type |
Table: dim_carriers
Columns:
| Column Name | Description | Notes |
|---|---|---|
| id | database record id | |
Helpers
N/A - Will update as questions come through.