This is the denormalized data derived from the ca_contact table used in Service intelligence. The reason for denormalizing as opposed to using existing data is that the amount of indexing required for Ingres, coupled with the complexity of the queries that would be necessary for deriving the data necessary, would impact performance of the base applications that are used to maintain the ca_contact table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| contact_uuid | byte(16) | not null | Contact uuid used across the mdb |
| combo_name | nvarchar(100) | with null | Derived value based concatenating the [last_name]+", "+[first_name]+" "+[middle_name] from the ca_contact table, or using the combo_name already derrived for the contact table if consistently used across the Unicenter applications |
| manager_uuid | byte(16) | with null | FK to si_contact_prop indicating the manager of the current contact. |
| manager_name | nvarchar(100) | with null | Derrived value based concatenating the [last_name]+", "+[first_name]+" "+[middle_name] from the ca_contact table, or using the combo_name of the manager already derrived for the contact table if consistently used accross the Unicenter applications |
| type | nvarchar(100) | with null | The classification/function/role of the contact set by the last application to touch the record. We believe that for first rev, contact will be owned by Service Desk so Analayst, Manager, etc.. should be available values. Argis, Service Management, and other applications may have the ability to modify these values. Ownership of contact record management will drive where we derrive this data from. |
| uspsd_org_uuid | byte(16) | with null | Service Desk Internal Organization uuid that the contact is affiliated with |
| location | nvarchar(100) | with null | Denormalized name of the contacts location based on the ca_contact.location.l_name value. |
| usi_org_uuid | byte(16) | with null | Service Intelligence Internal Organization uuid that the contact is affiliated with |
| uspsd_org_name | nvarchar(100) | with null | Denormalized Service Desk Internal Organization Name that the contact is affiliated with |
| uspsd_admin_org | nvarchar(100) | with null | Denormalized Service Desk Adkministrative Organization Name that the contact is affiliated with |
| active | integer | with null | Boolean that determines if the record is currently active or not in Service Desk |
| data_source | varchar(256) | not null | Source that the data was received from |
Product Name: Unicenter Service Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| contact_uuid | si_cnt_org_rel | cnt_uuid |