California Cancer Reporting System Standards, Volume III

RX Date Surgery

IDENTIFIERS

OWNER

CoC

DESCRIPTION

Records the earliest date on which any first course surgical procedure was performed.

LEVELS

Tumors, Admissions

LENGTH

8

ALLOWABLE VALUES

er084 RX Date Surgery

General Date Editing Rules:

Date fields are recorded in the D1 date format of year, month, day (CCYYMMDD). Month and day must have leading zeros for values 01...09.

The following date formats are allowed:

• CCYYMMDD Century+Year, Month and Day are provided.

• CCYYMM__ Century+Year and Month. Day consists of two blank spaces.

• CCYY____ Century+Year. Month and Day consist of four blank spaces.

The following date format is allowed:

CCYYMMDD Century+Year, Month and Day are provided.

Dates are checked first to ensure they conform to one of these formats, then for errors in the components. Checking stops on the first non-valid situation.

Range checking:

• Lowest allowed value:  January 1, 1850 (or in D1 format: 18500101)

• Highest allowed value: current system date

• The month is checked to ensure it falls within range 01...12.

• The day is checked to ensure it falls within range for that specific month. Accommodation is made for leap years.

SOURCE

If the record version is NAACCR version 12 (120 in original new case) or later, then upload the date and its associated flag value with no conversion.

Otherwise, if the record version is earlier than 12, then perform the following conversions in this order:

1. Right-justify and zero-fill the date to 8 digits.

2. Convert MMDDYYYY to YYYYMMDD.

3. Convert Date of Last Contact and Date of Last Contact Flag in the same manner as described in the Eureka Process Specification:  2010 Data Conversions document.

If steps 1 and 2 are the only changes made to the date, then DO NOT record them in the audit log.

UPDATE

Tumor Level

New Case Consolidation

If the tumor’s consolidated Date of Diagnosis year is 2003 or later, then

If all of the following conditions are true:

The admission shows surgery was given

((The Admission’s RX Summ--Surg Prim Site = 10-90), or

the Admission’s RX Summ--Scope Reg LN Sur = 1-7), or

the Admission’s RX Summ--Surg Oth Reg-Dis = 1-5))

Either of the following conditions are true

All three of the admission summary surgery codes match the corresponding tumor codes

None of the corresponding tumor values show that surgery was given

Any of the following conditions are true:

The Admission’s RX Date Surgery contains a full or partial date and the Tumor’s RX Date Surgery is blank

The Admission’s RX Date Surgery Flag shows that surgery was given but we don’t know when (code 12) and the Tumor’s RX Date Surgery Flag does NOT show that surgery was given (codes 10, 11)

Any part of the Tumor’s RX Date Surgery is blank, that same part of the Admission’s RX Date Surgery is entered, and other entered parts are equal

Then automatically update the five surgery summary tumor values with the corresponding admission values:

RX Date Surgery **

RX Date Surgery Flag

RX Summ--Surg Prim Site

RX Summ--Scope Reg LN Sur

RX Summ--Surg Oth Reg-Dis

Otherwise, if any of the above five surgery values are different between admission and tumor, then list both sets of values for review

If the tumor’s consolidated Date of Diagnosis year is earlier than 2003, then

If all of the following conditions are true:

The admission shows surgery was given

((The Admission’s RX Summ--Surg Site 98-02 = 10-90), or

The Admission’s RX Summ--Scope Reg 98-02 = 1-6), or

The Admission’s RX Summ--Surg Oth 98-02 = 1-8))

Either of the following conditions are true

All three of the admission 98-02 summary surgery codes plus RX Summ--Reg LN Examined and RX Summ--Reconstruct 1st match the corresponding tumor values

None of the three corresponding 98-02 summary surgery tumor codes show that surgery was given

Any of the following conditions are true:

The Admission’s RX Date Surgery contains a full or partial date and the Tumor’s RX Date Surgery is blank

The Admission’s RX Date Surgery Flag shows that surgery was given but we don’t know when (code 12) and the Tumor’s RX Date Surgery Flag does NOT show that surgery was given (codes 10, 11)

Any part of the Tumor’s RX Date Surgery is blank, that same part of the Admission’s RX Date Surgery is entered, and other entered parts are equal

Then automatically update these surgery summary tumor values with the corresponding admission values:

RX Date Surgery**

RX Date Surgery Flag

RX Summ--Surg Site 98-02

RX Summ--Scope Reg 98-02

RX Summ--Surg Oth 98-02

RX Summ--Reg LN Examined

RX Summ--Reconstruct 1st

If RX Summ--Surg Site 98-02, RX Summ--Scope Reg 98-02, or RX Summ--Reconstruct 1st were changed, then perform automatic 2003 Surgery to the Primary Site conversion according to Appendix 28-Surgery to the Primary Site Conversion Table for 2003 Data Changes which is based on the ‘Surgical Procedure of Primary Site and Surgical Procedure of Primary Site at this Facility’ conversion specifications in Commission on Cancer, Cancer Registry Data Conversion Rules: ROADS 1998-2000-FORDS, FORDS-ROADS 1998-2000, (see CoC website for the most current revision version) and automatically update RX Summ--Surg Prim Site

If either RX Summ--Scope Reg 98-02 or RX Summ--Reg LN Examined were changed, then automatically convert a new RX Summ--Scope Reg LN Sur value according to the conversion table described under RX Summ--Scope Reg LN Sur (UPDATE section)

If RX Summ--Surg Oth 98-02 was changed, then automatically convert a new RX Summ--Surg Oth Reg-Dis value according to the conversion table described under RX Summ--Surg Oth Reg-Dis (UPDATE section)

Otherwise, if any of the seven surgery values listed in step 1 are different between admission and tumor, then list both sets of values for review.

Manual Change*,**

Admission Level

Manual Change or Correction applied to date or its associated date flag*,**

Manual Change or Correction/Update applied to Date Surg Proc (1-3):

If Date Surg Proc 1, Date Surg Proc 1 Flag, Date Surg Proc 2, Date Surg Proc 2 Flag, Date Surg Proc 3, Date Surg Proce 3 Flag or Type of Reporting Source are changed, then compare them with RX Date Surgery and RX Date Surgery Flag to generate the best RX Date Surgery and RX Date Surgery Flag values using the following rules, executed in order and stopped when one of the numbered conditions is true*,**:

If Type of Reporting Source is 7 (DC only), then set RX Date Surgery to blank and RX Date Surgery Flag to 10.

If Type of Reporting Source is 6 (Autopsy only), then set RX Date Surgery to blank and RX Date Surgery Flag to 11.

If all four dates are blank, set the best RX Date Surgery Flag value according to this hierarchy: 12, 11, 10, blank.

Otherwise, set RX Date Surgery Flag to blank and compare all fully known or partially known surgical procedure dates and RX Date Surgery and set RX Date Surgery to the earliest**** of these known dates.

*If a full or partial date is entered in the date field, then automatically change the associated flag to blank; If a numeric associated flag code is selected/entered, then automatically change the date to blank

**If the date is changed, it is now later*** than Date of Last Contact, and Vital Status is alive(1), then automatically update Date of Last Contact with the new date and reset Date of Last Contact Flag to blank (this update applies to the patient’s Date of Last Contact and Vital Status for a Tumor Level change and to the patient and admission’s Date of Last Contact and Vital Status for an Admission level change).  Date of Initial RX SEER and Date of Initial RX Flag may also need to be changed (See Date of Initial RX SEER UPDATE section).

*** With year, month, and/or day potentially blank, a completely known date could appear to be later because it is a larger number than a partial later date.  Thus, to test for the latest date among known full or partial dates, use these tests in this order:

1. If one of the known dates’ years is later than (greater than) the other date's year being compared or if it is the only known year/date, then that date is the latest known date

2. If multiple known dates have the same latest year, but only one of them has a latest known month, then that is the latest known date

3. If multiple known dates have the same latest year & month, but only one of them has a latest known day, then that is the latest known date

**** With year, month and/or day potentially blank, a date with a partial but later date could appear to be earlier because it is a smaller number than a full earlier date.  Thus, to test for the earliest among known dates, use these tests in this order:

1. If one of the known dates’ years is earlier than (less than) the rest of the known date's year or if it is the only known year/date, then that date is the earliest known date

2. If multiple known dates have the same earliest year, but only one of them has an earliest known month, then that is the earliest known date

3. If multiple known dates have the same earliest year & month, but only one of them has an earliest known day, then that is the earliest known date

4. Otherwise, if two or more of the dates are the same earliest full or partial date, then that date is the earliest date

CONSOLIDATED DATA EXTRACT

Yes

INTERFIELD EDITS

IF339 RX Date Surgery, Date DX

IF382 Surgery, RX Date Surgery (ICD02) and (ICD03)

IF389 Histology (92-00) ICD-O-2, Date of Diagnosis

IF621 RX Date Surgery, Date of Last Contact

IF925 RX Date Surgery, Date Flag (COC)

IF1140: RX Date Mst Defn Srg, RX Date Surgery

IF1144: Class of Case 20-22, Treatment

HISTORICAL CHANGES