Domaine 'Procedure' - DCIR

Variables et tables utilisées dans le SNDS

_ER_CAM_F

• etb_pre_fin
• dcir_visit_id
• quantity
• cam_prs_ide

Règles de transformation

Champ	Règle	Jointure		Filtre
		Gauche	Droite
id*	hash(source_value)
person_id*	person_id de VISIT_OCCURRENCE	_ER_CAM_F ‘dciraa’ || ‘_’ || etb_pre_fin || dcir_visit_id	VISIT_OCCURRENCE visit_occurrence_source_value
start_date*	visit_start_date de VISIT_OCCURRENCE	_ER_CAM_F ‘dciraa’ || ‘_’ || etb_pre_fin || dcir_visit_id	VISIT_OCCURRENCE visit_occurrence_source_value
start_datetime	start_date + ‘00:00:00’
end_date	visit_end_date de VISIT_OCCURRENCE	_ER_CAM_F ‘dciraa’ || ‘_’ || etb_pre_fin || dcir_visit_id	VISIT_OCCURRENCE visit_occurrence_source_value
end_datetime	end_date + ‘00:00:00’
type_concept_id*	32810
status_concept_id	0
quantity	quantity de _ER_CAM_F
provider_id	provider_id de VISIT_OCCURRENCE	_ER_CAM_F ‘dciraa’ || ‘_’ || etb_pre_fin || dcir_visit_id	VISIT_OCCURRENCE visit_occurrence_source_value
visit_occurrence_id	visit_occurrence_id de VISIT_OCCURRENCE	_ER_CAM_F ‘dciraa’ || ‘_’ || etb_pre_fin || dcir_visit_id	VISIT_OCCURRENCE visit_occurrence_source_value
source_value	cam_prs_ide de _ER_CAM_F
source_concept_id	source_concept_id de SOURCE_TO_CONCEPT_MAP	_ER_CAM_F cam_prs_ide	SOURCE_TO_CONCEPT_MAP source_code	source_vocabulary_id = ‘CCAM’ ou source_vocabulary_id = ‘CSARR’
concept_id*	concept_id de SOURCE_TO_CONCEPT_MAP	_ER_CAM_F cam_prs_ide	SOURCE_TO_CONCEPT_MAP source_code	source_vocabulary_id = ‘CCAM’ ou source_vocabulary_id = ‘CSARR’
status_source_value	null
domain_id	domain_id provenant de CONCEPT (2 jointures) Si la jointure avec CONCEPT n’existe pas, mettre ‘Procedure’	Jointure 1: _ER_CAM_F cam_prs_ide Jointure 2: SOURCE_TO_CONCEPT_MAP concept_id	Jointure 1: SOURCE_TO_CONCEPT_MAP source_code Jointure2: CONCEPT concept_id

Domaine 'Procedure' - PMSI

Tables et variables utilisées dans le SNDS

T_MCOaaA : ent_dat_del nbr_exe_act cdc_act pha_act eta_num rsa_num	T_SSRaaCCAM : ccam_del_ent_um ccam_act ccam_pha_act eta_num rha_num	T_HADaaA : del_deb_sseq ccam_cod pha_cod eta_num_epmsi rhad_num	T_SSRaaFMSTC : del_dat_ent ccam_cod pha_act eta_num seq_num
T_SSRaaCSARR : ent_dat_del_um csarr_cod pha_act eta_num rhad_num	T_MCOaaFMSTC : del_dat_ent ccam_cod pha_act eta_num seq_num	T_RIPaaCCAM : ent_dat_del nbr_exe_act cdc_act pha_act eta_num_epmsi rip_num

Règles de transformation

Champ	Règle	Jointure		Filtre
		Gauche	Droite
id*	hash(source_value)
person_id*	person_id de VISIT_OCCURRENCE	cf visit_occurrence_id
start_date*	visit_start_date de VISIT_OCCURRENCE + nombre de jours écoulés entre le début de la visite et l’événement : T_MCOaaA : ent_dat_del T_SSRaaCCAM : ccam_del_ent_um T_RIPaaCCAM : ent_dat_del T_HADaaA : del_deb_sseq T_SSRaaFMSTC : 0 T_SSRaaCSARR : ent_dat_del_um T_MCOaaFMSTC : del_dat_ent	cf visit_occurrence_id
start_datetime	start_date + ‘00:00:00’
end_date	visit_start_date de VISIT_OCCURRENCE	cf visit_occurrence_id
end_datetime	end_date + ‘00:00:00’
type_concept_id*	32810
status_concept_id	0
quantity	T_MCOaaA : nbr_exe_act T_SSRaaCCAM : ccam_nbr_rea T_RIPaaCCAM : nbr_exe_act T_HADaaA : 1 T_SSRaaFMSTC : 1 T_SSRaaCSARR : nbr_csarr T_MCOaaFMSTC : 1
provider_id	provider_id de VISIT_OCCURRENCE	cf visit_occurrence_id
visit_occurrence_id	visit_occurrence_id de VISIT_OCCURRENCE	T_MCOaaA ‘mcoaa’ || ‘_’ || eta_num || ‘_’ || rsa_num T_SSRaaCCAM ‘ssr’ || ‘_’ || eta_num || ‘_’ || rha_num T_RIPaaCCAM ‘ripaa’ || ‘_’ || eta_num_epmsi || ’_’ || rip_num T_HADaaA ‘hadaa’ || ‘_’ || eta_num_epmsi || ‘_’ || rhad_num T_SSRaaFMSTC ‘ssraaace’ || ‘_’ || eta_num || ‘_’ || seq_num T_SSRaaCSARR ‘ssr’ || ‘_’ || eta_num || ‘_’ || rha_num T_MCOaaFMSTC ‘mcoaaace’ || ‘_’ || eta_num || ‘_’ || seq_num	VISIT_ OCCURRENCE visit_occurrence_source_value
visit_detail_id	visit_detail_id de VISIT_DETAIL	T_MCOaaA ‘mcoaa’ || ‘_’ || eta_num || ‘_’ || rsa_num del_dat_ent	VISIT_DETAIL visit_occurrence_id >visit_detail_start_date and < visit_detail_end_date
source_value	T_MCOaaA : cdc_act T_SSRaaCCAM : ccam_act T_RIPaaCCAM : cdc_act T_HADaaA : ccam_cod T_SSRaaFMSTC : ccam_cod T_SSRaaCSARR : csarr_cod T_MCOaaFMSTC : ccam_cod			T_MCOaaA : ph_act = 0 ou 1 T_SSRaaCCAM : ccam_pha_act = 0 ou 1 T_RIPaaCCAM : pha_act = 0 ou 1 T_HADaaA : pha_cod = 0 ou 1 T_SSRaaFMSTC : pha_act = 0 ou 1 T_MCOaaFMSTC : pha_act = 0 ou 1
source_concept_id	source_concept_id de SOURCE_TO_CONCEPT_MAP	T_MCOaaA : cdc_act T_SSRaaCCAM : ccam_act T_RIPaaCCAM : cdc_act T_HADaaA : ccam_cod T_SSRaaFMSTC : ccam_cod T_SSRaaCSARR : csarr_cod T_MCOaaFMSTC : ccam_cod	SOURCE_TO_ CONCEPT_MAP source_code	source_vocabulary_id = ‘CCAM’ et source_vocabulary_id = ‘CSARR’
concept_id*	concept_id de SOURCE_TO_CONCEPT_MAP	cf jointure source_concept_id		source_vocabulary_id = ‘CCAM’ et source_vocabulary_id = ‘CSARR’
domain_id	domain_id provenant de CONCEPT Si la jointure avec CONCEPT n’existe pas, mettre ‘Procedure’	Jointure 1: T_MCOaaA : cdc_act T_SSRaaCCAM : ccam_act T_RIPaaCCAM : cdc_act T_HADaaA : ccam_cod T_SSRaaFMSTC : ccam_cod T_SSRaaCSARR : csarr_cod T_MCOaaFMSTC : ccam_cod Jointure 2: SOURCE_TO_CONCEPT_MAP concept_id	Jointure 1: SOURCE_TO_ CONCEPT_MAP source_code Jointure 2: CONCEPT concept_id	source_vocabulary_id = ‘CCAM’ et source_vocabulary_id = ‘CSARR’

Accéder au code source

Le code source est disponible sur le dépôt Gitlab suivant (opens new window)