SELECT

	Nome AS "NOME",
	Funcional->CargoEfetivo->Descricao AS "CARGO",
	Funcional->DataIngOrgaoFormatada AS "DT. ING.", 
        Financeiro->DataDesligamento as "DESLIG",
        Funcional->TipoServidor->descricao,
        DATEDIFF(year, PESSOA->datanascimento, CAST((:p1 || '-12-31') AS Date )) AS "IDADE P.REF",
	COUNT('QTD') AS "QTD"

FROM RHCadServidor 

WHERE
	( Funcional->TipoServidor->Codigo IN (10))
	AND ( Funcional->DataIngOrgao <= CAST((:p1 || '-12-31') AS Date ))
	AND (
			( Financeiro->DataDesligamento IS NULL )
			OR
			( Financeiro->DataDesligamento > CAST((:p1 || '-12-31') AS Date )))
        AND (FUNCIONAL->LOTACAOEXERCICIO->CODIGO NOT IN (200360,200373,200378,200386,200387, 200388, 200359))
 

ORDER BY
	FUNCIONAL->TIPOSERVIDOR->DESCRICAO,
	Nome