Domaine 'Device exposure' - DCIR

Tables et variables du SNDS utilisées

• _ER_TIP_F
  • etb_pre_fin
  • dcir_visit_id
  • tip_acl_dtd
  • tip_prs_typ
  • tip_acl_dtf
  • tip_prs_ide

Règles de transformation

Variables	Règles	Gauche	Droite	Filtre
id*	hash (source_value)
visit_occurrence_id	visit_occurrence_id de VISIT_OCCURRENCE	_ER_TIP_F ‘dciraa’ || ‘_’ || etb_pre_fin || dcir_visit_id	VISIT_OCCURRENCE visit_occurrence_source_value
person_id*	person_id de VISIT_OCCURRENCE	cf jointure pour visit_occurrence_id
start_date*	tip_acl_dtd de _ER_TIP_F
start_datetime	start_date + ‘00:00:00’
end_date	Si la prestation concerne un achat : tip_prs_typ = 1 : null Sinon :tip_acl_dtf	cf jointure pour visit_occurrence_id
end_datetime	end_date + ‘00:00:00’
type_concept_id*	32810
provider_id	provider_id de VISIT_OCCURRENCE	cf jointure pour visit_occurrence_id
source_value	typ_prs_ide de _ER_TIP_F			typ_prs_ide != ‘9999999999999’
source_concept_id	source_concept_id de SOURCE_TO_CONCEPT_MAP	_ER_TIP_F typ_prs_ide	SOURCE_TO_CONCEPT_MAP source_code	source_vocabulary_id = ‘LPP’
concept_id*	concept_id de SOURCE_TO_CONCEPT_MAP	_ER_TIP_F typ_prs_ide	SOURCE_TO_CONCEPT_MAP source_code	source_vocabulary_id = ‘LPP’
domain_id	domain_id de CONCEPT s’il existe Sinon ‘Device’	_ER_TIP_F typ_prs_ide Jointure 2: SOURCE_TO_CONCEPT_MAP concept_id	SOURCE_TO_CONCEPT_MAP source_code Jointure 2: CONCEPT concept_id	source_vocabulary_id = ‘LPP’
quantity	quantity de _ER_TIP_F

Domaine 'Device exposure' - PMSI

Tables et variables utilisées dans le SNDS

• T_MCOaaDMIP
• T_MCOaaFPSTC
• T_SSRaaFPSTC (à partir de 2020)

Règles de transformation

Variables	Règles	Jointures		Filtres
		Gauche	Droite
id*	hash (source_value)
visit_occurrence_id	visit_occurrence_id de VISIT_OCCURRENCE	T_MCOaaDMIP ‘mcoaa’ || ‘_’ || eta_num || ‘_’ || rsa_num T_MCOaaFPSTC ‘mcoaaace’ || ‘_’ || eta_num || ‘_’ || seq_num T_SSRaaFPSTC ‘ssrace’ || ‘_’ || eta_num || ‘_’ || seq_num	VISIT_OCCURRENCE visit_occurrence_source_value
person_id*	person_id de VISIT_OCCURRENCE	cf jointure pour visit_occurrence_id
start_date*	visit_start_date de VISIT_OCCURRENCE + : Pour T_MCOaaDMIP : delai Pour T_MCOaaFPSTC : del_dat_ent Pour T_SSRaaFPSTC : del_dat_ent	cf jointure pour visit_occurrence_id
start_datetime	start_date + ‘00:00:00’
end_date	null
end_datetime	end_date + ‘00:00:00’
type_concept_id*	32810
provider_id	provider_id de VISIT_OCCURRENCE	cf jointure pour visit_occurrence_id
source_value	T_MCOaaDMIP : lpp_cod T_MCOaaFPSTC : lpp_cod T_SSRaaFPSTC : lpp_cod
source_concept_id	source_concept_id de SOURCE_TO_CONCEPT_MAP	T_MCOaaDMIP lpp_cod T_MCOaaFPSTC lpp_cod	SOURCE_TO_CONCEPT_MAP source_code	source_vocabulary_id = ‘LPP’
concept_id*	concept_id de SOURCE_TO_CONCEPT_MAP	T_MCOaaDMIP lpp_cod T_MCOaaFPSTC lpp_cod	SOURCE_TO_CONCEPT_MAP source_code	source_vocabulary_id = ‘LPP’
domain_id	domain_id de CONCEPT s’il existe Sinon ‘Device’	Jointure 1 : T_MCOaaDMIP lpp_cod T_MCOaaFPSTC lpp_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 = ‘LPP’
quantity	Somme de : Pour T_MCOaaDMIP : nbr_pos Pour T_MCOaaFPSTC : lpp_qua Pour T_SSRaaFPSTC : lpp_qua sur domain_id, person_id, visit_occurrence_id, provider_id, concept_id, source_value, source_concept_id, start_date, et end_date