Dimensional Warehouse Model Data Model

Entity

Entity Cancer Screening And Care Analysis

Description

This Analytical Requirement addresses the screening of patients deemed to be at risk of developing various forms of cancer and the treatment of those patients with cancer diagnoses. The analysis is generic and applicable to many cancers. Further analysis would be required to consider the specific conditions and treatments appropriate to a particular form of cancer.

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 (Primary Cancer Type)
- Care Plan (Types of treatment: Surgery, Radiotherapy, Chemotherapy, Combined therapies)
- Practitioner
- Provider

Attributes
Average Cancerous Tumor Count Per Cancer Patient
Average Cancerous Tumor Size
Calendar Dk
Care Plan Dk
Diagnosis Code Dk
Geographic Area Dk
Number Of Cancerous Tumors Detected
Number Of Cancer Patients Given Curative Therapy
Number Of Cancer Patients Given Palliative Care
Number Of Cancer Patients In Remission
Number Of Cancer Patients In Remission After 5 Years
Number Of Cancer Patients With Secondary Infections
Number Of Patients At Risk Of Cancer
Number Of Patients Screened for Cancer
Number Of Patients With Diagnosis Of Cancer
Patient Dk
Percentage Of At Risk Patients Screened for Cancer
Percentage Of Cancer Patients Given Curative Therapy
Percentage Of Cancer Patients Given Palliative Care
Percentage Of Cancer Patients In Remission After 5 Years
Percentage Of Cancer Patients With Secondary Infections
Percentage Of Screened Patients With Diagnosis Of Cancer
Plan Member Dk
Practitioner Dk
Provider Dk
Size Of Cancerous Tumors

Relationship
Cancer Screening And Care Analysis_Calendar Dimension_FK
Cancer Screening And Care Analysis_Patient Dimension_FK
Cancer Screening And Care Analysis_Care Plan Dimension_FK
Cancer Screening And Care Analysis_Practitioner Dimension_FK
Cancer Screening And Care Analysis_Provider Dimension_FK
Cancer Screening And Care Analysis_Geographic Area Dimension_FK
Cancer Screening And Care Analysis_Plan Member Dimension_FK
Cancer Screening And Care Analysis_Diagnosis Code Dimension_FK

Primary Key
Cancer Screening And Care Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Cancerous Tumor Count Per Cancer Patient

Description	The count malignant tumors in patients with a diagnosis of cancer expressed as a average over the number of cancer patients. 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 Cancerous Tumor Size

Description	The size (typically mass) of malignant tumors in patients with a diagnosis of cancer expressed as a average over the number of cancerous tumors. 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

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 Cancerous Tumors Detected

Description	The count malignant tumors in patients with a diagnosis of cancer.
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 Cancer Patients Given Curative Therapy

Description	The count of patients with a diagnosis of cancer who were treated with the objective of eliminating the cancer and leaving the patient cancer 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 Cancer Patients Given Palliative Care

Description	The count of patients with a diagnosis of cancer who were treated with the objective of maintaining their quality of life and eliminating or reducing pain and discomfort rather than attempting to eliminate the cancer. This may be the course of treatment applied where the cancer is deemed to be inoperative or incurable due to its advanced stage, the patients age or general health or where the risks associated with an intervention are judged to be too great.
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 Cancer Patients In Remission

Description	The count of patients with a diagnosis of cancer who after treatment are deemed to be cancer 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 Cancer Patients In Remission After 5 Years

Description	The count of patients with a diagnosis of cancer who after treatment are deemed to be cancer free and who remain cancer free for a period of 5 years or more.
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 Cancer Patients With Secondary Infections

Description	The count of patients with a diagnosis of cancer who were identified as having secondary cancerous infections. This is often the case where detection of the primary cancer is delayed and the infection has spread to adjoining organs or tissue. Secondary infections can also be detected in the course of treatment of the primary cancer over extended periods.
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 At Risk Of Cancer

Description	The count of patients deemed to be at risk of developing cancer. This may be based on age and / or gender for conditions such as breast cancer or prostate cancer or it may be based on family history or lifestyle factors.
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 Screened for Cancer

Description	The count of patients deemed to be at risk of developing cancer who were screened for the presence of the cancer.
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 Cancer

Description	The count of patients who were screened for cancer and for whom a diagnosis of the cancerous condition was 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

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 At Risk Patients Screened for Cancer

Description	The number of patients deemed to be at risk of developing cancer who were screened for the condition expressed as a percentage of the number of patients at risk. 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 Cancer Patients Given Curative Therapy

Description	The count of patients with a diagnosis of cancer who were treated with the objective of eliminating the cancer and leaving the patient cancer free expressed as a percentage of the number of cancer patients. 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 Cancer Patients Given Palliative Care

Description	The count of patients with a diagnosis of cancer who were treated with the objective of maintaining their quality of life and eliminating or reducing pain and discomfort rather than attempting to eliminate the cancer expressed as a percentage of the number of cancer patients. 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 Cancer Patients In Remission After 5 Years

Description	The count of patients with a diagnosis of cancer who after treatment are deemed to be cancer free and who remain cancer free for a period of 5 years or more expressed as a percentage of the number of cancer patients. 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 Cancer Patients With Secondary Infections

Description	The count of patients with a diagnosis of cancer who were identified as having secondary cancerous infections expressed as a percentage of the number of cancer patients. 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 Screened Patients With Diagnosis Of Cancer

Description	The number of patients who were screened for cancer and who had a diagnosis of cancer expressed as a percentage of the number of patients screened. 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

Size Of Cancerous Tumors

Description	The size (typically mass) of malignant tumors in patients with a diagnosis of cancer.
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

Relationship Details

Cancer Screening And Care Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Care Plan Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Cancer Screening And Care Analysis_Diagnosis Code Dimension_FK

Is Identifying Relationship	true
Child Table	Cancer Screening 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

Primary Key Details

Cancer Screening And Care Analysis PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model