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:35] ptalapova [ETL process] |
documentation:vocabulary:drg [2021/04/15 09:35] 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. |