EN
Español
English
Português
    AFLS_SLA

    Table for recording the different service level agreements that can be established

    Data model

    Fields

    Field Type Description
    agreement_type INT Identification of the type of service agreement (SLA, UC, OLA).
    date_finish DATETIME Service Level Agreement End Date
    date_start DATETIME Service Level Agreement Start Date
    description NVARCHAR (MAX) Detailed description of the service level agreement
    finish_has_alarm BIT Marking to identify if the service level agreement has an alarm to send notifications
    finish_limitdays INT Limit of days for end of the alarm
    is_deleted BIT Dialing to identify if this SLA is in a deleted state
    name* NVARCHAR (510) Service Level Agreement Name
    penality DECIMAL Established penalty value in case of breach of service level agreement
    proj_id INT Project ID related to service level agreement.
    review_has_alarm BIT Field for review if this service provision agreement has alarms configured
    review_limitdays INT Field for review if this service agreement has a limit of days configured
    sla_costse DECIMAL Field for recording costs of service provision agreement
    sla_date_review DATETIME Service Level Agreement Review Date Record
    sla_id* INT Unique identifier of the table

    Primary Key

    PK_AFLS_SLA
    sla_id

    References

    Column Referenced Table Referenced column Name
    agreement_type Bod. AFLS_TYPE_AGREEMENT id FK02_AFLS_SLA
    proj_id Bod. AFW_PROJECTS proj_id FK01_AFLS_SLA