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. ...@@ -53,7 +53,7 @@ PMSI data are recorded and stored in DXCARE PMSI.
## Data description ## Data description
### DXCARE PMSI ### Diagnosis
* **Schema**: PENSOINS * **Schema**: PENSOINS
* **Tables**: * **Tables**:
...@@ -72,6 +72,34 @@ PMSI data are recorded and stored in DXCARE PMSI. ...@@ -72,6 +72,34 @@ PMSI data are recorded and stored in DXCARE PMSI.
|RETRAIT | Is the diagnosis invalid | |RETRAIT | Is the diagnosis invalid |
|NIDIAGREF | Foreign key for C_DIAG_M ==> points to the corresponding ICD10 code| |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 # Data integration
## ETL ## ETL
... ...
......