California Cancer Reporting System Standards, Volume III

 

Date of 1st Contact

IDENTIFIERS

CCR ID

NAACCR ID

E1087

580

DESCRIPTION

Date patient was first seen at this hospital for evaluation and/or treatment of this tumor. This date is independent of whether the patient was an inpatient or an outpatient.

LEVELS

Admissions

LENGTH

8

ALLOWABLE VALUES

(Err#057)

er057 Date of 1st Contact

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

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 1st Contact and Date of 1st 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

Manual Update or Correction Applied to date or 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 and admission’s Date of Last Contact and Vital Status).

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

CONSOLIDATED DATA EXTRACT

Yes; record with earliest admission date for this tumor.

INTERFIELD EDITS

IF604 Date of Birth, Date of 1st Contact

IF605 Date of 1st Contact, Date of Last Contact

IF606 Class of Case 00

IF609 Date of 1st Contact, Date of Diagnosis, Institution Referred From

IF613 Type of Reporting Source (6 or 7), Date of 1st Contact, Date of Diagnosis

IF618 Date 1st Contact, Date Dx, OR Admis DX (Flag 11)

IF738 CS Lymph Nodes, Regional Nodes Positive

IF754 Type of Reporting Source, Date of 1st Contact, Date of Diagnosis

IF831 Class Case 49 (DCO), Type of Reporting Source, Vital Status, Date of Last Contact

IF842 Class 20-33 (Eureka)

IF894 Date of 1st Contact, Date Flag( NAACCR)

IF1124 Class of Case 43 Out of State Cases

IF1144: Class of Case 20-22, Treatment

IF1244: Class of Case 20-22, No Treatment

HISTORICAL CHANGES

1/08/07

Added IF #754 to cover MD only and lab only standards for Date_First_Admis and Date_DX.

2010

2010 Data Changes:  CCR name (Date_First_Admis) changed to NAACCR name. Revised Allowable Values, Source and Update logic information to match NAACCRv12 date scheme. Added IF#606.

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.