California Cancer Reporting System Standards, Volume III

 

Date Case Report Loaded

DENTIFIERS

CCR ID

NAACCR ID

E1486

2112

DESCRIPTION

The date that this case report was loaded into the regional registry database for initiation of quality control activities.

LEVELS

Admissions

LENGTH

8

ALLOWABLE VALUES

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

Automatically generate current date when case is loaded (same as Transmission Log’s transmission date) but don’t record as a data conversion in the audit log.

UPDATE

None

CONSOLIDATED DATA EXTRACT

Yes; record with the earliest admission date for this tumor.

INTERFIELD EDITS

None

HISTORICAL CHANGES

12/02 Added logic to Interfield edit that allows for when year is equal to Date_Case_Load and month and day dates are unknown or when month and year are equal to Date_Case_Load and day is unknown.
3/04 Removed Interfield edits #300, 301, 302 & 600 and the Allowable values edit (#152).
7/05 Removed Interfield edit text to correctly reflect the removal of these edits from 3/3/04.
2010 2010 Data Changes:  CCR name (Date_Case_Load) changed to NAACCR name. Revised Allowable Values to use the date format of CCYYMMDD and the new interoperability date functions and rules.
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.