Navy Databases

The Navy databases include:

• APL/AEL - a Navy General Distribution APL Allowance Parts List - the Navy's general distribution list. database that cross-references part numbers, NSNs and CAGE Commercial Activity Government Entity - listings of firms that manufacture or distribute items procured by the U.S. Government; also known as the Federal Supply Code for Manufacturers. The following are the types of activities and documents that are assigned CAGE Codes: Manufacturers; Vendors; Government agencies who manufacture an item of supply; Government agencies that control the development of government specifications and/or standards; Government specifications or standards when no single government source can be identified; NATO manufacturers. codes to APLs. The AEL Allowance Equipment List - the Navy's list for Trident submarines. Section C data contains categories of durable materials required to support a ship and its crew personnel involved with safety, health, special clothing, maintenance, and repair.
• MRIL - Master Reparable Item List database that provides current authorized disposition instructions for NRFI Not Ready For Issue. reparable items—primary Navy source document for users, shippers, and receivers of managed reparable components.
• NICN to NIIN - used to search the NICN Navy Item Control Number - temporary number assigned by the Navy to identify parts in the Navy supply system before they are cataloged by the Defense Logistics Services Center (DLSC) and given a complete National Stock Number (NSN). Some items are permanently identified by the NICN because of the nature of the items.-PCSN for the assigned NSN National Stock Number - a 13-digit number assigned to a part under the Federal Cataloging Program. The first four digits of the NSN are the Federal Supply Class (FSC) of the part. The last nine digits are the National Item Identification Number (NIIN) of the part./NIIN National Item Identification Number - nine-digit number assigned to a part under the Federal Cataloging Program. It is the last nine digits of the National Stock Number..
• NICP CRF - references both cataloged and non-cataloged items. Available data includes part numbers, CAGE Commercial Activity Government Entity - listings of firms that manufacture or distribute items procured by the U.S. Government; also known as the Federal Supply Code for Manufacturers. The following are the types of activities and documents that are assigned CAGE Codes: Manufacturers; Vendors; Government agencies who manufacture an item of supply; Government agencies that control the development of government specifications and/or standards; Government specifications or standards when no single government source can be identified; NATO manufacturers. codes, NIINs, and temporary Navy Item Control a five-digit number consisting of one alpha and four numerics used to relate component items to the end item to create a complete Master Material Support Record (MMSR) master record for a specific depot level repair item in the D049 database. Also known as CN NO or CTL NO. Numbers.
• NMDF - also defined as the Management List-Navy, is the primary source for relating NSN National Stock Number - a 13-digit number assigned to a part under the Federal Cataloging Program. The first four digits of the NSN are the Federal Supply Class (FSC) of the part. The last nine digits are the National Item Identification Number (NIIN) of the part. management data. It is a Navy-tailored file published in NIIN National Item Identification Number - nine-digit number assigned to a part under the Federal Cataloging Program. It is the last nine digits of the National Stock Number. sequence containing key data such as price, COG Cognizance Symbol - a two-position prefix to Federal Stock Numbers to identify and designate the inventory control point, office, or agency that exercises supply management within the Name. The first position of the COG is numeric and identifies the storage account. The second position is alphabetic and identifies the combined technical and inventory managers having jurisdiction over the item. The inventory manager is that inventory control point, office, or agency that exercises supply demand control over a given segment of Navy interest material., SMIC Special Material Identification Code - indicates unique application, reporting segments specialized distribution, etc., for logistics management purposes. Codes must be authorized by NAVSUP/SMR (Source Maintenance Recoverability Code)., SOS Source of Supply - code identifies the activity to receive requisitions for an item. This is the SOS is the Routing Identifier Code (RIC) that is listed in DOD 4140.17M, Supplement 1, MILSTRIP regulation. SOS G-O is shown to identify the GSA regional office, S-S to identify the subsistence purchasing activity. When G-O or S-S is used, place the correct character in the blank space. This should be done before updating on-site AMDF or other files. Refer to DOD 4041.17M for the correct character., AAC Activity Address Code - six-position code assigned to identify specific units, activities or organizations authorized to direct, ship or receive material, documentation or billing. Also Acquisition Advise Code - indicates how (as distinguished from where), and under what restrictions, an item is acquired., and item names.
• P2002 - an index to the Navy Stock List of Publications and Forms.
• P2300/10/30 (NHA) - contains P2300 - Information on all Aviation Repairable Items at the Depot, Intermediate, and Organizational repair levels; P2310 - All Aviation Consumable Items, all COG Cognizance Symbol - a two-position prefix to Federal Stock Numbers to identify and designate the inventory control point, office, or agency that exercises supply management within the Name. The first position of the COG is numeric and identifies the storage account. The second position is alphabetic and identifies the combined technical and inventory managers having jurisdiction over the item. The inventory manager is that inventory control point, office, or agency that exercises supply demand control over a given segment of Navy interest material. codes, ASO managed IR items, nine COG Cognizance Symbol - a two-position prefix to Federal Stock Numbers to identify and designate the inventory control point, office, or agency that exercises supply management within the Name. The first position of the COG is numeric and identifies the storage account. The second position is alphabetic and identifies the combined technical and inventory managers having jurisdiction over the item. The inventory manager is that inventory control point, office, or agency that exercises supply demand control over a given segment of Navy interest material. DLA Defense Logistics Agency - provides the Army, Navy, Air Force, Marine Corps, other federal agencies, and joint and allied forces with a variety of logistics, acquisition and technical services. These include processing requisitions, distribution of parts and supplies, DIIBBS information (DLA International Bid Board System), and Document Services that provide solutions for the conversion, retrieval, output, and distribution of digital documents. items, and other service items; P2330 - Family A P2300 file that specifies whether the item is the head of the family or a component. Repairable Items, Identifies which items are heads of family for interchangeable parts.
• SPMIG - includes Standard PMS (Planned Maintenance Systems) Materials Identification Guide information that pertains to surface ships and submarines during shipyard, overhaul, and Intermediate Maintenance activity (IMA Intermediate Maintenance Activity.) availabilities.
• WUC - tracks parts associated with Naval aircraft that has been repaired. Work Unit Codes are used to track maintenance actions on aircraft systems.
• WUC (S3 Aircraft) - an extension of the WUC Work Unit Code - a one, three, five, or seven character number or alphanumeric code that normally identifies the system, sub-system, set, major component, repairable subassembly, or part of an end item being worked on. database which tracks parts associated with Naval aircraft that has been repaired.