Reports-detail

From VPOIDS Documentation

Contents

Reports

Member Photos List

Report ID: member_photos_list

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: memberPhotos.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberPhotos_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberPhotos_email.xsl
    • Print template:
    • Template option:

Mission Counts Year to Date

Report ID: mission_counts_YTD

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: missionCountsYTD.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionCountsYTD_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionCountsYTD_email.xsl
    • Print template:
    • Template option:

ACN Mission Counts Year to Date (deprecate)

Report ID: acn_mission_counts_YTD

Active: false

Dataset:

  • Type: adCmdText
  • Text: SELECT * FROM monthly_mission_report

Output formats:

  • Format: Display
    • Template: defaultReport_table.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: defaultReport_table.xsl
    • Print template:
    • Template option:

Canceled Mission Detail

Report ID: cancelled_mission_detail

Number of canceled mission legs by month and the cancelation reason. The percentages are percent of all canceled missions. You can choose to include linking legs (with other organizations), and only missions that were coordinated (pilot added) prior to the cancelation.

Active: true

Dataset:

  • Type: adCmdText
  • Text: SELECT year(m.mission_date) as missionYear, month(m.mission_date) as monthNo, cancelled, count(ml.id) as legCount, ml.pilot_id, afa.id as afa_leg_id FROM mission m JOIN mission_leg ml ON (m.id = ml.mission_id) LEFT JOIN afa_leg afa ON (ml.id = afa.id)

Output formats:

  • Format: Display
    • Template: cancelledMissions.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: cancelledMissions_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: cancelledMissions_email.xsl
    • Print template:
    • Template option:

Canceled Mission Detail

Report ID: cancelled_mission_detail_for_wing

Number of canceled mission legs by month and the cancelation reason for this wing only. The percentages are percent of all canceled missions for this wing. The wing of the mission leg is determined by the pilot assigned to the mission at the time of cancelation, therefore, these counts are for coordinated missions only.

Active: false

Dataset:

  • Type: adCmdText
  • Text: SELECT year(m.mission_date) as missionYear, month(m.mission_date) as monthNo, cancelled, count(ml.id) as legCount, ml.pilot_id, mb.wing_id, w.name as wingName FROM mission m JOIN mission_leg ml ON (m.id = ml.mission_id) JOIN member mb ON (ml.pilot_id = mb.id) JOIN wing w ON (mb.wing_id = w.id)

Output formats:

  • Format: Display
    • Template: cancelledMissions_for_wing.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: cancelledMissions_for_wing_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: cancelledMissions_for_wing_email.xsl
    • Print template:
    • Template option:

Canceled Mission Detail by Wing

Report ID: cancelled_mission_detail_wing

Number of canceled mission legs by month and wing. The percentages by wing are the percent of all scheduled mission legs, the percentages by month are a percent for that month of all canceled missions. The wing of the mission leg is determined by the pilot assigned to the mission at the time of cancelation, therefore, these counts are for coordinated missions only. Linking legs with other organizations are not included.

Active: false

Dataset:

  • Type: adCmdText
  • Text: SELECT year(m.mission_date) as missionYear, month(m.mission_date) as monthNo, wing.id as wingID, wing.name, count(ml.id) as legCount, count(cancelled) as cancelledCount FROM mission m JOIN mission_leg ml ON (m.id = ml.mission_id) JOIN member mb ON (ml.pilot_id = mb.id) JOIN wing ON (mb.wing_id = wing.id)

Output formats:

  • Format: Display
    • Template: cancelledMissions_wing.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: cancelledMissions_wing_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: cancelledMissions_wing_email.xsl
    • Print template:
    • Template option:

Statistical Summary

Report ID: statistical_summary

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: statisticalSummary.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: statisticalSummary_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: statisticalSummary_email.xsl
    • Print template:
    • Template option:

Member Roster

Report ID: member_roster

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: memberDirectory.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberDirectory_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: memberDirectory_email.xsl
    • Print template:
    • Template option:

Member Roster

Report ID: member_roster_members

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: memberDirectory.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberDirectory_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: memberDirectory_email.xsl
    • Print template:
    • Template option:

Search Member Applications

Report ID: search_member_applications

Searches completed and processed member applications (not temporary applications). Since a member may have multiple applications (one for membership initiation and one for each renewal thereafter), there may be multiple results for a single member.

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: searchMemberApplications.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: searchMemberApplications_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: searchMemberApplications_email.xsl
    • Print template:
    • Template option:

Monthly Mission Report

Report ID: monthly_mission_report_detail

Note that this summary only includes missions for which a mission report has been filed and approved. Before distributing, verify that there are no mission reports outstanding. Pilot cost is based on $40 per hour.

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: monthlyMissionsReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Monthly Mission Report

Report ID: monthly_mission_report_summary

(Deprecated) Note that this summary only includes missions for which a mission report has been filed and approved. Before distributing, verify that there are no mission reports outstanding. Pilot cost is based on a fixed rate of $30 per hour.

Active: false

Dataset:

Output formats:

  • Format: Display
    • Template: monthlyMissionsReportSummary.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: monthlyMissionsReportSummary_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: monthlyMissionsReportSummary_email.xsl
    • Print template:
    • Template option:

Monthly Mission Report Reconciliation

Report ID: mission_report_reconcile

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: missionReportReconcile.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionReportReconcile_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionReportReconcile_email.xsl
    • Print template:
    • Template option:

Coordination Report: New Members Only

Report ID: coordinatorReportNewMembersByMissionLeg

The following is a coordination contact list this mission leg. The list contains the names of Command Pilots who have not yet flown a mission and are based at either the origin or destination airport.

Active: false

Dataset:

Output formats:

  • Format: Normal
    • Template: missions_available_coordination.xsl
    • Print template:
    • Template option: afidFrame

Coordination Report: All Members

Report ID: coordinatorReportAllMembersByMissionLeg

The following is a coordination contact list this mission leg. The list contains the names of Command Pilots who are based at either the origin or destination airport.

Active: false

Dataset:

Output formats:

  • Format: Normal
    • Template: missions_available_coordination.xsl
    • Print template:
    • Template option: afidFrame

Child Passengers

Report ID: childrenPassengersReport

The following report shows mission legs for all passengers who were under 18 years of age at the time of the mission.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: childrenPassengersReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: childrenPassengersReport_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: childrenPassengersReport_email.xsl
    • Print template:
    • Template option:
  • Format: Download
    • Template:
    • Print template:
    • Template option:

Alaska Airlines Report

Report ID: alaskaAirlines

Active: true

Dataset:

  • Type: adCmdText
  • Text: SELECT mr.mission_date, date_format(`mr`.`mission_date`,"%m-%d-%Y") AS `displayDate`, concat_ws(" ", p.first_name,p.last_name) as passengerName, fa.ident as origin, ta.ident as destination, (case when (mr.airline_ref_number is Not Null) then mr.airline_ref_number else "" END) as VTA, (case when (`pa`.`illness` is null) then "" else pa.illness end) AS `illness` FROM mission m JOIN mission_leg ml on (m.id = ml.mission_id) JOIN passenger pa on (m.passenger_id = pa.id) JOIN person p on (pa.person_id = p.id) JOIN mission_report mr on (ml.mission_report_id = mr.id) JOIN airport fa on (ml.from_airport_id = fa.id) JOIN airport ta on (ml.to_airport_id = ta.id) WHERE pilot_id = 4028

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Camp Passengers

Report ID: campPassengers

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: campPassengers.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: campPassengers_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: campPassengers_email.xsl
    • Print template:
    • Template option:

Missions Summary

Report ID: weekendSummary

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: weekendSummary.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: weekendSummary_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: weekendSummary_email.xsl
    • Print template:
    • Template option:

Outreach Report

Report ID: outreachReport

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: outreachReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: outreachReport_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: outreachReport_email.xsl
    • Print template:
    • Template option:

Origin Destination Summary Report

Report ID: originDestination

This report lists missions with the first origin and ultimate destination of the mission for all missions, including multi-leg missions.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Mission Legs Origin Destination Summary Report

Report ID: originDestinationLegs

This report lists all mission legs flown with the origin and destination of the mission leg.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: missionLegsOriginDestination.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Origin Destination Summary Report (ACN Legs)

Report ID: originDestinationAFA

This report lists missions with the first origin and ultimate destination of the mission for all missions, including multi-leg missions. This report includes ACN Legs. For non-ACN legs, the report includes only mission legs with approved mission reports. The wing represented is the wing of the pilot who flew the first non-ACN leg.

Active: false

Dataset:

  • Type: adCmdText
  • Text: SELECT * FROM missionsOriginDestinationAFA

Output formats:

  • Format: Normal
    • Template: missionsOriginDestination.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionsOriginDestination.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Create PDF
    • Template: missionsOriginDestination.xsl
    • Print template:
    • Template option: afidFrame

Mission Legs Origin Destination Summary Report (ACN)

Report ID: originDestinationLegsAFA

This report lists all mission legs flown with the origin and destination of the mission leg. This report includes ACN legs. For non-ACN legs, the report includes only mission legs with approved mission reports.

Active: false

Dataset:

  • Type: adCmdText
  • Text: SELECT * FROM missionLegsOriginDestinationAFA

Output formats:

  • Format: Normal
    • Template: missionLegsOriginDestinationAFA.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionLegsOriginDestinationAFA.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Create PDF
    • Template: missionLegsOriginDestinationAFA.xsl
    • Print template:
    • Template option: afidFrame

Deceased Persons Report

Report ID: deceasedPersons

Persons who are listed as being deceased.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Members Total Hours

Report ID: membersTotalHours

Lists active pilot members and their flight hours on record.

Active: true

Dataset:

  • Type: adCmdText
  • Text: SELECT concat_ws(" ",`p`.`first_name`,`p`.`last_name`) AS `personName`, m.wing_id as wingID, m.flight_status as flightStatus, pilot.total_hours as totalHours FROM person p JOIN member m ON (p.id = m.person_id) JOIN pilot ON (m.id = pilot.member_id) WHERE active = 1

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Pilots Disaster Response Status

Report ID: hseats

Lists pilot members and their Disaster Response Program status.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Camp Mission Legs

Report ID: campCounts

Lists Camp mission legs

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

New Member Status

Report ID: newMembers

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: newMembers.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: newMembers_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: newMembers_email.xsl
    • Print template:
    • Template option:

New Members Needing Badge or Notebook

Report ID: newMembersNeedingBadge

Recent members who have not yet received a badge or notebook

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: newMembersNeedingBadge.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: newMembersNeedingBadge_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: newMembersNeedingBadge_email.xsl
    • Print template:
    • Template option:

Command Pilots who have not Flown a Mission

Report ID: membersNoMissions

Lists active command pilots who have not yet flown a mission.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: membersNoMissions.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: membersNoMissions_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: membersNoMissions_email.xsl
    • Print template:
    • Template option:

Flight Status by Wing

Report ID: flightStatusWing

Currently active members showing flight status by wing.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: memberFlightStatusWing.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Mission Types by Wing

Report ID: missionTypesWing

Mission leg counts by mission type by wing, based on approved mission reports.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_table.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Mission Counts By Member

Report ID: memberMissionCounts

Mission leg counts by member, based on approved mission reports.

Active: true

Dataset:

  • Type: adCmdText
  • Text: SELECT mb.id as memberID, mb.external_id as externalID, concat_ws(", ",`p`.`last_name`,`p`.`first_name`) AS `pilotName`, p.last_name as lastName, mr.mission_date as missionDate, mb.wing_id as wingID, count(ml.id) as legCount, sum(hobbs_time) as hobbsTime, sum(commercial_ticket_cost) as commercialTicketCost FROM mission m JOIN mission_leg ml ON (m.id = ml.mission_id) JOIN mission_report mr ON (ml.mission_report_id = mr.id) JOIN member mb ON (ml.pilot_id = mb.id) JOIN person p ON (mb.person_id = p.id)

Output formats:

  • Format: Normal
    • Template: missionsByMember.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionsByMember_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template: afwDownloadReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Member Mission Distribution

Report ID: memberMissionDistribution

Distribution of Missions flown by Members

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: memberMissionDistribution.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberMissionDistribution_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberMissionDistribution_email.xsl
    • Print template:
    • Template option:

Permanent Member Statistics

Report ID: memberWingStatsMonth

Report of the permanent member statistics.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: memberWingStatsMonth.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberWingStatsMonth_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberWingStatsMonth_email.xsl
    • Print template:
    • Template option:

Permanent Member Statistics

Report ID: memberWingStatsWing

Report of the permanent member statistics.

Active: false

Dataset:

Output formats:

  • Format: Normal
    • Template: memberWingStatsWing.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberWingStatsWing_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberWingStatsWing_email.xsl
    • Print template:
    • Template option:

Permanent Mission Statistics

Report ID: missionTypeWingStatsLeg

Report of the permanent mission statistics showing the number of mission legs.

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: missionTypeWingStatsLeg.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionTypeWingStatsLeg_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionTypeWingStatsLeg_email.xsl
    • Print template:
    • Template option:

Permanent Mission Statistics (Aircraft Hours)

Report ID: missionTypeWingStatsHours

Report of the permanent mission statistics showing hours flown.

Active: false

Dataset:

Output formats:

  • Format: Normal
    • Template: missionTypeWingStatsHours.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionTypeWingStatsHours_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionTypeWingStatsHours_email.xsl
    • Print template:
    • Template option:

Permanent Mission Statistics (Aircraft Cost)

Report ID: missionTypeWingStatsCost

Report of the permanent mission statistics showing the aircraft cost.

Active: false

Dataset:

Output formats:

  • Format: Normal
    • Template: missionTypeWingStatsCost.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionTypeWingStatsCost_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionTypeWingStatsCost_email.xsl
    • Print template:
    • Template option:

Permanent Mission Statistics (Commercial Tickets)

Report ID: missionTypeWingStatsComm

Report of the permanent mission statistics showing the value of commercial tickets.

Active: false

Dataset:

Output formats:

  • Format: Normal
    • Template: missionTypeWingStatsComm.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionTypeWingStatsComm_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionTypeWingStatsComm_print.xsl
    • Print template:
    • Template option:

Commercial Ticket Cost Tracking

Report ID: missionCostTracker

Track the costs of missions paid with commercial tickets

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: commercialCost.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: commercialCost_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: commercialCost_email.xsl
    • Print template:
    • Template option:

AFIDS Audit Logs

Report ID: auditLog

Active: true

Dataset:

  • Type: adCmdText
  • Text: SELECT DateTimeDisplay, date_time as datetime, audit_identity as auditidentity, event, event_reason as eventreason FROM rp_audit_logs

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

AFIDS Audit Log Summary

Report ID: loginsSummary

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_table.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option:
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

AFIDS Logins by non-staff

Report ID: loginsNonStaff

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

AFIDS Audit Logs by Staff

Report ID: loginsStaff

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Member Applications for Reconciliation

Report ID: memberApplications

Member Applications and Renewals for Reconciliation

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: memberApplicationReconcile.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberApplicationReconcile_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberApplicationReconcile_email.xsl
    • Print template:
    • Template option:

Mission Itinerary

Report ID: missionItinerary

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: missionItinerary.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionItinerary_print.xsl
    • Print template: itinerary
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionItinerary_email.xsl
    • Print template: itinerary
    • Template option:

Mission Itinerary

Report ID: missionItineraryMaster

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: missionItineraryMaster.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: missionItineraryMaster_print.xsl
    • Print template: blank
    • Template option: afidFrame
  • Format: Send Email
    • Template: missionItinerary_email.xsl
    • Print template: itinerary
    • Template option:

Member Application

Report ID: memberApplication

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: memberApplication.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberApplication_print.xsl
    • Print template: application
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberApplication_email.xsl
    • Print template:
    • Template option:

Airport Landings

Report ID: airport_landings

List of landings at a given airport for obtaining waivers for airport fees.

Active: true

Dataset:

Output formats:

  • Format: Display
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Search Pending Member Applications

Report ID: searchMemberApplicationsTemp

Search for pending member applications that have or have not yet been processed.

Active: true

Dataset:

  • Type: adCmdText
  • Text: SELECT id, application_date, date_format(application_date,"%m-%d-%Y") AS `application_date_display`, renewal, title, first_name, last_name, city, state, zipcode, email, affirmation_agreed, dues_amount_paid, method_of_payment_id, ccard_approval_number, ccard_error_code, ccard_avs_result, processed_date, member_id, person_id, novapointe_id, payment_transaction_id FROM application_temp

Output formats:

  • Format: Normal
    • Template: applicationTempSearch.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: applicationTempSearch_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Download
    • Template:
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: applicationTempSearch_email.xsl
    • Print template:
    • Template option:

Membership Application

Report ID: printMemberApplication

Print a completed member application

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: memberApplication.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: memberApplication_print.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: memberApplication_print.xsl
    • Print template:
    • Template option:

Missions Canceled for No Pilot

Report ID: cancelled_mission_no_pilot

Missions canceled for no pilot, or no pilot other leg

Active: true

Dataset:

Output formats:

  • Format: Normal
    • Template: defaultReport_jquery.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Print
    • Template: afwPrintReport.xsl
    • Print template:
    • Template option: afidFrame
  • Format: Send Email
    • Template: afwEmailReport.xsl
    • Print template:
    • Template option:

Medical Release Form

Report ID: medRelease

Form sent to the releasing physician for medical release.

Active: false

Dataset:

Output formats:

  • Format: Print
    • Template: medRelease.xsl
    • Print template:
    • Template option: printFrame

Medical Confirmation for Angel Flight Mission

Report ID: medReleaseByPassenger

Form sent to the releasing physician for medical release.

Active: false

Dataset:

Output formats:

  • Format: Print
    • Template: medRelease_print.xsl
    • Print template: letterhead
    • Template option:
  • Format: Email
    • Template: medRelease_print.xsl
    • Print template: letterhead
    • Template option:

Printable Mission Report for Members

Report ID: printableMissionReport

Printable version of the mission report which pilots can use for their records

Active: false

Dataset:

Output formats:

  • Format: Print
    • Template: missionReport_print.xsl
    • Print template: letterhead
    • Template option:
  • Format: Email
    • Template: missionReport_print.xsl
    • Print template: letterhead
    • Template option:

Form with member's information for a paper renewal

Report ID: memberForm

Form with member's information for a paper renewal

Active: false

Dataset:

Output formats:

  • Format: Print
    • Template: memberForm_print.xsl
    • Print template: letterhead_member
    • Template option:
  • Format: Email
    • Template: memberForm_print.xsl
    • Print template: letterhead_member
    • Template option: