Defines an SLA contract, One are more contracts are tied to an account, basically contract is the primary entity to do service level assurance
| Column Name | Column Datatype | Column Null Option | Column Comment |
| contract_id | integer | not null | Unique identity for the contract |
| expiredate | date | with null | Expire date for the contract |
| report_interval | integer | with null | Reporting interval.
SLO's are checked for breaches for each reporting interval. |
| report_offset | varchar(20) | with null | |
| start_date | date | with null | Start date of contract |
| status | integer | with null | Active, Pending, Cancelled |
| description | nvarchar(128) | with null | Description of contract |
| account_id | varchar(50) | with null | Associated account id |
| tenant_id | varchar(50) | with null | Associated tenant id |
| contract_type | varchar(20) | with null | Used to indicate hidden contracts that represents report groups. NULL indicates normal contract |
| service_hours | varchar(100) | with null | Specification of service hours:
# separated list of HH:MM times where HH is hours and MM is minutes. Starts with sunday and ends with saturday. |
| last_update | date | with null |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| contract_id | usm_link_contract_sla_inst | contract_id |
| contract_id | usm_sla_metric_instance | contract_id |
| contract_id | usm_serviceconfig | contract_id |
| contract_id | usm_slo_event | contract_id |
| contract_id | usm_slo_data | contract_id |
| contract_id | usm_sm_event | contract_id |
| contract_id | usm_report_group | contract_id |
| contract_id | usm_sla_instance | contract_id |
| contract_id | usm_contract_action | contract_id |
| contract_id | usm_metric_instance | contract_id |
| contract_id | usm_link_service_event | contract_id |