1 / 84

Division of Cancer Prevention and Control

Prep Plus and CRS Plus. Software Programs for Registering, Editing, Linking, Consolidating, and Maintaining Central Cancer Registry Data. Michelle Esterly CDC/NPCR Contractor Joe Rogers Team Lead, Data Analysis and Support Team, NPCR, CDC.

mmiyashiro
Télécharger la présentation

Division of Cancer Prevention and Control

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Prep Plus and CRS Plus Software Programs for Registering, Editing, Linking, Consolidating, and Maintaining Central Cancer Registry Data Michelle Esterly CDC/NPCR Contractor Joe Rogers Team Lead, Data Analysis and Support Team, NPCR, CDC National Center for Chronic Disease Prevention and Health Promotion Web Demonstration 2015 Division of Cancer Prevention and Control

  2. Registry Plus • Suite of publicly available, free-of-charge, Windows-based software programs for collecting and processing cancer registry data • Made available by the CDC to implement NPCR • Enable central registries to meet NPCR program standards in the face of existing budgetary constraints • Compliant with national standards • Fully customizable for state-specific needs

  3. CDC Registry Plus

  4. CDC–NPCR Prep and CRS Plus Contacts Michelle L. Esterly, CDC/NPCR Contractor E-mail: mesterly@cdc.gov

  5. Tools for Data at the CCR • Registry Plus tools used to support central registry operations of processing, maintenance, and use of central registry data • Prep Plus • Register and edit submitted data, and prepare abstracts for processing in CRS Plus • CRS Plus (including TLC Plus) • Link, consolidate, maintain, and use central cancer registry data

  6. Prep Plus General Information Windows-based software, networked, multi-user Used to receive and apply data quality/completeness edits to batches of incoming abstracts Uses CDC’s EDITS program/NAACCR standard edits • Customizable by central registry Input is NAACCR records in version 14.0 and later from any source Output is records in latest NAACCR version, edited and bundled for subsequent processing

  7. Prep Plus Features • Review only records with edit errors and correct the errors-OR- • Visually edit (inspect and modify) all records in the bundle, on screen, without printing hard copies • User can also HOLD an abstract with or without errors to staff work file • Report of edit errors can be generated and printed for return to reporting facility

  8. Prep Plus Customization • User can create their own “display type” • Interface where user enters data • Subset of NAACCR standard data items plus any state-specific items • Order of displayed data items can be specified • User can determine their own edit requirements • User-defined functions can be invoked for local processing options

  9. Prep Plus Processing • Open new bundle (file of abstracts) • User enters source of the file or the source automatically displays if a hospital code table is included in Prep Plus • Files can be flagged for interstate data exchange or VA reporting to prevent future release of the records • Files and abstracts are registered

  10. Prep Plus Select Raw Bundle RawAbs Folder Select File Enter Date File Received

  11. Prep Plus File Processing Collaborative Staging Calculated Edits Run File and Individual Abstracts Registered

  12. Prep Plus Abstract Processing Each record is: • Copied to an archive file • Converted to the latest NAACCR record layout if necessary • Assigned a unique permanent ID that carries to CRS Plus (AbsRefID) • Date-stamped • Added to tracking database • Edited according to the state’s requirements • Marked DO NOT RELEASE if necessary

  13. Prep PlusVisual Review & Resolving Edit Errors

  14. Prep Plus Disposition Tab

  15. Prep Plus Edit Reports - Summary

  16. Prep Plus Edit Reports - Detail

  17. CRS Plus - (Central Registry System) • Used to manage central registry---link, consolidate, and maintain source records in a central database • Creates consolidated patient and tumor tables for the same person and tumor with the best values from multiple sources • Provides for automatic determination of multiple primary tumors and consolidation of data items from multiple case reports into incidence records • Produces standard extracts for NPCR and NAACCR call-for-data submission, user-specified extracts, and NAACCR-formatted files

  18. CRS Plus Features • Customizable to meet your needs • Retain all source records • Query tool to extract data • Provides standard management reports

  19. CRS Plus User Authorization Levels • Administrator • Consolidator • Editor • Viewer • Table Editor

  20. Administrative Functions

  21. Special Import into CRS Plus • Special Import is a one-time import of registry data from current software into CRS Plus • Support provided by Registry Plus Team to assist registry and IT staff to ensure successful import of records • Need your data in 3 files (in NAACCR file format) that correspond to the CRS Plus tables for • Demographic Summary (Patients) • Medical Summary (Tumors) • Abstracts (Facility Records)

  22. Importing Prepped Bundles from Prep Plus • Select files to import • Unattended import allows user to import multiple files without manual intervention in between files (can run overnight) • Import Activity Report • Import Log • Provides tracking of all imports

  23. Flag for Release of Records • Carried over from Prep Plus and populated in Unusual Follow-Up Method for Data Exchange and VA records • Can also be manually updated in CRS Plus for individual cases

  24. CRS Plus Import Window

  25. CRS Plus Import

  26. CRS Plus Import

  27. CRS Plus Import Report

  28. CRS Plus Import Log

  29. TLC Plus (TumorLinkage &Consolidation) • Provides automated support for CTR decision-making • Do multiple abstracts for the same person represent SAME or DIFFERENT tumors? • For multiple abstracts for the same tumor, what consolidated values should be used for analysis? • Demographic (Patient tables) • Cancer identification (Medical Summary tables) • Treatment summary (Medical Summary tables) • Most TLC Plus decisions can be verified by CTR • TLC Plus rules can be modified or de-activated by central registry

  30. CRS Plus Data Flow Incoming Abstract 1. Patient Linkage Algorithm Add to Database: New Patient NO MAYBE Patient Linkage Result Pending: Patient Linkage YES 2. Tumor Linkage Algorithm Add to Database: New Tumor NO MAYBE Tumor Linkage Result Pending: Tumor Linkage YES 3. Data Item Consolidation NO Consolidation Result Pending: Consolidation YES 4. Collaborative Staging NO Collaborative Staging Result Pending: CS YES 5. Duplicate/M Record Type Determination YES Duplicate/M Record Result Pending: Duplicate/M Record NO 6. Run Consolidated Edits Add to Database: Consolidated Record NO YES Edits Result Pending: Edit Error

  31. Abstracts Table-Status1 • Broad status of abstract

  32. Abstracts Table-Status2 • Why the abstract is in pending • Value greater than 0 indicates system sent to pending

  33. Defined Data FlowPending Status Codes

  34. CRS Plus Patient DataStructure Diagram Abstracts tables: Facility-specific data, submitted abstracts AbsRefID 165 J. Smith, Colon PtID 106 MedRefID 130 AbsRefID 166 J. Smith, Kidney PtID 106 MedRefID 131 AbsRefID 345 J. Smith, Kidney PtID 106 MedRefID 131 MedRefID 130 Colon PtID 106 SeqNum 00 SeqNum 01 MedRefID 131 KidneyPtID 106SeqNum 02 Medical Summary tables: Consolidated tumor information Patients tables: Consolidated patient information PtID 106 J. Smith

  35. CRS Plus Activities • View a case • Update a case • Work with Pending cases • Edit the case structure for a case • Print a case • Run queries against the database • Create extracts of data out of the database • Run reports

  36. CRS Plus File Menu

  37. Viewing Records • Viewing Records – For viewing only • Updates cannot be made from this screen • Default Grid Display • Layout of Screen

  38. CRS Plus View Case

  39. Searching for Patientsin Database

  40. Processing Pending Abstracts

  41. Patient Linkage • First step: Blocking performed to identify all consolidated records similar to the incoming record • Soundex of last name • Birth date • SSN • Blocking –allows patient linkage to be completed more efficiently

  42. Patient Linkage • Second step: Matching specific data items from the incoming record against all consolidated records to assign match score • Data items used to compute score: Date of Birth SSN First Name Sex Middle Name Race 1 Last Name

  43. Patient Linkage • Matching algorithm assigns different scores for exact or partially matched data items • CRS Plus uses two cut-off scores to identify potential matches • Highest possible score – 170 • All records with a score of 155 or higher are considered definite matches (Patient ID transferred) • Records with score less than 80 are eliminated as matches (Low score can be determined by Registry)

  44. Patient Linkage Potential Dispositions • New Patient: No records with match score =>80 • Record sent for sequence number check • New Patient record and Tumor record created • Pending Patient Linkage: One or more records with scores = 80-154 OR one record with score => 155 but another record matched • Record sent to pending for manual patient linkage • Linked to Patient: Only one record with score => 155 OR one record with score => 155 and other records matched with scores significantly lower • Patient ID assigned and record proceeds to TLC Plus

  45. Pending: Patient Linkage

  46. Pending: Sequence New Patient • Records designated as New Patient enter sequence number check • Based on Sequence Number--Hospital • Values of 00, 99, or blank – Assign Sequence Number--Central of 00 • Any other value – abstract sent to pending for manual Sequence Number--Central assignment

  47. Tumor Linkage • TLC Plus – automated tumor linkage process to determine if record can be linked to an existing tumor • Involves matching of specific data items from incoming abstract against linked consolidated records • Data items used to determine Tumor Linkage: Primary Site Behavior Histologic Type Laterality Diagnosis Date Reporting Facility

  48. Tumor Linkage Potential Dispositions • New Tumor (NO): Tumor determined to be new primary, not currently on database • New Tumor record created and record proceeds to automated consolidation (patient data items only) • Pending Tumor Linkage (MAYBE): Automated Tumor linkage not determined • Record sent to pending for manual tumor linkage • Consolidate (YES): Tumor determined to be same primary • Record proceeds to TLC Plus for automated consolidation

  49. Pending: Tumor Linkage

  50. Pending: Tumor Linkage

More Related