California Cancer Reporting System Standards, Volume III

 

Date of Last Contact

CCR ID

NAACCR ID

E1516

1750

 

DESCRIPTION

Date of last known information about this patient, or date of death if patient deceased

LEVELS

Patients, Admissions

LENGTH

8

ALLOWABLE VALUES

er116 Date of Last Contact

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.

SOURCE

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:

  1. Right-justify and zero-fill the date to 8 digits.
  2. Convert MMDDYYYY to YYYYMMDD.
  3. If any parts of the date (YYYY, MM, or DD) are 00, 0000, 88, 8888, 99, or 9999, then convert them to blank (no value).
  4. If the date is now completely blank, then set the associated date flag to 12 (unknown); otherwise, set the date flag to blank.

If steps 1 and 2 are the only changes made, then don't record them in the audit log.

UPDATE

Patient Active Follow-up Fields Update Logic

CONSOLIDATED DATA EXTRACT

Yes

INTERFIELD EDITS

IF331 Vital Status, Cause of Death, Date of Last Contact

IF377 Cause of Death, Date Last Contact

IF451 RX Date--Most Defin Surg, Date Last of Contact

IF454 RX Date--Transplnt/Endocr, Date Last Contact

IF605 Date of 1st Contact, Date of Last Contact

IF610 Place of Death, Type of Reporting Source 7

IF614 Type of Reporting Source (6 or 7), Date of Diagnosis, Date of Last Contact

IF621 RX Date--Surgery, Date of Last Contact

IF622 RX Date--Radiation, Date of Last Contact

IF623 RX Date--Chemo, Date of Last Contact

IF624 RX Date--Hormone, Date of Last Contact

IF625 RX Date--BRM, Date Last Contact

IF626 RX Date--Other, Date of Last Contact

IF659 Date Cancer Status, Date of Last Contact

IF669 RX Date DX Stg Proc, Date of Last Contact

IF675 Date of Inpatient Adm, Date of Last Contact

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

IF835 Date of Last Contact, Date of Diagnosis

IF1124 Class of Case 43 Out of State Cases

IF1139 Date of Last Contact, Date Flag

HISTORICAL CHANGES

2010 2010 Data changes:  CCR name (Date_Last_Pat_FU) changed to NAACCR name. Revised Allowable Values, Source and Update logic information to match NAACCRv12 date scheme.  Added IF 605, 624, 626, 841.

07/08/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.