ADH Cancer Registry Data (Version 23 Layout)

ATTENTION: The Cancer Registry layout has changed for years 2020 forward.

Cancer Registry data is provided to the Arkansas APCD by the Arkansas Department of Health. The Arkansas Central Cancer Registry (ACCR) is a population-based registry designed to collect timely and complete data on cancer cases diagnosed in the state of Arkansas. Events diagnosed in 2013 and onward are available for selection. Cancer Registry data is provided as a full file replace each year and contains the most updated version of cancer registry records. The Cancer Registry never closes out a year for processing. Older cases received from reporting facilities are processed as soon as they are received (This is why central Cancer Registries submit all diagnosis years annually to the CDC and NAACCR for dissemination).

Patient identifiers can change over time as patient and tumor records get consolidated. De-duplication of tumor and patient records is used to ensure each record is a single incidence of cancer. As such, patient identifiers (CaseID) can change. It is recommend to use APCD_Unique_ID and Patient Sex to help consolidate records.

The Arkansas Cancer Registry data definitions can be found in the supporting tool, the North American Association of Central Cancer Registries (NAACCR). The NAACCR data dictionary is located here: https://apps.naaccr.org/data-dictionary/data-dictionary/version=23/chapter-view/record-layout-table/

Cancer registries use a specialized set of ICD codes called ICD-O: https://apps.who.int/iris/bitstream/handle/10665/96612/9789241548496_eng.pdf. Coding Guidelines: SEER ICD-O-3 Coding Materials

How to find data element definitions:

Each variable has an associated NAACCR Item number in the NAACCR.html tool.

identify the Column Name of the desired element in the table below
open the NAACCR data dictionary - https://apps.naaccr.org/data-dictionary/data-dictionary/version=23/chapter-view/record-layout-table/
once in the tool, search the XML_NAACCR_ID column for the column name from the table below. Once located, click on the XML_NAACCR_ID for the detailed definitions.

COLUMN_NAME	FORMAT	LENGTH
RecKey (Unique row number assigned by Arkansas APCD for tracking purposes.)	bigint	NULL
abstractedBy	varchar	3
accessionNumberHosp	varchar	3
addrAtDxCity	varchar	28
addrAtDxCountry	varchar	6
addrAtDxPostalCode	varchar	12
addrAtDxState	varchar	50
addrCurrentCountry	varchar	6
addrCurrentState	varchar	50
adenoidCysticBasaloidPattern	varchar	8
adenopathy	varchar	4
afpPostOrchiectomyLabValue	varchar	10
afpPostOrchiectomyRange	varchar	4
afpPreOrchiectomyLabValue	varchar	10
afpPreOrchiectomyRange	varchar	4
afpPretreatmentInterpretation	varchar	4
afpPretreatmentLabValue	varchar	9
AGE (Patient age derived by Arkansas APCD based on Date of Birth and pull date)	numeric	NULL
ageAtDiagnosis	varchar	6
ajccApiVersionCurrent	varchar	3
ajccApiVersionOriginal	varchar	3
ajccCancerSurvApiVersionCurrent	varchar	3
ajccCancerSurvApiVersionOriginal	varchar	3
ajccId	varchar	7
ajccTnmClinM	varchar	10
ajccTnmClinN	varchar	10
ajccTnmClinNSuffix	varchar	7
ajccTnmClinStageGroup	varchar	18
ajccTnmClinT	varchar	14
ajccTnmClinTSuffix	varchar	6
ajccTnmPathM	varchar	10
ajccTnmPathN	varchar	11
ajccTnmPathNSuffix	varchar	7
ajccTnmPathStageGroup	varchar	18
ajccTnmPathT	varchar	14
ajccTnmPathTSuffix	varchar	6
ajccTnmPostTherapyClinM	varchar	6
ajccTnmPostTherapyClinN	varchar	7
ajccTnmPostTherapyClinNSuffix	varchar	3
ajccTnmPostTherapyClinStageGrp	varchar	3
ajccTnmPostTherapyClinT	varchar	8
ajccTnmPostTherapyClinTSuffix	varchar	3
ajccTnmPostTherapyM	varchar	7
ajccTnmPostTherapyN	varchar	11
ajccTnmPostTherapyNSuffix	varchar	7
ajccTnmPostTherapyStageGroup	varchar	6
ajccTnmPostTherapyT	varchar	15
ajccTnmPostTherapyTSuffix	varchar	6
alkRearrangement	varchar	3
ambiguousTerminologyDx	varchar	4
anemia	varchar	4
archiveFin	varchar	3
autopsy	varchar	4
bSymptoms	varchar	4
behaviorCodeIcdO3	varchar	4
behaviorIcdO1	varchar	3
behaviorIcdO2	varchar	4
bilirubinPretxTotalLabValue	varchar	8
bilirubinPretxUnitOfMeasure	varchar	4
birthplace	varchar	6
birthplaceCountry	varchar	50
birthplaceState	varchar	50
boneInvasion	varchar	4
brafMutationalAnalysis	varchar	3
brainMolecularMarkers	varchar	5
breslowTumorThickness	varchar	7
ca125PretreatmentInterpretation	varchar	4
ca199PretxLabValue	varchar	3
cancerStatus	varchar	4
casefindingSource	varchar	5
causeOfDeath	varchar	7
ceaPretreatmentInterpretation	varchar	4
ceaPretreatmentLabValue	varchar	9
censusBlockGroup2000	varchar	4
censusBlockGroup2010	varchar	4
censusBlockGroup2020	varchar	4
censusIndCode2010	varchar	7
censusOccCode2010	varchar	7
censusOccIndSys7000	varchar	4
censusTrCertainty2000	varchar	4
censusTrCertainty2010	varchar	4
censusTrPovertyIndictr	varchar	4
censusTract2000	varchar	9
censusTract2010	varchar	9
censusTract2020	varchar	9
censusTractCertainty2020	varchar	4
chromosome19qLossHeterozygosity	varchar	4
chromosome1pLossHeterozygosity	varchar	4
chromosome3Status	varchar	4
chromosome8qStatus	varchar	4
circumferentialResectionMargin	varchar	7
classOfCase	varchar	3
clinicalMarginWidth	varchar	3
cocAccreditedFlag	varchar	4
cocCodingSysCurrent	varchar	5
cocCodingSysOriginal	varchar	5
codingSystemForEod	varchar	4
comorbidComplication1	varchar	8
comorbidComplication10	varchar	8
comorbidComplication2	varchar	8
comorbidComplication3	varchar	8
comorbidComplication4	varchar	8
comorbidComplication5	varchar	8
comorbidComplication6	varchar	8
comorbidComplication7	varchar	8
comorbidComplication8	varchar	8
comorbidComplication9	varchar	8
computedEthnicity	varchar	4
computedEthnicitySource	varchar	4
countyAtDx	varchar	6
countyAtDxAnalysis	varchar	6
countyAtDxGeocode2000	varchar	6
countyAtDxGeocode2010	varchar	6
countyAtDxGeocode2020	varchar	6
crcChecksum	varchar	3
creatininePretreatmentLabValue	varchar	7
creatininePretxUnitOfMeasure	varchar	4
csExtension	varchar	6
csLymphNodes	varchar	6
csLymphNodesEval	varchar	4
csMetsAtDx	varchar	5
csMetsAtDxBone	varchar	4
csMetsAtDxBrain	varchar	4
csMetsAtDxLiver	varchar	4
csMetsAtDxLung	varchar	4
csMetsEval	varchar	4
csSiteSpecificFactor1	varchar	6
csSiteSpecificFactor10	varchar	6
csSiteSpecificFactor11	varchar	6
csSiteSpecificFactor12	varchar	6
csSiteSpecificFactor13	varchar	6
csSiteSpecificFactor14	varchar	6
csSiteSpecificFactor15	varchar	6
csSiteSpecificFactor16	varchar	6
csSiteSpecificFactor17	varchar	6
csSiteSpecificFactor18	varchar	6
csSiteSpecificFactor19	varchar	6
csSiteSpecificFactor2	varchar	6
csSiteSpecificFactor20	varchar