EN
Español
English
Português
    AFLS_SLA_TIMES

    Table for recording service level agreement timers

    Data model

    Fields

    Field Type Description
    chronometer_id* INT Associated stopwatch identifier.
    compilance* DECIMAL Compliance Percentage
    create_date DATETIME Creation date record.
    default_sla_time* BIT Dialing for default record identification
    delete_date DATETIME Deletion date record.
    id* INT Unique identifier of the table
    is_deleted BIT Dialing to identify if the service agreement time is in a deleted state.
    model_id INT The model identifier of the associated stopwatch.
    priority INT Priority identifier of the associated stopwatch.
    sla_id* INT Associated service level agreement identifier.
    target* DECIMAL Fulfillment Time in Minutes

    Primary Key

    PK_AFLS_SLA_TIMES
    id

    References

    Column Referenced Table Referenced column Name
    chronometer_id* Bod. AFW_ITEM_TIMES id FK01_AFLS_SLA_TIMES
    model_id dbo.AFW_ITEM_MODEL id FK04_AFLS_SLA_TIMES
    priority dbo.AFLS_PRIORITY id FK03_AFLS_SLA_TIMES
    sla_id* dbo.AFLS_SLA sla_id FK02_AFLS_SLA_TIMES