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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
| FAIT_HOSPIT:
LOAD
FINESS & '-' & index_RSA as Id_sejour,
FINESS & '-' & index_RSA & '-' & index_RUM AS Id_RUM,
FINESS,
Vers_RSA,
index_RSA,
Vers_RSS,
Num_sequentiel_tarifs,
Vers_Classif_RSS,
GHM_RSS,
Ctrl_GHM_RSS,
Vers_Classif_RSA,
GHM_RSA as GHM,
Ctrl_GHM_RSA,
Nb_RUM,
age_annee,
age_jour,
sexe,
mode_entree,
provenance_entree,
mois_sortie,
annee_sortie,
mode_sortie,
destination,
type_sejour,
duree_sejour,
code_Geo,
poids_entree,
age_gestationnel,
delai_date_regles_date_entree,
Nb_seances,
GHS,
Nb_journees_ExH,
type_sejour_ExB,
Nb_journees_ExB,
forfait_dialyse,
TOP_UHCD,
confirmation_codage,
Nb_Supp_hemodialyse,
Nb_Supp_Entr_dialyse_Auto,
Nb_Supp_Entr_dialyse_Ambu,
Nb_Supp_Entr_hemodialyse,
Nb_actes_GHS_9615,
Nb_Rdth,
filler,
Nb_Supp_caisson_hyperbare,
type_prelevement_organe,
Nb_Supp_REA,
Nb_Supp_SI_REA,
Nb_Supp_STF,
Nb_Supp_SRC,
Nb_Supp_NN1,
Nb_Supp_NN2,
Nb_Supp_NN3,
Nb_Supp_REP,
passage_lit_soins_palliatifs,
Type_radiotherapie,
type_dosimetrie,
Num_innovation,
Nb_faisceaux,
index_RUM_DP,
'DR' as Nature, // On stocke la nature des codes DR
DR as Code,
Nb_DAS,
Nb_actes,
'RSA' as type_hospit;
SQL SELECT
* FROM RSA;
Concatenate (FAIT_HOSPIT)
LOAD
FINESS & '-' & index_RSA AS Id_sejour,
FINESS & '-' & index_RSA & '-' & index_RUM AS Id_RUM,
FINESS,
index_RSA,
index_RUM,
'RSA' as type_hospit,
'DAS' as Nature,
DAS as Code;
SQL SELECT * FROM DAS; |
Partager