EN
Español
English
Português
    ASDK_SLA

    Contains the information for the management of Service Level Agreements

    Data model

    Fields

    Field Type Description
    calendar_id INT Calendar ID
    contract_type INT Determines the type of contract (SLA = 14, UC = 54, OLA = 55)
    date_finish DATETIME Settlement End Date
    date_start DATETIME Settlement Start Date
    descripcion NVARCHAR (8000) Description of the Agreement
    finish_schedule_flag* BIT Indicates if the end date has been reached
    finish_template_id INT Mail template ID for the end date alert, reference the ASMS_MAIL_TEMPLATE.id table
    fl_int_finish_has_alarm* BIT Determine if the end date has an alarm
    fl_int_finish_limitdays INT Specify the number of days before the end date to generate the alarm
    fl_int_review_has_alarm* BIT Determine if the review date has an alarm
    fl_int_review_limitdays INT Specify the number of days before the review date to generate the alarm
    fl_int_slastate INT Status ID for the case, reference the ASMS_STATUS.stat_id table
    is_delete* BIT Indicates whether the Agreement has been deleted
    name* NVARCHAR (510) Name of Agreement
    previous_status_id INT Previous state identifier for the case, reference the table ASMS_STATUS.stat_id
    proj_id INT Associated project ID, reference table ASMS_PROJECTS.proj_id
    reason_id INT Identify the reason for the Agreement
    review_schedule_flag* BIT Indicates whether the review date has been reached
    review_template_id INT Mail template ID for the review date alert, reference the ASMS_MAIL_TEMPLATE.id table
    sla_date_close DATETIME Deal Closing Date
    sla_date_open DATETIME Date of registration or reopening of the Agreement
    sla_date_review DATETIME Date of revision of the Agreement
    sla_id* INT Unique identifier of the quotas of the Agreements
    sla_modified_date DATETIME Date of last modification
    sla_modifier_id INT Identifier of the last modifier user

    Primary Key

    PK_ASDK_SLA
    sla_id

    References

    Column Referenced Table Referenced column Name
    finish_template_id dbo.ASMS_MAIL_TEMPLATE id FK02_ASDK_SLA
    fl_int_slastate dbo.ASMS_STATUS stat_id FK03_ASDK_SLA
    proj_id dbo.ASMS_PROJECTS proj_id FK01_ASDK_SLA
    review_template_id dbo.ASMS_MAIL_TEMPLATE id FK04_ASDK_SLA