Certainly, it is possible to design an Oracle database (or any other) and applications to recognize that 2 employees at different locations are the same employee. An associative table is just one way to accomplish this. I suspect you are looking for an easy way to do this within one of Oracle’s (or some 3rd party’s) application suites. We don’t use those where I work, so I can’t help with that. I’m sure others in your target group, but they’ll need to know what you’re using to be able to respond intelligently.