Rule is a basic entity which drives the fulfillment of a task, we can add any number of rule for a specific rule_event_type.
Rule will hold a bunch of action associated which will be triggered on execution of this rule
Eg: A new hire is added to a company and you want to drive certain thing as soon as a user is added into the system.
Here "new hire" is a new rule which is added to rule_event_type ADD_USER.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| rule_id | varchar(50) | not null | Non-displayable id used in the backend as a reference between tables. |
| status | integer | with null | ACTIVE/DISABLED. A disabled rule does not get triggered when an event occurs. |
| display_name | nvarchar(64) | with null | Name for this rule. |
| description | nvarchar(128) | with null | Text explaining the purpose of this rule. |
| is_hidden | integer | with null | YES/NO. Any hidden rules will not be shown in the GUI. However, they will be triggered when an event corresponding to the event type this rule is subscribed for, occurs. |
| is_system | integer | with null | YES/NO. iCanProvision comes with some in-built rules for certain event types such as SLA Violation etc. These are system rules. |
| event_type_id | varchar(50) | with null | Non-displayable id used in the backend as a reference between tables. |
| type | nvarchar(64) | with null | Specifies the type of the rule |
| sub_type | nvarchar(50) | with null | Specifies the secondary type of the rule |
| start_time | date | with null | Specifies the start time of the rule activation |
| expire_time | date | with null | Specifies the expiration time of the rule |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| rule_id | usm_contract_action | rule_id |
| rule_id | usm_rule_condition | rule_id |
| rule_id | usm_rule_action | rule_id |