Entity Marketing Optimization And Expense Analysis

DescriptionAnalysis of the marketing processes to manage expenditure, improve profit margin, optimize capital efficiency and manage enterprise risk.

Attributes
Activity Cost AmountActivity Cost Amount
Actual Member ResponseActual Member Response
Average Member Acquisition Cost AmountAverage Member Acquisition Cost Amount
Calendar DkCalendar Dk
Call Center Cost AmountCall Center Cost Amount
Campaign Dimension DkCampaign Dimension Dk
Campaign Execution Cost AmountCampaign Execution Cost Amount
Campaign Execution Personnel UtilizationCampaign Execution Personnel Utilization
Commission Cost AmountCommission Cost Amount
Cost Of Acquiring New Members AmountCost Of Acquiring New Members Amount
Forecasted Premium Income From New Business AmountForecasted Premium Income From New Business Amount
Forecast Marketing Research Cost AmountForecast Marketing Research Cost Amount
Forecast Member ResponseForecast Member Response
Geographic Area DkGeographic Area Dk
Group DkGroup Dk
Health Plan Product DkHealth Plan Product Dk
Insurance Policy Dimension DkInsurance Policy Dimension Dk
Marketing Activity Dimension DkMarketing Activity Dimension Dk
Marketing Cost AmountMarketing Cost Amount
Marketing Planning Cost AmountMarketing Planning Cost Amount
Marketing Planning Personnel UtilizationMarketing Planning Personnel Utilization
Marketing Research Cost AmountMarketing Research Cost Amount
Marketing Research Forecasting Accuracy RatioMarketing Research Forecasting Accuracy Ratio
Marketing Research Personnel UtilizationMarketing Research Personnel Utilization
Marketing Research To Execution Cycle TimeMarketing Research To Execution Cycle Time
Member Response Forecasting Accuracy RatioMember Response Forecasting Accuracy Ratio
Member Response Rate Per Marketing ExpenseMember Response Rate Per Marketing Expense
Number Of New Members AcquiredNumber Of New Members Acquired
Organization DkOrganization Dk
Party Role DkParty Role Dk
Percentage Campaign Execution Per SGA CostPercentage Campaign Execution Per SGA Cost
Percentage Marketing Planning Per SGA CostPercentage Marketing Planning Per SGA Cost
Percentage Marketing Research Per SGA CostPercentage Marketing Research Per SGA Cost
Plan Member DkPlan Member Dk
Premium Income Forecasting Accuracy RatioPremium Income Forecasting Accuracy Ratio
Premium Income From Campaign AmountPremium Income From Campaign Amount
Revenue Generated Per Marketing Expense AmountRevenue Generated Per Marketing Expense Amount
SGA Cost AmountSGA Cost Amount
Support Function Cost AmountSupport Function Cost Amount
Time To Create Marketing PlanTime To Create Marketing Plan
Time To Execute CampaignTime To Execute Campaign
Total Marketing Personnel UtilizationTotal Marketing Personnel Utilization

Relationship
Marketing Optimization And Expense Analysis_Calendar Dimension_FKMarketing Optimization And Expense Analysis_Calendar Dimension_FK
Marketing Optimization And Expense Analysis_Geographic Area Dimension_FKMarketing Optimization And Expense Analysis_Geographic Area Dimension_FK
Marketing Optimization And Expense Analysis_Plan Member Dimension_FKMarketing Optimization And Expense Analysis_Plan Member Dimension_FK
Marketing Optimization And Expense Analysis_Group Dimension_FKMarketing Optimization And Expense Analysis_Group Dimension_FK
Marketing Optimization And Expense Analysis_Health Plan Product Dimension_FKMarketing Optimization And Expense Analysis_Health Plan Product Dimension_FK
Marketing Optimization And Expense Analysis_Insurance Policy Dimension_FKMarketing Optimization And Expense Analysis_Insurance Policy Dimension_FK
Marketing Optimization And Expense Analysis_Campaign Dimension_FKMarketing Optimization And Expense Analysis_Campaign Dimension_FK
Marketing Optimization And Expense Analysis_Marketing Activity Dimension_FKMarketing Optimization And Expense Analysis_Marketing Activity Dimension_FK
Marketing Optimization And Expense Analysis_Organization Dimension_FKMarketing Optimization And Expense Analysis_Organization Dimension_FK
Marketing Optimization And Expense Analysis_Party Role Dimension_FKMarketing Optimization And Expense Analysis_Party Role Dimension_FK

Primary Key
Marketing Optimization And Expense Analysis PKMarketing Optimization And Expense Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Activity Cost Amount
DescriptionThe total cost of an activity or activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Actual Member Response
DescriptionNumber of actual member responses.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Member Acquisition Cost Amount
DescriptionAverage cost for acquiring a new member

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



 Call Center Cost Amount
DescriptionThe total cost related to call center activities including for member service, provider service, and other call centers.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Campaign Dimension 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



 Campaign Execution Cost Amount
DescriptionThe actual costs incurred in campaign execution activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Campaign Execution Personnel Utilization
DescriptionActual manpower in full time equivalent (FTE) used to execute the activity.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Commission Cost Amount
DescriptionThe total commission cost including commissions paid to employees, brokers, agents and other intermediaries.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Cost Of Acquiring New Members Amount
DescriptionThe sum of all associated costs in new member acquisition.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Forecasted Premium Income From New Business Amount
DescriptionThe forecasted total premium income resulting from the new policies that will be sold by the insurance company.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Forecast Marketing Research Cost Amount
DescriptionThe amount the organization planned to spend on market research activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Forecast Member Response
DescriptionNumber of member responses forecast.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
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 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



 Insurance Policy Dimension 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



 Marketing Activity Dimension 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



 Marketing Cost Amount
DescriptionThe total cost associated with marketing activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marketing Planning Cost Amount
DescriptionThe actual costs incurred in marketing planning activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marketing Planning Personnel Utilization
DescriptionActual manpower in full time equivalent (FTE) used in marketing planning activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marketing Research Cost Amount
DescriptionThe actual costs incurred in marketing research activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marketing Research Forecasting Accuracy Ratio
DescriptionThe accuracy of the forecasting of marketing research costs, expressed as the ratio between actual and planned marketing research cost.

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



 Marketing Research Personnel Utilization
DescriptionActual manpower in full time equivalent (FTE) used in market research activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marketing Research To Execution Cycle Time
DescriptionFull cycle time of the marketing process starting from the initiation of the marketing research till the completion of the campaign execution.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Member Response Forecasting Accuracy Ratio
DescriptionMeasures the accuracy of the member response forecasting as a ratio between number of actual member responses versus forecasted member responses for a campaign.

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



 Member Response Rate Per Marketing Expense
DescriptionThe rate of customer responses in relation to marketing expenses.

Depending on the nature of the campaign this might be modified to represent, for example, the number of responses per $1000 spent on the campaign.

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



 Number Of New Members Acquired
DescriptionThe number of members who bought through the campaign and who did not own active products beforehand. May be applied to group or individual members as appropriate to the campaign.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization 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



 Party Role 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



 Percentage Campaign Execution Per SGA Cost
DescriptionThe costs associated with execution of campaigns expressed as a percentage of the total Selling, General and Administrative (SGA) cost.

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



 Percentage Marketing Planning Per SGA Cost
DescriptionThe costs associated with marketing planning expressed as a percentage of the total Selling, General and Administrative (SGA) cost.

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



 Percentage Marketing Research Per SGA Cost
DescriptionThe costs associated with marketing research expressed as a percentage of the total Selling, General and Administrative (SGA) cost.

Formula: [(A/B)*100]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 Premium Income Forecasting Accuracy Ratio
DescriptionThe accuracy of the forecasting of marketing research costs, expressed as the ratio between actual and planned marketing research cost.

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



 Premium Income From Campaign Amount
DescriptionThe amount of revenue generated by the marketing campaign.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Revenue Generated Per Marketing Expense Amount
DescriptionThe proportion of the revenue realized as a result of the marketing campaign against the total cost of the marketing process.

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



 SGA Cost Amount
DescriptionSelling, General and Administrative expenses (SGA) are the total of all direct and indirect selling expenses and all general and administrative expenses of a Health Plan Organization, as reported on a company's income statement.
Direct selling expenses are expenses that can be directly linked to the sale of a specific unit such as a broker commission for the sale of a health insurance policy.
Indirect selling expenses are expenses which cannot be directly linked to the sale of a specific unit, but which are proportionally allocated to all units sold during a certain period, such as telephone, interest and postal charges.
General and administrative expenses include, among other things, salaries of non-sales personnel, rent, heat and lights.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Support Function Cost Amount
DescriptionThe total cost related to policy administration, finance, IT, HR and other support functions.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Time To Create Marketing Plan
DescriptionMeasures the total elapsed time between activity start and activity completion.
Actual time spent on the creation of a marketing plan measured in days.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Time To Execute Campaign
DescriptionMeasures the time spent on a business activity.
Actual time spent on the execution of the marketing campaign.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Total Marketing Personnel Utilization
DescriptionActual manpower in full time equivalent (FTE) used to execute the marketing process.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Marketing Optimization And Expense Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense 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



 Marketing Optimization And Expense Analysis_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense 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



 Marketing Optimization And Expense Analysis_Plan Member Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense 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



 Marketing Optimization And Expense Analysis_Group Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense 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



 Marketing Optimization And Expense Analysis_Health Plan Product Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense 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



 Marketing Optimization And Expense Analysis_Insurance Policy Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableInsurance Policy Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Marketing Optimization And Expense Analysis_Campaign Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCampaign Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Marketing Optimization And Expense Analysis_Marketing Activity Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableMarketing Activity Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Marketing Optimization And Expense Analysis_Organization Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Marketing Optimization And Expense Analysis_Party Role Dimension_FK
Is Identifying Relationshiptrue
Child TableMarketing Optimization And Expense Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableParty Role Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Marketing Optimization And Expense Analysis PK
Key AttributePlan Member Dk
Key AttributeMarketing Activity Dimension Dk
Key AttributeOrganization Dk
Key AttributeParty Role Dk
Key AttributeCalendar Dk
Key AttributeGeographic Area Dk
Key AttributeGroup Dk
Key AttributeHealth Plan Product Dk
Key AttributeInsurance Policy Dimension Dk
Key AttributeCampaign Dimension Dk