Dimensional Warehouse Model Data Model

Entity

Entity Business Activity Performance Analysis

Description

Analysis of the effectiveness and efficiency that the health plan organization achieves in performing its business activities.

Attributes
Activity Completion On Time Rate
Activity Completion Success Rate
Activity Cost Amount
Activity Cost Forecast Accuracy Rate
Activity Cost Forecast Amount
Activity Duration
Activity Time Spent
Average Activity Cost Amount
Average Activity Duration
Average Activity Time Spent
Calendar Dk
Capital Expenditure For Organization Amount
Geographic Area Dk
Group Dk
Health Plan Product Dk
Number Of Activities
Number Of Activities Completed Late But Successfully
Number Of Late Activities
Number Of Successful Activities
Organization Dk
Percentage Capex For Process
Personnel Utilization Per Activity
Planned Personnel Requirement Per Activity
Process Capex Amount

Relationship
Business Activity Performance Analysis_Calendar Dimension_FK
Business Activity Performance Analysis_Geographic Area Dimension_FK
Business Activity Performance Analysis_Group Dimension_FK
Business Activity Performance Analysis_Health Plan Product Dimension_FK
Business Activity Performance Analysis_Organization Dimension_FK

Primary Key
Business Activity Performance Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Activity Completion On Time Rate

Description	The proportion of activities successfully completed within the planned timeframe. Formula: [(A-B)/C] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Activity Completion Success Rate

Description	Percentage of activities that were completed successfully from begin to end, in relation to the total number of activities. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Activity Cost Amount

Description	The total cost of an activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Activity Cost Forecast Accuracy Rate

Description	The ratio of the actual activity cost to the planned activity cost. A ratio of less than one indicates that actual activity cost was less than forecast; a ratio greater than one indicate that actual activity cost exceeded the forecast cost. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Activity Cost Forecast Amount

Description	The planned or expected cost of the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Activity Duration

Description	Measures the total elapsed time between activity start and activity completion date.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Activity Time Spent

Description	Total time spent on a business activity by employees, agents or contractors of the organization. It is the sum of actual effort expended on this activity by all employees and does not include wait time. This is in contrast to activity duration or cycle time which include intervening wait times etc.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Activity Cost Amount

Description	Average cost of a business process. Formula: [sum(A)/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Activity Duration

Description	Average activity cycle time for a business activity. That is the average length of time from when an activity is commenced until it is completed. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Activity Time Spent

Description	Average time spent on a business activity by employees, agents or contractors of the organization. It is the sum of actual effort expended on this activity by all persons divided by the number of activities. This is in contrast to average activity duration or cycle time which include intervening wait times etc. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Capital Expenditure For Organization Amount

Description	Overall Capital Expenditure (CAPEX) Figure for the organization. This is a reference amount used to measure the significance of capex on individual projects. It should not be aggregated in any analysis as this would overstate organization capex.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Geographic Area Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Group Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Health Plan Product Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Number Of Activities

Description	Counts the number of occurrences of a business activity, per type of business activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Activities Completed Late But Successfully

Description	Number of successful activities with late completion.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Late Activities

Description	Counts the number of successfully completed business activities for which the completion exceeds the planned cycle time, per type of business activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Successful Activities

Description	Counts the number of successful completions of a business activity, per type of business activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Percentage Capex For Process

Description	Proportion of the capital expenditure (CAPEX) for the business process to the total capital expenditure of the health plan organization. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Personnel Utilization Per Activity

Description	Actual manpower in full time equivalent (FTE) days used to execute the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Personnel Requirement Per Activity

Description	Planned required manpower in full time equivalent (FTE) days to execute the business activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Process Capex Amount

Description	Capital expenditure for the process.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Business Activity Performance Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Business Activity Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Business Activity Performance Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Business Activity Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Business Activity Performance Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Business Activity Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Business Activity Performance Analysis_Health Plan Product Dimension_FK

Is Identifying Relationship	true
Child Table	Business Activity Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Health Plan Product Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Business Activity Performance Analysis_Organization Dimension_FK

Is Identifying Relationship	true
Child Table	Business Activity Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Business Activity Performance Analysis PK

Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk
Key Attribute	Health Plan Product Dk
Key Attribute	Organization Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model