<?xml version="1.0" encoding="ISO-8859-1"?>
<persistence-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:noNamespaceSchemaLocation="../../../../defs/config-metier/Persistence.xsd">
    <layer name="mysql" persistence-model="xemelios-sql">
        <!--document
            id="erar"
            repository-import-xslt-file="">
            <table type="repository" base-name="ERAR_REPOSITORY" version="1">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                COLLECTIVITE VARCHAR(15) NOT NULL,
                REPOSITORY LONGBLOB,
                ENCODING VARCHAR(20)
                ) TYPE MYISAM
            </table>
            <table type="list-bc" base-name="ERAR_LIST_BUDG_COLL" version="1">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                COLLECTIVITE VARCHAR(15) NOT NULL,
                BUDGET VARCHAR(24) NOT NULL,
                BUDGET_LIB VARCHAR(200),
                COLLECTIVITE_LIB VARCHAR(200),
                INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
                INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
                ) TYPE MYISAM
            </table>
            <etat id="LigneERAR" import-xslt-file="erar/erar-import-mysql.xsl">
    <key1>
        <path>/PES_Restit/PES_ERAR/LigneERAR/Empechement/@added:generated-id</path>
    </key1>
    <key2>
        <path>/PES_Restit/PES_ERAR/LigneERAR/Etape/@added:generated-id</path>
    </key2>

    <table type="document" base-name="TBL_ERAR_DOCUMENTS" version="1">
        CREATE TABLE IF NOT EXISTS ${base-name} (
            COLLECTIVITE VARCHAR(15) NOT NULL,
            BUDGET VARCHAR(24) NOT NULL, 
            INITIAL_DOC_NAME VARCHAR(100) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL, 
            DOC LONGBLOB, 
            ENCODING VARCHAR(20), 
            INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID) 
        ) TYPE MYISAM </table>
    <table type="index" id="TBL_LIGNEERAR_IX" base-name="ERAR_LIGNEERAR" version="2" main="true"> 
        CREATE TABLE IF NOT EXISTS ${base-name} ( 
            COLLECTIVITE VARCHAR(15) NOT NULL, 
            BUDGET VARCHAR(24) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL,
            EXER INTEGER,
            ID_COLL VARCHAR(14),
            FINJUR VARCHAR(20),
            COD_COLL VARCHAR(3),
            COD_BUD VARCHAR(2),
            LIBELLE_COLBUD VARCHAR(38),
            SERVICE_ORDONNATEUR VARCHAR(10),
            REF_COMPTA_TYPE_REF VARCHAR(2),
            REF_COMPTA_ID_BORD INTEGER,
            REF_COMPTA_ID_PIECE INTEGER,
            REF_COMPTA_EXER_RATTACH INTEGER,
            REF_COMPTA_ID_LIGNE INTEGER,
            REF_COMPTA_NUM_FACT VARCHAR(15),
            REF_COMPTA_CODE_PERIODE VARCHAR(5),
            REF_COMPTA_COD_PROD VARCHAR(3),
            REF_COMPTA_LIB_PROD VARCHAR(30),
            REF_COMPTA_DATE_EMISSION_PCE DATE,
            DEB_ID_TIERS VARCHAR(15),
            DEB_DATE_MALADE DATE,
            DEB_TYP_TIERS VARCHAR(2),
            DEB_NAT_ID_TIERS VARCHAR(2),
            DEB_DATE_ID_TIERS DATE,
            DEB_REF_TIERS VARCHAR(30),
            DEB_CAT_TIERS VARCHAR(2),
            DEB_NAT_JUR VARCHAR(2),
            DEB_CIVILITE VARCHAR(10),
            DEB_NOM VARCHAR(38),
            DEB_COMPLNOM VARCHAR(38),
            DEB_PRENOM VARCHAR(38),
            DEB_TYP_ADR VARCHAR(1),
            DEB_ADR1 VARCHAR(38),
            DEB_ADR2 VARCHAR(38),
            DEB_ADR3 VARCHAR(38),
            DEB_CP VARCHAR(5),
            DEB_VILLE VARCHAR(38),
            DEB_CODPAYS VARCHAR(3),
            DEB_DATE_ADR DATE,
            DEB_NPAI VARCHAR(1),
            DEB_REF_ALLOCATAIRE VARCHAR(20),
            ASS_ID_TIERS VARCHAR(15),
            ASS_DATE_MALADE DATE,
            ASS_TYP_TIERS VARCHAR(2),
            ASS_NAT_ID_TIERS VARCHAR(2),
            ASS_DATE_ID_TIERS DATE,
            ASS_REF_TIERS VARCHAR(30),
            ASS_CAT_TIERS VARCHAR(2),
            ASS_NAT_JUR VARCHAR(2),
            ASS_CIVILITE VARCHAR(10),
            ASS_NOM VARCHAR(38),
            ASS_COMPLNOM VARCHAR(38),
            ASS_PRENOM VARCHAR(38),
            MAL_ID_TIERS VARCHAR(15),
            MAL_DATE_MALADE DATE,
            MAL_TYP_TIERS VARCHAR(2),
            MAL_NAT_ID_TIERS VARCHAR(2),
            MAL_DATE_ID_TIERS DATE,
            MAL_REF_TIERS VARCHAR(30),
            MAL_CAT_TIERS VARCHAR(2),
            MAL_NAT_JUR VARCHAR(2),
            MAL_CIVILITE VARCHAR(10),
            MAL_NOM VARCHAR(38),
            MAL_COMPLNOM VARCHAR(38),
            MAL_PRENOM VARCHAR(38),
            MAL_DATE_ENTREE DATE,
            MAL_DATE_SORTIE DATe,
            MAL_NUM_ENTREE VARCHAR(14),
            MT_PRINC DECIMAL(14,2),
            MT_FRAIS DECIMAL(14,2),
            RAR_PRINC DECIMAL(14,2),
            RAR_FRAIS DECIMAL(14,2),
            DATE_PRESCRIPTION DATE,
            DATE_ADMISSION_NV DATE,
            MT_NV DECIMAL(14,2),
            DATE_MAJORATION DATE,
            COD_PROD_LOCAL VARCHAR(3),
            ETAB_GEO VARCHAR(10),
            DATE_DEB_FACT DATE,
            DATE_FIN_FACT DATE,
        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID)
     ) TYPE MYISAM
    </table>
    <table type="index" id="TBL_ERAR_EMPECHEMENT_IX" base-name="ERAR_EMPECHEMENT" version="1" main="false" based-on="key1">
        CREATE TABLE IF NOT EXISTS ${base-name} (
            COLLECTIVITE VARCHAR(15) NOT NULL,
            BUDGET VARCHAR(24) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL, 
            NODE_ID VARCHAR(50) NOT NULL, 
            CODEMP VARCHAR(15), 
            LIBEMP VARCHAR(30),
            DATE_DEBUT_EMP DATE,
            DATE_FIN_EMP DATE,
         INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
         INDEX IX_${base-name}_DC (DOC_ID)
     ) TYPE MYISAM
    </table>
    <table type="index" id="TBL_ERAR_ETAPE_IX" base-name="ERAR_ETAPE" version="1" main="false" based-on="key2">
        CREATE TABLE IF NOT EXISTS ${base-name} (
            COLLECTIVITE VARCHAR(15) NOT NULL, 
            BUDGET VARCHAR(24) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL, 
            NODE_ID VARCHAR(50) NOT NULL, 
            CODE_ETAPE VARCHAR(3), 
            NAT_ETAPE VARCHAR(2), 
            LIB_ETAPE VARCHAR(30), 
            DATE_ETAPE DATE,
            DATE_ANNULATION DATE,
            CODE_ACTU VARCHAR(2), 
            LIB_ACTU VARCHAR(30),
            DATE_ACTU DATE,
            REF_ACTE VARCHAR(14),
            DATE_DEMANDE_ACTE DATE, 
            DATE_ENVOI_ACTE DATE,
            DATE_AUTOMATE DATE,
            DATE_REMISE_ACTE DATE,
            ETAT_VALIDATION VARCHAR(1),
            ETAT_ETAPE VARCHAR(1),
            NUM_ACTE_POURSUITE VARCHAR(14), 
            MT_ACTE_POURSUITE DECIMAL(14,2), 
            MT_ETAPE DECIMAL(14,2),
            MT_FRAIS_ETAPE DECIMAL(14,2),
            ORIGINE_ETAPE VARCHAR(1),
            ORDREPRES INTEGER,
        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
        INDEX IX_${base-name}_DC (DOC_ID)
    ) TYPE MYISAM
    </table>

                <criteria id="IdColl" sql-index-id="IdColl">
                    <where-clause>fn:string-compare(${table}.${column},IdColl)</where-clause>
                </criteria>
                <criteria id="FinJur" sql-index-id="FinJur">
                    <where-clause>fn:string-compare(${table}.${column},FinJur)</where-clause>
                </criteria>
                <criteria id="CodCol" sql-index-id="CodCol">
                    <where-clause>fn:string-compare(${table}.${column},CodCol)</where-clause>
                </criteria>
                <criteria id="CodBud" sql-index-id="CodBud">
                    <where-clause>fn:string-compare(${table}.${column},CodBud)</where-clause>
                </criteria>
                <criteria id="LibColBud" sql-index-id="LibelleColBud">
                    <where-clause>fn:string-compare(${table}.${column},LibColBud)</where-clause>
                </criteria>
                
                <criteria id="ordo" sql-index-id="SvcOrdo">
                    <where-clause>fn:string-compare(${table}.${column},ordo)</where-clause>
                </criteria>
                <criteria id="RefComptaTypeRef" sql-index-id="refComptaTypeRef">
                    <where-clause>${table}.${column}='##VALEUR:TypeRef##'</where-clause>
                </criteria>
                <criteria id="RefComptaIdBord" sql-index-id="refComptaIdBord">
                    <where-clause>${table}.${column}##OPERATEUR:IdBord####VALEUR:IdBord##</where-clause>
                </criteria>
                <criteria id="RefComptaIdPiece" sql-index-id="refComptaIdPiece">
                    <where-clause>${table}.${column}##OPERATEUR:IdPiece####VALEUR:IdPiece##</where-clause>
                </criteria>
                <criteria id="RefComptaExerRattach" sql-index-id="refComptaExerRattach">
                    <where-clause>${table}.${column}##OPERATEUR:exer####VALEUR:exer##</where-clause>
                </criteria>
                <criteria id="RefComptaIdLigne" sql-index-id="refComptaIdLigne">
                    <where-clause>${table}.${column}##OPERATEUR:IdLigne####VALEUR:IdLigne##</where-clause>
                </criteria>
                <criteria id="RefComptaNumFact" sql-index-id="refComptaNumFact">
                    <where-clause>fn:string-compare(${table}.${column},NumFact)</where-clause>
                </criteria>
                <criteria id="RefComptaCodePeriode" sql-index-id="refComptaCodePeriode">
                    <where-clause>fn:string-compare(${table}.${column},CodePeriode)</where-clause>
                </criteria>
                <criteria id="RefComptaCodProd" sql-index-id="refComptaCodProd">
                    <where-clause>fn:string-compare(${table}.${column},CodProd)</where-clause>
                </criteria>
                <criteria id="RefComptaLibProd" sql-index-id="refComptaLibProd">
                    <where-clause>fn:string-compare(${table}.${column},LibProd)</where-clause>
                </criteria>
                <criteria id="RefComptaDatePce" sql-index-id="refComptaDateEmissionPce">
                    <where-clause>fn:date-compare(${table}.${column},DatePce)</where-clause>
                </criteria>

                <criteria id="DebIdTiers" sql-index-id="debIdTiers">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="DebNom" sql-index-id="debNom">
                    <where-clause>fn:string-compare(${table}.${column},DebNom)</where-clause>
                </criteria>
                <criteria id="DebComplNom" sql-index-id="debComplNom">
                    <where-clause>fn:string-compare(${table}.${column},DebComplNom)</where-clause>
                </criteria>
                <criteria id="DebPrenom" sql-index-id="debPrenom">
                    <where-clause>fn:string-compare(${table}.${column},DebPrenom)</where-clause>
                </criteria>
                <criteria id="DebTypTiers" sql-index-id="debTypTiers">
                    <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
                </criteria>
                <criteria id="DebDteIdTiers" sql-index-id="debDateIdTiers">
                    <where-clause>fn:date-compare(${table}.${column},DebDteIdTiers)</where-clause>
                </criteria>
                <criteria id="DebRefTiers" sql-index-id="debRefTiers">
                    <where-clause>fn:string-compare(${table}.${column},DebRefTiers)</where-clause>
                </criteria>
                <criteria id="DebCatTiers" sql-index-id="debCatTiers">
                    <where-clause>${table}.${column}='##VALEUR:DebCatTiers##'</where-clause>
                </criteria>
                <criteria id="DebNatJur" sql-index-id="debNatJur">
                    <where-clause>${table}.${column}='##VALEUR:DebNatJur##'</where-clause>
                </criteria>
                <criteria id="DebCivilite" sql-index-id="debCivilite">
                    <where-clause>fn:string-compare(${table}.${column},DebCivilite)</where-clause>
                </criteria>
                <criteria id="DebTypAdr" sql-index-id="debTypAdr">
                    <where-clause>${table}.${column}='##VALEUR:DebTypAdr##'</where-clause>
                </criteria>
                <criteria id="DebAdr1" sql-index-id="debAdr1">
                    <where-clause>fn:string-compare(${table}.${column},DebAdr1)</where-clause>
                </criteria>
                <criteria id="DebAdr2" sql-index-id="debAdr2">
                    <where-clause>fn:string-compare(${table}.${column},DebAdr2)</where-clause>
                </criteria>
                <criteria id="DebAdr3" sql-index-id="debAdr3">
                    <where-clause>fn:string-compare(${table}.${column},DebAdr3)</where-clause>
                </criteria>
                <criteria id="DebCP" sql-index-id="debCp">
                    <where-clause>fn:string-compare(${table}.${column},DebCP)</where-clause>
                </criteria>
                <criteria id="DebVille" sql-index-id="debVille">
                    <where-clause>fn:string-compare(${table}.${column},DebVille)</where-clause>
                </criteria>
                <criteria id="DebNPAI" sql-index-id="debNpai">
                    <where-clause>${table}.${column}='##VALEUR:DebNPAI##'</where-clause>
                </criteria>
                <criteria id="DebRefAllocataire" sql-index-id="debRefAllocataire">
                    <where-clause>fn:string-compare(${table}.${column},DebRefAllocataire)</where-clause>
                </criteria>
                
                <criteria id="AssIdTiers" sql-index-id="assIdTiers">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="AssNom" sql-index-id="assNom">
                    <where-clause>fn:string-compare(${table}.${column},AssNom)</where-clause>
                </criteria>
                <criteria id="AssComplNom" sql-index-id="assComplNom">
                    <where-clause>fn:string-compare(${table}.${column},AssComplNom)</where-clause>
                </criteria>
                <criteria id="AssPrenom" sql-index-id="assPrenom">
                    <where-clause>fn:string-compare(${table}.${column},AssPrenom)</where-clause>
                </criteria>
                <criteria id="AssTypTiers" sql-index-id="assTypTiers">
                    <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
                </criteria>
                <criteria id="AssDteIdTiers" sql-index-id="assDateIdTiers">
                    <where-clause>fn:date-compare(${table}.${column},AssDteIdTiers)</where-clause>
                </criteria>
                <criteria id="AssRefTiers" sql-index-id="assRefTiers">
                    <where-clause>fn:string-compare(${table}.${column},AssRefTiers)</where-clause>
                </criteria>
                <criteria id="AssCatTiers" sql-index-id="assCatTiers">
                    <where-clause>${table}.${column}='##VALEUR:AssCatTiers##'</where-clause>
                </criteria>
                <criteria id="AssNatJur" sql-index-id="assNatJur">
                    <where-clause>${table}.${column}='##VALEUR:AssNatJur##'</where-clause>
                </criteria>
                <criteria id="AssCivilite" sql-index-id="assCivilite">
                    <where-clause>fn:string-compare(${table}.${column},AssCivilite)</where-clause>
                </criteria>
                
                <criteria id="MalIdTiers" sql-index-id="malIdTiers">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="MalNom" sql-index-id="malNom">
                    <where-clause>fn:string-compare(${table}.${column},MalNom)</where-clause>
                </criteria>
                <criteria id="MalComplNom" sql-index-id="malComplNom">
                    <where-clause>fn:string-compare(${table}.${column},MalComplNom)</where-clause>
                </criteria>
                <criteria id="MalPrenom" sql-index-id="malPrenom">
                    <where-clause>fn:string-compare(${table}.${column},MalPrenom)</where-clause>
                </criteria>
                <criteria id="MalTypTiers" sql-index-id="malTypTiers">
                    <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
                </criteria>
                <criteria id="MalDteIdTiers" sql-index-id="malDateIdTiers">
                    <where-clause>fn:date-compare(${table}.${column},MalDteIdTiers)</where-clause>
                </criteria>
                <criteria id="MalRefTiers" sql-index-id="malRefTiers">
                    <where-clause>fn:string-compare(${table}.${column},MalRefTiers)</where-clause>
                </criteria>
                <criteria id="MalCatTiers" sql-index-id="malCatTiers">
                    <where-clause>${table}.${column}='##VALEUR:MalCatTiers##'</where-clause>
                </criteria>
                <criteria id="MalNatJur" sql-index-id="malNatJur">
                    <where-clause>${table}.${column}='##VALEUR:MalNatJur##'</where-clause>
                </criteria>
                <criteria id="MalCivilite" sql-index-id="malCivilite">
                    <where-clause>fn:string-compare(${table}.${column},MalCivilite)</where-clause>
                </criteria>
                <criteria id="MalDateEntree" sql-index-id="malDateEntree">
                    <where-clause>fn:date-compare(${table}.${column},MalDateEntree)</where-clause>
                </criteria>
                <criteria id="MalDateSortie" sql-index-id="malDateSortie">
                    <where-clause>fn:date-compare(${table}.${column},MalDateSortie)</where-clause>
                </criteria>
                <criteria id="MalNumEntree" sql-index-id="malNumEntree">
                    <where-clause>fn:string-compare(${table}.${column},MalNumEntree)</where-clause>
                </criteria>
                
                <criteria id="MtPrinc" sql-index-id="mtPrinc">
                    <where-clause>${table}.${column}##OPERATEUR:MtPrinc####VALEUR:MtPrinc##</where-clause>
                </criteria>
                <criteria id="MtFrais" sql-index-id="mtFrais">
                    <where-clause>${table}.${column}##OPERATEUR:MtFrais####VALEUR:MtFrais##</where-clause>
                </criteria>
                <criteria id="RarPrinc" sql-index-id="RarPrinc">
                    <where-clause>${table}.${column}##OPERATEUR:RarPrinc####VALEUR:RarPrinc##</where-clause>
                </criteria>
                <criteria id="RarFrais" sql-index-id="RarFrais">
                    <where-clause>${table}.${column}##OPERATEUR:RarFrais####VALEUR:RarFrais##</where-clause>
                </criteria>
                <criteria id="DateNV" sql-index-id="dateAdmissionNV">
                    <where-clause>fn:date-compare(${table}.${column},DateNV)</where-clause>
                </criteria>
                <criteria id="MtNV" sql-index-id="mtNv">
                    <where-clause>${table}.${column}##OPERATEUR:MtNV####VALEUR:MtNV##</where-clause>
                </criteria>
                <criteria id="DateMajoration" sql-index-id="dateMajoration">
                    <where-clause>fn:date-compare(${table}.${column},DateMajoration)</where-clause>
                </criteria>
                <criteria id="DatePrescription" sql-index-id="datePrescription">
                    <where-clause>fn:date-compare(${table}.${column},DatePrescription)</where-clause>
                </criteria>
                <criteria id="etabGeo" sql-index-id="etabGeo">
                    <where-clause>fn:string-compare(${table}.${column},etabGeo)</where-clause>
                </criteria>
                <criteria id="CodProdLocal" sql-index-id="codProdLocal">
                    <where-clause>fn:string-compare(${table}.${column},CodProdLocal)</where-clause>
                </criteria>
                <criteria id="DateDebFact" sql-index-id="dateDebFact">
                    <where-clause>fn:date-compare(${table}.${column},DateDebFact)</where-clause>
                </criteria>
                <criteria id="DateFinFact" sql-index-id="dateFinFact">
                    <where-clause>fn:date-compare(${table}.${column},DateFinFact)</where-clause>
                </criteria>
                
                <criteria id="EmpCodEmp" sql-index-id="empCodEmp">
                    <where-clause>fn:string-compare(${table}.${column},CodEmp)</where-clause>
                </criteria>
                <criteria id="EmpLibEmp" sql-index-id="empLibEmp">
                    <where-clause>fn:string-compare(${table}.${column},LibEmp)</where-clause>
                </criteria>
                <criteria id="EmpDateDebEmp" sql-index-id="empDateDebEmp">
                    <where-clause>fn:date-compare(${table}.${column},DateDebEmp)</where-clause>
                </criteria>
                <criteria id="EmpDateFinEmp" sql-index-id="empDateFinEmp">
                    <where-clause>fn:date-compare(${table}.${column},DateFinEmp)</where-clause>
                </criteria>
                
                <criteria id="EtpCodeEtape" sql-index-id="etpCodeEtape">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtape)</where-clause>
                </criteria>
                <criteria id="EtpNatEtape" sql-index-id="etpNatEtape">
                    <where-clause>${table}.${column}='##VALEUR:NatEtape##'</where-clause>
                </criteria>
                <criteria id="EtpLibEtape" sql-index-id="etpLibEtape">
                    <where-clause>fn:string-compare(${table}.${column},LibEtape)</where-clause>
                </criteria>
                <criteria id="EtpDateEtape" sql-index-id="etpDateEtape">
                    <where-clause>fn:date-compare(${table}.${column},DateEtape)</where-clause>
                </criteria>
                <criteria id="EtpDateAnnulation" sql-index-id="etpDateAnnulation">
                    <where-clause>fn:date-compare(${table}.${column},DateAnnulation)</where-clause>
                </criteria>
                <criteria id="EtpCodeActu" sql-index-id="etpCodeActu">
                    <where-clause>${table}.${column}='##VALEUR:CodeActu##'</where-clause>
                </criteria>
                <criteria id="EtpLibActu" sql-index-id="etpLibActu">
                    <where-clause>fn:string-compare(${table}.${column},LibActu)</where-clause>
                </criteria>
                <criteria id="EtpRefActe" sql-index-id="etpRefActe">
                    <where-clause>fn:string-compare(${table}.${column},RefActe)</where-clause>
                </criteria>
                <criteria id="EtpDateDemandeActe" sql-index-id="etpDateDemandeActe">
                    <where-clause>fn:date-compare(${table}.${column},DateDemande)</where-clause>
                </criteria>
                <criteria id="EtpDateEnvoiActe" sql-index-id="etpDateEnvoiActe">
                    <where-clause>fn:date-compare(${table}.${column},DateEnvoi)</where-clause>
                </criteria>
                <criteria id="EtpDateRemiseActe" sql-index-id="etpDateRemiseActe">
                    <where-clause>fn:date-compare(${table}.${column},DateRemise)</where-clause>
                </criteria>
                <criteria id="EtpDateAutomate" sql-index-id="etpDateAutomate">
                    <where-clause>fn:date-compare(${table}.${column},DateAutomate)</where-clause>
                </criteria>
                <criteria id="EtpEtatValidation" sql-index-id="etpEtatValidation">
                    <where-clause>${table}.${column}='##VALEUR:EtatValidation##'</where-clause>
                </criteria>
                <criteria id="EtpEtatEtape" sql-index-id="etpEtatEtape">
                    <where-clause>${table}.${column}='##VALEUR:EtatEtape##'</where-clause>
                </criteria>
                <criteria id="EtpNumActe" sql-index-id="etpNumActePoursuite">
                    <where-clause>fn:string-compare(${table}.${column},NumActe)</where-clause>
                </criteria>
                <criteria id="EtpMtActe" sql-index-id="etpMtActePoursuite">
                    <where-clause>${table}.${column}##OPERATEUR:MtActe####VALEUR:MtActe##</where-clause>
                </criteria>
                <criteria id="EtpMtEtape" sql-index-id="etpMtEtape">
                    <where-clause>${table}.${column}##OPERATEUR:MtEtape####VALEUR:MtEtape##</where-clause>
                </criteria>
                <criteria id="EtpMtFraisEtape" sql-index-id="etpMtFraisEtape">
                    <where-clause>${table}.${column}##OPERATEUR:MtFraisEtape####VALEUR:MtFraisEtape##</where-clause>
                </criteria>
                <criteria id="EtpOrigineEtape" sql-index-id="etpOrigineEtape">
                    <where-clause>${table}.${column}='##VALEUR:OrigineEtape##'</where-clause>
                </criteria>
                
                
                
                
                <sql-index id="exer" table="TBL_LIGNEERAR_IX" column="EXER" path="/PES_Restit/PES_ERAR/Exer/@V" datatype="string" format="uppercase"/>
                <sql-index id="IdColl" table="TBL_LIGNEERAR_IX" column="ID_COLL" path="/PES_Restit/PES_ERAR/LigneERAR/Collectivite/IdColl/@V" datatype="string" format="uppercase"/>
                <sql-index id="FinJur" table="TBL_LIGNEERAR_IX" column="FINJUR" path="/PES_Restit/PES_ERAR/LigneERAR/Collectivite/FinJur/@V" datatype="string" format="uppercase"/>
                <sql-index id="CodCol" table="TBL_LIGNEERAR_IX" column="COD_COLL" path="/PES_Restit/PES_ERAR/LigneERAR/Collectivite/CodCol/@V" datatype="string" format="uppercase"/>
                <sql-index id="CodBud" table="TBL_LIGNEERAR_IX" column="COD_BUD" path="/PES_Restit/PES_ERAR/LigneERAR/Collectivite/CodBud/@V" datatype="string" format="uppercase"/>
                <sql-index id="LibelleColBud" table="TBL_LIGNEERAR_IX" column="LIBELLE_COLBUD" path="/PES_Restit/PES_ERAR/LigneERAR/Collectivite/LibelleColBud/@V" datatype="string" format="uppercase"/>
                <sql-index id="SvcOrdo" table="TBL_LIGNEERAR_IX" column="SERVICE_ORDONNATEUR" path="/PES_Restit/PES_ERAR/LigneERAR/ServiceOrdonnateur/@V" datatype="string" format="uppercase"/>
                <sql-index id="refComptaTypeRef" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_TYPE_REF" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/TypeRef/@V" datatype="string"/>
                <sql-index id="refComptaIdBord" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_BORD" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/IdBord/@V" datatype="integer"/>
                <sql-index id="refComptaIdPiece" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_PIECE" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/IdPiece/@V" datatype="integer"/>
                <sql-index id="refComptaExerRattach" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_EXER_RATTACH" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/ExerRattach/@V" datatype="integer"/>
                <sql-index id="refComptaIdLigne" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_LIGNE" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/IdLigne/@V" datatype="integer"/>
                <sql-index id="refComptaNumFact" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_NUM_FACT" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/NumFact/@V" datatype="string" format="uppercase"/>
                <sql-index id="refComptaCodePeriode" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_CODE_PERIODE" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/CodePeriode/@V" datatype="string" format="uppercase"/>
                <sql-index id="refComptaCodProd" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_COD_PROD" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/CodProd/@V" datatype="string" format="uppercase"/>
                <sql-index id="refComptaLibProd" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_LIB_PROD" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/LibProd/@V" datatype="string" format="uppercase"/>
                <sql-index id="refComptaDateEmissionPce" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_DATE_EMISSION_PCE" path="/PES_Restit/PES_ERAR/LigneERAR/RefCompta/DateEmissionPiece/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/IdTiers/@V" datatype="string" format="uppercase"/>
                <sql-index id="debDateMalade" table="TBL_LIGNEERAR_IX" column="DEB_DATE_MALADE" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/DteMalade/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debTypTiers" table="TBL_LIGNEERAR_IX" column="DEB_TYP_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/TypTiers/@V" datatype="string"/>
                <sql-index id="debNatIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_NAT_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/NatIdTiers/@V" datatype="string"/>
                <sql-index id="debDateIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_DATE_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/DteIdTiers/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debRefTiers" table="TBL_LIGNEERAR_IX" column="DEB_REF_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/RefTiers/@V" datatype="string" format="uppercase"/>
                <sql-index id="debCatTiers" table="TBL_LIGNEERAR_IX" column="DEB_CAT_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/CatTiers/@V" datatype="string"/>
                <sql-index id="debNatJur" table="TBL_LIGNEERAR_IX" column="DEB_NAT_JUR" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/NatJur/@V" datatype="string"/>
                <sql-index id="debCivilite" table="TBL_LIGNEERAR_IX" column="DEB_CIVILITE" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/Civilite/@V" datatype="string" format="uppercase"/>
                <sql-index id="debNom" table="TBL_LIGNEERAR_IX" column="DEB_NOM" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/Nom/@V" datatype="string" format="uppercase"/>
                <sql-index id="debComplNom" table="TBL_LIGNEERAR_IX" column="DEB_COMPLNOM" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/ComplNom/@V" datatype="string" format="uppercase"/>
                <sql-index id="debPrenom" table="TBL_LIGNEERAR_IX" column="DEB_PRENOM" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/InfoTiers/Prenom/@V" datatype="string" format="uppercase"/>
                <sql-index id="debTypAdr" table="TBL_LIGNEERAR_IX" column="DEB_TYP_ADR" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/TypAdr/@V" datatype="string"/>
                <sql-index id="debAdr1" table="TBL_LIGNEERAR_IX" column="DEB_ADR1" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/Adr1/@V" datatype="string" format="uppercase"/>
                <sql-index id="debAdr2" table="TBL_LIGNEERAR_IX" column="DEB_ADR2" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/Adr2/@V" datatype="string" format="uppercase"/>
                <sql-index id="debAdr3" table="TBL_LIGNEERAR_IX" column="DEB_ADR3" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/Adr3/@V" datatype="string" format="uppercase"/>
                <sql-index id="debCp" table="TBL_LIGNEERAR_IX" column="DEB_CP" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/CP/@V" datatype="string" format="uppercase"/>
                <sql-index id="debVille" table="TBL_LIGNEERAR_IX" column="DEB_VILLE" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/Ville/@V" datatype="string" format="uppercase"/>
                <sql-index id="debCodPays" table="TBL_LIGNEERAR_IX" column="DEB_CODPAYS" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/CodPays/@V" datatype="string" format="uppercase"/>
                <sql-index id="debDateAdr" table="TBL_LIGNEERAR_IX" column="DEB_DATE_ADR" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/Adresse/DteAdr/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debNpai" table="TBL_LIGNEERAR_IX" column="DEB_NPAI" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/NPAI/@added:normalized" datatype="boolean"/>
                <sql-index id="debRefAllocataire" table="TBL_LIGNEERAR_IX" column="DEB_REF_ALLOCATAIRE" path="/PES_Restit/PES_ERAR/LigneERAR/Debiteur/RefAllocataire/@V" datatype="string" format="uppercase"/>
                <sql-index id="assIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/IdTiers/@V" datatype="string" format="uppercase"/>
                <sql-index id="assDateMalade" table="TBL_LIGNEERAR_IX" column="ASS_DATE_MALADE" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/DteMalade/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="assTypTiers" table="TBL_LIGNEERAR_IX" column="ASS_TYP_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/TypTiers/@V" datatype="string"/>
                <sql-index id="assNatIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_NAT_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/NatIdTiers/@V" datatype="string"/>
                <sql-index id="assDateIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_DATE_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/DteIdTiers/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="assRefTiers" table="TBL_LIGNEERAR_IX" column="ASS_REF_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/RefTiers/@V" datatype="string" format="uppercase"/>
                <sql-index id="assCatTiers" table="TBL_LIGNEERAR_IX" column="ASS_CAT_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/CatTiers/@V" datatype="string"/>
                <sql-index id="assNatJur" table="TBL_LIGNEERAR_IX" column="ASS_NAT_JUR" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/NatJur/@V" datatype="string"/>
                <sql-index id="assCivilite" table="TBL_LIGNEERAR_IX" column="ASS_CIVILITE" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/Civilite/@V" datatype="string" format="uppercase"/>
                <sql-index id="assNom" table="TBL_LIGNEERAR_IX" column="ASS_NOM" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/Nom/@V" datatype="string" format="uppercase"/>
                <sql-index id="assComplNom" table="TBL_LIGNEERAR_IX" column="ASS_COMPLNOM" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/ComplNom/@V" datatype="string" format="uppercase"/>
                <sql-index id="assPrenom" table="TBL_LIGNEERAR_IX" column="ASS_PRENOM" path="/PES_Restit/PES_ERAR/LigneERAR/Assure/Prenom/@V" datatype="string" format="uppercase"/>
                <sql-index id="malIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/IdTiers/@V" datatype="string" format="uppercase"/>
                <sql-index id="malDateMalade" table="TBL_LIGNEERAR_IX" column="MAL_DATE_MALADE" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/DteMalade/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malTypTiers" table="TBL_LIGNEERAR_IX" column="MAL_TYP_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/TypTiers/@V" datatype="string"/>
                <sql-index id="malNatIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_NAT_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/NatIdTiers/@V" datatype="string"/>
                <sql-index id="malDateIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_DATE_ID_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/DteIdTiers/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malRefTiers" table="TBL_LIGNEERAR_IX" column="MAL_REF_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/RefTiers/@V" datatype="string" format="uppercase"/>
                <sql-index id="malCatTiers" table="TBL_LIGNEERAR_IX" column="MAL_CAT_TIERS" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/CatTiers/@V" datatype="string"/>
                <sql-index id="malNatJur" table="TBL_LIGNEERAR_IX" column="MAL_NAT_JUR" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/NatJur/@V" datatype="string"/>
                <sql-index id="malCivilite" table="TBL_LIGNEERAR_IX" column="MAL_CIVILITE" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/Civilite/@V" datatype="string" format="uppercase"/>
                <sql-index id="malNom" table="TBL_LIGNEERAR_IX" column="MAL_NOM" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/Nom/@V" datatype="string" format="uppercase"/>
                <sql-index id="malComplNom" table="TBL_LIGNEERAR_IX" column="MAL_COMPLNOM" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/ComplNom/@V" datatype="string" format="uppercase"/>
                <sql-index id="malPrenom" table="TBL_LIGNEERAR_IX" column="MAL_PRENOM" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/InfoTiers/Prenom/@V" datatype="string" format="uppercase"/>
                <sql-index id="malDateEntree" table="TBL_LIGNEERAR_IX" column="MAL_DATE_ENTREE" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/DateEntree/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malDateSortie" table="TBL_LIGNEERAR_IX" column="MAL_DATE_SORTIE" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/DateSorite/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malNumEntree" table="TBL_LIGNEERAR_IX" column="MAL_NUM_ENTREE" path="/PES_Restit/PES_ERAR/LigneERAR/Malade/NumEntree/@V" datatype="string" format="uppercase"/>
                <sql-index id="mtPrinc" table="TBL_LIGNEERAR_IX" column="MT_PRINC" path="/PES_Restit/PES_ERAR/LigneERAR/MtPrinc/@V" datatype="decimal"/>
                <sql-index id="mtFrais" table="TBL_LIGNEERAR_IX" column="MT_FRAIS" path="/PES_Restit/PES_ERAR/LigneERAR/MtFrais/@V" datatype="decimal"/>
                <sql-index id="RarPrinc" table="TBL_LIGNEERAR_IX" column="RAR_PRINC" path="/PES_Restit/PES_ERAR/LigneERAR/RarPrinc/@V" datatype="decimal"/>
                <sql-index id="RarFrais" table="TBL_LIGNEERAR_IX" column="RAR_FRAIS" path="/PES_Restit/PES_ERAR/LigneERAR/RarFrais/@V" datatype="decimal"/>
                <sql-index id="datePrescription" table="TBL_LIGNEERAR_IX" column="DATE_PRESCRIPTION" path="/PES_Restit/PES_ERAR/LigneERAR/DatePrescription/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="dateAdmissionNV" table="TBL_LIGNEERAR_IX" column="DATE_ADMISSION_NV" path="/PES_Restit/PES_ERAR/LigneERAR/DateAdmissionNV/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="mtNv" table="TBL_LIGNEERAR_IX" column="MT_NV" path="/PES_Restit/PES_ERAR/LigneERAR/MtNV/@V" datatype="decimal"/>
                <sql-index id="dateMajoration" table="TBL_LIGNEERAR_IX" column="DATE_MAJORATION" path="/PES_Restit/PES_ERAR/LigneERAR/DateMajoration/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="codProdLocal" table="TBL_LIGNEERAR_IX" column="COD_PROD_LOCAL" path="/PES_Restit/PES_ERAR/LigneERAR/CodProdLocal/@V" datatype="string" format="uppercase"/>
                <sql-index id="etabGeo" table="TBL_LIGNEERAR_IX" column="ETAB_GEO" path="/PES_Restit/PES_ERAR/LigneERAR/EtabGeo/@V" datatype="string" format="uppercase"/>
                <sql-index id="dateDebFact" table="TBL_LIGNEERAR_IX" column="DATE_DEB_FACT" path="/PES_Restit/PES_ERAR/LigneERAR/DateDebFact/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="dateFinFact" table="TBL_LIGNEERAR_IX" column="DATE_FIN_FACT" path="/PES_Restit/PES_ERAR/LigneERAR/DateFinFact/@V" datatype="date" format="yyyy-MM-dd"/>
                
                <sql-index id="empNodeId" table="TBL_ERAR_EMPECHEMENT_IX" column="NODE_ID" path="/PES_Restit/PES_ERAR/LigneERAR/Empechement/@added:generated-id" datatype="string"/>
                <sql-index id="empCodEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="CODEMP" path="/PES_Restit/PES_ERAR/LigneERAR/Empechement/CodEmp/@V" datatype="string" format="uppercase"/>
                <sql-index id="empLibEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="LIBEMP" path="/PES_Restit/PES_ERAR/LigneERAR/Empechement/LibEmp/@V" datatype="string" format="uppercase"/>
                <sql-index id="empDateDebEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="DATE_DEBUT_EMP" path="/PES_Restit/PES_ERAR/LigneERAR/Empechement/DateDebutEmp/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="empDateFinEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="DATE_FIN_EMP" path="/PES_Restit/PES_ERAR/LigneERAR/Empechement/DateFinEmp/@V" datatype="date" format="yyyy-MM-dd"/>
                
                <sql-index id="etpNodeId" table="TBL_ERAR_ETAPE_IX" column="NODE_ID" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/@added:generated-id" datatype="string"/>
                <sql-index id="etpCodeEtape" table="TBL_ERAR_ETAPE_IX" column="CODE_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/CodeEtape/@V" datatype="string"/>
                <sql-index id="etpNatEtape" table="TBL_ERAR_ETAPE_IX" column="NAT_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/NatEtape/@V" datatype="string"/>
                <sql-index id="etpLibEtape" table="TBL_ERAR_ETAPE_IX" column="LIB_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/LibEtape/@V" datatype="string" format="uppercase"/>
                <sql-index id="etpDateEtape" table="TBL_ERAR_ETAPE_IX" column="DATE_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateEtape/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateAnnulation" table="TBL_ERAR_ETAPE_IX" column="DATE_ANNULATION" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateAnnulation/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpCodeActu" table="TBL_ERAR_ETAPE_IX" column="CODE_ACTU" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/CodeActu/@V" datatype="string" format="uppercase"/>
                <sql-index id="etpLibActu" table="TBL_ERAR_ETAPE_IX" column="LIB_ACTU" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/LibActu/@V" datatype="string" format="uppercase"/>
                <sql-index id="etpDateActu" table="TBL_ERAR_ETAPE_IX" column="DATE_ACTU" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateActu/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpRefActe" table="TBL_ERAR_ETAPE_IX" column="REF_ACTE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/RefActe/@V" datatype="string" format="uppercase"/>
                <sql-index id="etpDateDemandeActe" table="TBL_ERAR_ETAPE_IX" column="DATE_DEMANDE_ACTE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateDemandeActe/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateEnvoiActe" table="TBL_ERAR_ETAPE_IX" column="DATE_ENVOI_ACTE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateEnvoiActe/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateAutomate" table="TBL_ERAR_ETAPE_IX" column="DATE_AUTOMATE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateAutomate/@V" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateRemiseActe" table="TBL_ERAR_ETAPE_IX" column="DATE_REMISE_ACTE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/DateRemiseActe" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpEtatValidation" table="TBL_ERAR_ETAPE_IX" column="ETAT_VALIDATION" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/EtatValidation/@V" datatype="string"/>
                <sql-index id="etpEtatEtape" table="TBL_ERAR_ETAPE_IX" column="ETAT_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/EtatEtape/@V" datatype="string"/>
                <sql-index id="etpNumActePoursuite" table="TBL_ERAR_ETAPE_IX" column="NUM_ACTE_POURSUITE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/NumActePoursuite/@V" datatype="string" format="uppercase"/>
                <sql-index id="etpMtActePoursuite" table="TBL_ERAR_ETAPE_IX" column="MT_ACTE_POURSUITE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/MtActePoursuite/@V" datatype="decimal"/>
                <sql-index id="etpMtEtape" table="TBL_ERAR_ETAPE_IX" column="MT_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/MtEtape/@V" datatype="decimal"/>
                <sql-index id="etpMtFraisEtape" table="TBL_ERAR_ETAPE_IX" column="MT_FRAIS_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/MtFraisEtape/@V" datatype="decimal"/>
                <sql-index id="etpOrigineEtape" table="TBL_ERAR_ETAPE_IX" column="ORIGINE_ETAPE" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/OrigineEtape/@V" datatype="string"/>
                <sql-index id="etpOrdrePres" table="TBL_ERAR_ETAPE_IX" column="ORDREES" path="/PES_Restit/PES_ERAR/LigneERAR/Etape/OrdrePres/@V" datatype="integer"/>
                
                <element id="PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX">
        <sql-count>COUNT(DISTINCT(CONCAT(PES_RESTIT_PES_ERAR_LIGNEERAR_IX.DOC_ID,PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX.NODE_ID)))</sql-count>
        <special-cond>PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX.NODE_ID IS NOT NULL</special-cond>
    </element>
    <element id="PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX">
        <sql-count>COUNT(DISTINCT(CONCAT(PES_RESTIT_PES_ERAR_LIGNEERAR_IX.DOC_ID,PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX.NODE_ID)))</sql-count>
        <special-cond>PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX.NODE_ID IS NOT NULL</special-cond>
    </element>

            </etat>
        </document-->
        <document
            id="ERAR_V2"
            repository-import-xslt-file="">
            <table type="list-bc" base-name="ERAR_LIST_BUDG_COLL_2" version="1">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                COLLECTIVITE VARCHAR(15) NOT NULL,
                BUDGET VARCHAR(24) NOT NULL,
                BUDGET_LIB VARCHAR(200),
                COLLECTIVITE_LIB VARCHAR(200),
                INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
                INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
                ) TYPE MYISAM
            </table>
            <etat id="ligneErarV2" import-xslt-file="erar/erarv2-import-mysql.xsl">
    <key1>
        <path>/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@added:generated-id</path>
    </key1>
    <key2>
        <path>/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@added:generated-id</path>
    </key2>

    <table type="document" base-name="TBL_ERAR_DOCUMENTS_2" version="1">
        CREATE TABLE IF NOT EXISTS ${base-name} (
            COLLECTIVITE VARCHAR(15) NOT NULL,
            BUDGET VARCHAR(24) NOT NULL, 
            INITIAL_DOC_NAME VARCHAR(100) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL, 
            DOC LONGBLOB, 
            ENCODING VARCHAR(20), 
            INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID) 
        ) TYPE MYISAM </table>
    <table type="index" id="TBL_LIGNEERAR_IX" base-name="ERAR_LIGNEERAR_2" version="3" main="true"> 
        CREATE TABLE IF NOT EXISTS ${base-name} ( 
            COLLECTIVITE VARCHAR(15) NOT NULL, 
            BUDGET VARCHAR(24) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL,
            EXER INTEGER,
            ID_COLL VARCHAR(14),
            FINJUR VARCHAR(20),
            COD_COLL VARCHAR(3),
            COD_BUD VARCHAR(2),
            LIBELLE_COLBUD VARCHAR(38),
            SERVICE_ORDONNATEUR VARCHAR(10),
            REF_COMPTA_TYPE_REF VARCHAR(2),
            REF_COMPTA_ID_BORD INTEGER,
            REF_COMPTA_ID_PIECE INTEGER,
            REF_COMPTA_EXER_RATTACH INTEGER,
            REF_COMPTA_ID_LIGNE INTEGER,
            REF_COMPTA_NUM_FACT VARCHAR(15),
            REF_COMPTA_CODE_PERIODE VARCHAR(5),
            REF_COMPTA_COD_PROD VARCHAR(3),
            REF_COMPTA_LIB_PROD VARCHAR(30),
            REF_COMPTA_DATE_EMISSION_PCE DATE,
            DEB_ID_TIERS VARCHAR(15),
            DEB_DATE_MALADE DATE,
            DEB_TYP_TIERS VARCHAR(2),
            DEB_NAT_ID_TIERS VARCHAR(2),
            DEB_DATE_ID_TIERS DATE,
            DEB_REF_TIERS VARCHAR(30),
            DEB_CAT_TIERS VARCHAR(2),
            DEB_NAT_JUR VARCHAR(2),
            DEB_CIVILITE VARCHAR(10),
            DEB_NOM VARCHAR(38),
            DEB_COMPLNOM VARCHAR(38),
            DEB_PRENOM VARCHAR(38),
            DEB_TYP_ADR VARCHAR(1),
            DEB_ADR1 VARCHAR(38),
            DEB_ADR2 VARCHAR(38),
            DEB_ADR3 VARCHAR(38),
            DEB_CP VARCHAR(5),
            DEB_VILLE VARCHAR(38),
            DEB_CODPAYS VARCHAR(50),
            DEB_DATE_ADR DATE,
            DEB_NPAI VARCHAR(1),
            DEB_REF_ALLOCATAIRE VARCHAR(20),
            ASS_ID_TIERS VARCHAR(15),
            ASS_DATE_MALADE DATE,
            ASS_TYP_TIERS VARCHAR(2),
            ASS_NAT_ID_TIERS VARCHAR(2),
            ASS_DATE_ID_TIERS DATE,
            ASS_REF_TIERS VARCHAR(30),
            ASS_CAT_TIERS VARCHAR(2),
            ASS_NAT_JUR VARCHAR(2),
            ASS_CIVILITE VARCHAR(10),
            ASS_NOM VARCHAR(38),
            ASS_COMPLNOM VARCHAR(38),
            ASS_PRENOM VARCHAR(38),
            MAL_ID_TIERS VARCHAR(15),
            MAL_DATE_MALADE DATE,
            MAL_TYP_TIERS VARCHAR(2),
            MAL_NAT_ID_TIERS VARCHAR(2),
            MAL_DATE_ID_TIERS DATE,
            MAL_REF_TIERS VARCHAR(30),
            MAL_CAT_TIERS VARCHAR(2),
            MAL_NAT_JUR VARCHAR(2),
            MAL_CIVILITE VARCHAR(10),
            MAL_NOM VARCHAR(38),
            MAL_COMPLNOM VARCHAR(38),
            MAL_PRENOM VARCHAR(38),
            MAL_DATE_ENTREE DATE,
            MAL_DATE_SORTIE DATe,
            MAL_NUM_ENTREE VARCHAR(14),
            MT_PRINC DECIMAL(14,2),
            MT_FRAIS DECIMAL(14,2),
            RAR_PRINC DECIMAL(14,2),
            RAR_FRAIS DECIMAL(14,2),
            DATE_PRESCRIPTION DATE,
            DATE_ADMISSION_NV DATE,
            MT_NV DECIMAL(14,2),
            DATE_MAJORATION DATE,
            COD_PROD_LOCAL VARCHAR(3),
            ETAB_GEO VARCHAR(10),
            DATE_DEB_FACT DATE,
            DATE_FIN_FACT DATE,
            OBJET_PIECE VARCHAR(160),
        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID)
     ) TYPE MYISAM 
        <patch from-version="1">
            <sql failonerror="false">ALTER TABLE ${base-name} MODIFY DEB_CODPAYS VARCHAR(50)</sql>
            <sql failonerror="false">ALTER TABLE ${base-name} ADD OBJET_PIECE VARCHAR(160)</sql>
        </patch>
        <patch from-version="2">
            <sql failonerror="false">ALTER TABLE ${base-name} ADD OBJET_PIECE VARCHAR(160)</sql>
        </patch>
    </table>
    <table type="index" id="TBL_ERAR_EMPECHEMENT_IX" base-name="ERAR_EMPECHEMENT_2" version="1" main="false" based-on="key1">
        CREATE TABLE IF NOT EXISTS ${base-name} (
            COLLECTIVITE VARCHAR(15) NOT NULL,
            BUDGET VARCHAR(24) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL, 
            NODE_ID VARCHAR(50) NOT NULL, 
            CODEMP VARCHAR(15), 
            LIBEMP VARCHAR(30),
            DATE_DEBUT_EMP DATE,
            DATE_FIN_EMP DATE,
         INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
         INDEX IX_${base-name}_DC (DOC_ID)
     ) TYPE MYISAM
    </table>
    <table type="index" id="TBL_ERAR_ETAPE_IX" base-name="ERAR_ETAPE_2" version="1" main="false" based-on="key2">
        CREATE TABLE IF NOT EXISTS ${base-name} (
            COLLECTIVITE VARCHAR(15) NOT NULL, 
            BUDGET VARCHAR(24) NOT NULL, 
            DOC_ID VARCHAR(100) NOT NULL, 
            NODE_ID VARCHAR(50) NOT NULL, 
            CODE_ETAPE VARCHAR(3), 
            NAT_ETAPE VARCHAR(2), 
            LIB_ETAPE VARCHAR(30), 
            DATE_ETAPE DATE,
            DATE_ANNULATION DATE,
            CODE_ACTU VARCHAR(2), 
            LIB_ACTU VARCHAR(30),
            DATE_ACTU DATE,
            REF_ACTE VARCHAR(14),
            DATE_DEMANDE_ACTE DATE, 
            DATE_ENVOI_ACTE DATE,
            DATE_AUTOMATE DATE,
            DATE_REMISE_ACTE DATE,
            ETAT_VALIDATION VARCHAR(1),
            ETAT_ETAPE VARCHAR(1),
            NUM_ACTE_POURSUITE VARCHAR(14), 
            MT_ACTE_POURSUITE DECIMAL(14,2), 
            MT_ETAPE DECIMAL(14,2),
            MT_FRAIS_ETAPE DECIMAL(14,2),
            ORIGINE_ETAPE VARCHAR(1),
            ORDREPRES INTEGER,
        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
        INDEX IX_${base-name}_DC (DOC_ID)
    ) TYPE MYISAM
    </table>


    <!-- CRITERIA /PES_Restit/PES_ERAR/LigneERAR -->
                <criteria id="IdColl" sql-index-id="IdColl">
                    <where-clause>fn:string-compare(${table}.${column},IdColl)</where-clause>
                </criteria>
                <criteria id="FinJur" sql-index-id="FinJur">
                    <where-clause>fn:string-compare(${table}.${column},FinJur)</where-clause>
                </criteria>
                <criteria id="CodCol" sql-index-id="CodCol">
                    <where-clause>fn:string-compare(${table}.${column},CodCol)</where-clause>
                </criteria>
                <criteria id="CodBud" sql-index-id="CodBud">
                    <where-clause>fn:string-compare(${table}.${column},CodBud)</where-clause>
                </criteria>
                <criteria id="LibColBud" sql-index-id="LibelleColBud">
                    <where-clause>fn:string-compare(${table}.${column},LibColBud)</where-clause>
                </criteria>
                
                <criteria id="ordo" sql-index-id="SvcOrdo">
                    <where-clause>fn:string-compare(${table}.${column},ordo)</where-clause>
                </criteria>
                <criteria id="RefComptaTypeRef" sql-index-id="refComptaTypeRef">
                    <where-clause>${table}.${column}='##VALEUR:TypeRef##'</where-clause>
                </criteria>
                <criteria id="RefComptaIdBord" sql-index-id="refComptaIdBord">
                    <where-clause>${table}.${column}##OPERATEUR:IdBord####VALEUR:IdBord##</where-clause>
                </criteria>
                <criteria id="RefComptaIdPiece" sql-index-id="refComptaIdPiece">
                    <where-clause>${table}.${column}##OPERATEUR:IdPiece####VALEUR:IdPiece##</where-clause>
                </criteria>
                <criteria id="RefComptaExerRattach" sql-index-id="refComptaExerRattach">
                    <where-clause>${table}.${column}##OPERATEUR:exer####VALEUR:exer##</where-clause>
                </criteria>
                <criteria id="RefComptaIdLigne" sql-index-id="refComptaIdLigne">
                    <where-clause>${table}.${column}##OPERATEUR:IdLigne####VALEUR:IdLigne##</where-clause>
                </criteria>
                <criteria id="RefComptaNumFact" sql-index-id="refComptaNumFact">
                    <where-clause>fn:string-compare(${table}.${column},NumFact)</where-clause>
                </criteria>
                <criteria id="RefComptaCodePeriode" sql-index-id="refComptaCodePeriode">
                    <where-clause>fn:string-compare(${table}.${column},CodePeriode)</where-clause>
                </criteria>
                <criteria id="RefComptaCodProd" sql-index-id="refComptaCodProd">
                    <where-clause>fn:string-compare(${table}.${column},CodProd)</where-clause>
                </criteria>
                <criteria id="RefComptaLibProd" sql-index-id="refComptaLibProd">
                    <where-clause>fn:string-compare(${table}.${column},LibProd)</where-clause>
                </criteria>
                <criteria id="RefComptaDatePce" sql-index-id="refComptaDateEmissionPce">
                    <where-clause>fn:date-compare(${table}.${column},DatePce)</where-clause>
                </criteria>
                
                <criteria id="ObjetPiece" sql-index-id="objetPiece">
                    <where-clause>fn:string-compare(${table}.${column},ObjetPiece)</where-clause>
                </criteria>
                
                
                <criteria id="DebIdTiers" sql-index-id="debIdTiers">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="DebNom" sql-index-id="debNom">
                    <where-clause>fn:string-compare(${table}.${column},DebNom)</where-clause>
                </criteria>
                <criteria id="DebComplNom" sql-index-id="debComplNom">
                    <where-clause>fn:string-compare(${table}.${column},DebComplNom)</where-clause>
                </criteria>
                <criteria id="DebPrenom" sql-index-id="debPrenom">
                    <where-clause>fn:string-compare(${table}.${column},DebPrenom)</where-clause>
                </criteria>
                <criteria id="DebTypTiers" sql-index-id="debTypTiers">
                    <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
                </criteria>
                <criteria id="DebDteIdTiers" sql-index-id="debDateIdTiers">
                    <where-clause>fn:date-compare(${table}.${column},DebDteIdTiers)</where-clause>
                </criteria>
                <criteria id="DebRefTiers" sql-index-id="debRefTiers">
                    <where-clause>fn:string-compare(${table}.${column},DebRefTiers)</where-clause>
                </criteria>
                <criteria id="DebCatTiers" sql-index-id="debCatTiers">
                    <where-clause>${table}.${column}='##VALEUR:DebCatTiers##'</where-clause>
                </criteria>
                <criteria id="DebNatJur" sql-index-id="debNatJur">
                    <where-clause>${table}.${column}='##VALEUR:DebNatJur##'</where-clause>
                </criteria>
                <criteria id="DebCivilite" sql-index-id="debCivilite">
                    <where-clause>${table}.${column}='##VALEUR:DebCivilite##'</where-clause>
                </criteria>
                <!--criteria id="DebTypAdr" sql-index-id="debTypAdr">
                    <where-clause>${table}.${column}='##VALEUR:DebTypAdr##'</where-clause>
                </criteria-->
                <criteria id="DebAdr1" sql-index-id="debAdr1">
                    <where-clause>fn:string-compare(${table}.${column},DebAdr1)</where-clause>
                </criteria>
                <criteria id="DebAdr2" sql-index-id="debAdr2">
                    <where-clause>fn:string-compare(${table}.${column},DebAdr2)</where-clause>
                </criteria>
                <criteria id="DebAdr3" sql-index-id="debAdr3">
                    <where-clause>fn:string-compare(${table}.${column},DebAdr3)</where-clause>
                </criteria>
                <criteria id="DebCP" sql-index-id="debCp">
                    <where-clause>fn:string-compare(${table}.${column},DebCP)</where-clause>
                </criteria>
                <criteria id="DebVille" sql-index-id="debVille">
                    <where-clause>fn:string-compare(${table}.${column},DebVille)</where-clause>
                </criteria>
                <criteria id="DebPays" sql-index-id="debCodPays">
                    <where-clause>fn:string-compare(${table}.${column},DebPays)</where-clause>
                </criteria>
                <criteria id="DebNPAI" sql-index-id="debNpai">
                    <where-clause>${table}.${column}='##VALEUR:DebNPAI##'</where-clause>
                </criteria>
                <criteria id="DebRefAllocataire" sql-index-id="debRefAllocataire">
                    <where-clause>fn:string-compare(${table}.${column},DebRefAllocataire)</where-clause>
                </criteria>
                
                <criteria id="AssIdTiers" sql-index-id="assIdTiers">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="AssNom" sql-index-id="assNom">
                    <where-clause>fn:string-compare(${table}.${column},AssNom)</where-clause>
                </criteria>
                <criteria id="AssComplNom" sql-index-id="assComplNom">
                    <where-clause>fn:string-compare(${table}.${column},AssComplNom)</where-clause>
                </criteria>
                <criteria id="AssPrenom" sql-index-id="assPrenom">
                    <where-clause>fn:string-compare(${table}.${column},AssPrenom)</where-clause>
                </criteria>
                <criteria id="AssTypTiers" sql-index-id="assTypTiers">
                    <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
                </criteria>
                <criteria id="AssDteIdTiers" sql-index-id="assDateIdTiers">
                    <where-clause>fn:date-compare(${table}.${column},AssDteIdTiers)</where-clause>
                </criteria>
                <criteria id="AssRefTiers" sql-index-id="assRefTiers">
                    <where-clause>fn:string-compare(${table}.${column},AssRefTiers)</where-clause>
                </criteria>
                <criteria id="AssCatTiers" sql-index-id="assCatTiers">
                    <where-clause>${table}.${column}='##VALEUR:AssCatTiers##'</where-clause>
                </criteria>
                <criteria id="AssNatJur" sql-index-id="assNatJur">
                    <where-clause>${table}.${column}='##VALEUR:AssNatJur##'</where-clause>
                </criteria>
                <criteria id="AssCivilite" sql-index-id="assCivilite">
                    <where-clause>${table}.${column}='##VALEUR:AssCivilite##'</where-clause>
                </criteria>
                
                <criteria id="MalIdTiers" sql-index-id="malIdTiers">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="MalNom" sql-index-id="malNom">
                    <where-clause>fn:string-compare(${table}.${column},MalNom)</where-clause>
                </criteria>
                <criteria id="MalComplNom" sql-index-id="malComplNom">
                    <where-clause>fn:string-compare(${table}.${column},MalComplNom)</where-clause>
                </criteria>
                <criteria id="MalPrenom" sql-index-id="malPrenom">
                    <where-clause>fn:string-compare(${table}.${column},MalPrenom)</where-clause>
                </criteria>
                <criteria id="MalTypTiers" sql-index-id="malTypTiers">
                    <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
                </criteria>
                <criteria id="MalDteIdTiers" sql-index-id="malDateIdTiers">
                    <where-clause>fn:date-compare(${table}.${column},MalDteIdTiers)</where-clause>
                </criteria>
                <criteria id="MalRefTiers" sql-index-id="malRefTiers">
                    <where-clause>fn:string-compare(${table}.${column},MalRefTiers)</where-clause>
                </criteria>
                <criteria id="MalCatTiers" sql-index-id="malCatTiers">
                    <where-clause>${table}.${column}='##VALEUR:MalCatTiers##'</where-clause>
                </criteria>
                <criteria id="MalNatJur" sql-index-id="malNatJur">
                    <where-clause>${table}.${column}='##VALEUR:MalNatJur##'</where-clause>
                </criteria>
                <criteria id="MalCivilite" sql-index-id="malCivilite">
                    <where-clause>${table}.${column}='##VALEUR:MalCivilite##'</where-clause>
                </criteria>
                <criteria id="MalDateEntree" sql-index-id="malDateEntree">
                    <where-clause>fn:date-compare(${table}.${column},MalDateEntree)</where-clause>
                </criteria>
                <criteria id="MalDateSortie" sql-index-id="malDateSortie">
                    <where-clause>fn:date-compare(${table}.${column},MalDateSortie)</where-clause>
                </criteria>
                <criteria id="MalNumEntree" sql-index-id="malNumEntree">
                    <where-clause>fn:string-compare(${table}.${column},MalNumEntree)</where-clause>
                </criteria>
                
                <criteria id="MtPrinc" sql-index-id="mtPrinc">
                    <where-clause>${table}.${column}##OPERATEUR:MtPrinc####VALEUR:MtPrinc##</where-clause>
                </criteria>
                <criteria id="MtFrais" sql-index-id="mtFrais">
                    <where-clause>${table}.${column}##OPERATEUR:MtFrais####VALEUR:MtFrais##</where-clause>
                </criteria>
                <criteria id="RarPrinc" sql-index-id="RarPrinc">
                    <where-clause>${table}.${column}##OPERATEUR:RarPrinc####VALEUR:RarPrinc##</where-clause>
                </criteria>
                <criteria id="RarFrais" sql-index-id="RarFrais">
                    <where-clause>${table}.${column}##OPERATEUR:RarFrais####VALEUR:RarFrais##</where-clause>
                </criteria>
                <criteria id="DateNV" sql-index-id="dateAdmissionNV">
                    <where-clause>fn:date-compare(${table}.${column},DateNV)</where-clause>
                </criteria>
                <criteria id="MtNV" sql-index-id="mtNv">
                    <where-clause>${table}.${column}##OPERATEUR:MtNV####VALEUR:MtNV##</where-clause>
                </criteria>
                <criteria id="DateMajoration" sql-index-id="dateMajoration">
                    <where-clause>fn:date-compare(${table}.${column},DateMajoration)</where-clause>
                </criteria>
                <criteria id="DatePrescription" sql-index-id="datePrescription">
                    <where-clause>fn:date-compare(${table}.${column},DatePrescription)</where-clause>
                </criteria>
                <criteria id="etabGeo" sql-index-id="etabGeo">
                    <where-clause>fn:string-compare(${table}.${column},etabGeo)</where-clause>
                </criteria>
                <criteria id="CodProdLocal" sql-index-id="codProdLocal">
                    <where-clause>fn:string-compare(${table}.${column},CodProdLocal)</where-clause>
                </criteria>
                <criteria id="DateDebFact" sql-index-id="dateDebFact">
                    <where-clause>fn:date-compare(${table}.${column},DateDebFact)</where-clause>
                </criteria>
                <criteria id="DateFinFact" sql-index-id="dateFinFact">
                    <where-clause>fn:date-compare(${table}.${column},DateFinFact)</where-clause>
                </criteria>
                
                <criteria id="EmpCodEmp" sql-index-id="empCodEmp">
                    <where-clause>${table}.${column}=##VALEUR:CodEmp##</where-clause>
                </criteria>
                <criteria id="EmpDateDebEmp" sql-index-id="empDateDebEmp">
                    <where-clause>fn:date-compare(${table}.${column},DateDebEmp)</where-clause>
                </criteria>
                <criteria id="EmpDateFinEmp" sql-index-id="empDateFinEmp">
                    <where-clause>fn:date-compare(${table}.${column},DateFinEmp)</where-clause>
                </criteria>
                
                <criteria id="EtpCodeEtape" sql-index-id="etpCodeEtape">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtape)</where-clause>
                </criteria>
                <criteria id="EtpNatEtape" sql-index-id="etpCodeEtape">
                    <where-clause>${table}.${column}='##VALEUR:NatEtape##'</where-clause>
                </criteria>
                <!--criteria id="EtpLibEtape" sql-index-id="etpLibEtape">
                    <where-clause>fn:string-compare(${table}.${column},LibEtape)</where-clause>
                </criteria-->
                <criteria id="EtpDateEtape" sql-index-id="etpDateEtape">
                    <where-clause>fn:date-compare(${table}.${column},DateEtape)</where-clause>
                </criteria>
                <criteria id="EtpDateAnnulation" sql-index-id="etpDateAnnulation">
                    <where-clause>fn:date-compare(${table}.${column},DateAnnulation)</where-clause>
                </criteria>
                <criteria id="EtpDateActu" sql-index-id="etpDateActu">
                    <where-clause>fn:date-compare(${table}.${column},DateActu)</where-clause>
                </criteria>
                
                <criteria id="EtpCodeActu" sql-index-id="etpCodeActu">
                    <where-clause>${table}.${column}='##VALEUR:CodeActu##'</where-clause>
                </criteria>
                <!--criteria id="EtpLibActu" sql-index-id="etpLibActu">
                    <where-clause>fn:string-compare(${table}.${column},LibActu)</where-clause>
                </criteria-->
                <criteria id="EtpRefActe" sql-index-id="etpRefActe">
                    <where-clause>fn:string-compare(${table}.${column},RefActe)</where-clause>
                </criteria>
                <criteria id="EtpDateDemandeActe" sql-index-id="etpDateDemandeActe">
                    <where-clause>fn:date-compare(${table}.${column},DateDemande)</where-clause>
                </criteria>
                <criteria id="EtpDateEnvoiActe" sql-index-id="etpDateEnvoiActe">
                    <where-clause>fn:date-compare(${table}.${column},DateEnvoi)</where-clause>
                </criteria>
                <criteria id="EtpDateRemiseActe" sql-index-id="etpDateRemiseActe">
                    <where-clause>fn:date-compare(${table}.${column},DateRemise)</where-clause>
                </criteria>
                <criteria id="EtpDateAutomate" sql-index-id="etpDateAutomate">
                    <where-clause>fn:date-compare(${table}.${column},DateAutomate)</where-clause>
                </criteria>
                <criteria id="EtpEtatValidation" sql-index-id="etpEtatValidation">
                    <where-clause>${table}.${column}='##VALEUR:EtatValidation##'</where-clause>
                </criteria>
                <criteria id="EtpEtatEtape" sql-index-id="etpEtatEtape">
                    <where-clause>${table}.${column}='##VALEUR:EtatEtape##'</where-clause>
                </criteria>
                <criteria id="EtpNumActe" sql-index-id="etpNumActePoursuite">
                    <where-clause>fn:string-compare(${table}.${column},NumActe)</where-clause>
                </criteria>
                <criteria id="EtpMtActe" sql-index-id="etpMtActePoursuite">
                    <where-clause>${table}.${column}##OPERATEUR:MtActe####VALEUR:MtActe##</where-clause>
                </criteria>
                <criteria id="EtpMtEtape" sql-index-id="etpMtEtape">
                    <where-clause>${table}.${column}##OPERATEUR:MtEtape####VALEUR:MtEtape##</where-clause>
                </criteria>
                <criteria id="EtpMtFraisEtape" sql-index-id="etpMtFraisEtape">
                    <where-clause>${table}.${column}##OPERATEUR:MtFraisEtape####VALEUR:MtFraisEtape##</where-clause>
                </criteria>
                <criteria id="EtpOrigineEtape" sql-index-id="etpOrigineEtape">
                    <where-clause>${table}.${column}='##VALEUR:OrigineEtape##'</where-clause>
                </criteria>
                <criteria id="docId" sql-index-id="debIdTiers">
                    <where-clause>ERAR_LIGNEERAR_2.DOC_ID='##VALEUR:docId##'</where-clause>
                </criteria>
                
                
                
                <sql-index id="exer" table="TBL_LIGNEERAR_IX" column="EXER" path="/n:PosteComptable/n:Piece/@ExerRattach" datatype="string" format="uppercase"/>
                <sql-index id="IdColl" table="TBL_LIGNEERAR_IX" column="ID_COLL" path="/n:PosteComptable/@IdColl" datatype="string" format="uppercase"/>
                <sql-index id="FinJur" table="TBL_LIGNEERAR_IX" column="FINJUR" path="/n:PosteComptable/@FinJur" datatype="string" format="uppercase"/>
                <sql-index id="CodCol" table="TBL_LIGNEERAR_IX" column="COD_COLL" path="/n:PosteComptable/@CodCol" datatype="string" format="uppercase"/>
                <sql-index id="CodBud" table="TBL_LIGNEERAR_IX" column="COD_BUD" path="/n:PosteComptable/@CodBud" datatype="string" format="uppercase"/>
                <sql-index id="LibelleColBud" table="TBL_LIGNEERAR_IX" column="LIBELLE_COLBUD" path="/n:PosteComptable/@LibelleColBud" datatype="string" format="uppercase"/>
                <sql-index id="SvcOrdo" table="TBL_LIGNEERAR_IX" column="SERVICE_ORDONNATEUR" path="/n:PosteComptable/n:Piece/n:LigneERAR/@ServiceOrdonnateur" datatype="string" format="uppercase"/>
                <sql-index id="refComptaTypeRef" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_TYPE_REF" path="/n:PosteComptable/n:Piece/@TypeRef" datatype="string"/>
                <sql-index id="refComptaIdBord" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_BORD" path="/n:PosteComptable/n:Piece/@IdBord" datatype="integer"/>
                <sql-index id="refComptaIdPiece" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_PIECE" path="/n:PosteComptable/n:Piece/@IdPiece" datatype="integer"/>
                <sql-index id="refComptaExerRattach" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_EXER_RATTACH" path="/n:PosteComptable/n:Piece/@ExerRattach" datatype="integer"/>
                <sql-index id="refComptaIdLigne" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_LIGNE" path="/n:PosteComptable/n:Piece/n:LigneERAR/@IdLigne" datatype="integer"/>
                <sql-index id="refComptaNumFact" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_NUM_FACT" path="/n:PosteComptable/n:Piece/n:LigneERAR/@NumFact" datatype="string" format="uppercase"/>
                <sql-index id="refComptaCodePeriode" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_CODE_PERIODE" path="/n:PosteComptable/n:Piece/n:LigneERAR/@CodePeriode" datatype="string" format="uppercase"/>
                <sql-index id="refComptaCodProd" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_COD_PROD" path="/n:PosteComptable/n:Piece/n:LigneERAR/@CodProduit" datatype="string" format="uppercase"/>
                <sql-index id="refComptaLibProd" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_LIB_PROD" path="/n:PosteComptable/n:Piece/n:LigneERAR/@LibProduit" datatype="string" format="uppercase"/>
                <sql-index id="refComptaDateEmissionPce" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_DATE_EMISSION_PCE" path="/n:PosteComptable/n:Piece/@DateEmissionPiece" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@IdTiers" datatype="string" format="uppercase"/>
                <sql-index id="debDateMalade" table="TBL_LIGNEERAR_IX" column="DEB_DATE_MALADE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@DteMalade" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debTypTiers" table="TBL_LIGNEERAR_IX" column="DEB_TYP_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@TypTiers" datatype="string"/>
                <sql-index id="debNatIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_NAT_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@NatIdTiers" datatype="string"/>
                <sql-index id="debDateIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_DATE_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@DteIdTiers" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debRefTiers" table="TBL_LIGNEERAR_IX" column="DEB_REF_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@RefTiers" datatype="string" format="uppercase"/>
                <sql-index id="debCatTiers" table="TBL_LIGNEERAR_IX" column="DEB_CAT_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@CatTiers" datatype="string"/>
                <sql-index id="debNatJur" table="TBL_LIGNEERAR_IX" column="DEB_NAT_JUR" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@NatJur" datatype="string"/>
                <sql-index id="debCivilite" table="TBL_LIGNEERAR_IX" column="DEB_CIVILITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Civilite" datatype="string" format="uppercase"/>
                <sql-index id="debNom" table="TBL_LIGNEERAR_IX" column="DEB_NOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Nom" datatype="string" format="uppercase"/>
                <sql-index id="debComplNom" table="TBL_LIGNEERAR_IX" column="DEB_COMPLNOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@ComplNom" datatype="string" format="uppercase"/>
                <sql-index id="debPrenom" table="TBL_LIGNEERAR_IX" column="DEB_PRENOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Prenom" datatype="string" format="uppercase"/>
                <sql-index id="debAdr1" table="TBL_LIGNEERAR_IX" column="DEB_ADR1" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Adr1" datatype="string" format="uppercase"/>
                <sql-index id="debAdr2" table="TBL_LIGNEERAR_IX" column="DEB_ADR2" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Adr2" datatype="string" format="uppercase"/>
                <sql-index id="debAdr3" table="TBL_LIGNEERAR_IX" column="DEB_ADR3" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Adr3" datatype="string" format="uppercase"/>
                <sql-index id="debCp" table="TBL_LIGNEERAR_IX" column="DEB_CP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@CP" datatype="string" format="uppercase"/>
                <sql-index id="debVille" table="TBL_LIGNEERAR_IX" column="DEB_VILLE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Ville" datatype="string" format="uppercase"/>
                <sql-index id="debCodPays" table="TBL_LIGNEERAR_IX" column="DEB_CODPAYS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@CodPays" datatype="string" format="uppercase"/>
                <sql-index id="debDateAdr" table="TBL_LIGNEERAR_IX" column="DEB_DATE_ADR" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@DteAdr" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="debNpai" table="TBL_LIGNEERAR_IX" column="DEB_NPAI" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@added:NPAI-normalized" datatype="boolean"/>
                <sql-index id="debRefAllocataire" table="TBL_LIGNEERAR_IX" column="DEB_REF_ALLOCATAIRE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@RefAllocataire" datatype="string" format="uppercase"/>
                <sql-index id="assIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@IdTiers" datatype="string" format="uppercase"/>
                <sql-index id="assDateMalade" table="TBL_LIGNEERAR_IX" column="ASS_DATE_MALADE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@DteMalade" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="assTypTiers" table="TBL_LIGNEERAR_IX" column="ASS_TYP_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@TypTiers" datatype="string"/>
                <sql-index id="assNatIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_NAT_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@NatIdTiers" datatype="string"/>
                <sql-index id="assDateIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_DATE_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@DteIdTiers" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="assRefTiers" table="TBL_LIGNEERAR_IX" column="ASS_REF_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@RefTiers" datatype="string" format="uppercase"/>
                <sql-index id="assCatTiers" table="TBL_LIGNEERAR_IX" column="ASS_CAT_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@CatTiers" datatype="string"/>
                <sql-index id="assNatJur" table="TBL_LIGNEERAR_IX" column="ASS_NAT_JUR" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@NatJur" datatype="string"/>
                <sql-index id="assCivilite" table="TBL_LIGNEERAR_IX" column="ASS_CIVILITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@Civilite" datatype="string" format="uppercase"/>
                <sql-index id="assNom" table="TBL_LIGNEERAR_IX" column="ASS_NOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@Nom" datatype="string" format="uppercase"/>
                <sql-index id="assComplNom" table="TBL_LIGNEERAR_IX" column="ASS_COMPLNOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@ComplNom" datatype="string" format="uppercase"/>
                <sql-index id="assPrenom" table="TBL_LIGNEERAR_IX" column="ASS_PRENOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@Prenom" datatype="string" format="uppercase"/>
                <sql-index id="malIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@IdTiers" datatype="string" format="uppercase"/>
                <sql-index id="malDateMalade" table="TBL_LIGNEERAR_IX" column="MAL_DATE_MALADE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DteMalade" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malTypTiers" table="TBL_LIGNEERAR_IX" column="MAL_TYP_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@TypTiers" datatype="string"/>
                <sql-index id="malNatIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_NAT_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@NatIdTiers" datatype="string"/>
                <sql-index id="malDateIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_DATE_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DteIdTiers" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malRefTiers" table="TBL_LIGNEERAR_IX" column="MAL_REF_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@RefTiers" datatype="string" format="uppercase"/>
                <sql-index id="malCatTiers" table="TBL_LIGNEERAR_IX" column="MAL_CAT_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@CatTiers" datatype="string"/>
                <sql-index id="malNatJur" table="TBL_LIGNEERAR_IX" column="MAL_NAT_JUR" path="/n:PES_Restit/n:PES_ERAR/n:LigneERAR/n:Malade/n:InfoTiers/n:NatJur/@V" datatype="string"/>
                <sql-index id="malCivilite" table="TBL_LIGNEERAR_IX" column="MAL_CIVILITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Civilite" datatype="string" format="uppercase"/>
                <sql-index id="malNom" table="TBL_LIGNEERAR_IX" column="MAL_NOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Nom" datatype="string" format="uppercase"/>
                <sql-index id="malComplNom" table="TBL_LIGNEERAR_IX" column="MAL_COMPLNOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@ComplNom" datatype="string" format="uppercase"/>
                <sql-index id="malPrenom" table="TBL_LIGNEERAR_IX" column="MAL_PRENOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Prenom" datatype="string" format="uppercase"/>
                <sql-index id="malDateEntree" table="TBL_LIGNEERAR_IX" column="MAL_DATE_ENTREE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DateEntree" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malDateSortie" table="TBL_LIGNEERAR_IX" column="MAL_DATE_SORTIE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DateSorite" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="malNumEntree" table="TBL_LIGNEERAR_IX" column="MAL_NUM_ENTREE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@NumEntree" datatype="string" format="uppercase"/>
                <sql-index id="mtPrinc" table="TBL_LIGNEERAR_IX" column="MT_PRINC" path="/n:PosteComptable/n:Piece/n:LigneERAR/@MtPrincipal" datatype="decimal"/>
                <sql-index id="mtFrais" table="TBL_LIGNEERAR_IX" column="MT_FRAIS" path="/n:PosteComptable/n:Piece/n:LigneERAR/@MtFrais" datatype="decimal"/>
                <sql-index id="RarPrinc" table="TBL_LIGNEERAR_IX" column="RAR_PRINC" path="/n:PosteComptable/n:Piece/n:LigneERAR/@RarPrincipal" datatype="decimal"/>
                <sql-index id="RarFrais" table="TBL_LIGNEERAR_IX" column="RAR_FRAIS" path="/n:PosteComptable/n:Piece/n:LigneERAR/@RarFrais" datatype="decimal"/>
                <sql-index id="datePrescription" table="TBL_LIGNEERAR_IX" column="DATE_PRESCRIPTION" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DatePrescription" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="dateAdmissionNV" table="TBL_LIGNEERAR_IX" column="DATE_ADMISSION_NV" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateAdmissionNV" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="mtNv" table="TBL_LIGNEERAR_IX" column="MT_NV" path="/n:PosteComptable/n:Piece/n:LigneERAR/@MtNV" datatype="decimal"/>
                <sql-index id="dateMajoration" table="TBL_LIGNEERAR_IX" column="DATE_MAJORATION" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateMajoration" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="codProdLocal" table="TBL_LIGNEERAR_IX" column="COD_PROD_LOCAL" path="/n:PosteComptable/n:Piece/n:LigneERAR/@CodProdLocal" datatype="string" format="uppercase"/>
                <sql-index id="etabGeo" table="TBL_LIGNEERAR_IX" column="ETAB_GEO" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Maison" datatype="string" format="uppercase"/>
                <sql-index id="dateDebFact" table="TBL_LIGNEERAR_IX" column="DATE_DEB_FACT" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateDebFact" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="dateFinFact" table="TBL_LIGNEERAR_IX" column="DATE_FIN_FACT" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateFinFact" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="objetPiece" table="TBL_LIGNEERAR_IX" column="OBJET_PIECE" path="/n:PosteComptable/n:Piece/n:LigneERAR/@ObjetPiece" datatype="string" format="uppercase"/>
                
                <sql-index id="empNodeId" table="TBL_ERAR_EMPECHEMENT_IX" column="NODE_ID" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@added:generated-id" datatype="string"/>
                <sql-index id="empCodEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="CODEMP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@Code" datatype="string" format="uppercase"/>
                <sql-index id="empDateDebEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="DATE_DEBUT_EMP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@DateDebut" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="empDateFinEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="DATE_FIN_EMP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@DateFin" datatype="date" format="yyyy-MM-dd"/>
                
                <sql-index id="etpNodeId" table="TBL_ERAR_ETAPE_IX" column="NODE_ID" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@added:generated-id" datatype="string"/>
                <sql-index id="etpCodeEtape" table="TBL_ERAR_ETAPE_IX" column="CODE_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@CodeEtape" datatype="string"/>
                <sql-index id="etpDateEtape" table="TBL_ERAR_ETAPE_IX" column="DATE_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateEtape" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateAnnulation" table="TBL_ERAR_ETAPE_IX" column="DATE_ANNULATION" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateAnnulation" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpCodeActu" table="TBL_ERAR_ETAPE_IX" column="CODE_ACTU" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@CodeActu" datatype="string" format="uppercase"/>
                <sql-index id="etpDateActu" table="TBL_ERAR_ETAPE_IX" column="DATE_ACTU" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateActu" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpRefActe" table="TBL_ERAR_ETAPE_IX" column="REF_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@RefActe" datatype="string" format="uppercase"/>
                <sql-index id="etpDateDemandeActe" table="TBL_ERAR_ETAPE_IX" column="DATE_DEMANDE_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateDemandeActe" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateEnvoiActe" table="TBL_ERAR_ETAPE_IX" column="DATE_ENVOI_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateEnvoiActe" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateAutomate" table="TBL_ERAR_ETAPE_IX" column="DATE_AUTOMATE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateAutomate" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpDateRemiseActe" table="TBL_ERAR_ETAPE_IX" column="DATE_REMISE_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateRemiseActe" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="etpEtatValidation" table="TBL_ERAR_ETAPE_IX" column="ETAT_VALIDATION" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@ValiditeEtape" datatype="string"/>
                <sql-index id="etpEtatEtape" table="TBL_ERAR_ETAPE_IX" column="ETAT_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@EtatEtape" datatype="string"/>
                <sql-index id="etpNumActePoursuite" table="TBL_ERAR_ETAPE_IX" column="NUM_ACTE_POURSUITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@RefActe" datatype="string" format="uppercase"/>
                <sql-index id="etpMtActePoursuite" table="TBL_ERAR_ETAPE_IX" column="MT_ACTE_POURSUITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@MtActe" datatype="decimal"/>
                <sql-index id="etpMtEtape" table="TBL_ERAR_ETAPE_IX" column="MT_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@MtEtape" datatype="decimal"/>
                <sql-index id="etpMtFraisEtape" table="TBL_ERAR_ETAPE_IX" column="MT_FRAIS_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@MtFraisEtape" datatype="decimal"/>
                <sql-index id="etpOrigineEtape" table="TBL_ERAR_ETAPE_IX" column="ORIGINE_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@OrigineEtape" datatype="string"/>
                
                <element id="PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX">
        <sql-count>COUNT(DISTINCT(CONCAT(PES_RESTIT_PES_ERAR_LIGNEERAR_IX.DOC_ID,PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX.NODE_ID)))</sql-count>
        <special-cond>PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX.NODE_ID IS NOT NULL</special-cond>
    </element>
    <element id="PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX">
        <sql-count>COUNT(DISTINCT(CONCAT(PES_RESTIT_PES_ERAR_LIGNEERAR_IX.DOC_ID,PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX.NODE_ID)))</sql-count>
        <special-cond>PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX.NODE_ID IS NOT NULL</special-cond>
    </element>

            </etat>
        </document>
    </layer>
</persistence-config>

