-
Notifications
You must be signed in to change notification settings - Fork 3
HAD Events
Youcef Sebiat edited this page May 4, 2020
·
3 revisions
The following describes all the available to extractions Events from PMSI-HAD table in SNDS. The link in the title redirects to the implementation of the Extractor. You can call that Extractor to get the Event.
Values are coded in CCAM coding system.
| Event field | PatientID | category | groupID | value | weight | start | end |
|---|---|---|---|---|---|---|---|
| Mapping | NUM_ENQ from HAD_C | had_ccam_act | Concatenation of ETA_NUM_EPMSI, RHAD_NUM, and year from HAD_C | CCAM_COD from HAD_A | 1.0 (non used) | EXE_SOI_DTD from HAD_C | null(non used) |
Values are coded in CIM-10 coding system.
| Event field | PatientID | category | groupID | value | weight | start | end |
|---|---|---|---|---|---|---|---|
| Mapping | NUM_ENQ from HAD_C | had_main_diagnosis | Concatenation of ETA_NUM_EPMSI, RHAD_NUM, and year from HAD_C | DGN_PAL from HAD_B | 1.0 (non used) | EXE_SOI_DTD from HAD_C | null(non used) |
Values are coded in CIM-10 coding system.
| Event field | PatientID | category | groupID | value | weight | start | end |
|---|---|---|---|---|---|---|---|
| Mapping | NUM_ENQ from HAD_C | had_associated_diagnosis | Concatenation of ETA_NUM_EPMSI, RHAD_NUM, and year from HAD_C | DGN_ASS from HAD_D | 1.0 (non used) | EXE_SOI_DTD from HAD_C | null(non used) |
Values are coded in a referential here.
| Event field | PatientID | category | groupID | value | weight | start | end |
|---|---|---|---|---|---|---|---|
| Mapping | NUM_ENQ from HAD_C | had_main_take_over_reason | Concatenation of ETA_NUM_EPMSI, RHAD_NUM, and year from HAD_C | PEC_PAL from HAD_B | 1.0 (non used) | EXE_SOI_DTD from HAD_C | null(non used) |
Values are coded in a referential here.
| Event field | PatientID | category | groupID | value | weight | start | end |
|---|---|---|---|---|---|---|---|
| Mapping | NUM_ENQ from HAD_C | had_associated_take_over_reason | Concatenation of ETA_NUM_EPMSI, RHAD_NUM, and year from HAD_C | PEC_ASS from HAD_B | 1.0 (non used) | EXE_SOI_DTD from HAD_C | null(non used) |
- Section One: Events Mapping
- DCIR
- PMSI
- Referentials
- Section Two: Extraction Elements
- Section Three: Patients Mapping
- Section Four: Transformers