California Cancer Reporting System Standards, Volume III

RX Date Transp Endo

IDENTIFIERS

DESCRIPTION

Date that the Transplant/Endocrine procedure was done.

LEVELS

Tumor

Admission

LENGTH

8

ALLOWABLE VALUES

er230 RX Date--Transplt/Endocr

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. Convert Date of Last Contact and Date of Last 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

Tumor Level

New Case Consolidation:

If all of the following conditions are true:

the Admission shows that transplant/endocrine therapy was given (RX Summ—Transplnt/Endocr = 10, 11, 12, 20, 30, or 40)

either of the following conditions are true:

the Admission & Tumor RX Summ—Transplnt/Endocr codes are the same

the Tumor’s RX Summ—Transplnt/Endocr code shows that no transplant/endocrine therapy was given

any of the following conditions are true:

the Admission’s RX Date--Transplnt/Endocr contains a full or partial date and the Tumor’s RX Date--Transplnt/Endocr is blank

the Admission’s RX Date--Transplnt/Endocr Flag shows that treatment occurred but we don’t know when (code 12) and the Tumor’s RX Date--Transplnt/Endocr Flag does NOT show that treatment occurred (codes 10, 11, 15)

Any part* of the Tumor’s RX Date--Transplnt/Endocr is blank, that same part of the Admission’s RX Date--Transplnt/Endocr is entered, and other entered parts are equal

Then automatically consolidate

the Admission’s RX Date--Transplnt/Endocr into the Tumor’s  RX Date--Transplnt/Endocr**

the Admission’s RX Date--Transplnt/Endocr Flag into the Tumor’s RX Date--Transplnt/Endocr Flag

the Admission’s RX Summ—Transplnt/Endocr into the Tumor’s RX Summ--Transplnt/Endocr

Otherwise, if any of the above three transplant/endocrine therapy summary values differ between the admission and tumor, then

List both sets of summary codes, dates, & flag codes for review

Manual Change*,**

Admission Level

Manual Change 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). RX Date--Systemic and RX Date—Systemic Flag and Date of Initial RX--SEER and Date of Initial RX Flag may also need to be changed (See RX Date--Systemic and Date of Initial RX--SEER UPDATE sections).

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

CONSOLIDATED DATA EXTRACT

Yes

INTERFIELD EDITS

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

IF455 RX Date Transplnt/Endocr Date of Dx

IF456 RX Date--Transplnt Endo, RX Summ—Transplnt/Endocr

IF717 DCO, RX Date--Transplant/Endocrine Flag

IF836 RX Date--Transplnt Endocr, Date Flag

IF842 Class 20-33 (Eureka)

IF1144: Class of Case 20-22, Treatment

HISTORICAL CHANGES