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