US Sales
Nitro provides connectors to Symphony Health and Iqvia. Once the data is normalized, is available for analysis via Nitro. This is a single sales star that uses data from either Symphony Health data solutions or Iqvia Xponent. Raw data from both providers is transformed into the star to allow for ease of reporting.
| Iqvia Table | Iqvia Field | Symphony Table | Symphony | Dimension | Common Sales Star |
|---|---|---|---|---|---|
| Demographic | dim_us_sales_demographic_id__v | ||||
| iqvia_sales_xponent_demographic_ods__v | imsno__v | symphony_demographic_ods__v | rel_id__v | Demographic |
sales_provider_id__v |
| iqvia_sales_xponent_demographic_ods__v | middleinitial__v | symphony_demographic_ods__v | middle_name__v | Demographic | middle_name__v |
| iqvia_sales_xponent_demographic_ods__v | address1__v | symphony_demographic_ods__v | address__v | Demographic | address1__v |
| iqvia_sales_xponent_demographic_ods__v | firstname__v | symphony_demographic_ods__v | first_name__v | Demographic | first_name__v |
| iqvia_sales_xponent_demographic_ods__v | lastname__v | symphony_demographic_ods__v | last_name__v | Demographic | last_name__v |
| iqvia_sales_xponent_demographic_ods__v | speccode__v | symphony_demographic_ods__v | specialty_code__v | Demographic | specialty_code__v |
| iqvia_sales_xponent_demographic_ods__v | specdesc__v | symphony_demographic_ods__v | specialty_description__v | Demographic | specialty_description__v |
| iqvia_sales_xponent_demographic_ods__v | zip__v | symphony_demographic_ods__v | zip_code__v | Demographic | zip_code__v |
| iqvia_sales_xponent_demographic_ods__v | imsno__v | symphony_demographic_ods__v | npi_number__v | Demographic | npi_number__v |
| iqvia_sales_xponent_demographic_ods__v | city__v | symphony_demographic_ods__v | city__v | Demographic | city__v |
| iqvia_sales_xponent_demographic_ods__v | state__v | symphony_demographic_ods__v | state__v | Demographic | state__v |
| symphony_demographic_ods__v | title__v | Demographic | title__v | ||
| symphony_demographic_ods__v | pdrp_indicator__v | Demographic | pdrp_indicator__v | ||
| symphony_demographic_ods__v | pdrp_date__v | Demographic | pdrp_date__v | ||
| symphony_demographic_ods__v | territory__v | Demographic | territory__v | ||
| Demographic | us_sales_demographic_lastmodifieddate__v | ||||
| Plan | dim_us_sales_plan_id__v | ||||
| iqvia_sales_payer_plan_ods__v | payer_plan_id__v | symphony_plan_ods__v | plan_id__v | Plan | plan_id__v |
| iqvia_sales_payer_plan_ods__v | payerid__v | symphony_plan_ods__v | mco_number__v | Plan | payer_id__v |
| iqvia_sales_payer_plan_ods__v | city__v | symphony_plan_ods__v | city__v | Plan | city__v |
| iqvia_sales_payer_plan_ods__v | hq_state__v | symphony_plan_ods__v | state__v | Plan | state__v |
| iqvia_sales_payer_plan_ods__v | model__v | symphony_plan_ods__v | plan_type__v | Plan | plan_type__v |
| iqvia_sales_payer_plan_ods__v | payername__v | symphony_plan_ods__v | mco_name__v | Plan | payer_name__v |
| iqvia_sales_payer_plan_ods__v | planname__v | symphony_plan_ods__v | plan_name__v | Plan | plan_name__v |
| symphony_plan_ods__v | plan_sub_type__v | Plan | plan_subtype__v | ||
| symphony_plan_ods__v | payment_type_indicator__v | Plan | payment_type_indicator__v | ||
| symphony_plan_ods__v | enrollment__v | Plan | enrollment__v | ||
| Plan | us_sales_plan_lastmodifieddate__v | ||||
| iqvia_sales_payer_plan_ods__v | months_with_data__v | Plan | months_with_data__v | ||
| iqvia_sales_payer_plan_ods__v | operating_state__v | Plan | operating_state__v | ||
| Product | dim_us_sales_product_id__v | ||||
| iqvia_market_ods__v | productgroupnumber__v | symphony_product_ods__v | product_id__v | Product | product_id__v |
| iqvia_market_ods__v | brand__v | symphony_product_ods__v | drug_name__v | Product | brand__v |
| iqvia_market_ods__v | product__v | symphony_product_ods__v | product_name__v | Product | product_name__v |
| symphony_product_ods__v | usc_code__v | Product | usc_code | ||
| symphony_product_ods__v | form_code__v | Product | form_code__v | ||
| symphony_product_ods__v | form_description__v | Product | form_description__v | ||
| iqvia_market_ods__v | type__v | Product | type__v | ||
| Product | us_sales_product_lasatmodifieddate__v | ||||
| Market | dim_us_sales_market_id__v | ||||
| productgroupnumber__v | market_id__v | Market | market_id__v | ||
| class_form__v | market_name__v | Market | market_name__v | ||
| Market | us_sales_market_lasatmodifieddate__v | ||||
| iqvia_sales_xponent_details_ods__v | new_rx__v | symphony_prescriber_payer_fact_ods__v | new_rx_count__v | Fact | new_rx_count__v |
| iqvia_sales_xponent_details_ods__v | total_rx__v - new_rx__v | symphony_prescriber_payer_fact_ods__v | refill_rx_count__v | Fact | refill_rx_count__v |
| iqvia_sales_xponent_details_ods__v | total_rx__v | symphony_prescriber_payer_fact_ods__v | total_rx_count__v | Fact | total_rx_count__v |
| iqvia_sales_xponent_details_ods__v | new_quantity__v | symphony_prescriber_payer_fact_ods__v | new_rx_quantity__v | Fact | new_rx_quantity__v |
| iqvia_sales_xponent_details_ods__v | total_quantity__v - new_quantity__v | symphony_prescriber_payer_fact_ods__v | refill_rx_quantity__v | Fact | refill_rx_quantity__v |
| iqvia_sales_xponent_details_ods__v | total_quanitity__v | symphony_prescriber_payer_fact_ods__v | total_rx_quantity__v | Fact | total_rx_quantity__v |
| symphony_prescriber_payer_fact_ods__v | new_rx_cost__v | Fact | new_rx_dollars__v | ||
| symphony_prescriber_payer_fact_ods__v | refill_rx_cost__v | Fact | refill_rx_dollars__v | ||
| symphony_prescriber_payer_fact_ods__v | total_rx_cost__v | Fact | total_rx_dollars__v | ||
| Fact | dim_us_sales_demographic_id__v | ||||
| Fact | dim_us_sales_plan_id__v | ||||
| Fact | dim_us_sales_product_id__v | ||||
| Fact | dim_us_sales_market_id__v | ||||
| iqvia_sales_xponent_details_ods__v | data_period_dt__v | symphony_prescriber_payer_fact_ods__v | week_ending_date__v | Fact | dim_date_id__v |
