documentation:vocabulary:drg
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
documentation:vocabulary:drg [2021/04/15 09:35] ptalapova [ETL process] |
documentation:vocabulary:drg [2021/04/15 09:35] (current) ptalapova [ETL process] |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| ==== ETL process ==== | ==== ETL process ==== | ||
| - | - 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' |
| - | - 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 intersection 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.1618479322.txt.gz · Last modified: 2021/04/15 09:35 by ptalapova
Page Tools
