add concept structure authored by JOUHET Vianney's avatar JOUHET Vianney
...@@ -211,22 +211,13 @@ WHERE ...@@ -211,22 +211,13 @@ WHERE
### Concept codes structure ### Concept codes structure
### Data types
PMSI data contains only coded concepts :
* ICD10 codes representing diagnosis for the venue (primary, secondary and related diagnosis are coded
* Procedures are natively coded using a french procedure terminology (aka CCAM) a part of these codes are mapped to SNOMED-CT codes
|SOURCE ELEMENT | CONCEPT_CD | MODIFIER_CD | START DATE | END DATE|
|---------------|------------|-------------|------------|---------|
## Concept codes structure
All CONCEPT_CD have a similar structure : All CONCEPT_CD have a similar structure :
- Open-ended question (free text or numeric) : FLUX_ID:DATA_ELEMENT - Open-ended question (free text or numeric) : FLUX_ID:DATA_ELEMENT
- Closed-ended question : FLUX_ID:DATA_ELEMENT-VALUE_DOMAIN|PERMISSIBLE - Closed-ended question : FLUX_ID:DATA_ELEMENT-VALUE_DOMAIN|PERMISSIBLE
|SOURCE ELEMENT |FLUX_ID |DATA_ELEMENT|VALUE_DOMAIN |PERMISSIBLE | |SOURCE ELEMENT |FLUX_ID |DATA_ELEMENT|VALUE_DOMAIN |PERMISSIBLE |
|---------------|--------------------------------|------------|--------------|-------------| |---------------|--------------------------------|------------|--------------|-------------|
| | |DATA_ELEMENT|*VALUE_DOMAIN*|*PERMISSIBLE*| | ICD10 code | PMSI |DIAGNOSTIC |*ICD10CHU*| actual code|
... ...
......