EN
Español
English
Português
    AFLS_SERVICES

    Table for creating detailed records for a particular AFLS service.

    Data model

    Fields

    Field Type Description
    ola_id INT OLA (Operating Level Agreement) identifier: Contract that defines the internal technical relationships that are necessary in the company providing a service to support the agreed SLAs
    proj_id INT The identifier of the project to which the particular service relates.
    serv_active* BIT Field to identify if the service is
    serv_base_cost* DECIMAL Field for defining the base cost of a service
    serv_calendar_id* INT An identifier used to associate the service with a specific calendar.
    serv_create_enable_by_specialist* BIT Dialing to identify if the service is applicable for creation by specialists
    serv_default* BIT Default Service Assignment Field
    serv_description* NVARCHAR (MAX) Field where the service description is entered
    serv_execution_time* INT A field where the maximum time it can take for a service to run is recorded
    serv_id* INT Primary key of the table with service ID.
    serv_is_priority_or_emregency* BIT Boolean field used to mark the service as priority or default
    serv_is_provide_all_ci* BIT Dialing to identify if the service is applicable for all CI Configuration Items
    serv_model_id INT Model identifier associated with the service.
    serv_name* NVARCHAR (200) Field where the service name is stored
    serv_provider_assignment_type* INT Service Assignment Type: DirectAssignment = 1 –> Work order is assigned to a vendor directly given by the AFLS algorithm during its creation. PublicDistribution = 2 –> The order(s) that have this type of service will enter the list of available orders so that any provider that meets the appropriate conditions can take them.
    serv_subject_default NVARCHAR (200) Subject default value for the service
    serv_time_planning* INT Field for recording planned time of service execution
    serv_type* INT Type of service: 0 - Mandatory 1- PointToPoint, 2- Standard
    sla_id* INT Compo where the identifier of the particular service level agreement is recorded.
    uc_id INT UC Identifier (Underpinning Contract): This is a formal contract between an IT service provider and a third-party provider.

    Primary Key

    PK_AFLS_SERVICES
    serv_id

    References

    Column Referenced Table Referenced column Name
    proj_id dbo.AFLS_PROJECTS proj_id FK01_AFLS_SERVICES
    serv_calendar_id* dbo.AFLS_CALENDAR cale_id FK04_AFLS_SERVICES
    serv_model_id dbo.AFW_ITEM_MODEL id FK03_AFLS_SERVICES
    sla_id* dbo.AFLS_SLA sla_id FK02_AFLS_SERVICES