Ownership is Everything: The Data Integrous System of Record

data integrity supply chain

Our actions and decisions are only as good as the data we use to rule them. That being true, when designing complicated systems, ensure the integrity of the data set involved becomes enormously important. Obviously, the data that resides in a system should be accurate. However, it also needs to have integrity, which means consistent and not unnecessarily redundant.

A good data set is invaluable. Done well, it puts all of the data elements in one place, making it easy to share, analyze, extrapolate, and use.  Which system owns the data is potentially even more important.  If you want to fundamentally alter the data based on business rule or a business logic, then it should be done in the system that owns the data—so it’s critical to track the lifecycle of the system and to refer users to the primary system for specific data.

For example, sales order (SO) information is always owned by an enterprise resource planning (ERP) system, since that is where all the aspects of the order are handled and tracked throughout the lifecycle of the sale. That same sales order might be downloaded to a warehouse management system (WMS) for fulfillment. The WMS will use the order information to fulfill the order, to optimize the fulfillment process, for packaging instructions, and more. However, this system should only allow information lookup—while changes to the data should be done in the ERP.

Let me offer a real-world example. When I was working at multinational computer company, we sold computers all over the world. We had a complicated challenge of streamlining the system integrations pertaining to shipment data from various manufacturers worldwide. These suppliers would share advance shipment notifications (ASNs) through electronic data interchange (EDI).  About 856 transactions in all, these provided all shipment information that allowed the recipient to be ready to receive the product. Our goal was to create a single consistent architecture so that the Global Supply Chain Systems Group could support it.

The company, which was 30 years old, had gone through multiple acquisitions and had teams all over the globe.  Any change had the potential to impact a lot of people.

So how do you skin this cat? So how do you streamline all these system integrations in a smart way that makes the system manageable?  We ended up leveraging GT Nexus, a global supply chain management platform.  In its infancy, the company created a system that provided visibility to ocean shipment data including current status, origin, destination, ETA, path, modal etc. GT Nexus began accumulating this information, eventually it became the repository for this information worldwide. It was so easy to login to the system and get all the information about the shipment as long as you had a shipment number. By integrating into the system, GT Nexus became the system of record for all the shipment data until we completed our streamlining.

It is very important to have a system that owns the life-cycle of the data set to create a single source of truth.  More important, maintaining a single, simple architecture eases integration into other systems

What are some of the data integrity and system of record challenges you have run into, while optimizing, integrating, streamlining, maintaining different supply chain systems in your organization? How did you overcome those challenges? Let us know your thoughts in the comments section below.

Author:
Puga Sankara
About:
Puga Sankara is the Founder, CEO of Smart Gladiator LLC. Smart Gladiator designs, builds, and delivers market-leading mobile technology for retailers, distributors, and 3PL service providers. So far, Smart Gladiator LoadProof has been used to ship, receive, and scan more than 100 million boxes. SG LoadProof is a patent pending Centralized Enterprise Photo/Video Document System on Cloud for Supply Chain. SG LP is built on the fact that photos & videos are vital docs as important as POs/SOs/Legal Contracts/Fulfillment Orders that reside in ERP/WMS/TMS systems, that serve as compelling, conclusive, unequivocal proof of crucial, critical, vital operations executed in Supply Chain within/across orgs when fulfilling customer orders as well as meeting contractual obligations between orgs as merchandise is transferred between different parties that partake in Supply Chain functions & operations. And these photos/videos data should not be stored in someone’s Smartphone or Email Inbox or in their personal/work Computer, but should be stored in a Centralized Enterprise system, where such data can be pushed into super-fast, stored securely, accessible to all stake holders (CFO/Sales Reps/Customer Support/AR/AP) in an org, as well as facilitates super-fast retrieval/sharing. LP is an Enterprise System of record for Photo/Video docs & is as important as an ERP which is an enterprise system of record for POs, SOs, Legal Contracts between parties etc. that have huge legal ramifications, also as important as a WMS (Warehouse Management System) that hold indispensable shipment & fulfillment data on orders. Like how Instagram, Facebook, Snapchat etc. have evolved into social media platforms/systems that enable individuals to showcase their beauty/pretty clothes/lovely cosmetics/hep coolness etc., LoadProof is an Enterprise system that holds similar photos/videos, but for a different reason, not for show off, but to serve as compelling, conclusive, unequivocal & indisputable system of record and proof that can be presented even in the court of law, when there is a dispute between parties while they execute many facets of the Supply Chain functions & operations. SG LoadProof is also an Enterprise System of Record for Photos, videos and any other digital documents for your Supply Chain Network. A system of record (SOR) or source system of record (SSoR) is a data management term for an information storage system (commonly implemented on a computer system running a database management system) that is the authoritative data source for a given data element or piece of information. The need to identify systems of record can become acute in organizations where management information systems have been built by taking output data from multiple source systems, re-processing this data, and then re-presenting the result for new business use. In these cases, multiple information systems may disagree about the same piece of information. These disagreements may stem from semantic differences, differences in opinion, use of different sources, and differences in the timing of the extract, transform, and load processes that create the data they report against, or may simply be the result of bugs. The integrity and validity of any data set is open to question when there is no traceable connection to a good source, such as a known System of Record. Where the integrity of the data is vital, if there is an agreed system of record, the data element must either be linked to, or extracted directly from it. In other cases, the provenance and estimated data quality should be documented. The “system of record” approach is a good fit for environments where both: 1. there is a single authority over all data consumers, and 2. all consumers have similar needs Here, LoadProof is the System of Record for pictures and videos for all the entities in Supply chain who uses pictures and videos to track using any Supply Chain System infrastructure. 1. LoadProof provides accurate, thorough, complete, and latest information in pictures and videos related to any entity in the Supply chain that is tracked. 2. LoadProof is the single authority on pictures and videos related to any entity in the Supply Chain that is tracked 3. LoadProof doesn’t let any external system to copy the records being stored in it, which eliminates the data being duplicated in multiple places to preserve the data integrity and credibility. 4. LoadProof has a secured login procedure which lets only users with select level access to view the data and modify the records which helps in maintaining LoadProof is becoming the Industry Standard System for Photo & Video Docs for Supply Chain Smart Gladiator is located in ATDC - Advanced Tech Dev Center (tech Incubator) in Georgia Institute of Tech. Click for a demo - https://loadproof.com/apply Puga is a supply chain technology professional with more than 25 years of experience in deploying capabilities in the logistics and supply chain domain. His prior roles involved managing complicated mission-critical programs driving revenue numbers, rolling out a multitude of capabilities involving more than a dozen systems, and managing a team of 30 to 50 personnel across multiple disciplines and departments in large corporations such as Hewlett Packard. He has deployed WMS for more than 30 distribution centers in his role as a senior manager with Manhattan Associates. He has also performed process analysis walk-throughs for more than 50 distribution centers for WMS process design and performance analysis review, optimizing processes for better productivity and visibility through the supply chain. Size of these DCs varied from 150,000 to 1.2 million SQFT. Puga Sankara has an MBA from Georgia Tech. He can be reached at puga@smartgladiator.com or visit the company at www.smartgladiator.com. Also follow him at www.pugasankara.com. [Read More]
More articles by: Puga Sankara

215 Comments

  1. Achat mГ©dicament en ligne fiable [url=https://pharmafst.com/#]pharmacie en ligne pas cher[/url] п»їpharmacie en ligne france pharmafst.shop

  2. Tadalafil sans ordonnance en ligne [url=https://tadalmed.shop/#]Tadalafil achat en ligne[/url] Achat Cialis en ligne fiable tadalmed.com

  3. pharmacies en ligne certifiГ©es [url=https://pharmafst.shop/#]pharmacie en ligne sans ordonnance[/url] pharmacies en ligne certifiГ©es pharmafst.shop

  4. Kamagra pharmacie en ligne [url=http://kamagraprix.com/#]kamagra livraison 24h[/url] Kamagra Commander maintenant

  5. pharmacie en ligne france livraison belgique [url=http://pharmafst.com/#]Meilleure pharmacie en ligne[/url] Pharmacie sans ordonnance pharmafst.shop

  6. Cialis generique prix [url=https://tadalmed.shop/#]Cialis en ligne[/url] Tadalafil achat en ligne tadalmed.com

  7. pharmacie en ligne france livraison belgique [url=https://pharmafst.shop/#]Pharmacie en ligne France[/url] Pharmacie en ligne livraison Europe pharmafst.shop

  8. reputable canadian online pharmacies [url=http://expressrxcanada.com/#]Canadian pharmacy shipping to USA[/url] canadian online pharmacy

  9. vavada вход [url=https://vavadavhod.tech/#]vavada casino[/url] вавада казино

  10. вавада казино [url=https://vavadavhod.tech/#]vavada вход[/url] вавада зеркало

  11. pin up вход [url=https://pinuprus.pro/#]пин ап зеркало[/url] пин ап зеркало

  12. вавада [url=http://vavadavhod.tech/#]vavada[/url] вавада официальный сайт

  13. order Cialis online no prescription [url=http://zipgenericmd.com/#]order Cialis online no prescription[/url] online Cialis pharmacy

  14. modafinil legality [url=https://modafinilmd.store/#]doctor-reviewed advice[/url] modafinil 2025

  15. cialis 10mg price [url=https://tadalaccess.com/#]tadalafil vs sildenafil[/url] trusted online store to buy cialis

  16. cialis vs flomax for bph [url=https://tadalaccess.com/#]TadalAccess[/url] cialis for prostate

  17. cialis pills pictures [url=https://tadalaccess.com/#]cialis free trial 2018[/url] cheap cialis

  18. us pharmacy prices for cialis [url=https://tadalaccess.com/#]TadalAccess[/url] generic cialis

  19. when will cialis become generic [url=https://tadalaccess.com/#]TadalAccess[/url] no presciption cialis

  20. san antonio cialis doctor [url=https://tadalaccess.com/#]tadalafil vidalista[/url] which is better cialis or levitra

  21. tadalafil vidalista [url=https://tadalaccess.com/#]cialis manufacturer[/url] cialis maximum dose

  22. what is cialis used for [url=https://tadalaccess.com/#]canadian cialis[/url] cialis pills pictures

  23. how to buy tadalafil online [url=https://tadalaccess.com/#]what is the difference between cialis and tadalafil?[/url] when will generic cialis be available in the us

  24. max dosage of cialis [url=https://tadalaccess.com/#]Tadal Access[/url] recreational cialis

  25. cialis manufacturer coupon 2018 [url=https://tadalaccess.com/#]TadalAccess[/url] cialis 20 mg coupon

  26. where can i buy cialis online [url=https://tadalaccess.com/#]cialis side effects with alcohol[/url] cialis online with no prescription

  27. tadalafil dose for erectile dysfunction [url=https://tadalaccess.com/#]what is the active ingredient in cialis[/url] vigra vs cialis

  28. how to buy tadalafil online [url=https://tadalaccess.com/#]Tadal Access[/url] tadalafil lowest price

  29. where to buy tadalafil online [url=https://tadalaccess.com/#]TadalAccess[/url] cialis manufacturer coupon lilly

  30. cheapest antibiotics [url=http://biotpharm.com/#]buy antibiotics online[/url] best online doctor for antibiotics

  31. Medications online Australia [url=https://pharmau24.com/#]PharmAu24[/url] Online drugstore Australia

  32. erectile dysfunction drugs online [url=https://eropharmfast.com/#]top rated ed pills[/url] Ero Pharm Fast

  33. CasinoAlpha experts rate this Wolfy Casino no deposit bonus as excellent because it offers players 20 free spins on one of the most popular games at the casino. The best part about this offer is that it has no wagering requirements, making it accessible even to the most inexperienced players. The maximum cashout limit for this bonus is $20, which we appreciate as an excellent amount for a bonus that requires no initial investment. This review is going to tell you everything about all you need to know about the no deposit bonus in the United States. Here you will understand how to select the best online casino in the US, the no deposit bonus, how it can be claimed, the bonus code, how to redeem, and the software provider that placed their focus on the United States
    https://emprendedorespoliticos.com/uncategorized/resolving-withdrawal-issues-fast-on-slot-ludo-the-live-dealer-casino-game-earning-app-for-india/
    Although it’s a leading name in personal and business credit cards, many casinos don’t accept American Express as a deposit or withdrawal method. So, it’s a good idea to check whether your chosen site accepts Amex before you sign up. Unfortunately, you cannot payout at an online casino using this method as it is only available for deposits. There are other online wallet options such as online casinos Neteller, Ecopayz, and traditional Visa, bank transfer deposit casino, and others for this purpose. …is not issued by all banks all over the world, however, it is widely accepted. VISA licenses its brand to the banks who issue it, therefore, it is up to the banks whether or not they would actually offer this service to their customers. If you do have it, however, you can play at online casinos using it, as it is a method that is most frequently used by players across online casinos.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.