# 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