4 ms·
first real job was at a 2-year rural college. We had 2 systems, one for students, one for staff. Sometimes people would forget to properly reference the 'othe
by briffle 2y ago
first real job was at a 2-year rural college.
We had 2 systems, one for students, one for staff. Sometimes people would forget to properly reference the 'other' account when a teacher took a class, or a student taught a community education class, etc. We were in the process of consolidating into a single DB, and didn't want a bunch of duplicates.
We had a person Leslie that kept getting duplicated in the systems. Same address same age, same birthdate. Only difference was different gender, and last 2 digits of social was 21 instead of 12.
So our dba deleted one, and linked them.
Month later, same thing. So our DBA fixed it. Shaking his head at the people up front not following data entry procedures.
Next week, both Leslie's were in our office. They were born on same day, but hospitals in nearby towns. Back then socials were handed out sequentially by region. They had different last names until they married 40 years before.
They were laughing and said this happens more often then most people would think.