Entity Healthcare Program Selection And Member Target Analysis

DescriptionThe 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.

Attributes
Average Days Absent Per MemberAverage Days Absent Per Member
Average Length Of Stay Per AdmissionAverage Length Of Stay Per Admission
Calendar DkCalendar Dk
Claims Payment AmountClaims Payment Amount
Condition DkCondition Dk
Cost Of Managing Patients Diagnosed With Disease AmountCost Of Managing Patients Diagnosed With Disease Amount
Cost Of Program AmountCost Of Program Amount
Cost Of Program Per Participant AmountCost Of Program Per Participant Amount
Cost Per Member Diagnosed With Disease AmountCost Per Member Diagnosed With Disease Amount
Diagnosis Code DkDiagnosis Code Dk
Geographic Area DkGeographic Area Dk
Medical Claims Payment AmountMedical Claims Payment Amount
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 Inpatient Days Per 1000 MembersNumber Of Inpatient Days Per 1000 Members
Number Of InterventionsNumber Of Interventions
Number Of Interventions Per ParticipantNumber Of Interventions Per Participant
Number Of Medical ClaimsNumber Of Medical Claims
Number Of Medical Claims Per MemberNumber Of Medical Claims Per Member
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 Diagnosed Members EnrolledPercentage Of Diagnosed Members Enrolled
Percentage Of Members Diagnosed With DiseasePercentage Of Members Diagnosed With Disease
Pharmacy Claims Payment AmountPharmacy Claims Payment Amount
Pharmacy Claims Payment Per Member AmountPharmacy Claims Payment Per Member Amount
Plan Member DkPlan Member Dk

Relationship
Healthcare Program Selection And Member Target Analysis_Calendar Dimension_FKHealthcare Program Selection And Member Target Analysis_Calendar Dimension_FK
Healthcare Program Selection And Member Target Analysis_Geographic Area Dimension_FKHealthcare Program Selection And Member Target Analysis_Geographic Area Dimension_FK
Healthcare Program Selection And Member Target Analysis_Condition Dimension_FKHealthcare Program Selection And Member Target Analysis_Condition Dimension_FK
Healthcare Program Selection And Member Target Analysis_Diagnosis Code Dimension_FKHealthcare Program Selection And Member Target Analysis_Diagnosis Code Dimension_FK
Healthcare Program Selection And Member Target Analysis_Plan Member Dimension_FKHealthcare Program Selection And Member Target Analysis_Plan Member Dimension_FK
Healthcare Program Selection And Member Target Analysis_Patient Dimension_FKHealthcare Program Selection And Member Target Analysis_Patient Dimension_FK

Primary Key
Healthcare Program Selection And Member Target Analysis PKHealthcare Program Selection And Member Target 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



 Claims 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



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



 Cost Of Program Amount
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



 Cost Of Program Per Participant Amount
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 Amount
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



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



 Geographic Area 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



 Medical Claims 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



 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/Decimal Float [FLOAT(15)]
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
DescriptionThe 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/Decimal Float [FLOAT(15)]
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/Decimal Float [FLOAT(15)]
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 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/Decimal Float [FLOAT(15)]
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.

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 Medical Claims 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 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 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 performed 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/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Provider Visits
DescriptionNumber of visits by members to healthcare 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 healthcare 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/Decimal 9 [DECIMAL(19,9)]
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 Diagnosed Members Enrolled
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 Claims Payment Amount
DescriptionThe total monetary value of 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



 Pharmacy Claims Payment Per Member Amount
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



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

Relationship Details

 Healthcare Program Selection And Member Target Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableHealthcare Program Selection And Member Target 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



 Healthcare Program Selection And Member Target Analysis_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TableHealthcare Program Selection And Member Target Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeographic Area Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Healthcare Program Selection And Member Target Analysis_Condition Dimension_FK
Is Identifying Relationshiptrue
Child TableHealthcare Program Selection And Member Target 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



 Healthcare Program Selection And Member Target Analysis_Diagnosis Code Dimension_FK
Is Identifying Relationshiptrue
Child TableHealthcare Program Selection And Member Target Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableDiagnosis Code Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Healthcare Program Selection And Member Target Analysis_Plan Member Dimension_FK
Is Identifying Relationshiptrue
Child TableHealthcare Program Selection And Member Target Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePlan Member Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Healthcare Program Selection And Member Target Analysis_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TableHealthcare Program Selection And Member Target 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

Primary Key Details

 Healthcare Program Selection And Member Target Analysis PK
Key AttributeCalendar Dk
Key AttributeGeographic Area Dk
Key AttributeCondition Dk
Key AttributeDiagnosis Code Dk
Key AttributePlan Member Dk
Key AttributePatient Dk