This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
documentation:vocabulary:drg [2020/07/20 08:52] ptalapova created |
documentation:vocabulary:drg [2021/04/15 09:35] (current) ptalapova [ETL process] |
||
---|---|---|---|
Line 15: | Line 15: | ||
* DRG | * DRG | ||
* MS-DRG | * MS-DRG | ||
+ | |||
+ | ==== 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-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. |