California Cancer Reporting System Standards, Volume III
| CCR ID | NAACCR ID |
E1077 |
445 |
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.
If the record version is version 12 or later, then upload with no conversion.
If the record version is earlier than 12, then perform the following conversions in this order:
Right-justify and zero-fill the date to 8 digits.
Convert MMDDYYYY to YYYYMMDD.
If any parts of the date (year, month, and/or day) are 00, 0000, 88, 8888, 99, or 9999, then convert them to blank (no value).
When formatting is the only change to a date, do not record it in the audit log.
Tumor Level
New Case Consolidation
If the admission and tumor’s Date of Mult Tumors or Date of Mult Tumors Flag values are different, then list both dates and both flags for review
Manual Update*, **
Admission Level
Manual Update or Correction applied to date or its associated date flag*, **
*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).
*** 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:
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
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
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
IF742 Multiplicity Counter, Date of Mult Tumors
IF744 Date of Mult Tumors, Date of Diagnosis
IF784 Date Mult Tum, Lymphoma-Leukemia-Unk Site
IF830 Mult Tum Rpt As One Prim, Date of Mult Tum
IF906 Date of Mult Tumors, Date Flag (NAACCR)
| 8/15/06 | New data item for 2007. |
| 2/20/08 | Changed Update spec to List for Review (was Manual) so discrepancies are reflected in Conflict table. Added IF #784. |
| 2/2009 | Added IF #830. |
| 2010 | 2010 Data Changes: Revised Allowable Values and Source information to match NAACCRv12 date scheme. Revised Allowable Values, Source and Update logic information to match NAACCRv12 date scheme. Added IF #906. |
| 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 Date of Multiple Tumors to Date of Mult Tumors |