tblCANC - Diagnosis of Cancer

holds type and date of diagnosis of cancer

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name Format Description
PATIENT character (or numeric if possible) Patient id
CANC_D yyyy-mm-dd Date of diagnosis
CANC_D_A character: see coding of date precision optional precision annotation for date of diagnosis
LOC_CODE character Location code according to diagnosis
LOC_CODE_SYS character Location coding System: ICD10, ICD9, other systems, e.g. NA-ACCORD-short list
HIST_CODE character Histology code according to diagnosis
HIST_CODE_SYS character Histology coding system: ICD-O-3, other systems, e.g. NA-ACCORD-short list, None

Additional Fields

Field name Format Description
DIAG_ADJUD_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Diagnosis centrally adjudicated
DIAG_VALID_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Diagnosis histologically confirmed
REGISTRY_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Coding and Diagnosis taken from cancer registry
HIST_AVAILABLE_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 2 = Summary available
  • 9 = Unknown
Histology available
HIST_SUMMARY character If HIST_AVAILABLE_Y = 1 or 2, please store a copy of the full report and provide a short free text histology summary here.
CANC_HISTORY_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Has the patient previously received radiotherapy, chemotherapy or surgery for a malignant disease
CANC_HISTORY_D yyyy If yes, provide first year of treatment

QA Checks

Table Crosstable Error Code Description Study specific Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes