A range of specialist technology services designed to ensure that APM’s suite of software dovetails seamlessly with your existing processes and systems.
Reporting Datawarehouse Synchronised database
Although APM’s software suite contains a comprehensive range of reporting options, airlines require as much information as possible to create bespoke analysis and statistical reporting.
APM’s Synchronised Database enables standard industry business intelligence tools to plug-in and retrieve vital data to create on-demand reporting, analysis and dashboards without compromising the integrity of the live database.
APM supplies documentation to explain the fields in the Synchronised Database. Users of an Oracle database must ensure their Oracle License permits them to provide access to the database for a third party. The synchronised database can be deployed using a Firebird, Oracle or MSSQL database structure. The frequency of integration of the synchronisation can be set by the customer but must be at least 10 minutes.
APM database Soap extract service
The ApmDb Soap Export is a web service designed to provide certain specified flight data to any other system. There are fourteen different function options to select data from,
‘apmDbSectorExtract’ provides a simple list of flight sectors.
- ‘apmDbFlightStatusExtract’ provides a more detailed list of flight sectors, which includes actuals delays, passenger, fuel and certain crew data.
- ‘apmDbCrewDutyExtract’ provides a detailed list of crew duties.
- ‘apmAmosSectorExtract’ provides a list of sector information used to import data in Amos software.
- ‘apmDbFlightLogExtract’ provides a list of sectors, which includes delay, pax, freight, fuel and crew data. The sectors are returned regardless they have a flightlog created in APM system.
- ‘apmDbGetCrewDetails’ provides details about a dedicated Crew member
- ‘apmDbGetFuelCostSetList’ provides a list of Fuel Cost Sets.
- ‘apmDbGetFuelSuppliers’ provides a list of Fuel Suppliers.
- ‘apmDbGetFuelTaxes’ provides a list of Fuel Cost Sets with attached Fuel Taxes.
- ‘apmDbGetFuelMarketRates’ provides a list of Fuel Cost Sets with attached Fuel Market Rates.
- ‘apmDbGetFlightLog’ provides a single flight log. Only sector having a flightlog created is returned by the method.
- ‘apmDbGetCrewRayDose’ provides a the sum of cosmic ray doses by crew member for a period.
- ‘apmDbGetPendingHotac’ returns the same grid as in “Hotac & Dhd -> Hotel Booking -> Pending Booking” within CrewLogic.
- ‘apmDbGetCrewGroundActivitiesCounters’ returns the list of ground activities with block counters.
Fatigue Risk Management Platform integration
Fatigue poses a large risk to aviation safety and the capability within APM’s crewing software to integrate with a Fatigue Risk Management platform offers many benefits to airlines. FRMSc’s Safe Suite is a platform to identify fatigues scores of both cabin crew (CARE) and flight crew (SAFE), assisting your airline in safe crew management. The model is based on the popular fatigue scale — Samn-Perelli seven-point fatigue scale (SPS).
APM customers with a SAFE suite license are able to track the fatigue risks to their crew members with the integration of the SAFE Suite of predictive fatigue models with our crewing module; CrewLogic.
APM Passenger File transformer service
The APM Transformer Service picks up a file in a non-XML format – supplied by a third-party system – from a folder, and transforms them into XML file message structure that is compliant with an APM XML schema. Specific versions of this transformation service can be developed to deal with particular file formats.
APM passenger file ingest service
The APM Pax File ingest Service picks up the transformed files generated by the transformer and ingests the pax figures into the APM database commercial segments.
APM IATA message decoder
Receives and transmits for specified IATA-compliant Type B messages.
Lido integration API
APM have an integration API exchange with the LIDO flight planning system which is available as an option.
- The development based on IBM MQSeries 184.108.40.206
— The development based on LIDO API v5.7.0 patch 1243
— The development based on APM V5
The messages available from APM to Lido are:
ASMs for Lido flight planning tool (messages are sent for the next 2 days before operations departure date, but this can be parameterized). The ASM messages are generated and sent automatically without any user intervention.
WAB (Weight and Balance Payload Message)
for each sector the message records either the expected or booked passenger numbers by gender, class; and adult, children, infant and then uses an APM weight dictionary to compute weights. Additionally for each sector the freight is entered into the flight sector information window.
The sum of the freight and passenger (possibly including crew members) weight values based on the weight dictionary calculates the total of the payload to transmit in the WOB message to Lido
WOB (Payload Message): for each commercial segment the message records either the expected or booked passenger numbers by gender, class; and adult, children, infant on commercial segment and then uses an APM weight dictionary to compute weights. Additionally for each commercial segment the freight is entered into the flight sector information window.
The sum of the freight and passenger weight values based on the weight dictionary calculates the total of the payload to transmit in the WOB message to Lido.
CMS message: (Crew data message based on crew information from CrewLogic for crew briefing giving Pilot in Command name, crew code, other crew roles and names plus duty position flight no,date). APM users must be using CrewLogic for this message to include appropriate details. The CMS messages are generated and sent automatically without any user intervention.
FUP: Fuel Price Message (taken from the financial tables in APM Financial systems, by airport fuel price, valid from date valid to). The FUP messages are generated and sent automatically without any user intervention.
MVT/MVA messages: Sent for actual time updates. The MVT/MVA messages are generated and sent automatically without any user intervention.
Posting Message: To MQSeries for various docs from APM to LIDO, for example, GenDec can be sent from the APM system to Lido for flight briefing.
Message from LIDO to APM: APM collect these messages from the MQSeries Lido API with a service scan.
WABi: this message includes ETE, planned trip fuel, estimated block fuel. We use this message in APM to update actual times based on the departure time of the sector, total fuel and planned trip fuel.
Lido Flight Plan Briefing Package: This is available from Lido subject to specification and additional cost.
APM Integration Message Processor
The APM Integration Message Processor is a service that generates MVT and ASM messages including NEW, CNL, RIN, TIM, CON, RPL, FLT and EQT messages from the APM system to a third party system for integration purposes.
The Integration Message Processor must be configured within the service itself with all recipient addresses for the third party system, not the addresses as normally set in SmartOps for MVT or ASM’s message transfer. Once this is done the user needs to take no further action for the integration message recipients as configured within the service itself for the third party.
Users also set the integration period of the message transfer from the APM Integration Message Processor to the third party system. The messages will transmit automatically, unless users elect to use the APM Integration Survey utility, which enables the user to review
The integration message flow can only be transmitted to a defined folder on the customers network and the message can then be collected by a third party software from that folder.
Crew SAFE (Fatigue Management) Roster File Export
The APM SAFE (Fatigue Management) Roster File Export is a module which generates upon a User request an excel file that can be sent to the ‘SAFE’ system who will calculate the Fatigue Management score in their system, normally before a roster is published.
With this process the Fatigue Management score is not indicated within the APM system,
the Fatigue Management score is indicated in the SAFE system and therefore using this analysis, the User must make amendments as necessary to the CrewLogic Roster and re-export the file to SAFE to ensure the results comply with Fatigue Management limitations. With this export, compliance to Fatigue Management limitations is the responsibility of the User and the SAFE system.
This Export module by APM is a separate executable the User must rent from APM, called ‘SAFE’ Roster Export.
SAGEM Flight Data Management Suite Export
The APM SAGEM Flight Data Management Suite Export is a module which exports on demand or as a service, aircraft details with flight routings including estimated and actual times together with flight deck crew duty information. The SAGEM calculations will use this data in accordance with the SAGEM contract between the airline and SAGEM.
For further details refer to the SAGEM website,
Aerobytes File Extract (APM V6 and later)
The Aerobytes File Export is an extract report from that can be produced in a CVS file that can be either manually or automatically uploaded into the Aerobytes system in order for Aerobytes to align the data with the flights actually flown and to establish who flew the particular flight. The end user report for the airline is produced by Aerobytes.
For further details refer to the Aerobytes website,
Crew Engine Service
This service performs all automatic background tasks related to Crewlogic (automatic check & save of rotations following a modification on a flight, automatic verification and repair of PN counters).
Crew Passed Qualification Events Update
This service automatically validates all PN re-qualification events for the recurrent check whose “Auto Ack Passed Events” column is checked as soon as the event passes.
SSIM import service
This is an interface which can import from a defined folder an SSIM Chapter 7 file, the import populates a schedule scenario with the flights and builds the flight rotations with airports defined in the APM database as schedule stops. It then assigns the rotations to aircraft registrations according to onward flight information (DEI6). The system will then assign the scenario to the Live production schedule.
FCM Generators for Flight Crew Manifest messages generation (APIS)
This is an automatic flight crew manifest message generator following which the message is sent to the appropriate authority.
The APM File Export Service.
The APM file Export Service is an application that enables the User to,
Export a CSV file or Standard and Closed Accruals,
Export a CSV file of the APM Generic Stats Report
Message Transported Service
This service allows to retrieve the messages from a SITA inbox or an email box to insert them into the database APM. It also allows you to deposit IATA messages generated by the APM system in an out folder and send them via SITA or via email.
The APM Ops Engine.
This service performs all automated background tasks related to SmartOps for a draft (to be validated by third party systems) automatic Zero Fuel Weight Calculation.