'Many IDs to choose' what do you mean by this. I really do think the dept does have this data, in a database somewhere. Finding the person who has it is probably difficult though.
Can you have duplicate IDs? Ie is 0003 in system 1 guaranteed to be the same as 0003 in system 2? I suspect that's also a problem you may run into with this analysis.
... View more