Contains the status information for a record or item. It applies to service requests, CIs, Services, SLAs, Tasks, Events, Articles, among other objects.
Data model
Fields
| Field |
Type |
Description |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_app_category |
INT |
Related, unique entity type next to the stat_project, stat_model_id, and stat_name fields |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_background_color_rgb |
NVARCHAR (24) |
Color representation of the IC status in RGB scale Ex: 99.255.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_behavior |
INT |
|
Types |
use |
|
Articles |
0 = Unpublished 1 = Published |
|
Cis |
0 = Inactive 1 = Active |
|
Service |
0 = Strategy 1 = Design 2 = Transition 3 = Operation, 4 = Retired |
|
Incidents |
Profile ID |
|
Changes |
Profile ID |
|
Problems |
Profile ID |
|
Service Requirements |
Profile ID |
|
Releases |
Profile ID |
|
| stat_description* |
NVARCHAR (500) |
Description of the state |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_id* |
INT |
Unique State Identifier |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_model_id |
INT |
Unique model identifier next to the stat_app_category, stat_project, and stat_name fields |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_name* |
NVARCHAR (100) |
State name, unique next to fields stat_project, stat_model_id, and stat_app_category |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_note |
BIT |
Indicates whether a note is required for status |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_project |
INT |
Identifier of the project to which the state belongs, unique along with stat_app_category, stat_model_id, and stat_name |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stat_stage_id |
INT |
Identifier of the behavior of the state, (Ex: Voided, in progress) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Primary Key
References
