Metrics-tables

From VPOIDS Documentation

Metrics tables

The following tables in AFIDS are used to track metrics.

Metrics (metrics)

The metrics table maintains the top-level statistics for the organization, which are reported in the executive dashboard. These are updated daily

Field Type Description
last_ytd_request_count int Count of requests last year, from the first of the last year to this calendar day of last year. Used to compare this year to date, YOY

Pilot stats (pilot_stats)

Route stats (route_stats)

Field Type Description
total_legs int Total legs requested for that route. Includes all statistical mission types.
air_legs int Pilot flown legs flown for that route. Mission report approved. Includes all statistical mission types.
commercial_legs int Commercial legs flown for that route. Mission report approved. Includes all statistical mission types.
pilot_cost int Hobbs time * aircraft cost for air mission legs. Mission report approved. Includes all statistical mission types.
commercial_cost int Commercial ticket cost for commercial mission legs. Mission report approved. Includes all statistical mission types.
pilot_requests int Total pilot requests for this route.
ave_time_to_request int Number of hours between the time the mission was added and the first pilot request was received.
canceled_weather int Total of all legs canceled for weather or weather other leg. Includes all statistical mission types.
canceled_no_pilot int Total of all legs canceled for no pilot or no pilot other leg. Includes all statistical mission types.
distance int Distance between the origin and destination
probability int Calculated probability that the mission will be flown.

Passenger stats (passenger_stats)

Metrics methods

The metrics action.class