California Cancer Reporting System Standards, Volume III
CCR ID |
NAACCR ID |
E1318 |
3230 |
Records the date of initiation for systemic therapy that is part of first course of treatment. Systemic therapy is considered chemotherapy agents, hormonal agents, biological response modifiers, bone marrow transplants, stem cell harvests, and surgical and/or radiation endocrine therapy
Tumor
Admission
LENGTH
8
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.
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
When month is known, it is checked to ensure it falls within range 01...12.
When month and day are known, day is checked to ensure it falls within range for that specific month. Accommodation is made for leap years.
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.
Tumor Level
New Case Consolidation
(Perform after chemo, hormone, BRM, and Transp Endo consolidations)
If 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, or Type of Reporting Source are changed, then compare them to generate RX Date Systemic and RX Date Systemic Flag values according to these consolidation 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 Systemic to blank and RX Date Systemic Flag to 10.
If Type of Reporting Source is 6 (Autopsy only), then set RX Date Systemic to blank and RX Date Systemic Flag to 11.
If all four dates are blank, then set RX Date Systemic to blank and consolidate RX Date Systemic Flag by comparing all the individual input date flags and determine the best value according to this hierarchy: 12, 15, 10, 11, blank.
Otherwise, set RX Date Systemic Flag to blank and compare all fully known or partially known dates and set RX Date Systemic to the earliest* one.
Manual Change to 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, or Type of Reporting Source:
Regenerate according to above New Case Consolidation rules.
Admission Level
Manual change or correction/update applied to 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, 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
Yes
IF891 RX Date Systemic, Systemic RX
IF926 RX Date Systemic, Date Flag
| 3/26/03 | New data item requirement for cases diagnosed January 1, 2003 forward. |
| 3/03/04 | Removed conversion instruction from SOURCE for Version 9 records. See Use Case 22. |
| 1/19/05 | Allowable Values, Source requirements, and Update logic, changed to handle 88888888 as a valid date. |
| 2010 | 2010 Data Changes: Updated Allowable Values, Source and Update logic for new NAACCR date specs. CCR name (Date_Systemic) to match NAACCR name. Added IF #891, 926. |
| 12/20/10 | Updated Source and Step 3 in Update logic to reflect flag hierarchy (changed hierarchy of flags--was 12, 11, 15, 10, blank). |
| 7/8/2011 | General Date Editing Rules and Range Checking updated for additional clarity. However, the intent of the date rules remain the same as the 2010 update. |
| May 2013 | Name changed from RX Date--Systemic to RX Date Systemic |