VISN Diabetes Results

  • Doc File 93.50KByte



Cube: VISN Diabetes Results

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 |

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

|Patients With Last A1c < 6.5 |Count of patients that had a Hemoglobin A1c resulted during a twelve-month time |

| |period with their last Hemoglobin A1c value being less than 6.5. |

|Patients With Last A1c >= 6.5 and < 8 |Count of patients that had a Hemoglobin A1c resulted during a twelve-month time |

| |period with their last Hemoglobin A1c value being greater than or equal 6.5 and less|

| |than 8. |

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

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

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

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

|Last A1c Value |Result of last Hemoglobin A1c taken. |

|Date Last A1c Resulted |Date last Hemoglobin A1c was resulted. |

|1st Previous A1c Value |The first prior Hemoglobin A1c resulted after the patients last Hemoglobin A1c was |

| |taken. |

|Date 1st Previous A1c Resulted |Date first prior Hemoglobin A1c was resulted. |

|2nd Previous A1c Value |The second prior Hemoglobin A1c resulted after the patients last Hemoglobin A1c was |

| |taken. |

|Date 2nd Previous A1c Resulted |Date second prior Hemoglobin A1c was resulted. |

|Last Outside A1c Value |Result of last Hemoglobin A1c taken off site. The outside lab result is taken from |

| |the related A1c Health Factor at each site. If the outside result is not entered |

| |into the Health Factor as ‘number.number’ then the result value is ignored. |

|Date Last Outside A1c Value |Date last outside Hemoglobin A1c was resulted. |

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

| |months with a value less than 100. |

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

| |months with a value greater or equal 100 and less than 120. |

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

| |months with a value greater or equal 120 and less than 130. |

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

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

|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 Lipid Panel Not Done Within 2 |Count of patients that did not received a full lipid panel within the last |

|Years |twenty-four months. |

|Last LDL Value |Result of the last LDL taken either a direct or calculated. |

|Date Last LDL Resulted |Date last LDL taken either a direct or calculated. |

|1st Previous LDL Value |The first prior LDL (direct or calculated) resulted after the patients last LDL |

| |(direct or calculated) was taken. |

|Date 1st Previous LDL Resulted |Date first prior LDL (direct or calculated) was resulted. |

|2nd Previous LDL Value |The second prior LDL (direct or calculated) resulted after the patients last LDL |

| |(direct or calculated) was taken. |

|Date 2nd Previous LDL Resulted |Date second prior LDL-Cholesterol was resulted. |

|Last Outside LDL Value |Result of last LDL (direct or calculated) taken off site. The outside lab result is |

| |taken from the related LDL Health Factor at each site. If the outside result is not |

| |entered into the Health Factor as ‘number.number’ then the result value is ignored. |

|Date Last Outside LDL Value |Date last outside LDL (direct or calculated) was resulted. |

|Last Creatinine Value |Result of the last Serum Creatinine taken. |

|Date Last Creatinine Resulted |Date last Serum Creatinine was resulted. |

|1st Previous Creatinine Value |The first prior Serum Creatinine resulted after the patients last Serum Creatinine |

| |was taken. |

|Date 1st Previous Creatinine Resulted |Date first prior Serum Creatinine was resulted. |

|2nd Previous Creatinine Value |The second prior Serum Creatinine resulted after the patients last Serum Creatinine |

| |was taken. |

|Date 2nd Previous Creatinine Resulted |Date second prior Serum Creatinine was resulted. |

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

|Last BP Value |Result of last Blood Pressure taken. |

|Date of Last BP Taken |Date last Blood Pressure was resulted. |

|1st Previous BP Value |The first prior Blood Pressure taken after the patients last Blood Pressure was |

| |taken. |

|Date 1st Previous BP Taken |Date first prior Blood Pressure was resulted. |

|2nd Previous BP Value |The second prior Blood Pressure taken after the patients last Blood Pressure was |

| |taken. |

|Date 2nd Previous BP Taken |Date second prior Blood Pressure was resulted. |

|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 Insulin Rx |Number of Insulin prescriptions the patient had within a twelve-month time period. |

|Patients With Oral Hypoglycemic Agents Rx |Number of Oral Hypoglycemic Agents prescriptions the patient had within a |

| |twelve-month time period. |

|Patients With Test Strips Rx |Number of Glucose test strips prescriptions the patient had within a twelve-month |

| |time period. |

|Patients With Aspirin Rx (CN103) |Number of Aspirin prescriptions from the (CN103) drug class the patient had within a|

| |twelve-month time period. |

|Patients With Statin Rx (CV350) |Number of Statin prescriptions from the (CV350) drug class the patient had within a |

| |twelve-month time period. |

|Patients With Ace Inhibitor Rx (CV800) |Number of Ace Inhibitor prescriptions from the (CV800) drug class the patient had |

| |within a twelve-month time period. |

|Current Tobacco Users |Count of patients that very had a Health Factor as current tobacco user. |

|Received Tobacco Counseling |Count of patients that within a twelve-month time period received tobacco |

| |counseling. |

|Lifetime Non Tobacco User |Count of patients that ever had a Health Factor as lifetime non-tobacco user. |

|Former Tobacco User |Count of patients that very had a Health Factor as a former tobacco user. |

|Received Pneumococcal Vaccine |Count patients that received at anytime the Pneumococcal Vaccine. |

|Received Flu Vaccine |Count of patients that received a flu immunization within a twelve-month time |

| |period. |

 

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

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

Online Preview   Download