Entity Outpatient Pharmacy Benefits Analysis

DescriptionThe analysis of outpatient utilization of drug products, including costs and savings achieved by generic substitution, formulary usage, and mail order.

Attributes
Administration Fee AmountAdministration Fee Amount
Average Days Supply Per PrescriptionAverage Days Supply Per Prescription
Average Dispensed Alternative Drug Differential Per Member AmountAverage Dispensed Alternative Drug Differential Per Member Amount
Average Dispensed Alternative Drug Differential Per Prescription AmountAverage Dispensed Alternative Drug Differential Per Prescription Amount
Average Member And Health Plan Cost Of Dispensed Prescriptions PMPM AmountAverage Member And Health Plan Cost Of Dispensed Prescriptions PMPM Amount
Average Number Of Drug Switches Per MemberAverage Number Of Drug Switches Per Member
Average Number Of Prescriptions PMPYAverage Number Of Prescriptions PMPY
Average Patient Pay Per Prescription AmountAverage Patient Pay Per Prescription Amount
Average Professional Service Fee Paid Per Prescription AmountAverage Professional Service Fee Paid Per Prescription Amount
Calendar DkCalendar Dk
Condition DkCondition Dk
Coverage Eligibility DkCoverage Eligibility Dk
Dispensed Alternative Drug Differential AmountDispensed Alternative Drug Differential Amount
Dispensing Fee AmountDispensing Fee Amount
Geographic Area DkGeographic Area Dk
Group DkGroup Dk
Health Plan Cost Of Dispensed PrescriptionsHealth Plan Cost Of Dispensed Prescriptions
Health Plan Product DkHealth Plan Product Dk
Ingredient Cost AmountIngredient Cost Amount
Ingredient Cost Of Originally Prescribed DrugIngredient Cost Of Originally Prescribed Drug
Ingredient Discount AmountIngredient Discount Amount
Medication DkMedication Dk
Member And Health Plan Cost Of Dispensed PrescriptionsMember And Health Plan Cost Of Dispensed Prescriptions
Member Cost Of Dispensed PrescriptionsMember Cost Of Dispensed Prescriptions
Number Of Days SupplyNumber Of Days Supply
Number Of Drug Prescriptions DispensedNumber Of Drug Prescriptions Dispensed
Number Of Drug SwitchesNumber Of Drug Switches
Number Of Member MonthsNumber Of Member Months
Number Of MembersNumber Of Members
Number Of Member YearsNumber Of Member Years
Pharmacy Order Dispense DkPharmacy Order Dispense Dk
Plan Member DkPlan Member Dk
Practitioner DkPractitioner Dk
Professional Service Fee AmountProfessional Service Fee Amount
Provider DkProvider Dk
Rebate AmountRebate Amount
Sales Tax AmountSales Tax Amount

Relationship
Outpatient Pharmacy Benefits Analysis_Calendar Dimension_FKOutpatient Pharmacy Benefits Analysis_Calendar Dimension_FK
Outpatient Pharmacy Benefits Analysis_Geographic Area Dimension_FKOutpatient Pharmacy Benefits Analysis_Geographic Area Dimension_FK
Outpatient Pharmacy Benefits Analysis_Plan Member Dimension_FKOutpatient Pharmacy Benefits Analysis_Plan Member Dimension_FK
Outpatient Pharmacy Benefits Analysis_Condition Dimension_FKOutpatient Pharmacy Benefits Analysis_Condition Dimension_FK
Outpatient Pharmacy Benefits Analysis_Group Dimension_FKOutpatient Pharmacy Benefits Analysis_Group Dimension_FK
Outpatient Pharmacy Benefits Analysis_Practitioner Dimension_FKOutpatient Pharmacy Benefits Analysis_Practitioner Dimension_FK
Outpatient Pharmacy Benefits Analysis_Provider Dimension_FKOutpatient Pharmacy Benefits Analysis_Provider Dimension_FK
Outpatient Pharmacy Benefits Analysis_Medication Dimension_FKOutpatient Pharmacy Benefits Analysis_Medication Dimension_FK
Outpatient Pharmacy Benefits Analysis_Pharmacy Order Dispense Dimension_FKOutpatient Pharmacy Benefits Analysis_Pharmacy Order Dispense Dimension_FK
Outpatient Pharmacy Benefits Analysis_Health Plan Product Dimension_FKOutpatient Pharmacy Benefits Analysis_Health Plan Product Dimension_FK
Outpatient Pharmacy Benefits Analysis_Coverage Eligibility Dimension_FKOutpatient Pharmacy Benefits Analysis_Coverage Eligibility Dimension_FK

Primary Key
Outpatient Pharmacy Benefits Analysis PKOutpatient Pharmacy Benefits Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Administration Fee Amount
DescriptionThe total administration amount charged, for dispensed prescriptions, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Days Supply Per Prescription
DescriptionThe average days supply per dispensed prescription, during the period of analysis.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Dispensed Alternative Drug Differential Per Member Amount
DescriptionThe average cost differential per member between originally prescribed drugs and dispensed drugs. (applies only to prescriptions where dispensed drug differs from originally prescribed drug).

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Dispensed Alternative Drug Differential Per Prescription Amount
DescriptionThe average difference in cost on prescription between originally prescribed drugs and dispensed drugs. (applies only to prescriptions where dispensed drug differs from originally prescribed drug).

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Member And Health Plan Cost Of Dispensed Prescriptions PMPM Amount
DescriptionThe average amount paid, for dispensed prescriptions, during the period of analysis, per member per month (PMPM).
This includes all amounts paid by the member and health plan, net of any rebates.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Number Of Drug Switches Per Member
DescriptionThe average number of drug switches per member.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Number Of Prescriptions PMPY
DescriptionThe average number of prescriptions dispensed to members, per member year, during the period of analysis.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Patient Pay Per Prescription Amount
DescriptionThe average amount members paid for each dispensed prescription, during the period of analysis.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Professional Service Fee Paid Per Prescription Amount
DescriptionThe average amount charged, per prescription, for dispensing professional services, during the period of analysis.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Calendar Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Condition Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Coverage Eligibility Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Dispensed Alternative Drug Differential Amount
DescriptionThe total difference in cost between the originally prescribed drug(s) and dispensed drug(s). This only applies to prescriptions where dispensed drug differs from originally prescribed drug, during the period of analysis.

Formula: [A-B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Dispensing Fee Amount
DescriptionThe total dispensing fee amount charged, for dispensed prescriptions, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Geographic Area Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Group Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Health Plan Cost Of Dispensed Prescriptions
DescriptionThe total amount paid, by the health plan, for dispensed prescriptions, during the period of analysis.

Formula: [A-B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Plan Product Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Ingredient Cost Amount
DescriptionThe total undiscounted cost of drug ingredients or drug products, for dispensed prescriptions, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Ingredient Cost Of Originally Prescribed Drug
DescriptionThe total undiscounted cost of the originally prescribed drug ingredients or drug products, for dispensed prescriptions where a drug switch occurred, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Ingredient Discount Amount
DescriptionThe total amount, that was discounted from the drug ingredient costs, for dispensed prescriptions, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medication Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Member And Health Plan Cost Of Dispensed Prescriptions
DescriptionThe total amount paid for dispensed prescriptions, during the period of analysis. This includes all amounts paid by the member and health plan, net of any rebates.

Formula: [(A+B+C+D+E+F)-G]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Member Cost Of Dispensed Prescriptions
DescriptionThe total amount, paid by members, for dispensed prescriptions, in the form of deductibles, co-payment and other disallowed amounts, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Days Supply
DescriptionThe total of estimated number of days that prescriptions will last if taken according to prescriber instructions.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Drug Prescriptions Dispensed
DescriptionThe total number of drug prescriptions dispensed to members, during the period of analysis.
A prescription for more than 30 days supply may count multiple times towards this measurement, i.e. 90 days supply may be considered as 3 prescriptions.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Drug Switches
DescriptionThe total number of drug switches, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Member Months
DescriptionThe total number of months that a member has one or more active memberships, in one or more health benefits plans, during the period of analysis.
This may be a point in time calculation of the number of members, at a specific date in every month (15th) or it may be rounded sum of the number of months based on each members enrollment dates.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members
DescriptionThe total count of members, during the period of analysis.
This may be the total number of people with one or more active memberships at a given point in time during the period, or the average number of people with active memberships over the full period.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Member Years
DescriptionThe total number of years that member have one or more active memberships, in one or more health benefits plans, during the period of analysis.
This may be a point in time calculation of the number of members, at a specific date in every year (1st of July), be based on the number of member months calculation or may be rounded sum of the number of years based on each members enrollment dates.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pharmacy Order Dispense Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Plan Member Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Professional Service Fee Amount
DescriptionThe total amount charged, for dispensed prescription professional services, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Rebate Amount
DescriptionThe total formulary or other rebate amount received by the health plan, in respect of dispensed prescriptions, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sales Tax Amount
DescriptionThe total sales tax amount charged, for dispensed prescriptions, during the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Outpatient Pharmacy Benefits Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeographic Area Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Plan Member Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePlan Member Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Condition Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCondition Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Group Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGroup Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Medication Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableMedication Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Pharmacy Order Dispense Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePharmacy Order Dispense Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Health Plan Product Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableHealth Plan Product Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Outpatient Pharmacy Benefits Analysis_Coverage Eligibility Dimension_FK
Is Identifying Relationshiptrue
Child TableOutpatient Pharmacy Benefits Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCoverage Eligibility Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Outpatient Pharmacy Benefits Analysis PK
Key AttributePlan Member Dk
Key AttributeCondition Dk
Key AttributePractitioner Dk
Key AttributeProvider Dk
Key AttributeMedication Dk
Key AttributePharmacy Order Dispense Dk
Key AttributeHealth Plan Product Dk
Key AttributeCoverage Eligibility Dk
Key AttributeCalendar Dk
Key AttributeGeographic Area Dk
Key AttributeGroup Dk