RFP_Attachment_4.J_-_DataReferenceModel.xlsx

Cover Sheet

Data Reference Model Vocab Spreadsheet

Developed By:

Item Master Capability InitiativeCommunity of Interest

Version 3.1

Redlines: 8 Aug 2018, v2.2, 13 Nov 2018, v3.1

Release to AF BMA Data Management Coordination Panel:

Distribution A. Approved For Public Release

&F

&A &P of &N

Change Log

1. Legend for AF Item Record Col A, B

2. Warranty Lines 10,11 - deconflict

3. Context for Fed Catalog Updates/Responses

4. ADS typo on Product Structure (0 -PLM)

5. Rename Proposed ADS Tab - list source systems Col A, F

6. ADS Attribute Typos - Customer/Vendor

7. SME updates to provisioning attributes - definition adds

Blue highlights - additions/changes Red strike through - deletions Adjudicating IM Date Reference Model (DRM) Community of Interest (COI) Panel comments. V2.2, Item Master DRM Redlines delivered 8 Aug 2018 28-Sep-18 2nd adjudication of FM/A1 comments. In response to:

1. Item Master Data Model CRM_Consolidated IMLCI Responses_6 Aug 2018_28 Sept 2018 IMLCI Revisions V3.0, Item Master DRM, 28 Sept 2018

13-Nov-18 Revision to ADS Indicators In response to:

1. Item Master Data Model CRM_Consolidated IMLCI Responses_6 Aug 2018_28 Sept 2018 IMLCI Revisions 5 Nov 2018 followup telecon V3.1, Item Master DRM, 13 Nov 2018

&F

&A &P of &N

Information Asset List

&F

&A &P of &N

Data Elements - Master

1 -Suitable for competitive acquisition. (See Notes 1 and 2.)

2 - Suitable for competitive acquisition for the first. time. (See Notes 1 and 2.)

3 - Acquire directly from the actual manufacturer, whether or not the prime contractor is the actual manufacturer.

4 - Acquire, for the first time, directly from the actual manufacturer rather than the prime contractor who is not the actual manufacturer.

QD QUANTITY DECREASED – When the quantity on order is being decreased.

IR - INTERIM RELEASE DISAPPROVED – Item and total quantity interim released by Contractor are disapproved.

Shipping Address Bill-To Address

C - Shipment is a consolidation, but does not exceed 84 inches in any dimension.

D - Shipment is a consolidation and exceeds 84 inches in one or more dimensions.

Z - Shipment is not a consolidation, but does exceed 84 inches in one or more dimensions

Used On - For example, the carburetor cited is used on a gasoline engine

Used when there is a requirement for an item for which no NSN is assigned 2- Adoption of Non-AF Used NSN Used when there is a requirement for an item that has been assigned an NSN, but the AF is not a recorded user.

3 -Disposal or Condemnation Used for a request to change an item to disposal or condemned status.

4 -FSC, Item Name, Type II or Part Number Change Used when the base requests review and change to FSC, Item Name, Item Identification/characteristics, or Part Number.

5 - NSN CMD Review (except ERRC code) Used when base personnel feel some management data element(s) has been assigned in error or change is required.

6 -Reinstate a Canceled or Disposal NSN Used when there is a requirement for an item that is canceled or in disposal status.

7 -Reserved 8 - Adoption Of Non-AF Used NSN Which Has Been Substituted For A Valid AF Used NSN This reason code will be used to request AF be added as a user when a requisitioned item has been substituted with a Non-AF used NSN.

9 - ERRC code

USAF

DOD/Government Service/Agencies Foreign Military Sales Local Unit (USAF Units or Tenants ordering through local base supply)

G - Service Company J - Manufacturer K - Regular Dealer/Distributor L - Sales Office N - Not Coded

B - 501 to 750 employees C - 751 to 1000 employees D - 1001 to 1500 employees E - Over 1500 employees N -Not Available

E - North Atlantic Treaty Organization (NATO) or Other Foreign Organizations or Foreign Codification Bureaus Manufacturers F -Non-Manufacturers (U.S./NATO or Other Foreign Codification Bureaus) CAGE Type of Business Data Element A code that defines the disadvantage status of a business. Code Alphabetic H - Approved by Small Business Administration (SBA) for Section 8 Program.

I - Other Disadvantaged small business firm.

N - Not a disadvantaged small business firm.

CAGE Woman Owned Business Data Element A code that denotes whether a business is woman owned or not. Indicator Alphabetic Y - woman-owned business N - not woman-owned business Cancellation Reason Code Data Element The reason the transaction is being canceled. Code Alphabetic 1A U (Cancel Use) D (Cancel Duplicate) I (Cancel Invalid)

Z - Special requirements - See specific instructions or drawings provided.

0 - No requirement

Condition 2 - The item is not currently managed by the receiving integrated material manager (IMM) Condition 3 - submitter is requesting support for an item without an NSN and being identified with the IMC process to the Integrated materiel manager for management including cataloging and supply support.

B-Construction D-Architect and Engineer (AAE)

A-Recommended for Breakout B-Not Recommended for Breakout-Safety C-Not Recommended for Breakout-Warranty D-Not Recommended for Breakout-Unstable Design E-Not Recommended for Breakout-Value Added F-Not Recommended for Breakout-Other/Combination The applicable codes for the second position are as follows:

B -Source(s) are specified on "Source Control," "Altered Item," or "Selected Item" drawings/documents. (The contractor shall furnish a list of the sources with this code as additional REFNOs and CAGECs).

C- Requires engineering source approval by the design control activity in order to maintain the quality of the part. An alternate source must qualify in accordance with the design control activity's procedures, as approved by the cognizant Government engineering activity.

G There are no technical restrictions to competition.

K- Produced from class 1A castings (e.g., class 1 of MIL-STD- 2175) and similar type forgings. The process of developing and proving the acceptability of high-integrity casting and forgings requires repetitive performance by a controlled source. Each casting or forging must be produced along identical lines to those which resulted in initial acceptability of the part. The contractor shall furnish a list of known sources for obtaining casting/forgings with this code.

M- Master or coordinated tooling is required to produce this part. This tooling is not owned by the Government or, where owned, cannot be made available to other sources. The contractor shall furnish a list of the firms possessing the master or coordinated tooling with this code.

N-Requires special test/inspection facilities to determine and maintain ultraprecision quality for function or system integrity. Substantiation and inspection of the precision or quality cannot be accomplished without such specialized test or inspection facilities. Other sources in industry do not possess, nor would it be economically feasible for them to acquire facilities. The contractor shall furnish a list of the required facilities and their locations with this code.

P- The rights to use the data needed to purchase this part from additional sources are not owned by the Government and cannot be purchased.

V- A high reliability part under a formal reliability program. Probability of failure would be unacceptable from the standpoint of safety of that personnel/equipment. The cognizant engineering activity has determined that data to define and control reliability limits cannot be obtained, nor is it possible to draft adequate specifications for this purpose. Continued control by the existing source is necessary to ensure acceptable reliability. (The contractor shall identify the existing source with this code as additional numbers and CAGECs.)

Y- The design of this part is unstable. Engineering, manufacturing, or performance characteristics indicate that the required design objectives have not been achieved. Major changes are contemplated because the part has a low process yield or has demonstrated marginal performance during tests or service use. These changes will render the present part obsolete and unusable in its present configuration. Limited acquisition from the present source is anticipated pending configuration changes. The contractor shall identify the existing source with this code as a reference/additional REFNO and CAGEC.

JLC 19 - PICA/SICA Management Level Change and/or reassignment Request - JLC 47 - DOD I&S Family Collaboration Request - I&S collaboration between the AF and other DOD I&S activities AFMC Form 133, Interchangeability and Substitutability Program - I&S collaboration between AF activities is accomplished by the ES Logistics Reassignment Cord Request Type Data Element The type of request to be coordinated. Code Alphanumeric PICA or SICA Management Level Change or Reassignment Request (JLC Form 19) Nonconsumable Item Materiel Support Request (JLC Form 17)

6-DELETE RECOVERABLE REPORTABLE - CODE 6 IS SUBMITTED BY THE CRITICAL ITEM MONITOR (CIM) AND REPLACES CODE 7 WHEN A RECOVERABLE ITEM IS NO LONGER CRITICAL.

7-RECOVERABLE REPORTABLE - CRITICAL.

BLNK - NOT APPLICABLE.

E-DELETE EOQ (CODE 5) FROM CRITICAL

Critical Safety Item (CSI) Flag Data Element A indicator identifying an item whose failure could result in the loss or substantial damage of the air vehicle or weapon system and serious injury or death to personnel. Indicator Alphabetic N INDICATES THE ITEM IS NOT A CRITICAL SAFETY ITEM.

Y INDICATES THE ITEM IS A CRITICAL SAFETY ITEM.

Other Services Other DoD Agencies Other Gov't Agencies Contractor

Blank

B REQUIRED, NOT RECEIVED, PROVISIONS OMITTED.

C REQUIRED, NOT RECEIVED, PRICE EXCESSIVE.

D REQUIRED, NOT RECEIVED, CONTRACTOR DEFAULTED.

E REQUIRED, NOT RECEIVED, SUBCONTRACTOR REFUSED.

F REQUIRED, NOT RECEIVED, FURNISHED PREVIOUSLY.

N NOT REQUIRED.

P REQUIRED, NOT RECEIVED, NOT CODED F OR X.

R REQUIRED AND SUBMITTED.

X OTHER, JUSTIFICATION ON OTHER PAPER

Code Alphabetic 1A R Drawing required and submitted N Drawing not required P Drawing required but not received and not coded A through F or X AFMC Form 784 has been submitted.

B Represents items with ESD sensitivity.

C Represents items with EMI sensitivity.

D Represents items with both ESD and EMI sensitivity.

2 - An item assigned EMC 1 in the cataloging system for which an Air Force base desires visibility for local use. SBSS accounting will be maintained but will not be reported to the USAF Equipment Data Bank.

3 - An item which requires SBSS accounting and reporting to the USAF Equipment Data Bank but does not justify transaction reporting. Overlay type reporting to the USAF Equipment Data Bank is required.

4 - An item of such logistics significance that transaction reporting to the Equipment Data Bank is required.

5 - An item requiring EMC 4 accounting/reporting except the individual assets will be identified by a serial or registration number.

3 - Failure of this part will not render the end item inoperable.

5 - Item does not qualify for the assignment of code 1 but is needed for personnel safety.

6 - Item does not qualify for the assignment of code 1 but is needed for legal, climatic, or other requirements peculiar to the planned operational environment of the end item.

7 - Item does not qualify for the assignment of code 1 but is needed to prevent impairment of, or the temporary reduction of, operational effectiveness of the end item.