Changes

Page history
pmsi authored by JOUHET Vianney's avatar JOUHET Vianney
Show whitespace changes
Inline Side-by-side
PMSI.md
View page @ 911af742
......@@ -53,7 +53,7 @@ PMSI data are recorded and stored in DXCARE PMSI.
## Data description
### DXCARE PMSI
### Diagnosis
* **Schema**: PENSOINS
* **Tables**:
......@@ -72,6 +72,34 @@ PMSI data are recorded and stored in DXCARE PMSI.
|RETRAIT | Is the diagnosis invalid |
|NIDIAGREF | Foreign key for C_DIAG_M ==> points to the corresponding ICD10 code|
### Procedures
* **Schema**: PENSOINS
* **Tables**:
* CCAMCODAGE: Contains coded instances (procedures effectively coded)
|COLUMN |DESCRIPTION |
|------------------------------------------|-----------------------------------------------------------------------------------------------------|
|CCAM | CCAM Code|
|STATUT | 3 = erased |
|NIDACTIVITE | Foreign key CCAMACTIVITE|
|NIDINTERV | Foreign key CCAMINTERV|
* CCAMACTIVITE: Effective activity coded by the CCAM code
|COLUMN |DESCRIPTION |
|------------------------------------------|-----------------------------------------------------------------------------------------------------|
|STATUT | 3 = erased |
* CCAMINTERV: Effective intervention code by the CCAM codes
|COLUMN |DESCRIPTION |
|------------------------------------------|-----------------------------------------------------------------------------------------------------|
|RETRAIT | Has the intervention been erased
# Data integration
## ETL
......
......