tblCANC - Diagnosis of Cancer


holds type and date of diagnosis of cancer

There is a large heterogeneity across cohorts regarding the documentation of cancer diagnoses. Some use ICD9 or ICD10 for cancer location and have no information on histology. Others have cross-linked with cancer registries and are able to provide very granular ICD-O-3 histology codes. There are also proprietary systems such as the NA-ACCORD short list (instructions, list_1 & list_2). In tblCANC we suggest to not restrict to a single coding system but to allow cohorts to provide the data in different systems as long as definitions and mapping tables are submitted alongside the data.

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


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes