Calculated Columns (Summary Table Queries)

The calculated columns are included to give supporting information for the codes of interest.  The Enrollment summary tables for each category are used with the selected request type to calculate the rates.   

Medical Queries: HCPCS Procedures, ICD-9 Diagnoses, and ICD-9 Procedures

• Total Enrollment in Strata (Members): Total count includes members with both medical and drug coverage plus those with medical coverage only.
• Prevalence Rates: Users per 1000 enrollees
• Event Rate: Events per 1000 enrollees
• Events per Member

Drug Queries: Pharmacy Dispensings by Generic Name and Drug Class

• Total Enrollment in Strata (Members): Total count includes members with both medical and drug coverage plus those with drug coverage only.
• Prevalence Rates: Users per 1000 enrollees
• Dispensing Rate: Dispensings per 1000 enrollees
• Days per Dispensing
• Days per User