Service Desk Practitioners Forum
cancel

Link between ITSM_PERSONS and ITSM_ORGANIZATIONS

SOLVED
Go to solution
Highlighted
Ryan Schremp
New Member.

Link between ITSM_PERSONS and ITSM_ORGANIZATIONS

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.
2 REPLIES
George M. Meneg
Acclaimed Contributor.
Solution

Re: Link between ITSM_PERSONS and ITSM_ORGANIZATIONS

Hello Ryan,

Probably you mistyped your query because the ITSM_PERSONS and ITSM_ORGANIZATIONS are indeed joined on ITSM_PERSONS.PER_ORG_OID=ITSM_ORGANIZATIONS.ORG_OID

Furthermore if you see the definition of the table "ITSM_PERSONS" you will note the following "entry"

CONSTRAINT [PER_ORG_OID_FK] FOREIGN KEY
(
[PER_ORG_OID]
) REFERENCES [ITSM_ORGANIZATIONS] (
[ORG_OID]
)

meaning that these tables are joined on the columns PER_ORG_OID and ORG_OID
menes fhtagn
Ryan Schremp
New Member.

Re: Link between ITSM_PERSONS and ITSM_ORGANIZATIONS

Thanks a lot. I guess I'll have to go back through my code and see what I come up with.