The default service goals.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| service_goal_id | integer | not null | Uniquely identifies the |
| label | nvarchar(100) | with null | The label of the service goal |
| label_bundle_key | varchar(50) | with null | Bundle key for the label. Used if label is null |
| description | nvarchar(255) | with null | Description for service goal |
| descr_bundle_key | varchar(50) | with null | Bundle key for description. Used if description is null. |
| properties | integer1 | with null | Gives the properties, in binary format
properties & 1 == 1 : required properties & 2 == 1 : editable properties & 4 == 1 : hidden |
| default_value | varchar(255) | with null | Default value for the service goal |
| minval | varchar(255) | with null | Minimum allowed value for service goal values |
| maxval | varchar(255) | with null | Maximum value for service goal values. |
| orientation | integer1 | with null | # 0: no orientation # 1: less than # 2: less or equal # 3: greater or equal # 4: greater than |
| name | nvarchar(100) | not null | Purpose of the field is to have a string to match against for our data import system. When new metrics are added through the data import, we need this to check if the service goal is already defined. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| service_goal_id | usm_service_goal_values | service_goal_id |
| service_goal_id | usm_report_group_goal | service_goal_id |
| service_goal_id | usm_link_metric_scope | service_goal_id |