resource check-up & diagnosis: conducting a database audit
DESCRIPTION
Resource Check-Up & Diagnosis: Conducting a Database Audit. Brandi Nieland 2-1-1 Maryland, Baltimore Donnie House 2-1-1 Helpline, Tulsa. 2-1-1 Maryland. 2-1-1 Oklahoma. Reasons for Conducting a Database Audit. Quality Control Merged Databases Software Migrations Multiple Users. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/1.jpg)
Resource Check-Up & Diagnosis: Conducting a Database Audit
Brandi Nieland2-1-1 Maryland, Baltimore
Donnie House2-1-1 Helpline, Tulsa
![Page 2: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/2.jpg)
2-1-1 Maryland
![Page 3: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/3.jpg)
2-1-1 Oklahoma
![Page 4: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/4.jpg)
Reasons for Conducting a Database Audit•Quality Control
▫Merged Databases▫Software Migrations▫Multiple Users
![Page 5: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/5.jpg)
Reasons for Conducting a Database Audit•AIRS Standard Implementation
▫New Standards•AIRS Accreditation Requirements
▫Secret Shopper▫Review Prior to Site Visit
Adobe Acrobat Document
![Page 6: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/6.jpg)
Types of Database Audits - Oklahoma•Service Type Audits
▫(i.e. Food Pantries)
•Database Element Spot Checks ▫(i.e. Service Hours)▫Download to Access/Excel
•City/County ChecklistAdobe Acrobat
Document
![Page 7: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/7.jpg)
Types of Database Audits•Randomized Agency Record Audit
▫Percentage/Number of Records▫All Updated Records
•Audits vs. Peer Reviews
![Page 8: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/8.jpg)
Audit Tools - Maryland•AIRS Resource Database
Self-Assessment Tool
•Style Guide
•Audit Form
Adobe Acrobat Document
Adobe Acrobat Document
![Page 9: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/9.jpg)
Audit Tools - Oklahoma•Style Guide
•Resource Specialist Checklist
•Audit Form
Adobe Acrobat Document
Adobe Acrobat Document
Adobe Acrobat Document
Adobe Acrobat Document
![Page 10: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/10.jpg)
Audit Process - Maryland•Completing the Audit
▫Review in resource module▫Survey to agency
![Page 11: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/11.jpg)
Audit Process - Oklahoma•Completing the Audit
▫Review in resource module▫Review in contact module▫Review online
![Page 12: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/12.jpg)
Audit Process•Providing Feedback to Specialists•Making Corrections/Adjustments•Keeping Records
![Page 13: Resource Check-Up & Diagnosis: Conducting a Database Audit](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815e96550346895dcd25f0/html5/thumbnails/13.jpg)
Lessons Learned•Objective vs. Subjective•Consistency in the Auditor is Key•Balance Negative and Positive