DBCC CHECKDB (db_stage) WITH physical_only executed by SISTEMAFIRJAN\SQLAgentService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 5 seconds.  Internal database snapshot has split point LSN = 00000094:0001df70:0001 and first LSN = 00000094:0001df60:0001.

DBCC CHECKDB (CustomizacoesSGE) WITH physical_only executed by SISTEMAFIRJAN\SQLAgentService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 2 minutes 59 seconds.  Internal database snapshot has split point LSN = 00005faa:00060650:0001 and first LSN = 00005faa:00060640:0001.

DBCC CHECKDB (CorporeRM_GED) WITH physical_only executed by SISTEMAFIRJAN\SQLAgentService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.  Internal database snapshot has split point LSN = 000005c9:0001f168:0001 and first LSN = 000005c9:0001f158:0001.

DBCC CHECKDB (CorporeRM) WITH physical_only executed by SISTEMAFIRJAN\SQLAgentService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 18 minutes 46 seconds.  Internal database snapshot has split point LSN = 0003d3de:001162d8:0011 and first LSN = 0003d3de:001162b8:0001.

Error: 17832, Severity: 20, State: 2.

Error: 17832, Severity: 20, State: 2.

Error: 18456, Severity: 14, State: 5.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: 10.255.18.229]

Error: 17832, Severity: 20, State: 18.

Error: 17836, Severity: 20, State: 14.

Error: 17828, Severity: 20, State: 7.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17832, Severity: 20, State: 18.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 14.

Error: 17832, Severity: 20, State: 18.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 17.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 14.

Error: 17836, Severity: 20, State: 14.

select * from [dbo].[GIMAGEM]

select * from SPLANOAULA (nolock)

INSERT INTO #XEventData
            SELECT CAST(event_data AS XML) AS EventDataXML
            FROM sys.fn_xe_file_target_read_file(
                (SELECT CAST(target_data AS XML).value('(EventFileTarget/File/@name)[1]', 'NVARCHAR(1000)')
                FROM sys.dm_xe_sessions AS s
                JOIN sys.dm_xe_session_targets AS t ON s.address = t.event_session_address
                WHERE s.name = 'system_health' AND t.target_name = 'event_file'),
                NULL, NULL, NULL)
            WHERE object_name IN ('database_file_size_change', 'log_file_size_change')

SELECT SHORARIO.CODCOLIGADA, 
                               SHORARIO.CODHOR, 
                               SHORARIO.CODTURNO,
                               SHORARIO.HORAINICIAL, 
                               SHORARIO.HORAFINAL, 
                               SHORARIO.DIASEMANA,
                                CASE WHEN (SHORARIOTURMA.DATAINICIAL IS NOT NULL)
                                  THEN SHORARIOTURMA.DATAINICIAL
                                  WHEN (STURMADISC.DTINICIAL IS NOT NULL)
                                       THEN STURMADISC.DTINICIAL
                                  WHEN (STURMA.DTINICIAL IS NOT NULL)
                                       THEN STURMA.DTINICIAL
                                  ELSE
                                     SPLETIVO.DTINICIO 
                                END DATAINICIAL,  
                                CASE WHEN (SHORARIOTURMA.DATAFINAL IS NOT NULL)
                                  THEN SHORARIOTURMA.DATAFINAL
                                  WHEN (STURMADISC.DTFINAL IS NOT NULL)
                                       THEN STURMADISC.DTFINAL
                                  WHEN (STURMA.DTFINAL IS NOT NULL)
                                       THEN STURMA.DTFINAL
                                 WHEN (SPLETIVO.DTFIM IS NOT NULL)
                                       THEN SPLETIVO.DTFIM
                                  ELSE
                                     SPLETIVO.DTPREVISTA 
                                END DATAFINAL, 
                                CASE WHEN (SHORARIOTURMA.DATAINICIAL IS NOT NULL)
                                  THEN '0'
                                  WHEN (STURMADISC.DTINICIAL IS NOT NULL)
                                       THEN '4'
                                  WHEN (STURMA.DTINICIAL IS NOT NULL)
                                       THEN '5'
                                  ELSE
                                     '3'
                                END ORIGEMDATAINICIAL,  
                                CASE WHEN (SHORARIOTURMA.DATAFINAL IS NOT NULL)
                                  THEN '0'
                                  WHEN (STURMADISC.DTFINAL IS NOT NULL)
                                       THEN '4'
                                  WHEN (STURMA.DTFINAL IS NOT NULL)
                                       THEN '5'
                                  ELSE
                                     '3'
                                END ORIGEMDATAFINAL,
                                SHORARIOTURMA.IDTURMADISC ID, 
                                SDISCIPLINA.NOME  +  ' ('  +  SDISCIPLINA.CODDISC  +  ')' DESCRICAO, 
                                4 TIPOHORARIO, 
                                3 TIPOCHOQUEHORARIO,
                                STURMADISC.CODTIPOCURSO,
                                STIPOCURSO.NOME AS TIPOCURSO,
                                STURMADISC.CODFILIAL,
                                GFILIAL.NOME AS FILIAL,
                                SHORARIOTURMA.IDHORARIOTURMA,
                                SHORARIOTURMA.CODSUBTURMA,
                                STURMADISC.ESPELHO,
                                SMATRICULA.IDTURMADISCPRINCIPAL,
                                SSTATUS.DIINCALUNODISC,
                                SSTATUS.DIBLQALTSITMATDISCPRT
                              FROM SHORARIOTURMA (NOLOCK) JOIN SHORARIO (NOLOCK)
                                  ON (SHORARIOTURMA.CODCOLIGADA = SHORARIO.CODCOLIGADA AND 
                                      SHORARIOTURMA.CODHOR = SHORARIO.CODHOR)
                                JOIN STURMADISC (NOLOCK)
                                  ON (SHORARIOTURMA.CODCOLIGADA = STURMADISC.CODCOLIGADA AND
                                      SHORARIOTURMA.IDTURMADISC = STURMADISC.IDTURMADISC)
                                JOIN SDISCIPLINA (NOLOCK)
                                  ON (STURMADISC.CODCOLIGADA = SDISCIPLINA.CODCOLIGADA AND
                                      STURMADISC.CODDISC = SDISCIPLINA.CODDISC)
                                JOIN STURMA (NOLOCK)
                                  ON (STURMADISC.CODCOLIGADA = STURMA.CODCOLIGADA AND
                                      STURMADISC.CODFILIAL = STURMA.CODFILIAL AND
                                      STURMADISC.CODTURMA = STURMA.CODTURMA AND
                                      STURMADISC.IDPERLET = STURMA.IDPERLET)
                                JOIN SMATRICULA (NOLOCK)
                                  ON (SMATRICULA.CODCOLIGADA = STURMADISC.CODCOLIGADA AND
                                      SMATRICULA.IDTURMADISC = STURMADISC.IDTURMADISC)
                                JOIN SPLETIVO (NOLOCK)
                                  ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA AND
                                      SMATRICULA.IDPERLET = SPLETIVO.IDPERLET)
                                JOIN SSTATUS (NOLOCK)
                                  ON (SMATRICULA.CODCOLIGADA = SSTATUS.CODCOLIGADA AND
                                      SMATRICULA.CODSTATUS   = SSTATUS.CODSTATUS) 
                                JOIN STIPOCURSO (NOLOCK)
                                  ON STURMADISC.CODCOLIGADA = STIPOCURSO.CODCOLIGADA
                                    AND STURMADISC.CODTIPOCURSO = STIPOCURSO.CODTIPOCURSO
                                JOIN GFILIAL (NOLOCK)
                                  ON STURMADISC.CODCOLIGADA = GFILIAL.CODCOLIGADA
                                    AND STURMADISC.CODFILIAL = GFILIAL.CODFILIAL
                                LEFT JOIN SPARAM (NOLOCK) 
                                  ON (STURMA.CODCOLIGADA = SPARAM.CODCOLIGADA AND
                                      STURMA.CODFILIAL = SPARAM.CODFILIAL AND
                                      STURMA.CODTIPOCURSO = SPARAM.CODTIPOCURSO AND
                                      SPARAM.ID = 'UTITURMASUBTURMAIND') 
 WHERE SHORARIOTURMA.CODCOLIGADA = @CODCOLIGADA AND                              
                              SMATRICULA.RA = @RA AND
                              (STURMADISC.ESPELHO = 'N' OR STURMADISC.ESPELHO IS NULL)  AND
                              SPLETIVO.ENCERRADO = 'N' AND
                              STURMADISC.ATIVA = 'S' 
 AND 
          ( ( ( SPARAM.TEXTO = '1'
                  OR SPARAM.TEXTO = 'S' )
               AND ( ( SHORARIOTURMA.CODSUBTURMA IS NULL
                        OR SHORARIOTURMA.CODSUBTURMA = '' )
                      OR SHORARIOTURMA.CODSUBTURMA = SMATRICULA.CODSUBTURMA ) )
              OR ( ( SPARAM.TEXTO = '0'
                      OR SPARAM.TEXTO = 'N'
                      OR SPARAM.TEXTO IS NULL )
                   AND ( ( ( SHORARIOTURMA.CODSUBTURMA IS NULL
                              OR SHORARIOTURMA.CODSUBTURMA = '' )
                           AND NOT EXISTS (SELECT HORARIOSUBTURMA.CODSUBTURMA
                                           FROM   SHORARIOTURMA HORARIOSUBTURMA (NOLOCK)
                                           WHERE  HORARIOSUBTURMA.CODCOLIGADA = SHORARIOTURMA.CODCOLIGADA
                                                  AND HORARIOSUBTURMA.IDTURMADISC = SHORARIOTURMA.IDTURMADISC
                                                  AND HORARIOSUBTURMA.CODSUBTURMA = SMATRICULA.CODSUBTURMA) )
                          OR SHORARIOTURMA.CODSUBTURMA = SMATRICULA.CODSUBTURMA ) ) ) 
 AND STURMADISC.CODTIPOCURSO = @CODTIPOCURSO_N
 AND (SSTATUS.DIINCALUNODISC = 'S' OR SSTATUS.DIEMCURSO = 'S')
 AND (SMATRICULA.IDTURMADISCORIGEM IS NOT NULL
                               OR (SMATRICULA.IDTURMADISCORIGEM IS NULL AND SMATRICULA.IDTURMADISCPRINCIPAL IS NULL 
                                                                        AND NOT EXISTS(SELECT 1 FROM SMATRICULA TAB (NOLOCK)
                                                                                 WHERE TAB.RA = SMATRICULA.RA
                                                                                 AND TAB.IDTURMADISCORIGEM = STURMADISC.IDTURMADISC)))

SELECT DISTINCT GFILIAL.CODFILIAL,
GFILIAL.NOME AS UNIDADE, 
DIRETOR.NOME AS DIRETOR ,
/*'oneto@firjan.com.br' AS EMAILDIRETOR,*/
DIRETOR.EMAIL AS EMAILDIRETOR ,
SECRETARIO.NOME AS SECRETARIO ,
SECRETARIO.EMAIL AS EMAILSECRETARIO 
/*'cdores@firjan.com.br' AS  EMAILSECRETARIO*/

FROM SMATRICULA (NOLOCK)
INNER JOIN SALUNO (NOLOCK) ON 
 SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA
 AND SMATRICULA.RA = SALUNO.RA
INNER JOIN PPESSOA P (NOLOCK) ON 
 SALUNO.CODPESSOA = P.CODIGO
INNER JOIN SALUNOCOMPL (NOLOCK) ON 
 SALUNO.CODCOLIGADA = SALUNOCOMPL.CODCOLIGADA
 AND SALUNO.RA = SALUNOCOMPL.RA
INNER JOIN SMATRICPL (NOLOCK) ON 
 SMATRICULA.CODCOLIGADA = SMATRICPL.CODCOLIGADA
 AND SMATRICULA.IDHABILITACAOFILIAL = SMATRICPL.IDHABILITACAOFILIAL
 AND SMATRICULA.RA = SMATRICPL.RA
 AND SMATRICULA.IDPERLET = SMATRICPL.IDPERLET
INNER JOIN STURMADISC (NOLOCK) ON 
 SMATRICULA.CODCOLIGADA = STURMADISC.CODCOLIGADA
 AND SMATRICULA.IDHABILITACAOFILIAL = STURMADISC.IDHABILITACAOFILIAL
 AND SMATRICULA.IDTURMADISC = STURMADISC.IDTURMADISC
 AND SMATRICULA.IDPERLET = STURMADISC.IDPERLET
INNER JOIN SETAPAS N (NOLOCK) ON 
 STURMADISC.CODCOLIGADA = N.CODCOLIGADA
 AND STURMADISC.IDTURMADISC = N.IDTURMADISC
 AND N.TIPOETAPA = 'N'
 AND N.CODETAPA = 1
INNER JOIN STURMA (NOLOCK) ON 
 STURMA.CODCOLIGADA = STURMADISC.CODCOLIGADA
 AND STURMA.CODFILIAL = STURMADISC.CODFILIAL
 AND STURMA.CODTURMA = STURMADISC.CODTURMA
 AND STURMA.IDPERLET = STURMADISC.IDPERLET
 AND STURMA.CODFILIAL = SMATRICPL.CODFILIAL
 AND STURMA.CODTURMA = SMATRICPL.CODTURMA 
 
INNER JOIN GFILIAL (NOLOCK) 
 ON STURMA.CODCOLIGADA = GFILIAL.CODCOLIGADA
 AND STURMA.CODFILIAL = GFILIAL.CODFILIAL 

INNER JOIN SHABILITACAOFILIAL (NOLOCK) ON 
 STURMA.CODCOLIGADA = SHABILITACAOFILIAL.CODCOLIGADA
 AND STURMA.IDHABILITACAOFILIAL = SHABILITACAOFILIAL.IDHABILITACAOFILIAL

INNER JOIN SCURSO (NOLOCK) ON 
 SHABILITACAOFILIAL.CODCOLIGADA = SCURSO.CODCOLIGADA
 AND SHABILITACAOFILIAL.CODCURSO = SCURSO.CODCURSO
INNER JOIN SAREA (NOLOCK) ON 
 SCURSO.CODCOLIGADA = SAREA.CODCOLIGADA
 AND SCURSO.CODAREA = SAREA.CODAREA
INNER JOIN SMODALIDADECURSO (NOLOCK) ON 
 SCURSO.CODCOLIGADA = SMODALIDADECURSO.CODCOLIGADA
 AND SCURSO.CODMODALIDADECURSO = SMODALIDADECURSO.CODMODALIDADECURSO
INNER JOIN SDISCIPLINA (NOLOCK) ON 
 STURMADISC.CODCOLIGADA = SDISCIPLINA.CODCOLIGADA
 AND STURMADISC.CODDISC = SDISCIPLINA.CODDISC
 
LEFT OUTER JOIN DBO.SDIRECAOFILIAL (NOLOCK) 
 ON GFILIAL.CODCOLIGADA = SDIRECAOFILIAL.CODCOLIGADA
 AND GFILIAL.CODFILIAL = SDIRECAOFILIAL.CODFILIAL
 AND SDIRECAOFILIAL.DTFIM IS NULL
 
LEFT OUTER JOIN DBO.PPESSOA AS DIRETOR ( NOLOCK ) ON 
 DIRETOR.CODIGO = SDIRECAOFILIAL.CODPESSOA
LEFT OUTER JOIN DBO.PPESSOA AS SECRETARIO ( NOLOCK ) ON 
 SECRETARIO.CODIGO = SDIRECAOFILIAL.CODPESSOASEC1
 

INNER JOIN SPLETIVO (NOLOCK) ON 
 STURMA.CODCOLIGADA = SPLETIVO.CODCOLIGADA
 AND STURMA.IDPERLET = SPLETIVO.IDPERLET

LEFT JOIN SPROVAS P1 (NOLOCK) ON 
 N.CODCOLIGADA = P1.CODCOLIGADA
 AND N.IDTURMADISC = P1.IDTURMADISC
 AND N.CODETAPA = P1.CODETAPA
 AND N.TIPOETAPA = P1.TIPOETAPA
 AND P1.CODPROVA = 1
 
LEFT JOIN SPROVAS P2 (NOLOCK) ON 
 N.CODCOLIGADA = P2.CODCOLIGADA
 AND N.IDTURMADISC = P2.IDTURMADISC
 AND N.CODETAPA = P2.CODETAPA
 AND N.TIPOETAPA = P2.TIPOETAPA
 AND P2.CODPROVA = 2

LEFT JOIN SPROVAS P3 (NOLOCK) ON 
 N.CODCOLIGADA = P3.CODCOLIGADA
 AND N.IDTURMADISC = P3.IDTURMADISC
 AND N.CODETAPA = P3.CODETAPA
 AND N.TIPOETAPA = P3.TIPOETAPA
 AND P3.CODPROVA = 3


LEFT JOIN SNOTAS SNOTAS_ATIVIDADE1 (NOLOCK) ON 
 STURMADISC.CODCOLIGADA = SNOTAS_ATIVIDADE1.CODCOLIGADA
 AND STURMADISC.IDTURMADISC = SNOTAS_ATIVIDADE1.IDTURMADISC
 AND SMATRICULA.RA = SNOTAS_ATIVIDADE1.RA
 AND N.TIPOETAPA = SNOTAS_ATIVIDADE1.TIPOETAPA 
 AND P1.CODPROVA = SNOTAS_ATIVIDADE1.CODPROVA
 AND N.CODETAPA = SNOTAS_ATIVIDADE1.CODETAPA
 
LEFT JOIN SNOTAS SNOTAS_ATIVIDADE2 (NOLOCK) ON 
 STURMADISC.CODCOLIGADA = SNOTAS_ATIVIDADE2.CODCOLIGADA
 AND STURMADISC.IDTURMADISC = SNOTAS_ATIVIDADE2.IDTURMADISC
 AND SMATRICULA.RA = SNOTAS_ATIVIDADE2.RA
 AND N.TIPOETAPA = SNOTAS_ATIVIDADE2.TIPOETAPA 
 AND P2.CODPROVA = SNOTAS_ATIVIDADE2.CODPROVA
 AND N.CODETAPA = SNOTAS_ATIVIDADE2.CODETAPA
 
LEFT JOIN SNOTAS SNOTAS_ATIVIDADE3 (NOLOCK) ON 
 STURMADISC.CODCOLIGADA = SNOTAS_ATIVIDADE3.CODCOLIGADA
 AND STURMADISC.IDTURMADISC = SNOTAS_ATIVIDADE3.IDTURMADISC
 AND SMATRICULA.RA = SNOTAS_ATIVIDADE3.RA
 AND N.TIPOETAPA = SNOTAS_ATIVIDADE3.TIPOETAPA 
 AND P3.CODPROVA = SNOTAS_ATIVIDADE3.CODPROVA
 AND N.CODETAPA = SNOTAS_ATIVIDADE3.CODETAPA

WHERE STURMA.CODCOLIGADA = 3
AND YEAR(STURMADISC.DTFINAL) >= 2025
AND STURMADISC.DTFINAL < GETDATE()
AND SMATRICPL.CODSTATUS = 2
AND SMATRICPL.CODSTATUSRES IS NULL
AND SMATRICULA.CODSTATUS = 2
AND (
(P1.CODPROVA = 1 AND P2.CODPROVA IS NULL AND P3.CODPROVA IS NULL AND SNOTAS_ATIVIDADE1.NOTA IS NULL)
OR 
(P1.CODPROVA = 1 AND P2.CODPROVA = 2 AND P3.CODPROVA = 3 AND (SNOTAS_ATIVIDADE3.NOTA IS NULL OR SNOTAS_ATIVIDADE2.NOTA IS NULL OR SNOTAS_ATIVIDADE1.NOTA IS NULL))
)

SELECT SHORARIO.CODCOLIGADA,
                                 SHORARIO.CODHOR,
                                 SHORARIO.DIASEMANA,
                                 SHORARIO.HORAINICIAL,
                                 SHORARIO.HORAFINAL,
                                 STURMADISC.IDTURMADISC,
                                 STURMADISC.CODTURMA,
                                 SDISCIPLINA.NOMEREDUZIDO,
                                 SHORARIOTURMA.IDHORARIOTURMA,
                                 SHORARIOTURMA.DATAINICIAL,
                                 SHORARIOTURMA.DATAFINAL,
                                 SHORARIOTURMA.CODSUBTURMA,
                                 SDISCIPLINA.CODDISC,
                                 SDISCIPLINA.NOME,
                                 SCURSO.NOME                                                     CURSO,
                                 SHABILITACAO.NOME                                               HABILITACAO,
                                 STURMADISC.TIPO,
                                 COALESCE(SHORARIOTURMA.URLAULAONLINE, STURMADISC.URLAULAONLINE) URLAULAONLINE,
                                 CASE
                                   WHEN PREDIOHORARIOTURMA.CODPREDIO IS NOT NULL
                                         OR BLOCOHORARIOTURMA.CODBLOCO IS NOT NULL
                                         OR SALAHORARIOTURMA.CODSALA IS NOT NULL THEN CONCAT(CONCAT(PREDIOHORARIOTURMA.CODPREDIO, ' - '), PREDIOHORARIOTURMA.NOME)
                                   ELSE
                                     CASE
                                       WHEN PREDIOTURMADISC.CODPREDIO IS NOT NULL
                                             OR BLOCOTURMADISC.CODBLOCO IS NOT NULL
                                             OR SALATURMADISC.CODSALA IS NOT NULL THEN CONCAT(CONCAT(PREDIOTURMADISC.CODPREDIO, ' - '), PREDIOTURMADISC.NOME)
                                       ELSE
                                         CASE
                                           WHEN PREDIOTURMA.CODPREDIO IS NOT NULL
                                                 OR BLOCOTURMA.CODBLOCO IS NOT NULL
                                                 OR SALATURMA.CODSALA IS NOT NULL THEN CONCAT(CONCAT(PREDIOTURMA.CODPREDIO, ' - '), PREDIOTURMA.NOME)
                                         END
                                     END
                                 END                                                             AS NOMEPREDIO,
                                 CASE
                                   WHEN PREDIOHORARIOTURMA.CODPREDIO IS NOT NULL
                                         OR BLOCOHORARIOTURMA.CODBLOCO IS NOT NULL
                                         OR SALAHORARIOTURMA.CODSALA IS NOT NULL THEN
                                     CASE
                                       WHEN BLOCOHORARIOTURMA.DESCRICAO IS NOT NULL THEN CONCAT(CONCAT(BLOCOHORARIOTURMA.CODBLOCO, ' - '), BLOCOHORARIOTURMA.DESCRICAO)
                                       ELSE BLOCOHORARIOTURMA.CODBLOCO
                                     END
                                   ELSE
                                     CASE
                                       WHEN PREDIOTURMADISC.CODPREDIO IS NOT NULL
                                             OR BLOCOTURMADISC.CODBLOCO IS NOT NULL
                                             OR SALATURMADISC.CODSALA IS NOT NULL THEN
                                         CASE
                                           WHEN BLOCOTURMADISC.DESCRICAO IS NOT NULL THEN CONCAT(CONCAT(BLOCOTURMADISC.CODBLOCO, ' - '), BLOCOTURMADISC.DESCRICAO)
                                           ELSE BLOCOTURMADISC.CODBLOCO
                                         END
                                       ELSE
                                         CASE
                                           WHEN PREDIOTURMA.CODPREDIO IS NOT NULL
                                                 OR BLOCOTURMA.CODBLOCO IS NOT NULL
                                                 OR SALATURMA.CODSALA IS NOT NULL THEN
                                             CASE
                                               WHEN BLOCOTURMA.DESCRICAO IS NOT NULL THEN CONCAT(CONCAT(BLOCOTURMA.CODBLOCO, ' - '), BLOCOTURMA.DESCRICAO)
                                               ELSE BLOCOTURMA.CODBLOCO
                                             END
                                         END
                                     END
                                 END                                                             AS NOMEBLOCO,
                                 CASE
                                   WHEN PREDIOHORARIOTURMA.CODPREDIO IS NOT NULL
                                         OR BLOCOHORARIOTURMA.CODBLOCO IS NOT NULL
                                         OR SALAHORARIOTURMA.CODSALA IS NOT NULL THEN
                                     CASE
                                       WHEN SALAHORARIOTURMA.DESCRICAO IS NOT NULL THEN CONCAT(CONCAT(SALAHORARIOTURMA.CODSALA, ' - '), SALAHORARIOTURMA.DESCRICAO)
                                       ELSE SALAHORARIOTURMA.CODSALA
                                     END
                                   ELSE
                                     CASE
                                       WHEN PREDIOTURMADISC.CODPREDIO IS NOT NULL
                                             OR BLOCOTURMADISC.CODBLOCO IS NOT NULL
                                             OR SALATURMADISC.CODSALA IS NOT NULL THEN
                                         CASE
                                           WHEN SALATURMADISC.DESCRICAO IS NOT NULL THEN CONCAT(CONCAT(SALATURMADISC.CODSALA, ' - '), SALATURMADISC.DESCRICAO)
                                           ELSE SALATURMADISC.CODSALA
                                         END
                                       ELSE
                                         CASE
                                           WHEN PREDIOTURMA.CODPREDIO IS NOT NULL
                                                 OR BLOCOTURMA.CODBLOCO IS NOT NULL
                                                 OR SALATURMA.CODSALA IS NOT NULL THEN
                                             CASE
                                               WHEN SALATURMA.DESCRICAO IS NOT NULL THEN CONCAT(CONCAT(SALATURMA.CODSALA, ' - '), SALATURMA.DESCRICAO)
                                               ELSE SALATURMA.CODSALA
                                             END
                                         END
                                     END
                                 END                                                             AS NOMESALA
                         FROM   SHORARIOTURMA (NOLOCK)
                                 JOIN STURMADISC (NOLOCK)
                                   ON ( SHORARIOTURMA.CODCOLIGADA = STURMADISC.CODCOLIGADA
                                        AND SHORARIOTURMA.IDTURMADISC = STURMADISC.IDTURMADISC )
                                 JOIN STURMA (NOLOCK)
                                   ON STURMADISC.CODCOLIGADA = STURMA.CODCOLIGADA
                                      AND STURMADISC.CODFILIAL = STURMA.CODFILIAL
                                      AND STURMADISC.IDPERLET = STURMA.IDPERLET
                                      AND STURMADISC.CODTURMA = STURMA.CODTURMA
                                 JOIN SHORARIOPROFESSOR (NOLOCK)
                          ON ( SHORARIOTURMA.CODCOLIGADA = SHORARIOPROFESSOR.CODCOLIGADA 
                               AND SHORARIOTURMA.IDHORARIOTURMA = SHORARIOPROFESSOR.IDHORARIOTURMA )
                         JOIN SPROFESSORTURMA (NOLOCK)
                           ON  ( SHORARIOPROFESSOR.CODCOLIGADA = SPROFESSORTURMA.CODCOLIGADA 
                                AND SHORARIOPROFESSOR.IDPROFESSORTURMA = SPROFESSORTURMA.IDPROFESSORTURMA)
                                 JOIN SHORARIO (NOLOCK)
                                   ON ( SHORARIOTURMA.CODCOLIGADA = SHORARIO.CODCOLIGADA
                                        AND SHORARIOTURMA.CODHOR = SHORARIO.CODHOR )
                                 JOIN SPLETIVO (NOLOCK)
                                   ON ( SPLETIVO.CODCOLIGADA = STURMADISC.CODCOLIGADA
                                        AND SPLETIVO.IDPERLET = STURMADISC.IDPERLET )
                                 JOIN SDISCIPLINA (NOLOCK)
                                   ON ( STURMADISC.CODCOLIGADA = SDISCIPLINA.CODCOLIGADA
                                        AND STURMADISC.CODDISC = SDISCIPLINA.CODDISC )
                                 JOIN SPROFESSOR (NOLOCK)
                                   ON ( SPROFESSORTURMA.CODCOLIGADA = SPROFESSOR.CODCOLIGADA
                                        AND SPROFESSORTURMA.CODPROF = SPROFESSOR.CODPROF )
                                 JOIN PPESSOA (NOLOCK)
                                   ON ( SPROFESSOR.CODPESSOA = PPESSOA.CODIGO )
                                 LEFT JOIN SHABILITACAOFILIAL (NOLOCK)
                                        ON STURMADISC.CODCOLIGADA = SHABILITACAOFILIAL.CODCOLIGADA
                                           AND STURMADISC.IDHABILITACAOFILIAL = SHABILITACAOFILIAL.IDHABILITACAOFILIAL
                                 LEFT JOIN SHABILITACAO (NOLOCK)
                                        ON SHABILITACAOFILIAL.CODCOLIGADA = SHABILITACAO.CODCOLIGADA
                                           AND SHABILITACAOFILIAL.CODCURSO = SHABILITACAO.CODCURSO
                                           AND SHABILITACAOFILIAL.CODHABILITACAO = SHABILITACAO.CODHABILITACAO
                                 LEFT JOIN SCURSO (NOLOCK)
                                        ON SHABILITACAOFILIAL.CODCOLIGADA = SCURSO.CODCOLIGADA
                                           AND SHABILITACAOFILIAL.CODCURSO = SCURSO.CODCURSO
                                 LEFT JOIN SHORARIOTURMA SHORARIOSUBTUR(NOLOCK)
                                        ON ( SHORARIOTURMA.CODCOLIGADA = SHORARIOSUBTUR.CODCOLIGADA
                                             AND SHORARIOTURMA.IDHORARIOTURMA = SHORARIOSUBTUR.IDHORARIOTURMAVINC )
                                 LEFT JOIN SSALA SALAHORARIOTURMA (NOLOCK)
                                        ON SHORARIOTURMA.CODCOLIGADA = SALAHORARIOTURMA.CODCOLIGADA
                                           AND SHORARIOTURMA.CODFILIAL = SALAHORARIOTURMA.CODFILIAL
                                           AND SHORARIOTURMA.CODPREDIO = SALAHORARIOTURMA.CODPREDIO
                                           AND SHORARIOTURMA.CODSALA = SALAHORARIOTURMA.CODSALA
                                           AND SHORARIOTURMA.CODBLOCO = SALAHORARIOTURMA.CODBLOCO
                                 LEFT JOIN SBLOCO BLOCOHORARIOTURMA (NOLOCK)
                                        ON SHORARIOTURMA.CODCOLIGADA = BLOCOHORARIOTURMA.CODCOLIGADA
                                           AND SHORARIOTURMA.CODFILIAL = BLOCOHORARIOTURMA.CODFILIAL
                                           AND SHORARIOTURMA.CODPREDIO = BLOCOHORARIOTURMA.CODPREDIO
                                           AND SHORARIOTURMA.CODBLOCO = BLOCOHORARIOTURMA.CODBLOCO
                                 LEFT JOIN SPREDIO PREDIOHORARIOTURMA (NOLOCK)
                                        ON SHORARIOTURMA.CODCOLIGADA = PREDIOHORARIOTURMA.CODCOLIGADA
                                           AND SHORARIOTURMA.CODFILIAL = PREDIOHORARIOTURMA.CODFILIAL
                                           AND SHORARIOTURMA.CODPREDIO = PREDIOHORARIOTURMA.CODPREDIO
                                 LEFT JOIN SSALA SALATURMADISC (NOLOCK)
                                        ON STURMADISC.CODCOLIGADA = SALATURMADISC.CODCOLIGADA
                                           AND STURMADISC.CODFILIAL = SALATURMADISC.CODFILIAL
                                           AND STURMADISC.CODPREDIO = SALATURMADISC.CODPREDIO
                                           AND STURMADISC.CODSALA = SALATURMADISC.CODSALA
                                           AND STURMADISC.CODBLOCO = SALATURMADISC.CODBLOCO
                                 LEFT JOIN SBLOCO BLOCOTURMADISC (NOLOCK)
                                        ON STURMADISC.CODCOLIGADA = BLOCOTURMADISC.CODCOLIGADA
                                           AND STURMADISC.CODFILIAL = BLOCOTURMADISC.CODFILIAL
                                           AND STURMADISC.CODPREDIO = BLOCOTURMADISC.CODPREDIO
                                           AND STURMADISC.CODBLOCO = BLOCOTURMADISC.CODBLOCO
                                 LEFT JOIN SPREDIO PREDIOTURMADISC (NOLOCK)
                                        ON STURMADISC.CODCOLIGADA = PREDIOTURMADISC.CODCOLIGADA
                                           AND STURMADISC.CODFILIAL = PREDIOTURMADISC.CODFILIAL
                                           AND STURMADISC.CODPREDIO = PREDIOTURMADISC.CODPREDIO
                                 LEFT JOIN SSALA SALATURMA (NOLOCK)
                                        ON STURMA.CODCOLIGADA = SALATURMA.CODCOLIGADA
                                           AND STURMA.CODFILIAL = SALATURMA.CODFILIAL
                                           AND STURMA.CODPREDIO = SALATURMA.CODPREDIO
                                           AND STURMA.CODSALA = SALATURMA.CODSALA
                                           AND STURMA.CODBLOCO = SALATURMA.CODBLOCO
                                 LEFT JOIN SBLOCO BLOCOTURMA (NOLOCK)
                                        ON STURMA.CODCOLIGADA = BLOCOTURMA.CODCOLIGADA
                                           AND STURMA.CODFILIAL = BLOCOTURMA.CODFILIAL
                                           AND STURMA.CODPREDIO = BLOCOTURMA.CODPREDIO
                                           AND STURMA.CODBLOCO = BLOCOTURMA.CODBLOCO
                                 LEFT JOIN SPREDIO PREDIOTURMA (NOLOCK)
                                        ON STURMA.CODCOLIGADA = PREDIOTURMA.CODCOLIGADA
                                           AND STURMA.CODFILIAL = PREDIOTURMA.CODFILIAL
                                           AND STURMA.CODPREDIO = PREDIOTURMA.CODPREDIO
                          WHERE  SPLETIVO.ENCERRADO = 'N'
                                 AND SPLETIVO.EXIBIRPORTAL = 'S'
                                 AND STURMADISC.ATIVA = 'S'
                                 AND SPROFESSORTURMA.CODCOLIGADA = @CODCOLIGADA
                                 AND PPESSOA.CODUSUARIO = @CODUSUARIO
                                      AND STURMADISC.CODFILIAL = 392 AND STURMADISC.CODTIPOCURSO  = 1 
                                     /*AND*/ 
                                      AND ((STURMADISC.GERENCIAL = 'S') OR 
                                                            (STURMADISC.IDTURMADISC NOT IN 
                                                                       (SELECT IDTURMADISCGERENCIADA 
                                                        FROM STURMADISCGERENCIADA (NOLOCK)
                                                        WHERE CODCOLIGADA = 3)))ORDER BY SHORARIO.HORAINICIAL,
                                  SHORARIO.HORAFINAL,
                                  SHORARIO.DIASEMANA,
                                  SHORARIOTURMA.CODSUBTURMA,
                                  SHORARIOTURMA.DATAINICIAL

SELECT DISTINCT 
                             SALUNO.RA,
                             SALUNO.CODCOLIGADA,
                             NULL                                     CODFILIAL,
                      NULL                                     CODTIPOCURSO,
                              (CASE
                     WHEN (RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOA.NOME))
                     ELSE RTRIM(LTRIM(PPESSOA.NOMESOCIAL))
                  END)   NOMEALUNO,
                             PPESSOA.DTNASCIMENTO                     DTNASCIMENTOALUNO,
                             PPESSOA.CODUSUARIO                       CODUSUARIOALUNO,
                             PPESSOA.CODIGO                           CODPESSOAUSUARIO,
                             NULL                                     CODUSUARIOPAI,
                             NULL                                     NOMEPAI,
                             NULL                                     CODUSUARIOMAE,
                             NULL                                     NOMEMAE,
                             NULL                                     CODUSUARIORACA,
                             NULL                                     NOMERACA,
                             NULL                                     CODUSUARIORESPFINANCEIRO,
                             NULL                                     NOMERESPFINANCEIRO,
                             NULL                                     CODCOLIGADACFO,
                             NULL                                     CODCFO,
                             NULL                                     CODUSUARIORESPCONTRATO,
                             NULL                                     NOMERESPCONTRATO,
                             NULL                                     CODUSUARIORESPPARCELA,
                             NULL                                     NOMERESPPARCELA,
                             NULL                                     ACESSOACADEMICOSCFO,
                             'S'        DADOSACADEMICOS,
                             'S'        DADOSFINANCEIROS,
                             NULL                                     IDIMAGEMPAI,
                             NULL                                     IDIMAGEMMAE,
                             NULL                                     IDIMAGEMACAD,
                             NULL                                     IDIMAGEMFIN,
                             NULL                                     IDIMAGEMCONT,
                             PPESSOA.IDIMAGEM                         IDIMAGEM,
                             SALUNO.CODCOLCFO CODCOLCFOALUNO,
                             SALUNO.CODCFO CODCFOALUNO
                      FROM   SALUNO (NOLOCK)
                             JOIN PPESSOA (NOLOCK)
                               ON SALUNO.CODPESSOA = PPESSOA.CODIGO
                      LEFT JOIN SMATRICPL (NOLOCK)
                       ON SMATRICPL.CODCOLIGADA = SALUNO.CODCOLIGADA AND 
                          SMATRICPL.RA = SALUNO.RA
                      WHERE  (PPESSOA.CODUSUARIO = @CODUSUARIO) /*AND*/

                      UNION
                      SELECT DISTINCT SALUNO.RA,
                             SALUNO.CODCOLIGADA,
                             NULL                                             CODFILIAL,
                      NULL                                             CODTIPOCURSO,
                              (CASE
                     WHEN (RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOA.NOME))
                     ELSE RTRIM(LTRIM(PPESSOA.NOMESOCIAL))
                  END)           NOMEALUNO,
                             PPESSOA.DTNASCIMENTO                             DTNASCIMENTOALUNO,
                             PPESSOA.CODUSUARIO                               CODUSUARIOALUNO,
                             PPESSOARACA.CODIGO                               CODPESSOAUSUARIO,
                             NULL                                             CODUSUARIOPAI,
                             NULL                                             NOMEPAI,
                             NULL                                             CODUSUARIOMAE,
                             NULL                                             NOMEMAE,
                             PPESSOARACA.CODUSUARIO                           CODUSUARIORACA,
                              (CASE
                     WHEN (RTRIM(LTRIM(PPESSOARACA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOARACA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOARACA.NOME))
                     ELSE RTRIM(LTRIM(PPESSOARACA.NOMESOCIAL))
                  END)   NOMERACA,
                             NULL                                             CODUSUARIORESPFINANCEIRO,
                             NULL                                             NOMERESPFINANCEIRO,
                             NULL                                             CODCOLIGADACFO,
                             NULL                                             CODCFO,
                             NULL                                             CODUSUARIORESPCONTRATO,
                             NULL                                             NOMERESPCONTRATO,
                             NULL                                             CODUSUARIORESPPARCELA,
                             NULL                                             NOMERESPPARCELA,
                             NULL                                             ACESSOACADEMICOSCFO,
                             'S'                DADOSACADEMICOS,
                             CASE
                                WHEN SCONTRATOACESSOS.CODPESSOA IS NOT NULL THEN 'S'
                                ELSE 'N'
                             END DADOSFINANCEIROS,                             
                             NULL                                             IDIMAGEMPAI,
                             NULL                                             IDIMAGEMMAE,
                             PPESSOARACA.IDIMAGEM                             IDIMAGEMACAD,
                             NULL                                             IDIMAGEMFIN,
                             NULL                                             IDIMAGEMCONT,
                             PPESSOA.IDIMAGEM                                 IDIMAGEM,
                             SALUNO.CODCOLCFO                                 CODCOLCFOALUNO,
                             SALUNO.CODCFO                                    CODCFOALUNO
                      FROM   SALUNO (NOLOCK)
                             LEFT JOIN PPESSOA PPESSOARACA (NOLOCK)
                                    ON (SALUNO.CODPESSOARACA = PPESSOARACA.CODIGO)
                             JOIN PPESSOA (NOLOCK)
                               ON SALUNO.CODPESSOA = PPESSOA.CODIGO
                             LEFT JOIN SCONTRATOACESSOS (NOLOCK)
                               ON SALUNO.RA = SCONTRATOACESSOS.RA AND
                                  SALUNO.CODPESSOARACA = SCONTRATOACESSOS.CODPESSOA AND                                   
                                  SCONTRATOACESSOS.TIPORELACIONAMENTO = 'A'                                                     
                      LEFT JOIN SMATRICPL (NOLOCK)
                       ON SMATRICPL.CODCOLIGADA = SALUNO.CODCOLIGADA AND 
                          SMATRICPL.RA = SALUNO.RA
                      WHERE  (PPESSOARACA.CODUSUARIO = @CODUSUARIO
                               AND (PPESSOARACA.CODIGO <> PPESSOA.CODIGO
                                      OR PPESSOARACA.CODIGO IS NULL)) /*AND*/

                      UNION
                      SELECT DISTINCT SALUNO.RA,
                                      SALUNO.CODCOLIGADA                        CODCOLIGADA,
                                      NULL                                      CODFILIAL,
                                      NULL                                      CODTIPOCURSO,
                                       (CASE
                     WHEN (RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOA.NOME))
                     ELSE RTRIM(LTRIM(PPESSOA.NOMESOCIAL))
                  END)    NOMEALUNO,
                                      PPESSOA.DTNASCIMENTO                      DTNASCIMENTOALUNO,
                                      PPESSOA.CODUSUARIO                        CODUSUARIOALUNO,
                                      PPESSOAFILIACAO.CODIGO                    CODPESSOAUSUARIO,
                                      CASE
                                        WHEN VFILIACAO.TIPORELACIONAMENTO = 'P' THEN PPESSOAFILIACAO.CODUSUARIO
                                        ELSE NULL
                                      END                    CODUSUARIOPAI,
                                      CASE
                                        WHEN VFILIACAO.TIPORELACIONAMENTO = 'P' THEN  (CASE
                     WHEN (RTRIM(LTRIM(PPESSOAFILIACAO.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOAFILIACAO.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOAFILIACAO.NOME))
                     ELSE RTRIM(LTRIM(PPESSOAFILIACAO.NOMESOCIAL))
                  END) 
                                        ELSE NULL
                                      END                    NOMEPAI,
                                      CASE
                                        WHEN VFILIACAO.TIPORELACIONAMENTO = 'M' THEN PPESSOAFILIACAO.CODUSUARIO
                                        ELSE NULL
                                      END                    CODUSUARIOMAE,
                                      CASE
                                        WHEN VFILIACAO.TIPORELACIONAMENTO = 'M' THEN  (CASE
                     WHEN (RTRIM(LTRIM(PPESSOAFILIACAO.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOAFILIACAO.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOAFILIACAO.NOME))
                     ELSE RTRIM(LTRIM(PPESSOAFILIACAO.NOMESOCIAL))
                  END) 
                                        ELSE NULL
                                      END                    NOMEMAE,
                                      NULL                   CODUSUARIORACA,
                                      NULL                   NOMERACA,
                                      NULL                   CODUSUARIORESPFINANCEIRO,
                                      NULL                   NOMERESPFINANCEIRO,
                                      NULL                   CODCOLIGADACFO,
                                      NULL                   CODCFO,
                                      NULL                   CODUSUARIORESPCONTRATO,
                                      NULL                   NOMERESPCONTRATO,
                                      NULL                   CODUSUARIORESPPARCELA,
                                      NULL                   NOMERESPPARCELA,
                                      NULL                   ACESSOACADEMICOSCFO,
                                      COALESCE((SFILIACAO.DADOSACADEMICOS), 'N')  DADOSACADEMICOS,
                                      CASE
                                          WHEN SCONTRATOACESSOS.CODPESSOA IS NOT NULL THEN 'S'
                                          ELSE 'N'
                                      END DADOSFINANCEIROS,
                                      CASE
                                        WHEN VFILIACAO.TIPORELACIONAMENTO = 'P' THEN PPESSOAFILIACAO.IDIMAGEM
                                        ELSE NULL
                                      END                    IDIMAGEMPAI,
                                      CASE
                                        WHEN VFILIACAO.TIPORELACIONAMENTO = 'M' THEN PPESSOAFILIACAO.IDIMAGEM
                                        ELSE NULL
                                      END                    IDIMAGEMMAE,
                                      NULL                   IDIMAGEMACAD,
                                      NULL                   IDIMAGEMFIN,
                                      NULL                   IDIMAGEMCONT,
                                      PPESSOA.IDIMAGEM       IDIMAGEM,
                                      SALUNO.CODCOLCFO CODCOLCFOALUNO,
                                      SALUNO.CODCFO CODCFOALUNO
                      FROM   SALUNO (NOLOCK)
                             JOIN PPESSOA (NOLOCK)
                               ON SALUNO.CODPESSOA = PPESSOA.CODIGO
                             LEFT JOIN VFILIACAO (NOLOCK)
                                       LEFT JOIN PPESSOA PPESSOAFILIACAO (NOLOCK)
                                              ON PPESSOAFILIACAO.CODIGO = VFILIACAO.CODPESSOAFILIACAO
                                                 AND VFILIACAO.TIPORELACIONAMENTO IN ('P', 'M')
                                    ON VFILIACAO.CODPESSOAFILHO = SALUNO.CODPESSOA
                             LEFT JOIN SFILIACAO (NOLOCK)
                                    ON SFILIACAO.CODFILIACAO = VFILIACAO.CODFILIACAO                             
                             LEFT JOIN SCONTRATOACESSOS (NOLOCK)
                                    ON SCONTRATOACESSOS.RA = SALUNO.RA AND
                                       SCONTRATOACESSOS.CODPESSOA = VFILIACAO.CODPESSOAFILIACAO AND                                       
                                       SCONTRATOACESSOS.TIPORELACIONAMENTO IN ('P', 'M')                             
                      WHERE  (PPESSOAFILIACAO.CODUSUARIO = @CODUSUARIO) /*AND*/

                      UNION
                      SELECT DISTINCT SALUNO.RA,
                             SALUNO.CODCOLIGADA                         CODCOLIGADA,
                             NULL                                       CODFILIAL,
                             NULL                                       CODTIPOCURSO,
                              (CASE
                     WHEN (RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOA.NOME))
                     ELSE RTRIM(LTRIM(PPESSOA.NOMESOCIAL))
                  END)     NOMEALUNO,
                             PPESSOA.DTNASCIMENTO                       DTNASCIMENTOALUNO,
                             PPESSOA.CODUSUARIO                         CODUSUARIOALUNO,
                             NULL                                       CODPESSOAUSUARIO,
                             NULL                                       CODUSUARIOPAI,
                             NULL                                       NOMEPAI,
                             NULL                                       CODUSUARIOMAE,
                             NULL                                       NOMEMAE,
                             NULL                                       CODUSUARIORACA,
                             NULL                                       NOMERACA,
                             FCFOALUNO.CODUSUARIOACESSO                 CODUSUARIORESPFINANCEIRO,
                             FCFOALUNO.NOMEFANTASIA                     NOMERESPFINANCEIRO,
                             FCFOALUNO.CODCOLIGADA                      CODCOLIGADACFO,
                             FCFOALUNO.CODCFO                           CODCFO,
                             NULL                                       CODUSUARIORESPCONTRATO,
                             NULL                                       NOMERESPCONTRATO,
                             NULL                                       CODUSUARIORESPPARCELA,
                             NULL                                       NOMERESPPARCELA,
                             SALUNO.DADOSACADEMICOSCFO                  ACESSOACADEMICOSCFO,
                             'N'          DADOSACADEMICOS,
                             CASE
                                WHEN SCONTRATOACESSOS.CODCFO IS NOT NULL THEN 'S'
                                ELSE 'N'
                             END DADOSFINANCEIROS,
                             NULL                                       IDIMAGEMPAI,
                             NULL                                       IDIMAGEMMAE,
                             NULL                                       IDIMAGEMACAD,
                             NULL                                       IDIMAGEMFIN,
                             NULL                                       IDIMAGEMCONT,
                             PPESSOA.IDIMAGEM                           IDIMAGEM,
                             SALUNO.CODCOLCFO                           CODCOLCFOALUNO,
                             SALUNO.CODCFO                              CODCFOALUNO
                      FROM   SALUNO (NOLOCK)
                             JOIN SPESSOA (NOLOCK)
                               ON SALUNO.CODPESSOA = SPESSOA.CODIGO
                             JOIN PPESSOA (NOLOCK)
                               ON SALUNO.CODPESSOA = PPESSOA.CODIGO
                             LEFT JOIN FCFO FCFOALUNO (NOLOCK)
                                    ON SALUNO.CODCOLCFO = FCFOALUNO.CODCOLIGADA
                                       AND SALUNO.CODCFO = FCFOALUNO.CODCFO
                             LEFT JOIN SCONTRATOACESSOS (NOLOCK)
                                    ON SCONTRATOACESSOS.RA = SALUNO.RA AND
                                       SCONTRATOACESSOS.CODCOLCFO = FCFOALUNO.CODCOLIGADA AND
                                       SCONTRATOACESSOS.CODCFO = FCFOALUNO.CODCFO AND
                                       SCONTRATOACESSOS.TIPORELACIONAMENTO = 'F'
                      LEFT JOIN SMATRICPL (NOLOCK)
                       ON SMATRICPL.CODCOLIGADA = SALUNO.CODCOLIGADA AND 
                          SMATRICPL.RA = SALUNO.RA
                      WHERE  (FCFOALUNO.CODUSUARIOACESSO = @CODUSUARIO
                              AND (FCFOALUNO.CODUSUARIOACESSO <> PPESSOA.CODUSUARIO
                                    OR PPESSOA.CODUSUARIO IS NULL))

SELECT target_data
         FROM sys.dm_xe_session_targets xet WITH(nolock)
         JOIN sys.dm_xe_sessions xes WITH(nolock)
         ON xes.address = xet.event_session_address
         WHERE xes.name = 'telemetry_xevents'
         AND xet.target_name = 'ring_buffer'

select * from SNOTAETAPA (nolock)

WITH MATRICULAS AS (
    SELECT
        SM.CODCOLIGADA,
        SM.CODFILIAL,
        SM.IDPERLET,
        SM.CODTURMA,
        SM.RA,
        SC.CODMODALIDADECURSO
    FROM DBO.SMATRICPL SM
    INNER JOIN DBO.STURMA ST
        ON SM.CODCOLIGADA = ST.CODCOLIGADA
       AND SM.CODFILIAL   = ST.CODFILIAL
       AND SM.CODTURMA    = ST.CODTURMA
       AND SM.IDPERLET    = ST.IDPERLET
    INNER JOIN DBO.SHABILITACAOFILIAL SHF
        ON ST.CODCOLIGADA   = SHF.CODCOLIGADA
       AND ST.IDHABILITACAOFILIAL = SHF.IDHABILITACAOFILIAL
    INNER JOIN DBO.SCURSO SC
        ON SHF.CODCOLIGADA = SC.CODCOLIGADA
       AND SHF.CODCURSO    = SC.CODCURSO
    INNER JOIN DBO.SPLETIVO L
        ON L.CODCOLIGADA = SM.CODCOLIGADA
       AND L.CODFILIAL   = SM.CODFILIAL
       AND L.IDPERLET    = SM.IDPERLET
    INNER JOIN DBO.SSTATUS S
        ON S.CODCOLIGADA   = SM.CODCOLIGADA
       AND S.CODSTATUS     = SM.CODSTATUS
       AND S.CODTIPOCURSO  = L.CODTIPOCURSO
    WHERE 
    

 

      SM.CODCOLIGADA = 2
     /* AND L.DTINICIO BETWEEN
            DATEFROMPARTS(YEAR(GETDATE()), 1, 1)
        AND DATEADD(DAY, -1, DATEFROMPARTS(YEAR(GETDATE())+1, 1, 1))
      AND SC.CODMODALIDADECURSO IN (1, 9, 10)
      AND (
           (S.CODTIPOCURSO = 1 AND SM.CODSTATUS = 2)
        /*OR (S.CODTIPOCURSO = 3 AND SM.CODSTATUS = 39)*/
      )*/
),
RANKED AS (
    SELECT
        RM.*,
        ROW_NUMBER() OVER (
            PARTITION BY RM.RA
            ORDER BY RM.CODMODALIDADECURSO
        ) AS RN
    FROM MATRICULAS RM
)
SELECT
    CONCAT(R.CODCOLIGADA, R.RA)                           AS IDENTIFICADOR,
    CONCAT(R.CODCOLIGADA, R.CODFILIAL)                    AS IDENTIFICADORESCOLA,
    LOWER(ISNULL(SCP.CODALUNOSCAE, M.VC_NR_MATRICULA) + '@ALUNO.FIRJANSENAISESI.COM.BR') AS USUARIO,
    'Abc@1234'                                            AS SENHA,
    P.NOME                                                AS NOMECOMPLETO,
    P.ESTADO                                              AS UF,
    CAST(P.DTNASCIMENTO AS DATE)                          AS DATANASCIMENTO,
    R.CODMODALIDADECURSO                                  AS CODMODALIDADECURSO
FROM RANKED R
JOIN DBO.SALUNO A
    ON A.RA          = R.RA
   AND A.CODCOLIGADA = R.CODCOLIGADA
JOIN DBO.PPESSOA P
    ON P.CODIGO = A.CODPESSOA
LEFT JOIN DBO.SALUNOCOMPL SCP
    ON SCP.CODCOLIGADA = A.CODCOLIGADA
   AND SCP.RA          = A.RA
LEFT JOIN [LNK_CORPORATIVO].PRODUCAO.DBO.PESSOADOCUMENTACAO PD
    ON P.CPF = PD.VC_NR_CPF_PESSOADOC
LEFT JOIN [LNK_CORPORATIVO].PRODUCAO.DBO.PESSOA P2
    ON P2.IN_SQ_PESSOA = PD.IN_SQ_PESSOA
LEFT JOIN [LNK_CORPORATIVO].PRODUCAO.DBO.MATRICULA M
    ON P2.IN_SQ_PESSOA = M.IN_SQ_PESSOA
WHERE R.RN = 1

The job succeeded.  The Job was invoked by Schedule 17 ([SCH 01] - Ajuste CUBO).  The last step to run was step 5 ([STEP 03] - CREATE PROC SP_SCAE_2017).

The job succeeded.  The Job was invoked by Schedule 20 ([SCH 01] - Copia dos Arquivos de Backup).  The last step to run was step 1 ([STP 01] - Copia arquivo de Backup).

The job succeeded.  The Job was invoked by Schedule 16 (CHECKDB Diario - Schedule - SGE).  The last step to run was step 1 (STEP 01 - CHECKDB Physical - SGE).

The job succeeded.  The Job was invoked by User SISTEMAFIRJAN\vdutra.adm.  The last step to run was step 4 (STP 04 - DB_Growth_History_Detail).  The job was requested to start at step 1 (STP 01 - DB_Growth_History).

The job succeeded.  The Job was invoked by Schedule 15 (10 em 10 Minutos).  The last step to run was step 1 (Kill).

The job succeeded.  The Job was invoked by Schedule 14 (SCH 01 - Limpa TempDB).  The last step to run was step 10 (STEP 10).

The job succeeded.  The Job was invoked by Schedule 18 ([STEP 01] - AGENDAMENTO).  The last step to run was step 1 ([STEP 01] - MANUTEN��O DE �NDICES).

The job succeeded.  The Job was invoked by Schedule 19 ([STEP 01] - SCH Update STATISTICS).  The last step to run was step 1 ([STEP 01] - EXEC Update STATISTICS).

The job succeeded.  The Job was invoked by Schedule 10 (Backup DIFF.Subplan_1).  The last step to run was step 1 (Subplan_1).

The job succeeded.  The Job was invoked by Schedule 9 (DBA Backup FULL.Subplan_1).  The last step to run was step 1 (Subplan_1).

The job succeeded.  The Job was invoked by Schedule 11 (DBA Backup LOG.Subplan_1).  The last step to run was step 1 (Subplan_1).

The job succeeded.  The Job was invoked by Schedule 8 (syspolicy_purge_history_schedule).  The last step to run was step 3 (Erase Phantom System Health Records.).

ALTER INDEX [PKSTURMACOMPL] ON [dbo].[STURMACOMPL] REBUILD

ALTER INDEX [PKGUSRPAR] ON [dbo].[GUSRPAR] REBUILD

ALTER INDEX [PKFLOGSESSAOCAIXA] ON [dbo].[FLOGSESSAOCAIXA] REBUILD

ALTER INDEX [PKFBOLETOHISTORICO] ON [dbo].[FBOLETOHISTORICO] REBUILD

ALTER INDEX [PKSASSINATURACONTRATO] ON [dbo].[SASSINATURACONTRATO] REBUILD

ALTER INDEX [PKSSTATUS] ON [dbo].[SSTATUS] REBUILD

ALTER INDEX [PKGFORMULA] ON [dbo].[GFORMULA] REBUILD

ALTER INDEX [PKGBKDETAILACTIONPREF] ON [dbo].[GBKDETAILACTIONPREF] REBUILD

ALTER INDEX [PKSHISTALUNOCOL] ON [dbo].[SHISTALUNOCOL] REBUILD

ALTER INDEX [PKSATIVIDADEPESSOA] ON [dbo].[SATIVIDADEPESSOA] REBUILD

ALTER INDEX [PKSPLETIVO] ON [dbo].[SPLETIVO] REBUILD

ALTER INDEX [PKSPROVAS] ON [dbo].[SPROVAS] REBUILD

ALTER INDEX [PKGJOBXLOG] ON [dbo].[GJOBXLOG] REBUILD

ALTER INDEX [PKSDISCNAOAPROVEITADAS] ON [dbo].[SDISCNAOAPROVEITADAS] REBUILD

ALTER INDEX [PKGWORKFLOW] ON [dbo].[GWORKFLOW] REBUILD

ALTER INDEX [PKSHABILITACAOALUNO] ON [dbo].[SHABILITACAOALUNO] REBUILD

ALTER INDEX [PKGRELBATCH] ON [dbo].[GRELBATCH] REBUILD

ALTER INDEX [PKGJOBLOG] ON [dbo].[GJOBLOG] REBUILD

ALTER INDEX [PKSPLANOAULA] ON [dbo].[SPLANOAULA] REBUILD

ALTER INDEX [PKGDEFCOMPL] ON [dbo].[GDEFCOMPL] REBUILD

ALTER INDEX [PKSHABILITACAO] ON [dbo].[SHABILITACAO] REBUILD

ALTER INDEX [<Name of Missing Index, sysname,>] ON [dbo].[SFREQUENCIA] REBUILD

ALTER INDEX [PKSMATRICPLCOMPL] ON [dbo].[SMATRICPLCOMPL] REBUILD

ALTER INDEX [PKSNOTASCOMENTARIO] ON [dbo].[SNOTASCOMENTARIO] REBUILD

ALTER INDEX [PKSHISTHABILITACAOALUNO] ON [dbo].[SHISTHABILITACAOALUNO] REBUILD

ALTER INDEX [PKSCURSOCOMPL] ON [dbo].[SCURSOCOMPL] REBUILD

ALTER INDEX [PKGJOBX] ON [dbo].[GJOBX] REBUILD

ALTER INDEX [<Name of Missing Index, sysname,>] ON [dbo].[SHORARIOPROFESSOR] REBUILD

ALTER INDEX [PKFTEMPLATEACORDO] ON [dbo].[FTEMPLATEACORDO] REBUILD

ALTER INDEX [PK_ZINTPSESIFUNCIONARIOPERFIL] ON [dbo].[ZINTPSESIFUNCIONARIOPERFIL] REBUILD

ALTER INDEX [IXSHISTDISCEQUIVCONCLUIDAS] ON [dbo].[SHISTDISCEQUIVCONCLUIDAS] REBUILD

ALTER INDEX [ZXZSCAEMOBILIDADE_ISOLADA] ON [dbo].[ZSCAEMOBILIDADE_ISOLADA] REBUILD

ALTER INDEX [PKGETD] ON [dbo].[GETD] REBUILD

ALTER INDEX [PK__ZMDMONIT__D28B1EA02BB59AA6] ON [dbo].[ZMDMONITORERROSN] REBUILD

ALTER INDEX [PK_ZGOOGLEINTPERIODOMAT] ON [dbo].[ZGOOGLEINTPERIODOMAT] REBUILD

ALTER INDEX [PK__ZMDMONIT__D03F98E656F21E20] ON [dbo].[ZMDMONITOREXECSN] REBUILD

ALTER INDEX [PK__ZMDMONIT__D03F98E617DB4C91] ON [dbo].[ZMDMONITOREXECSS] REBUILD

ALTER INDEX [PKBOBJETOAVALIADO] ON [dbo].[BOBJETOAVALIADO] REBUILD

ALTER INDEX [IDX_ZGOOGLEINTATIVIEXTRA] ON [dbo].[ZGOOGLEINTATIVIEXTRA] REBUILD

ALTER INDEX [PKSZSUSCLINICA] ON [dbo].[SZSUSCLINICA] REBUILD

ALTER INDEX [PK_ZTEMPLATEPARAMSEGNIVPROPOB] ON [dbo].[ZTEMPLATEPARAMSEGNIVELPROPOBJ] REBUILD

ALTER INDEX [PKSEQUIVALENCIAHABILITACAOALUN] ON [dbo].[SEQUIVALENCIAHABILITACAOALUNO] REBUILD

ALTER INDEX [PKSRESPONSAVELCONTRATO] ON [dbo].[SRESPONSAVELCONTRATO] REBUILD

ALTER INDEX [PKTFORMAPAGTO] ON [dbo].[TFORMAPAGTO] REBUILD

ALTER INDEX [PKTITMEVC] ON [dbo].[TITMEVC] REBUILD

ALTER INDEX [PKSPSLOCAL] ON [dbo].[SPSLOCAL] REBUILD

ALTER INDEX [PKHALARME] ON [dbo].[HALARME] REBUILD

ALTER INDEX [PKSBOLSACOMPL] ON [dbo].[SBOLSACOMPL] REBUILD

ALTER INDEX [PKVAGENTESNOCIVOS] ON [dbo].[VAGENTESNOCIVOS] REBUILD

ALTER INDEX [PKGGATILHOWORKFLOW] ON [dbo].[GGATILHOWORKFLOW] REBUILD

(@CODUSUARIO nvarchar(4000)) SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;SELECT CODCOLIGADA, CODUSUARIO, CODSISTEMA, CODPERFIL, INDICE, CONTROLE 
                       FROM GUSRPERFIL (NOLOCK) WHERE CODUSUARIO = @CODUSUARIO ORDER BY INDICE

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="(@CODUSUARIO nvarchar(4000)) SET FMTONLY OFF; " StatementId="1" StatementCompId="1" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET NO_BROWSETABLE ON; " StatementId="2" StatementCompId="2" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET FMTONLY ON;" StatementId="3" StatementCompId="3" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SELECT CODCOLIGADA, CODUSUARIO, CODSISTEMA, CODPERFIL, INDICE, CONTROLE &#x0D;&#x0A;                       FROM GUSRPERFIL (NOLOCK) WHERE CODUSUARIO = @CODUSUARIO ORDER BY INDICE" StatementId="4" StatementCompId="4" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="3.36346" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xAF062DB1E91366FC" QueryPlanHash="0xB9E1ED383DCE7D46" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="200"><ThreadStat Branches="1"/><Warnings><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(20),[CorporeRM].[dbo].[GUSRPERFIL].[CODUSUARIO],0)=[@CODUSUARIO]"/></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" GrantedMemory="0" MaxUsedMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419430" EstimatedPagesCached="419430" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="47827984"/><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100038" AvgRowSize="38" EstimatedTotalSubtreeCost="3.36346" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODCOLIGADA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODUSUARIO"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODSISTEMA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODPERFIL"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="INDICE"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CONTROLE"/></OutputList><MemoryFractions Input="1" Output="1"/><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="INDICE"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285062" AvgRowSize="38" EstimatedTotalSubtreeCost="3.3521" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODCOLIGADA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODUSUARIO"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODSISTEMA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CODPERFIL"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="INDICE"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Column="CONTROLE"/></OutputList><Parallelism><RelOp NodeId="3" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1" EstimatedRowsRead="1.32841e+06" EstimateIO="3.04461" EstimateCPU="0.182676" AvgRowSize="38" EstimatedTotalSubtreeCost="3.22728" Table... [PLANO TRUNCADO - Consulte via SSMS]

(@USUARIO nvarchar(4000)) SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;--RMSLoginServer
SELECT U.CODCOLIGADA, U.CODUSUARIO, U.CODSISTEMA, U.CODPERFIL, U.INDICE, U.CONTROLE
                             FROM GUSRPERFIL U (NOLOCK), GPERFIL P (NOLOCK)
                             WHERE P.CODSISTEMA = U.CODSISTEMA
                               AND P.CODPERFIL = U.CODPERFIL                               
                               AND U.CODUSUARIO = @USUARIO
                               AND P.STATUS = 1

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="(@USUARIO nvarchar(4000)) SET FMTONLY OFF; " StatementId="1" StatementCompId="1" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET NO_BROWSETABLE ON; " StatementId="2" StatementCompId="2" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET FMTONLY ON;--RMSLoginServer&#x0D;&#x0A;" StatementId="3" StatementCompId="3" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SELECT U.CODCOLIGADA, U.CODUSUARIO, U.CODSISTEMA, U.CODPERFIL, U.INDICE, U.CONTROLE&#x0D;&#x0A;                             FROM GUSRPERFIL U (NOLOCK), GPERFIL P (NOLOCK)&#x0D;&#x0A;                             WHERE P.CODSISTEMA = U.CODSISTEMA&#x0D;&#x0A;                               AND P.CODPERFIL = U.CODPERFIL                               &#x0D;&#x0A;                               AND U.CODUSUARIO = @USUARIO&#x0D;&#x0A;                               AND P.STATUS = 1" StatementId="4" StatementCompId="4" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="3.35538" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x20EA9D6EE8E30B82" QueryPlanHash="0xE6776808A2AF5CB5" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="40" CompileTime="2" CompileCPU="2" CompileMemory="480"><ThreadStat Branches="2"/><Warnings><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(20),[U].[CODUSUARIO],0)=[@USUARIO]"/></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419430" EstimatedPagesCached="419430" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="47827984"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-28T06:01:12.18" ModificationCount="0" SamplingPercent="100" Statistics="[PKGPERFIL]" Table="[GPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-28T06:00:02.99" ModificationCount="1164" SamplingPercent="8.94007" Statistics="[IDX_GUSRPERFIL_COLIGADA_SIST]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-30T11:57:59.04" ModificationCount="751" SamplingPercent="8.92367" Statistics="[_WA_Sys_00000004_050FA50E]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-28T06:00:03.34" ModificationCount="1164" SamplingPercent="8.94007" Statistics="[GD_202308_1]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-28T06:01:12.18" ModificationCount="0" SamplingPercent="100" Statistics="[IXGPERFIL_STATUS]" Table="[GPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-28T06:00:02.73" ModificationCount="1164" SamplingPercent="8.94007" Statistics="[PKGUSRPERFIL]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285081" AvgRowSize="52" EstimatedTotalSubtreeCost="3.35538" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODCOLIGADA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODUSUARIO"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODSISTEMA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERF... [PLANO TRUNCADO - Consulte via SSMS]

 SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;--ProfessorTestGradeServer
SELECT  SALUNO.CODCOLIGADA,
                              SALUNO.RA,
                              ETAPA.CODETAPA,
                              ETAPA.TIPOETAPA,
                              SMATRICULA.IDTURMADISC,
                              PPESSOA.NOME              NOMEALUNO,
                              SMATRICULA.NUMDIARIO,
                              SMATRICULA.CODSTATUS,
                              SSTATUS.DESCRICAO         STATUS,
                              SSTATUS.NOTASFALTASWEB,
                              SSTATUS.DIBLOQNOTAFALTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,
                              SPLETIVO.CODPERLET,
                              GETDATE()                 DATAATUAL,
                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,
                              SNOTAETAPA.NOTAFALTA      NOTA,
                              SNOTAETAPA.CODCONCEITO,
                              SNOTAETAPA.NOTAFALTA      FALTA,
                              SNOTAETAPA.IDGRUPO,
                              SNOTAETAPA.AULASDADAS,
                              ETAPA.DESCRICAO,
                              SNOTAETAPACOMENTARIO.COMENTARIO
                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)
                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)
                          JOIN SMATRICULA (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA
                                  AND SMATRICULA.RA = SALUNO.RA)  
                          JOIN SPLETIVO (NOLOCK)
                              ON (SMATRICULA.CODCOLIGA... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText=" SET FMTONLY OFF; " StatementId="1" StatementCompId="1" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET NO_BROWSETABLE ON; " StatementId="2" StatementCompId="2" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET FMTONLY ON;--ProfessorTestGradeServer&#x0D;&#x0A;" StatementId="3" StatementCompId="3" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SELECT  SALUNO.CODCOLIGADA,&#x0D;&#x0A;                              SALUNO.RA,&#x0D;&#x0A;                              ETAPA.CODETAPA,&#x0D;&#x0A;                              ETAPA.TIPOETAPA,&#x0D;&#x0A;                              SMATRICULA.IDTURMADISC,&#x0D;&#x0A;                              PPESSOA.NOME              NOMEALUNO,&#x0D;&#x0A;                              SMATRICULA.NUMDIARIO,&#x0D;&#x0A;                              SMATRICULA.CODSTATUS,&#x0D;&#x0A;                              SSTATUS.DESCRICAO         STATUS,&#x0D;&#x0A;                              SSTATUS.NOTASFALTASWEB,&#x0D;&#x0A;                              SSTATUS.DIBLOQNOTAFALTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,&#x0D;&#x0A;                              SPLETIVO.CODPERLET,&#x0D;&#x0A;                              GETDATE()                 DATAATUAL,&#x0D;&#x0A;                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      NOTA,&#x0D;&#x0A;                              SNOTAETAPA.CODCONCEITO,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      FALTA,&#x0D;&#x0A;                              SNOTAETAPA.IDGRUPO,&#x0D;&#x0A;                              SNOTAETAPA.AULASDADAS,&#x0D;&#x0A;                              ETAPA.DESCRICAO,&#x0D;&#x0A;                              SNOTAETAPACOMENTARIO.COMENTARIO&#x0D;&#x0A;                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)&#x0D;&#x0A;                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)&#x0D;&#x0A;                          JOIN SMATRICULA (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.RA = SALUNO.RA)  &#x0D;&#x0A;                          JOIN SPLETIVO (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.IDPERLET = SPLETIVO.IDPERLET)&#x0D;&#x0A;                          JOIN SSTATUS (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SSTATUS.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.CODSTATUS = SSTATUS.CODSTATUS)                                          &#x0D;&#x0A;                          LEFT JOIN SETAPAS ETAPA (NOLOCK)&#x0D;&#x0A;                              ON (ETAPA.CODCOLIGADA = SMATRICULA.CODCOLIGADA&#x0D;&#x0A;                                    AND ETAPA.IDTURMADISC = SMATRICULA.IDTURMADISC&#x0D;&#x0A;                                    AND ETAPA.TIPOETAPA = 'N' )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPA (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = ETAPA.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = ETAPA.CODETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.TIPOETAPA = ETAPA.TIPOETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.IDTURMADISC = ETAPA.IDTURMADISC&#x0... [PLANO TRUNCADO - Consulte via SSMS]

(@USUARIO nvarchar(4000),@COLIGADA int)--RMSLoginServer
SELECT U.CODCOLIGADA, U.CODUSUARIO, U.CODSISTEMA, U.CODPERFIL, U.INDICE, U.CONTROLE
                             FROM GUSRPERFIL U (NOLOCK), GPERFIL P (NOLOCK)
                             WHERE P.CODSISTEMA = U.CODSISTEMA
                               AND P.CODPERFIL = U.CODPERFIL                               
                               AND U.CODUSUARIO = @USUARIO
                               AND P.STATUS = 1 AND U.CODCOLIGADA = @COLIGADA

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="(@USUARIO nvarchar(4000),@COLIGADA int)--RMSLoginServer&#x0D;&#x0A;SELECT U.CODCOLIGADA, U.CODUSUARIO, U.CODSISTEMA, U.CODPERFIL, U.INDICE, U.CONTROLE&#x0D;&#x0A;                             FROM GUSRPERFIL U (NOLOCK), GPERFIL P (NOLOCK)&#x0D;&#x0A;                             WHERE P.CODSISTEMA = U.CODSISTEMA&#x0D;&#x0A;                               AND P.CODPERFIL = U.CODPERFIL                               &#x0D;&#x0A;                               AND U.CODUSUARIO = @USUARIO&#x0D;&#x0A;                               AND P.STATUS = 1 AND U.CODCOLIGADA = @COLIGADA" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="3.4218" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x6121A2D87314EF58" QueryPlanHash="0xE6776808A2AF5CB5" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="40" CompileTime="3" CompileCPU="3" CompileMemory="512"><ThreadStat Branches="2"/><Warnings><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(20),[U].[CODUSUARIO],0)=[@USUARIO]"/></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419430" EstimatedPagesCached="419430" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="47570976"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-28T06:01:12.18" ModificationCount="0" SamplingPercent="100" Statistics="[PKGPERFIL]" Table="[GPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:07.16" ModificationCount="0" SamplingPercent="8.84741" Statistics="[IDX_GUSRPERFIL_COLIGADA_SIST]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:07.92" ModificationCount="0" SamplingPercent="8.84741" Statistics="[_WA_Sys_00000004_050FA50E]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:07.47" ModificationCount="0" SamplingPercent="8.84741" Statistics="[GD_202308_1]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-28T06:01:12.18" ModificationCount="0" SamplingPercent="100" Statistics="[IXGPERFIL_STATUS]" Table="[GPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:06.86" ModificationCount="0" SamplingPercent="8.84741" Statistics="[PKGUSRPERFIL]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285063" AvgRowSize="40" EstimatedTotalSubtreeCost="3.4218" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODCOLIGADA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODUSUARIO"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODSISTEMA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODPERFIL"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="INDICE"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CONTROLE"/></OutputList><Parallelism><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" Estimate... [PLANO TRUNCADO - Consulte via SSMS]

(@USUARIO nvarchar(4000),@COLIGADA int) SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;--RMSLoginServer
SELECT U.CODCOLIGADA, U.CODUSUARIO, U.CODSISTEMA, U.CODPERFIL, U.INDICE, U.CONTROLE
                             FROM GUSRPERFIL U (NOLOCK), GPERFIL P (NOLOCK)
                             WHERE P.CODSISTEMA = U.CODSISTEMA
                               AND P.CODPERFIL = U.CODPERFIL                               
                               AND U.CODUSUARIO = @USUARIO
                               AND P.STATUS = 1 AND U.CODCOLIGADA = @COLIGADA

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="(@USUARIO nvarchar(4000),@COLIGADA int) SET FMTONLY OFF; " StatementId="1" StatementCompId="1" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET NO_BROWSETABLE ON; " StatementId="2" StatementCompId="2" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET FMTONLY ON;--RMSLoginServer&#x0D;&#x0A;" StatementId="3" StatementCompId="3" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SELECT U.CODCOLIGADA, U.CODUSUARIO, U.CODSISTEMA, U.CODPERFIL, U.INDICE, U.CONTROLE&#x0D;&#x0A;                             FROM GUSRPERFIL U (NOLOCK), GPERFIL P (NOLOCK)&#x0D;&#x0A;                             WHERE P.CODSISTEMA = U.CODSISTEMA&#x0D;&#x0A;                               AND P.CODPERFIL = U.CODPERFIL                               &#x0D;&#x0A;                               AND U.CODUSUARIO = @USUARIO&#x0D;&#x0A;                               AND P.STATUS = 1 AND U.CODCOLIGADA = @COLIGADA" StatementId="4" StatementCompId="4" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="3.4218" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x7E3F37B9CCD4352D" QueryPlanHash="0xE6776808A2AF5CB5" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="40" CompileTime="4" CompileCPU="4" CompileMemory="512"><ThreadStat Branches="2"/><Warnings><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(20),[U].[CODUSUARIO],0)=[@USUARIO]"/></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419430" EstimatedPagesCached="419430" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="47570976"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-28T06:01:12.18" ModificationCount="0" SamplingPercent="100" Statistics="[PKGPERFIL]" Table="[GPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:07.16" ModificationCount="0" SamplingPercent="8.84741" Statistics="[IDX_GUSRPERFIL_COLIGADA_SIST]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:07.92" ModificationCount="0" SamplingPercent="8.84741" Statistics="[_WA_Sys_00000004_050FA50E]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:07.47" ModificationCount="0" SamplingPercent="8.84741" Statistics="[GD_202308_1]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-28T06:01:12.18" ModificationCount="0" SamplingPercent="100" Statistics="[IXGPERFIL_STATUS]" Table="[GPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/><StatisticsInfo LastUpdate="2026-03-31T06:00:06.86" ModificationCount="0" SamplingPercent="8.84741" Statistics="[PKGUSRPERFIL]" Table="[GUSRPERFIL]" Schema="[dbo]" Database="[CorporeRM]"/></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285081" AvgRowSize="52" EstimatedTotalSubtreeCost="3.4218" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODCOLIGADA"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODUSUARIO"/><ColumnReference Database="[CorporeRM]" Schema="[dbo]" Table="[GUSRPERFIL]" Alias="[U]" Column="CODSISTEMA"/><ColumnReference Database="[CorporeRM]" ... [PLANO TRUNCADO - Consulte via SSMS]

 SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;--ProfessorTestGradeServer
SELECT  SALUNO.CODCOLIGADA,
                              SALUNO.RA,
                              ETAPA.CODETAPA,
                              ETAPA.TIPOETAPA,
                              SMATRICULA.IDTURMADISC,
                              PPESSOA.NOME              NOMEALUNO,
                              SMATRICULA.NUMDIARIO,
                              SMATRICULA.CODSTATUS,
                              SSTATUS.DESCRICAO         STATUS,
                              SSTATUS.NOTASFALTASWEB,
                              SSTATUS.DIBLOQNOTAFALTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,
                              SPLETIVO.CODPERLET,
                              GETDATE()                 DATAATUAL,
                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,
                              SNOTAETAPA.NOTAFALTA      NOTA,
                              SNOTAETAPA.CODCONCEITO,
                              SNOTAETAPA.NOTAFALTA      FALTA,
                              SNOTAETAPA.IDGRUPO,
                              SNOTAETAPA.AULASDADAS,
                              ETAPA.DESCRICAO,
                              SNOTAETAPACOMENTARIO.COMENTARIO
                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)
                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)
                          JOIN SMATRICULA (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA
                                  AND SMATRICULA.RA = SALUNO.RA)  
                          JOIN SPLETIVO (NOLOCK)
                              ON (SMATRICULA.CODCOLIGA... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText=" SET FMTONLY OFF; " StatementId="1" StatementCompId="1" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET NO_BROWSETABLE ON; " StatementId="2" StatementCompId="2" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET FMTONLY ON;--ProfessorTestGradeServer&#x0D;&#x0A;" StatementId="3" StatementCompId="3" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SELECT  SALUNO.CODCOLIGADA,&#x0D;&#x0A;                              SALUNO.RA,&#x0D;&#x0A;                              ETAPA.CODETAPA,&#x0D;&#x0A;                              ETAPA.TIPOETAPA,&#x0D;&#x0A;                              SMATRICULA.IDTURMADISC,&#x0D;&#x0A;                              PPESSOA.NOME              NOMEALUNO,&#x0D;&#x0A;                              SMATRICULA.NUMDIARIO,&#x0D;&#x0A;                              SMATRICULA.CODSTATUS,&#x0D;&#x0A;                              SSTATUS.DESCRICAO         STATUS,&#x0D;&#x0A;                              SSTATUS.NOTASFALTASWEB,&#x0D;&#x0A;                              SSTATUS.DIBLOQNOTAFALTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,&#x0D;&#x0A;                              SPLETIVO.CODPERLET,&#x0D;&#x0A;                              GETDATE()                 DATAATUAL,&#x0D;&#x0A;                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      NOTA,&#x0D;&#x0A;                              SNOTAETAPA.CODCONCEITO,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      FALTA,&#x0D;&#x0A;                              SNOTAETAPA.IDGRUPO,&#x0D;&#x0A;                              SNOTAETAPA.AULASDADAS,&#x0D;&#x0A;                              ETAPA.DESCRICAO,&#x0D;&#x0A;                              SNOTAETAPACOMENTARIO.COMENTARIO&#x0D;&#x0A;                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)&#x0D;&#x0A;                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)&#x0D;&#x0A;                          JOIN SMATRICULA (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.RA = SALUNO.RA)  &#x0D;&#x0A;                          JOIN SPLETIVO (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.IDPERLET = SPLETIVO.IDPERLET)&#x0D;&#x0A;                          JOIN SSTATUS (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SSTATUS.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.CODSTATUS = SSTATUS.CODSTATUS)                                          &#x0D;&#x0A;                          LEFT JOIN SETAPAS ETAPA (NOLOCK)&#x0D;&#x0A;                              ON (ETAPA.CODCOLIGADA = SMATRICULA.CODCOLIGADA&#x0D;&#x0A;                                    AND ETAPA.IDTURMADISC = SMATRICULA.IDTURMADISC&#x0D;&#x0A;                                    AND ETAPA.TIPOETAPA = 'N' )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPA (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = ETAPA.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = ETAPA.CODETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.TIPOETAPA = ETAPA.TIPOETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.IDTURMADISC = ETAPA.IDTURMADISC&#x0... [PLANO TRUNCADO - Consulte via SSMS]

 SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;--ProfessorTestGradeServer
SELECT  SALUNO.CODCOLIGADA,
                              SALUNO.RA,
                              ETAPA.CODETAPA,
                              ETAPA.TIPOETAPA,
                              SMATRICULA.IDTURMADISC,
                              PPESSOA.NOME              NOMEALUNO,
                              SMATRICULA.NUMDIARIO,
                              SMATRICULA.CODSTATUS,
                              SSTATUS.DESCRICAO         STATUS,
                              SSTATUS.NOTASFALTASWEB,
                              SSTATUS.DIBLOQNOTAFALTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,
                              SPLETIVO.CODPERLET,
                              GETDATE()                 DATAATUAL,
                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,
                              SNOTAETAPA.NOTAFALTA      NOTA,
                              SNOTAETAPA.CODCONCEITO,
                              SNOTAETAPA.NOTAFALTA      FALTA,
                              SNOTAETAPA.IDGRUPO,
                              SNOTAETAPA.AULASDADAS,
                              ETAPA.DESCRICAO,
                              SNOTAETAPACOMENTARIO.COMENTARIO
                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)
                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)
                          JOIN SMATRICULA (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA
                                  AND SMATRICULA.RA = SALUNO.RA)  
                          JOIN SPLETIVO (NOLOCK)
                              ON (SMATRICULA.CODCOLIGA... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText=" SET FMTONLY OFF; " StatementId="1" StatementCompId="1" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET NO_BROWSETABLE ON; " StatementId="2" StatementCompId="2" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SET FMTONLY ON;--ProfessorTestGradeServer&#x0D;&#x0A;" StatementId="3" StatementCompId="3" StatementType="SET ON/OFF" RetrievedFromCache="true"/><StmtSimple StatementText="SELECT  SALUNO.CODCOLIGADA,&#x0D;&#x0A;                              SALUNO.RA,&#x0D;&#x0A;                              ETAPA.CODETAPA,&#x0D;&#x0A;                              ETAPA.TIPOETAPA,&#x0D;&#x0A;                              SMATRICULA.IDTURMADISC,&#x0D;&#x0A;                              PPESSOA.NOME              NOMEALUNO,&#x0D;&#x0A;                              SMATRICULA.NUMDIARIO,&#x0D;&#x0A;                              SMATRICULA.CODSTATUS,&#x0D;&#x0A;                              SSTATUS.DESCRICAO         STATUS,&#x0D;&#x0A;                              SSTATUS.NOTASFALTASWEB,&#x0D;&#x0A;                              SSTATUS.DIBLOQNOTAFALTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,&#x0D;&#x0A;                              SPLETIVO.CODPERLET,&#x0D;&#x0A;                              GETDATE()                 DATAATUAL,&#x0D;&#x0A;                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      NOTA,&#x0D;&#x0A;                              SNOTAETAPA.CODCONCEITO,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      FALTA,&#x0D;&#x0A;                              SNOTAETAPA.IDGRUPO,&#x0D;&#x0A;                              SNOTAETAPA.AULASDADAS,&#x0D;&#x0A;                              ETAPA.DESCRICAO,&#x0D;&#x0A;                              SNOTAETAPACOMENTARIO.COMENTARIO&#x0D;&#x0A;                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)&#x0D;&#x0A;                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)&#x0D;&#x0A;                          JOIN SMATRICULA (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.RA = SALUNO.RA)  &#x0D;&#x0A;                          JOIN SPLETIVO (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.IDPERLET = SPLETIVO.IDPERLET)&#x0D;&#x0A;                          JOIN SSTATUS (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SSTATUS.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.CODSTATUS = SSTATUS.CODSTATUS)                                          &#x0D;&#x0A;                          LEFT JOIN SETAPAS ETAPA (NOLOCK)&#x0D;&#x0A;                              ON (ETAPA.CODCOLIGADA = SMATRICULA.CODCOLIGADA&#x0D;&#x0A;                                    AND ETAPA.IDTURMADISC = SMATRICULA.IDTURMADISC&#x0D;&#x0A;                                    AND ETAPA.TIPOETAPA = 'N' )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPA (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = ETAPA.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = ETAPA.CODETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.TIPOETAPA = ETAPA.TIPOETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.IDTURMADISC = ETAPA.IDTURMADISC&#x0... [PLANO TRUNCADO - Consulte via SSMS]

--ProfessorTestGradeServer
SELECT  SALUNO.CODCOLIGADA,
                              SALUNO.RA,
                              ETAPA.CODETAPA,
                              ETAPA.TIPOETAPA,
                              SMATRICULA.IDTURMADISC,
                              PPESSOA.NOME              NOMEALUNO,
                              SMATRICULA.NUMDIARIO,
                              SMATRICULA.CODSTATUS,
                              SSTATUS.DESCRICAO         STATUS,
                              SSTATUS.NOTASFALTASWEB,
                              SSTATUS.DIBLOQNOTAFALTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,
                              SPLETIVO.CODPERLET,
                              GETDATE()                 DATAATUAL,
                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,
                              SNOTAETAPA.NOTAFALTA      NOTA,
                              SNOTAETAPA.CODCONCEITO,
                              SNOTAETAPA.NOTAFALTA      FALTA,
                              SNOTAETAPA.IDGRUPO,
                              SNOTAETAPA.AULASDADAS,
                              ETAPA.DESCRICAO,
                              SNOTAETAPACOMENTARIO.COMENTARIO
                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)
                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)
                          JOIN SMATRICULA (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA
                                  AND SMATRICULA.RA = SALUNO.RA)  
                          JOIN SPLETIVO (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA
                             ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="--ProfessorTestGradeServer&#x0D;&#x0A;SELECT  SALUNO.CODCOLIGADA,&#x0D;&#x0A;                              SALUNO.RA,&#x0D;&#x0A;                              ETAPA.CODETAPA,&#x0D;&#x0A;                              ETAPA.TIPOETAPA,&#x0D;&#x0A;                              SMATRICULA.IDTURMADISC,&#x0D;&#x0A;                              PPESSOA.NOME              NOMEALUNO,&#x0D;&#x0A;                              SMATRICULA.NUMDIARIO,&#x0D;&#x0A;                              SMATRICULA.CODSTATUS,&#x0D;&#x0A;                              SSTATUS.DESCRICAO         STATUS,&#x0D;&#x0A;                              SSTATUS.NOTASFALTASWEB,&#x0D;&#x0A;                              SSTATUS.DIBLOQNOTAFALTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,&#x0D;&#x0A;                              SPLETIVO.CODPERLET,&#x0D;&#x0A;                              GETDATE()                 DATAATUAL,&#x0D;&#x0A;                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      NOTA,&#x0D;&#x0A;                              SNOTAETAPA.CODCONCEITO,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      FALTA,&#x0D;&#x0A;                              SNOTAETAPA.IDGRUPO,&#x0D;&#x0A;                              SNOTAETAPA.AULASDADAS,&#x0D;&#x0A;                              ETAPA.DESCRICAO,&#x0D;&#x0A;                              SNOTAETAPACOMENTARIO.COMENTARIO&#x0D;&#x0A;                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)&#x0D;&#x0A;                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)&#x0D;&#x0A;                          JOIN SMATRICULA (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.RA = SALUNO.RA)  &#x0D;&#x0A;                          JOIN SPLETIVO (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.IDPERLET = SPLETIVO.IDPERLET)&#x0D;&#x0A;                          JOIN SSTATUS (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SSTATUS.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.CODSTATUS = SSTATUS.CODSTATUS)                                          &#x0D;&#x0A;                          LEFT JOIN SETAPAS ETAPA (NOLOCK)&#x0D;&#x0A;                              ON (ETAPA.CODCOLIGADA = SMATRICULA.CODCOLIGADA&#x0D;&#x0A;                                    AND ETAPA.IDTURMADISC = SMATRICULA.IDTURMADISC&#x0D;&#x0A;                                    AND ETAPA.TIPOETAPA = 'N' )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPA (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = ETAPA.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = ETAPA.CODETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.TIPOETAPA = ETAPA.TIPOETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.IDTURMADISC = ETAPA.IDTURMADISC&#x0D;&#x0A;                                  AND SNOTAETAPA.RA = SMATRICULA.RA )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPACOMENTARIO (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = SNOTAETAPACOMENTARIO.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = SNOTAETAPACOMENTARIO.CODETAPA&#x0D;&#x0A;                                  AND SNOTA... [PLANO TRUNCADO - Consulte via SSMS]

(@CODUSUARIO varchar(11))--EduContextoPortalData
SELECT DISTINCT 
                             SALUNO.RA,
                             SALUNO.CODCOLIGADA,
                             NULL                                     CODFILIAL,
                      NULL                                     CODTIPOCURSO,
                              (CASE
                     WHEN (RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOA.NOME))
                     ELSE RTRIM(LTRIM(PPESSOA.NOMESOCIAL))
                  END)   NOMEALUNO,
                             PPESSOA.DTNASCIMENTO                     DTNASCIMENTOALUNO,
                             PPESSOA.CODUSUARIO                       CODUSUARIOALUNO,
                             PPESSOA.CODIGO                           CODPESSOAUSUARIO,
                             NULL                                     CODUSUARIOPAI,
                             NULL                                     NOMEPAI,
                             NULL                                     CODUSUARIOMAE,
                             NULL                                     NOMEMAE,
                             NULL                                     CODUSUARIORACA,
                             NULL                                     NOMERACA,
                             NULL                                     CODUSUARIORESPFINANCEIRO,
                             NULL                                     NOMERESPFINANCEIRO,
                             NULL                                     CODCOLIGADACFO,
                             NULL                                     CODCFO,
                             NULL                                     CODUSUARIORESPCONTRATO,
                             NULL                                     NOMERESPCONTRATO,
                             NULL                                     CODUSUARIORESPPARCELA,
     ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="(@CODUSUARIO varchar(11))--EduContextoPortalData&#x0D;&#x0A;SELECT DISTINCT &#x0D;&#x0A;                             SALUNO.RA,&#x0D;&#x0A;                             SALUNO.CODCOLIGADA,&#x0D;&#x0A;                             NULL                                     CODFILIAL,&#x0D;&#x0A;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;               NULL                                     CODTIPOCURSO,&#x0D;&#x0A;                              (CASE&#x0D;&#x0A;                     WHEN (RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) IS NULL OR RTRIM(LTRIM(PPESSOA.NOMESOCIAL)) = '') THEN RTRIM(LTRIM(PPESSOA.NOME))&#x0D;&#x0A;                     ELSE RTRIM(LTRIM(PPESSOA.NOMESOCIAL))&#x0D;&#x0A;                  END)   NOMEALUNO,&#x0D;&#x0A;                             PPESSOA.DTNASCIMENTO                     DTNASCIMENTOALUNO,&#x0D;&#x0A;                             PPESSOA.CODUSUARIO                       CODUSUARIOALUNO,&#x0D;&#x0A;                             PPESSOA.CODIGO                           CODPESSOAUSUARIO,&#x0D;&#x0A;                             NULL                                     CODUSUARIOPAI,&#x0D;&#x0A;                             NULL                                     NOMEPAI,&#x0D;&#x0A;                             NULL                                     CODUSUARIOMAE,&#x0D;&#x0A;                             NULL                                     NOMEMAE,&#x0D;&#x0A;                             NULL                                     CODUSUARIORACA,&#x0D;&#x0A;                             NULL                                     NOMERACA,&#x0D;&#x0A;                             NULL                                     CODUSUARIORESPFINANCEIRO,&#x0D;&#x0A;                             NULL                                     NOMERESPFINANCEIRO,&#x0D;&#x0A;                             NULL                                     CODCOLIGADACFO,&#x0D;&#x0A;                             NULL                                     CODCFO,&#x0D;&#x0A;                             NULL                                     CODUSUARIORESPCONTRATO,&#x0D;&#x0A;                             NULL                                     NOMERESPCONTRATO,&#x0D;&#x0A;                             NULL                                     CODUSUARIORESPPARCELA,&#x0D;&#x0A;                             NULL                                     NOMERESPPARCELA,&#x0D;&#x0A;                             NULL                                     ACESSOACADEMICOSCFO,&#x0D;&#x0A;                             'S'        DADOSACADEMICOS,&#x0D;&#x0A;                             'S'        DADOSFINANCEIROS,&#x0D;&#x0A;                             NULL                                     IDIMAGEMPAI,&#x0D;&#x0A;                             NULL                                     IDIMAGEMMAE,&#x0D;&#x0A;                             NULL                                     IDIMAGEMACAD,&#x0D;&#x0A;                             NULL                                     IDIMAGEMFIN,&#x0D;&#x0A;                             NULL                                     IDIMAGEMCONT,&#x0D;&#x0A;                             PPESSOA.IDIMAGEM                         IDIMAGEM,&#x0D;&#x0A;                             SALUNO.CODCOLCFO CODCOLCFOALUNO,&#x0D;&#x0A;                             SALUNO.CODCFO CODCFOALUNO&#x0D;&#x0A;                      FROM   SALUNO (NOLOCK)&#x0D;&#x0A;                             JOIN PPESSOA (NOLOCK)&#x0D;&#x0A;                               ON SALUNO.CODPESSOA = PPESSOA.CODIGO&#x0D;&#x0A;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;               LEFT JOIN SMATRICPL (NOLOCK)&#x0D;&#x0A;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;               ON SMATRICPL.CODCOLIGADA = SALUNO.CODCOLIGADA AND &#x0D;&#x0A;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;&#x09;                  SMATRICPL.RA... [PLANO TRUNCADO - Consulte via SSMS]

--ProfessorTestGradeServer
SELECT  SALUNO.CODCOLIGADA,
                              SALUNO.RA,
                              ETAPA.CODETAPA,
                              ETAPA.TIPOETAPA,
                              SMATRICULA.IDTURMADISC,
                              PPESSOA.NOME              NOMEALUNO,
                              SMATRICULA.NUMDIARIO,
                              SMATRICULA.CODSTATUS,
                              SSTATUS.DESCRICAO         STATUS,
                              SSTATUS.NOTASFALTASWEB,
                              SSTATUS.DIBLOQNOTAFALTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,
                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,
                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,
                              SPLETIVO.CODPERLET,
                              GETDATE()                 DATAATUAL,
                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,
                              SNOTAETAPA.NOTAFALTA      NOTA,
                              SNOTAETAPA.CODCONCEITO,
                              SNOTAETAPA.NOTAFALTA      FALTA,
                              SNOTAETAPA.IDGRUPO,
                              SNOTAETAPA.AULASDADAS,
                              ETAPA.DESCRICAO,
                              SNOTAETAPACOMENTARIO.COMENTARIO
                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)
                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)
                          JOIN SMATRICULA (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA
                                  AND SMATRICULA.RA = SALUNO.RA)  
                          JOIN SPLETIVO (NOLOCK)
                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA
                             ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4445.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="--ProfessorTestGradeServer&#x0D;&#x0A;SELECT  SALUNO.CODCOLIGADA,&#x0D;&#x0A;                              SALUNO.RA,&#x0D;&#x0A;                              ETAPA.CODETAPA,&#x0D;&#x0A;                              ETAPA.TIPOETAPA,&#x0D;&#x0A;                              SMATRICULA.IDTURMADISC,&#x0D;&#x0A;                              PPESSOA.NOME              NOMEALUNO,&#x0D;&#x0A;                              SMATRICULA.NUMDIARIO,&#x0D;&#x0A;                              SMATRICULA.CODSTATUS,&#x0D;&#x0A;                              SSTATUS.DESCRICAO         STATUS,&#x0D;&#x0A;                              SSTATUS.NOTASFALTASWEB,&#x0D;&#x0A;                              SSTATUS.DIBLOQNOTAFALTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAONOTA,&#x0D;&#x0A;                              ETAPA.DTINICIODIGITACAO   DTINICIODIGITACAOFALTA,&#x0D;&#x0A;                              ETAPA.DTLIMITEDIGITACAO   DTLIMITEDIGITACAOFALTA,&#x0D;&#x0A;                              SPLETIVO.CODPERLET,&#x0D;&#x0A;                              GETDATE()                 DATAATUAL,&#x0D;&#x0A;                              ISNULL(ETAPA.PONTDIST, 0) PONTDIST,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      NOTA,&#x0D;&#x0A;                              SNOTAETAPA.CODCONCEITO,&#x0D;&#x0A;                              SNOTAETAPA.NOTAFALTA      FALTA,&#x0D;&#x0A;                              SNOTAETAPA.IDGRUPO,&#x0D;&#x0A;                              SNOTAETAPA.AULASDADAS,&#x0D;&#x0A;                              ETAPA.DESCRICAO,&#x0D;&#x0A;                              SNOTAETAPACOMENTARIO.COMENTARIO&#x0D;&#x0A;                      FROM SALUNO (NOLOCK) JOIN PPESSOA (NOLOCK)&#x0D;&#x0A;                              ON (SALUNO.CODPESSOA = PPESSOA.CODIGO)&#x0D;&#x0A;                          JOIN SMATRICULA (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SALUNO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.RA = SALUNO.RA)  &#x0D;&#x0A;                          JOIN SPLETIVO (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SPLETIVO.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.IDPERLET = SPLETIVO.IDPERLET)&#x0D;&#x0A;                          JOIN SSTATUS (NOLOCK)&#x0D;&#x0A;                              ON (SMATRICULA.CODCOLIGADA = SSTATUS.CODCOLIGADA&#x0D;&#x0A;                                  AND SMATRICULA.CODSTATUS = SSTATUS.CODSTATUS)                                          &#x0D;&#x0A;                          LEFT JOIN SETAPAS ETAPA (NOLOCK)&#x0D;&#x0A;                              ON (ETAPA.CODCOLIGADA = SMATRICULA.CODCOLIGADA&#x0D;&#x0A;                                    AND ETAPA.IDTURMADISC = SMATRICULA.IDTURMADISC&#x0D;&#x0A;                                    AND ETAPA.TIPOETAPA = 'N' )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPA (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = ETAPA.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = ETAPA.CODETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.TIPOETAPA = ETAPA.TIPOETAPA&#x0D;&#x0A;                                  AND SNOTAETAPA.IDTURMADISC = ETAPA.IDTURMADISC&#x0D;&#x0A;                                  AND SNOTAETAPA.RA = SMATRICULA.RA )&#x0D;&#x0A;                          LEFT JOIN SNOTAETAPACOMENTARIO (NOLOCK)&#x0D;&#x0A;                              ON (SNOTAETAPA.CODCOLIGADA = SNOTAETAPACOMENTARIO.CODCOLIGADA&#x0D;&#x0A;                                  AND SNOTAETAPA.CODETAPA = SNOTAETAPACOMENTARIO.CODETAPA&#x0D;&#x0A;                                  AND SNOTA... [PLANO TRUNCADO - Consulte via SSMS]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[GERENCIAL]

[CODDISC], [CODTURMA], [CODTURNO], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO]

SELECT DISTINCT STURMADISC.CODCOLIGADA,
                                      STURMADISC.CODFILIAL,
                                      STURMADISC.CODTIPOCURSO,
                                      SPLETIVO.IDPERLET,
                                      SPLETIVO.CODPERLET,
                                      GFILIAL.NOMEFANTASIA,
                                      SCURSO.CODCURSO,
                                      SCURSO.NOME                             CURSO,
                                      SHABILITACAOFILIAL.IDHABILITACAOFILIAL,
                                      SHABILITACAO.CODHABILITACAO,
                                      SHABILITACAO.NOME                       HABILITACAO,
                                      STURNO.CODTURNO,
                                      STURNO.NOME                             NOMETURNO,
                                      STURMADISC.CODTURMA,
                                      STURMADISC.IDTURMADISC,
                                      STURMADISC.GERENCIAL,
                                      STURMADISC.TIPO,
                                      SDISCIPLINA.CODDISC,
                                      SDISCIPLINA.NOME                        DISCIPLINA,
                                      SPLETIVO.ENCERRADO,
                                      SDISCIPLINA.ITINERARIOFORMATIVO,
                                      SPROFESSOR.CODPROF,
                                      STURMA.NOM... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[GERENCIAL]

[CODDISC], [CODTURMA], [CODTURNO], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO]

(@CODCOLIGADA_N smallint,@CODFILIAL_N int,@CODTIPOCURSO_N int,@CODUSUARIO_S varchar(11))--ProfessorClassReportServer
SELECT DISTINCT STURMADISC.CODCOLIGADA,
                                      STURMADISC.CODFILIAL,
                                      STURMADISC.CODTIPOCURSO,
                                      SPLETIVO.IDPERLET,
                                      SPLETIVO.CODPERLET,
                                      GFILIAL.NOMEFANTASIA,
                                      SCURSO.CODCURSO,
                                      SCURSO.NOME                             CURSO,
                                      SHABILITACAOFILIAL.IDHABILITACAOFILIAL,
                                      SHABILITACAO.CODHABILITACAO,
                                      SHABILITACAO.NOME                       HABILITACAO,
                                      STURNO.CODTURNO,
                                      STURNO.NOME                             NOMETURNO,
                                      STURMADISC.CODTURMA,
                                      STURMADISC.IDTURMADISC,
                                      STURMADISC.GERENCIAL,
                                      STURMADISC.TIPO,
                                      SDISCIPLINA.CODDISC,
                                      SDISCIPLINA.NOME                        DISCIPLINA,
                                      SPLETIVO.ENCERRADO,
                                      SDISCIPLINA.ITINERARIOF... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[GERENCIAL]

[CODDISC], [CODITINERARIOFORMATIVO], [CODTURMA], [CODTURNO], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO]

(@CODCOLIGADA_N smallint,@CODFILIAL_N int,@CODTIPOCURSO_N int,@CODUSUARIO_S varchar(11))--ProfessorDisciplineClassServer
SELECT DISTINCT STURMADISC.CODCOLIGADA,
                                      STURMADISC.CODFILIAL,
                                      STURMADISC.CODTIPOCURSO,
                                      SPLETIVO.IDPERLET,
                                      SPLETIVO.CODPERLET,
                                      GFILIAL.NOMEFANTASIA,
                                      SCURSO.CODCURSO,
                                      SCURSO.NOME                             CURSO,
                                      SHABILITACAOFILIAL.IDHABILITACAOFILIAL,
                                      SHABILITACAO.CODHABILITACAO,
                                      SHABILITACAO.NOME                       HABILITACAO,
                                      STURNO.CODTURNO,
                                      STURNO.NOME                             NOMETURNO,
                                      STURMADISC.CODTURMA,
                                      STURMADISC.IDTURMADISC,
                                      STURMADISC.GERENCIAL,
                                      STURMADISC.TIPO,
                                      SDISCIPLINA.CODDISC,
                                      SDISCIPLINA.NOME                        DISCIPLINA,
                                      SPLETIVO.ENCERRADO,
                                      SDISCIPLINA.ITINERA... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[GERENCIAL]

[CODDISC], [CODITINERARIOFORMATIVO], [CODTURMA], [CODTURNO], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO]

SELECT DISTINCT STURMADISC.CODCOLIGADA,
                                      STURMADISC.CODFILIAL,
                                      STURMADISC.CODTIPOCURSO,
                                      SPLETIVO.IDPERLET,
                                      SPLETIVO.CODPERLET,
                                      GFILIAL.NOMEFANTASIA,
                                      SCURSO.CODCURSO,
                                      SCURSO.NOME                             CURSO,
                                      SHABILITACAOFILIAL.IDHABILITACAOFILIAL,
                                      SHABILITACAO.CODHABILITACAO,
                                      SHABILITACAO.NOME                       HABILITACAO,
                                      STURNO.CODTURNO,
                                      STURNO.NOME                             NOMETURNO,
                                      STURMADISC.CODTURMA,
                                      STURMADISC.IDTURMADISC,
                                      STURMADISC.GERENCIAL,
                                      STURMADISC.TIPO,
                                      SDISCIPLINA.CODDISC,
                                      SDISCIPLINA.NOME                        DISCIPLINA,
                                      SPLETIVO.ENCERRADO,
                                      SDISCIPLINA.ITINERARIOFORMATIVO,
                                      SPROFESSOR.CODPROF,
                                      STURMA.NOM... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[GERENCIAL]

[CODDISC], [CODTURMA], [CODTURNO], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO]

SELECT DISTINCT STURMADISC.CODCOLIGADA,
                                      STURMADISC.CODFILIAL,
                                      STURMADISC.CODTIPOCURSO,
                                      SPLETIVO.IDPERLET,
                                      SPLETIVO.CODPERLET,
                                      GFILIAL.NOMEFANTASIA,
                                      SCURSO.CODCURSO,
                                      SCURSO.NOME                             CURSO,
                                      SHABILITACAOFILIAL.IDHABILITACAOFILIAL,
                                      SHABILITACAO.CODHABILITACAO,
                                      SHABILITACAO.NOME                       HABILITACAO,
                                      STURNO.CODTURNO,
                                      STURNO.NOME                             NOMETURNO,
                                      STURMADISC.CODTURMA,
                                      STURMADISC.IDTURMADISC,
                                      STURMADISC.GERENCIAL,
                                      STURMADISC.TIPO,
                                      SDISCIPLINA.CODDISC,
                                      SDISCIPLINA.NOME                        DISCIPLINA,
                                      SPLETIVO.ENCERRADO,
                                      SDISCIPLINA.ITINERARIOFORMATIVO,
                                      SPROFESSOR.CODPROF,
                                      STURMA.NOM... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[GERENCIAL]

[CODDISC], [CODTURMA], [CODTURNO], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO]

(@CODCOLIGADA_N smallint,@CODFILIAL_N int,@CODTIPOCURSO_N int,@CODUSUARIO_S varchar(11))--ProfessorDisciplineClassServer
SELECT DISTINCT STURMADISC.CODCOLIGADA,
                                      STURMADISC.CODFILIAL,
                                      STURMADISC.CODTIPOCURSO,
                                      SPLETIVO.IDPERLET,
                                      SPLETIVO.CODPERLET,
                                      GFILIAL.NOMEFANTASIA,
                                      SCURSO.CODCURSO,
                                      SCURSO.NOME                             CURSO,
                                      SHABILITACAOFILIAL.IDHABILITACAOFILIAL,
                                      SHABILITACAO.CODHABILITACAO,
                                      SHABILITACAO.NOME                       HABILITACAO,
                                      STURNO.CODTURNO,
                                      STURNO.NOME                             NOMETURNO,
                                      STURMADISC.CODTURMA,
                                      STURMADISC.IDTURMADISC,
                                      STURMADISC.GERENCIAL,
                                      STURMADISC.TIPO,
                                      SDISCIPLINA.CODDISC,
                                      SDISCIPLINA.NOME                        DISCIPLINA,
                                      SPLETIVO.ENCERRADO,
                                      SDISCIPLINA.ITINERA... [TRUNCADO]

[CorporeRM].[dbo].[SDISCGRADE]

[CODCURSO], [CODDISC], [CODGRADE], [CODHABILITACAO]

[CH]

SELECT  
SDISCIPLINA.CH,
HR_AULA_EB.CH_EB,
HR_AULA_EB.CH_REALIZADA,
  SUM(CASE WHEN SSTATUS.DESCRICAO LIKE 'TRANCADO' THEN 1 END) TRANCADO,
  SUM(CASE WHEN SSTATUS.DESCRICAO IN ('APROVADO' ) THEN 1 END) CONCLUIDO,
  SUM(CASE WHEN SSTATUS.DESCRICAO LIKE 'RETIDO' OR SSTATUS.DESCRICAO LIKE '%REPROVADO%' OR SSTATUS.DESCRICAO LIKE '%TRANCADO%'THEN 1 END) RETIDO,
  SUM(CASE WHEN SSTATUS.DESCRICAO LIKE 'CANCELADO' THEN 1 END) CANCELADO,
  SUM(CASE WHEN SSTATUS.DESCRICAO LIKE 'EVADIDO' THEN 1 END) EVADIDO,
  SUM(CASE WHEN SSTATUS.DESCRICAO LIKE 'TRANSFERIDO' THEN 1 END) TRANSFERIDO,
  (SUM(CASE WHEN SSTATUS.DESCRICAO IN ('APROVADO' ) THEN 1 END) * 100) / COUNT(*) INDICECONCLUDENTE,
  (SUM(CASE WHEN SSTATUS.DESCRICAO IN ('EVADIDO','REPROVADO','Reprovado por Frequ�ncia','RETIDO') THEN 1 END) * 100) / COUNT(*) INDICEEVADIDO


FROM SMATRICULA(NOLOCK)
INNER JOIN STURMADISC(NOLOCK)
  ON STURMADISC.CODCOLIGADA = SMATRICULA.CODCOLIGADA
  AND STURMADISC.IDTURMADISC = SMATRICULA.IDTURMADISC
INNER JOIN SDISCIPLINA(NOLOCK)
  ON SDISCIPLINA.CODCOLIGADA = STURMADISC.CODCOLIGADA
  AND SDISCIPLINA.CODDISC = STURMADISC.CODDISC
LEFT JOIN SSTATUS(NOLOCK)
    ON SSTATUS.CODCOLIGADA  =  SMATRICULA.CODCOLIGADA
    AND SSTATUS.CODSTATUS  =  SMATRICULA.CODSTATUSRES
    
LEFT JOIN 
(SELECT
STURMADISC.CODCOLIGADA,
STURMADISC.IDTURMADISC,
STURMADISC.CODDISC,
STURMADISC.DURACAOAULA,
COUNT_AULAS.AULASDADAS,
(COUNT_AULAS.AULASDADAS*ISNULL (STURMADISC.DURACAOAULA,50))/60 AS CH_REALI... [TRUNCADO]

[CorporeRM].[dbo].[SHABILITACAOFILIAL]

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODCURSO], [CODGRADE], [CODHABILITACAO], [CODTURNO]

(@CODCOLIGADA smallint,@RA varchar(8),@CODUSUARIO varchar(11))--EduContextoPortalData

          SELECT SHABILITACAOFILIAL.CODCOLIGADA,
                 SHABILITACAOFILIAL.CODFILIAL,
                 GFILIAL.NOMEFANTASIA             NOMEFILIAL,
                 SHABILITACAOFILIAL.CODTIPOCURSO,
                 STIPOCURSO.NOME                  NOMETIPOCURSO,
                 SMATRICPL.RA,
                 SMATRICPL.IDHABILITACAOFILIAL,
                 SCURSO.CODCURSO,
                 SCURSO.NOME                      NOMECURSO,
                 SHABILITACAO.CODHABILITACAO,  
                 SHABILITACAO.NOME                NOMEHABILITACAO,
                 SGRADE.DESCRICAO                 NOMEMATRIZ,
                 STURNO.NOME                      NOMETURNO,
                 SMATRICPL.IDPERLET,
                 SPLETIVO.CODPERLET,
                 SPLETIVO.DTINICIO,
                 STIPOCURSO.APRESENTACAO,
                 SMATRICPL.CODTURMA,
                 SMATRICPL.PERIODO,
                 STATUSHABILITACAO.DESCRICAO      SITMATHABILITACAO,
                 SSTATUS.DESCRICAO SITMATPERLET,
                 SMATRICPL.CODSTATUSRES,
                 GUSUARIO.EMAIL
          FROM   SHABILITACAOALUNO (NOLOCK)
           LEFT JOIN SSTATUS STATUSHABILITACAO (NOLOCK)
                  ON STATUSHABILITACAO.CODCOLIGADA = SHABILITACAOALUNO.CODCOLIGADA
                     AND STATUSHABILITACAO.CODSTATUS = SHABILITACAOALUNO.CODSTATUS
           JOIN S... [TRUNCADO]

[CorporeRM].[dbo].[SHABILITACAOFILIAL]

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODCURSO], [CODGRADE], [CODHABILITACAO], [CODTURNO]

SELECT SHABILITACAOFILIAL.CODCOLIGADA,
                 SHABILITACAOFILIAL.CODFILIAL,
                 GFILIAL.NOMEFANTASIA             NOMEFILIAL,
                 SHABILITACAOFILIAL.CODTIPOCURSO,
                 STIPOCURSO.NOME                  NOMETIPOCURSO,
                 SMATRICPL.RA,
                 SMATRICPL.IDHABILITACAOFILIAL,
                 SCURSO.CODCURSO,
                 SCURSO.NOME                      NOMECURSO,
                 SHABILITACAO.CODHABILITACAO,  
                 SHABILITACAO.NOME                NOMEHABILITACAO,
                 SGRADE.DESCRICAO                 NOMEMATRIZ,
                 STURNO.NOME                      NOMETURNO,
                 SMATRICPL.IDPERLET,
                 SPLETIVO.CODPERLET,
                 SPLETIVO.DTINICIO,
                 STIPOCURSO.APRESENTACAO,
                 SMATRICPL.CODTURMA,
                 SMATRICPL.PERIODO,
                 STATUSHABILITACAO.DESCRICAO      SITMATHABILITACAO,
                 SSTATUS.DESCRICAO SITMATPERLET,
                 SMATRICPL.CODSTATUSRES,
                 GUSUARIO.EMAIL
          FROM   SHABILITACAOALUNO (NOLOCK)
           LEFT JOIN SSTATUS STATUSHABILITACAO (NOLOCK)
                  ON STATUSHABILITACAO.CODCOLIGADA = SHABILITACAOALUNO.CODCOLIGADA
                     AND STATUSHABILITACAO.CODSTATUS = SHABILITACAOALUNO.CODSTATUS
           JOIN SHABILITACAOFILIAL (NOLOCK)
                JOIN SCURSO (NOLOCK)
                  ON ( SHABILITAC... [TRUNCADO]

[CorporeRM].[dbo].[SHABILITACAOFILIAL]

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODCURSO], [CODGRADE], [CODHABILITACAO], [CODTURNO]

(@CODCOLIGADA smallint,@RA varchar(8),@CODUSUARIO varchar(6))--EduContextoPortalData

          SELECT SHABILITACAOFILIAL.CODCOLIGADA,
                 SHABILITACAOFILIAL.CODFILIAL,
                 GFILIAL.NOMEFANTASIA             NOMEFILIAL,
                 SHABILITACAOFILIAL.CODTIPOCURSO,
                 STIPOCURSO.NOME                  NOMETIPOCURSO,
                 SMATRICPL.RA,
                 SMATRICPL.IDHABILITACAOFILIAL,
                 SCURSO.CODCURSO,
                 SCURSO.NOME                      NOMECURSO,
                 SHABILITACAO.CODHABILITACAO,  
                 SHABILITACAO.NOME                NOMEHABILITACAO,
                 SGRADE.DESCRICAO                 NOMEMATRIZ,
                 STURNO.NOME                      NOMETURNO,
                 SMATRICPL.IDPERLET,
                 SPLETIVO.CODPERLET,
                 SPLETIVO.DTINICIO,
                 STIPOCURSO.APRESENTACAO,
                 SMATRICPL.CODTURMA,
                 SMATRICPL.PERIODO,
                 STATUSHABILITACAO.DESCRICAO      SITMATHABILITACAO,
                 SSTATUS.DESCRICAO SITMATPERLET,
                 SMATRICPL.CODSTATUSRES,
                 GUSUARIO.EMAIL
          FROM   SHABILITACAOALUNO (NOLOCK)
           LEFT JOIN SSTATUS STATUSHABILITACAO (NOLOCK)
                  ON STATUSHABILITACAO.CODCOLIGADA = SHABILITACAOALUNO.CODCOLIGADA
                     AND STATUSHABILITACAO.CODSTATUS = SHABILITACAOALUNO.CODSTATUS
           JOIN SH... [TRUNCADO]

[CorporeRM].[dbo].[SHABILITACAOFILIAL]

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODCURSO], [CODGRADE], [CODHABILITACAO], [CODTURNO]

SELECT SHABILITACAOFILIAL.CODCOLIGADA,
                 SHABILITACAOFILIAL.CODFILIAL,
                 GFILIAL.NOMEFANTASIA             NOMEFILIAL,
                 SHABILITACAOFILIAL.CODTIPOCURSO,
                 STIPOCURSO.NOME                  NOMETIPOCURSO,
                 SMATRICPL.RA,
                 SMATRICPL.IDHABILITACAOFILIAL,
                 SCURSO.CODCURSO,
                 SCURSO.NOME                      NOMECURSO,
                 SHABILITACAO.CODHABILITACAO,  
                 SHABILITACAO.NOME                NOMEHABILITACAO,
                 SGRADE.DESCRICAO                 NOMEMATRIZ,
                 STURNO.NOME                      NOMETURNO,
                 SMATRICPL.IDPERLET,
                 SPLETIVO.CODPERLET,
                 SPLETIVO.DTINICIO,
                 STIPOCURSO.APRESENTACAO,
                 SMATRICPL.CODTURMA,
                 SMATRICPL.PERIODO,
                 STATUSHABILITACAO.DESCRICAO      SITMATHABILITACAO,
                 SSTATUS.DESCRICAO SITMATPERLET,
                 SMATRICPL.CODSTATUSRES,
                 GUSUARIO.EMAIL
          FROM   SHABILITACAOALUNO (NOLOCK)
           LEFT JOIN SSTATUS STATUSHABILITACAO (NOLOCK)
                  ON STATUSHABILITACAO.CODCOLIGADA = SHABILITACAOALUNO.CODCOLIGADA
                     AND STATUSHABILITACAO.CODSTATUS = SHABILITACAOALUNO.CODSTATUS
           JOIN SHABILITACAOFILIAL (NOLOCK)
                JOIN SCURSO (NOLOCK)
                  ON ( SHABILITAC... [TRUNCADO]

[CorporeRM].[dbo].[SLOGCAMPUS]

[CODCOLIGADA], [RA]

(@CODCOLIGADA smallint,@IDHABILITACAOFILIAL int,@RA varchar(8))--GlbWorkflowExecProc
SELECT SHABILITACAOALUNO.CODCOLIGADA, SHABILITACAOALUNO.IDHABILITACAOFILIAL, 
                   SHABILITACAOALUNO.RA, 
                   SHABILITACAOALUNO.CODTIPOINGRESSO, 
                   STIPOINGRESSO.DESCRICAO TIPOINGRESSO,
                   SHABILITACAOALUNO.CODINST, SHABILITACAOALUNO.CODSTATUS, 
                   SHABILITACAOALUNO.DTINGRESSO, SHABILITACAOALUNO.PONTOSVESTIBULAR, 
                   SHABILITACAOALUNO.CLASSIFICACAOVESTIBULAR, SHABILITACAOALUNO.MEDIAVESTIBULAR, 
                   SHABILITACAOALUNO.DTCOLACAOGRAU, SHABILITACAOALUNO.DTEMISDIPLOMA, 
                   SHABILITACAOALUNO.REGISTROCONCLUSAO, SHABILITACAOALUNO.LIVROREGISTRO, 
                   SHABILITACAOALUNO.PAGINAREGISTRO, SHABILITACAOALUNO.DTCONCLUSAOCURSO, 
                   SHABILITACAOALUNO.CR, SHABILITACAOALUNO.MEDIAGLOBAL, 
                   SHABILITACAOALUNO.DTPROVAO, SHABILITACAOALUNO.PROCESSOREGISTRO, 
                   SHABILITACAOALUNO.CODINSTDIPLOMA, SHABILITACAOALUNO.OBSERVACAO, 
                   SHABILITACAOALUNO.REALIZOUPROVAO, SHABILITACAOALUNO.IDHABILITACAOFILIALORIGEM, 
                   SHABILITACAOALUNO.CODMOTIVOTRANSFERENCIA, SHABILITACAOALUNO.MOTIVOTRANSFERENCIA, 
                   SHABILITACAOALUNO.INDICECARENCIA, 
                   SHABILITACAOALUNO.CODCAMPUS,
                   SHABILITACAOALUNO.LOCALIZACAOFISICA,
                   SHABILITACAOALUNO.CO... [TRUNCADO]

[CorporeRM].[dbo].[SCURSO]

[CODCOLIGADA], [CODMODALIDADECURSO]

[CODAREA]

SELECT "Col1029","Col1030","Col1027","Tbl1008"."CODMODALIDADECURSO" "Col1024" FROM "CorporeRM"."dbo"."SMODALIDADECURSO" "Tbl1008" WITH (NOLOCK),(SELECT "Tbl1004"."CODCOLIGADA" "Col1029","Tbl1004"."CODCURSO" "Col1030","Tbl1004"."CODAREA" "Col1031","Tbl1004"."CODMODALIDADECURSO" "Col1032","Tbl1006"."CODAREA" "Col1027","Tbl1004"."IDFT" "Col1033","Tbl1006"."CODCOLIGADA" "Col1026" FROM "CorporeRM"."dbo"."SAREA" "Tbl1006" WITH (NOLOCK),"CorporeRM"."dbo"."SCURSO" "Tbl1004" WITH (NOLOCK) WHERE "Tbl1004"."CODAREA"="Tbl1006"."CODAREA") Qry1034 WHERE "Col1029"="Tbl1008"."CODCOLIGADA" AND "Col1032"="Tbl1008"."CODMODALIDADECURSO"

[CorporeRM].[dbo].[FLAN]

[CODAPLICACAO], [CODCOLIGADA], [STATUSLAN]

[RECCREATEDON]

[CAMPOALFAOP1], [CODCCUSTO], [CODCFO], [CODCOLCFO], [CODFILIAL], [CODTB1FLX], [CODTDO], [DATAEMISSAO], [DATAVENCIMENTO], [HISTORICO], [NUMERODOCUMENTO], [SERIEDOCUMENTO], [VALORORIGINAL]

(@P_CODCOLIGADA int,@P_STATUSSUCESSO int)SELECT FLAN.CODCOLIGADA
  , FLAN.IDLAN
  , FLAN.CODFILIAL
  , FLAN.SERIEDOCUMENTO PREFIXO
 , FLAN.NUMERODOCUMENTO NUMERO
 , FLAN.CAMPOALFAOP1 AS PARCELA
  , FLAN.HISTORICO
 , FLAN.CODTDO
 , FLAN.CODTB1FLX NATUREZA
 , FLAN.DATAEMISSAO EMISSAO
 , FLAN.DATAVENCIMENTO VENCIMENTO
 , FLAN.VALORORIGINAL VALOR
 , FCFO.NOMEFANTASIA NOME
 , FCFO.CGCCFO CGC
 , FCFO.PESSOAFISOUJUR TIPOCLIENTE
 , FCFO.RUA ENDERECO 
 , FCFO.COMPLEMENTO
 , FCFO.BAIRRO
 , FCFO.CODMUNICIPIO MUNICIPIO 
 , FCFO.CODETD ESTADO 
 , FCFO.CEP
 , FCFO.INSCRESTADUAL INCRICAO_ESTADUAL
 , FCFO.EMAIL
  , FLAN.CODCCUSTO CENTROCUSTO
  , FLANCOMPL.ITEMCONTABIL ITEMCONTA
  , FLANCOMPL.CLASSEVALOR

FROM FLAN (NOLOCK)

JOIN FCFO (NOLOCK)
ON FLAN.CODCOLCFO = FCFO.CODCOLIGADA
AND FLAN.CODCFO = FCFO.CODCFO

LEFT JOIN ZINTBACKOFFICEPROTHEUSLANPROTHEUS (NOLOCK)
ON FLAN.CODCOLIGADA = ZINTBACKOFFICEPROTHEUSLANPROTHEUS.CODCOLIGADA
AND FLAN.IDLAN = ZINTBACKOFFICEPROTHEUSLANPROTHEUS.IDLAN

LEFT JOIN FLANCOMPL (NOLOCK)
ON FLAN.CODCOLIGADA = FLANCOMPL.CODCOLIGADA
AND FLAN.IDLAN = FLANCOMPL.IDLAN

WHERE FLAN.CODCOLIGADA = @P_CODCOLIGADA
AND FLAN.STATUSLAN = 1
AND FLAN.CODAPLICACAO = 'F'
AND (ZINTBACKOFFICEPROTHEUSLANPROTHEUS.IDLAN IS NULL OR ZINTBACKOFFICEPROTHEUSLANPROTHEUS.STATUSINTEGRACAO <> 
@P_STATUSSUCESSO)
AND NOT EXISTS (SELECT NULL FROM SLAN (NOLOCK)
    WHERE FLAN.CODCOLIGADA = SLAN.CODCOLIGADA
    AND FLAN.IDLAN = SLAN.IDLAN)
AND FLAN.RECCR... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODBLOCO], [CODDISC], [CODPREDIO], [CODSALA], [CODTURMA], [GERENCIAL], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO], [URLAULAONLINE]

SELECT SHORARIO.CODCOLIGADA,
                                 SHORARIO.CODHOR,
                                 SHORARIO.DIASEMANA,
                                 SHORARIO.HORAINICIAL,
                                 SHORARIO.HORAFINAL,
                                 STURMADISC.IDTURMADISC,
                                 STURMADISC.CODTURMA,
                                 SDISCIPLINA.NOMEREDUZIDO,
                                 SHORARIOTURMA.IDHORARIOTURMA,
                                 SHORARIOTURMA.DATAINICIAL,
                                 SHORARIOTURMA.DATAFINAL,
                                 SHORARIOSUBTUR.CODSUBTURMA,
                                 SDISCIPLINA.CODDISC,
                                 SDISCIPLINA.NOME,
                                 SCURSO.NOME                                                     CURSO,
                                 SHABILITACAO.NOME                                               HABILITACAO,
                                 STURMADISC.TIPO,
                                 COALESCE(SHORARIOTURMA.URLAULAONLINE, STURMADISC.URLAULAONLINE) URLAULAONLINE,
                                 CASE
                                   WHEN PREDIOHORARIOTURMA.CODPREDIO IS NOT NULL
                                         OR BLOCOHORARIOTURMA.CODBLOCO IS NOT NULL
                                         OR SALAHORARIOTURMA.CODSALA IS NOT NULL THEN CONCAT(CONCAT(PREDIOHORARIOTURMA.CODPREDIO, ' - '), PREDIO... [TRUNCADO]

[CorporeRM].[dbo].[STURMADISC]

[ATIVA], [CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODBLOCO], [CODDISC], [CODPREDIO], [CODSALA], [CODTURMA], [GERENCIAL], [IDHABILITACAOFILIAL], [IDPERLET], [TIPO], [URLAULAONLINE]

(@CODCOLIGADA smallint,@CODUSUARIO varchar(11))--EduQuadroHorarioProfData
SELECT SHORARIO.CODCOLIGADA,
                                 SHORARIO.CODHOR,
                                 SHORARIO.DIASEMANA,
                                 SHORARIO.HORAINICIAL,
                                 SHORARIO.HORAFINAL,
                                 STURMADISC.IDTURMADISC,
                                 STURMADISC.CODTURMA,
                                 SDISCIPLINA.NOMEREDUZIDO,
                                 SHORARIOTURMA.IDHORARIOTURMA,
                                 SHORARIOTURMA.DATAINICIAL,
                                 SHORARIOTURMA.DATAFINAL,
                                 SHORARIOSUBTUR.CODSUBTURMA,
                                 SDISCIPLINA.CODDISC,
                                 SDISCIPLINA.NOME,
                                 SCURSO.NOME                                                     CURSO,
                                 SHABILITACAO.NOME                                               HABILITACAO,
                                 STURMADISC.TIPO,
                                 COALESCE(SHORARIOTURMA.URLAULAONLINE, STURMADISC.URLAULAONLINE) URLAULAONLINE,
                                 CASE
                                   WHEN PREDIOHORARIOTURMA.CODPREDIO IS NOT NULL
                                         OR BLOCOHORARIOTURMA.CODBLOCO IS NOT NULL
                                         OR SALAHORARIOTURMA.CODSALA ... [TRUNCADO]

[CorporeRM].[dbo].[SHORARIO]

[CODCOLIGADA], [DIASEMANA]

[CLASSIFICACAO], [CODTURNO], [DISPONIVELPLANEJAMENTO], [HORAFINAL], [HORAINICIAL]

SELECT SHORARIO.CODCOLIGADA,
                                                                            SHORARIO.CODTURNO,
                                                                            SHORARIO.CODHOR,
                                                                            STURNO.NOME         TURNO,
                                                                            SHORARIO.DIASEMANA,
                                                                            SHORARIO.HORAINICIAL,
                                                                            SHORARIO.HORAFINAL,
                                                                            SHORARIO.CLASSIFICACAO,
                                                                            SHORARIO.DISPONIVELPLANEJAMENTO
                                                                      FROM  SHORARIO (NOLOCK),
                                                                            STURNO (NOLOCK)
                                                                      WHERE SHORARIO.CODCOLIGADA = STURNO.CODCOLIGADA
                                                                            AND SHORARIO.CODTURNO = STURNO.CODTURNO AND (SHORARIO.CODCOLIGADA = @CODCOLIGADA_N 
                           AND STURNO.CODTIPOCURSO = @CODTIPOCURSO_N 
                           AND STURNO.CODFILIAL = @CODFILIAL_N 
                           AND SHORARIO.DIASEMANA = @DIASEMANA_N )

[CorporeRM].[dbo].[SHORARIO]

[CODCOLIGADA], [DIASEMANA]

[CLASSIFICACAO], [CODTURNO], [DISPONIVELPLANEJAMENTO], [HORAFINAL], [HORAINICIAL]

SELECT SHORARIO.CODCOLIGADA,
                                                                            SHORARIO.CODTURNO,
                                                                            SHORARIO.CODHOR,
                                                                            STURNO.NOME         TURNO,
                                                                            SHORARIO.DIASEMANA,
                                                                            SHORARIO.HORAINICIAL,
                                                                            SHORARIO.HORAFINAL,
                                                                            SHORARIO.CLASSIFICACAO,
                                                                            SHORARIO.DISPONIVELPLANEJAMENTO
                                                                      FROM  SHORARIO (NOLOCK),
                                                                            STURNO (NOLOCK)
                                                                      WHERE SHORARIO.CODCOLIGADA = STURNO.CODCOLIGADA
                                                                            AND SHORARIO.CODTURNO = STURNO.CODTURNO AND (SHORARIO.CODCOLIGADA = @CODCOLIGADA_N 
                           AND STURNO.CODTIPOCURSO = @CODTIPOCURSO_N 
                           AND STURNO.CODFILIAL = @CODFILIAL_N 
                           AND SHORARIO.DIASEMANA = @DIASEMANA_N )

[CorporeRM].[dbo].[GMAILSEND]

[SENDTIME]

(@DATA datetime)--RMSMailServer
DELETE FROM GMAILSENDATTACH WHERE IDENVIO IN (SELECT IDENVIO FROM GMAILSEND (NOLOCK) WHERE SENDTIME < @DATA)

[CorporeRM].[dbo].[SETAPAS]

[CODCOLIGADA], [ETAPAENCERRADA], [IDTURMADISC], [TIPOETAPA]

[DTFIM], [DTINICIO]

(@CODCOLIGADA_N smallint,@IDTURMADISC_N int,@DATAPLANOAULA_D datetime)--EduPlanoAulaData
SELECT 1
           FROM SETAPAS
           WHERE CODCOLIGADA = @CODCOLIGADA_N
             AND IDTURMADISC = @IDTURMADISC_N
             AND TIPOETAPA = 'F'
             AND ETAPAENCERRADA = 'S'
             AND (DTINICIO IS NULL OR DTINICIO <= @DATAPLANOAULA_D)
             AND (DTFIM IS NULL OR DTFIM >= @DATAPLANOAULA_D)

SLOGCAMPUS

[CODCOLIGADA], [RA]

CREATE INDEX [IX_SLOGCAMPUS_CODCOLIGADA_RA_7ECB8] ON [CorporeRM].[dbo].[SLOGCAMPUS] ([CODCOLIGADA], [RA])

SCOORDENADOR

[CODPESSOA]

CREATE INDEX [IX_SCOORDENADOR_CODPESSOA_57187] ON [CorporeRM].[dbo].[SCOORDENADOR] ([CODPESSOA])

STURMADISC

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO], [ATIVA]

[GERENCIAL]

[CODTURMA], [IDPERLET], [CODDISC], [CODTURNO], [IDHABILITACAOFILIAL], [TIPO]

CREATE INDEX [IX_STURMADISC_CODCOLIGADA_CODFILIAL_CODTIPOCURSO_ATIVA_GERENCIAL_E03CF] ON [CorporeRM].[dbo].[STURMADISC] ([CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO], [ATIVA],[GERENCIAL]) INCLUDE ([CODTURMA], [IDPERLET], [CODDISC], [CODTURNO], [IDHABILITACAOFILIAL], [TIPO])

ZTEMPLATELOG

[CODCOLIGADA], [IDFUNCIONALIDADE], [MODULO], [CAMPOCHAVE], [VALORCHAVE]

CREATE INDEX [IX_ZTEMPLATELOG_CODCOLIGADA_IDFUNCIONALIDADE_MODULO_CAMPOCHAVE_VALORCHAVE_0305D] ON [CorporeRM].[dbo].[ZTEMPLATELOG] ([CODCOLIGADA], [IDFUNCIONALIDADE], [MODULO], [CAMPOCHAVE], [VALORCHAVE])

SCONTRATO

[CODCOLIGADA], [CODCONTRATO]

CREATE INDEX [IX_SCONTRATO_CODCOLIGADA_CODCONTRATO_D4D70] ON [CorporeRM].[dbo].[SCONTRATO] ([CODCOLIGADA], [CODCONTRATO])

FLAN

[CODFILIAL]

[HISTORICO]

[NUMERODOCUMENTO], [CODIGOBARRA], [IPTE], [CNABNOSSONUMERO], [NFOUDUP], [CLASSIFICACAO], [PAGREC], [STATUSLAN], [CODAPLICACAO], [IDFAT], [IDMOV], [IDPGTO], [CODCCUSTO], [DATACRIACAO], [DATAVENCIMENTO], [DATAEMISSAO], [DATABAIXA], [DATAPREVBAIXA], [DATACONTABILIZ], [DATACANCELAMENTO], [DATAOP1], [DATAOP2], [DATAOP3], [DATAOP4], [DATAOP5], [DATAPAG], [MESDECOMPETENCIA], [VALORORIGINAL], [VALORBAIXADO], [VALORJUROS], [VALORDESCONTO], [VALOROP1], [VALOROP2], [VALOROP3], [VALOROP4], [VALOROP5], [VALOROP6], [VALOROP7], [VALOROP8], [VALORMULTA], [VALORIRRF], [VALORDEVOLUCAO], [JUROSDIA], [CODCOLCFO], [CODCFO], [CODCOLCXA], [CODCXA], [CODTDO], [CODDEPARTAMENTO], [SERIEDOCUMENTO], [CODTB1FLX], [CODTB2FLX], [CODTB3FLX], [CODTB4FLX], [CODTB5FLX], [TIPOCONTABILLAN], [CODMOEVALORORIGINAL], [NUMEROCONTABIL], [SEGUNDONUMERO], [LIBAUTORIZADA], [STATUSEXPORTACAO], [STATUSEXTRATO], [CAMPOALFAOP1], [CAMPOALFAOP2], [CAMPOALFAOP3], [CNABSTATUS], [CNABBANCO], [CODVEN], [PERLETIVO], [PARCELA], [COTA], [USUARIO], [CODRPR], [BAIXAAUTORIZADA], [TEMCHEQUEPARCIAL], [JAIMPRIMIU], [NUMBLOQUEIOS], [CODUSUDESBLOQUEIO1], [CODUSUDESBLOQUEIO2], [CHAPA], [CARENCIAJUROS], [TIPOJUROSDIA], [USUARIOCRIACAO], [DATAALTERACAO], [ALTERACAOBLOQUEADA], [MULTADIA], [DESCONTADO], [VALORINSS], [CODRECEITA], [CNABCODRETORNO], [VRPERDAFINANCEIRA], [IDHISTORICO], [VALORDEDUCAODEPENDENTES], [BAIXAPENDENTE], [IDBORDERO], [VALORORIGINALBX], [VALORDESCONTOBX], [VALORJUROSBX], [VALORMULTABX], [VALORCAPBX], [VALOROP1BX], [VALOROP2BX], [VALOROP3BX], [VALOROP4BX], [VALOROP5BX], [VALOROP6BX], [VALOROP7BX], [VALOROP8BX], [VALORINSSBX], [VALORIRRFBX], [VALORSESTSENATBX], [VALORDEVOLUCAOBX], [VALORNOTACREDITOBX], [VALORADIANTAMENTOBX], [VALORJUROSVENDORBX], [VALORRETENCOESBX], [VALORPERDAFINANCEIRABX], [VALORVINCULADO], [MODELOCONTABILIZACAO], [MODELOCONTABILIZACAOBAIXA], [IDOPERACAO], [IDOPERACAOBAIXA], [IDLANMOVORIGEM], [VALORDESCONTOACORDO], [VALORJUROSACORDO], [VALORACRESCIMOACORDO], [IDCONVENIO], [INDNATREC], [NATREC], [DATAORCAMENTO], [STATUSORCAMENTO], [CODCOLTOMADOR], [CODTOMADOR], [IDCEITOMADOR], [VALORDEDUCAOVARIAVEL], [CLASSIFICACAOPAGREC], [STATUSLIQDUVIDOSA], [CLASSELCDPR], [TIPOLCDPR], [CPFCNPJLCDPR], [MODALIDADELCDPR], [STATUSNEGATIVACAO], [STATUSTERCEIRIZACAO], [QRCODEPIX], [CODCOLCONVENIO], [STATUSAPROVACAO], [DATACONTROLEAPROVACAO], [IDFLUIG], [IDNATRENDIMENTOIRRF]

CREATE INDEX [IX_FLAN_CODFILIAL_HISTORICO_FE6F5] ON [CorporeRM].[dbo].[FLAN] ([CODFILIAL],[HISTORICO]) INCLUDE ([NUMERODOCUMENTO], [CODIGOBARRA], [IPTE], [CNABNOSSONUMERO], [NFOUDUP], [CLASSIFICACAO], [PAGREC], [STATUSLAN], [CODAPLICACAO], [IDFAT], [IDMOV], [IDPGTO], [CODCCUSTO], [DATACRIACAO], [DATAVENCIMENTO], [DATAEMISSAO], [DATABAIXA], [DATAPREVBAIXA], [DATACONTABILIZ], [DATACANCELAMENTO], [DATAOP1], [DATAOP2], [DATAOP3], [DATAOP4], [DATAOP5], [DATAPAG], [MESDECOMPETENCIA], [VALORORIGINAL], [VALORBAIXADO], [VALORJUROS], [VALORDESCONTO], [VALOROP1], [VALOROP2], [VALOROP3], [VALOROP4], [VALOROP5], [VALOROP6], [VALOROP7], [VALOROP8], [VALORMULTA], [VALORIRRF], [VALORDEVOLUCAO], [JUROSDIA], [CODCOLCFO], [CODCFO], [CODCOLCXA], [CODCXA], [CODTDO], [CODDEPARTAMENTO], [SERIEDOCUMENTO], [CODTB1FLX], [CODTB2FLX], [CODTB3FLX], [CODTB4FLX], [CODTB5FLX], [TIPOCONTABILLAN], [CODMOEVALORORIGINAL], [NUMEROCONTABIL], [SEGUNDONUMERO], [LIBAUTORIZADA], [STATUSEXPORTACAO], [STATUSEXTRATO], [CAMPOALFAOP1], [CAMPOALFAOP2], [CAMPOALFAOP3], [CNABSTATUS], [CNABBANCO], [CODVEN], [PERLETIVO], [PARCELA], [COTA], [USUARIO], [CODRPR], [BAIXAAUTORIZADA], [TEMCHEQUEPARCIAL], [JAIMPRIMIU], [NUMBLOQUEIOS], [CODUSUDESBLOQUEIO1], [CODUSUDESBLOQUEIO2], [CHAPA], [CARENCIAJUROS], [TIPOJUROSDIA], [USUARIOCRIACAO], [DATAALTERACAO], [ALTERACAOBLOQUEADA], [MULTADIA], [DESCONTADO], [VALORINSS], [CODRECEITA], [CNABCODRETORNO], [VRPERDAFINANCEIRA], [IDHISTORICO], [VALORDEDUCAODEPENDENTES], [BAIXAPENDENTE], [IDBORDERO], [VALORORIGINALBX], [VALORDESCONTOBX], [VALORJUROSBX], [VALORMULTABX], [VALORCAPBX], [VALOROP1BX], [VALOROP2BX], [VALOROP3BX], [VALOROP4BX], [VALOROP5BX], [VALOROP6BX], [VALOROP7BX], [VALOROP8BX], [VALORINSSBX], [VALORIRRFBX], [VALORSESTSENATBX], [VALORDEVOLUCAOBX], [VALORNOTACREDITOBX], [VALORADIANTAMENTOBX], [VALORJUROSVENDORBX], [VALORRETENCOESBX], [VALORPERDAFINANCEIRABX], [VALORVINCULADO], [MODELOCONTABILIZACAO], [MODELOCONTABILIZACAOBAIXA], [IDOPERACAO], [IDOPERACAOBAIXA], [IDLANMOVORIGEM], [VALORDESCONTOACORDO], [VALORJUROSACORDO], [VALORACRESCIMOACORDO], [IDCONVENIO], [INDNATREC], [NATREC], [DATAORCAMENTO], [STATUSORCAMENTO], [CODCOLTOMADOR], [CODTOMADOR], [IDCEITOMADOR], [VALORDEDUCAOVARIAVEL], [CLASSIFICACAOPAGREC], [STATUSLIQDUVIDOSA], [CLASSELCDPR], [TIPOLCDPR], [CPFCNPJLCDPR], [MODALIDADELCDPR], [STATUSNEGATIVACAO], [STATUSTERCEIRIZACAO], [QRCODEPIX], [CODCOLCONVENIO], [STATUSAPROVACAO], [DATACONTROLEAPROVACAO], [IDFLUIG], [IDNATRENDIMENTOIRRF])

SHABILITACAOFILIAL

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODTURNO], [CODCURSO], [CODHABILITACAO], [CODGRADE]

CREATE INDEX [IX_SHABILITACAOFILIAL_CODCOLIGADA_CODFILIAL_CODTIPOCURSO_F7B97] ON [CorporeRM].[dbo].[SHABILITACAOFILIAL] ([CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]) INCLUDE ([CODTURNO], [CODCURSO], [CODHABILITACAO], [CODGRADE])

GMAILSEND

[SENDTIME]

CREATE INDEX [IX_GMAILSEND__SENDTIME_8CAB3] ON [CorporeRM].[dbo].[GMAILSEND] ([SENDTIME])

SALUNO

[RA]

CREATE INDEX [IX_SALUNO_RA_54877] ON [CorporeRM].[dbo].[SALUNO] ([RA])

STURMADISC

[CODCOLIGADA], [IDPERLET]

[CODFILIAL], [CODTURMA], [CODDISC], [CODTIPOCURSO]

CREATE INDEX [IX_STURMADISC_CODCOLIGADA_IDPERLET_59810] ON [CorporeRM].[dbo].[STURMADISC] ([CODCOLIGADA], [IDPERLET]) INCLUDE ([CODFILIAL], [CODTURMA], [CODDISC], [CODTIPOCURSO])

SMATRICPL

[CODCOLIGADA], [CODFILIAL]

[CODTIPOMAT], [CODTURMA], [CODSTATUSRES], [CODSTATUS], [DTMATRICULA], [DTRESULTADO], [IDENTIFICADOR], [NUMCARTEIRA], [VIACARTEIRA], [PERIODO], [NUMALUNO], [CARTEIRAEMITIDA], [DTSOLICITACAOALTERACAO], [CR], [CODINSTDESTINO], [CODMOTIVOTRANSFERENCIA], [DTMATRICULAENCERRA], [ANOREFERENCIAENADE]

CREATE INDEX [IX_SMATRICPL_CODCOLIGADA_CODFILIAL_9B621] ON [CorporeRM].[dbo].[SMATRICPL] ([CODCOLIGADA], [CODFILIAL]) INCLUDE ([CODTIPOMAT], [CODTURMA], [CODSTATUSRES], [CODSTATUS], [DTMATRICULA], [DTRESULTADO], [IDENTIFICADOR], [NUMCARTEIRA], [VIACARTEIRA], [PERIODO], [NUMALUNO], [CARTEIRAEMITIDA], [DTSOLICITACAOALTERACAO], [CR], [CODINSTDESTINO], [CODMOTIVOTRANSFERENCIA], [DTMATRICULAENCERRA], [ANOREFERENCIAENADE])

SMATRICPL

[CODCOLIGADA], [CODFILIAL], [CODSTATUS]

[CODTIPOMAT], [CODTURMA], [CODSTATUSRES], [DTMATRICULA], [DTRESULTADO], [IDENTIFICADOR], [NUMCARTEIRA], [VIACARTEIRA], [PERIODO], [NUMALUNO], [CARTEIRAEMITIDA], [DTSOLICITACAOALTERACAO], [CR], [CODINSTDESTINO], [CODMOTIVOTRANSFERENCIA], [DTMATRICULAENCERRA], [ANOREFERENCIAENADE]

CREATE INDEX [IX_SMATRICPL_CODCOLIGADA_CODFILIAL_CODSTATUS_F4A0E] ON [CorporeRM].[dbo].[SMATRICPL] ([CODCOLIGADA], [CODFILIAL], [CODSTATUS]) INCLUDE ([CODTIPOMAT], [CODTURMA], [CODSTATUSRES], [DTMATRICULA], [DTRESULTADO], [IDENTIFICADOR], [NUMCARTEIRA], [VIACARTEIRA], [PERIODO], [NUMALUNO], [CARTEIRAEMITIDA], [DTSOLICITACAOALTERACAO], [CR], [CODINSTDESTINO], [CODMOTIVOTRANSFERENCIA], [DTMATRICULAENCERRA], [ANOREFERENCIAENADE])

SETAPAS

[CODCOLIGADA], [IDTURMADISC], [TIPOETAPA]

[DTINICIO], [DTFIM]

[DTLIMITECONTPREVISTO], [DTLIMITECONTEFETIVO]

CREATE INDEX [IX_SETAPAS_CODCOLIGADA_IDTURMADISC_TIPOETAPA_DTINICIO_DTFIM_59DDB] ON [CorporeRM].[dbo].[SETAPAS] ([CODCOLIGADA], [IDTURMADISC], [TIPOETAPA],[DTINICIO], [DTFIM]) INCLUDE ([DTLIMITECONTPREVISTO], [DTLIMITECONTEFETIVO])

SETAPAS

[CODCOLIGADA], [IDTURMADISC], [TIPOETAPA], [ETAPAENCERRADA]

[DTINICIO], [DTFIM]

CREATE INDEX [IX_SETAPAS_CODCOLIGADA_IDTURMADISC_TIPOETAPA_ETAPAENCERRADA_DTINICIO_DTFIM_EC09F] ON [CorporeRM].[dbo].[SETAPAS] ([CODCOLIGADA], [IDTURMADISC], [TIPOETAPA], [ETAPAENCERRADA],[DTINICIO], [DTFIM])

SLOGPLETIVO

[CODCOLIGADA], [IDPERLET], [CODFILIAL], [CODTURMA]

[DTALTERACAO]

[OPERACAO], [CODSTATUSRES], [CODSTATUSANT]

CREATE INDEX [IX_SLOGPLETIVO_CODCOLIGADA_IDPERLET_CODFILIAL_CODTURMA_DTALTERACAO_01D6D] ON [CorporeRM].[dbo].[SLOGPLETIVO] ([CODCOLIGADA], [IDPERLET], [CODFILIAL], [CODTURMA],[DTALTERACAO]) INCLUDE ([OPERACAO], [CODSTATUSRES], [CODSTATUSANT])

SHABILITACAOFILIAL

[CODCOLIGADA], [CODTIPOCURSO]

[CODTURNO], [CODCURSO], [CODHABILITACAO], [CODGRADE]

CREATE INDEX [IX_SHABILITACAOFILIAL_CODCOLIGADA_CODTIPOCURSO_082BF] ON [CorporeRM].[dbo].[SHABILITACAOFILIAL] ([CODCOLIGADA], [CODTIPOCURSO]) INCLUDE ([CODTURNO], [CODCURSO], [CODHABILITACAO], [CODGRADE])

FLAN

[CODCOLIGADA], [STATUSLAN], [CODAPLICACAO]

[RECCREATEDON]

[NUMERODOCUMENTO], [CODCCUSTO], [HISTORICO], [DATAVENCIMENTO], [DATAEMISSAO], [VALORORIGINAL], [CODCOLCFO], [CODCFO], [CODTDO], [CODFILIAL], [SERIEDOCUMENTO], [CODTB1FLX], [CAMPOALFAOP1]

CREATE INDEX [IX_FLAN_CODCOLIGADA_STATUSLAN_CODAPLICACAO_RECCREATEDON_6E42C] ON [CorporeRM].[dbo].[FLAN] ([CODCOLIGADA], [STATUSLAN], [CODAPLICACAO],[RECCREATEDON]) INCLUDE ([NUMERODOCUMENTO], [CODCCUSTO], [HISTORICO], [DATAVENCIMENTO], [DATAEMISSAO], [VALORORIGINAL], [CODCOLCFO], [CODCFO], [CODTDO], [CODFILIAL], [SERIEDOCUMENTO], [CODTB1FLX], [CAMPOALFAOP1])

SLOGPLETIVO

[CODCOLIGADA]

[DTALTERACAO]

[CODFILIAL], [CODTURMA], [OPERACAO], [CODSTATUSRES], [CODSTATUSANT]

CREATE INDEX [IX_SLOGPLETIVO_CODCOLIGADA_DTALTERACAO_E252F] ON [CorporeRM].[dbo].[SLOGPLETIVO] ([CODCOLIGADA],[DTALTERACAO]) INCLUDE ([CODFILIAL], [CODTURMA], [OPERACAO], [CODSTATUSRES], [CODSTATUSANT])

STURMADISC

[CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO]

[CODTURMA]

[IDPERLET], [CODDISC], [CODTURNO], [CODPREDIO], [CODSALA], [IDHABILITACAOFILIAL], [DURACAOAULA], [MAXALUNOS], [DTINICIAL], [DTFINAL], [NOME], [TIPO], [CODCAMPUS], [CODBLOCO], [ADICIONALNOTURNO], [ADICIONALEXTRA], [VAGASCALOUROS], [NUMMAXALUNOOUTROSCURSOS], [DISPONIVELMATRICULA], [VAGASLISTAESPERA], [NUMCREDITOSCOB], [VALORCREDITO], [DTINICIOMATPRES], [DTFIMMATPRES], [DTINICIOMATPORTAL], [DTFIMMATPORTAL], [RECCREATEDBY], [RECCREATEDON], [RECMODIFIEDBY], [RECMODIFIEDON], [ATIVA], [GERENCIAL], [ALIASCOMUNIDADE], [CODAGENDA], [TIPONOTA]

CREATE INDEX [IX_STURMADISC_CODCOLIGADA_CODFILIAL_CODTIPOCURSO_CODTURMA_2A07A] ON [CorporeRM].[dbo].[STURMADISC] ([CODCOLIGADA], [CODFILIAL], [CODTIPOCURSO],[CODTURMA]) INCLUDE ([IDPERLET], [CODDISC], [CODTURNO], [CODPREDIO], [CODSALA], [IDHABILITACAOFILIAL], [DURACAOAULA], [MAXALUNOS], [DTINICIAL], [DTFINAL], [NOME], [TIPO], [CODCAMPUS], [CODBLOCO], [ADICIONALNOTURNO], [ADICIONALEXTRA], [VAGASCALOUROS], [NUMMAXALUNOOUTROSCURSOS], [DISPONIVELMATRICULA], [VAGASLISTAESPERA], [NUMCREDITOSCOB], [VALORCREDITO], [DTINICIOMATPRES], [DTFIMMATPRES], [DTINICIOMATPORTAL], [DTFIMMATPORTAL], [RECCREATEDBY], [RECCREATEDON], [RECMODIFIEDBY], [RECMODIFIEDON], [ATIVA], [GERENCIAL], [ALIASCOMUNIDADE], [CODAGENDA], [TIPONOTA])

SPSINSCRICAOAREAOFERTADA

[CODCOLIGADAMAT], [IDPERLET], [IDHABFILIALMAT], [RAMAT]

CREATE INDEX [IX_SPSINSCRICAOAREAOFERTADA_CODCOLIGADAMAT_IDPERLET_IDHABFILIALMAT_RAMAT_4421E] ON [CorporeRM].[dbo].[SPSINSCRICAOAREAOFERTADA] ([CODCOLIGADAMAT], [IDPERLET], [IDHABFILIALMAT], [RAMAT])