Exibir código-fonte para Usuários de escolas

<syntaxhighlight lang="sql" line="1" >
/*
- Usuários de escola (CP, diretor..)
*/

USE PUB_SPO_GestaoPedagogica --ALTERAR BD
GO

SELECT
	UadSuperior.uad_nome AS DRE
	, Esc.esc_nome AS Escola
	, Pes.pes_nome as Nome
	, Usu.usu_login AS [login]
	, Gru.gru_nome AS GrupoLogin
	,visao.vis_nome AS Visão
FROM RHU_Colaborador Col WITH(NOLOCK)
INNER JOIN Synonym_PES_Pessoa Pes WITH(NOLOCK)
	ON Pes.pes_id = Col.pes_id
INNER JOIN Synonym_SYS_Usuario Usu WITH(NOLOCK)
	ON Usu.pes_id = Pes.pes_id
	AND Usu.usu_situacao <> 3
INNER JOIN Synonym_SYS_UsuarioGrupo UGru WITH(NOLOCK)
	ON Ugru.usu_id = Usu.usu_id
	AND UGru.usg_situacao <> 3
INNER JOIN PUB_SPO_CoreSSO..SYS_UsuarioGrupoUA UGruUA WITH(NOLOCK) --ALTERAR BD
	ON UGruUA.gru_id = UGru.gru_id
	AND UGruUA.usu_id = Usu.usu_id
INNER JOIN Synonym_SYS_Grupo Gru WITH(NOLOCK)
	ON Gru.gru_id = UGru.gru_id
	AND Gru.gru_situacao <> 3
	AND Gru.sis_id = 102 -- SGP

INNER JOIN Synonym_SYS_UnidadeAdministrativa Uad WITH(NOLOCK)
	ON Uad.ent_id = UGruUA.ent_id
	AND Uad.uad_id = UGruUA.uad_id

INNER JOIN ESC_Escola Esc WITH(NOLOCK)
	ON Esc.ent_id = Uad.ent_id
	AND Esc.uad_id = Uad.uad_id
	AND Esc.esc_situacao <> 3

INNER JOIN Synonym_SYS_UnidadeAdministrativa UadSuperior WITH(NOLOCK)
	ON UadSuperior.ent_id = Uad.ent_id
	AND UadSuperior.uad_id = ISNULL(esc.uad_idSuperiorGestao, Uad.uad_idSuperior)

INNER JOIN PUB_SPO_CoreSSO..SYS_Visao visao WITH(NOLOCK) ON visao.vis_id = Gru.vis_id --ALTERAR BD

WHERE
	Col.col_situacao <> 3
	--AND NOT EXISTS (SELECT 1 FROM ACA_Docente Doc WITH(NOLOCK) WHERE Doc.col_id = Col.col_id AND Doc.doc_situacao <> 3)

order by
	Uad.uad_nome
	, Pes.pes_nome
</syntaxhighlight>