US Sales Week

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