I work in the NOC with my company and I'm writing a webapp to streamline checking visitors in and out of our datacenter to keep track of who is visiting, how often, and for how long. I've been working with our test server trying to find the link between ITSM_PERSONS and ITSM_ORGANIZATIONS because these are pretty much the only tables I need to work with. The logical link would be PER_ORG_OID in ITSM_PERSONS would be the same as ORG_OID in ITSM_ORGANIZATIONS but I'm finding that isn't true.
What should I be looking at for what links the people in the ITSM_PERSONS table with the company they're connected to? Thanks in advance.