*Description de la source de données (a quoi correspondent les données, comment elle sont saisies par les utilisateurs, les terminologies utilisées le cas échéant...)*
PMSI, namely Programme de Médicalisation des Systèmes d'Information, corresponds to reimbursment data for french hospital.
These standard data are produced for each **inpatient venue** to hospital any hospital in France. They aim at describing relevant medical information that have to be produced to determine the cost of an **inpatient venue**.
In Bordeaux University Hospital, these data are centrally produced by specialized technician within a specific unit. This work is done under the supervision of public health mds specialized in medical informatics.
The format and semantics of the data are defined as a national standard by a french agency (ATIH) in charge of centrally collect these data at the national scale.
As a result these data are of high quality and produced in a standardized way for all french hospitals.
Within these data the I2N2 data warehouse integrates to important kinds of observations :
* ICD10 coded diagnosis
* Procedures coded usin as french procedure terminology (CCAM)
### Diagnosis
Diagnosis include 3 different levels depending on the importance of the diagnosis regarding the patient venue:
* Main diagnosis (le diagnostic principal referenced as DP) : **Mandatory, unique**. Refers to the maim motivation for the patient venue there is only one DP per venue
* Secondary diagnosis (le diagnostic relié reference as DR) : **optional, unique**. This diagnosis is used when the DP do not refers to a disease (i.e. chemotherapy or radiotherapy). In this situation the DR correspond to the disease treated by the process coded in DP. For instance chemotherapy for a lung cancer will be coded DP: Z511 (chemotherapy) + DR: C34 (lung cancer)
* Related diagnosis (les diagnostics associés significatifs referenced as DAS): **optional, multiple**. Includes all relevant **active** comorbidities.
* Other diagnosis (les diagnostics associés documentaires referenced as DAD): **optional, multiple**. Other comorbidities (irelevant to the venue) such as previous diseases etc...
This combination of diagnosis is produced for each venue in a specific unit within an hospital. Hence a single inpatient venue can have multiple movements in different units leading to multiple coded tuples.
### Procedures
**Optionnal, multiple**. For each patient movement procedures that are done during the hospital stay within the unit are coded a french terminology (CCAM)
## Example
## Example
*Un ou plusieurs exemple(s) de données issues de la source*
Patient with a breast cancer and an ongoing diabetes.
* First inpatient venue for surgery of the breast cancer (2 movements)
* Movement to the surgery unit :
* DP: C509 breast cancer
* DAS: E149 - diabetes
* procedure: QEFA004 - tumor excision
* Movement to medical unit :
* DP: C509 breast cancer
* DAS: E149 - diabetes
* Second venue for chemotherapy:
* Movement to unit
* DP: Z511 - chemotherapy
* DR: C509 - breast cancer
* DAD: E149 - diabetes
## Software
*Un descriptif de l'application d'où sont issues les données*
