Data Quality User Group Meeting Minutes
June 1, 2001


Date: June 1, 2001
Time: 9:00 am
Location: Rockledge II, Room 6201
Next Meeting: TBD

Action Items

1. Facilitate QRC Access to Original Applications and IC Source Documents (Belinda)
2. Facilitate QRC Interviews with Staff (Belinda, Bob, Larry)
3. Provide QRC with OLTP to IRDB Bridging Documentation (Larry)
4. Facilitate QRC Access to TechView Manuals (Larry)
5. Facilitate QRC's Obtaining Logons and Provide Demos of IMPAC II Modules (Larry)

Proceedings

Greetings
Belinda and Bob greeted QRC and expressed their hopes for a productive and cooperative relationship. Now that funding is available, everyone is anxious for the data cleanup project to begin. The purpose of this kickoff meeting is to present our perception of the problem. Belinda noted that in the course of their investigation, QRC may unearth additional anomalies. Since existing tools are not satisfactory, one of QRC's primary tasks will be to develop and execute software to determine all the personal identifier data discrepancies.

Presentation of the Problem
Maria Bukowski has dedicated a great deal of time and energy to studying the PERSONS data problem. She presented a 15-minute overview including: the construction of personal information in the OLTP and IRDB databases; description of problems with redundant and incorrectly collapsed profiles and with person name, SSN, professional degree and address data. Maria also estimated the magnitude of these problems and provided illustrative examples. Refer to Maria's handouts (attachments A and B) for details.

Discussion of Data Correction and Improvement Considerations
· Corrections of data in IMPAC II OLTP will correct IRDB CURRENT data, but not IRDB HISTORY or PUB data since pointers have been severed.
· In some cases, it may be necessary to go back to the original application in order to resolve problems. Therefore, the contractors may need access to the IC grant files and archives. Belinda will facilitate interaction between QRC and the ICs.
· Unless restrictive business editing rules coincide with cleanup, the project will lose ground. Since it is unclear who has the authority to make changes, the contractor will have to conduct interviews. QRC was asked to go through Bob, Belinda or Larry to arrange interviews.
· Changing business rules (e.g., restricting the update of SSNs) will require policy decisions. Belinda said that she is looking to QRC to propose "reasonable" rules that support data integrity without slowing down the grants process.
· The flow of data from the OLTP (normalized) to the IRDB (denormalized) must be considered in problem analysis and resolution. Larry will provide QRC with technical documentation on bridging. QRC also requested access to TechView Volume 1 (OLTP) and Volume 2 (IRDB).
· Larry said there is an in-house tool to collapse profiles. He will make this tool available to QRC. He will also facilitate obtaining logons for QRC and will provide demos of the IMPAC II modules.

Contractual Items
Karen Riggs of the NLM Contracting Office introduced herself and invited QRC to call her with questions. She advised QRC to follow instructions for reporting requirements, deliverables and invoicing found in the SOW. Invoices are to be sent to her office.

Closing Remarks
Belinda praised QRC for their good work on CGAF and acknowledged the size and difficulty of the task they now face. She invited QRC to participate at Project Team meetings.

Attendees

Carol Bleakley, OD, bleakc@od.nih.gov
Maria Bukowski, OD, bukowskim@od.nih.gov
Zoe-Ann Copeland, OD, copelanz@od.nih.gov
Fanning, Larry, OD, fanningl@od.nih.gov
Paul D. Gammill, QRC, pgammill@qrc.com
Cassandra Gibbs, OD, gibbsc@od.nih.gov
Steve Hazen, NCI, hazens@mail.nih.gov
Jim Lipton, NIDCR, liptonj@email.nidr.nih.gov
Mary V. Look, QRC, mlook@qrc.com
Richard Mantovani, QRC, mantovani@macroint.com
Donald J. McMaster, Jr. QRC, dmcmaster@qrc.gov
Madeline Monheit, LTS, monheitm@od.nih.gov
Bob Moore, OD, moorerf@od.nih.gov
Karen Riggs, NLM, Kr33v@nih.gov
Susan Scolnik, NHLBI, scolniks@nhlbi.nih.gov
Belinda Seto, OD, setob@od.nih.gov
Sara Silver, Z-tech, ssilver@hq.row.com

Attachments
A. Construction of Personal Information
B. IMPAC II Data Quality Review (June 1, 2001)