documentation:vocabulary:drg
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
documentation:vocabulary:drg [2021/04/15 09:34] ptalapova [for ETL] |
documentation:vocabulary:drg [2021/04/15 09:35] ptalapova [ETL process] |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| ==== ETL process ==== | ==== ETL process ==== | ||
| - | - 1. If event_date <= 2007-09-30 source DRG codes should be mapped to source_vocabulary_id = 'DRG' and source concept_class_id = 'DRG' | + | - If event_date <= 2007-09-30 source DRG codes should be mapped to source_vocabulary_id = 'DRG' and source concept_class_id = 'DRG' |
| - | - 2. If event_date >= 2007-10-01 source DRG codes should be mapped to source vocabulary_id = 'DRG' and source concept_class_id = 'MS-DRG' | + | - If event_date >= 2007-10-01 source DRG codes should be mapped to source vocabulary_id = 'DRG' and source concept_class_id = 'MS-DRG' |
| - | Note: MS-DRG codes of '156', '155', '251','154', '250' should be filtered using "invalid_reason is null" due to the intersecation of valid dates. | + | Note: MS-DRG codes of '156', '155', '251','154', '250' should be filtered using //invalid_reason is null// due to the intersection of valid dates. |
documentation/vocabulary/drg.txt · Last modified: 2021/04/15 09:35 by ptalapova
Page Tools
