DCIR Events

DCIR Events

The following describes all the available to extractions Events from DCIR table in SNDS. The link in the title redirects to the implementation of the Extractor. You can call that Extractor to get the Event.

CCAM Act in DCIR

Values are coded in CCAM coding system.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from ER_PRS_F	dcir_act	Look to the groupID section	CAM_PRS_IDE from ER_CAM_F	1.0 (non used)	EXE_SOI_DTD from ER_PRS_F	null(non used)

groupID algorithm

The groupID carries the information about the type of the institution where the act was carried. Here are the values:

1. Liberal: Done in cabinet of a doctor.
2. Private Ambulatory: service in a private institution, given in ambulatory mode, i.e. without hospitalisation.
3. Public Ambulatory: service in a public institution, given in ambulatory mode, i.e. without hospitalisation.
4. Private hospitalisation: service in a private institution, given within hospitalisation. Maybe duplicated with MCO-Act.
5. DCIR-Act: For legacy purpose, works with old DCIR schemas.
6. unknown_source.

Here how to get them from DCIR.

1. if PRS_PPU_SEC from ER_ETE_F is equal to 1, then groupID = public_ambulatory.
2. Else

• if ETE_GHS_NUM from ER_ETE_F is null, then groupID = Liberal.
• else:
  • if ETE_GHS_NUM from ER_ETE_F is 0 and ETE_TYP_COD is one of : (4, 5, 6, 7), then groupID = private_ambulatory.
  • else unknown_source.

Biological Act in DCIR

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from ER_PRS_F	dcir_act	Look to the groupID section	BIO_PRS_IDE from ER_BIO_F	1.0 (non used)	EXE_SOI_DTD from ER_PRS_F	null(non used)

Drug Delivery in DCIR

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from ER_PRS_F	drug_purchase	prescription id	drug id	1.0 for small box, 2.0 for big box	EXE_SOI_DTD from ER_PRS_F	null(non used)

Prescription ID

The prescription ID is the hash of the concactenation of (FLX_DIS_DTD,FLX_TRT_DTD,FLX_EMT_TYP,FLX_EMT_NUM,FLX_EMT_ORD,ORG_CLE_NUM,DCT_ORD_NUM) all from ER_PRS_F.

Drug ID

The drug id depends on the level pass in the DrugConfig. Available levels:

1. CIP13: gives the CIP13.
2. Molecule combination: gives the actif molecules in the drug.
3. Pharmaceutical level: gives the pharmaceutical classification of the drug.
4. Therapeutical level: gives the therapeutical classification of the drug.

The CIP13 is directly available. For the molecules level, a special IR_PHA_R with a molecules column defined. One is available here.

For Pharmaceutical and Therapeutic level, you must define a DrugClassConfig of interest for you. Here is an example of antidepressants

NGAP acts

NGAP stands for nomenclature générale des actes professionnels, a codification largely replaced by CCAM, but still used by some medical practionners especially in the liberal sector.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from ER_PRS_F	ngap_act	Same as CCAM act	look below	1.0 (non used)	EXE_SOI_DTD from ER_PRS_F	null(non used)

Value of NGAP acts

String concatenation of the following, in that order, seperated by _:

1. PRS_NAT_REF from ER_PRS_F.
2. PRS_NAT_CB2 from IR_NAT_V.
3. PRS_ACT_CFT from ER_PRS_F.

Practitioner Claim Speciality

Get the speciality of the practionner for the delivered act.

Medical practionner

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from ER_PRS_F	medical_practitioner_claim	PFS_EXE_NUM from ER_PRS_F	PSE_SPE_COD from ER_PRS_F	1.0 (non used)	EXE_SOI_DTD from ER_PRS_F, or FLX_DIS_DTD from ER_PRS_F if previous is null	null(non used)

Non medical practionner

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from ER_PRS_F	non_medical_practitioner_claim	PFS_EXE_NUM from ER_PRS_F	PSE_ACT_NAT from ER_PRS_F	1.0 (non used)	EXE_SOI_DTD from ER_PRS_F, or FLX_DIS_DTD from ER_PRS_F if previous is null	null(non used)