Formulary Products
| Global ODS Field | Field Type |
Source Data Connector: MMIT Table: mmit_drugs_ods__v |
|---|---|---|
| composite_key__v | varchar(141) | |souce_connector_name__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_ndc_bridge_ods__v.ndc__v|mmit_drugs_ods__v.medid__v| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console (Source ID)null |
| native_id__v | varchar(41) | |mmit_medispan_bridge_ODS__v.ddi__v|mmit_ndc_bridge_ods__v.ndc__v|mmit_drugs_ods__v.medid__v| |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console (Connector Name) |
| source_table_name__v | varchar(100) | Extracted from MDS |
| med_id__v | varchar(500) | mmit_drugs_ods__v.medid__v |
| drug_name__v | varchar(500) | mmit_drugs_ods__v.drugname__v |
| product_class__v | varchar(10) | mmit_drugs_ods__v.productclass__v |
| brand_generic__v | varchar(10) | mmit_drugs_ods__v.brandgeneric__v |
| client_drug_flag__v | varchar(1) | mmit_drugs_ods__v.clientdrugflag__v |
| ddi__v | varchar(6) | mmit_medispan_bridge_ODS__v.ddi__v |
| ndc__v | varchar(11) | mmit_ndc_bridge_ods__v.ndc__v |
