You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
99 lines
4.7 KiB
99 lines
4.7 KiB
-- =====================================================================
|
|
-- Divers traitements sur les données avant l'installation des données
|
|
-- =====================================================================
|
|
|
|
-- Suppression de listes
|
|
-- Le contenu des listes est supprimé dans dbsetup si la liste n'existe plus et qu'elle provient de cti
|
|
DELETE FROM pmsi.t_listes
|
|
WHERE t_listes.code IN ( 'CTI_SRC11_71A',
|
|
'CTI_SRC11_82A',
|
|
'CTI_SRC12_18D',
|
|
'CTI_SRC12_19D',
|
|
'CTI_SRC12_25A',
|
|
'CTI_SRC13_81A',
|
|
'CTI_SRC13_81D',
|
|
'CTI_SRC13_82A',
|
|
'CTI_SRC13_83A',
|
|
'CTI_SRC13_83D',
|
|
'CTI_SRC14_81A',
|
|
'CTI_SRC14_81D',
|
|
'CTI_SRC14_82A',
|
|
'CTI_SRC14_83A',
|
|
'CTI_SRC14_83D',
|
|
'CTI_SRC15_81A',
|
|
'CTI_SRC15_81D',
|
|
'CTI_SRC15_82A',
|
|
'CTI_SRC15_83A',
|
|
'CTI_SRC15_83D',
|
|
'CTI_SRC17_82A',
|
|
'CTI_SRC17_83D',
|
|
'OLD_CTI_CARDIO_ABLATION_ATR_DROITE_ACTES_2022',
|
|
'OLD_CTI_CARDIO_ABLATION_ATR_TRANS_ACTES_2022',
|
|
'OLD_CTI_CARDIO_ABLATION_ATR_TRANS_ACTES_HS_2022',
|
|
'OLD_CTI_CARDIO_ANOMALIES_CLOISONNEMENT_ACTES_2022',
|
|
'OLD_CTI_CARDIO_CONG_A_ADULTE_ACTES_2022',
|
|
'OLD_CTI_CARDIO_CONG_B_ADULTE_ACTES_2022',
|
|
'OLD_CTI_CARDIO_CONG_B_ENF_ACTES_2022',
|
|
'OLD_CTI_CARDIO_DEFIBR_MULTI_ACTES_2022',
|
|
'OLD_CTI_CARDIO_DEFIBR_MULTI_ACTES_HS_2022',
|
|
'OLD_CTI_CARDIO_DILATATION_ACTES_2022',
|
|
'OLD_CTI_CARDIO_DILATATION_ENF_ACTES_2022',
|
|
'OLD_CTI_CARDIO_DILATATION_STENOSE_ACTES_2022',
|
|
'OLD_CTI_CARDIO_ELECTRO_ACTES_2022',
|
|
'OLD_CTI_CARDIO_FERMETURE_ARTERIEL_ACTES_2022',
|
|
'OLD_CTI_CARDIO_FERM_SEPTUM_ACTES_2022',
|
|
'OLD_CTI_CARDIO_ISCHEMIQUES_ACTES_2022',
|
|
'OLD_CTI_CARDIO_ISCHEMIQUES_ACTES_HS_2022',
|
|
'OLD_CTI_CARDIO_MAKER_MONO_DOUBLE_ACTES_2022',
|
|
'OLD_CTI_CARDIO_POSE_STENT_ACTES_2022',
|
|
'OLD_CTI_CARDIO_POSE_STENT_ENF_ACTES_2022',
|
|
'OLD_CTI_CARDIO_RISQUE_PLAIE_ACTES_HS_2022',
|
|
'OLD_CTI_CARDIO_SEPTUM_ACTES_2022',
|
|
'CTI_FFM24_ANNEXE10',
|
|
'CTI_FFM15_15A',
|
|
'CTI_AFFM',
|
|
'CTI_DR12_1L',
|
|
'CTI_DR12_1U',
|
|
'CTI_DR13_1L',
|
|
'CTI_DR13_1U',
|
|
'CTI_DR14_1L',
|
|
'CTI_DR14_1U',
|
|
'CTI_DR15_1L',
|
|
'CTI_DR15_1U',
|
|
'CTI_DR16_1L',
|
|
'CTI_DR16_1U',
|
|
'CTI_DR17_1L',
|
|
'CTI_DR17_1U',
|
|
'CTI_DR18_1L',
|
|
'CTI_DR18_1U',
|
|
'CTI_DR19_1L',
|
|
'CTI_DR19_1U',
|
|
'CTI_DR20_1L',
|
|
'CTI_DR20_1U',
|
|
'CTI_DR22_1L',
|
|
'CTI_DR22_1U',
|
|
'CTI_CMA2018_2',
|
|
'CTI_CMA2018_234',
|
|
'CTI_CMA2018_3',
|
|
'CTI_CMA2018_4'
|
|
'CTI_DR22_1U',
|
|
'CTI_SE112_10A',
|
|
'CTI_SE115_10A',
|
|
'CTI_SE117_10A',
|
|
'CTI_SE119_10A',
|
|
'CTI_SE212_13A',
|
|
'CTI_SE213_13A',
|
|
'CTI_SE215_13A',
|
|
'CTI_SE216_13A',
|
|
'CTI_SE217_13A',
|
|
'CTI_SE218_13A',
|
|
'CTI_SE312_11A',
|
|
'CTI_SE315_11A',
|
|
'CTI_SE316_11A',
|
|
'CTI_SE317_11A',
|
|
'CTI_SE412_14A',
|
|
'CTI_SE415_14A',
|
|
'CTI_SE517_99A',
|
|
'CTI_SE518_99A',
|
|
'CTI_SE618_99A'
|
|
);
|