HZ_ORG_CONTACTS
Specializes a HZ_RELATIONSHIPS row into a named contact for an organization party, carrying the contact's role attributes.
Key Columns
Used In
Related
Party contacts (people) for a customer/organization
A 'contact' in TCA is a person party related to an organization party — never a single 'HZ_CONTACTS' table, and HZ_PARTY_SITES is not it either (that's addresses only, no phone/email). The relationship itself lives on HZ_RELATIONSHIPS (SUBJECT_ID = the person's PARTY_ID, OBJECT_ID = the organization's PARTY_ID, RELATIONSHIP_TYPE identifying it as a contact relationship), specialized by a HZ_ORG_CONTACTS row (PARTY_RELATIONSHIP_ID = the relationship, plus role attributes like JOB_TITLE). The contact person's actual phone/email lives separately on HZ_CONTACT_POINTS (OWNER_TABLE_ID = the person's PARTY_ID, OWNER_TABLE_NAME = 'HZ_PARTIES', CONTACT_POINT_TYPE = 'PHONE' or 'EMAIL'). So a full 'contacts with phone/email for this org' query joins HZ_PARTIES (org) -> HZ_RELATIONSHIPS -> HZ_ORG_CONTACTS, plus HZ_PARTIES again (for the contact's own name) -> HZ_CONTACT_POINTS (for that contact's phone/email) — five tables, not three.