California Cancer Reporting System Standards, Volume III

Date Initial RX SEER

IDENTIFIERS

DESCRIPTION

Date first course of definitive treatment started for this tumor.

LEVELS

Tumors, Admissions

LENGTH

8

ALLOWABLE VALUES

A valid, complete date in YYYYMMDD.

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 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

After all the input dates and flags have been loaded or converted and loaded (depending on the record version), perform steps 1 – 4 in the UPDATE section, Tumor Level, New Case Consolidation to generate this date and it’s associated date flag, rather than loading vendor values which may or may not be generated in the same way.

UPDATE

Tumor Level

New Case Consolidation

(Perform after all other treatment field and Type of Reporting Source consolidations)

If the tumor's RX Date Surgery, RX Date Surgery Flag, RX Date Most Defin Surg, RX Date Mst Defn Srg Flag, RX Date Radiation, RX Date Radiation Flag, RX Date Chemo, RX Date Chemo Flag, RX Date Hormone, RX Date Hormone Flag, RX Date BRM, RX Date BRM Flag, RX Date--Transplnt Endocr, RX Date--Transplnt Endocr Flag, RX Date Other, RX Date Other Flag, or Type of Reporting Source are changed, then compare them to generate Date of Initial RX—SEER and Date of Initial RX Flag values according to these consolidation rules, executed in order and stopped when one of the numbered conditions is true:

1. If the tumor's Type of Reporting Source is 7 (DC only), then set Date Initial RX SEER to blank and Date Initial RX SEER Flag to 10.

2. If the tumor's Type of Reporting Source is 6 (Autopsy only), then set Date Initial RX SEER to blank and Date Initial RX SEER Flag to 11.

3. If all input dates are blank, then set Date Initial RX SEER to blank and consolidate Date Initial RX SEER Flag by comparing all the individual input date flags and determine the best value according to this hierarchy: 12, 15, 10, 11, blank.   If Date Initial RX SEER Flag is now 15, convert it again to 10.

4. Otherwise, set Date Initial RX SEER Flag to blank and compare all fully known or partially known dates and set Date Initial RX SEER to the earliest of these known dates, taking into account that partial dates can have blank months and/or days.*

Manual change to RX Date Surgery, RX Date Surgery Flag, RX Date Most Defin Surg, RX Date Mst Defn Srg Flag, RX Date Radiation, RX Date Radiation Flag, RX Date Chemo, RX Date Chemo Flag, RX Date Hormone, RX Date Hormone Flag, RX Date BRM, RX Date BRM Flag, RX--Date Transplnt Endocr, RX--Date Transplnt Endocr Flag, RX Date Other, RX Date Other Flag, or Type of Reporting Source:

Regenerate according to above New Case Consolidation rules.

Admission Level

Manual change or Correction Applied to RX Date Surgery, RX Date Surgery Flag, RX Date Most Defin Surg, RX Date Mst Defn Srg Flag, RX Date Radiation, RX Date Radiation Flag, RX Date Chemo, RX Date Chemo Flag, RX Date Hormone, RX Date Hormone Flag, RX Date BRM, RX Date BRM Flag, RX Date--Transplnt Endocr, RX Date--Transplnt Endocr Flag, RX Date Other, RX Date Other Flag, or Type of Reporting Source:

Regenerate according to above New Case Consolidation rules.

* 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:

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

• 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

• 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

• 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

IF322 Type of Reporting Source 6 & 7, Date of Initial RX, Reason for No Surgery

IF362 Date Init RX SEER, Date of DX

IF606 Class of Case 00

IF842 Class 20-33 (Eureka)

IF899 Date Initial RX SEER, Ca Dir RX 2003 (SEER IF180)

IF900 Date Initial RX SEER, Ca Dir RX 98-02

IF903 Date Initial RX SEER, Date Flag

IF1144: Class of Case 20-22, Treatment

HISTORICAL CHANGES