Entity Service Utilization Claim Detail Analysis

DescriptionAnalysis of utilization detail allows drill downs on specific aspects of utilization and medical costs. As a result of such analysis, the health plan may undertake member and/or provider education, initiate public health or health management programs, or take other actions to control utilization and costs.

Attributes
Average Claim Payment Per Admission AmountAverage Claim Payment Per Admission Amount
Average Claim Payment Per DME Claim AmountAverage Claim Payment Per DME Claim Amount
Average Claim Payment Per ER Visit AmountAverage Claim Payment Per ER Visit Amount
Average Claim Payment Per Inpatient Day AmountAverage Claim Payment Per Inpatient Day Amount
Average Claim Payment Per Lab Claim AmountAverage Claim Payment Per Lab Claim Amount
Average Claim Payment Per Medical Claim AmountAverage Claim Payment Per Medical Claim Amount
Average Claim Payment Per Member AmountAverage Claim Payment Per Member Amount
Average Claim Payment Per Member Using Mental Health Benefit AmountAverage Claim Payment Per Member Using Mental Health Benefit Amount
Average Claim Payment Per Mental Health Claim AmountAverage Claim Payment Per Mental Health Claim Amount
Average Claim Payment Per Outpatient Surgery AmountAverage Claim Payment Per Outpatient Surgery Amount
Average Claim Payment Per Pharmacy Claim AmountAverage Claim Payment Per Pharmacy Claim Amount
Average Claim Payment Per Provider Visit AmountAverage Claim Payment Per Provider Visit Amount
Average Claim Payment Per Service AmountAverage Claim Payment Per Service Amount
Average Claim Payment Per Session AmountAverage Claim Payment Per Session Amount
Average Claim Payment Per Substance Abuse Claim AmountAverage Claim Payment Per Substance Abuse Claim Amount
Average DME Claim Payment Per Member AmountAverage DME Claim Payment Per Member Amount
Average ER Claim Payment Per Member AmountAverage ER Claim Payment Per Member Amount
Average Hospitalization Claim Payment Per Member AmountAverage Hospitalization Claim Payment Per Member Amount
Average Lab Claim Payment Per Member AmountAverage Lab Claim Payment Per Member Amount
Average Length Of Stay Per AdmissionAverage Length Of Stay Per Admission
Average Medical Claim Payment Per Member AmountAverage Medical Claim Payment Per Member Amount
Average Mental Health Claim Payment Per Member AmountAverage Mental Health Claim Payment Per Member Amount
Average Outpatient Surgery Claim Payment Per Member AmountAverage Outpatient Surgery Claim Payment Per Member Amount
Average Pharmacy Claim Payment Per Member AmountAverage Pharmacy Claim Payment Per Member Amount
Average Provider Visit Claim Payment Per Member AmountAverage Provider Visit Claim Payment Per Member Amount
Average Substance Abuse Claim Payment Per Member AmountAverage Substance Abuse Claim Payment Per Member Amount
Calendar DkCalendar Dk
Claim DkClaim Dk
Claim Payment AmountClaim Payment Amount
Claim Payments For Members With Claims Greater Than $50000Claim Payments For Members With Claims Greater Than $50000
Claim Payments For Provider Visits AmountClaim Payments For Provider Visits Amount
Claim Payments For Sessions AmountClaim Payments For Sessions Amount
Condition DkCondition Dk
Cost Of Admissions AmountCost Of Admissions Amount
Cost Of Claims For Members With Mental Health Claims AmountCost Of Claims For Members With Mental Health Claims Amount
Cost Of Encounters AmountCost Of Encounters Amount
Crude Mortality RateCrude Mortality Rate
DME Claim Payment AmountDME Claim Payment Amount
Eligible Population CountEligible Population Count
Enrollment CountEnrollment Count
ER Visits Claim Payment AmountER Visits Claim Payment Amount
Geographic Area DkGeographic Area Dk
Group DkGroup Dk
Health Plan Product DkHealth Plan Product Dk
Hospitalization Claim Payment AmountHospitalization Claim Payment Amount
Lab Claim Payment AmountLab Claim Payment Amount
Medical Claim Payment AmountMedical Claim Payment Amount
Mental Health Claim Payment AmountMental Health Claim Payment Amount
Number Of Claims Per 1000 MembersNumber Of Claims Per 1000 Members
Number Of DeathsNumber Of Deaths
Number Of DME ClaimsNumber Of DME Claims
Number Of DME Claims Per 1000 MembersNumber Of DME Claims Per 1000 Members
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 EncountersNumber Of Encounters
Number Of Encounters Per 1000 MembersNumber Of Encounters Per 1000 Members
Number Of Inpatient AdmissionsNumber Of Inpatient Admissions
Number Of Inpatient Admissions Per 1000 MembersNumber Of Inpatient Admissions Per 1000 Members
Number Of Inpatient DaysNumber Of Inpatient Days
Number Of InterventionsNumber Of Interventions
Number Of Interventions Per 1000 MembersNumber Of Interventions Per 1000 Members
Number Of Lab ClaimsNumber Of Lab Claims
Number Of Lab Claims Per 1000 MembersNumber Of Lab Claims Per 1000 Members
Number Of Medical ClaimsNumber Of Medical Claims
Number Of MembersNumber Of Members
Number Of Members With 2 Or More ER Visits In One YearNumber Of Members With 2 Or More ER Visits In One Year
Number Of Members With Claims Cost Greater Than $15000Number Of Members With Claims Cost Greater Than $15000
Number Of Members With Claims Cost Greater Than $50000Number Of Members With Claims Cost Greater Than $50000
Number Of Members With Mental Health ClaimsNumber Of Members With Mental Health Claims
Number Of Mental Health ClaimsNumber Of Mental Health Claims
Number Of Mental Health Claims Per 1000 MembersNumber Of Mental Health Claims Per 1000 Members
Number Of Outpatient SurgeriesNumber Of Outpatient Surgeries
Number Of Outpatient Surgeries Per 1000 MembersNumber Of Outpatient Surgeries Per 1000 Members
Number Of Pharmacy ClaimsNumber Of Pharmacy Claims
Number Of PrescriptionsNumber Of Prescriptions
Number Of Prescriptions Per 1000 MembersNumber Of Prescriptions Per 1000 Members
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
Number Of ServicesNumber Of Services
Number Of Services Per 1000 MembersNumber Of Services Per 1000 Members
Number Of SessionsNumber Of Sessions
Number Of Substance Abuse ClaimsNumber Of Substance Abuse Claims
Number Of Substance Abuse Claims Per 1000 MembersNumber Of Substance Abuse Claims Per 1000 Members
Outpatient Surgery Claim Payment AmountOutpatient Surgery Claim Payment Amount
Payments For Medical Services AmountPayments For Medical Services Amount
Percentage Of Eligible Population EnrollmentPercentage Of Eligible Population Enrollment
Percentage Of Total Claims Attributable To Members With Claims Greater Than $50000Percentage Of Total Claims Attributable To Members With Claims Greater Than $50000
Pharmacy Claim Payment AmountPharmacy Claim Payment Amount
Plan Member DkPlan Member Dk
Practitioner DkPractitioner Dk
Procedure Code DkProcedure Code Dk
Proportion Of DME Total Claim CostProportion Of DME Total Claim Cost
Proportion Of ER Visit Total Claim CostProportion Of ER Visit Total Claim Cost
Proportion Of Hospitalization Total Claim CostProportion Of Hospitalization Total Claim Cost
Proportion Of Lab Total Claim CostProportion Of Lab Total Claim Cost
Proportion Of Medical Total Claim CostProportion Of Medical Total Claim Cost
Proportion Of Mental Health Total Claim CostProportion Of Mental Health Total Claim Cost
Proportion Of Outpatient Surgery Total Claim CostProportion Of Outpatient Surgery Total Claim Cost
Proportion Of Pharmacy Total Claim CostProportion Of Pharmacy Total Claim Cost
Proportion Of Provider Visit Total Claim CostProportion Of Provider Visit Total Claim Cost
Proportion Of Substance Abuse Total Claim CostProportion Of Substance Abuse Total Claim Cost
Provider DkProvider Dk
Service DkService Dk
Substance Abuse Claim Payment AmountSubstance Abuse Claim Payment Amount

Relationship
Service Utilization Claim Detail Analysis_Calendar Dimension_FKService Utilization Claim Detail Analysis_Calendar Dimension_FK
Service Utilization Claim Detail Analysis_Geographic Area Dimension_FKService Utilization Claim Detail Analysis_Geographic Area Dimension_FK
Service Utilization Claim Detail Analysis_Plan Member Dimension_FKService Utilization Claim Detail Analysis_Plan Member Dimension_FK
Service Utilization Claim Detail Analysis_Condition Dimension_FKService Utilization Claim Detail Analysis_Condition Dimension_FK
Service Utilization Claim Detail Analysis_Group Dimension_FKService Utilization Claim Detail Analysis_Group Dimension_FK
Service Utilization Claim Detail Analysis_Provider Dimension_FKService Utilization Claim Detail Analysis_Provider Dimension_FK
Service Utilization Claim Detail Analysis_Practitioner Dimension_FKService Utilization Claim Detail Analysis_Practitioner Dimension_FK
Service Utilization Claim Detail Analysis_Claim Dimension_FKService Utilization Claim Detail Analysis_Claim Dimension_FK
Service Utilization Claim Detail Analysis_Service Dimension_FKService Utilization Claim Detail Analysis_Service Dimension_FK
Service Utilization Claim Detail Analysis_Procedure Code Dimension_FKService Utilization Claim Detail Analysis_Procedure Code Dimension_FK
Service Utilization Claim Detail Analysis_Health Plan Product Dimension_FKService Utilization Claim Detail Analysis_Health Plan Product Dimension_FK

Primary Key
Service Utilization Claim Detail Analysis PKService Utilization Claim Detail Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Average Claim Payment Per Admission Amount
DescriptionThe average claim payment for each admission.

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



 Average Claim Payment Per DME Claim Amount
DescriptionThe average claim payment for each durable medical equipment (DME) claim.

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



 Average Claim Payment Per ER Visit Amount
DescriptionThe average claim payment for each emergency room visit.

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



 Average Claim Payment Per Inpatient Day Amount
DescriptionThe average claim payment for each day of hospitalization.

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



 Average Claim Payment Per Lab Claim Amount
DescriptionThe average claim payment for each lab claim.

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



 Average Claim Payment Per Medical Claim Amount
DescriptionThe average claim payment for each medical claim.

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



 Average Claim Payment Per Member Amount
DescriptionAverage amount paid for 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



 Average Claim Payment Per Member Using Mental Health Benefit Amount
DescriptionCost of all claims per member for those members using mental health benefit. This measure is important as research shows that total claims costs are higher for these members and be adversely affected by restricting mental health benefits.

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



 Average Claim Payment Per Mental Health Claim Amount
DescriptionThe average payment for each mental health claim.

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



 Average Claim Payment Per Outpatient Surgery Amount
DescriptionThe average payment for each outpatient surgery claim.

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



 Average Claim Payment Per Pharmacy Claim Amount
DescriptionThe average payment for each pharmacy claim.

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



 Average Claim Payment Per Provider Visit Amount
DescriptionThe average payment for each provider visit.

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



 Average Claim Payment Per Service Amount
DescriptionThe average amount paid for each service provided.

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



 Average Claim Payment Per Session Amount
DescriptionThe average payment for each session provided.

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



 Average Claim Payment Per Substance Abuse Claim Amount
DescriptionThe average cost of each substance abuse claim.

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



 Average DME Claim Payment Per Member Amount
DescriptionThe average value of claim payments for durable medical equipment (DME) 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



 Average ER Claim Payment Per Member Amount
DescriptionThe cost of emergency room visits 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



 Average Hospitalization Claim Payment Per Member Amount
DescriptionThe cost of inpatient services 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



 Average Lab Claim Payment Per Member Amount
DescriptionLab claim payments 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



 Average Length Of Stay Per Admission
DescriptionThe average number of days patients stayed in hospital.

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 Medical Claim Payment Per Member Amount
DescriptionThe average amount paid for 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/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Average Mental Health Claim Payment Per Member Amount
DescriptionAverage mental health claim payments 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



 Average Outpatient Surgery Claim Payment Per Member Amount
DescriptionThe cost of outpatient surgery 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



 Average Pharmacy Claim Payment Per Member Amount
DescriptionAverage pharmacy claim payments 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



 Average Provider Visit Claim Payment Per Member Amount
DescriptionThe cost of provider visits 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



 Average Substance Abuse Claim Payment Per Member Amount
DescriptionAverage substance abuse claim payments 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



 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



 Claim 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



 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



 Claim Payments For Members With Claims Greater Than $50000
DescriptionSum of claim payments for members with claims greater than $50,000.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Claim Payments For Provider Visits Amount
DescriptionThe sum of the amounts paid for provider visits.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Claim Payments For Sessions Amount
DescriptionThe sum of the amounts paid for sessions.
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 Admissions Amount
DescriptionThe sum of the amounts paid for admissions.
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 Claims For Members With Mental Health Claims Amount
DescriptionOverall cost of mental health claims.
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 Encounters Amount
DescriptionThe sum of the amounts paid for encounters.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Crude Mortality Rate
DescriptionThe mortality rate from all causes within a given population during a given period of time (generally one year). May be calculated against the population at the middle of the time period or against the average population during the time period. Expressed as rate per thousand.

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



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



 Eligible Population Count
DescriptionThe total number of individuals in group who were eligible to enroll.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enrollment Count
DescriptionThe number of members of a group who enroll in a health benefits plan.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ER Visits Claim Payment Amount
DescriptionThe sum of the amounts paid for emergency room visits.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 Group 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



 Health Plan Product 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



 Hospitalization Claim Payment Amount
DescriptionThe sum of the amounts paid for admissions.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



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



 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



 Mental Health Claim Payment Amount
DescriptionThe sum of amounts paid for mental health 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 Claims Per 1000 Members
DescriptionNumber of claims per member.

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 Deaths
DescriptionThe mortality rate in the given population across the given time period, (typically a year).
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



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



 Number Of DME Claims Per 1000 Members
DescriptionNumber of durable medical equipment (DME) claims 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 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 Encounters
DescriptionThe total number of encounters.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Encounters Per 1000 Members
DescriptionNumber of encounters 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 Admissions
DescriptionThe number of number of inpatient admissions. The definition of an inpatient admission may vary by facility but typically involves 24 hours or more of clinical observation and nursing support.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Inpatient Admissions Per 1000 Members
DescriptionNumber of 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 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 1000 Members
DescriptionNumber of interventions 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 Lab Claims
DescriptionTotal number of lab claims.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Lab Claims Per 1000 Members
DescriptionNumber of lab claims per 1000 member.

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 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 With 2 Or More ER Visits In One Year
DescriptionNumber of members with 2 or more ER visits in 12-month measurement period.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members With Claims Cost Greater Than $15000
DescriptionNumber of members with claims cost greater than $15,000.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members With Claims Cost Greater Than $50000
DescriptionNumber of members with claims cost greater than $50,000.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members With Mental Health Claims
DescriptionThe number of members who have one or more claims against mental health coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



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



 Number Of Mental Health Claims Per 1000 Members
DescriptionNumber of mental health claims 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 Outpatient Surgeries
DescriptionTotal number or outpatient surgeries.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Outpatient Surgeries Per 1000 Members
DescriptionNumber of outpatient surgeries 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 Pharmacy Claims
DescriptionThe number of pharmacy claims during the period.
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 1000 Members
DescriptionNumber of prescriptions 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 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



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



 Number Of Services Per 1000 Members
DescriptionNumber of services 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 Sessions
DescriptionThe total number of sessions.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



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



 Number Of Substance Abuse Claims Per 1000 Members
DescriptionNumber of substance abuse claims 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



 Outpatient Surgery Claim Payment Amount
DescriptionThe sum of the amounts paid for outpatient surgery.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Payments For Medical Services Amount
DescriptionThe sum of the amounts paid for medical services.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of Eligible Population Enrollment
DescriptionThe percentage of number eligible individuals of a group who enroll in a health benefits plan.

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 Total Claims Attributable To Members With Claims Greater Than $50000
DescriptionClaim payments for members with claims greater than $50,000 as percent of total claim payments.

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



 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



 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



 Procedure 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



 Proportion Of DME Total Claim Cost
DescriptionDurable medical equipment (DME) claim payments as percent of total claim payments.

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



 Proportion Of ER Visit Total Claim Cost
DescriptionCost of emergency room visits as percent of total claim payments.

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



 Proportion Of Hospitalization Total Claim Cost
DescriptionHospitalization costs as percent of total claim payments.

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



 Proportion Of Lab Total Claim Cost
DescriptionLab claim payments as percent of total claim payments.

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



 Proportion Of Medical Total Claim Cost
DescriptionMedical claim payments as percent of total claim payments.

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



 Proportion Of Mental Health Total Claim Cost
DescriptionCost of mental health claims as percent of total claim payments.

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



 Proportion Of Outpatient Surgery Total Claim Cost
DescriptionCost of outpatient surgery as percent of total claim payments.

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



 Proportion Of Pharmacy Total Claim Cost
DescriptionCost of pharmacy claims as percent of total claim payments.

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



 Proportion Of Provider Visit Total Claim Cost
DescriptionCost of provider visits as percent of total claim payments.

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



 Proportion Of Substance Abuse Total Claim Cost
DescriptionCost of substance abuse claims as percent of total claim payments.

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



 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



 Service 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



 Substance Abuse Claim Payment Amount
DescriptionThe sum of amounts paid for substance abuse claim payments.
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

 Service Utilization Claim Detail Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail 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



 Service Utilization Claim Detail Analysis_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail 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



 Service Utilization Claim Detail Analysis_Plan Member Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail 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



 Service Utilization Claim Detail Analysis_Condition Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail 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



 Service Utilization Claim Detail Analysis_Group Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGroup Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Service Utilization Claim Detail Analysis_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail 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



 Service Utilization Claim Detail Analysis_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail 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



 Service Utilization Claim Detail Analysis_Claim Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableClaim Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Service Utilization Claim Detail Analysis_Service Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableService Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Service Utilization Claim Detail Analysis_Procedure Code Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProcedure Code Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Service Utilization Claim Detail Analysis_Health Plan Product Dimension_FK
Is Identifying Relationshiptrue
Child TableService Utilization Claim Detail Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableHealth Plan Product Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Service Utilization Claim Detail Analysis PK
Key AttributeCalendar Dk
Key AttributeGeographic Area Dk
Key AttributePlan Member Dk
Key AttributeCondition Dk
Key AttributeGroup Dk
Key AttributeProvider Dk
Key AttributePractitioner Dk
Key AttributeClaim Dk
Key AttributeService Dk
Key AttributeProcedure Code Dk
Key AttributeHealth Plan Product Dk