OK, let's see how I can totally mis-explain this and maintain my [Redacted], Inc cover...
Let's say we track UFO sighting reports. We have an electronic database of every UFO, along with a file for it for anytime that UFO appears anywhere. (Just assume that we can tell which UFOs are seen more than once. I know, the metaphor really doesn't make sense, but go with it anyway.)
We have a master set of files for domestic UFO sightings. Underneath that, we have a subset of them that we'll call green glowy UFOs. Because they're special, and we need to track them separately, so we keep their files separate.
Well, I've started a project to clean up the UFO file cabinets. Come to find out, nobody has pulled out any of the files for debunked/explained UFOs since sometime in 2003, leaving us with a huge number of files that we don't need anymore just taking up space. Compounding this problem, apparently back in the 90s, my predecessors at [Redacted], Inc for reasons unknown deemed it necessary to keep TWO separate files for each green glowy UFOs - one in the green glowy UFO file cabinet, and one in the general domestic UFO file cabinet. This is inefficient and annoying.
So now, not only am I pulling out all of the files for the debunked UFOs, I am combining the duplicate files for all of the green glowy UFOs. This is a slow process and is a pain in my behind, but at least it gets me out of my cube and moving around a bit.
Oh, and I am also finding that we are missing a lot of files for our UFO sightings, so I'm going to have to pull information for all of those ones out of the electronic tracking system and create new UFO files, lest our auditors come through someday and get angry at us for not having all of our UFO records properly in place.