BI Updates (May 2021)

BI Updates (May 2021)

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

    • Related Articles

    • Feasibility Updates May 2023 [Videos]

      This Video includes the Following Feasibility Updates; Dedicated Feasibility page** Trip Feasibility Real Time updates** Feasibility results display on Ops Dashboard** Feasibility checks for require flight attendant setting Feasibility checks for ...

    • Mobile App Updates and Maintenance (May 2021)

      The following updates have been added to the mobile app: Personnel event edits Accept flight leg change to acknowledge flight legs Mobile background sync Bug fixes NEW FEATURE DETAILS Event Edits Editing Personnel events in the iOS Mobile app, My ...

    • Airport-Related Updates from May 2023 Release [Video]

      Short Video from the May 2023 release on the Airport hours and Aircraft Restrictions tabs within airport profiles:

    • API Updates (May 2021)

      The following area of the API has been added: Airport/FBO Additional endpoints have been added to the Connect API. This update allows an operation to pull airport info and FBOs/Handlers at that airport. Furthermore, existing endpoints have been ...

    • 2024 November 06 - Web Updates

      Avianis has adopted a new release process and the release note format has changed. Avianis updates most every week on either Tuesday or Wednesday, with additional releases when warranted. Release notes will only be issued for notable updates and new ...