Specialty Pharmacy

Global dimensional table for Specialty Pharmacy (dim_specialty_pharmacy_gbl_DDS__v) sourced from patient_status_gbl_ods__v.

Column Name Column Type Description Mapping from patient_status_gbl_ods__v
dim_global_specialty_pharmacy_id__v bigint Surrogate dimensional key --
specialty_pharmacy_dea__v VARCHAR(255) Specialty Pharmacy DEA specialty_pharmacy_dea__v
specialty_pharmacy_id__v VARCHAR(255) Specialty Pharmacy ID specialty_pharmacy_id__v
specialty_pharmacy_junior_parent_name__v VARCHAR(255) Specialty Pharmacy parent name specialty_pharmacy_junior_parent_name__v
specialty_pharmacy_name__v VARCHAR(255) Specialty Pharmacy Name specialty_pharmacy_name__v
specialty_pharmacy_npi__v VARCHAR(255) Specialty Pharmacy NPI specialty_pharmacy_npi__v
specialty_pharmacy_state__v VARCHAR(255) Specialty Pharmacy State specialty_pharmacy_state__v
specialty_pharmacy_zip__v VARCHAR(255) Specialty Pharmacy Zip specialty_pharmacy_zip__v