Relationship table that joins many contacts to many organizations within the Unicenter Service Intelligence product. This allows the product to have separate organizational structures derived from both Unicenter Service Desk and Unceinter Argis so that the customer cn decide which is the best structure to use for the presentation of their metrics.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| org_uuid | byte(16) | not null | Organization tables uuid value based on records used within Unicenter Service Desk, Argis, or Service Management. (i.e. we only pull those records that are referenced within these applications as opposed to all ca_organization records) |
| cnt_uuid | byte(16) | not null | Contact uuid that is a member of the organization. |
| contact_name | nvarchar(100) | with null | Resolved name of contact for the relationship |
| rel_org_name | nvarchar(100) | with null | Denormalized organization nam to reduce lookups on cca_organization table. |
| data_source | varchar(256) | not null | Source that the data was received from |
| rel_org_location | nvarchar(100) | with null | Denormalized organization location name used to reduce lookups on the ca_organization.ca_location structure. |
Product Name: Unicenter Service Intelligence
Table Type: Table