1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| RSA:
LOAD FINESS & '-' & index_RSA as Id_RSA,
FINESS as rsaEtab,
mode_entree,
provenance_entree,
mois_sortie as RSA_mois_sortie,
annee_sortie as RSA_annee_sortie,
index_RUM_DP,
'DR' as rsaNature, // on stocke la nature des codes DR
DR as rsaCode;
SQL SELECT
* FROM RSA;
JOIN LOAD FINESS AS rsaEtab,
Raison_sociale AS rsaRaisSoc
resident Etablissements;
JOIN LOAD
Code as rsaCode,
Libelle_court as rsaLibCode
resident THS_CIM10;
// ########## CREATION DE LA TABLE DE FAIT RUM ###################
RUM:
LOAD
FINESS & '-' & index_RSA & '-' & index_RUM AS Id_RUM, // on garde un id_rum pour faire des stats sur le nombre de rum
FINESS & '-' & index_RSA AS Id_RSA, // on garde le meme id_RSA que celui du load de la table rsa. il servira a compter le nombre de RSA et associer les RSA correspondants au RUM
FINESS as rumEtab,
index_RUM,
'DP' as rumNature,
DP as rumCode,
IGS2,
Nb_DAS as rumNb_DAS,
Nb_actes as rumNb_actes,
duree_sejour as dureeSejour
;
SQL SELECT
* FROM RUM;
JOIN LOAD FINESS AS rumEtab,
Raison_sociale AS rumRaisSoc
resident Etablissements;
JOIN LOAD Code AS rumCode,
Libelle_court AS rumLibCode
resident THS_CIM10; |
Partager