The NDC Dimension table provides standardized product, manufacturer, and regulatory attributes for each National Drug Code (NDC), including drug identification, classification, strength, packaging, and status details sourced from MediSpan and Walmart’s Global Pharmacy Hub.
| Technical Name | Business Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|
| brand_genic_type_cd | Brand Generic Type Code | String | Y | - | - |
| geo_region_cd | Geographic Region Code | String | - | - | - |
| gph_innr_pk_qty | GPH Inner Pack Quantity | String | - | - | - |
| gph_outer_pk_qty | GPH Outer Pack Quantity | String | - | - | - |
| mdspn_dea_class_cd | MDSPN DEA Class Code | String | - | - | - |
| mdspn_drug_nm | MDSPN Drug Name | String | - | - | - |
| mdspn_drug_type_nm | MDSPN Drug Type Name | String | - | - | - |
| mdspn_item_status_nm | MDSPN Item Status Name | String | - | - | - |
| mdspn_mfr_nm | MDSPN Manufacturer Name | String | - | - | - |
| mdspn_ndc_eff_dt | MDSPN NDC Effective Date | String | - | - | - |
| mdspn_prev_ndc_upc_hri_cd | MDSPN Previous NDC UPC HRI Code | String | - | - | - |
| mdspn_strength_qty | MDSPN Strength Quantity | Date | - | - | - |
| mdspn_strength_uom_cd | MDSPN Strength UOM Code | String | - | - | - |
| mdspn_thrpc_class_nm | MDSPN Therapeutic Class Name | String | - | - | - |
| ndc_actv_ind | NDC Active Indicator | Numeric | - | - | - |
| ndc_nbr | National Drug Code Number | Numeric | - | - | - |
| op_cmpny_cd | Operational Company Code | Int64 | - | - | - |
