Formulary Restrictions
| Global ODS Field | Field Type |
Source Data Connector: MMIT Table: Step_Therapy_Path |
Source Data Connector: MMIT Table: Prior_Auth_Path |
|---|---|---|---|
| composite_key__v | varchar(852) | |source_connector_name__v|mmit_planscontroller_ods__v.formularyname__v|mmit_drugs_ods__v.medid__v| mmit_ndc_bridge_ods__v.ndc__v| mmit_planscontroller_ods__v.planname__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_states_ods__v.stateid__v| | |source_connector_name__v|mmit_planscontroller_ods__v.formularyname__v|mmit_drugs_ods__v.medid__v| mmit_ndc_bridge_ods__v.ndc__v|mmit_states_ods__v.stateid__v| mmit_planscontroller_ods__v.planname__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_paudf_ods__v.udfname__v|mmit_paudf_ods__v.udfvalue__v| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console (Source ID)null | Extracted from Internal Admin Console (Source ID)null |
| native_id__v | varchar(952) | |mmit_planscontroller_ods__v.formularyname__v|mmit_drugs_ods__v.medid__v| mmit_ndc_bridge_ods__v.ndc__v| mmit_planscontroller_ods__v.planname__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_states_ods__v.stateid__v| | |mmit_planscontroller_ods__v.formularyname__v|mmit_drugs_ods__v.medid__v| mmit_ndc_bridge_ods__v.ndc__v|mmit_states_ods__v.stateid__v| mmit_planscontroller_ods__v.planname__v|mmit_medispan_bridge_ODS__v.ddi__v|mmit_paudf_ods__v.udfname__v|mmit_paudf_ods__v.udfvalue__v| |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console (Connector Name) | Extracted from Internal Admin Console (Connector Name) |
| source_table_name__v | varchar(100) | Extracted from Internal Admin Console (table name (mmit_planscontroller_ods__v) | Extracted from Internal Admin Console (table name (mmit_planscontroller_ods__v) |
| entity_id__v | varchar(20) | mmit_planscontroller_ods__v.org_id__v | Record ID from data source |
| formulary_name__v | varchar(255) | mmit_planscontroller_ods__v.formularyname__v | mmit_planscontroller_ods__v.formularyname__v |
| controller_name__v | varchar(500) | mmit_planscontroller_ods__v.controllername__v | mmit_planscontroller_ods__v.controllername__v |
| plan_name__v | varchar(500) | mmit_planscontroller_ods__v.planname__v | mmit_planscontroller_ods__v.planname__v |
| parent_name__v | varchar(500) | mmit_planscontroller_ods__v.parentname__v | mmit_planscontroller_ods__v.parentname__v |
| channel__v | varchar(255) | mmit_planscontroller_ods__v.channel | mmit_planscontroller_ods__v.channel |
| plan_type__v | varchar(255) | mmit_planscontroller_ods__v.plantype__v | mmit_planscontroller_ods__v.plantype__v |
| pbm_name__v | varchar(500) | mmit_planscontroller_ods__v.pbmname__v | mmit_planscontroller_ods__v.pbmname__v |
| pbm_id__v | varchar(20) | mmit_planscontroller_ods__v.pbmid__v | mmit_planscontroller_ods__v.pbmid__v |
| pbm_relationship__v | varchar(255) | mmit_planscontroller_ods__v.pbmrelationship__v | mmit_planscontroller_ods__v.pbmrelationship__v |
| nonformulary_policy__v | varchar(255) | mmit_planscontroller_ods__v.nonformularypolicy__v | mmit_planscontroller_ods__v.nonformularypolicy__v |
| benefit_design__v | varchar(255) | mmit_planscontroller_ods__v.benefitdesign__v | mmit_planscontroller_ods__v.benefitdesign__v |
| not_listed_policy__v | varchar(255) | mmit_planscontroller_ods__v.notlistedpolicy__v | mmit_planscontroller_ods__v.notlistedpolicy__v |
| pa_appropriate_restrictive_status__v | varchar(2) | mmit_prio_auth_ods__v.appropriaterestrictivestatus__v | |
| pa_gender__v | varchar(1) | mmit_prior_auth_ods__v.gender__v | |
| pa_age__v | varchar(20) | mmit_prior_auth_ods__v.age__v | |
| pa_age_compare_type__v | varchar(2) | mmit_prior_auth_ods__v.agecompare__v | |
| pa_duration__v | varchar(20) | mmit_prior_auth_ods__v.duration__v | |
| pa_duration_type__v | varchar(1) | mmit_prior_auth_ods__v.durationunit__v | |
| pa_is_specialty_required__v | varchar(20) | mmit_prior_auth_ods__v.isspecialty__v | |
| pa_is_step_within_pa__v | varchar(20) | mmit_prior_auth_ods__v.isstepwithinpa__v | |
| pa_is_medicare_bvsd__v | varchar(20) | mmit_prior_auth_ods__v.ismedicarebvsd__v | |
| pa_udf_name__v | varcahr(100) | mmit_paudf_ods__v.udfname__v | |
| pa_udf_value__v | varchar(8000) | mmit_paudf_ods__v.udfvalue__v | |
| st_is_step_generics__v | varchar(2) | mmit_step_therapy_ods__v.isstepgeneric__v | |
| st_step_status__v | varchar(100) | mmit_step_therapy_ods__v.stepstatus__v | |
| st_step_products__v | varchar(4000) | mmit_step_therapy_ods__v.stepproducts__v | |
| st_step_generics_count__v | varchar(2) | mmit_step_therapy_ods__v.stepgenericscount__v | |
| st_step_brand_count__v | varchar(10) | mmit_step_therapy_ods__v.stepbrandscount__v | |
| drug_name__v | varchar(500) | mmit_drugs_ods__v.drugname__v | mmit_drugs_ods__v.drugname__v |
| product_class__v | varchar(500) | mmit_drugs_ods__v.productclass__v | mmit_drugs_ods__v.productclass__v |
| brand_generic__v | varchar(10) | mmit_drugs_ods__v.brandgeneric__v | mmit_drugs_ods__v.brandgeneric__v |
| client_drug_flag__v | varchar(1) | mmit_drugs_ods__v.clientdrugflag__v | mmit_drugs_ods__v.clientdrugflag__v |
| ddi__v | varchar(6) | mmit_medispan_bridge_ODS__v.ddi__v | mmit_medispan_bridge_ODS__v.ddi__v |
| ndc__v | varchar(11) | mmit_ndc_bridge_ods__v.ndc__v | mmit_ndc_bridge_ods__v.ndc__v |
| state__v | varchar(20) | mmit_states_ods__v.stateid__v | mmit_states_ods__v.stateid__v |
| lives__v | varchar(10) | mmit_states_ods__v.lives__v | mmit_states_ods__v.lives__v |
