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 !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?

2 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 ! 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.)

3 Design data (performance specs, visuals, CAD drawings, etc.)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?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?

4 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? 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?

5 NnCommunication meansCommunication means?? Email? FTP? Online? Paper? Email? FTP? Online? Paper? ATA 2004 ATA 2004 eBusinesseBusinessForumForumIssues Solved !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) 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.

6 spec 2000 is a datastandard and an 2004 ATA 2004 eBusinesseBusinessForumForumElectronic data InterchangeFile TransfersAutoIDPurchasing / InvoicingRepair Order ClaimsCustomerMFR / Supplier / Repair AgenciesMarketplace DatabasesBar Coded Shipping LabelsPerm. 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!

7 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 ?Serial Number ?Employee Number ?Location ?Order Number ?SSN without the dashes ?Who knows ???ATA 2004 ATA 2004 eBusinesseBusinessForumForumExample of an Intelligent NumberSerial Number showing the Text Element Identifier (TEI)SER263265930spaceTEI4 charactersSerial Number1 15 charactersSimple, plain text, WYSIWYG, easy for people -easy for computersATA 2004 ATA 2004 eBusinesseBusinessForumForumExample of an Intelligent NumberSerial Number showing the Text Element Identifier (TEI)Simple, plain text, WYSIWYG, easy for people -easy for computersRFID Tag<SER>263265930 </SER>Serial NumberAntennaATA 2004 ATA 2004 eBusinesseBusinessForumForumThe business problem we re trying to solve is one of ( ) identificationand Traceability .

8 Historically, real parts Traceability is done poorly Historically, real parts Traceability is done poorly and is very expensiveand is very expensive Most parts tracked by Serial # within part # it Most parts tracked by Serial # within part # it hasn t worked ! hasn t worked ! Three logic flawsThree logic flaws Customers invent their own numbering systems for partsCustomers invent their own numbering systems for parts When form / fit / function changes When form / fit / function changes --new part # requirednew part # required--this effectively loses the ability to track itthis effectively loses the ability to track it No control between companies of part Numbers assigned, no legal No control between companies of part Numbers assigned, no legal teeth regarding bogus parts teeth regarding bogus partsTracking Parts Tracking Parts Why so hard ?Why so hard ?commonATA 2004 ATA 2004 eBusinesseBusinessForumForumTracking Parts Tracking Parts --the Solutionthe SolutionSpec 2000 Permanent Bar Code/RFIDSpec 2000 Permanent Bar Code/RFIDWhat is it?

9 A universal Social Security Number for serialized parts Simple elegance -Only 2 rules:1) unique Serial # within CAGE Code2) RFID tag, label or mark lasts the life of the partEasy to understand, Easy to communicateATA 2004 ATA 2004 eBusinesseBusinessForumForumWho is using Perm. part Marking?Who is using Perm. part Marking? Used by 1500+ international companiesUsed by 1500+ international companies An ISO 21849 specificationAn ISO 21849 specification Adopted by the AIA (Adopted by the AIA (Aerospace Industries Association)Aerospace Industries Association) Included in Included in DoDDoDUnique Identifier (UID) policyUnique Identifier (UID) policy It is adopted by the railroad industryIt is adopted by the railroad industry It is used in some automotive companiesIt is used in some automotive companies It is used in several military programsIt is used in several military programs C17, CH47 Helicopter, torpedo markingC17, CH47 Helicopter, torpedo markingATA 2004 ATA 2004 eBusinesseBusinessForumForumSo why do we want to mark parts ?

10 So why do we want to mark parts ?1. We have too much money and we need to spend We want to look busy for the rest of our We are mentally sharing of identification and tracking of the part has ALLthe benefits !ATA 2004 ATA 2004 eBusinesseBusinessForumForum Every piece of data is intelligentEvery piece of data is intelligent the electronic data (quotes, orders, adv. shipping notice, etc.)the electronic data (quotes, orders, adv. shipping notice, etc.)and the bar coded data and the bar coded data (shipping labels, perm. bar code ID) both use the same data iden(shipping labels, perm. bar code ID) both use the same data identifier tifier Bar coded data and HRI allows for business transitionsBar coded data and HRI allows for business transitions Human readable data allows for existing business systems to contHuman readable data allows for existing business systems to continue, and allows for inue, and allows for more advanced companies to benefit from Auto ID advanced companies to benefit from Auto ID savings.