Attachment_2_PWS_-_DLA_Land_and_Maritime.pdf

Attachment 2 – Page 1

Attachment 2

PERFORMANCE WORK STATEMENT – DLA LAND & MARITIME

DLA Enterprise Online Databases Subscription Service

A. INTRODUCTION

1. General Information: Managing the enormous volume of technical and contractual information from internal and external sources is critical to the completion of DLA Land and Maritime’s mission. DLA Land and Maritime requires a comprehensive suite of information in electronic media to assist their engineers and technical professionals in making better, faster and more cost-effective decisions. This online information is to consist of a collection of specifications, standards, parts catalogs, and regulations required too support research and procurement of DoD items of supply by DLA Land and Maritime professionals.

The items being researched are required to support the Military Services and ultimately the warfighter.

2. Objective: To provide DLA Land and Maritime with an array of technical and procurement data to assist in supporting the Military Services and ultimately the warfighter.

B. DESCRIPTION OF WORK

1. General: Refer to Appendix A for a list of acronyms used in this document.

2. Technical Aspects:

a. Must be compatible with the current DLA Land and Maritime integrated work stations (IWS) configuration.

b. Must be compatible with Windows XP Sp3.

c. Must be able to run without the user having administrative privileges.

d. The service is to include a comprehensive single index that allows various types of searching and management reports, with the ability to identify specific documents then view and print the actual document pages via desktop IWS.

e. Security provided via usernames and passwords for systems with proprietary/sensitive data.

f. Document images scanned at 300X300 dpi. Minimum. All images must be PDF format.

h. Document images must be viewable in PDF (Adobe Acrobat) format.

DODISS documents must be viewable/searchable as full-text with intradocument linkages and cut-and-paste capabilities to Notepad, word processors, etc.

i. Must be able to print individual pages, range of pages, or the complete document.

j. Must use the Internet, standard Web browsers, and the Adobe Acrobat image viewer to deliver the data, so no customized software installation or configuration is necessary to use the product.

k. Must allow for a minimum of 25 simultaneous users of government specifications and standards. The minimum number of simultaneous users

Attachment 2 – Page 2 for each non-government specifications and standards organization shall be as specified below.

l. Must allow for a minimum of 100 simultaneous users for the logistics database application.

m. Must have user friendly features to obtain yearly demand for a standard within five years.

n. Must be able to filter an FSC search removing previous standardization and outside the five year purchase window leaving a remainder of opportunities sorted by part numbers to be used for the PA to determine writing new standards.

3. Training and Support

a. Users must have access to product customer service 24 hours a day via phone and email.

b. The supplier’s packaged price must include 30-days on-site Logistics Database Application Training with up to 4-days in any given month for an employee to be on-site to assist with training, process issues, troubleshooting, report, design, and product application assistance.

c. Monthly user reports for all DLA enterprise users should be submitted with user statistics and usage for the various subscription services.

4. Specifications and Standards

a. Government Specifications and Standards: The service shall provide as a minimum access to the following documents with access to both index and complete and unlimited access to full-text images in PDF and/or ASCII Text:

Military Specifications and Standards Navy Technical Publications Federal Specifications and Standards Commercial Item Descriptions (CIDs) Joint/Army-Navy Specifications and Standards Military/Federal Qualified Products Lists (QPLs) Qualified Manufacturers Lists (QMLs) Military Handbooks Military Bulletins MS Drawings AND, ANA, AN Drawings DLA Drawings Data Item Descriptions (DIDs) Federal Information Processing Standards Naval Instructions and Directives DoD Directives

Attachment 2 – Page 3

NASA Documents Historical (cancelled and superseded) documents Federal Construction Regulations from the Corps of Engineers, Army, Navy, Air Force and other Federal Agencies NATO Documents (including STANAGS and AQAP)

b. Non-Government standards including DoD Adopted non-government standards:

This section must provide direct access to images to documents from the following Standards Developing Organizations:

Non-Government Standard Body

Minimum # of Simultaneous Users

Non-Government Standard Body

Minimum # of Simultaneous Users

AA 3 FMVSS 3

ABMA 3 IEEE 3

ABS 2 IESNA 3

ACI 2 FORD 3

AGA 3 GM 3

AGMA 3 GMW 2

AIA/NAS 5 ICEA 2

AIAA 3 IEC 3

ANS 2 IPC 3

ANSI 2 ISA 2

ANSI/ESD 2

API 3 ISO 2

AHRI 3 MSS 3

ASA 3 NACE 3

ASME 5 NAVISTAR 3

ASME BPVC 3 NEMA 3

ASSE 3 AWS 3

AWWA 3 NFPA 2

BHMA 2 NISO 2

BOCA 2 NSF 2

BSI 2 PIA 2

CGA 2 PPI 3

CSA 3 SMACNA 3

CTI 2 SSPC 3

Attachment 2 – Page 4

Also Historical Non-Government Standards for: ANSI, API, ASME, ASTM, CSA/AGA, DIN, IEEE, NEMA, SAE, UL, EIA, IEC, AWS, NFPA, ANS, AIA/NAS.

The standards should include Redlines or Version comparison documents, that help end users to quickly identify the changes made between the current and historical versions of documents. A redline includes the complete text of the document, as it appears in the current published version, with changes from the previous version highlighted in context.

Vendor must provide access to 3-Dimensional Standards with access to 3D models for National Aerospace Standards (NAS/NASM/NAM/NA).

This service must allow the technical user/engineer to visualize and refine the specific configured model as necessary (example: define the required parts based on parameters such as thread size, length, material, finish, and locking type) before generating a 3D model that can be saved into more than 150 native and neutral CAD and graphic formats. The engineer can then insert the model into a computer design.

ANSI/ESD standards include as a minimum, S13.1, S6.1, S4.1, S4.2, S1.1, STM2.1, STM3.1, STM7.1, STM9.1, STM12.1, STM97.1, STM97.2, ESD TR53 and ESD SP9.2

(1) All non-government standards must be licensed by the issuing standards developing organization to allow image viewing and printing of the desired actual standard in hardcopy format as needed.

(2) Document images must include full English translation.

(3) Documents must be updated a minimum of every 7 days.

(4) System must identify recently updated documents.

(5) System must provide automatic update notification capabilities.

(6) Documents must be provided via electronic media. Hardcopy delivery of documents will not be considered.

c. Specifications and Standards Search: The system must allow the user to locate specific military information by the following methods:

(1) All Military/DoD, Government, and Non-Government documents must be included in the same product using the same search engine.

The index must include not only Military/Government documents

EIA 3 TIA 2

AWS 3 UL 3

CEA 3 ECA 3

JEDEC 3 SAE 3

Attachment 2 – Page 5 but also DoD adopted industry standards and industry standards.

(2) Searching by document number or portion of a document number, including alpha prefixes and decimal points.

(3) Keywords must be searchable from the index in the Title of the document, Scope/Intended Use/Keyword paragraphs and from the document outline for all documents that include this information.

(4) Keyword searching of the full-text of DODISS documents from the index and the ability to copy- and-paste this information into any Word Processor. This full-text ASCII provides easy copy-and- paste capabilities into any Word Processor software to expedite project documentation.

(5) Searching by Federal Supply Class (FSC).

(6) Searching by Preparing Organization.

(7) The product must have the capability to conduct a search by specific document type. For example, search by Military Specifications, Federal Specifications, etc.

(8) The product must be capable of limiting a search to active or historical (canceled/superseded) document references.

(9) Combination or Boolean searching must be possible.

(10) Each search query should provide the user with a Results List. The

Results List must identify the document number, active or historical status, publication date, if it is newly revised, and the document title.

d. Document Reports: The service must make available the following reports:

(1) A document summary that provides Scope and Intended use information for Government and DoD adopted standards.

(2) Keywords assigned by the author of the document, for example see

Document Summary for MIL- STD-1580A.

(3) Additional management information such as applicable QPLs, DIDs, etc.

(4) Links to QPL and FLIS data when applicable for DODISS documents.

(5) An Applicable Documents report that lists all documents referenced within the document for Government and DoD Adopted standards.

(6) Links to applicable documents.

(7) Responsible Activities report that includes addresses, phone/fax numbers, and email addresses for the Preparing Activity, Custodians, Reviewers and the Society/Organization.

(8) A history of the document to include the date of the base document as well as any revisions or amendments, with links to those documents.

(9) A complete document outline that allows the user to go from the index directly to the paragraph, sub-paragraph, or section level rather than simply the first page of the document.

Attachment 2 – Page 6

(10) The report information must be printable.

e. Additional Service Features

(1) Favorites List – includes capability for users to add any document in the service to his/her Favorites List with a single click. Documents on the Favorites list should be automatically tracked for changes, and email Alerts should be sent out when changes occur.

(2) Favorites List/Notes – includes ability to add Notes to documents on the user’s Favorites List for personal viewing.

(3) Watch Lists (Document List Management) – includes ability for users to create Watch Lists of documents for individual or project team access. Users can create as many “named” Watch Lists as needed. Documents on a Watch

(4) List can be maintained at a specific version, or they can be updated to the most current version. Users can manage access to their Watch Lists, i.e., determine other users that can have view and/or edit rights. All (or selected) documents on Watch Lists should be automatically tracked, and email Alerts sent out when changes occur.

Users should be able to include additional email addresses in order to share Alerts.

(5) Alert (Revision) Notification – all documents on a Favorites List or Watch List should be tracked and Alerts generated when changes occur, including new revisions, amendments or other new pages, or cancellations. Alerts should be sent by email. Alerts should also be displayed online (on the Alerts tab).

(6) Change Type – The system should provide “Change Type” information for documents that easily identifies the “Type of Change”, including Update Revision, Editorial and more. Document “Change Types” should display on the Document Summary and on Watch Lists. Email Alert Notifications should also include the “Change Type”.

(7) Account Notes/Annotations - Administrator should be able to add Notes to any document record within the service irrespective of whether it is included in their subscription. Administrator-added Account Notes should be visible to all users. Account Notes should include the ability to hyperlink to other documents, for example, an internal procedure document.

(8) My Publications – Administrators should be able to add their own document information to the index. Added records should be indexed, integrated and searchable within the index using all of the searching and filtering functions. The bibliographical data can also be linked to a document maintained on a secured environment using a URL.

Attachment 2 – Page 7

(9) Save Search – users should be able to create complex queries and save them under any name they choose. Once a search strategy is saved, users should be able to recreate the search at any time.

(10) Download/Export and Print Search Results – users should be able to download up to 1000 search results into a Microsoft Excel worksheet. Users should be able to print search results.

(11) User Preferences – the system should allow users to personalize settings and display of search results, including the date format, number of results per page, number of recently viewed documents, Search Filters defaults, display of DoD Adopted/ANSI Approval indicators and even select the display language of document titles.

(12) Purchase Individual Documents – the system should provide the capability to purchase documents that are not included in the subscription license.

5. Databases

a. Logistics Database Applications: Access shall be provided to the following databases/information systems:

FLIS DoD I&S

H6 H4/H8 CAGE

H2 Procurement History Technical Characteristics GSA Procurement History MOE Rules Federal Agency Procurement History CAGE Cross Reference DODAAF Section K Data (Obsolete NSNs) AMDF Historical NATO Stock Numbers SB700-20 Product Item Description D043/D043X Mil Spec/ Standard/ Drawing Number D049

APL/AEL P2300

MIAPL P2310

Trident APL/AEL P2330

NMDF WUC

NICP/CRF QPL

NICN-to-NIIN PMA LIRSH Canadian MCRL MSC Procurement History Canadian Procurement History

MRIL

NFTD

ILS

SRVA

EPLS

Attachment 2 – Page 8

b. Database Specific Requirements: A description of each database and information system listed above can be found in Appendix B. Access to this information must be independent and integrated throughout the information resource management system. The following database search provisions apply:

(1) The FLIS database must be searched by any combination of the following fields: Manufacturer’s part number (which must be found by specifying ANY portion of the part number), FSC, NIIN, NSN, Item Name (both approved and unapproved item names), CAGE Code, Company Name, Source of Supply, Acquisition Advice Code, Item Name Code, end item codes from the Army, Navy and Air Force, Navy COG code, PID Keyword, PID Specification, and technical characteristics.

(2) The FLIS database must reference PID information for any NIINs that report such information. This is a mandatory requirement since PID data often has technical data that is not referenced in the technical characteristics and references specification, standards and drawing number data.

(3) The FLIS database must search obsolete NIINs found in the Section K or E of the FLIS database and instantly reference the correct replacing NIIN.

(4) Company Name searches must allow the user to select multiple CAGEs that represent the company name searched (since the user may not know which manufacturer’s facility pertains to their search).

(5) Keyword searches must select all the records that match the keyword values.

(6) Each database must be independently searched by applicable fields or combination of fields, i.e., the WUC database must support searching by Work Unit Code (brief and extended) and item name.

The AMDF must be searched by any combination of the following search keys: NIIN, Keyword , EIC and LIN; Procurement Histories must be searched by NIIN, CAGE , Company Name, Keyword, Source, Contract Number and Government Fiscal Year. The MIAPL must be searched by APL/RIC, Nomenclature, Drawing Number, Specification Number, NIIN, CAGE, Manual Number; the DODAAF database must be searched by City, Country, Agency Name, State, Zip Code or DODAAC Code. The CAGE database must be searched by any combination of the following search keys:

CAGE, Company Name, City, State, Zip, SIC, Telephone Number.

(7) CAGE data must be accessible at any time while using the service.

The CAGE data must provide access to CCR, D&B, and contact info from at least one additional source. All CAGE codes must be defined

Attachment 2 – Page 9 by double clicking on the CAGE value.

(8) Technical Characteristics must be searched by specifying any search in the FLIS, and then narrowing the search by any applicable technical characteristics, regardless of INC or Item Names. Users must be able to research parts by entering one or more of its technical characteristics, including numeric range values. Users must also have the ability to select one or more answers from a pick list of valid replies. Selecting only one value from the pick list will be considered unacceptable by DLA Land and Maritime since this will not fulfill the purpose of searching by technical characteristics. Users must then be able to cross-reference the FLIS data for each technical characteristic record retrieved and instantly view all relevant data to the computer screen.

(9) A flexible Batch feature must be available to query each database independently by any single search key. The FLIS database must also be searched by a Part/CAGE combination in order to retrieve just those specific FLIS records. Batch data must be input via keyboard or a file and downloaded to either the printer or a file.

Output to a batch must be available in the following formats:

Standard formatted reports, user customized formatted reports, ASCII reports or user customized ASCII reports. Users must be able to save their search values entered manually to a file for later use.

Batch values resulting in no hits must be recorded in an error log.

Users must not be limited to the number of batch values searched when entering batch values by file. The system must allow up to 500 search values to be entered when batching by keyboard. The batch processing must take place on the server so that the user’s workstation is not tied up during the batch process.

(10) All databases must support unlimited, fast batch searches, including FLIS, CAGE, Procurement History, APL, AEL, etc. by multiple search parameters, for instance partial part number and Item Name in the FLIS, Contract Year and Source for Procurement, Hull Number for APL, etc. This is a mission critical element for DLA Land and Maritime to support a variety of analytical functions across the organization.

(11) The system must provide an instant, clearly visible cross-reference to additional databases that have more information regarding the part searched. For Navy users, the CRF must be one of the databases that are referenced. The user must have complete flexibility in selecting the databases to automatically cross-reference.

(12) To accommodate DLA Land and Maritime users, the system must allow users to search by a NICN (Navy Item Control Number) in the FLIS search screen. If the NICN has been assigned a FLIS record, Attachment 2 – Page 10 the system must report back the FLIS record and show the NIIN/NSN cross-referenced.

(13) Users must have the ability to customize their reports to field level data elements. Users must have the flexibility to permanently save a preferred output format and use this format when printing reports to the printer or file. The custom output feature must operate when interactively searching the product or when invoking the batch search capability. This feature is necessary to DLA Land and Maritime since limiting reports to include just the information needed saves time, paper and other resources.

(14) The system must have a way of tracking usage by username or by project number, shared by any number of usernames. This feature is key for DLA Land and Maritime since usage tracking helps track work-loads and reflects product access. Reports must be generated to show usage by username and/or by project number.

(15) To accommodate DLA Land and Maritime Navy database users, the APL and AEL databases must have the ability to search by NOMENCLATURE, HULL # and UIC Number. Nomenclature searches must search all words (regardless of order) and numeric values. This is a key factor for accurately researching APLS. Also, the APL and AEL databases must support batch searching, where users are able to customize their output to a field level.

(16) Also to accommodate DLA Land and Maritime Navy database users, the service must allow output to the Navy’s ICAPS and ROMIS software programs. This is an important feature since output to these programs saves labor time and ensures accuracy.

(17) System MUST have ability to find parts by ANY PORTION of the part number and narrow the search results by COMPANY NAME – this does NOT include selecting each separate CAGE code to complete the search, which would result in much wasted time. This search must be supported in any databases referencing part numbers, including FILS, CRF, D049, PMA, P2300, etc.

(18) Logistics system MUST allow technical characteristic searches to be performed by multiple INC classes. Selecting one INC at a time does not meet DLA Land and Maritime’s search requirements.

(19) All PID (Product Item Description) text must be searchable, not just included in reports.

(20) In order to maintain reporting standardization, it is critical for each department to customize their reports to a field and cross database level. These reports, once created, must be made available to groups or departments in order to share report structures.

Attachment 2 – Page 11

6. Manufacturers’ Catalogs: Provide a catalog service that allows simple, full-text searching on manufacturers’ catalogs. The service must provide catalogs for a minimum of 16,000 manufacturers and have the ability to expand the list based on users’ queries.

a. The database must be searched by any combination of the following fields:

Keyword, Part Number (which can include any numeric searches; e.g., part number, referenced document number, NIIN, NSN, etc.), Manufacturer Name (includes old names, alternate names or GSA contractor number).

Both PDF and non-PDF documents are searchable and accessible in this database.

b. The database must allow searching for manufacturer’s catalogs by any of the following: Street Address, City, State, Zip/Postal Code, Country, Telephone #, Fax #, SIC Code, NAICS Code, CAGE Code with a result of the actual vendor’s catalog or data sheet.

c. The results list from any search must produce a single list of results with the ability to view manufactures information and/or full-text catalogs from that results page. It is also critical that a relevance ranking system indicates and sorts the results based on best match to the search criteria with the best matches appearing first.

d. The service must provide the ability to locate products by industry or military standard, such as ASTM A276 or MIL-STD-1290. It must also provide the ability to combine the search for a product by industry or military standard, keyword, and /or manufacturer such as MIL-STD-1290 and fuel valve.

e. Access to a service containing commercial and military parts is required and the service must include full-text database to both commercial vendor and GSA information. It must contain full-text document pages of supplier catalogs, data sheets, and related documents, and contains GSA supply schedules, contractor information, and related publications. All COTS or government-approved sources for items and information can be searched, viewed, and printed using the same product and the same search engine.

Access to partial catalog information, URL links to the vendor’s web page or on-line catalog information is not acceptable.

f. The service must include an automatic word thesaurus to link related terms, enabling technical and procurement personnel to search for a part using familiar language.

g. A category filtering option allows results to be displayed across the entire database or by subject area or industry (e.g., Materials, Marine, Aerospace, GSA). This allows for targeted results, saving valuable research time

h. The service must include an automatic NSN list is generated for any catalog that has matches in the product with links to government parts and logistics database information.

Attachment 2 – Page 12

i. The user must be able to find manufacturer or distributor information for the item searched. This information is to include manufacturer listings for all vendors and distributors with catalogs in the database. These listings contain addresses, sales office listings, contact information, NAICS/SIC/CAGE codes and URL links to manufacturer's websites where available. It also should include over 400,000 "directory only" manufacturer listings (no images available) that link to Harris InfoSource profile information.

j. The user MUST be able to automatically cross-reference other databases for more information about the item searched.

k. This product is updated daily by the provider to insure the availability of current, accurate information.

7. The vendor shall provide an electronic component part lookup which will provides technical and logistics personnel with sources of hard to find products or products which are or soon will be no longer manufactured. The database shall research, approve, document, source, and cross and/or recommend electronic components.

a. The vendor database shall provide sources for hard to find electronic components that fit onto or connect up to a Printed Circuit Boards (PCB), which are or soon will be no longer manufactured.

b. The vendor database shall provide information on hard to find electronic components which are no longer manufacture.

c. The vendor database shall provide information and allow access to electronic components

d. The vendor database shall provide information and allow access to more than 440 million components, including parametric details, and cross reference (substitutability

e. The vendor database shall provide documentation (datasheets, end-of-life, status changes) for individual components

f. The vendor database shall provide historical tracking information for individual components

g. The vendor database shall provide material content on Restriction of Hazardous Substances Directive (RoHS) and Lead-free parts

h. The vendor database shall provide complete coverage from more than 3,800 manufacturers

i. Identify and cross reference PCB connectors and similar parts to include mating connectors, tooling and accessories

j. Search by part number (including generic and partial part numbers) product category, or manufacturer name

k. Access component status information

l. Identify replacement parts for current and obsolete parts

m. Access to revision histories for current obsolete, and historical semiconductor parts

n. Access Qualified Parts List (QPL) listings and related documents for mil-

Attachment 2 – Page 13 spec parts

o. Cross-reference (substitutability) for individual parts/components

p. Obtain detailed part characteristics

q. Links to NSNs and to the QPD

r. Identify RoHS compliant and lead-free parts, and access their related documentation.

s. Identify Reach compliance information, and access their related documentation.

t. Identify DRC compliance information, and access their related documentation.

u. Identify counterfeit alerts by accessing manufacturer, GIDEP and Electronic

Systems Community (ESCO) alerts.

v. Access Aftermarket Manufacturers

w. Access to 48 Franchised and Independent Distributors for Inventory, Lead

Time and Pricing.

8. A parts list comparison tool to oversee component and supplier risks. This tool provides a strategic approach to product management by actively monitoring and notifying impending changes to critical components or suppliers. This tool should assist in establishing best Diminishing Manufacturing Sources and Material Shortages (DMSMS) practices for avoiding obsolescence and sourcing issues with an enterprise view of suppliers, components and product configurations.

a. This parts list comparison tool must compares parts data with information contained within the Electronics Database of over 440 million parts from over 3800 worldwide manufacturers. The parts list comparison tool must provide:

Timely alerts to impending sourcing issues Component life cycle and years to end of life forecasts Up to 131 Attributes / Parts PCN & EOL Notification and Historical Content: 1960-1980 48 electronic part distributors, updated daily and 13 Aftermarket

Manufacturers Cross-references to alternate parts (with over 350M Direct and Similar) Access to electronic manufacturer’s Authorized Distributors Links to NSNs and to the QPD

b. The parts list comparison tool must give access to the add on fasteners database for part number scrubbing with links to Manufacturer datasheets and Specs and Standards drawings

c. The parts list comparison tool must give ability to load reference lists to match additional columns of internal knowledge

d. The parts list comparison tool must give obsolescence issues, life cycle forecasts, PCN's, EOL Notices, GIDEP and Electronics Systems Community (ESCO) counterfeiting alerts must be clearly indicated and potential

Attachment 2 – Page 14 resolutions offered by the BOM Manager in order to expedite the decision making process.

e. The parts list comparison tool must give identify obsolescence issues by actively monitoring component status changes, life cycle forecasts, manufacturer PCNs, EOL Notices, GIDEP and ESCO alerts.

f. The parts list comparison tool must give automate resolution processes and communication with responsible parties

g. The parts list comparison tool must give enhance practices by documenting issues and resolutions, and other metrics

h. The parts list comparison tool must give receive daily updates for component status, PCN and EOL notices, GIDEP and ESCO counterfeit alerts, failure notices, last time buy and delivery dates, counterfeit alerts and reinstatement parts

i. The parts list comparison tool must give generate life cycle, supply chain and hazardous material health scores based on the years to end-of-life forecast, number of active suppliers, RoHS compliance, lead-free status and hazardous material attributes

j. The parts list comparison tool must give generate 2-4-8 year availability forecasts at the assembly and part level

k. The Electronic Component Parts Look Up tool and the BOM Manager tool must be able to access Fastener content to effectively select and manage a broader range of critical components in an integrated toolset. This Fasteners integration must allow users decision support to identify and source over 28 million standard fasteners and hardware.

1.1M Manufacturer based part numbers from 69 manufacturers,17

Fastener part types:

Bolts, bushings, inserts, key & key seats, knobs, nut plates, nuts, pins, pins springs, posts, rivets, screws, snaps, spacers, studs, washers, wires 28M Standards based part numbers:

AIA/NAS - Aerospace Industries Association / National Aerospace

Standards ASME – American Society of Mechanical Engineers BSI - British Standards Institute DLA – Defense Logistics Agency Includes Navy & Air Force Standards DIN - Deutsches Institut für Normung German Standards Organization SAE – Society of Automotive Engineers

l. Vendor must provide an Authorized Distributors add on that is integrated into the Electronic Component Parts Look Up tool which allows users the ability to procure components with a high degree of confidence in order to help prevent counterfeit incidents. This will help DLA Land and Maritime obtain electronic

Attachment 2 – Page 15 parts from the original manufacturer, their authorized dealers, or from trusted suppliers who obtain parts exclusively from the OEM or authorized dealer. This places the burden of proof squarely upon industry. This tool should help establish a secure supply chain to help avoid counterfeit parts by using an authorized distributor.

Attachment 2 – Page 16

APPENDIX A: LIST OF ACRONYMS

AA The Aluminum Association AAC Acquisition Advise Code ABMA The American Bearing Manufacturing Association ABS American Bureau of Shipping AC1 American Concrete Institute ADP Automated Data Processing AEL Allowance Equipage List AGA American Gas Association AGMA American Gas Manufacturers Association AIA/NAS Aerospace Industries Association AIAA American Institute of Aeronautics and Astronautics AIIM Association for Information + Image Management AIN Approval Item Name AMDF Army Master Data File AN Air Force Navy Aeronautical Drawing ANA Air Force Navy Aeronautical Bulletins AND Air Force Navy Aeronautical Design Standards ANS American Nuclear Society ANSI American National Standards Institute API American Petroleum Institute APL Allowance Parts List AQAP Allied Quality Assurance Publication AHRI (ARI) Air Conditioning Heating + Refrigeration Institute ASA Acoustical Society of America ASCII American Standard Code for Information Exchange ASHRE American Society of Heating and Refrigeration ASME American Society of Mechanical Engineers ASME BPVC ASME — Boiler Pressure and Vessel Code ASO Aviation Supply Office ASQ American Society for Quality ASSE American Society of Sanitary Engineering ASTM American Society for Testing and Materials ASSIST(FORMERLY DODISS) Acquisition Streamlining and Standardization Information System AWS American Welding Society AWWA American Water Works Association BH MA Builders Hardware Manufacturers Association BOCA Building Officials and Code Administration BSI British Standards Association CDNMCRL Canadian Master Cross Reference List CEA Consumer Electronics Association CECC (CD-ROM Access is permissible)

Attachment 2 – Page 17

CENELEC Electronics Components Committee CGA Compressed Gas Association CID Commercial Item Description CLAM DSCC functional areas: Commodities, Land, Aerospace, and Maritime COG Cognizance Code COR/CORT Contracting Officer Representative/ Contracting Officer Technical

Representative COTS Commercial Off The Shelf CSA CSA America — Gas Equipment Standards CTI Cooling Technology Institute DID Data Item Description DIN German Stds Deutsches Institute Normung DISC Defense Industrial Supply Center DLA Defense Logistics Agency DOD Department of Defense DODAAC Department of Defense Activity Address Codes DODAAF Department of Defense Activity Address File DSCC Defense Supply Center Columbus DSCR Defense Supply Center Richmond ECA Electronic Components, Assem and Materials EIA Electronics Industries Association EIC Engineering Item Code EPLS Excluded Parties List System RIG Federal Item Identification Guide FLIS Federal Logistics Information System FMVSS Federal Motor Vehicle Safety Standards FORD Ford Master Engineering Collection FSC Federal Supply Class FSCM Federal Supply Code for Manufacturers GM General Motors Standards GMW GM Worldwide Engineering Standards GSA General Services Administration HISTORICAL STANDARDS SERVICE — wfo aws, others ICEA Insulated Cable Engineers Association 1CP Inventory Control Point IEC International Electrotechnical Commission IEEE Institute of Electrical and Electronics Engineers IESNA Illuminating Engineering Society of North America IHS Information Handling Services ILS Inventory Locator Service INC Item Name Code IPC Association Connecting Electronics Industry ISA Instrumentation, Systems & Automation Society

Attachment 2 – Page 18

ISO International Organization for Standardization IT Information Technology IWS Integrated Work Stations J6C (J6) Information Operations Columbus JEDEC Solid State Technology Association LIN Line Item Number LIRSH List of Items Requiring Special Handling MCN Management Control Number MCRL Master Cross Reference List MIAPL Master Index of Allowable Parts List MOE Major Organizational Entity MRIL Master Repairable Item List MSC Military Sealift Command MSS Manufacturers Standardization Valve and Fittings Industry NACE National Association of Corrosion Engineers NAICS North American Industry Classification System NASA National Aeronautics and Space Administration NATO North Atlantic Treaty Organization NAVISTAR International Truck and Engine Corp NAVS UP Naval Supply NEMA National Electrical Manufacturers Association NFPA National Fire Protection Association NFTD National Forging Tooling Database NICN Navy Item Control Number NICP/CRF Navy Item control Point/Cross Reference File NIIN National Item Identification Number NISO National Information Standards Organization NMDF Navy Master Data File NSF National Sanitation Foundation NSN National Stock Number PDF Portable Document Format PIA- Parachute Industry Association PID Product Item Description PMA Parts Manufacturer Authority PPI Plastics Pipe Institute QML Qualified Manufacturers List QPL Qualified Products List RWMA Resistance Welding Manual — AWS SAE Society of Automotive Engineers SIC Standard Industrial Classification SMACNA Sheet Metal and Air Conditioning SMD Standardized Military Drawing SMIC Special Material Identification Code

Attachment 2 – Page 19

SNUD Stock Number User Directory SOS Source of Supply SPCC Ships Parts Control Center SRAN Stock Record Account Number SRVA Supplier Requirements Visibility Application SSPC Society for Protective Coatings STANAG Standardization Agreement TECHAMERICA (formally GEIA — Government Electronics and Information

Technology Association) TIA Telecommunications Industry UIC Unit Identification Code UL Underwriters Laboratory URL Universal Resource Locator WUC Work Unit Code

Attachment 2 – Page 20

APPENDIX B: DATABASE SYSTEM DESCRIPTIONS

AMDF: The Army Master Data File (AMDF) provides the most commonly used supply management data necessary to perform logistics functions.

The file is used to:

Verify Prescribed Load Lists, Authorized Stockage Lists, and Asset Balance Files Identify related National Stock Number (NSN)/Management Control Number (MCN) information.

Obtain information on interchangeability/substitutability and historical data to support the operations listed above Verify current pricing

APL/AEL: The Navy's General Distribution Allowance Parts List (APL) cross references part numbers, NSNs and CAGE codes to APLs. Obtained from the Navy Ships Parts Control Center (SPCC), this database shows top-down, bottom-up relationships between all parts in the system.

The database includes Sections A (FLSIP .25-APL and MODFLSIP-APL and .5 APL), B (electronic or MAPL) and C (AEL). The Allowance Equipage List (AEL) contains categories of durable materials that are required to support a ship and its crew personnel involved with safety, health, special clothing, maintenance, and repair.

CAGE Cross Reference: Cross references to the H4/H8 Commercial And Government Entity (CAGE) database. The CAGE database also includes manufacturer information from the CCR (Central Contractor Registry), D&B (Dun and Bradstreet).

Canadian MCRL: The CDNMCRL database provides access to vital information on 4 million items in the Canadian supply system.

Canadian Procurement History: This database provides Canadian procurement information.

D0431D043X: The Air Force Interchangeability and Substitutability Grouping List (D043/D043X) contains item information by Master National Stock Number and Related National Stock Number. It provides the Air Force with the functional and physical replacement items that are equivalent in performance, reliability, and maintainability. In addition, it contains information on items capable of being exchanged for another under specific conditions or applications.

D049: The Air Force Master Material Support Record (D049) is a database of maintenance data applicable to all end items managed by the Air Force Logistics Command. The D049 provides a

Attachment 2 – Page 21 breakdown of items contained within end items or weapons systems. The breakdown includes the complete range of parts, special tools, test equipment, and a few technical orders required to perform depot level repair on an item. This is an historical database and is no longer updated.

DoD I&S: The Department of Defense Interchangeable and Substitutable (DOD l&S) file contains a cross reference of both interchangeable and substitutable National Stock Numbers found in the Defense Integrated Data System (DIDS). This information has now been integrated into the FLIS.

DODAAF: The Department of Defense Activity Address File (DODAAF) provides the addresses of government activities and companies that do business with the government. Searches may be made by activity address code, city, country, name of activity or company, state, or ZIP code.

EPLS: The Excluded Parties List System provides you the ability to identify individuals or companies that have been excluded from receiving Federal contracts, certain subcontracts, and certain types of Federal financial and non-financial assistance and benefits.

Federal Agency Procurement History: This collection represents approximately 100 local and federal government agencies and is not traceable to NSNs. These are histories for maintenance, repair, research and development, architects, rentals, charters, ADP processing, equipment modifications, and other services not connected to items tracked in the Federal Supply Catalog. The contractor, date of award, amount of award, contract number, action dates, point of performance, and the contracting agency are all available in this database.

FLIS (formerly MCRL/ML-C): The FLIS Master Cross Reference List 1, 2, and 3 (MCRL) provides a cross-referenced list of National Stock Numbers, manufacturers' part numbers, and CAGE Codes supplemented with related data, including an alternate parts breakdown list. Information is available for more than 12 million items purchased within the Federal Supply System. Also contained in the FLIS is the ML-C (Management List- Consolidated), which provides pricing, stocking, and procurement information on all National Stock Numbers within the Federal Supply System.

GSA Procurement History: The source for this data is the General Services Administration (GSA). It contains procurement history for those items purchased off of GSA contracts. Information includes GSA schedule, CEC number, contractor name and address, NSNs, performance location, and contract dates.

H2: The Federal Supply Classifications (H2) is an index that categorizes items of supply in the Federal Catalog System into groups and then subdivides the groups into classes according to physical or performance characteristics. The primary application of the FSC is in the National Stock Number (NSN). The NSN for an item of supply consists of the applicable four-digit FSC number plus the nine-digit National Item Identification Number (MIN).

Attachment 2 – Page 22

H41H8 CAGE: The H4/H8 Commercial And Government Entity (CAGE) code provides listings of firms that manufacture or distribute items procured by the U.S. Government or by other NATO countries. This database was created as a result of a merge between the former H4 and H8 Handbooks.

The CAGE Code was formerly referred to as the FSCM (Federal Supply Code for Manufacturers).

H6: The H6 (Federal Item Name Directory) contains information on all item names and definitions in the Federal Supply System, along with associated Federal Supply Class (FSCs), Approved Item Names (AINs), non-approved item names, Federal Item Identification Guides (FlIGs), and Item Name Codes (INCs).

Historical NATO Stock Numbers: This collection of historical records can be searched by NATO NIIN, CAGE code, part number, and keyword.

LIRSH: The List of Items Requiring Special Handling (LIRSH) includes codes that:

Identify item demilitarization procedures Identify item shelf life and shelf life actions Identify whether or not the item should be specially secured List any hazardous materials within the item

MIAPL: The Navy's Master Index of Allowable Parts List (MIAPL) is a comprehensive cross-reference of data used to support the Navy logistics arena. Obtained from the Navy Ships Parts Control Center (SPCC), the MIAPL provides information on items of supply that are on the Allowance Parts List (APL). Data in the MIAPL include equipment component identification, technical manual cross-references, equipment specifications, nomenclature, and several other convenient cross-references. Since the APL and AEL are now updated more frequently, the Navy has stopped providing updates to the MIAPL

Mil Spec/Standard/Drawing Number: The Mil Spec/Standard/Drawing number information that is included on the PID/SPEC tab is received from the Major DLA centers: DLA Land and Maritime, DLA Troop Support, And DLA Aviation. A new search key has been added to the FLIS labeled P1D/SPEC. This search key will allow you to enter a Military Specification, Standard or Drawing number and retrieve those NSNs that have that value referenced in the Specification/Standard section.

MOE Rules: Major Organizational Entity (MOE) Rules represent the collection of specific purchase rules that apply to the management of an item or group of items of supply.

MRIL: The Master Repairable Item List (MRIL) provides users, shippers, and receivers of Navy-managed repairable components with current authorized disposition instructions for Not-Ready- For-Issue (NRFI) repairable assets. It is the primary Navy source document detailing where to ship a repairable item when it is broken. The Fleet Material Support Office prepares the data. It covers disposition instructions for items managed by both the Aviation Supply Office (ASO) and

Attachment 2 – Page 23 the Ships Parts Control Center (SPCC).

MSC Procurement History: The Military Sealift. Command (MSC) Procurement History database contains NSNs, item Names, UIC numbers, Hull numbers, part numbers, CAGE codes and status, quantity, unit price, company name, city, and state. You can search the MSC database by NIIN, UIC, HULL, Part, CAGE, and Company.

NFTD: The National Forging Tooling Database (NFTD) is designed specifically to help organizations search, identify, locate and procure items which require forged tools. Over 200,000 tooling identification numbers are in the NFTD and are directly linked by part number and NSN within the logistics database.

NICN-to-NIIN: The NICN-to-NIIN database provides a cross reference from the Navy Item Control Number (NICN) to a National Item Identification Number (NIIN). The file is essential for researching actual NIINs that were once temporary stock numbers and identifying critical management data for these items.

NICP/CRF: The Navy Item Control Point/Cross Reference File (NICP/CRF) references both cataloged and non-cataloged items. Available data include part numbers, CAGE codes, NIINs, and Temporary Navy Item Control Numbers.

NMDF: The Navy Master Data File (NMDF), also defined as the Management List- Navy, is the primary source for relating National Stock Number (NSN) management data. It is a Navy-tailored file published in National Item Identification Number (NIIN) sequence containing key data such as price, COG, SMIC, SOS, AAC, and item names.

P2002: NAVSUP Pub 2002 is an index to the Navy Stock List of Publications and Forms. The P2002 contains current cognizance publications and forms. Key data elements include stock number, form or publication number, title, revision date, and material control codes. The source publisher no longer offers commercial distribution of this data; therefore, it is no longer updated.

P2300: The P2300 database contains information on all Aviation Repairable Items at the Depot, Intermediate, and Organizational repair levels. Report data used primarily for research and part configuration includes SM&R codes, alternate NIINs, packaging data, and next higher assemblies.

P2310: The P2310 database contains all Aviation Consumable Items, all COG codes, ASO managed IR items, nine COG DLA items, and other service items. Data include nomenclature, repairable items/model, and application to the next higher assembly.

P2330: The P2330 database contains the Family Repairable Items and identifies which items are

Attachment 2 – Page 24 heads of family for interchangeable parts. Data includes Special Material Identification Code, Material Control Code, family related indicator, family group code, and family relationship

PMA: The Parts Manufacturer Authority (PMA) database is maintained by the FAA and contains information regarding approved alternate manufacturers for aviation specific equipment. This database lists the manufacturer's name, address, part number, description and the model number for the aircraft(s) the part is used on.

Procurement History: The Procurement History database contains data from the Army, Navy, Marine Corps, Air Force, Coast Guard, and Defense Logistics Agency (DLA) and other locations, providing both government and industry easy access to the history of this competitive marketplace. Items can be examined down to the individual National Item Identification Number (NIIN), date of the award, contract line item number, lot quantity size, total dollars expended, and cost per individual item. The files include full history from the data sources and provide easy access to information on the source from which the government purchased the item, what was paid, and how often the item was purchased.

Product Item Description (PID): This data includes an assortment of technical characteristic information as well as additional approved manufacturers/part numbers, drawing numbers, and military specification references; Over 4 million NllNs in the FLIS database have PID information associated with their records. The sources for this descriptive information are the four hardware DLA centers: Defense Supply Center Richmond (DSCR), Defense Supply Center Columbus (DSCC), and Defense Industrial Supply Center (DISC).

QPUQML: The Qualified Products List (QPL) / Qualified Manufacturers List (QML) database includes the full text of all current U.S. Military and Federal QPLs; more than 1,200 documents covering over 1.5 million pretested products. Information on Standard Military Drawing (SMD) part numbers is also included. It gives users the ability to search by vendor or military part number as well as several other index keys. The database can be used to cross-reference the MCRL data by part number.

SB700-20: The Reportable Items Selected for Authorization (SB700-20) supply bulletin contains all active Line Item Numbers (LINs).