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 |