Part Traceability Data Standards - Spec 2000

1 ATA 2004 ATA 2004 eBusinesseBusinessForumForumPart TraceabilityPart TraceabilityData StandardsData StandardsJon AndresenPresidentTechnology SolutionsOakland, CASpec 2000 -An Industrial Standard for this MillenniumAtlanta, GA Technology Solutions 200429 October 2004 ATA 2004 ATA 2004 eBusinesseBusinessForumForumHere to tell you: forget the damn technology !(I m really the DataGuy!)Who Am I ?Who Am I ?ATA 2004 ATA 2004 eBusinesseBusinessForumForumDon t get sucked in by the technology !ATA 2004 ATA 2004 eBusinesseBusinessForumForumATA 2004 ATA 2004 eBusinesseBusinessForumForumATA 2004 ATA 2004 eBusinesseBusinessForumForumATA 2004 ATA 2004 eBusinesseBusinessForumForumATA 2004 ATA 2004 eBusinesseBusinessForumForumnnYaYagottag ottaprove everything !

2 Prove everything ! Where did it come from?Where did it come from? When did it come from there?When did it come from there? Who brought it?Who brought it? Where is it going ?Where is it going ? When will it get there ?When will it get there ? Where is it now ?Where is it now ? Who has it ?Who has it ? What condition is it in?What condition is it in?Here s the Problem !Here s the Problem !Safety CriticalSecurity CriticalCost CriticalATA 2004 ATA 2004 eBusinesseBusinessForumForumThe Problem:The Problem:More Info to CustomerMore EfficientLess StaffCollaborate w/ SuppliersExpand Customer BaseKeep Costs DownMore RegulationsYou !

3 Faster Faster Cheaper !Cheaper !Better Better ATA 2004 ATA 2004 eBusinesseBusinessForumForumWhy Spec 2000 ?Why Spec 2000 ?Customer ASupplier 1Is this your business model ?ATA 2004 ATA 2004 of this !..because of this !Customer ASupplier 1 Customer DCustomer CCustomer BCustomer ESupplier 4 Supplier 5 Supplier 2 Supplier 3It is too costly to do business 25 (or 2500)different ways !ATA 2004 ATA 2004 eBusinesseBusinessForumForumCustomer/Sup plier InterchangesCustomer/Supplier InterchangesRequirements Specification for new part (documents, diagrams, etc.)Design data (performance specs, visuals, CAD drawings, etc.)

4 Commercial negotiations (discussion documents, contract drafts, etc.)Progress Monitoring/updates (letters, phone calls, documents, etc.)Initial/replenishment Purchasing Transactions (POs, expedites, etc.)Parts Shipments Involving New, Repair, Warranty, & Exchange PartsTrading Transactions (quotes, warranties, invoices, etc.)Engineering & Maintenance Information (manuals, graphics, training, etc.)Customer Support & Service Bulletins (documents, photos, graphics, etc.)CustomersSuppliersParts Traceability : mfgr, install, remove, repair, store, ship, scrap, 2004 ATA 2004 eBusinesseBusinessForumForumWhat s Needed for Success?

5 NnCommon dataCommon data Whose part # are we talking about? How long can it be? Whose part # are we talking about? How long can it be? Can it have special characters in it?Can it have special characters in it?nnCommon identityCommon identity How does everyone uniquely identify this part ? What is its How does everyone uniquely identify this part ? What is its Social Security Number that never changes?Social Security Number that never changes?nnMinimum Standard for TraceabilityMinimum Standard for Traceability When you do something to the part , what data do you When you do something to the part , what data do you record?

6 What business benefit is gained by having data ?record? What business benefit is gained by having data ?ATA 2004 ATA 2004 eBusinesseBusinessForumForumThe IssuesThe IssuesnnData standardsData Standards ?? When you say part # , whose are you talking about?When you say part # , whose are you talking about?nnCommon formatCommon formatto the data you send/receive?to the data you send/receive? Excel spreadsheet? Word document? Transaction?Excel spreadsheet? Word document? Transaction?nnCommunication meansCommunication means?? Email? FTP? Online? Paper? Email? FTP? Online? Paper? ATA 2004 ATA 2004 eBusinesseBusinessForumForumIssues Solved !

7 Issues Solved !With Spec 2000 With Spec 2000nnData Dictionary defines all dataData Dictionary defines all data Definition, field lengths, special characters, , field lengths, special characters, spreadsheet data formatsSimple spreadsheet data formats It works from PC s Excel to mainframe SQLIt works from PC s Excel to mainframe SQLnnCommunication remains flexible Communication remains flexible accommodates your needs and capabilitiesaccommodates your needs and capabilitiesWhat is Spec 2000 ?What is Spec 2000 ? A specification to exchange information:A specification to exchange information:--Purchasing transactions Purchasing transactions --Repair Order transactionsRepair Order transactions--Aircraft and Engine warrantyAircraft and Engine warranty--Reliability data Collection and Exchange Reliability data Collection and Exchange -- part Marking using data (not just text)

8 System for buying and selling aircraft parts and repair serviceSystem for buying and selling aircraft parts and repair servicess--Defines data for business transactionsDefines data for business transactions Established network of 1500 suppliers and airline operators Established network of 1500 suppliers and airline operators Established and very well supported EDI formatEstablished and very well supported EDI format--used for 40+ years used for 40+ years --started as ATA Spec200started as ATA Spec200In Summary:Spec 2000 is a datastandard and an 2004 ATA 2004 eBusinesseBusinessForumForumElectronic data InterchangeFile TransfersAutoIDPurchasing / InvoicingRepair Order ClaimsCustomerMFR / Supplier / Repair AgenciesMarketplace DatabasesBar Coded Shipping LabelsPerm.

9 Bar Code/RFID ID on Parts1500+ companies involvedWorldwide !Tools, Test, & Ground Prices / Lead TimesRepair Agency Capabilities / PricesSurplus Parts AvailabilityReliability DatabaseProvisioningDelivery ConfigurationInventory Consumption DataLead Time Performance DataReliability DataSpec 2000 eBusinessTraceability DatabasesEDI StandardsATA 2004 ATA 2004 eBusinesseBusinessForumForumPermanent Bar Code/RFID Identification of PartsLegend:Existing Standards In-Process StandardsFuture StandardsJon Andresen, President Technology SolutionsRev: May 2004 Spec 2000 Common DataThe Foundation is laid with common data !(giving parts a Social Security Number)Functional and data ArchitectureSpec 2000 ATA 2004 ATA 2004 eBusinesseBusinessForumForum It is the strong foundation you want to build on It is persistent It guides corporations in all decisions It spans applications and ERP systems, and yes,even Vice Presidents!

10 ATA 2004 ATA 2004 eBusinesseBusinessForumForum2000 x !Cost to fix an errorCost to make an error2000 How much does bad data cost you ?ATA 2004 ATA 2004 eBusinesseBusinessForumForumBenefits of RFID/Bar Code TechnologyTimeAccuracyTimeAccuracyManual data EntryRFID/Bar Code data Entry1) Touch typists average 1 error every 30 characters2) Bar code errors occurs once every 3 million characters !How many touch typists in your production areas ?3) RFID is even more accurate than that !ATA 2004 ATA 2004 eBusinesseBusinessForumForum263265930 What sthis ?This is a NAKED number with no intelligence whatsoever ! part Number ?