Last Name Null Causing Database Confusion

Posted by Frank Strafford on October 10, 2018 in GSA, SAM,

Databases have long had difficulty displaying the name Null. That is because database systems are wired to read this as a value or more accurately, the non-value “null”. It is deeply ingrained in their programming code and used in many software programs. To be clear, “null” does not have a zero (0) value. It means that the value is unknown.

SAM Glitch

The General Services Administration’s (GSA) Systems for Awards Management (SAM) is not immune to this programming. It has been discovered that the name Null will have a “null” value in its database. It was unable to display a value or string of text which should otherwise be part of an individual’s last name. For example, it would reflect John Null as John “(empty field)”. This makes it challenging to confirm which individuals are excluded due to the absence of a last name in their records.

Note that this situation is not confined to the GSA-SAM. This exists across a wide range of industries that employ the use of databases. It is an unavoidable circumstance, especially when the software program is created including the “null” attribute. This can be observed in the financial services industry, for instance. A bank having depositors with Null as a last name in their system might mail letters to the right address with the correct first name. The last name however would be left blank because their printing system will read Null as “null” or unknown from their database.

Case In Point

GSA-SAM

An actual SAM search was performed on Angela Johnson Null online. It yielded an “Exclusion” result with an Exclusion Type of Prohibition / Restriction. Clearly, the record is on their searchable database.

The problem however was when this list was actually downloaded. Angela Johnson Null’s name would be reflected as Angela Johnson only. Her last name Null would no longer appear.

SAM search

– click to enlarge –

The case is the same for the three other individuals following her name. Observe Bruce L., John W. and Kelly. They all have a last name Null however due to a bug in the SAM system, their last names cannot be detected. The “null” dilemma is quite common especially for institutions with large sets of data. To be clear, such names were picked up by our systems. It was because they were included in OIG’s LEIE so any risk that they could be missed under the SAM was averted.

About Frank Strafford

About Frank Strafford

Related Articles

What Are the Effects of OIG ...

December 22, 2014

A person can end up on the OIG List of Excluded Individuals for a range of reasons and the main effect of being excluded is that individuals cannot receive payment through Medicare, Medicaid or any ot...

13 Days, 250K in OIG Fines

February 5, 2015

Looks like the OIG means business. Over the course of the past 13 days, over $250,000 in fines have been meted out due to the alleged employment of excluded individuals.  The first involved a Minnes...

Updates on Data Modernization Efforts by ...

June 24, 2022

At the March 29, 2022 Health Care Compliance Association (HCCA) conference, Christi A. Grimm, HHS-OIG Inspector General, presented an update on key agency initiatives and priorities that directly impa...

Understanding OIG Exclusions

OIG Exclusions Screening Process

Exclusion FAQS

Quick OIG Exclusion Basics

Employing Excluded Individuals

Consequences to Employing an Excluded Individual

OIG Compliance Law

Laws and Publications on OIG Compliance

More Compliance Resources

About Us

Industry leader Streamline Verify has been forging new paths in Exclusion Screening.

Trusted for Good Reason

  • ✓ Guaranteed accurate
  • ✓ Certified Secure
  • ✓ Audit Proof
  • ✓ Feature-rich reporting
  • ✓ Round the clock real-time-data
  • ✓ Processing fully automated

Security First

  • ✓ Cloud hosted
  • ✓ Encrypted data
  • ✓ Real-time backups

Trusted for Accuracy

  • ✓ Physical security
  • ✓ Restricted access
  • ✓ Single sign-on
  • ✓ Password security
  • ✓ Certified secure
  • ✓ Cross checking

HEALTHCARE ESTABLISHMENTS NATIONWIDE COUNT ON STREAMLINE VERIFY

5

60%

Average workload reduction by implementing the Streamline Verify program

5

10K

Establishments trust Streamline Verify nationwide

5

2011

Serving the healthcare industry’s unique compliance needs since 2011

5

24X

Setting standards with hourly synchronization to primary source data

VERIFIED!

[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]