WITH NIVEL1 AS (
	SELECT
		T0."Code"
		, T0."U_Perspectiva"
		, T0."U_Sigla"
		, T0."U_Pai"
		, T0."U_Objetivo"
		, T0."U_Indicador"
	FROM
		"@PLANEJAMENTO" T0
	WHERE
		IFNULL(T0."U_Pai", '') = '-'
)
,  NIVEL2 AS (
	SELECT
		T0."Code"
		, T0."U_Perspectiva"
		, T0."U_Sigla"
		, T0."U_Pai"
		, T0."U_Objetivo"
		, T0."U_Indicador"
	FROM
		"@PLANEJAMENTO" T0
	 	INNER JOIN NIVEL1 T1 ON T1."U_Sigla" = T0."U_Pai"
)
,  NIVEL3 AS (
	SELECT
		T0."Code"
		, T0."U_Perspectiva"
		, T0."U_Sigla"
		, T0."U_Pai"
		, T0."U_Objetivo"
		, T0."U_Indicador"
	FROM
		"@PLANEJAMENTO" T0
	 	INNER JOIN NIVEL2 T1 ON T1."U_Sigla" = T0."U_Pai"
)
,  NIVEL4 AS (
	SELECT
		T0."Code"
		, T0."U_Perspectiva"
		, T0."U_Sigla"
		, T0."U_Pai"
		, T0."U_Objetivo"
		, T0."U_Indicador"
	FROM
		"@PLANEJAMENTO" T0
	 	INNER JOIN NIVEL3 T1 ON T1."U_Sigla" = T0."U_Pai"
)

SELECT DISTINCT
	T0."Code" AS NIVEL1_CODE
	, T0."U_Perspectiva" AS NIVEL1_PERSPECTIVA
	, T0."U_Sigla" AS NIVEL1_SIGLA
	, T0."U_Pai" AS NIVEL1_PAI
	, T0."U_Objetivo" AS NIVEL1_OBJETIVO
	, T0."U_Indicador" AS NIVEL1_INDICADOR
	, YEAR(A0."U_Ano") AS NIVEL1_ANO
	, A0."U_Valor" AS NIVEL1_VALOR
	, T1."Code" AS NIVEL2_CODE
	, T1."U_Perspectiva" AS NIVEL2_PERSPECTIVA
	, T1."U_Sigla" AS NIVEL2_SIGLA
	, T1."U_Pai" AS NIVEL2_PAI
	, T1."U_Objetivo" AS NIVEL2_OBJETIVO
	, T1."U_Indicador" AS NIVEL2_INDICADOR
	, YEAR(A1."U_Ano") AS NIVEL2_ANO
	, A1."U_Valor" AS NIVEL2_VALOR
	, T2."Code" AS NIVEL3_CODE
	, T2."U_Perspectiva" AS NIVEL3_PERSPECTIVA
	, T2."U_Sigla" AS NIVEL3_SIGLA
	, T2."U_Pai" AS NIVEL3_PAI
	, T2."U_Objetivo" AS NIVEL3_OBJETIVO
	, T2."U_Indicador" AS NIVEL3_INDICADOR
	, YEAR(A2."U_Ano") AS NIVEL3_ANO
	, A2."U_Valor" AS NIVEL3_VALOR
FROM
	NIVEL1 T0 LEFT JOIN "@PLANEJAMENTOVALOR" A0 ON A0."Code" = T0."Code"
	, NIVEL2 T1 LEFT JOIN "@PLANEJAMENTOVALOR" A1 ON A1."Code" = T1."Code"
	, NIVEL3 T2 LEFT JOIN "@PLANEJAMENTOVALOR" A2 ON A2."Code" = T2."Code"
ORDER BY
	T0."Code"
	, T1."Code"
	, T2."Code"
	, YEAR(A1."U_Ano")
	, YEAR(A0."U_Ano")
	, YEAR(A2."U_Ano")