CrossWalk™

Finds errors and omissions between the parts manual and LSAR-036, generating updates.

Description

CrossWalk™ is the natural evolution in the LHG QA process that, like Validator™ and DataSync™, connects the dots and identifies discrepancies between two logistics management data sets.  CrossWalk™ is designed to detect the differences between the Logistics Support Analysis Record (LSAR)-036 and Repair Part and Special Tool List (RPSTL) parts manual.

CrossWalk™ is designed to allow the user to choose which of the identified differences stay and which ones don’t.  The user has the option to implement each approved change manually to the selected data set or to use an automated process to apply the changes.

The output presented to the user is grouped into two categories; gaps and differences.  A gap is information present in only one of the data sets. For example, item X is only present in the 036 data.  A difference is information present in both data sets that do not match. For example, quantity, Source, Maintenance and Recoverability (SMR) codes do not match.

This output is also useful to assess the level of effort necessary to bring the data sets in line or update them to current configurations.

Performance

CrossWalk™ displays the results of each data set in a side-by-side, easy to understand grid.  Users are allowed to filter on:

  • Figures
  • Items
  • Quantities
  • Family Structures
  • Functional Groupings
  • Descriptions
  • National Stock Numbers (NSNs)
  • SMR Codes

The output presented to the user can be exported to an Excel file for offline review.

CrossWalk™ is in response to a customer challenge to update their RPSTL after a year of 036 changes.  They needed to know what changed; where it changed, and how to properly action each change.  Over the year, more than 52,000 changes to the 036 occurred that impacted the current RPSTL.  Included were small changes such as supplier, SMR codes and quantities, and significant changes like the breakdown and repair of assemblies and major components.

While using the LHG tools to work this effort for our client, we found cases where the RPSTL data was more accurate than the 036 data regarding NSNs, nomenclature, and breakdown of components. Using this information, and the CrossWalk™ side-by-side comparison view format, allowed us to focus the RPSTL update activities on only the change data that needed updating.  Our tools significantly reduced the required labor and saved our client money.  Further, our tools improved quality by eliminating incorrect changes.

Each LHG tool was born from a customer challenge or obstacle.  Each tool is proven to reduce costs and development time, improve quality, and discover the unknown.