wiki:Hicdep_1.100/TableCANC

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

For new cohorts we propose to use ICD9/10 coding schemes for cancer location and ICD-O-3 for histology if these results can be obtained from cancer registries.

Each row of tblCANC consists of a diagnosis of one cancer type.

If AIDS defining cancers are reported in tblCANC they should NOT be deleted from tblDIS.

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

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 HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
Last modified 18 months ago Last modified on 12/02/15 09:39:32