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