Catalog Update (Colloquial Name, Catalog TAMCN, IDN)

Warehouse

USMC: CSP

Done

Submitted: 6 Aug 2014

Description
DPAS overwrites the TAMCN Description and Item Description for NSN items. As a result, the CSP Program has all NSN's flagged as Part Numbers due to the fact they have manipulated/changed Item Description names to better match what the item actually is. This is preventing automatic catalog updates, and creates false reports in the system. DPAS was designed around size category being driven by TAMCN. Our system catalog does not provide a TAMCN for all items, and the way we asked DPAS to design that process was incorrect. It is very important to the longevity and sustainment of our program. Currently, the only way we can get the system to work is to set all stock numbers to part numbers.

Recommended
For the CSP Enterprise Program, MARFORLOGCOM is requesting to add the following fields to the DPAS Stock Number Table:

• Colloquial Name:
  The CSP Program has all NSN's flagged as Part Numbers due to the fact they have manipulated/changed Item Description names to better match what the item actually is. With a 'Colloquial Name' field the CSP Enterprise program could use this field for the Item Description and then allow the I-001 interface from MARCORLOGCOM's Tech Data Management System update daily. This will better support audibility once the NSN's have their flag changed from Part Number to NSN managed items. Should this change be accepted, please update Item Description to be a non-editable field within the system for NSN coming from the Agency Catalog. This field must perpetuate through all of the reports and grids options (processes) that contain asset information within the system.
• Catalog TAMCN:
  Another reason that all NSN’s were set to part numbers is because our agency catalog does not have a TAMCN for all items. As a result, the interface for our agency catalog overwrites the TAMCN, when a TAMCN is needed for the individual issue process within the system. This field will be used to represent the Official TAMCN assigned from the Agency Catalog for all NSN’s within the system. This field must perpetuate through all of the reports and grids options (processes) that contain asset information within the system.
• ID Number:
  ID Number is a unique identifier of different variants of items under a TAMCN. It is requested to add this field to the DPAS Stock Number Table and all associated reports and grid options (processes) in the system to support user identification of the different variants of an asset.

Applying these two changes to the system will better support audibility, as it will allow the CSP to change the NSN’s they have flagged as Part Number Managed to NSN managed items.

Mission Critical
This is a policy mandated system change, that will allow the CSP data to be reported IAW Marine Corps Cataloging Policy.

Benefits
Improves accuracy and accountability with respect to catalog data updates.

Users
This field could be used for all Agencies.

Completed - Release 3.0 - 15 May 2015