--- /dev/null
+<?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">
+ <!-- persistence-model defines the way informations are defined -->
+ <!-- only xemelios-sql is defined at this moment -->
+ <document id="bourses" repository-import-xslt-file="bourses/nomenclature-import-bourses.xsl">
+ <table type="repository" base-name="BOURSES_REPOSITORY" version="1">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ ID VARCHAR(25),
+ LIBELLE VARCHAR(100),
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ REPOSITORY LONGBLOB,
+ ENCODING VARCHAR(20)
+ ) ENGINE MYISAM
+ </table>
+ <table type="special-key" base-name="BOURSES_SPECIAL_KEYS" 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,
+ KEY1 VARCHAR(100) NOT NULL,
+ LIB1 VARCHAR(200),
+ KEY2 VARCHAR(100),
+ LIB2 VARCHAR(200),
+ KEY3 VARCHAR(100),
+ LIB3 VARCHAR(200),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <table type="list-bc" base-name="BOURSES_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),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <etat
+ id="bourses"
+ import-xslt-file="bourses/bourses-import-mysql.xsl">
+ <key1>
+ <path>/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/@generated-id</path>
+ </key1>
+ <table
+ type="document"
+ base-name="BOURSES_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),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <!-- id is local for etat, and valid only for type=index -->
+ <table
+ type="index"
+ id="T1"
+ base-name="BOURSES_INDEX_VERS"
+ 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,
+ ANNEE INTEGER,
+ ID_VERST VARCHAR(50),
+ PRESTATION VARCHAR(50),
+ DATE_EMISSION DATE,
+ ID_DOSSIER VARCHAR(50),
+ ID_TIERS VARCHAR(30),
+ TYPE_TIERS VARCHAR(2),
+ NAT_ID_TIERS VARCHAR(2),
+ DATE_ID_TIERS DATE,
+ REF_TIERS VARCHAR(30),
+ CAT_TIERS VARCHAR(2),
+ NAT_JUR VARCHAR(2),
+ CIVILITE VARCHAR(10),
+ NOM VARCHAR(100),
+ COMPLEMENT_NOM VARCHAR(50),
+ PRENOM VARCHAR(50),
+ DATE_NAISS DATE,
+ ADR1 VARCHAR(80),
+ ADR2 VARCHAR(80),
+ ADR3 VARCHAR(80),
+ CODE_POSTAL VARCHAR(5),
+ VILLE VARCHAR(80),
+ CODE_RES SMALLINT,
+ CODE_PAYS VARCHAR(3),
+ DATE_ADR DATE,
+ RIB VARCHAR(23),
+ DATE_DECISION DATE,
+ DATE_EFFET_DECISION DATE,
+ DATE_FIN_DECISION DATE,
+ NATURE_DECISION VARCHAR(24),
+ ID_DECISION VARCHAR(50),
+ PERIODICITE_DECISION VARCHAR(100),
+ MONTANT_DECISION DECIMAL(16,3),
+ MONTANT_VERSEMENT DECIMAL(16,3),
+ NUM_ORDRE_SEQUENCE INTEGER,
+ NB_TOTAL_SEQUENCE INTEGER,
+ SERVICE VARCHAR(160),
+ COMMENTAIRE VARCHAR(250),
+ NUM_MANDAT VARCHAR(50),
+ MOIS VARCHAR(2),
+ DATE_LIQUIDATION DATE,
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ <patch from-version="1">
+ <sql>ALTER TABLE ${base-name} MODIFY NUM_MANDAT VARCHAR(50)</sql>
+ <sql>ALTER TABLE ${base-name} MODIFY NATURE_DECISION VARCHAR(24)</sql>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_LIQUIDATION DATE</sql>
+ </patch>
+ </table>
+ <table
+ type="index"
+ id="T3"
+ base-name="BOURSES_INDEX_BENEF"
+ version="1"
+ 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,
+ ID_TIERS VARCHAR(30),
+ TYPE_TIERS VARCHAR(2),
+ NAT_ID_TIERS VARCHAR(2),
+ DATE_ID_TIERS DATE,
+ REF_TIERS VARCHAR(30),
+ CAT_TIERS VARCHAR(2),
+ NAT_JUR VARCHAR(2),
+ CIVILITE VARCHAR(10),
+ NOM VARCHAR(100),
+ COMPLEMENT_NOM VARCHAR(50),
+ PRENOM VARCHAR(50),
+ ID_FAMILLE VARCHAR(50),
+ DATE_NAISS DATE,
+ ADR1 VARCHAR(80),
+ ADR2 VARCHAR(80),
+ ADR3 VARCHAR(80),
+ CODE_POSTAL VARCHAR(5),
+ VILLE VARCHAR(80),
+ CODE_RES SMALLINT,
+ CODE_PAYS VARCHAR(3),
+ DATE_ADR DATE,
+ RIB VARCHAR(23),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+
+ <criteria id="annee" type="1" sql-index-id="S1">
+ <where-clause>${table}.${column}=##VALEUR:annee##</where-clause>
+ </criteria>
+ <criteria id="mois" type="1" sql-index-id="S87">
+ <where-clause>${table}.${column}='##VALEUR:mois##'</where-clause>
+ </criteria>
+ <criteria id="id_verst" type="1" sql-index-id="S5">
+ <where-clause>fn:string-compare(${table}.${column},id_verst)</where-clause>
+ </criteria>
+ <criteria id="nom_benef" type="1" sql-index-id="S2">
+ <where-clause>fn:string-compare(${table}.${column},nom_benef)</where-clause>
+ </criteria>
+ <criteria id="prenom_benef" type="1" sql-index-id="S57">
+ <where-clause>fn:string-compare(${table}.${column},prenom_benef)</where-clause>
+ </criteria>
+ <criteria id="nom_dest" type="1" sql-index-id="S3">
+ <where-clause>fn:string-compare(${table}.${column},nom_dest)</where-clause>
+ </criteria>
+ <criteria id="code_prestation" type="1" sql-index-id="S6">
+ <where-clause>fn:string-compare(${table}.${column},code_prestation)</where-clause>
+ </criteria>
+ <criteria id="prestation" type="1" sql-index-id="S6">
+ <where-clause>${table}.${column}='##VALEUR:prestation##'</where-clause>
+ </criteria>
+ <criteria id="id_doss" type="1" sql-index-id="S4">
+ <where-clause>fn:string-compare(${table}.${column},id_doss)</where-clause>
+ </criteria>
+ <criteria id="id_tiers_dest" type="1" sql-index-id="S7">
+ <where-clause>fn:string-compare(${table}.${column},id_tiers_dest)</where-clause>
+ </criteria>
+ <criteria id="type_tiers_dest" type="1" sql-index-id="S9">
+ <where-clause>fn:string-compare(${table}.${column},type_tiers_dest)</where-clause>
+ </criteria>
+ <criteria id="ref_tiers_dest" type="1" sql-index-id="S12">
+ <where-clause>fn:string-compare(${table}.${column},ref_tiers_dest)</where-clause>
+ </criteria>
+ <criteria id="cat_tiers_dest" type="1" sql-index-id="S13">
+ <where-clause>${table}.${column}='##VALEUR:cat_tiers_value##'</where-clause>
+ </criteria>
+ <criteria id="adr_dest" type="1" sql-index-id="S19">
+ <where-clause>fn:string-compare(${table}.${column},adr_dest)</where-clause>
+ </criteria>
+ <criteria id="cp_dest" type="1" sql-index-id="S22">
+ <where-clause>fn:string-compare(${table}.${column},cp_dest)</where-clause>
+ </criteria>
+ <criteria id="ville_dest" type="1" sql-index-id="S23">
+ <where-clause>fn:string-compare(${table}.${column},ville_dest)</where-clause>
+ </criteria>
+ <criteria id="date_decision" type="1" sql-index-id="S28">
+ <where-clause>fn:date-compare(${table}.${column},date_decision)</where-clause>
+ </criteria>
+ <criteria id="date_effet_decision" type="1" sql-index-id="S29">
+ <where-clause>fn:date-compare(${table}.${column},date_effet_decision)</where-clause>
+ </criteria>
+ <criteria id="date_fin_decision" type="1" sql-index-id="S30">
+ <where-clause>fn:date-compare(${table}.${column},date_fin_decision)</where-clause>
+ </criteria>
+ <criteria id="nature_decision" type="1" sql-index-id="S31">
+ <where-clause>${table}.${column}='##VALEUR:nature_decision##'</where-clause>
+ </criteria>
+<!--
+ <criteria id="existence_pj" sql-index-id="S44">
+ <where-clause>${table}.${column} IS NOT NULL</where-clause>
+ </criteria>
+-->
+ <criteria id="service" type="1" sql-index-id="S38">
+ <where-clause>fn:string-compare(${table}.${column},service)</where-clause>
+ </criteria>
+ <criteria id="id_tiers_benef" type="1" sql-index-id="S47">
+ <where-clause>fn:string-compare(${table}.${column},id_tiers_benef)</where-clause>
+ </criteria>
+ <criteria id="rib_verst" type="1" sql-index-id="S67">
+ <where-clause>fn:string-compare(${table}.${column},rib_verst)</where-clause>
+ </criteria>
+ <criteria id="type_tiers_benef" type="1" sql-index-id="S49">
+ <where-clause>fn:string-compare(${table}.${column},type_tiers_benef)</where-clause>
+ </criteria>
+ <criteria id="ref_tiers_benef" type="1" sql-index-id="S52">
+ <where-clause>fn:string-compare(${table}.${column},ref_tiers_benef)</where-clause>
+ </criteria>
+ <criteria id="cat_tiers_benef" type="1" sql-index-id="S53">
+ <where-clause>${table}.${column}='##VALEUR:cat_tiers_value##'</where-clause>
+ </criteria>
+ <criteria id="adr_benef" type="1" sql-index-id="S59">
+ <where-clause>fn:string-compare(${table}.${column},adr_benef)</where-clause>
+ </criteria>
+ <criteria id="cp_benef" type="1" sql-index-id="S62">
+ <where-clause>fn:string-compare(${table}.${column},cp_benef)</where-clause>
+ </criteria>
+ <criteria id="ville_benef" type="1" sql-index-id="S63">
+ <where-clause>fn:string-compare(${table}.${column},ville_benef)</where-clause>
+ </criteria>
+ <criteria id="decision_id" sql-index-id="S32">
+ <where-clause>fn:string-compare(${table}.${column},decision_id)</where-clause>
+ </criteria>
+ <criteria id="DP" sql-index-id="S40">
+ <where-clause>fn:string-compare(${table}.${column},DP)</where-clause>
+ </criteria>
+ <criteria id="nature" sql-index-id="S41">
+ <where-clause>${table}.${column}='##VALEUR:nature##'</where-clause>
+ </criteria>
+ <criteria id="budget" sql-index-id="S42">
+ <where-clause>${table}.${column}='##VALEUR:budget##'</where-clause>
+ </criteria>
+ <criteria id="fonction" sql-index-id="S43">
+ <where-clause>fn:string-compare(${table}.${column},fonction)</where-clause>
+ </criteria>
+ <criteria id="benef_famille" sql-index-id="S83">
+ <where-clause>fn:string-compare(${table}.${column},benef_famille)</where-clause>
+ </criteria>
+ <criteria id="benef_date_naiss" sql-index-id="S58">
+ <where-clause>fn:date-compare(${table}.${column},naissance)</where-clause>
+ </criteria>
+ <criteria id="date_verst" sql-index-id="S69">
+ <where-clause>fn:date-compare(${table}.${column},date_verst)</where-clause>
+ </criteria>
+ <criteria id="mt_verst" sql-index-id="S35">
+ <where-clause>${table}.${column}##OPERATEUR:mt####VALEUR:mt##</where-clause>
+ </criteria>
+ <criteria id="mt_decision" sql-index-id="S34">
+ <where-clause>${table}.${column}##OPERATEUR:mt####VALEUR:mt##</where-clause>
+ </criteria>
+ <criteria id="comment" sql-index-id="S39">
+ <where-clause>fn:string-compare(${table}.${column},comment)</where-clause>
+ </criteria>
+ <criteria id="date_liquidation" type="1" sql-index-id="S88">
+ <where-clause>fn:date-compare(${table}.${column},date_liquidation)</where-clause>
+ </criteria>
+
+ <sql-index
+ id="S1"
+ path="/n:Bourses/n:Annee/@V"
+ datatype="integer"
+ column="ANNEE"
+ table="T1"/>
+ <sql-index
+ id="S2"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:Nom/@V"
+ datatype="string"
+ format="uppercase"
+ column="NOM"
+ table="T3"/>
+ <sql-index
+ id="S2bis"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire[1]/n:InfoTiers/n:Nom/@V"
+ datatype="string"
+ format="uppercase"
+ column="NOM"
+ table="T3"/>
+ <sql-index
+ id="S3"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:Nom/@V"
+ datatype="string"
+ format="uppercase"
+ column="NOM"
+ table="T1"/>
+ <sql-index
+ id="S4"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:IdDossier/@V"
+ datatype="string"
+ column="ID_DOSSIER"
+ table="T1"/>
+ <sql-index
+ id="S5"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:IdVerst/@V"
+ datatype="string"
+ column="ID_VERST"
+ table="T1"/>
+ <sql-index
+ id="S6"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Prestation/@V"
+ datatype="string"
+ column="PRESTATION"
+ format="uppercase"
+ table="T1"/>
+ <sql-index
+ id="S7"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:IdTiers/@V"
+ datatype="string"
+ column="ID_TIERS"
+ format="uppercase"
+ table="T1"/>
+ <sql-index
+ id="S8"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:DteMalade/@V"
+ datatype="date"
+ column="DATE_MALADE"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+ <sql-index
+ id="S9"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:TypTiers/@V"
+ datatype="string"
+ column="TYPE_TIERS"
+ format="uppercase"
+ table="T1"/>
+ <sql-index
+ id="S10"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:NatIdTiers/@V"
+ datatype="string"
+ column="NAT_ID_TIERS"
+ table="T1"/>
+ <sql-index
+ id="S11"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:DteIdTiers/@V"
+ datatype="date"
+ column="DATE_ID_TIERS"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+
+ <sql-index
+ id="S12"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:RefTiers/@V"
+ datatype="string"
+ column="REF_TIERS"
+ table="T1"/>
+
+ <sql-index
+ id="S13"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:CatTiers/@V"
+ datatype="string"
+ column="CAT_TIERS"
+ table="T1"/>
+
+ <sql-index
+ id="S14"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:NatJur/@V"
+ datatype="string"
+ column="NAT_JUR"
+ table="T1"/>
+
+ <sql-index
+ id="S15"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:Civilite/@V"
+ datatype="string"
+ column="CIVILITE"
+ table="T1"/>
+
+ <sql-index
+ id="S16"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:ComplNom/@V"
+ datatype="string"
+ column="COMPLEMENT_NOM"
+ table="T1"/>
+
+ <sql-index
+ id="S17"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:InfoTiers/n:Prenom/@V"
+ datatype="string"
+ column="PRENOM"
+ table="T1"/>
+
+ <sql-index
+ id="S18"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:DateNaissance/@V"
+ datatype="date"
+ column="DATE_NAISS"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+
+ <sql-index
+ id="S19"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:Adr1/@V"
+ datatype="string"
+ column="ADR1"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S20"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:Adr2/@V"
+ datatype="string"
+ column="ADR2"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S21"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:Adr3/@V"
+ datatype="string"
+ column="ADR3"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S22"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:CP/@V"
+ datatype="string"
+ column="CODE_POSTAL"
+ table="T1"/>
+
+ <sql-index
+ id="S23"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:Ville/@V"
+ datatype="string"
+ column="VILLE"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S24"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:CodeRes/@V"
+ datatype="boolean"
+ column="CODE_RES"
+ table="T1"/>
+
+ <sql-index
+ id="S25"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:CodePays/@V"
+ datatype="string"
+ column="CODE_PAYS"
+ table="T1"/>
+
+ <sql-index
+ id="S26"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Destinataire/n:Adresse/n:DteAdr/@V"
+ datatype="date"
+ column="DATE_ADR"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+
+ <sql-index
+ id="S28"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:Date/@V"
+ datatype="date"
+ column="DATE_DECISION"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+
+ <sql-index
+ id="S29"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:DateEffet/@V"
+ datatype="date"
+ column="DATE_EFFET_DECISION"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+
+ <sql-index
+ id="S30"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:DateFin/@V"
+ datatype="date"
+ column="DATE_FIN_DECISION"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T1"/>
+
+ <sql-index
+ id="S31"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:Nature/@V"
+ datatype="string"
+ column="NATURE_DECISION"
+ table="T1"/>
+
+ <sql-index
+ id="S32"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:IdDecision/@V"
+ datatype="string"
+ column="ID_DECISION"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S33"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:Periodicite/@V"
+ datatype="string"
+ column="PERIODICITE_DECISION"
+ table="T1"/>
+
+ <sql-index
+ id="S34"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Decision/n:Mt/@V"
+ datatype="decimal"
+ column="MONTANT_DECISION"
+ table="T1"/>
+
+ <sql-index
+ id="S35"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Mt/@V"
+ datatype="decimal"
+ column="MONTANT_VERSEMENT"
+ table="T1"/>
+
+ <sql-index
+ id="S38"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Service/@V"
+ datatype="string"
+ column="SERVICE"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S39"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Commentaire/@V"
+ datatype="string"
+ column="COMMENTAIRE"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S40"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:NumDP/@V"
+ datatype="string"
+ column="NUM_MANDAT"
+ format="uppercase"
+ table="T1"/>
+
+ <sql-index
+ id="S41"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:CodeNature/@V"
+ datatype="string"
+ column="CODE_NATURE"
+ table="T1"/>
+
+ <sql-index
+ id="S42"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Code_Budget/@V"
+ datatype="string"
+ column="CODE_BUDGET"
+ table="T1"/>
+
+ <sql-index
+ id="S43"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:CodeFonction/@V"
+ datatype="string"
+ column="CODE_FONCTION"
+ table="T1"/>
+
+ <sql-index
+ id="S47"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:IdTiers/@V"
+ datatype="string"
+ column="ID_TIERS"
+ format="uppercase"
+ table="T3"/>
+ <sql-index
+ id="S49"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:TypTiers/@V"
+ datatype="string"
+ column="TYPE_TIERS"
+ format="uppercase"
+ table="T3"/>
+ <sql-index
+ id="S50"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:NatIdTiers/@V"
+ datatype="string"
+ column="NAT_ID_TIERS"
+ format="uppercase"
+ table="T3"/>
+ <sql-index
+ id="S51"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:DteIdTiers/@V"
+ datatype="date"
+ column="DATE_ID_TIERS"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T3"/>
+
+ <sql-index
+ id="S52"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:RefTiers/@V"
+ datatype="string"
+ column="REF_TIERS"
+ table="T3"/>
+
+ <sql-index
+ id="S53"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:CatTiers/@V"
+ datatype="string"
+ column="CAT_TIERS"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S54"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:NatJur/@V"
+ datatype="string"
+ column="NAT_JUR"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S55"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:Civilite/@V"
+ datatype="string"
+ column="CIVILITE"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S56"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:ComplNom/@V"
+ datatype="string"
+ column="COMPLEMENT_NOM"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S57"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:InfoTiers/n:Prenom/@V"
+ datatype="string"
+ column="PRENOM"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S58"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:DateNaissance/@V"
+ datatype="date"
+ column="DATE_NAISS"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T3"/>
+
+ <sql-index
+ id="S59"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:Adr1/@V"
+ datatype="string"
+ column="ADR1"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S60"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:Adr2/@V"
+ datatype="string"
+ column="ADR2"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S61"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:Adr3/@V"
+ datatype="string"
+ column="ADR3"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S62"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:CP/@V"
+ datatype="string"
+ column="CODE_POSTAL"
+ table="T3"/>
+
+ <sql-index
+ id="S63"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:Ville/@V"
+ datatype="string"
+ column="VILLE"
+ format="uppercase"
+ table="T3"/>
+
+ <sql-index
+ id="S64"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:CodeRes/@V"
+ datatype="boolean"
+ column="CODE_RES"
+ table="T3"/>
+
+ <sql-index
+ id="S65"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:CodePays/@V"
+ datatype="string"
+ column="CODE_PAYS"
+ table="T3"/>
+
+ <sql-index
+ id="S66"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Beneficiaire/n:Adresse/n:DteAdr/@V"
+ datatype="date"
+ column="DATE_ADR"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ table="T3"/>
+
+ <sql-index
+ id="S67"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:CpteBancaire/@rib"
+ datatype="string"
+ column="RIB"
+ table="T1"/>
+ <sql-index
+ id="S69"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Date/@V"
+ datatype="date"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ column="DATE_EMISSION"
+ table="T1"/>
+
+ <sql-index
+ id="S87"
+ path="/n:Bourses/n:DonneesVersement/n:Versement/n:Mois/@V"
+ datatype="string"
+ column="MOIS"
+ table="T1"/>
+
+ <sql-index
+ id="S88"
+ path="/n:Bourses/n:Date/@V"
+ datatype="date"
+ format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"
+ column="DATE_LIQUIDATION"
+ table="T1"/>
+
+ </etat>
+ </document>
+ </layer>
+</persistence-config>