ALMIS

1. ALMIS Aviation Logistics Management Information System Portal: http://cgweb.almis.uscg.mil Project: http://cgweb.arsc.uscg.mil/almis LCDR Daniel P. Taylor

2. Aircraft Computerized Maintenance System (ACMS) is used to manage aircraft maintenance and configuration. The application and the database are at ARSC. The users are spread out among 25 Air Stations, ARSC, and HQ. ACMS apps ACMS data

3. Data gets into ACMS through a data entry person. Data is transferred from a person to one or more paper forms, and input by a data entry person using a character-based application. character interface ACMS apps ACMS data

4. Reports from ACMS are limited to “canned” character-based reports that can be printed only on certain designated printers. character-based paper reports character interface limited printers ACMS apps ACMS data

5. charts, MOEs, information local applications character-based paper reports character interface limited printers ACMS apps Most units have their own standalone systems into which they feed some the same data that is input into ACMS … ACMS data

6. charts, MOEs, information local applications character-based paper reports character interface limited printers ACMS apps … or into which they re-key data from reports generated from ACMS. ACMS data

7. charts, MOEs, information charts, MOEs, information local applications local applications The Aviation Maintenance Management Information System (AMMIS) is used to manage aircraft supply, inventory, accounting, finance, procurement, depot maintenance, and flight operations. Until Summer 2000, there had been no system interfaces between AMMIS and ACMS character-based paper reports character-based paper reports character interface limited printers character interface limited printers ACMS apps AMMIS apps ACMS data AMMIS data

8. charts, MOEs, information charts, MOEs, information local applications local applications character-based paper reports character-based paper reports character interface limited printers character interface limited printers There were some interfaces, like the NMC report run from ACMS, then re-keyed into AMMIS for the Abstract of Ops report ACMS apps AMMIS apps ACMS data AMMIS data

9. Most of the integration between the two systems happened by people correlating reports from both systems. charts, MOEs, information charts, MOEs, information local applications local applications character-based paper reports character-based paper reports character interface limited printers character interface limited printers ACMS apps AMMIS apps Do I have the parts I need for the mx coming due? ACMS data AMMIS data

10. And there was plenty of redundancy and inconsistency in the two systems from the same data being put into both systems. charts, MOEs, information charts, MOEs, information local applications local applications character-based paper reports character-based paper reports character interface limited printers character interface limited printers How many times do I need to input flight time? ACMS apps AMMIS apps ACMS data AMMIS data

11. So what’s wrong with this picture?

12. Needed to build interfaces between the two systems and stop running reports from one and then re-entering into the other. charts, MOEs, information charts, MOEs, information local applications local applications character-based paper reports character-based paper reports character interface limited printers character interface limited printers X ACMS apps AMMIS apps ACMS data AMMIS data

13. charts, MOEs, information charts, MOEs, information local applications local applications X X character-based paper reports character-based paper reports character interface limited printers character interface limited printers ACMS apps AMMIS apps Needed to eliminate the non value-added data entry where possible and get data straight from the person who has it into the computer. ACMS data AMMIS data

14. charts, MOEs, information charts, MOEs, information local applications local applications character-based paper reports character-based paper reports character interface limited printers character interface limited printers X X ACMS apps AMMIS apps Needed to eliminate the redundant data entry. ACMS data AMMIS data

15. Needed to capture some of the information that hadn’t been captured, like discrepancy and corrective action for unscheduled maintenance. charts, MOEs, information charts, MOEs, information local applications local applications character-based paper reports character-based paper reports character interface limited printers character interface limited printers ACMS apps AMMIS apps ACMS data AMMIS data

16. Needed to make it easier to get information out of both systems – Right information, right place, right time, right format. charts, MOEs, information charts, MOEs, information local applications local applications X character-based paper reports character-based paper reports X X X character interface limited printers character interface limited printers ACMS apps AMMIS apps ACMS data AMMIS data

17. charts, MOEs, information charts, MOEs, information local applications local applications X X X X character-based paper reports character-based paper reports character interface limited printers character interface limited printers ACMS apps AMMIS apps Needed to eliminate the multiple data entry into standalone systems created by units because there had been no way to get out much of what had been put in. ACMS data AMMIS data

18. What have we done about it?

19. AMMIS, ACMS apps ALMIS data (AMMIS, ACMS, EAL) Transitioned to a unified architecture with a single physical database and legacy applications on a single machine.

20. character-based paper reports character interface limited printers AMMIS, ACMS apps ALMIS data (AMMIS, ACMS, EAL) Legacy applications remain. Much of AMMIS will remain, legacy ACMS interface will be gradually replaced by Electronic Aircraft Logbook.

21. character-based paper reports character interface limited printers AMMIS, ACMS apps New, browser based EAL and Decision Support System will use same single database architecture accessed through the ALMIS Portal. browser apps (EAL, DSS) ALMIS data (AMMIS, ACMS, EAL)

22. browser interface: on screen one click charts, MOEs, information character-based paper reports character interface limited printers AMMIS, ACMS apps EAL interface will be easy enough for user to input logbook data. DSS will provide on screen access to information using OLAP, reporting, ad hoc tools. browser apps (EAL, DSS) ALMIS data (AMMIS, ACMS, EAL)

23. browser interface: on screen one click charts, MOEs, information rich, formatted, schedulable, exportable reports, charts, MOEs, information character-based paper reports character interface limited printers any printer AMMIS, ACMS apps Browser based system allows for printing to any printer. Reports can be scheduled, exported to MS Excel, e-mailed, or printed. browser apps (EAL, DSS) ALMIS data (AMMIS, ACMS, EAL)

24. browser interface: on screen one click charts, MOEs, information rich, formatted, schedulable, exportable reports, charts, MOEs, information character-based paper reports character interface limited printers any printer Data can be exported to MS Excel or to CSV format for direct input into or linkage with unit-developed applications, without the non value added data re-keying. AMMIS, ACMS apps browser apps (EAL, DSS) ALMIS data (AMMIS, ACMS, EAL) charts, MOEs, information local applications

25. browser interface: on screen one click charts, MOEs, information rich, formatted, schedulable, exportable reports, charts, MOEs, information character-based paper reports character interface limited printers any printer AMMIS, ACMS apps browser apps (EAL, DSS) ALMIS data (AMMIS, ACMS, EAL) charts, MOEs, information local applications