Umler Equipment Management Information System EMIS Presentation to ACASCO November 9, 2005

1. Umler� Equipment Management Information System(EMIS)Presentation to ACASCO November 9, 2005

2. 2 Agenda Reference Files: A Primer What is UMLER; Historical Background UMLER Challenges Driving Principles Umler� EMIS Features Project Plan Work to Get There What You Need to Do The Bigger Picture

3. 3 Railway Shipments: A Primer Moving a product In a piece of equipment From a location to a location For customers (shippers, consignees) Over a given route Under certain conditions

4. 4 The Shipment Instruction

5. 5 Shipments in Reference File Terms Moving a product (STCC) In a piece of equipment Owned by someone (MARK) Having certain characteristics (UMLER) From a location to a location (CSM, OPSL) For customers (shippers, consignees) (CIF) Over a given route (ROUTE) With one or more carriers (SCAC) Having specific junction points (JUNC) To be placed on a customer�s siding (SCRS) Under certain conditions (SCF)

6. 6 What is UMLER? �Universal Machine Language Equipment Register� First industry-wide central equipment database Created in 1968 Central file for over 1.7 million units Locomotives, EOT�s, MOW and passenger cars 1/2 million trailers, containers and chassis Processes equipment data changes Ownership, weight, components, attributes, dimensions, ABT and FRA inspection dates and pool information Processes over 600,000 transactions monthly Mission and safety critical to almost all railway applications

7. 7 Historical Background Introduction of interchange Central maintenance of equipment rosters Loading and transportation handling Pooling of equipment

8. 8 UMLER Challenges Expensive mainframe design Fixed file format that is almost full Inability to adequately handle changing equipment attributes and business needs Lacking robust security Batch processing Y2K bridging Out of step with current ownership model 1960�s IBM punch card technology still basis of design Codified structure Expensive Mainframe design Batch processing Not Y2K compliant Linked into almost all Railway processes Major undertaking to modernize 1960�s IBM punch card technology still basis of design Codified structure Expensive Mainframe design Batch processing Not Y2K compliant Linked into almost all Railway processes Major undertaking to modernize

9. 9 Umler� EMIS Project Driving Principles Value Proposition to the Railway Industry Ensure complete security of data Increase data accuracy and timeliness Reach the entire rail industry Make the system easy to use Integrate with other systems Make the system flexible and adaptable Single, central system � allow for use versus build.

10. 10 Umler� EMIS Features Facilitates equipment-owner participation through multiple access media On line TRAIN II Web service FTP Dynamic messaging Real-time update and communication Full lifecycle history Improved data quality High level of security User driven administration Dynamic design Advanced query facilities

11. 11 Umler Redesign � Project Plan Phase I Car Management Information Processing (Pool Processing) � 2003 � 2004 Phase II Inspections � 2004 � 2005 (Delivery Feb 26, 2006) Phase III Car Characteristics, Transfers � 2005 � 2007 1960�s IBM punch card technology still basis of design Codified structure Expensive Mainframe design Batch processing Not Y2K compliant Linked into almost all Railway processes Major undertaking to modernize 1960�s IBM punch card technology still basis of design Codified structure Expensive Mainframe design Batch processing Not Y2K compliant Linked into almost all Railway processes Major undertaking to modernize

12. 12 What�s in Phase 1 Infrastructure Real time processing New Web site http://emis.railinc.com Customer registration Security grants and permissions Car management functions Pools and pool assignments Car grades Transportation codes/ EMIS equipment management codes EMIS TRAIN II messaging Web services

13. 13 What�s New in Phase 2February 26, 2006 All inspection reporting via EMIS ABT FRA locomotive inspections Door lubrication Vehicular rack and flat certifications Retro-reflectorization reporting Future transactions Correction and nullification Advanced query Data refresh Company specific groups TRAIN II users Old formats not supported after February 26, 2006

14. 14 What�s Changing in Phase 2February 26, 2006 Single Car Air Brake Test System shut-down UMLER ON LINE (TSUM) is 12 hour batch, but EMIS is real time Adds versus ABT reporting Legacy UMLER Pool Message (Umler 72-74-75) retired TRAIN II reporting of EMIS elements only via EMIS Umler01 data ignored Outbound messages and reports continue to contain ABT data, but some elements will be missing FRA locomotive, Flat/Rack inspection only via EMIS

15. 15 What�s Coming in Phase 3?Q4 2007 Equipment characteristics Adds/deletes/modifications Restenciling Component management Status management All reporting via Umler� EMIS Umler� online (TSUM) application will be retired Replaced by Umler� EMIS application Legacy Umler TRAIN II messaging retired (Umler 01, 71)

16. 16 Work to Get There Review UMLER data from the perspective of what is needed in the national file Recognized that more data is needed for owners What is needed for interchange What is needed for safety Reconcile existing UMLER fields Fields that are used for multiple purposes need to be split Unused fields need to be retired Fields with duplicate meanings need to be clarified Review new fields that have been requested Are they still needed Get back to the Umler committee by Year end 2005 (Needed now for spec writing)

17. 17 What Now? What You Need to Do? Complete the data element review Get in the know Visit : www.railinc.com Let your IT department know; get them involved Town Hall meetings Join us in the testing and development area Get ready to sign-up for the new system Key contacts CSC@railinc.com 1-800-544-7245

18. 18 And now for the demo�.

19. RailincEquipment Systems The Bigger Picture: How Things Fit Together

20. 20 Railinc Equipment Systems Umler� �Universal Machine Language Equipment Register� The industry�s repository of railcar information Umler� EMIS Umler Equipment Management Information System The new vision of Umler� EHMS Equipment Health Management System Communicating detector information from carriers to car owners Supporting the industry�s Advanced Technology Safety Initiative (ATSI) EW Early Warning Communicating safety-sensitive information from car owners to carriers CRB Central back-office reconciling of AAR billable repairs

21. 21 Other Railinc Systems That Support Equipment Management ER Event Repository Location and status of all rail equipment F&S Forward and Store� Integral to the industry�s Waybill system Contents and Lading Handling and billing instructions Destination of equipment RAMP-ed Railway Asset Management Equipment Disposition

22. 22 How The Systems Fit Together

23. 23 Screen Shots

24. 24

25. 25

26. 26

27. 27

28. 28

29. 29

30. 30

31. 31

32. 32

33. 33

34. 34

35. 35

36. 36