Entity Chronic Disease Management Analysis

DescriptionThe analysis of the management of members with any type of chronic medical condition allowing the healthcare provider to assess the success of the disease management program through the health status of affected members. Includes analysis of factors that affects risk, reflects successful management, or represents treatment or follow-up for a patient.

Attributes
Average Days Absent Per MemberAverage Days Absent Per Member
Average Length Of Stay Per AdmissionAverage Length Of Stay Per Admission
Calendar DkCalendar Dk
Condition DkCondition Dk
Cost Of Program Per Enrolled MemberCost Of Program Per Enrolled Member
Cost Per Member Diagnosed With DiseaseCost Per Member Diagnosed With Disease
Encounter DkEncounter Dk
Inpatient Days Per 1000 MembersInpatient Days Per 1000 Members
Medical Claims Paid Per MemberMedical Claims Paid Per Member
Number Of AdmissionsNumber Of Admissions
Number Of Admissions Per 1000 MembersNumber Of Admissions Per 1000 Members
Number Of Days AbsentNumber Of Days Absent
Number Of Disease-specific MortalitiesNumber Of Disease-specific Mortalities
Number Of Disease-specific Mortalities Per 1000 PatientsNumber Of Disease-specific Mortalities Per 1000 Patients
Number Of Emergency Room VisitsNumber Of Emergency Room Visits
Number Of Emergency Room Visits Per 1000 MembersNumber Of Emergency Room Visits Per 1000 Members
Number Of Inpatient DaysNumber Of Inpatient Days
Number Of InterventionsNumber Of Interventions
Number Of Interventions Per ParticipantNumber Of Interventions Per Participant
Number Of Medical ClaimsNumber Of Medical Claims
Number Of MembersNumber Of Members
Number Of Members Diagnosed With DiseaseNumber Of Members Diagnosed With Disease
Number Of Participants EnrolledNumber Of Participants Enrolled
Number Of PrescriptionsNumber Of Prescriptions
Number Of Prescriptions Per MemberNumber Of Prescriptions Per Member
Number Of ProceduresNumber Of Procedures
Number Of Procedures Per 1000 MembersNumber Of Procedures Per 1000 Members
Number Of Provider VisitsNumber Of Provider Visits
Number Of Provider Visits Per 1000 MembersNumber Of Provider Visits Per 1000 Members
Patient DkPatient Dk
Percentage Of Affected Members Enrolled In DM ProgramPercentage Of Affected Members Enrolled In DM Program
Percentage Of Members Diagnosed With DiseasePercentage Of Members Diagnosed With Disease
Pharmacy Claim Payments Per MemberPharmacy Claim Payments Per Member
Point Of Care Location DkPoint Of Care Location Dk
Practitioner DkPractitioner Dk
Provider DkProvider Dk
Total Claim Payment AmountTotal Claim Payment Amount
Total Cost Of Managing Patients Diagnosed With DiseaseTotal Cost Of Managing Patients Diagnosed With Disease
Total Cost Of ProgramTotal Cost Of Program
Total Medical Claim Payment AmountTotal Medical Claim Payment Amount
Total Pharmacy Claim Payment AmountTotal Pharmacy Claim Payment Amount

Relationship
Chronic Disease Management Analysis_Provider Dimension_FKChronic Disease Management Analysis_Provider Dimension_FK
Chronic Disease Management Analysis_Patient Dimension_FKChronic Disease Management Analysis_Patient Dimension_FK
Chronic Disease Management Analysis_Encounter Dimension_FKChronic Disease Management Analysis_Encounter Dimension_FK
Chronic Disease Management Analysis_Practitioner Dimension_FKChronic Disease Management Analysis_Practitioner Dimension_FK
Chronic Disease Management Analysis_Condition Dimension_FKChronic Disease Management Analysis_Condition Dimension_FK
Chronic Disease Management Analysis_Point Of Care Location Dimension_FKChronic Disease Management Analysis_Point Of Care Location Dimension_FK
Chronic Disease Management Analysis_Calendar Dimension_FKChronic Disease Management Analysis_Calendar Dimension_FK

Primary Key
Chronic Disease Management Analysis PKChronic Disease Management Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Average Days Absent Per Member
DescriptionTotal 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 TypeStandards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Length Of Stay Per Admission
DescriptionThe average number of inpatient days for each admission.

Formula: [A/B]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
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



 Condition 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



 Cost Of Program Per Enrolled Member
DescriptionCost 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 TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Cost Per Member Diagnosed With Disease
DescriptionCost 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 TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Encounter 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



 Inpatient Days Per 1000 Members
DescriptionThe average number of inpatient days per 1000 members.

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



 Medical Claims Paid Per Member
DescriptionNumber of medical claims per member.

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



 Number Of Admissions
DescriptionThe total number of patient admissions.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Admissions Per 1000 Members
DescriptionThe total number of inpatient admissions per 1000 members.

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



 Number Of Days Absent
DescriptionTotal number of days absent from school or work in the measurement period for patients with the disease.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Disease-specific Mortalities
DescriptionTotal number of disease-specific mortalities. Total number of deaths caused by the disease.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Disease-specific Mortalities Per 1000 Patients
DescriptionThe disease-specific mortality rate per thousand patients.

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



 Number Of Emergency Room Visits
DescriptionTotal number or emergency room visits.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Emergency Room Visits Per 1000 Members
DescriptionNumber of emergency room visits per 1000 members.

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



 Number Of Inpatient Days
DescriptionThe number of days patients were in hospital.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Interventions
DescriptionThe total number of interventions or interactions between participants and program staff.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Interventions Per Participant
DescriptionAverage number of interventions for members or patients participating in the program.

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



 Number Of Medical Claims
DescriptionTotal number of medical claims.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members Diagnosed With Disease
DescriptionThe number of members of a health plan or a particular group that have a particular disease. Relevant, e.g., to determining to value and effectiveness of disease management program.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Participants Enrolled
DescriptionNumber of members participating in the program.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Prescriptions
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Prescriptions Per Member
DescriptionNumber of prescriptions per member.

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



 Number Of Procedures
DescriptionNumber of procedures performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Procedures Per 1000 Members
DescriptionNumber of procedures per 1000 members.

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



 Number Of Provider Visits
DescriptionNumber of visits to providers.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Provider Visits Per 1000 Members
DescriptionNumber of provider visits per 1000 members.

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



 Patient 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 Of Affected Members Enrolled In DM Program
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of Members Diagnosed With Disease
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pharmacy Claim Payments Per Member
DescriptionCost of pharmacy claims per 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



 Point Of Care Location 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



 Practitioner 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



 Provider 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



 Total Claim Payment Amount
DescriptionThe total amount of claim payments made to healthcare providers.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Total Cost Of Managing Patients Diagnosed With Disease
DescriptionTotal cost of managing patients diagnosed with disease, including all claims as well as costs of the disease management program.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Total Cost Of Program
DescriptionCost of the disease management program including vendor fees and the cost of health plan resources.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Total Medical Claim Payment Amount
DescriptionSum of amounts paid for medical claims.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Total Pharmacy Claim Payment Amount
DescriptionSum of amounts paid for pharmacy claims.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Chronic Disease Management Analysis_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Chronic Disease Management Analysis_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Chronic Disease Management Analysis_Encounter Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEncounter Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Chronic Disease Management Analysis_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Chronic Disease Management Analysis_Condition Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCondition Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Chronic Disease Management Analysis_Point Of Care Location Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Chronic Disease Management Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableChronic Disease Management 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

Primary Key Details

 Chronic Disease Management Analysis PK
Key AttributeProvider Dk
Key AttributePatient Dk
Key AttributeEncounter Dk
Key AttributePractitioner Dk
Key AttributeCondition Dk
Key AttributePoint Of Care Location Dk
Key AttributeCalendar Dk