createTableIndexPatch=\
begin \
execute immediate 'CREATE TABLE INDEX_PATCH_2012 ( \
- IND_ANNEE_GEST VARCHAR(2) not null, \
+ IND_ANNEE_GEST VARCHAR(4) not null, \
IND_TRI_GEST VARCHAR(1) not null, \
IND_COMPTABLE VARCHAR(6) not null, \
IND_IMPUTATION VARCHAR(1) not null, \
- IND_MINISTERE VARCHAR(2) not null, \
+ IND_MINISTERE VARCHAR(5) not null, \
IND_COMPTESPE VARCHAR(5) not null, \
IND_LOCALE VARCHAR(4) not null, \
- IND_ANNEE_TRSP VARCHAR(2) not null, \
+ IND_ANNEE_TRSP VARCHAR(4) not null, \
IND_TRI_TRSP VARCHAR(1) not null, \
IND_SECTION_BUDG VARCHAR(2), \
IND_CPTESPENAT VARCHAR(5) not null, \
SELECT \
edmn.COMPTABLE, \
edmn.IMPUTATION, \
- edmn.MINISTERE, \
- edmn.ANNEE_BUDG, \
+ edmn.MINISTEREBUDGETAIRE, \
+ edmn.ANNEE, \
edmn.TRIMESTRE, \
- edmn.NUM_LIASSE_DEB, \
- edmn.NUM_LIASSE_FIN \
+ edmn.NUMLIASSEDEB, \
+ edmn.NUMLIASSEFIN \
FROM EDMN_2012_ETAT edmn \
WHERE edmn.COLLECTIVITE = ? \
AND edmn.BUDGET = ? \