TCH +X7NKUZKS/XiTb34w3CxY8RgywlWXVqt4UvtxGEYIC/Des2vTUhzvEVM1exhmGDrg3D7K0VRo6TiWtnc6XRps/laaQthTHvdb029hWfY4Tf1IOEJYgMx+WlcuRxqPWHX0TbPCcZZysjtSbXow0nge9hSyetWUULx4kkVWGqEsUbeWvWIyFmr3XBbpZBhWGEb3myJwklZks0= TCH TCH Current +WzfiU0F2e1vXaH46gTjKt5sgQvFTfPxy0v13Hws4afDfNEp3Vd6meFGucRpACB75HRlqE0F881hSbmAaRjn68R4wwlLVEKBansl3OpcJV7CyNsJS0zDzUZh0ZhkHHcvwlpT7chWe+1rd9WAww== TCH Current dashboard_clinic_new_repeat_users_by_month clndr_quarter,System.String monthorder,System.Int64 months,System.String new_users,System.Int64 repeat_users,System.Int64 30 dashboard_clinic_new_repeat_users_by_month TCH select * from dashboard_clinic_new_repeat_users_by_month dashboard_clinic_visits_by_age ageband,System.String claims,System.Int64 patients,System.Int64 30 dashboard_clinic_visits_by_age TCH select * from dashboard_clinic_visits_by_age dashboard_clinic_visits_by_day claims,System.Int64 patients,System.Int64 Week_Day,System.String 30 dashboard_clinic_visits_by_day TCH select * from dashboard_clinic_visits_by_day where week_day <> 'Sat' dashboard_chronic_count_employees chronic_condition_count,System.String patients,System.Int64 30 dashboard_chronic_count_employees TCH select * from dashboard_chronic_count_employees dashboard_employee_a1c_scores ord,System.Int64 patients,System.Int64 score,System.String 30 dashboard_employee_a1c_scores TCH select * from dashboard_employee_a1c_scores dashboard_chronic_conditions_employees Clinic,System.Int64 Condition,System.String No_Doctor,System.Int64 patients,System.Int64 PCP,System.Int64 30 dashboard_chronic_conditions_employees TCH select * from dashboard_chronic_conditions_employees chronic_yearly_comparison Condition,System.String DX2008,System.Int64 DX2009,System.Int64 DX2010,System.Int64 DX2011,System.Int64 DXRTM,System.Int64 30 chronic_yearly_comparison TCH select * from chronic_yearly_comparison chronic_yearly_comparison2 Asthma,System.Int64 CHF,System.Int64 COPD,System.Int64 Diabetes,System.Int64 Ischemic,System.Int64 Model,System.String 30 chronic_yearly_comparison2 TCH select * from chronic_yearly_comparison dashboard_chronic_conditions_employees2 Clinic,System.Int64 Condition,System.String No_Doctor,System.Int64 patients,System.Int64 PCP,System.Int64 30 dashboard_chronic_conditions_employees2 TCH select * from dashboard_chronic_conditions_employees chronic_yearly_comparison_PRI _x0032_009,System.Double _x0032_010,System.Double _x0032_011,System.Double _x0032_012,System.Double _x0032_013,System.Double Condition,System.String 30 chronic_yearly_comparison_PRI TCH select * from chronic_yearly_comparison_PRI chronic_yearly_comparison_PRI2 Asthma,System.Double CHF,System.Double COPD,System.Double Diabetes,System.Double Hypertension,System.Double Low_x0020_Back_x0020_Pain,System.Double Model,System.String 30 chronic_yearly_comparison_PRI2 TCH select * from chronic_yearly_comparison_PRI dashboard_admits_readmits_er Admits,System.Int64 ER_Visits,System.Int64 modelgroup,System.String Readmits,System.Int64 30 dashboard_admits_readmits_er TCH select * from dashboard_admits_readmits_er dashboard_Preventive_Exams Exam,System.String testresult,System.Double 30 dashboard_Preventive_Exams TCH select Exam, testresult*100 as testresult from (select 'Mammogram' as Exam, Mammogram as testresult from dashboard_Preventive_Exams union select 'PSA' as Exam, PSA as testresult from dashboard_Preventive_Exams union select 'Cholesterol' as Exam, cholesterol as testresult from dashboard_Preventive_Exams ) a order by case when Exam = 'Mammogram' then 1 when Exam = 'PSA' then 2 else 3 end dashboard_gross_cost_PEPM PlanType,System.String Y1Y2Trend,System.Decimal Y2Y3Trend,System.Decimal Year_x0020_1,System.Decimal Year_x0020_2,System.Decimal YTD,System.Decimal 30 dashboard_gross_cost_PEPM TCH select * from dashboard_gross_cost_PEPM Gross Cost Header Row Year1,System.Int32 Year2,System.Int32 trend1,System.String Year3,System.Int32 trend2,System.String 30 Gross Cost Header Row TCH select year(getdate())-2 as Year1, year(getdate())-1 as Year2, 'Trend' as trend1, year(getdate()) as Year3, 'Trend' as trend2 MPR condition,System.String MPR,System.Double 30 MPR TCH Current select Condition, MPR from ( select 'Diabetes' as condition, avg(convert(float,diabetes_mpr)) as MPR from foundation_tch_current.dbo.acg_results_10 where diabetes_condition <> 'NP' and modelgroup = 'current' union select 'Hyperlipidemia' as condition, avg(convert(float,disorders_of_lipid_metabolism_mpr)) as MPR from acg_results_10 where disorders_of_lipid_metabolism_condition <> 'NP' and modelgroup = 'current' union select 'Asthma' as condition, avg(convert(float,persistent_asthma_mpr)) as MPR from acg_results_10 where persistent_asthma_condition <> 'NP' and modelgroup = 'current' union select 'Hypertension' as condition, avg(convert(float,Hypertension_mpr)) as MPR from acg_results_10 where Hypertension_condition <> 'NP' and modelgroup = 'current' ) a dashboard_condition_management_enrollment Employees,System.Int64 Enrolled,System.Int64 Not_x0020_Enrolled,System.Int64 percent_enrolled,System.Double Program,System.String 30 dashboard_condition_management_enrollment TCH select * from dashboard_condition_management_enrollment avg_cost_per_chronic Condition,System.String Employees,System.Int32 avg_cost,System.Decimal 30 avg_cost_per_chronic TCH Current select 'Diabetes' as Condition, sum(case when b.empdep = 'E' then 1 else 0 end) as Employees, avg(total_cost) as avg_cost from acg_results_10 a left join elg b on a.patient_id = b.ptid where modelgroup = 'current' and diabetes_condition <> 'NP' union select 'COPD' as Condition, sum(case when b.empdep = 'E' then 1 else 0 end) as Employees, avg(total_cost) as avg_cost from acg_results_10 a left join elg b on a.patient_id = b.ptid where modelgroup = 'current' and chronic_obstructive_pulmonary_disease_condition <> 'NP' union select 'CHF' as Condition, sum(case when b.empdep = 'E' then 1 else 0 end) as Employees, avg(total_cost) as avg_cost from acg_results_10 a left join elg b on a.patient_id = b.ptid where modelgroup = 'current' and congestive_heart_failure_condition <> 'NP' union select 'CAD' as Condition, sum(case when b.empdep = 'E' then 1 else 0 end) as Employees, avg(total_cost) as avg_cost from acg_results_10 a left join elg b on a.patient_id = b.ptid where modelgroup = 'current' and ischemic_heart_disease_condition <> 'NP' Potential Cost of Chronic Conditions Condition,System.String Potential_Cost,System.Double 30 Potential Cost of Chronic Conditions TCH Current select Condition, (PRI * patients * (select avg(total_cost) from acg_results_10 where modelgroup = 'current'))/1000000 as Potential_Cost from ( select 'Hypertension' as Condition, count(*) as patients, avg(unscaled_total_cost_resource_index) as PRI from acg_results_10 where modelgroup = 'current' and hypertension_condition <> 'NP' union select 'Hyperlipidemia' as Condition, count(*) as patients, avg(unscaled_total_cost_resource_index) as PRI from acg_results_10 where modelgroup = 'current' and disorders_of_lipid_metabolism_condition <> 'NP' union select 'Depression' as Condition, count(*) as patients, avg(unscaled_total_cost_resource_index) as PRI from acg_results_10 where modelgroup = 'current' and depression_condition <> 'NP' union select 'Diabetes' as Condition, count(*) as patients, avg(unscaled_total_cost_resource_index) as PRI from acg_results_10 where modelgroup = 'current' and diabetes_condition <> 'NP' union select 'Asthma' as Condition, count(*) as patients, avg(unscaled_total_cost_resource_index) as PRI from acg_results_10 where modelgroup = 'current' and persistent_asthma_condition <> 'NP' union select 'Low Back Pain' as Condition, count(*) as patients, avg(unscaled_total_cost_resource_index) as PRI from acg_results_10 where modelgroup = 'current' and low_back_pain_condition <> 'NP' ) x dashboard_condition_management_enrollment2 Employees,System.Int64 Enrolled,System.Int64 Not_x0020_Enrolled,System.Int64 percent_enrolled,System.Double Program,System.String 30 dashboard_condition_management_enrollment2 TCH select * from dashboard_condition_management_enrollment dashboard_generalists_vs_specialists cohort,System.String HMO,System.Double PPO,System.Double 30 dashboard_generalists_vs_specialists TCH select * from dashboard_generalists_vs_specialists dashboard_er_frequency_chart Clinic_x0020_Members,System.Double Diabetic_x0020_Clinic_x0020_Members,System.Double Diabetic_x0020_Members,System.Double Measure,System.String Members,System.Double Year,System.String 30 dashboard_er_frequency_chart TCH select * from dashboard_er_frequency_chart where [Year] >= year(getdate()) - 3 dashboard_ip_frequency_chart Clinic_x0020_Members,System.Double Diabetic_x0020_Clinic_x0020_Members,System.Double Diabetic_x0020_Members,System.Double Measure,System.String Members,System.Double Year,System.String 30 dashboard_ip_frequency_chart TCH select * from dashboard_ip_frequency_chart where [Year] >= year(getdate()) - 3 dashboard_diabetic_screenings_chart A1c_x0020_N,System.Double A1c_x0020_Y,System.Double Eye_x0020_N,System.Double Eye_x0020_Y,System.Double Microalbumin_x0020_N,System.Double Microalbumin_x0020_Y,System.Double YR,System.Int64 30 dashboard_diabetic_screenings_chart TCH select * from dashboard_diabetic_screenings_chart where YR >= year(getdate()) - 3 dashboard_a1c Clinic_x0020_Users,System.Double Measure,System.String Non_x0020_Clinic_x0020_Users,System.Double yr,System.Int64 30 dashboard_a1c TCH select * from dashboard_a1c where measure = 'A1c' and yr >= year(getdate()) -2 dashboard_mammogram_pap_chart Mammogram_x0020_N,System.Double Mammogram_x0020_Y,System.Double Measure,System.String Pap_x0020_N,System.Double Pap_x0020_Y,System.Double Year,System.Int64 30 dashboard_mammogram_pap_chart TCH select * from dashboard_mammogram_pap_chart where [year] >= year(getdate()) -3 EngineV2 None;Black;2;Solid;False;4;Black Transparent Black Transparent 3,0.2,0.7,0.7 Shape1 Transparent 3.9,0.1,1.6,1.6 0.1,0.1,0,0 StartPointPrimitive3 199806520c8745bd855f164719367750 1.5,1.5,0,0 EndPointPrimitive3 199806520c8745bd855f164719367750 Panel1 0.1,0.2,1.4,1.2 Black 2fd3ce047a9f49999b19faced4d32503 RoundedRectanglePrimitive1 0.2 3 0.1,0.2,0,0 StartPointPrimitive1 2fd3ce047a9f49999b19faced4d32503 1.5,1.4,0,0 EndPointPrimitive1 2fd3ce047a9f49999b19faced4d32503 1.6,0.2,1.2,1.2 Black bf0b1ab758d34c31bf956707fee0d3e6 RectanglePrimitive1 3 1.6,0.2,0,0 StartPointPrimitive2 bf0b1ab758d34c31bf956707fee0d3e6 2.8,1.4,0,0 EndPointPrimitive2 bf0b1ab758d34c31bf956707fee0d3e6 4,0.2,1.4,1.4 Black 199806520c8745bd855f164719367750 RoundedRectanglePrimitive2 0.2 3 3b1c4960cdc045e0960cc02488b6a5b6 0.39,0.39,0.39,0.39 Page1 11 8.5 Letter Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 7/3/2013 8:54:32 AM 7/3/2013 8:47:30 AM dd9a035787b74d949df06b64f2819b79 Report Inches 2012.2.1400 CSharp