California Cancer Reporting System Standards, Volume III

 

Date of Birth

IDENTIFIERS

CCR ID

NAACCR ID

E1033

240

DESCRIPTION

Birth date (CCYYMMDD) of the patient. Used to supplement patient identification for linkage, determine age at diagnosis, and to carry out cohort analyses.

LEVELS

Patients, Admissions

LENGTH

8

ALLOWABLE VALUES

er049 Date of Birth

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 Birth and Date of Birth 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.

Also, see CS Version Derived.

UPDATE

Patient Level

New Case Consolidation

If either of the following conditions are true:

    • The Admission’s Date of Birth contains a full or partial date and the Patient’s Date of Birth is blank

    • Any part of the patient’s Date of Birth is blank, that same part of the admission’s Date of Birth is entered, and other entered parts are equal

Then automatically update the patient’s Date of Birth and Date of Birth Flag values with the admission’s corresponding values

Manual Change*, **

Admission Level

Manual Change 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’s Date of Last Contact and Vital Status for a patient 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:

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

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

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

CONSOLIDATED DATA EXTRACT

Yes

INTERFIELD EDITS

IF602 Date of Birth, Date of Diagnosis

IF604 Date of Birth, Date of 1st Contact

IF895 Date of Birth, Date Flag (NAACCR)

HISTORICAL CHANGES

1/1/99

Century 20 added to allowable values.

7/6/01

Reference ICDO-3 histology in corrections section.

2010

2010 Data Changes--NAACCR changed name of field to Date of Birth (was Birth Date). Changed name in Update logic and edits. Revised Allowable Values and Source information to match NAACCRv12 date scheme.  Added IF #895.

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.