Reporting DB - Revision history

David.weller at 15:59, 29 May 2026

2026-05-29T15:59:28Z

David.weller: /* Table: dim_quotations */

2026-05-29T15:48:23Z

Table: dim_quotations

← Older revision		Revision as of 17:48, 29 May 2026
Line 34:		Line 34:
	\|quotation_id		\|quotation_id
	\|bigint		\|bigint
	\|		\|quotation id within qms
	\|		\|
	\|-		\|-
	\|hos_id		\|hos_id
	\|bigint		\|bigint
	\|		\|hos id associated with the job
	\|		\|
	\|-		\|-
	\|site_id		\|site_id
	\|bigint		\|bigint
	\|		\|the site (entity) that the job is saved for
	\|		\|
	\|-		\|-
	\|booked_at		\|booked_at
	\|datetime		\|datetime
	\|		\|the date / time the job was booked
	\|		\|
	\|-		\|-
	\|confirmed_at		\|confirmed_at
	\|datetime		\|datetime
	\|		\|the date / time the job was confirmed with airline
	\|		\|
	\|-		\|-
	\|quoted_at		\|quoted_at
	\|datetime		\|datetime
	\|		\|the date / time the job was quoted
	\|		\|
	\|-		\|-
	\|pre_quoted_at		\|pre_quoted_at
	\|datetime		\|datetime
	\|		\|the date / time the job was pre_quoted
	\|		\|
	\|-		\|-
	\|user_id		\|user_id
	\|bigint		\|bigint
	\|		\|the user who created the job
	\|		\|
	\|-		\|-
	\|group_type		\|group_type
	\|varchar		\|varchar
	\|		\|the group type of shipment
	\|		\|
	\|-		\|-
	\|booking_user_id		\|booking_user_id
	\|bigint		\|bigint
	\|		\|the id of the user who confirmed the job
	\|		\|
	\|-		\|-
	\|lost_reason		\|lost_reason
	\|varchar		\|varchar
	\|		\|the reason the job was lost
	\|		\|
	\|-		\|-
Line 103:		Line 103:
	\|-		\|-
	\|deleted_at		\|deleted_at
			\|timestamp
			\|
			\|
			\|-
			\|shipper_status
			\|varchar
			\|
			\|
			\|-
			\|lost_at
	\|timestamp		\|timestamp
	\|		\|

David.weller: /* Raw Tables, Columns and Suggested Modelling */

2026-05-29T15:45:10Z

Raw Tables, Columns and Suggested Modelling

← Older revision		Revision as of 17:45, 29 May 2026
Line 9:		Line 9:
	Within every table there is 2 consistent columns, to save repeating data - these columns will be shared here.		Within every table there is 2 consistent columns, to save repeating data - these columns will be shared here.

	~~====~~ Columns ~~====~~		'''Columns'''
	{\| class="wikitable"		{\| class="wikitable"
	!Column Name		!Column Name
Line 25:		Line 25:

	=== Table: dim_quotations ===		=== Table: dim_quotations ===
			'''Columns:'''
	~~====~~ Columns: ~~====~~
	{\| class="wikitable"		{\| class="wikitable"
	!Column Name		!Column Name
Line 225:		Line 224:

	=== Table: dim_cargo_type ===		=== Table: dim_cargo_type ===
			'''Columns:'''
	~~====~~ Columns: ~~====~~
	{\| class="wikitable"		{\| class="wikitable"
	!Column Name		!Column Name

David.weller at 15:44, 29 May 2026

2026-05-29T15:44:05Z

Show changes

David.weller: /* Raw Tables, Columns and Suggested Modelling */

2026-05-29T14:38:57Z

Raw Tables, Columns and Suggested Modelling

@@ Line 21: / Line 21: @@
 |portal
 |Which QMS instance the data is from.
-|Currently to identify, ATC, HAE, ACS, GA ZA, and AirCross.
+|The portal is the instance of the QMS system, not the entity, that is the site.
 |}
@@ Line 61: / Line 61: @@
 |-
 |site_id
-|the site (entity) is carrier / supplier is on
+|the site (entity) the carrier / supplier is on
+|
 |-
@@ Line 90: / Line 90: @@
 === Table: dim_customers ===
 '''Columns:'''
+{| class="wikitable"

David.weller at 14:26, 29 May 2026

2026-05-29T14:26:06Z

← Older revision		Revision as of 16:26, 29 May 2026
Line 3:		Line 3:

	The information below has the assumption that you understand databases, and have knowledge in PBI development and data management.		The information below has the assumption that you understand databases, and have knowledge in PBI development and data management.

			Currently we have only added the tables / columns for the information we know is required.

	=== Every Table ===		=== Every Table ===
Line 86:		Line 88:
	\|		\|
	\|}		\|}
			=== Table: dim_customers ===
			'''Columns:'''

David.weller at 14:24, 29 May 2026

2026-05-29T14:24:38Z

← Older revision		Revision as of 16:24, 29 May 2026
Line 50:		Line 50:
	!Notes		!Notes
	\|-		\|-
	\|id		\|carrier_id
	\|~~database record~~ id		\|id for the carrier
	\|		\|
	\|-		\|-
			\|name
			\|name of the carrier / supplier
	\|		\|
			\|-
			\|site_id
			\|the site (entity) is carrier / supplier is on
	\|		\|
			\|-
			\|is_gsa
			\|the carrier / supplier is gsa
	\|		\|
	\|-		\|-
			\|parent_id
			\|the parent carrier / supplier for this carrier
			\|this will be null if the carrier is a parent.
			\|-
			\|carrier_class
			\|supplier class
			\|airline, truck, sea freight etc..
			\|-
			\|carrier_subclass
			\|subclass for the carrier
	\|		\|
			\|-
			\|created_at
			\|when the carrier was created
	\|		\|
			\|-
			\|updated_at
			\|the last time the carrier was updated
	\|		\|
	\|}		\|}






	= Helpers =		= Helpers =
	N/A - Will update as questions come through.		N/A - Will update as questions come through.

David.weller: Created page with "= 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 [https://helpdesk.dcbi.aero/ 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, t..."

2026-05-29T11:54:31Z

Created page with "= 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 [https://helpdesk.dcbi.aero/ 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, t..."

New page

= 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 [https://helpdesk.dcbi.aero/ 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 ====
{| class="wikitable"
!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: ====
{| class="wikitable"
!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:'''
{| class="wikitable"
!Column Name
!Description
!Notes
|-
|id
|database record id
|
|-
|
|
|
|-
|
|
|
|}

= Helpers =
N/A - Will update as questions come through.