Decision Resources Group (DRG) Data Model
The following table displays data model information used when loading DRG formulary data files into Nitro's Staging Layer.
| Raw File Name | Nitro Table | STG Load Pattern | ODS Load Pattern | Primary Key | Composite Key Definition |
|---|---|---|---|---|---|
| control_totals.txt | drg_control_totals__v | pt_ftp_stg_rawload__v | pt_ftp_ods_rollingload__v | file_name__v | n/a |
| drug.txt | drg_drug__v | pt_ftp_stg_rawformulaload__v | pt_ftp_ods_genload__v | drg_drug_composite_id__v | |drug_class_id__v|drug_id__v| |
| formulary_detail.txt | drg_formulary_detail__v | pt_ftp_stg_rawformulaload__v | pt_ftp_ods_replace_ed_latest__v | drg_formulary_detail_composite_id__v | |plan_id__v|drug_id__v| |
| plan.txt | drg_plan__v | pt_ftp_stg_rawformulaload__v | pt_ftp_ods_replace_ed_latest__v | id__v | n/a |
| plan_geography.txt | drg_plan_geography__v | pt_ftp_stg_rawformulaload__v | pt_ftp_ods_genload__v | drg_plan_geography_composite_id__v | pk_id__v|geography_level_id__v|geography_id__v| |
| restriction_detail.txt | drg_restriction_detail__v | pt_ftp_stg_rawformulaload__v | pt_ftp_ods_replace_ed_latest__v |
drg_restriction_composite_id__v |
plan_id__v|drug_id__v|restriction_detail_id__v| |
The following table displays field information for each Nitro Table listed above.
| Nitro Table | drg_control_totals__v | drg_drug__v | drg_formulary_detail__v | drg_plan__v | drg_plan_geography__v | drg_restriction_detail__v |
|---|---|---|---|---|---|---|
|
Nitro Table Fields
|
file_name__v | drug_class_id__v | plan_id__v | id__v | pk_id__v | plan_id__v |
| record_count__v | drug_id__v | drug_id__v | plan_name__v | geography_level_id__v | drug_id__v | |
| data_date__v | drug_class_name__v | tier_code__v | plan_type_id__v | geography_id__v | restriction_detail_id__v | |
| file_create_date__v | drug_name__v | custom_tier_label__v | plan_type_name__v | geography_level_name__v | restriction_code__v | |
| generic__v | pa__v | exclusion_indicator__v | geography_abbrev_name__v |
formulary_entry_restriction_id__v |
||
| therapeutic_area_id__v | ql__v | plan_display_name__v | parent_geography_id__v | restriction_name__v | ||
| therapeutic_area_name__v | st__v | provider_id__v | parent_geography_name__v | benefit_name__v | ||
| manufacturer__v | or__v | provider_name__v | geography_name__v | restriction_detail_text__v | ||
| formulary_status__v | natinoal_lives_count__v | lives_count__v | restriction_additional_information_1__v | |||
| effective_date__v | national_medical_lives_count__v | medical_lives__v | restriction_additional_information_2__v | |||
| reason_code__v | t3_preferred__v | lower_range__v | ||||
| reason_code_description__v | vendor_plan_name__v | lower_unit__v | ||||
| vendor_formulary_status__v | formulary_id__v | upper_range__v | ||||
| copay__v | formulary_name__v | upper_unit__v | ||||
| restriction_comments__v | ||||||
| pharmacy_status__v | ||||||
| medical_status__v |
