Relational table that allows for many configuration item records to be related to many service intelligence records
| Column Name | Column Datatype | Column Null Option | Column Comment |
| rec_uuid | byte(16) | not null | SI Record uuid |
| persid | nvarchar(64) | not null | The persistent Identifier for this relationship record. |
| ci_uuid | byte(16) | not null | Configuration Items uuid |
| assignee_org | nvarchar(100) | with null | Assignees organization. De-Normalized here for performance purposes. |
| assignee_loc | nvarchar(100) | with null | Assignees location. De-Normalized here for performance purposes. |
| customer_org | nvarchar(100) | with null | Customers organization. De-Normalized here for performance purposes. |
| customer_loc | nvarchar(100) | with null | Customers Location from the record |
| rec_category | nvarchar(256) | with null | Denormalized category. |
| rec_ref_num | nvarchar(16) | with null | Denormalized si_rec_prop ref num. Placed here for performance purposes. |
| asset_name | nvarchar(100) | with null | DEe-normaliezed Name of the CI from owned_asset |
| rec_type | nvarchar(10) | with null | Type of record from Service Desk |
| data_source | varchar(256) | not null | Source that the data was received from |
Product Name: Unicenter Service Intelligence
Table Type: Table