Formulary
Global ODS Field | Field Type |
Source Data Connector: MMIT Table: mmit_planscontroller_ods__v |
---|---|---|
composite_key__v | varchar(1107) | |source_connector_name__v|mmit_planscontroller_ods__v.formularyname__v|mmit_drugs_ods__v.medid__v| mmit_ndc_bridge_ods__v.ndc__v|mmit_restrictions_ods__v.restrictioncode__v| mmit_planscontroller_ods__v.planname__v|mmit_statuses_ods__v.rawstatus__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_states_ods__v.stateid__v| |
source_system_id__v | varchar(18) | Extracted from Internal Admin Console (Source ID)null |
native_id__v | varchar(1207) | |mmit_planscontroller_ods__v.formularyname__v|mmit_drugs_ods__v.medid__v|mmit_ndc_bridge_ods__v.ndc__v|mmit_restrictions_ods__v.restrictioncode__v| mmit_planscontroller_ods__v.planname__v|mmit_statuses_ods__v.rawstatus__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_states_ods__v.stateid__v| |
source_connector_name__v | varchar(100) | Extracted from Internal Admin Console (Connector Name) |
source_table_name__v | varchar(100) | Extracted from Internal Admin Console (source table name (mmit_planscontroller_ods__v)) |
entity_id__v | varchar(20) | mmit_planscontroller_ods__v.org_id__v |
formulary_name__v | varchar(255) | mmit_planscontroller_ods__v.formularyname__v |
plan_name__v | varchar(500) | mmit_planscontroller_ods__v.planname__v |
controller_name__v | varchar(500) | mmit_planscontroller_ods__v.controllername__v |
parent_name__v | varchar(500) | mmit_planscontroller_ods__v.parentname__v |
channel__v | varchar(255) | mmit_planscontroller_ods__v.channel__v |
plan_type__v | varchar(255) | mmit_planscontroller_ods__v.plantype__v |
pbm_name__v | varchar(500) | mmit_planscontroller_ods__v.pbmname__v |
pbm_id__v | varchar(20) | mmit_planscontroller_ods__v.pbmid__v |
pbm_relationship__v | varchar(255) | mmit_planscontroller_ods__v.pbmrelationship__v |
nonformulary_policy__v | varchar(255) | mmit_planscontroller_ods__v.nonformularypolicy__v |
benefit_design__v | varchar(255) | mmit_planscontroller_ods__v.benefitdesign__v |
not_listed_policy__v | varchar(255) | mmit_planscontroller_ods__v.notlistedpolicy__v |
address_line_1__v | varchar(60) | mmit_plandetails_ods__v.address1__v |
address_line_2__v | varchar(60) | mmit_plandetails_ods__v.address2__v |
locality__v | varchar(50) | mmit_plandetails_ods__v.city__v |
administrative_area__v | varchar(20) | mmit_plandetails_ods__v.stateid__v |
postal_code__v | varchar(5) | mmit_plandetails_ods__v.zip__v |
postal_code_ext__v | varchar(4) | mmit_plandetails_ods__v.zipext__v |
phone__v | varchar(25) | mmit_plandetails_ods__v.phone__v |
prior_auth_phone__v | varchar(25) | mmit_plandetails_ods__v.priorauthphone__v |
prior_auth_fax__v | varchar(25) | mmit_plandetails_ods__v.priorauthfax__v |
member_phone__v | varchar(25) | mmit_plandetails_ods__v.memberphone__v |
therapeutic_class__v | varchar(70) | mmit_statuses_ods__v.therapeuticclass__v |
universal_status__v | varchar(255) | mmit_statuses_ods__v.universalstatus__v |
universal_status_roll_up__v | varchar(255) | mmit_statuses_ods__v.universalstatusrollup__v |
raw_status__v | varchar(255) | mmit_statuses_ods__v.rawstatus__v |
restriction_code__v | varchar(2) | mmit_restrictions_ods__v.restrictioncode__v |
restriction_detail__v | varchar(8000) | mmit_restrictions_ods__v.restrictiondetail__v |
drug_name__v | varchar(500) | mmit_drugs_ods__v.drugname__v |
product_class__v | varchar(500) | 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 |
state__v | varchar(20) | mmit_states_ods__v.stateid__v |
lives__v | varchar(10) | mmit_states_ods__v.lives__v |