You are an HIM supervisor for Happy Valley Hospital, a 600-bed facility. The Joint Commission requires that all documentation for the medical record is to be completed within 30 days. Happy Valley’s rate of compliance with this requirement is 87%. More importantly, this is the second year that Happy Valley’s compliance rate is less than the required 100%. The organization’s current practice is that a letter is sent to physicians once charts have become delinquent at 30 days post-discharge. Follow-up letters continue weekly, and if charts were not completed, the previous director would call the physician office. The HIM director has asked that you track the delinquent physicians in an Excel file: • Build a data dictionary using Excel. • Use at least 12 data elements and enter at least 15 different records The info on the data dictionary will be used to do a print merge letter in the even that a letter has to be sent out to providers who are delinquent with their records. Data Elements to be used: 1.Patient last name 2.Patient First name 3.Patient Address 4.Patient Contact 5.Patient Middle Initial 6.Patient Gender 7.Physician Name 8. Diagnosis 9. Admission Date 10.Discharge Date 11. Days Delinquent 12. Letter Sent -The 15 records can be made up patients and information. I have attached an example of a data dictionary
