I used to be a Deputy Sheriff in another state. I was also attached to a task force with the US Marshals Office. I can tell you first hand that every City Police Department, County Sheriff's Office, State Police Agency, and all the Federal Agencies (ATF, USM, FBI, DOJ, ICE, Railroad Police - yeah, that's it's own agency, DHS, Border Patrol, DEA) ALL have their own local records systems.
The FBI also maintains a national database called NCIC: National Crime Information Center.
Now, all of these law enforcement agencies in the country and their associated prosecutors offices and court clerks have to update their local database with warrant information, arrest records and charges, fingerprint records, name/address/phone #/SSN info, associated vehicle info, charges that have been dropped, downgraded, upgraded or dismissed, plea agreements, sentencing information, it ALL has to be updated. There is an unholy crap-ton of data that has to be entered DAILY and there is usually no checks/balances to go back and verify it is correct once its put in.
Next, state and local agencies that have received the proper training from the FBI and have the proper computer access to NCIC can upload their data to the NCIC database. This data can then able to be shared with other agencies with access to NCIC, but it is not a mandatory requirement that all state and local law enforcement agencies have access or upload their data if they do have access. The ones who do, have to upload it in a specific format, but this is typically a different format from the local system. This conversion of data formats which creates room for error. The uploading agency is supposed to verify the info is correct, but again, room for human error.
Now, when an agency searches a person's name, the system is designed to bring up all names that are phonetically similar (the computer is actually programmed to know what words sound like) and all the various spellings of the name. A human then has to sift through the returned info and decide if any of it matches the person they are physically dealing with. Room for Error.
I have seen first hand, on MANY occasions, the information in these databases are not current, not accurate, or not complete enough to make an accurate determination to whether it belongs to the person we were dealing with. I once arrested a man for being in possession of a stolen firearm (had a valid CCW). This was a Friday evening. He swore up and down he bought it from a sporting goods store where he worked in another state. Long story short, I could have let him sit in jail all weekend, but I went out of my way and called the ATF in Washington DC and actually got in touch with a live person on a Friday evening, (damn near impossible, trust me) from whom I found out the gun was 1 of 93 guns stolen from that store. All guns were recovered and returned, but some federal law prevented them from being sold to the public so they could only be sold to employees or disposed of in some other process. So this guy I arrested bought the gun in question LEGALLY and the ATF had the records of that legal purchase, but FORGOT to update NCIC. So here he is on vacation, 1,000 miles away from home in jail for no reason, and had I not done more than I needed to at the time, he would have sat in jail all weekend, gone to court Monday, been turned over to our local ATF office, and maybe Monday afternoon or Tuesday they would have figured it out and let him go.
There is too much info out there, with too much room for human error on the input side and on the retrieval side of the system. I guess the message I'd like to get across is this: It is very possible to have something pop up on a background check that was missed 20 times before. It is also very possible to have someone else's info pop up when your name is searched. This happens to my brother frequently because someone with the same first and last name and same middle initial (different middle name, but still starts with the letter D ) has a federal warrant for his arrest for armed robbery of a post office.
Unfortunately, often times the individual has to suffer or go through as much work to prove his case as the government has to go through to prove theirs. The one truly amazing part about the whole records system with NCIC and a million independent state and local systems is that these mistakes do not occur more often than they do.
So just my $.02 on these background checks and records checks.