| Dimensional Warehouse Model Data Model |
| Description | The analysis to identify health management programs, such as specific disease management programs, that the healthcare organization may wish to establish and to identify those patients or members who might benefit most from participation in such programs. The healthcare organization will want to consider the disease-specific morbidity and risk as well as the costs and potential benefits to be achieved in deciding which programs to offer. |
| Primary Key | |
Healthcare Program Selection And Member Target Analysis PK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Average Days Absent Per Member
| Description | Total number of days absent from school or work in the measurement period. 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 Length Of Stay Per Admission
| Description | The average number of inpatient days for each admission. 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 |
Claims Payment Amount
| Description | The total amount of claim payments made to healthcare providers. |
| 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 |
Condition 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 |
Cost Of Managing Patients Diagnosed With Disease Amount
| Description | Total cost of managing patients diagnosed with disease, including all claims as well as costs of the disease management program. Formula: [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 |
Cost Of Program Amount
| Description | Cost of the disease management program including vendor fees and the cost of health plan resources. |
| 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 |
Cost Of Program Per Participant Amount
| Description | Cost per member of the disease management program including vendor fees and the cost of health plan resources. Formula: [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 |
Cost Per Member Diagnosed With Disease Amount
| Description | Cost per member diagnosed with disease, including all claims as well as costs of the disease management program. Formula: [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 |
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 |
Medical Claims Payment Amount
| Description | Sum of amounts paid for medical claims. |
| 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 |
Number Of Admissions
| Description | The total number of patient admissions. |
| 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 Admissions Per 1000 Members
| Description | The total number of inpatient admissions per 1000 members. Formula: [(A/B)*1000] (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 |
Number Of Days Absent
| Description | Total number of days absent from school or work in the measurement period for patients with the disease. |
| 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 Disease-specific Mortalities
| Description | The total number of deaths caused by the disease. |
| 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 Disease-specific Mortalities Per 1000 Patients
| Description | The disease-specific mortality rate per thousand patients. Formula: [(A/B)*1000] (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 |
Number Of Emergency Room Visits
| Description | Total number or emergency room visits. |
| 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 Emergency Room Visits Per 1000 Members
| Description | Number of emergency room visits per 1000 members. Formula: [(A/B)*1000] (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 |
Number Of Inpatient Days
| Description | The number of days patients were in hospital. |
| 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 Inpatient Days Per 1000 Members
| Description | The average number of inpatient days per 1000 members. Formula: [(A/B)*1000] (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 |
Number Of Interventions
| Description | The total number of interventions or interactions between participants and program staff. |
| 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 Interventions Per Participant
| Description | Average number of interventions. 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 |
Number Of Medical Claims
| Description | Total number of medical claims. |
| 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 Medical Claims Per Member
| Description | Number of medical claims per member. 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 |
Number Of Members
| Description | The 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 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 Members Diagnosed With Disease
| Description | The number of members of a health plan or a particular group that have a particular disease. Relevant to determining to value and effectiveness of disease management program. |
| 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 Participants Enrolled
| Description | Number of members participating in the program. |
| 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 Prescriptions
| Description | The count of prescriptions for drugs or other treatments. A prescription is typically an order written by a healthcare professional for a drug or other treatment for a patient. |
| 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 Prescriptions Per Member
| Description | Number of prescriptions per member. 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 |
Number Of Procedures
| Description | Number of procedures performed. |
| 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 Procedures Per 1000 Members
| Description | Number of procedures performed per 1000 members. Formula: [(A/B)*1000] (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 |
Number Of Provider Visits
| Description | Number of visits by members to healthcare providers. |
| 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 Provider Visits Per 1000 Members
| Description | Number of healthcare provider visits per 1000 members. Formula: [(A/B)*1000] (see dependencies and their labels for measures used in the formula) |
| Data Type | Standards - Data Domains.ddm/Data Domains/Decimal 9 [DECIMAL(19,9)] |
| 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 Diagnosed Members Enrolled
| Description | The percentage of members of a health plan with a particular disease that participate in the relevant disease management program. 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 Members Diagnosed With Disease
| Description | The percentage of members of a health plan or a particular group that have a particular disease. Relevant to determining to value and effectiveness of disease management program. 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 |
Pharmacy Claims Payment Amount
| Description | The total monetary value of pharmacy claims. |
| 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 |
Pharmacy Claims Payment Per Member Amount
| Description | Cost of pharmacy claims per member. Formula: [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 |
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 |
| Relationship Details |
Healthcare Program Selection And Member Target Analysis_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Healthcare Program Selection And Member Target 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 |
Healthcare Program Selection And Member Target Analysis_Geographic Area Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Healthcare Program Selection And Member Target 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 |
Healthcare Program Selection And Member Target Analysis_Condition Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Healthcare Program Selection And Member Target 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 | Condition Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Healthcare Program Selection And Member Target Analysis_Diagnosis Code Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Healthcare Program Selection And Member Target 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 |
Healthcare Program Selection And Member Target Analysis_Plan Member Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Healthcare Program Selection And Member Target 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 |
Healthcare Program Selection And Member Target Analysis_Patient Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Healthcare Program Selection And Member Target 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 |
| Primary Key Details |
Healthcare Program Selection And Member Target Analysis PK
| Key Attribute | Calendar Dk |
| Key Attribute | Geographic Area Dk |
| Key Attribute | Condition Dk |
| Key Attribute | Diagnosis Code Dk |
| Key Attribute | Plan Member Dk |
| Key Attribute | Patient Dk |
| Dimensional Warehouse Model Data Model |