User Tools

Site Tools


documentation:vocabulary:drg

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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.
documentation/vocabulary/drg.1595235149.txt.gz ยท Last modified: 2020/07/20 08:52 by ptalapova