<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="no_planilla_nodet_siif" language="groovy" pageWidth="810" pageHeight="752" columnWidth="810" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="2.0490403660952135"/>
	<property name="ireport.x" value="528"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/no_planilla_nom_siif"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18080/jasperserver/services/repository"/>
	<parameter name="id_periodo_filtro" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="comando" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereClasePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="desc_clase" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="wherePago" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="tag_rete" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<parameter name="entidad_cliente" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cen_op" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<parameter name="format" class="java.lang.String">
		<defaultValueExpression><![CDATA["PDF"]]></defaultValueExpression>
	</parameter>
	<parameter name="wherePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="salto_linea" class="java.lang.String">
		<defaultValueExpression><![CDATA["  "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_agrup_rec" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<parameter name="whereInClasePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

' - '||(select max(abreviatura) from datos_compania where id = 1) as abreviatura,

informe.id_periodo,
informe.tipcod,
informe.tipo,
informe.tipcod || ' - ' || informe.tipo as completo_tipo,
informe.codigo,
informe.descripcion,
informe.valor,
funcionarios.cantidad as cantidad,

informe.rubro,
informe.descripcion_rub,
informe.CODIGO_SIIF,
informe.DESCRIPCION_siif,
informe.tercero_nit,

case when informe.tipcod = '01' then informe.rubro else informe.CODIGO_SIIF end as rubro_list,
case when informe.tipcod = '01' then informe.descripcion_rub else informe.DESCRIPCION_siif end as descripcion_rubro_list,
case when informe.tipcod = '01' then (select max(NIT) from datos_compania where id = 1) else informe.tercero_nit end as identificacion,
informe.atributo_cont,
informe.tipo_gasto,

(
    select distinct periodo.periodo
    from no_periodo_v periodo
    where periodo.id_periodo = $P{id_periodo_filtro}
) as periodo,

nvl( (
    select max(cenop.nom_cen_op)
    from centro_operacion cenop
    where
    1 = 1
    and cenop.id_cen_op = $P{id_cen_op}
), 'CONSOLIDADO') as cen_op

from(

    select
    id_periodo,tipcod,tipo,codigo,descripcion,
    rubro,descripcion_rub,CODIGO_SIIF,DESCRIPCION_siif,tercero_nit,atributo_cont,tipo_gasto,
    sum(valor_liquidado) valor
    from(

        select tab0.* from(

            select
            rub.rubro,
            rub.descripcion as descripcion_rub,
            listcon.CODIGO_SIIF,
            nvl(ter.razon_soc,concep.descripcion) || case when concep.descripcion like '%SOLID%' then ' - Fondo de Solidaridad' else  '' end as DESCRIPCION_siif,

            ter.num_doc as tercero_nit,

            rub.atributo_contable as atributo_cont,
            rub.tipo_Gasto_nom as tipo_gasto,

            concep.id_tipo_concepto,
            liquida.id_periodo,tipo.codigo as tipcod,tipo.descripcion as tipo,
            concep.codigo,concep.descripcion,liquida.valor_liquidado,liquida.num_doc,liquida.id_tipo_doc,
            tab5.id_cen_op,
            cargo.id_planta_p

            from no_liquida_nomina liquida

            left join no_concep_nomina concep on concep.id_concep_nomina = liquida.id_concep_nomina and concep.pago_func = 1
            left join no_tipo_concepto tipo on tipo.id_tipo_concepto = concep.id_tipo_concepto
            left join pr_rubro_presup_v rub on rub.id_rubro = concep.id_rubro
            left join no_lista_conceptos_siif listcon on listcon.ID_LISTA_CONCEPTOS_SIIF = concep.ID_LISTA_CONCEPTOS_SIIF
            left join interceros_v ter on ter.id_mae_ter = concep.id_acreedor

            left join pr_rubro_agrup_rec agrup on agrup.id_rubro = concep.id_rubro

            left join (

            select nom.*,
            case when tab.num_doc is not null then 1 else 0 end as pago
            from no_nombramiento_v nom

            left join (select distinct
            pago.id_tipo_doc,
            pago.num_doc
            from no_pago_func pago
            where
            (select fecha_fin from no_periodo where id_periodo = $P{id_periodo_filtro}) between pago.fecha_activacion and nvl(pago.fecha_terminacion, (select fecha_fin from no_periodo where id_periodo = $P{id_periodo_filtro}))
            )tab
            on tab.id_tipo_doc = nom.id_tipo_doc and tab.num_doc = nom.num_doc

            )tab0
            on tab0.id_tipo_doc = liquida.id_tipo_doc and tab0.num_doc = liquida.num_doc

            left join NO_ESTADO_FUNC_V tab5 on
            tab5.id_tipo_doc = liquida.id_tipo_doc
            and tab5.num_doc = liquida.num_doc
            and tab5.periodo = liquida.id_periodo

            left join no_dp_v cargo on cargo.id_dp = tab5.id_dp

            where liquida.id_periodo = $P{id_periodo_filtro} and tipo.id_tipo_concepto!=4
            $P!{whereInClasePlanta} $P!{wherePago}
            --filtro func con retefuente - 20140710
            and (
            0 = $P{tag_rete}
            or
            liquida.num_doc in (select distinct tab.num_doc from no_liquida_nomina tab where tab.id_periodo = $P{id_periodo_filtro} and tab.id_concep_nomina = (select no_param_concep.id_concep_rete from no_param_concep))
            )
            /*Se coloca filtro de id_agrup_rec - 20210317*/
            and (case when 0 = nvl($P{id_agrup_rec},0) then 1
                      else (case when nvl(agrup.id_agrup_rec,5) = $P{id_agrup_rec} then 1
                                 when nvl(agrup.id_agrup_rec,6) = $P{id_agrup_rec} then 1
                            else 0 end)
                      end
                ) = 1

        )tab0

        left join(

            select

            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
            tab.estado,

            sum(nvl(tab.valor,0)) as valor,
            sum(nvl(valor_nac,0)) as valor_nac,
            sum(nvl(valor_pro,0)) as valor_pro,

            sum(nvl(tab.valor_dev,0)) as valor_dev,
            sum(nvl(tab.valor_ded,0)) as valor_ded

            from(

                select
                rub.descripcion as descripcion_rub, rub.rubro as  codigo_rubro, rub.id_tipo_atributo_contab,
                tab5.operador,
                tab1.num_doc,tab6.nombre_apellido,

                case when nvl(tab2.estado,0) = 0 and tab7.estado = 0 and tab2.fecha_terminacion <= tab7.fecha_termina then 1 else nvl(tab2.estado,0) end as estado,

                case when agrup.id_agrup_rec = 5
                    then
                    case when tab5.operador = 1 then tab1.valor_liquidado
                         when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end
                    else 0 end as valor_nac,
                case when agrup.id_agrup_rec = 6
                    then
                    case when tab5.operador = 1 then tab1.valor_liquidado
                         when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end
                    else 0 end as valor_pro,

                case when tab5.operador = 1 then tab1.valor_liquidado
                     when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end as valor,
                case when tab5.operador = 1 then tab1.valor_liquidado
                     when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else 0 end as valor_dev,
                case when tab5.operador = 0 and tab5.id_tipo_concepto_org != 1 then tab1.valor_liquidado else 0 end as valor_ded,
                tab1.id_periodo,
                tab1.id_tipo_doc

                from no_liquida_nomina tab1

                left join no_concep_nomina tab5 on tab5.id_concep_nomina = tab1.id_concep_nomina
                left join pr_rubro_presup_v rub on  rub.id_rubro = tab5.id_rubro
                left join pr_rubro_agrup_rec agrup on agrup.id_rubro = tab5.id_rubro
                left join no_datos_funcionario_v tab6  on tab6.id_tipo_doc = tab1.id_tipo_doc and tab6.num_doc = tab1.num_doc


                --join no_pago_func tab2 on tab2.id_tipo_doc = tab1.id_tipo_doc and tab2.num_doc = tab1.num_doc
                left join (
                  SELECT
                   aut.*,
                   ROW_NUMBER() OVER (
                    partition by aut.num_doc
                    ORDER BY aut.num_doc asc, aut.fecha_activacion desc, aut.id_pago_func desc
                   ) AS rn
                  from no_pago_func aut
                )tab2
                on tab1.id_tipo_doc = tab2.id_tipo_doc and tab1.num_doc = tab2.num_doc
                and tab2.rn = 1
                left join no_nombramiento_v tab7  ON tab7.id_tipo_doc = tab1.id_tipo_doc and tab7.num_doc = tab1.num_doc


                where
                tab1.id_periodo = $P{id_periodo_filtro}
                and tab5.pago_func = 1

                /*and (case when tab5.operador = 0 then 1 else (case when nvl(rub.id_tipo_atributo_contab,1) = 1 then 1 else 0 end) end) = 1*/

                /*and tab5.id_rubro is null*//* and tab5.id_lista_conceptos_siif is not null*/

            )tab

            group by
            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
            tab.estado

        )tabagruprec
        on tabagruprec.id_periodo = tab0.id_periodo
        and tabagruprec.id_tipo_doc = tab0.id_tipo_doc
        and tabagruprec.num_doc = tab0.num_doc

        where
        1 = 1
        $P!{whereCenOp}
        $P!{wherePlanta}

        /*Se coloca filtro de id_agrup_rec - 20210317*/
        and (case when 0 = nvl($P{id_agrup_rec},0) or tab0.id_tipo_concepto = 1 then 1
                  else (case when nvl($P{id_agrup_rec},0) = 5 and (tabagruprec.valor_nac - tabagruprec.valor_ded) >= 0 then 1
                             when nvl($P{id_agrup_rec},0) = 6 and (tabagruprec.valor_nac - tabagruprec.valor_ded) <  0 and (tabagruprec.valor_pro - tabagruprec.valor_ded) >=  0 then 1
                        else 0 end)
                  end
            ) = 1

    )group by id_periodo,tipcod,tipo,codigo,descripcion,
    rubro,descripcion_rub,CODIGO_SIIF,DESCRIPCION_siif,tercero_nit,atributo_cont,tipo_gasto

)informe

left join(

    select concep.codigo,count(concep.num_doc) cantidad
    from (

    select tab0.* from(

            select
            concep.id_tipo_concepto,
            liquida.id_periodo,
            concep.codigo,
            liquida.num_doc,
            liquida.id_tipo_doc,
            tab5.id_cen_op,
            cargo.id_planta_p

            from no_liquida_nomina liquida
            left join no_concep_nomina concep on concep.id_concep_nomina = liquida.id_concep_nomina and concep.pago_func = 1
            left join no_tipo_concepto tipo on tipo.id_tipo_concepto = concep.id_tipo_concepto
            left join (

                select nom.*,
                case when tab.num_doc is not null then 1 else 0 end as pago
                from no_nombramiento_v nom

                left join (select distinct
                pago.id_tipo_doc,
                pago.num_doc
                from no_pago_func pago
                where
                (select fecha_fin from no_periodo where id_periodo = $P{id_periodo_filtro}) between pago.fecha_activacion and nvl(pago.fecha_terminacion, (select fecha_fin from no_periodo where id_periodo = $P{id_periodo_filtro}))
                )tab
                on tab.id_tipo_doc = nom.id_tipo_doc and tab.num_doc = nom.num_doc

            )tab0
            on tab0.id_tipo_doc = liquida.id_tipo_doc and tab0.num_doc = liquida.num_doc

            left join NO_ESTADO_FUNC_V tab5 on
            tab5.id_tipo_doc = liquida.id_tipo_doc
            and tab5.num_doc = liquida.num_doc
            and tab5.periodo = liquida.id_periodo

            left join no_dp_v cargo on cargo.id_dp = tab5.id_dp

            where liquida.id_periodo = $P{id_periodo_filtro} and tipo.id_tipo_concepto!=4
            $P!{whereInClasePlanta} $P!{wherePago}
            --filtro func con retefuente - 20140710
            and (
            0 = $P{tag_rete}
            or
            liquida.num_doc in (select distinct tab.num_doc from no_liquida_nomina tab where tab.id_periodo = $P{id_periodo_filtro} and tab.id_concep_nomina = (select no_param_concep.id_concep_rete from no_param_concep))
            )

        )tab0

        left join(

            select

            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
            tab.estado,

            sum(nvl(tab.valor,0)) as valor,
            sum(nvl(valor_nac,0)) as valor_nac,
            sum(nvl(valor_pro,0)) as valor_pro,

            sum(nvl(tab.valor_dev,0)) as valor_dev,
            sum(nvl(tab.valor_ded,0)) as valor_ded

            from(

                select
                rub.descripcion as descripcion_rub, rub.rubro as  codigo_rubro, rub.id_tipo_atributo_contab,
                tab5.operador,
                tab1.num_doc,tab6.nombre_apellido,

                case when nvl(tab2.estado,0) = 0 and tab7.estado = 0 and tab2.fecha_terminacion <= tab7.fecha_termina then 1 else nvl(tab2.estado,0) end as estado,

                case when agrup.id_agrup_rec = 5
                    then
                    case when tab5.operador = 1 then tab1.valor_liquidado
                         when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end
                    else 0 end as valor_nac,
                case when agrup.id_agrup_rec = 6
                    then
                    case when tab5.operador = 1 then tab1.valor_liquidado
                         when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end
                    else 0 end as valor_pro,

                case when tab5.operador = 1 then tab1.valor_liquidado
                     when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end as valor,
                case when tab5.operador = 1 then tab1.valor_liquidado
                     when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else 0 end as valor_dev,
                case when tab5.operador = 0 and tab5.id_tipo_concepto_org != 1 then tab1.valor_liquidado else 0 end as valor_ded,
                tab1.id_periodo,
                tab1.id_tipo_doc

                from no_liquida_nomina tab1

                left join no_concep_nomina tab5 on tab5.id_concep_nomina = tab1.id_concep_nomina
                left join pr_rubro_presup_v rub on  rub.id_rubro = tab5.id_rubro
                left join pr_rubro_agrup_rec agrup on agrup.id_rubro = tab5.id_rubro
                left join no_datos_funcionario_v tab6  on tab6.id_tipo_doc = tab1.id_tipo_doc and tab6.num_doc = tab1.num_doc


                --join no_pago_func tab2 on tab2.id_tipo_doc = tab1.id_tipo_doc and tab2.num_doc = tab1.num_doc
                left join (
                  SELECT
                   aut.*,
                   ROW_NUMBER() OVER (
                    partition by aut.num_doc
                    ORDER BY aut.num_doc asc, aut.fecha_activacion desc, aut.id_pago_func desc
                   ) AS rn
                  from no_pago_func aut
                )tab2
                on tab1.id_tipo_doc = tab2.id_tipo_doc and tab1.num_doc = tab2.num_doc
                and tab2.rn = 1
                left join no_nombramiento_v tab7  ON tab7.id_tipo_doc = tab1.id_tipo_doc and tab7.num_doc = tab1.num_doc


                where
                tab1.id_periodo = $P{id_periodo_filtro}
                and tab5.pago_func = 1

                /*and (case when tab5.operador = 0 then 1 else (case when nvl(rub.id_tipo_atributo_contab,1) = 1 then 1 else 0 end) end) = 1*/

                /*and tab5.id_rubro is null*//* and tab5.id_lista_conceptos_siif is not null*/

            )tab

            group by
            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
            tab.estado

        )tabagruprec
        on tabagruprec.id_periodo = tab0.id_periodo
        and tabagruprec.id_tipo_doc = tab0.id_tipo_doc
        and tabagruprec.num_doc = tab0.num_doc

        where
        1 = 1
        $P!{whereCenOp}
        $P!{wherePlanta}

        /*Se coloca filtro de id_agrup_rec - 20210317*/
        and (case when 0 = nvl($P{id_agrup_rec},0) or tab0.id_tipo_concepto = 1 then 1
                  else (case when nvl($P{id_agrup_rec},0) = 5 and (tabagruprec.valor_nac - tabagruprec.valor_ded) >= 0 then 1
                             when nvl($P{id_agrup_rec},0) = 6 and (tabagruprec.valor_nac - tabagruprec.valor_ded) <  0 and (tabagruprec.valor_pro - tabagruprec.valor_ded) >=  0 then 1
                        else 0 end)
                  end
            ) = 1

    )concep

    group by concep.codigo

)funcionarios on funcionarios.codigo = informe.codigo

order by
informe.tipcod,
nvl(informe.tercero_nit,0),
informe.rubro,
informe.codigo]]>
	</queryString>
	<field name="ABREVIATURA" class="java.lang.String"/>
	<field name="ID_PERIODO" class="java.math.BigDecimal"/>
	<field name="TIPCOD" class="java.lang.String"/>
	<field name="TIPO" class="java.lang.String"/>
	<field name="COMPLETO_TIPO" class="java.lang.String"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="CANTIDAD" class="java.math.BigDecimal"/>
	<field name="RUBRO" class="java.lang.String"/>
	<field name="DESCRIPCION_RUB" class="java.lang.String"/>
	<field name="CODIGO_SIIF" class="java.lang.String"/>
	<field name="DESCRIPCION_SIIF" class="java.lang.String"/>
	<field name="TERCERO_NIT" class="java.lang.String"/>
	<field name="RUBRO_LIST" class="java.lang.String"/>
	<field name="DESCRIPCION_RUBRO_LIST" class="java.lang.String"/>
	<field name="IDENTIFICACION" class="java.lang.String"/>
	<field name="ATRIBUTO_CONT" class="java.math.BigDecimal"/>
	<field name="TIPO_GASTO" class="java.math.BigDecimal"/>
	<field name="PERIODO" class="java.lang.String"/>
	<field name="CEN_OP" class="java.lang.String"/>
	<variable name="total_tipo" class="java.math.BigDecimal" resetType="Group" resetGroup="Tipo Periodo" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR}]]></variableExpression>
	</variable>
	<variable name="cantidad_tipo" class="java.math.BigDecimal" resetType="Group" resetGroup="Tipo Periodo" calculation="Sum">
		<variableExpression><![CDATA[$F{CANTIDAD}]]></variableExpression>
	</variable>
	<variable name="total_valor" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[($F{TIPCOD}.equals("01") ? $F{VALOR} : $F{VALOR} * (-1))]]></variableExpression>
	</variable>
	<variable name="total_cantidad" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{CANTIDAD}]]></variableExpression>
	</variable>
	<group name="Tipo Periodo">
		<groupExpression><![CDATA[$F{TIPCOD}]]></groupExpression>
		<groupHeader>
			<band height="32" splitType="Prevent">
				<textField>
					<reportElement mode="Opaque" x="0" y="0" width="810" height="12" forecolor="#000000" backcolor="#D2D8E0"/>
					<box leftPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="390" y="12" width="150" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[( $F{TIPCOD} == "01"
    ? "DESCRIPCION RUBRO PRESUPUESTAL"
    : "RAZON SOCIAL"
)]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="50" y="12" width="150" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[DESCRIPCIÓN NÓMINA]]></text>
				</staticText>
				<textField>
					<reportElement mode="Opaque" x="690" y="12" width="60" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[( $F{TIPCOD} == "01"
    ? "ATRIBUTO CONTABLE"
    : " "
)]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="300" y="12" width="90" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[( $F{TIPCOD} == "01"
    ? "IDENTIFICACION"
    : "IDENTIFICACION TERCERO"
)]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="750" y="12" width="60" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[( $F{TIPCOD} == "01"
    ? "TIPO DE GASTO"
    : " "
)]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="200" y="12" width="100" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[( $F{TIPCOD} == "01"
    ? "RUBRO PRESUPUESTAL"
    : "POSICION NO PRESUPUESTAL"
)]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="540" y="12" width="90" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VALOR]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="12" width="50" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[CÓDIGO NÓMINA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="630" y="12" width="60" height="20" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[NÚMERO REGISTROS]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="22">
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="540" y="0" width="90" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_tipo}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="0" y="0" width="540" height="12" backcolor="#D2D8E0"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["TOTAL " + $F{TIPO}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement mode="Opaque" x="630" y="0" width="180" height="12" backcolor="#D2D8E0"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement x="0" y="12" width="810" height="10"/>
					<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<detail>
		<band height="14" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="50" y="0" width="150" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="50" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="540" y="0" width="90" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="630" y="0" width="60" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CANTIDAD}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="690" y="0" width="60" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ATRIBUTO_CONT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="750" y="0" width="60" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TIPO_GASTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="390" y="0" width="150" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_RUBRO_LIST}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="200" y="0" width="100" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RUBRO_LIST}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="300" y="0" width="90" height="14" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{IDENTIFICACION}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="4" splitType="Stretch"/>
	</columnFooter>
	<summary>
		<band height="12">
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="540" y="0" width="90" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_valor}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="0" y="0" width="540" height="12" backcolor="#D2D8E0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["TOTAL "]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="630" y="0" width="180" height="12" backcolor="#D2D8E0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
