Sat with Andy as he worked on how to pull in DM_EyeExam Information for the Prototype. We are tracking EyeExam metrics for the Physician Dashboard, but the prototype is different. The prototype looks in the past to see if, among our DM population, a Preventive Visit has occurred (under the assumption that eye exams are performed at Prevenmtive Visits for DM patients.) Then the prototype looks forward to see if a PE is scheduled at some point in the future. Long story short we did figure a portion of this out - however we may no have to identify actual CPT codes that indicate that an actual Eye Exam was performed - no assumptions.
This afternoon was a lot of me watching Andy. I have to get better at following him. It is hard for me. I am trying to just write what I see (relevant or not) as a way of staying engaged. I will say that this technique helps. Even though I am not always following exacly what he is doing I am answering some questions for myself. For instance, today I figured out by watching him how to link a Pivot to SQL. I am going to try to build some things on my own with this technique - simple thing s for practice.
Tomorrow per Andy
- finish Prototype EyeExam
- update the EyePivot - calculated field
- preformat tab - last eye exam and future appt
- update the VBA
No comments:
Post a Comment