This update to the BI Tables includes additional data points to the existing tables and the addition of new tables.

Existing BI Tables and the additions:

FlightDataAnalysis

DepartureAirportID

ArrivalAirportID

CustomerIDs

AircraftID

FleetID

IsEmptyLeg

ActualDepartureDateLocal

ActualArrivalDateLocal

LeadPassengerIDs

AircraftOwnerIDs

FlightLegCrew

DutyID – The duty record that spans the flight leg being pulled

JobCardAnalysis

AircraftID

AIrportID

Personnel

CrewCode

AIrportID – This is for their homebase airport

PersonnelEventAnalysis

StartAirportID

EndAirportID

AIrcraftID

New BI Tables:

Aircraft

AircraftID (GUID)

OrganizationGUID

AircraftModel (Name field in the AircraftType table)

AircraftModelCode (TypeCode field from AircraftType table)

AircraftCategory

TailNumber

SerialNumber

Year

VendorName

OwnerName

HomebaseAirportID

RequiresOwnerApproval

CruisingSpeed

MinimumRunwayLength

IsActive

CruisingAltitude

FuelStopDistance

FuelStopTime

SinglePilot

Airport

ID (GUID)

Name

ICAO

FAA

IATA

City

Country

RunwayWidth

RunwayLength

Customs

AirportOfEntry

Elevation

Open24Hours

ControlTowerHours

Latitude

Longitude

AirportType

WindowsTimeZoneInfoID

IANATimeZoneId

CrewAvailability

ID (GUID)

OrganizationGUID

OrganizationUserID

StartDate

EndDate

AvailabilityType (this should be the name of the availability type, not the INT value)

CrewTypeRating

OrganizationUserID (GUID)

Type Rating (Name of the type rating, ex. B-737)

Model (If the AircraftTypeID IS NOT NULL, pull aircraft model).

Type Rating Position

Duty Positions (Comma separated list of duty positions set on type rating)

Issue Date

Expiration Date

Full Motion Sim Date

Proficiency Check Date

Did this answer your question?