documentation:vocabulary:drg
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:vocabulary:drg [2021/04/15 09:33] ptalapova |
documentation:vocabulary:drg [2021/04/15 09:35] ptalapova [ETL process] |
||
|---|---|---|---|
| Line 16: | Line 16: | ||
| * MS-DRG | * MS-DRG | ||
| - | ==== for ETL ==== | + | ==== 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
