Sales Tables
In these tables, you will find information regarding the issuance of the documents(TKT, EMD, RFND).
Documents and Coupons amounts are converted to Currency_1 and Currency_2 which are configured in the PSS.
BI_Sales_Documents
This table has the information of issued documents. Each row represents a form of payment (FOP). For example, if a document was paid with CASH and CREDIT CARD, two records will be here for that document. For counting calculations Quantity column should be used, only the first FOP will have “1“ as value.
If a ticket is voided, new records will be inserted in this table with negative amounts and quantity. The “Document_Transaction“ will be TKTX.
BI_Sales_Coupons
This table has the information of each coupon within the documents. To make a join between Coupons and Documents use “Document_Number”, “Year_of_Issue“ columns and “Form_Of_Payment_Number” equal 1.
Flown Tables
In this set of tables, you will find flown data. With the closure of a flight (manual or automatic) at least BI_Flown_Legs BI_Flown_Cabins, BI_Flown_Passengers, and BI_Flown_Leg_Passenger will be populated.
To join the data across tables you should use the next columns:
"Carrier"
"Flight_Number"
"Flight_Departure_Date"
"Airport_Number_From"
"Airport_Number_To"
In case of adding BI_Flown_Passengers, BI_Flown_Leg_Passengers, BI_Flown_Leg_Passengers_Not_Boarded or BI_Flown_Passengers_Not_Boarded you should also include the “Cabin” column.
BI_Flown_Legs
This table has information about the flown legs. For each leg you will find a record, therefore a unique record exists with the combination of "Carrier", "Flight_Number", "Flight_Departure_Date", "Airport_Number_From", "Airport_Number_To". It has general information about the leg, origin, destination, equipment, cost, distance, capacity.
BI_Flown_Cabins
This table has information about the cabins. For example, if a flight has economy and business, two records will exist here. The field “AircraftCapacity“ in this context makes reference to the cabin capacity.
BI_Flown_Leg_Delays
In case of existing a delay in a leg, in this information, you will find the code, description, and the delay.
BI_Flown_Leg_Passengers
En esta tabla se almacenan los pasajeros del leg. En caso ser un vuelo multileg el pasajero será contando en tantos legs como vuele y el valor de la tarifa será prorrateado en base a la distancia. Esta división permite generar indicadores de load factor en el leg.
BI_Flown_Leg_Passengers_EMD
This table has information about the EMD used in the leg. To join this table with BI_Flown_Leg_Passengers, you must use "Carrier", "Flight_Number", "Flight_Departure_Date", "Airport_Number_From", "Airport_Number_To”, “Record_Locator” and “Passenger_Name”.
BI_Flown_Leg_Passengers_Not_Boarded
This table has information about the not boarded passenger in the leg.
For example, no show or denied boarding passengers.
BI_Flown_Passengers
The same information of BI_Flown_Leg_Passengers but in a segment level
BI_Flown_Passengers_EMD
The same information of BI_Flown_Leg_Passengers_EMD but in a segment level
BI_Flown_Passengers_Not_Boarded
The same information of BI_Flown_Leg_Passengers_Not_Boarded but in a segment level