EN
Español
English
Português
    ASMS_MODEL

    It contains information about a type or model of elements. You can group and assign functions (such as possible statuses) to different elements such as Service Requirements, Tasks, Items, CIs, Packages or Events among others.

    Data model

    Fields

    Field Type Description
    active BIT Indicates whether the model is active, 0 = inactive, 1 = active
    default_profile_id INT Associated profile ID, reference to ASMS_MODELPROFILES.id table
    default_time_id INT Model default timer ID, reference to ASMS_TIMES.id table
    description* NVARCHAR (500) Model Description
    id* INT Unique model identifier
    instructions NVARCHAR (MAX) Help Text
    item_type_id* INT Model type, reference to ASMS_TYPES.id table, unique along with name
    name* NVARCHAR (200) Model name, unique along with type
    recalculate_date BIT Determines whether the model supports date recalculation
    script NVARCHAR (MAX) Text or script with HTML content to assign the description in cases

    Primary Key

    PK_ASMS_MODEL
    id

    References

    Column Referenced Table Referenced column Name
    default_profile_id dbo.ASMS_MODELPROFILES id FK02_ASMS_MODEL
    default_time_id dbo.ASMS_TIMES id FK03_ASMS_MODEL
    item_type_id* dbo.ASMS_TYPES id FK01_ASMS_MODEL