EN
Español
English
Português
    ASMS_TASK_TEMPLATE

    Contains information for the task template in a model

    Data model

    Fields

    Field Type Description
    afls_service_id INT Afls Integration Service ID
    depend_condition NVARCHAR (MAX) Task dependency condition
    depend_structure NVARCHAR (MAX) Task dependency structure
    depend_text NVARCHAR (MAX) Descriptive name of the task dependency
    description NVARCHAR (MAX) Task Description
    duration* INT Task duration
    id* INT Unique Task Identifier
    model_id* INT Related service model identifier, reference the ASMS_MODEL.id table
    name* NVARCHAR (512) Descriptive name of the task
    offset INT Task compensation
    profile_id INT Task-related profile ID, reference table ASMS_PROFILES.id
    task_model_id INT Task model type identifier, reference the ASMS_TASK_TEMPLATE.id table
    type_id* INT Task type identifier, (0 = status, 1 = condition)

    Primary Key

    PK_ASMS_TASK_TEMPLATE
    id

    References

    Column Referenced Table Referenced column Name
    model_id* dbo.ASMS_MODEL id FK01_ASMS_TASK_TEMPLATE