<?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="gen_archivos_siif_pago_bf" language="groovy" pageWidth="1150" pageHeight="612" orientation="Landscape" columnWidth="1110" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.366026910730141"/>
	<property name="ireport.x" value="398"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/gen_archivos_siif_pago_bf"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="id_periodo_filtro" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioTipoDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioNumDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereBanco" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoCuenta" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="tipo_banco_nom" class="java.lang.String"/>
	<parameter name="whereInClasePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_tipo_atributo_contab" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<parameter name="id_agrup_rec" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<parameter name="id_agrup_rec_func" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
rownum as rn,
tab.*,

(select codigo_instituto_siif from no_param_gen where id_param_gen = 1) as codigo_instituto_siif,
REPLACE(tab.codigo_siif,'0','') as codigo_siif_bf,
1 as tipo_nomina

from(

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

--Asignación Básica + Gastos de representación
concep.valor as valor_remuneracion


from(

    select
    id_clase_planta,
    id_periodo,
    case when estado = 0 then null else id_bn end as id_bn,
    case when estado = 0 then null else id end as tipo_cuenta,
    id_tipo_doc,
    replace(codigo_siif,'0','0') as codigo_siif,
    num_doc,
    nombre_apellido,
                PRIMER_NOMBRE,
                SEGUNDO_NOMBRE,
                PRIMER_APELLIDO,
                SEGUNDO_APELLIDO,
    case when estado = 0 then 'CH' else 'AC' end as medio_pago,
    case when estado = 0 then null else replace(tipo_iden,'0','0') end as tipo_iden,
    case when estado = 0 then null else nit_bn end as nit_bn,
    case when estado = 0 then null else banco end as banco,
    codigo_ach,
    descripcion,
    case when estado = 0 then null else nombre_corto end as nombre_corto,
    case when estado = 0 then null else id end as cuenta_id,
    case when estado = 0 then null else num_cuenta end as num_cuenta,
    sum(nvl(valor_dev,0)) as valor_dev,
    sum(nvl(valor_ded,0)) as valor_ded,
    sum(nvl(valor,0)) as valor,
    sum(nvl(valor_nac,0)) as valor_nac,
    sum(nvl(valor_pro,0)) as valor_pro,
    11 as tipo_cuenta_pagar

    from(

        select
        tab7.id_clase_planta,
        rub.descripcion as descripcion_rub, rub.rubro as  codigo_rubro, rub.id_tipo_atributo_contab,
        tab5.operador,
        tab.valor as valorsum,

        tab1.num_doc,tab6.nombre_apellido,
                tab6.PRIMER_NOMBRE,
                tab6.SEGUNDO_NOMBRE,
                tab6.PRIMER_APELLIDO,
                tab6.SEGUNDO_APELLIDO,
        tab3.codigo||' - '||tab3.descripcion as banco, tab3.codigo_ach,
        tab2.num_cuenta,
        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 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 nvl(recbf.id_agrup_rec,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 nvl(recbf.id_agrup_rec,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 and tab5.id_rubro is not null then tab1.valor_liquidado
             when tab5.operador = 0 and tab5.id_rubro is not null 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
             when tab5.operador = 1 and tab5.id_rubro is null and tab5.id_tipo_concepto_org != 1 then (tab1.valor_liquidado * -1) else 0 end as valor_ded,*/

        /*validar si es concepto es de reintegro, que no tenga concepto original se coloca en deducido - 20200819
        o es reintegro y no tiene rubro - 20200916
        */
        case
            when ( esrein.id_concep_nomina is not null and tab5.id_rubro is null ) then 0
            when ( esrein.id_concep_nomina is not null and conorig.id_concep_nomina is null ) then 0

            when tab5.operador = 1 and tab5.id_rubro is not null then tab1.valor_liquidado
            when tab5.operador = 0 and tab5.id_rubro is not null and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1)
        else 0 end as valor_dev,
        case
            when ( esrein.id_concep_nomina is null or ( esrein.id_concep_nomina is not null and conorig.id_concep_nomina is null ) or  ( esrein.id_concep_nomina is not null and tab5.id_rubro is null ) )
                and tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then tab1.valor_liquidado
            when ( esrein.id_concep_nomina is null or ( esrein.id_concep_nomina is not null and conorig.id_concep_nomina is null ) or  ( esrein.id_concep_nomina is not null and tab5.id_rubro is null ) )
                and tab5.operador = 1 and tab5.id_rubro is null and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1)
            when tab5.operador = 0 and tab5.id_tipo_concepto_org != 1 then tab1.valor_liquidado
            when tab5.operador = 1 and tab5.id_rubro is null and tab5.id_tipo_concepto_org != 1 then (tab1.valor_liquidado * -1)
        else 0 end as valor_ded,

        tab1.id_periodo,
        tab1.id_tipo_doc, tab3.id_bn, terbn.NUM_DOC as nit_bn, tipiden.codigo_siif as tipo_iden,
        tab4.id,
        tab4.descripcion,
        tab4.nombre_corto,
        tab8.codigo_siif
        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
        /*segun separacion topa el otro rec - 20210420*/
        left join no_funcionario_agrup_rec_bf recbf on recbf.id_tipo_doc = tab1.id_tipo_doc and recbf.num_doc = tab1.num_doc and recbf.id_periodo = $P{id_periodo_filtro}
        and agrup.id_agrup_rec = 5

        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

        left join ts_bn tab3 on tab3.id_bn = tab2.id_bn
        left join interceros terbn
        on terbn.id_mae_ter = tab3.id_mae_ter
        left join tipo_identificacion tipiden
        on tipiden.id_tipo_identificacion = terbn.id_tipo_doc

        left join ts_tc tab4 on tab4.id = tab2.tipo_cuenta

        join tipo_documento tab8 on tab8.id_tipo_doc = tab1.id_tipo_doc

        left join(

            select

            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
                tab.PRIMER_NOMBRE,
                tab.SEGUNDO_NOMBRE,
                tab.PRIMER_APELLIDO,
                tab.SEGUNDO_APELLIDO,
            tab.estado,

            sum(nvl(tab.valor,0)) as valor,
            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,
                tab6.PRIMER_NOMBRE,
                tab6.SEGUNDO_NOMBRE,
                tab6.PRIMER_APELLIDO,
                tab6.SEGUNDO_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 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 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

            )tab

            group by
            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
                tab.PRIMER_NOMBRE,
                tab.SEGUNDO_NOMBRE,
                tab.PRIMER_APELLIDO,
                tab.SEGUNDO_APELLIDO,
            tab.estado

        )tab
        on tab.id_periodo = tab1.id_periodo
        and tab.id_tipo_doc = tab1.id_tipo_doc
        and tab.num_doc = tab1.num_doc

        left join(

            select
              liq.id_tipo_doc,
              liq.num_doc,
              concep.id_concep_rein as id_concep_nomina,
              liq.id_periodo,
              sum(liq.valor_liquidado) as valor_liquidado

            from no_concep_nomina concep

            left join no_liquida_nomina liq
            on concep.id_concep_nomina = liq.id_concep_nomina

            where
            concep.id_concep_rein is not null
            and concep.id_tipo_concepto = 1
            AND concep.id_rubro is not null

              group by
              liq.id_tipo_doc,
              liq.num_doc,
              concep.id_concep_rein,
              liq.id_periodo
        )conorig
        on conorig.id_concep_nomina = tab5.id_concep_nomina
          and conorig.id_tipo_doc = tab1.id_tipo_doc
          and conorig.num_doc = tab1.num_doc
          and conorig.id_periodo = tab1.id_periodo

        left join(

            select
              concep.*
            from no_concep_nomina concep

            where
            concep.id_concep_nomina in (select no_concep_nomina.id_concep_rein from no_concep_nomina
                    where
                    id_concep_rein is not null
                    and id_tipo_concepto = 1
                    AND id_rubro is not null)
        )esrein
        on esrein.id_concep_nomina = tab5.id_concep_nomina

        where
        tab1.id_periodo = $P{id_periodo_filtro}
        and tab5.pago_func = 1
        /*Filtra seegun atributo contable del rubro*/
        and (case when 0 = $P{id_tipo_atributo_contab} then 1
                  when tab5.operador = 0
                  then (case when tab.valor >= 0 and 1 = $P{id_tipo_atributo_contab} then 1
                             when tab.valor <  0 and 2 = $P{id_tipo_atributo_contab} then 1
                             else 0 end)
                  else (case when nvl(rub.id_tipo_atributo_contab,1) = $P{id_tipo_atributo_contab}
                             then 1
                             else 0 end) end
            ) = 1
        /*Se coloca filtro de id_agrup_rec - 20210317*/
        and (case when 0 = nvl($P{id_agrup_rec},0) then 1
                  else (case when nvl(nvl(recbf.id_agrup_rec,agrup.id_agrup_rec),5) = $P{id_agrup_rec} then 1
                             when nvl(nvl(recbf.id_agrup_rec,agrup.id_agrup_rec),6) = $P{id_agrup_rec} then 1
                        else 0 end)
                  end
            ) = 1

    )
    group by
    id_clase_planta,
    codigo_siif,
    num_doc,nombre_apellido,
                PRIMER_NOMBRE,
                SEGUNDO_NOMBRE,
                PRIMER_APELLIDO,
                SEGUNDO_APELLIDO,
    tipo_iden,
    nit_bn,
    banco,codigo_ach,
    num_cuenta,descripcion,id_periodo,
    id_tipo_doc, id_bn, id, nombre_corto, estado

)tab0

left join(

    select

    concep.num_doc,
    concep.id_tipo_doc,
    sum(concep.valor) as valor

    from (

        SELECT
        concep.num_doc,
        concep.id_tipo_doc,
        concep.id_concep_nomina,
        concep.valor,
        concep.fecha_desde,
        concep.fecha_hasta,
           ROW_NUMBER() OVER (
            partition by concep.num_doc, concep.id_concep_nomina
            ORDER BY concep.num_doc, per.id_tipo_periodo, concep.fecha_desde desc, concep.fecha_hasta desc
           ) AS rn

        FROM no_concepto_periodo concep

        left join no_periodo per
        on per.id_periodo = concep.periodo

        where
        per.id_tipo_periodo in (1,2)
        and concep.id_anhos = ( select distinct periodo.id_anhos from no_periodo_v periodo where periodo.id_periodo = $P{id_periodo_filtro} )
        and concep.id_meses = ( select distinct periodo.id_meses from no_periodo_v periodo where periodo.id_periodo = $P{id_periodo_filtro} )
        and concep.id_concep_nomina in ( select no_param_concep.id_concep_basica from no_param_concep union select no_param_concep.id_concep_gasto_repre from no_param_concep)
        and concep.id_periodo_ajuste is null

    )concep

    where
    concep.rn = 1

    group by
    concep.num_doc,
    concep.id_tipo_doc

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

where
1 = 1
$P!{whereFuncionarioNumDoc} $P!{whereFuncionarioTipoDoc}
$P!{whereInClasePlanta}

and (

    tab0.num_doc not in (
     select nom.num_doc from no_nombramiento_v nom
      where nom.fecha_retiro is not null
      and (select no_periodo.fecha_ini from no_periodo
            where id_periodo = $P{id_periodo_filtro}) > trunc(last_day( nom.fecha_termina ))
    )

    or

    (select distinct periodo.id_tipo_periodo from no_periodo_v periodo where periodo.id_periodo = $P{id_periodo_filtro}) in (6,7,2,5)

)
/*validar valor de nacion y propio - 20210317*/
and (tab0.valor_nac + tab0.valor_pro) > 0

/*validacion segun separacion agrup_Rec - 20210420*/
and (

    (tab0.id_tipo_doc,tab0.num_doc) in (
        SELECT
        id_tipo_doc,
        num_doc
        FROM no_funcionario_agrup_rec_bf
        where
        id_periodo = $P{id_periodo_filtro}
        and id_agrup_rec = $P{id_agrup_rec_func}
    )

    or

    nvl($P{id_agrup_rec_func},0) in (0)

)

order by
tab0.num_doc

)tab]]>
	</queryString>
	<field name="RN" class="java.math.BigDecimal"/>
	<field name="ID_CLASE_PLANTA" class="java.math.BigDecimal"/>
	<field name="ID_PERIODO" class="java.math.BigDecimal"/>
	<field name="ID_BN" class="java.math.BigDecimal"/>
	<field name="TIPO_CUENTA" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="CODIGO_SIIF" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="PRIMER_NOMBRE" class="java.lang.String"/>
	<field name="SEGUNDO_NOMBRE" class="java.lang.String"/>
	<field name="PRIMER_APELLIDO" class="java.lang.String"/>
	<field name="SEGUNDO_APELLIDO" class="java.lang.String"/>
	<field name="MEDIO_PAGO" class="java.lang.String"/>
	<field name="TIPO_IDEN" class="java.lang.String"/>
	<field name="NIT_BN" class="java.lang.String"/>
	<field name="BANCO" class="java.lang.String"/>
	<field name="CODIGO_ACH" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="NOMBRE_CORTO" class="java.lang.String"/>
	<field name="CUENTA_ID" class="java.math.BigDecimal"/>
	<field name="NUM_CUENTA" class="java.lang.String"/>
	<field name="VALOR_DEV" class="java.math.BigDecimal"/>
	<field name="VALOR_DED" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="VALOR_NAC" class="java.math.BigDecimal"/>
	<field name="VALOR_PRO" class="java.math.BigDecimal"/>
	<field name="TIPO_CUENTA_PAGAR" class="java.math.BigDecimal"/>
	<field name="PERIODO" class="java.lang.String"/>
	<field name="VALOR_REMUNERACION" class="java.math.BigDecimal"/>
	<field name="CODIGO_INSTITUTO_SIIF" class="java.lang.String"/>
	<field name="CODIGO_SIIF_BF" class="java.lang.String"/>
	<field name="TIPO_NOMINA" class="java.math.BigDecimal"/>
	<variable name="total" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR}]]></variableExpression>
	</variable>
	<variable name="cantidad" class="java.math.BigDecimal" calculation="Count">
		<variableExpression><![CDATA[$F{NUM_DOC}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="880" y="0" width="70" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[TIPO DE CUENTA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="950" y="0" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[NUMERO DE CUENTA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1030" y="0" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[REMUNERACIÓN ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="70" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[PCI IDENTIFICACION ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="340" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[IDENTIFICACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="780" y="0" width="100" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[NUMERO IDENTIFICACION ENTIDAD FINANCIERA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="70" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[CONSECUTIVO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="160" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[TIPO NOMINA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="250" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[TIPO DOCUMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="430" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[PRIMER NOMBRE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="520" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[SEGUNDO NOMBRE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="700" y="0" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[SEGUNDO APELLIDO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="610" y="0" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<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[PRIMER APELLIDO]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="13" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="950" y="0" width="80" height="13" 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 verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_CUENTA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="1030" y="0" width="80" height="13" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_REMUNERACION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="880" y="0" width="70" height="13" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CUENTA_ID}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="70" y="0" width="90" height="13" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_INSTITUTO_SIIF}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="340" y="0" width="90" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="3">
					<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="780" y="0" width="100" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="3">
					<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_BN}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="0" y="0" width="70" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0">
					<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{RN}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="250" y="0" width="90" height="13" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_SIIF_BF}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="160" y="0" width="90" height="13" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_NOMINA}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="430" y="0" width="90" height="13" 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 verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMER_NOMBRE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="520" y="0" width="90" height="13" 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 verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SEGUNDO_NOMBRE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="610" y="0" width="90" height="13" 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 verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMER_APELLIDO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="700" y="0" width="80" height="13" 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 verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SEGUNDO_APELLIDO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="22" splitType="Stretch"/>
	</columnFooter>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1110" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
