NYCris: Rule to Identify Duplicate Tumours

1. NYCRIS: Rule to Identify Potential Duplicate Tumours (1) Select Patient Cohort Patient Id: Range Date Last Changed: Range Sex: M or F Check Patient Eligibility 1. Multi-primary 2. At least one tumour meets date criteria Compare Tumours For every patient compare each tumour to succeeding ones using: 1. First 3 characters of ICD Site code 2. First 3 digits of histology code 3. Behaviour code SAME SITES Sites are the same or equivalent C01 and C02 = Tongue C07 and C08 = Parotid/Other major salivary glands C12 and C13 = Pyriform sinus and hypopharynx C19 and C20 = Rectum and rectosigmoid junction C77 to C80    = Secondary Neoplasms (C82-C85, C91 and C95 =Various forms of NHL and lymphocytic and unspecified leukaemia)

2. NYCRIS: Rule to Identify Potential Duplicate Tumours (2) SAME Sites? Yes No SAME Histology? SAME Histology? Yes No Yes No Behaviour code > 2 for both tumours? No histology on one or both tumours? Yes No Both tumours malignant (code 3)? Yes No No Yes SAME SAME DIFFERENT DIFFERENT

3. NYCRIS: Use of Rule in Current Process • Duplicate Tumour Search report incorporated in C-CRIS2 • Run manually each month • Use Date Last Changed range to identify records added or amended since last run • Potential duplicate pairs of tumours reported side by side in printed report for ease of comparison • Duplicates resolved prior to next run

4. NYCRIS: Results Produced by Application of Rule November 2002 Patient Records Selected: 2,271 Potential Duplicate Pairs Found: 230 Actual Duplicate Records Deleted: 23 December 2002 Patient Records Selected: 1,652 Potential Duplicate Pairs Found: 153 Actual Duplicate Records Deleted: 9 Limitations • No account is taken of laterality so there are issues with paired organs e.g. Breast • Majority of records identified are genuine multiple tumours e.g. colorectal, skin, melanoma

5. NYCRIS: Examples of Potential Duplicate Pairs