Extraction of LPP from the peripheric table ER_TIP_F

[strayMat]

• Extract LPP events in the DCIR (Liste des Produits et Prestations, translated in MedicalAppliances) from the peripheric table TIP_PRS_IDE. These lines correspond to Medical Appliances (or medical devices) that are sold or rented to patients. Examples of such services are : dietary foods and articles for dressings, external orthoses and prostheses, implantable medical devices and vehicles for the physically handicapped

See the code column and table here : https://drees.shinyapps.io/dico-snds/?variable=TIP_PRS_IDE&search=&table=ER_TIP_F

[strayMat]

Some checks should be made on the data which I refer here :

• [ ] *Are the start date of cares (EXE_SOI_DTD) and the start date of location / purchase (ER_TIP_F__TIP_ACL_DTD) the same ? *

• [ ] Are the end date of cares (EXE_SOI_DTF) and the end date of location / purchase (ER_TIP_F__TIP_ACL_DTF) the same ?

• [ ] An interesting information is located in ER_TIP_F__TIP_PRS_TYP, the type of prestation. Where to incorporate this information ? In category ? In a new column, data_origin which purposes would be the origination of the event ? The possible values are the following:

0 | SANS OBJET
-- | --
1 | ACHAT
2 | ENTRETIEN
3 | LOCATION
4 | FRAIS DE PORT
5 | REPARATION
6 | SERVICE
7 | LIVRAISON
9 | VALEUR INCONNUE