VISN Diabetes Cohort



Cube: VISN Diabetes VISN Cohort

Patient Cohort Definition:

Any patient with a Hemoglobin A1c greater than or equal to 6.5 within the last year

OR

Any patient with an outpatient prescription for Insulin within the last year

OR

Any patient with an outpatient prescription for any Oral Hypoglycemic Agents other than Metformin within the last year

OR

Any patient with an outpatient prescription for Metformin within the last year that is active on the problem list with any 250 series ICD-9 diagnosis

OR

Any patient with an outpatient prescription for Metformin within the last year that had an outpatient visit at anytime with a 250 series ICD-9 diagnosis

OR

Any patient with an outpatient prescription for Glucose Test Strips within the last year that is active on the problem list with any 250 series ICD-9 diagnosis

OR

Any patient with an outpatient prescription for Glucose Test Strips within the last year that had an outpatient visit at anytime with a 250 series ICD-9 diagnosis

Patients Excluded from the Cohort:

Any patient with an outpatient prescription for Metformin within the last year that is not active on the problem list with any 250 series ICD-9 diagnosis.

OR

Any patient with an outpatient prescription for Metformin within the last year with an outpatient visit at anytime without a 250 series ICD-9 diagnosis.

OR

Any patient with an outpatient prescription for Glucose Test Strips within the last year that is not active on the problem list with any 250 series ICD-9 diagnosis.

OR

Any patient with an outpatient prescription for Glucose Test Strips within the last year with an outpatient visit at anytime without a 250 series ICD-9 diagnosis.

OR

Deceased patients

Test Patients

ZZ’d Patients

Cube Measures

|Measure |Description |

|Diabetes Patient Count |Count of patients in the cohort. |

|Percent A1c > 9 |Percent of patients that had a Hemoglobin A1c resulted during a twelve-month time |

| |period with their last Hemoglobin A1c value being greater than 9. |

|Percent A1c Not Done |Percent of patients during a twelve-month time period with no Hemoglobin A1c |

| |resulted. |

|Percent A1c > 9 or No A1c Done |Percent of patients that had a Hemoglobin A1c resulted during a twelve-month time |

| |period with their last Hemoglobin A1c value greater than 9 or no Hemoglobin A1c |

| |resulted for the same time period. |

|Target A1c > 9 and A1c Not Done |EPRP target for percent of patients that had a Hemoglobin A1c resulted during a |

| |twelve-month time period with their last Hemoglobin A1c value greater than 9 or no |

| |Hemoglobin A1c resulted for the same time period. |

|Percent LDL < 120 |Percent of patients with either a direct or calculated LDL within the last |

| |twenty-four months with a value less than 120. |

|Percent Lipid Panel Within 2 Years and LDL < |Percent of patients that received a full lipid panel within the last twenty-four |

|120 |months and the most recent direct or calculated LDL value was less than 120. |

|Target LDL < 120 |EPRP target for percent of patients that received a full lipid panel within the last|

| |twenty-four months and the most recent direct or calculated LDL value was less than |

| |120. |

|Percent BP < = 140/90 |Percentage of patients with their last Blood Pressure during a twelve-month time |

| |period less than or equal to 140/90 (Both systolic < = 140 AND diastolic < = 90). |

|Target BP < = 140/90 |EPRP target for percentage of patients with their last Blood Pressure during a |

| |twelve-month time period less than or equal to 140/90 (Both systolic < = 140 AND |

| |diastolic < = 90). |

|Percent BP > = 160/100 |Percentage of patients with their last Blood Pressure during a twelve-month time |

| |period less than or equal to 160/100 (Both systolic > = 160 OR diastolic > = 100). |

|Percent Without BP Done |Percentage of patients without their Blood Pressure taken during a twelve-month time|

| |period. |

|Percent BP > = 160/100 or Not Done |Percentage of patients with their last Blood Pressure during a twelve-month time |

| |period less than or equal to 160/100 (Both systolic > = 160 OR diastolic > = 100) or|

| |the patients Blood Pressure was not taken. |

|Target BP > = 160/100 or Not Done |EPRP target for percentage of patients with their last Blood Pressure during a |

| |twelve-month time period less than or equal to 160/100 (Both systolic > = 160 OR |

| |diastolic > = 100). |

|Percent Foot Exams |Percent of patients during a twelve-month time period that had a sensory foot exam. |

|Target Foot Exams |EPRP target for percent of patients during a twelve-month time period that had a |

| |sensory foot exam. |

|Percent Eye Exams |Percent of patients during a twelve-month time period that had a retinal eye exam. |

|Target Eye Exams |EPRP target for percent of patients during a twelve-month time period that had a |

| |retinal eye exam. |

|Patients With A1c > 9 |Count of patients that had a Hemoglobin A1c resulted during a twelve-month time |

| |period with their last Hemoglobin A1c value being greater than 9. |

|Patients With A1c Not Done |Count of patients during a twelve-month time period with no Hemoglobin A1c resulted.|

|Patients With A1c > 9 or No A1c Done |Count of patients that had a Hemoglobin A1c resulted during a twelve-month time |

| |period with their last Hemoglobin A1c value greater than 9 or no Hemoglobin A1c |

| |resulted for the same time period. |

|Patients With LDL < 120 |Count of patients with either a direct or calculated LDL within the last twenty-four|

| |months with a value less than 120. |

|Patients With LDL > = 120 |Count of patients with either a direct or calculated LDL within the last twenty-four|

| |months with a value greater than or equal to 120. |

|Patients With BP < = 140/90 |Count of patients with their last Blood Pressure during a twelve-month time period |

| |less than or equal to 140/90 (Both systolic < = 140 AND diastolic < = 90). |

|Patients With BP > = 140/90 |Count of patients with their last Blood Pressure during a twelve-month time period |

| |less than or equal to 140/90 (Both systolic > = 140 AND diastolic > = 90). |

|Patients With BP > = 160/100 |Count of patients with their last Blood Pressure during a twelve-month time period |

| |less than or equal to 160/100 (Both systolic > = 160 OR diastolic > = 100). |

|Patients Without BP Done |Count of patients without their Blood Pressure taken during a twelve-month time |

| |period. |

|Patients With BP > = 160/100 or Not Done |Count of patients with their last Blood Pressure during a twelve-month time period |

| |less than or equal to 160/100 (Both systolic > = 160 OR diastolic > = 100) or the |

| |patients Blood Pressure was not taken. |

|Patients With Foot Exams |Count of patients during a twelve-month time period that had a sensory foot exam. |

|Patients With No Foot Exams |Count of patients during a twelve-month time period without a sensory foot exam. |

|Patients With Eye Exams |Count of patients during a twelve-month time period that had a retinal eye exam. |

|Patients Without Eye Exams |Count of patients during a twelve-month time period without a retinal eye exam. |

|Patients With Lipid Panel Within 2 Years and |Count of patients that received a full lipid panel within the last twenty-four |

|LDL < 120 |months and the most recent direct or calculated LDL value was less than 120. |

|Patients With No Lipid Panel Within 2 Years |Count of patients that did not received a full lipid panel within the last |

| |twenty-four months. |

 Cube Dimensions

|Dimension |Hierarchy |Description |

|Team |Site |Site where the patient was seen. |

| |Team Name |Last team that the provider was assigned too based on the |

| | |SnapshotDate column found in the PatientProviderRel table. |

|Patients |Site |Site where the patient was seen. |

| |Division |Division where patient received most of their outpatient |

| |First Char Last Name |treatment. |

| |Patient Name |First character of patients last name. |

| | |Patients last name, first name followed by last four of SSN. |

|PC Provider |Site |Site where the patient was seen. |

| |Type |Primary care provider or not. |

| |First Char Last Name |First character of providers last name. |

| |Provider Name |Last Primary Provider assigned to the patient based on the |

| | |SnapshotDate column found in the PatientProviderRel table. |

|Time |Date Range |Twelve month time period. |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download