Dimensional Warehouse Model Data Model

Entity

Entity Stroke Disease Assessment And Care Analysis

Description

This Analytical Requirement addresses the assessment of patients suspected of having suffered a stroke or deemed at risk of suffering a stroke. The analysis will allow the provider or practitioner to view the incidence of strokes of various types and the impact they have on the affected population as well as the treatments given and the response of patients.

Dimensions (and sample axes of analysis):
- Calendar (Date, Reporting Period)
- Geographic Area (Region, State)
- Plan Member (Plan, Line of Business(Medicare, Medicaid, Commercial))
- Patient (Age, Gender, Smoker Status, BMI)
- Diagnosis (Stroke Type)
- Care Plan (Types of Treatment: Surgery, Medication, Rehabilitative Therapy)
- Practitioner
- Provider

Attributes
Calendar Dk
Care Plan Dk
Diagnosis Code Dk
Geographic Area Dk
Number Of Patients Assessed For Stroke
Number Of Patients Suspected Of Stroke
Number Of Patients With Diagnosis Of Stroke
Number Of Stroke Patients On Persistent Stroke Medication
Number Of Stroke Patients Receiving Rehabilitative Therapy
Number Of Stroke Patients Responding To Therapy
Number Of Stroke Patients With Impaired Cognitive Skills
Number Of Stroke Patients With Impaired Motor Skills
Number Of Stroke Patients With Impaired Speech
Number Of Stroke Patients With Surgical Intervention
Patient Dk
Percentage Of Assessed Patients With Diagnosis Of Stroke
Percentage of At Risk Patients Assessed for Stroke
Percentage Of Stroke Patients On Persistent Stroke Medication
Percentage Of Stroke Patients Receiving Rehabilitative Therapy
Percentage Of Stroke Patients Responding To Therapy
Percentage Of Stroke Patients With Impaired Cognitive Skills
Percentage Of Stroke Patients With Impaired Motor Skills
Percentage Of Stroke Patients With Impaired Speech
Percentage Of Stroke Patients With Surgical Intervention
Plan Member Dk
Practitioner Dk
Provider Dk

Relationship
Stroke Disease Assessment And Care Analysis_Care Plan Dimension_FK
Stroke Disease Assessment And Care Analysis_Diagnosis Dimension_FK
Stroke Disease Assessment And Care Analysis_Patient Dimension_FK
Stroke Disease Assessment And Care Analysis_Practitioner Dimension_FK
Stroke Disease Assessment And Care Analysis_Calendar Dimension_FK
Stroke Disease Assessment And Care Analysis_Provider Dimension_FK
Stroke Disease Assessment And Care Analysis_Geographic Area Dimension_FK
Stroke Disease Assessment And Care Analysis_Plan Member Dimension_FK

Primary Key
Stroke Disease Assessment And Care Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

Care Plan 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

Diagnosis Code 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

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

Number Of Patients Assessed For Stroke

Description	The count of patients who are suspected of having suffered a stroke or who are deemed to be at risk of stroke and who have been medically assessed to establish whether or not they have indeed suffered a stroke.
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 Patients Suspected Of Stroke

Description	The count of patients who are suspected of having suffered a stroke or who are deemed to be at risk of stroke. This may be based on age, family history or lifestyle factors. It may also be based on the patient's behavior or on the observations of a medical professional.
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 Patients With Diagnosis Of Stroke

Description	The count of patients who have been medically assessed for stroke and for whom a diagnosis of stroke has been made.
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 Stroke Patients On Persistent Stroke Medication

Description	The count of patients with a diagnosis of stroke who have been prescribed long term medication to control their condition and to prevent or reduce the impact of further incidences of stroke.
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 Stroke Patients Receiving Rehabilitative Therapy

Description	The count of patients with a diagnosis of stroke who are receiving therapy to help their recovery from the effects of the stroke. This may include speech therapy, physiotherapy and occupational therapy to help them resume their normal activities and lifestyle.
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 Stroke Patients Responding To Therapy

Description	The count of patients with a diagnosis of stroke who are receiving therapy to help their recovery and who are showing positive progress in their recovery.
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 Stroke Patients With Impaired Cognitive Skills

Description	The count of patients with a diagnosis of stroke who have a noticeable disimprovement in their cognitive skills. This may manifest itself as short term memory loss, confusion or lack of recognition of familiar objects or people among other symptoms.
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 Stroke Patients With Impaired Motor Skills

Description	The count of patients with a diagnosis of stroke who have also been diagnosed as having reduced motor skills. This can be difficulty with mobility or manipulation.
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 Stroke Patients With Impaired Speech

Description	The count of patients with a diagnosis of stroke who have an observable difficulty with speech. Stroke patients can often demonstrate slurred speech while otherwise appearing symptom free.
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 Stroke Patients With Surgical Intervention

Description	The count of patients with a diagnosis of stroke who have had surgery related to their stroke condition. This may be surgery to drain and repair internal bleeding or surgery to improve blood flow.
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

Patient 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 Of Assessed Patients With Diagnosis Of Stroke

Description	The count of patients for whom a diagnosis of stroke has been made expressed as a percentage of the number of patients who have been medically assessed for stroke. 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

Percentage of At Risk Patients Assessed for Stroke

Description	The count of patients who have been medically assessed for stroke expressed as a percentage of the number of patients who are suspected of having suffered a stroke or who are deemed to be at risk of stroke. 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

Percentage Of Stroke Patients On Persistent Stroke Medication

Description	The count of patients with a diagnosis of stroke who have been prescribed long term medication for their stroke condition expressed as a percentage of the number of patients with a diagnosis of stroke. 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

Percentage Of Stroke Patients Receiving Rehabilitative Therapy

Description	The count of patients with a diagnosis of stroke who are receiving therapy to help their recovery from the effects of the stroke expressed as a percentage of the number of patients with a diagnosis of stroke. 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

Percentage Of Stroke Patients Responding To Therapy

Description	The count of patients with a diagnosis of stroke who are receiving rehabilitative therapy and who are showing positive progress in their recovery expressed as a percentage of the number of patients who are receiving such therapy. 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

Percentage Of Stroke Patients With Impaired Cognitive Skills

Description	The count of patients with a diagnosis of stroke who have a noticeable dis-improvement in their cognitive skills expressed as a percentage of the number of patients with a diagnosis of stroke. 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

Percentage Of Stroke Patients With Impaired Motor Skills

Description	The count of patients with a diagnosis of stroke who have also been diagnosed as having reduced motor skills expressed as a percentage of the number of patients with a diagnosis of stroke. 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

Percentage Of Stroke Patients With Impaired Speech

Description	The count of patients with a diagnosis of stroke who have an observable difficulty with speech expressed as a percentage of the number of patients with a diagnosis of stroke. 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

Percentage Of Stroke Patients With Surgical Intervention

Description	The count of patients with a diagnosis of stroke who have had surgery related to their stroke condition expressed as a percentage of the number of patients with a diagnosis of stroke. 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

Plan Member 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

Practitioner 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

Provider 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

Relationship Details

Stroke Disease Assessment And Care Analysis_Care Plan Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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	Care Plan Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Stroke Disease Assessment And Care Analysis_Diagnosis Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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	Diagnosis Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Stroke Disease Assessment And Care Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Stroke Disease Assessment And Care Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Stroke Disease Assessment And Care Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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

Stroke Disease Assessment And Care Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Stroke Disease Assessment And Care Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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

Stroke Disease Assessment And Care Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Stroke Disease Assessment And Care 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	Plan Member 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

Stroke Disease Assessment And Care Analysis PK

Key Attribute	Care Plan Dk
Key Attribute	Diagnosis Code Dk
Key Attribute	Plan Member Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model