SLA Control Refactoring

the modeling and screens that parameterize the sla time were modified, in the items that have the control of ticket and problem tables the acordoservicocontrato table is no longer used to parameterize the sla time of activities the tempoatendservicocontrato table was created to define this relationship, which is now created by linking the servicocontrato directly to the acordonivelservico (service time); that is, before an sla is defined for an activity the service level agreement it must be defined for the activity in portfolio registration or maintenance screen automatic loading update scripts were included in the system that will load data into the table tempoatendservicocontrato , at the time of updating and respecting existing relationships therefore, after this update, the system must continue to apply the previously parameterized slas targets removal the service time screen has been redesigned and changed to no longer define contract targets and activity for service time this responsibility was passed to the portfolio screen and portfolio maintenance removal of the global, per customer, and specific concept the concept of global sla, by customer and specific, no longer exists in the system now all are slas specific, defined directly in the portfolio of activities the seasonal sla concept remains, well as a definition of vip priorities new business rule it is possible to relate, only, a single service time (service level agreement) main to an activity, however, as many times, of the seasonal type, are necessary portfolio screen the portfolio screen has been changed to record servicocontrato relationship with service agreements level of service, which can be applied to tickets, the choice of sla will be in accordance with what has the highest priority, respecting the priority of the service level agreement, calculated by the impact and priority of the service time, the priority of the unit, the priority of the employee and the requester's group the time setting will be chosen from the highest priority the flow definition and service time components have changed position and type, now the flow definition is of the “ select ” type and the service time definition is in a table format, as this is what needs to be added records and not the flow that is only one per activity former screen new screen portfolio maintenance screen the possibility to define the sla time for multiple activities was included, using the portfolio maintenance another important change is that we can now update information, in batches, from activities already related to the contract, the rules are as follows when linking activities to the contract or contract to activities, the system will add new relationships and update the existing ones, with the information fed into the final step of linking, where the user can define the flow, service time, calendar, date of start… only the information that is filled in in the final step of the link will be applied, one being record inclusion or update; if one or more activities are linked to the service contract, that is, performing an insertion operation in the database, if some obligatory information is missing , the operation will not be completed and the user will receive a message requesting them new maintenance screen time definition non altered rules priority calculation using or not parameter 104; vip priority setting; seasonality control; sla definition algorithm for all modules – this code has been refactored, but without changing business rules; definition of sla per task; sla compliance calculation impacts screens ticket smartportal experiencecenter templatesolicitacao acaoincidenterequisicao problema removal the following methods have been removed acordonivelservicoservice() findanssazonalbyidservicocontrato acordonivelservicoservice() findansincreqprocbyidservicocontrato acordonivelservicoservice() findanscliente acordonivelservicoservice() findansglobal acordonivelservicoservice() getidanssazonal apendix for this knowledge, the sql file with the script used to load the data to define the sla is attached to the tasker 14847 sqls for database analysis table that stores service and activity select from servico s table that defines the nature of each record select from servicoautorelacionamento s2 idservico refere se à atividade idservicorelacionado refere se ao servico de negócio service/activity relationship with the contract select from servicocontrato service time select from acordonivelservico a former relationship select from acordonivelservicocontrato a new relationship select from tempoatendservicocontrato t