This table holds the de-normalized log entries for each of the si_rec_prop records. There are many log entries for each si_rec_prop record, each with de-normalized data in them used for deriving different metrics.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| rec_uuid | byte(16) | not null | The owning SI Record uuid |
| actual_date | date | with null | User entered Date time that the record was added to Unicenter Service Desk activity logs. |
| type | char(10) | with null | Qualification for the activity log type. Values are CNCL = Canceled CB = Call Back recorded CL = Closed CLREQ = Close Request SLADELAY = SLA Delayed CHG = Change Order created ESC = Escalated EVT = SLA Event fired FLD = Field Updated INIT = Record created LOG = Log COmment added TR = Transferred ST = Status Updated |
| system_date | date | with null | System date _time stamp that the log was entered |
| assignee_org | nvarchar(100) | with null | The assignee's de-normalized organization |
| assignee_loc | nvarchar(100) | with null | The assignee's de-normalized location |
| assignee_group | nvarchar(100) | with null | The assignee's de-normalized group name |
| rec_state | nvarchar(100) | with null | Denormalized si_rec_prop.state |
| rec_category | nvarchar(256) | with null | Denormalized si_rec_prop.category |
| rec_customer_loc | nvarchar(100) | with null | Denormalized si_rec_prop.customers' location |
| rec_customer_org | nvarchar(100) | with null | Denormalized si_rec_prop.customers' organization |
| rec_status | nvarchar(100) | with null | Denormalized si_rec_prop.status |
| rec_type | char(10) | with null | Denormalized si_rec_prop.type |
| ref_num | nvarchar(16) | with null | Denormalized si_rec_prop.ref_num |
| data_source | varchar(256) | not null | The data source that the data was received from |
| persid | nvarchar(64) | not null | Persistent record ID from Service Desk |
| cnt_typ | integer | with null | |
| role_cost | money | with null |
Product Name: Unicenter Service Intelligence
Table Type: Table