EN
Español
English
Português
    ASMS_STATUS

    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 entity type, reference to ASMS_TYPES.id table, unique next to fields stat_project, stat_model_id, and stat_name                                                      
    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 Model ID, reference to the ASMS_MODEL.id table, unique 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, reference to the ASMS_PROJECTS.id table, unique along with stat_app_category, stat_model_id, and stat_name                                                      
    stat_stage_id INT Identifier of the behavior of the state, (e.g.: Voided, in progress) references the ASMS_STATUS_STAGE.id                                                      

    Primary Key

    PK_ASMS_STATUS
    stat_id

    References

    Column Referenced Table Referenced column Name
    stat_app_category dbo.ASMS_TYPES id FK01_ASMS_STATUS
    stat_model_id dbo.ASMS_MODEL id FK03_ASMS_STATUS
    stat_project dbo.ASMS_PROJECTS proj_id FK02_ASMS_STATUS
    stat_stage_id dbo.ASMS_STATUS_STAGE id FK04_ASMS_STATUS