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: https://seer.cancer.gov/icd-o-3/
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 | 6 |
csSiteSpecificFactor21 | varchar | 6 |
csSiteSpecificFactor22 | varchar | 6 |
csSiteSpecificFactor23 | varchar | 6 |
csSiteSpecificFactor24 | varchar | 6 |
csSiteSpecificFactor25 | varchar | 6 |
csSiteSpecificFactor3 | varchar | 6 |
csSiteSpecificFactor4 | varchar | 6 |
csSiteSpecificFactor5 | varchar | 6 |
csSiteSpecificFactor6 | varchar | 6 |
csSiteSpecificFactor7 | varchar | 6 |
csSiteSpecificFactor8 | varchar | 6 |
csSiteSpecificFactor9 | varchar | 6 |
csTumorSize | varchar | 6 |
csTumorSizeExtEval | varchar | 4 |
csVersionDerived | varchar | 9 |
csVersionInputCurrent | varchar | 9 |
csVersionInputOriginal | varchar | 9 |
date1stCrsRxCoc | varchar | 11 |
dateCaseCompleted | varchar | 11 |
dateCaseCompletedCoc | varchar | 3 |
dateCaseInitiated | varchar | 11 |
dateCaseLastChanged | varchar | 11 |
dateCaseReportExported | varchar | 11 |
dateCaseReportLoaded | varchar | 11 |
dateCaseReportReceived | varchar | 11 |
dateConclusiveDx | varchar | 11 |
dateInitialRxSeer | varchar | 3 |
dateOf1stContact | varchar | 3 |
dateOfBirth | varchar | 11 |
dateOfDeathCanada | varchar | 11 |
dateOfDiagnosis | varchar | 11 |
dateOfInptAdm | varchar | 3 |
dateOfInptDisch | varchar | 3 |
dateOfLastCancerStatus | varchar | 11 |
dateOfLastContact | varchar | 11 |
dateOfMultTumors | varchar | 11 |
dateRegionalLNDissection | varchar | 11 |
dateSentinelLymphNodeBiopsy | varchar | 11 |
dateTumorRecordAvailbl | varchar | 11 |
dcStateFileNumber | varchar | 128 |
derivedAjcc6M | varchar | 5 |
derivedAjcc6MDescript | varchar | 4 |
derivedAjcc6N | varchar | 5 |
derivedAjcc6NDescript | varchar | 4 |
derivedAjcc6StageGrp | varchar | 5 |
derivedAjcc6T | varchar | 5 |
derivedAjcc6TDescript | varchar | 4 |
derivedAjcc7M | varchar | 6 |
derivedAjcc7MDescript | varchar | 4 |
derivedAjcc7N | varchar | 6 |
derivedAjcc7NDescript | varchar | 4 |
derivedAjcc7StageGrp | varchar | 6 |
derivedAjcc7T | varchar | 6 |
derivedAjcc7TDescript | varchar | 4 |
derivedAjccFlag | varchar | 4 |
derivedEod2018M | varchar | 9 |
derivedEod2018N | varchar | 11 |
derivedEod2018StageGroup | varchar | 10 |
derivedEod2018T | varchar | 13 |
derivedNeoadjuvRxFlag | varchar | 3 |
derivedPostrx7M | varchar | 3 |
derivedPostrx7N | varchar | 3 |
derivedPostrx7StgeGrp | varchar | 3 |
derivedPostrx7T | varchar | 3 |
derivedPrerx7M | varchar | 3 |
derivedPrerx7MDescrip | varchar | 3 |
derivedPrerx7N | varchar | 3 |
derivedPrerx7NDescrip | varchar | 3 |
derivedPrerx7StageGrp | varchar | 3 |
derivedPrerx7T | varchar | 3 |
derivedPrerx7TDescrip | varchar | 3 |
derivedRaiStage | varchar | 4 |
derivedSeerClinStgGrp | varchar | 6 |
derivedSeerCmbMSrc | varchar | 4 |
derivedSeerCmbNSrc | varchar | 4 |
derivedSeerCmbStgGrp | varchar | 6 |
derivedSeerCmbTSrc | varchar | 4 |
derivedSeerCombinedM | varchar | 7 |
derivedSeerCombinedN | varchar | 7 |
derivedSeerCombinedT | varchar | 7 |
derivedSeerPathStgGrp | varchar | 6 |
derivedSs1977 | varchar | 4 |
derivedSs1977Flag | varchar | 4 |
derivedSs2000 | varchar | 4 |
derivedSs2000Flag | varchar | 4 |
derivedSummaryStage2018 | varchar | 4 |
diagnosticConfirmation | varchar | 4 |
diagnosticProc7387 | varchar | 3 |
edpMdeLink | varchar | 4 |
edpMdeLinkDate | varchar | 11 |
egfrMutationalAnalysis | varchar | 3 |
ehrReporting | varchar | 3 |
eodExtension | varchar | 5 |
eodExtensionProstPath | varchar | 5 |
eodLymphNodeInvolv | varchar | 4 |
eodMets | varchar | 5 |
eodOld13Digit | varchar | 3 |
eodOld2Digit | varchar | 3 |
eodOld4Digit | varchar | 3 |
eodPrimaryTumor | varchar | 6 |
eodRegionalNodes | varchar | 6 |
eodTumorSize | varchar | 6 |
esophagusAndEgjTumorEpicenter | varchar | 4 |
estrogenReceptorPercntPosOrRange | varchar | 6 |
estrogenReceptorSummary | varchar | 4 |
estrogenReceptorTotalAllredScore | varchar | 5 |
extranodalExtensionClin | varchar | 4 |
extranodalExtensionHeadNeckClin | varchar | 4 |
extranodalExtensionHeadNeckPath | varchar | 6 |
extranodalExtensionPath | varchar | 4 |
extravascularMatrixPatterns | varchar | 4 |
fibrosisScore | varchar | 4 |
figoStage | varchar | 7 |
followUpContactCity | varchar | 28 |
followUpContactPostal | varchar | 12 |
followUpContactState | varchar | 5 |
followUpSource | varchar | 4 |
followUpSourceCentral | varchar | 5 |
followingRegistry | varchar | 3 |
followupContactCountry | varchar | 6 |
gestationalTrophoblasticPxIndex | varchar | 5 |
gisCoordinateQuality | varchar | 5 |
gleasonPatternsClinical | varchar | 5 |
gleasonPatternsPathological | varchar | 5 |
gleasonScoreClinical | varchar | 5 |
gleasonScorePathological | varchar | 5 |
gleasonTertiaryPattern | varchar | 5 |
grade | varchar | 4 |
gradeClinical | varchar | 4 |
gradeIcdO1 | varchar | 3 |
gradePathSystem | varchar | 4 |
gradePathValue | varchar | 4 |
gradePathological | varchar | 4 |
gradePostTherapy | varchar | 4 |
gradePostTherapyClin | varchar | 4 |
hcgPostOrchiectomyLabValue | varchar | 10 |
hcgPostOrchiectomyRange | varchar | 4 |
hcgPreOrchiectomyLabValue | varchar | 10 |
hcgPreOrchiectomyRange | varchar | 4 |
her2IhcSummary | varchar | 4 |
her2IshDualProbeCopyNumber | varchar | 7 |
her2IshDualProbeRatio | varchar | 7 |
her2IshSingleProbeCopyNumber | varchar | 7 |
her2IshSummary | varchar | 4 |
her2OverallSummary | varchar | 4 |
heritableTrait | varchar | 4 |
highRiskCytogenetics | varchar | 4 |
highRiskHistologicFeatures | varchar | 4 |
histologicSubtype | varchar | 3 |
histologicTypeIcdO3 | varchar | 7 |
histologyIcdO1 | varchar | 3 |
histologyIcdO2 | varchar | 7 |
hivStatus | varchar | 4 |
iNRProthrombinTime | varchar | 6 |
icdO3ConversionFlag | varchar | 4 |
icdRevisionComorbid | varchar | 4 |
icdRevisionNumber | varchar | 4 |
ihsLink | varchar | 4 |
ihsPurchRefCareDeliveryArea | varchar | 3 |
industrySource | varchar | 4 |
inpatientStatus | varchar | 3 |
institutionReferredFrom | varchar | 3 |
institutionReferredTo | varchar | 3 |
invasionBeyondCapsule | varchar | 4 |
ipsilateralAdrenalGlandInvolve | varchar | 4 |
jak2 | varchar | 4 |
ki67 | varchar | 8 |
kitGeneImmunohistochemistry | varchar | 4 |
kras | varchar | 4 |
laterality | varchar | 4 |
ldhPostOrchiectomyRange | varchar | 4 |
ldhPreOrchiectomyRange | varchar | 4 |
ldhPretreatmentLabValue | varchar | 10 |
ldhPretreatmentLevel | varchar | 4 |
ldhUpperLimitsOfNormal | varchar | 6 |
lnAssessMethodFemoralInguinal | varchar | 4 |
lnAssessMethodParaaortic | varchar | 4 |
lnAssessMethodPelvic | varchar | 4 |
lnDistantAssessMethod | varchar | 4 |
lnDistantMediastinalScalene | varchar | 4 |
lnHeadAndNeckLevels1To3 | varchar | 4 |
lnHeadAndNeckLevels4To5 | varchar | 4 |
lnHeadAndNeckLevels6To7 | varchar | 4 |
lnHeadAndNeckOther | varchar | 4 |
lnIsolatedTumorCells | varchar | 4 |
lnLaterality | varchar | 4 |
lnPositiveAxillaryLevel1To2 | varchar | 5 |
lnSize | varchar | 7 |
lnStatusFemorInguinParaaortPelv | varchar | 3 |
lnStatusFemoralInguinal | varchar | 4 |
lnStatusParaAortic | varchar | 4 |
lnStatusPelvic | varchar | 4 |
lymphVascularInvasion | varchar | 4 |
lymphocytosis | varchar | 4 |
macroscopicEvalOfTheMesorectum | varchar | 5 |
majorVeinInvolvement | varchar | 4 |
maritalStatusAtDx | varchar | 4 |
measuredBasalDiameter | varchar | 7 |
measuredThickness | varchar | 7 |
methylationOfO6MGMT | varchar | 4 |
metsAtDxBone | varchar | 4 |
metsAtDxBrain | varchar | 4 |
metsAtDxDistantLn | varchar | 4 |
metsAtDxLiver | varchar | 4 |
metsAtDxLung | varchar | 4 |
metsAtDxOther | varchar | 4 |
microsatelliteInstability | varchar | 4 |
microvascularDensity | varchar | 5 |
militaryRecordNoSuffix | varchar | 3 |
mitoticCountUvealMelanoma | varchar | 7 |
mitoticRateMelanoma | varchar | 5 |
morphCodingSysCurrent | varchar | 4 |
morphCodingSysOriginl | varchar | 4 |
multTumRptAsOnePrim | varchar | 5 |
multigeneSignatureMethod | varchar | 4 |
multigeneSignatureResults | varchar | 5 |
multiplicityCounter | varchar | 5 |
naaccrRecordVersion | varchar | 6 |
nccnInternationalPrognosticIndex | varchar | 5 |
ncdbCovid19TxImpact | varchar | 4 |
ncdbSarsCov2Pos | varchar | 4 |
ncdbSarsCov2PosDate | varchar | 11 |
ncdbSarsCov2Test | varchar | 4 |
neoadjuvTherapyClinicalResponse | varchar | 4 |
neoadjuvTherapyTreatmentEffect | varchar | 4 |
neoadjuvantTherapy | varchar | 4 |
nextFollowUpSource | varchar | 4 |
nhiaDerivedHispOrigin | varchar | 4 |
noPatientContactFlag | varchar | 4 |
npcrDerivedAjcc8TnmClinStgGrp | varchar | 3 |
npcrDerivedAjcc8TnmPathStgGrp | varchar | 3 |
npcrDerivedAjcc8TnmPostStgGrp | varchar | 3 |
npcrDerivedClinStgGrp | varchar | 6 |
npcrDerivedPathStgGrp | varchar | 6 |
npiArchiveFin | varchar | 3 |
npiFollowingRegistry | varchar | 3 |
npiInstReferredFrom | varchar | 3 |
npiInstReferredTo | varchar | 3 |
npiPhysician3 | varchar | 13 |
npiPhysician4 | varchar | 13 |
npiPhysicianFollowUp | varchar | 13 |
npiPhysicianManaging | varchar | 13 |
npiPhysicianPrimarySurg | varchar | 13 |
npiRegistryId | varchar | 3 |
npiReportingFacility | varchar | 3 |
nrasMutationalAnalysis | varchar | 3 |
numberOfCoresExamined | varchar | 5 |
numberOfCoresPositive | varchar | 5 |
numberOfExaminedParaAorticNodes | varchar | 5 |
numberOfExaminedPelvicNodes | varchar | 5 |
numberOfPositiveParaAorticNodes | varchar | 5 |
numberOfPositivePelvicNodes | varchar | 5 |
numberPhasesOfRadTxToVolume | varchar | 5 |
occupationSource | varchar | 4 |
oncotypeDxRecurrenceScoreDcis | varchar | 6 |
oncotypeDxRecurrenceScoreInvasiv | varchar | 6 |
oncotypeDxRiskLevelDcis | varchar | 4 |
oncotypeDxRiskLevelInvasive | varchar | 4 |
organomegaly | varchar | 4 |
overRideAcsnClassSeq | varchar | 4 |
overRideAgeSiteMorph | varchar | 4 |
overRideCocSiteType | varchar | 4 |
overRideCs1 | varchar | 3 |
overRideCs10 | varchar | 3 |
overRideCs11 | varchar | 3 |
overRideCs12 | varchar | 3 |
overRideCs13 | varchar | 3 |
overRideCs14 | varchar | 3 |
overRideCs15 | varchar | 3 |
overRideCs16 | varchar | 3 |
overRideCs17 | varchar | 3 |
overRideCs18 | varchar | 3 |
overRideCs19 | varchar | 3 |
overRideCs2 | varchar | 3 |
overRideCs20 | varchar | 3 |
overRideCs3 | varchar | 3 |
overRideCs4 | varchar | 3 |
overRideCs5 | varchar | 3 |
overRideCs6 | varchar | 3 |
overRideCs7 | varchar | 3 |
overRideCs8 | varchar | 3 |
overRideCs9 | varchar | 3 |
overRideHistology | varchar | 4 |
overRideHospseqDxconf | varchar | 4 |
overRideHospseqSite | varchar | 4 |
overRideIllDefineSite | varchar | 4 |
overRideLeukLymphoma | varchar | 4 |
overRideNameSex | varchar | 4 |
overRideReportSource | varchar | 4 |
overRideSeqnoDxconf | varchar | 4 |
overRideSiteBehavior | varchar | 4 |
overRideSiteEodDxDt | varchar | 4 |
overRideSiteLatEod | varchar | 4 |
overRideSiteLatMorph | varchar | 4 |
overRideSiteLatSeqno | varchar | 4 |
overRideSiteTnmStggrp | varchar | 4 |
overRideSiteType | varchar | 4 |
overRideSsNodespos | varchar | 4 |
overRideSsTnmM | varchar | 4 |
overRideSsTnmN | varchar | 4 |
overRideSurgDxconf | varchar | 4 |
overRideTnm3 | varchar | 3 |
overRideTnmStage | varchar | 4 |
overRideTnmTis | varchar | 4 |
p16 | varchar | 3 |
PatientIdNumber | varchar | 128 |
patientSystemIdHosp | varchar | 3 |
pediatricStage | varchar | 3 |
pediatricStagedBy | varchar | 3 |
pediatricStagingSystem | varchar | 3 |
percentNecrosisPostNeoadjuvant | varchar | 8 |
perineuralInvasion | varchar | 4 |
peripheralBloodInvolvement | varchar | 4 |
peritonealCytology | varchar | 4 |
phase1DosePerFraction | varchar | 8 |
phase1NumberOfFractions | varchar | 6 |
phase1RadiationExternalBeamTech | varchar | 5 |
phase1RadiationPrimaryTxVolume | varchar | 5 |
phase1RadiationToDrainingLN | varchar | 5 |
phase1RadiationTreatmentModality | varchar | 5 |
phase1TotalDose | varchar | 9 |
phase2DosePerFraction | varchar | 8 |
phase2NumberOfFractions | varchar | 6 |
phase2RadiationExternalBeamTech | varchar | 5 |
phase2RadiationPrimaryTxVolume | varchar | 5 |
phase2RadiationToDrainingLN | varchar | 5 |
phase2RadiationTreatmentModality | varchar | 5 |
phase2TotalDose | varchar | 9 |
phase3DosePerFraction | varchar | 8 |
phase3NumberOfFractions | varchar | 6 |
phase3RadiationExternalBeamTech | varchar | 5 |
phase3RadiationPrimaryTxVolume | varchar | 5 |
phase3RadiationToDrainingLN | varchar | 5 |
phase3RadiationTreatmentModality | varchar | 5 |
phase3TotalDose | varchar | 9 |
physician3 | varchar | 11 |
physician4 | varchar | 11 |
physicianFollowUp | varchar | 11 |
physicianManaging | varchar | 11 |
physicianPrimarySurg | varchar | 11 |
placeOfDeath | varchar | 6 |
placeOfDeathCountry | varchar | 50 |
placeOfDeathState | varchar | 50 |
pleuralEffusion | varchar | 4 |
primaryPayerAtDx | varchar | 5 |
primarySclerosingCholangitis | varchar | 4 |
primarySite | varchar | 7 |
profoundImmuneSuppression | varchar | 4 |
progesteroneRecepPrcntPosOrRange | varchar | 6 |
progesteroneRecepSummary | varchar | 4 |
progesteroneRecepTotalAllredScor | varchar | 5 |
prostatePathologicalExtension | varchar | 6 |
psaLabValue | varchar | 8 |
qualityOfSurvival | varchar | 3 |
race1 | varchar | 5 |
race2 | varchar | 5 |
race3 | varchar | 5 |
race4 | varchar | 5 |
race5 | varchar | 5 |
raceCodingSysCurrent | varchar | 3 |
raceCodingSysOriginal | varchar | 4 |
raceNapiia | varchar | 5 |
radBoostDoseCgy | varchar | 3 |
radBoostRxModality | varchar | 5 |
radLocationOfRx | varchar | 3 |
radNoOfTreatmentVol | varchar | 3 |
radRegionalDoseCgy | varchar | 3 |
radRegionalRxModality | varchar | 5 |
radTreatmentVolume | varchar | 3 |
radiationTxDiscontinuedEarly | varchar | 5 |
readmSameHosp30Days | varchar | 3 |
reasonForNoRadiation | varchar | 4 |
reasonForNoSurgery | varchar | 4 |
recordNumberRecode | varchar | 5 |
recordType | varchar | 4 |
recurrenceDate1st | varchar | 11 |
recurrenceType1st | varchar | 5 |
regionalNodesExamined | varchar | 5 |
regionalNodesPositive | varchar | 5 |
registryId | varchar | 13 |
registryType | varchar | 4 |
reportingFacility | varchar | 3 |
reportingFacilityRestrictionFlag | varchar | 5 |
residualTumVolPostCytoreduction | varchar | 5 |
responseToNeoadjuvantTherapy | varchar | 4 |
rqrsNcdbSubmissionFlag | varchar | 3 |
ruca2000 | varchar | 4 |
ruca2010 | varchar | 4 |
ruralurbanContinuum1993 | varchar | 5 |
ruralurbanContinuum2003 | varchar | 5 |
ruralurbanContinuum2013 | varchar | 5 |
rxCodingSystemCurrent | varchar | 5 |
rxDateBrm | varchar | 11 |
rxDateChemo | varchar | 11 |
rxDateDxStgProc | varchar | 11 |
rxDateHormone | varchar | 11 |
rxDateMostDefinSurg | varchar | 11 |
rxDateOther | varchar | 11 |
rxDateRadiation | varchar | 11 |
rxDateRadiationEnded | varchar | 3 |
rxDateSurgery | varchar | 11 |
rxDateSurgicalDisch | varchar | 3 |
rxDateSystemic | varchar | 11 |
rxHospBrm | varchar | 3 |
rxHospChemo | varchar | 3 |
rxHospDxStgProc | varchar | 3 |
rxHospHormone | varchar | 3 |
rxHospOther | varchar | 3 |
rxHospPalliativeProc | varchar | 3 |
rxHospRadiation | varchar | 3 |
rxHospRegLnRemoved | varchar | 3 |
rxHospScopeReg9802 | varchar | 3 |
rxHospScopeRegLnSur | varchar | 3 |
rxHospSurgApp2010 | varchar | 3 |
rxHospSurgOth9802 | varchar | 3 |
rxHospSurgOthRegDis | varchar | 3 |
rxHospSurgPrimSite | varchar | 3 |
rxHospSurgPrimSite2023 | varchar | 3 |
rxHospSurgSite9802 | varchar | 3 |
rxSummBrm | varchar | 5 |
rxSummChemo | varchar | 5 |
rxSummDxStgProc | varchar | 5 |
rxSummHormone | varchar | 5 |
rxSummOther | varchar | 4 |
rxSummPalliativeProc | varchar | 4 |
rxSummRadToCns | varchar | 4 |
rxSummRadiation | varchar | 4 |
rxSummReconstruct1st | varchar | 4 |
rxSummRegLnExamined | varchar | 5 |
rxSummScopeReg9802 | varchar | 4 |
rxSummScopeRegLnSur | varchar | 4 |
rxSummSurgOth9802 | varchar | 4 |
rxSummSurgOthRegDis | varchar | 4 |
rxSummSurgPrimSite | varchar | 5 |
rxSummSurgPrimSite2023 | varchar | 3 |
rxSummSurgRadSeq | varchar | 4 |
rxSummSurgSite9802 | varchar | 5 |
rxSummSurgeryType | varchar | 5 |
rxSummSurgicalApproch | varchar | 4 |
rxSummSurgicalMargins | varchar | 4 |
rxSummSystemicSurSeq | varchar | 4 |
rxSummTransplntEndocr | varchar | 5 |
rxSummTreatmentStatus | varchar | 4 |
sCategoryClinical | varchar | 4 |
sCategoryPathological | varchar | 4 |
sarcomatoidFeatures | varchar | 6 |
schemaDiscriminator1 | varchar | 4 |
schemaDiscriminator2 | varchar | 4 |
schemaDiscriminator3 | varchar | 3 |
schemaId | varchar | 8 |
schemaIdVersionCurrent | varchar | 3 |
schemaIdVersionOriginal | varchar | 3 |
secondaryDiagnosis1 | varchar | 10 |
secondaryDiagnosis10 | varchar | 10 |
secondaryDiagnosis2 | varchar | 10 |
secondaryDiagnosis3 | varchar | 10 |
secondaryDiagnosis4 | varchar | 10 |
secondaryDiagnosis5 | varchar | 10 |
secondaryDiagnosis6 | varchar | 10 |
secondaryDiagnosis7 | varchar | 10 |
secondaryDiagnosis8 | varchar | 10 |
secondaryDiagnosis9 | varchar | 10 |
seerCauseSpecificCod | varchar | 4 |
seerOtherCod | varchar | 4 |
seerSiteSpecificFact1 | varchar | 4 |
seerSiteSpecificFact2 | varchar | 3 |
seerSiteSpecificFact3 | varchar | 3 |
seerSiteSpecificFact4 | varchar | 3 |
seerSiteSpecificFact5 | varchar | 3 |
seerSiteSpecificFact6 | varchar | 3 |
seerSummaryStage1977 | varchar | 4 |
seerSummaryStage2000 | varchar | 4 |
sentinelLymphNodesExamined | varchar | 5 |
sentinelLymphNodesPositive | varchar | 5 |
separateTumorNodules | varchar | 4 |
sequenceNumberCentral | varchar | 5 |
sequenceNumberHospital | varchar | 3 |
serumAlbuminPretreatmentLevel | varchar | 4 |
serumBeta2MicroglobulinPretxLvl | varchar | 4 |
sex | varchar | 1 |
siteCodingSysCurrent | varchar | 4 |
siteCodingSysOriginal | varchar | 4 |
siteIcdO1 | varchar | 3 |
spanishHispanicOrigin | varchar | 4 |
stateAtDxGeocode2000 | varchar | 5 |
stateAtDxGeocode2010 | varchar | 5 |
stateAtDxGeocode2020 | varchar | 5 |
subsqRx2ndCourseBrm | varchar | 3 |
subsqRx2ndCourseChemo | varchar | 3 |
subsqRx2ndCourseDate | varchar | 3 |
subsqRx2ndCourseHorm | varchar | 3 |
subsqRx2ndCourseOth | varchar | 3 |
subsqRx2ndCourseRad | varchar | 3 |
subsqRx2ndCourseSurg | varchar | 3 |
subsqRx2ndRegLnRem | varchar | 3 |
subsqRx2ndScopeLnSu | varchar | 3 |
subsqRx2ndSurgOth | varchar | 3 |
subsqRx3rdCourseBrm | varchar | 3 |
subsqRx3rdCourseChemo | varchar | 3 |
subsqRx3rdCourseDate | varchar | 3 |
subsqRx3rdCourseHorm | varchar | 3 |
subsqRx3rdCourseOth | varchar | 3 |
subsqRx3rdCourseRad | varchar | 3 |
subsqRx3rdCourseSurg | varchar | 3 |
subsqRx3rdRegLnRem | varchar | 3 |
subsqRx3rdScopeLnSu | varchar | 3 |
subsqRx3rdSurgOth | varchar | 3 |
subsqRx4thCourseBrm | varchar | 3 |
subsqRx4thCourseChemo | varchar | 3 |
subsqRx4thCourseDate | varchar | 3 |
subsqRx4thCourseHorm | varchar | 3 |
subsqRx4thCourseOth | varchar | 3 |
subsqRx4thCourseRad | varchar | 3 |
subsqRx4thCourseSurg | varchar | 3 |
subsqRx4thRegLnRem | varchar | 3 |
subsqRx4thScopeLnSu | varchar | 3 |
subsqRx4thSurgOth | varchar | 3 |
subsqRxReconstructDel | varchar | 3 |
summaryStage2018 | varchar | 4 |
survDateActiveFollowup | varchar | 11 |
survDateDxRecode | varchar | 11 |
survDatePresumedAlive | varchar | 11 |
survFlagActiveFollowup | varchar | 4 |
survFlagPresumedAlive | varchar | 4 |
survMosActiveFollowup | varchar | 7 |
survMosPresumedAlive | varchar | 7 |
thrombocytopenia | varchar | 4 |
tnmClinDescriptor | varchar | 4 |
tnmClinM | varchar | 7 |
tnmClinN | varchar | 7 |
tnmClinStageGroup | varchar | 6 |
tnmClinStagedBy | varchar | 5 |
tnmClinT | varchar | 7 |
tnmEditionNumber | varchar | 5 |
tnmPathDescriptor | varchar | 4 |
tnmPathM | varchar | 7 |
tnmPathN | varchar | 7 |
tnmPathStageGroup | varchar | 6 |
tnmPathStagedBy | varchar | 5 |
tnmPathT | varchar | 7 |
tobaccoUseSmokingStatus | varchar | 4 |
totalDose | varchar | 9 |
tumorDeposits | varchar | 5 |
tumorGrowthPattern | varchar | 4 |
tumorMarker1 | varchar | 4 |
tumorMarker2 | varchar | 4 |
tumorMarker3 | varchar | 4 |
tumorRecordNumber | varchar | 5 |
tumorSizeClinical | varchar | 6 |
tumorSizePathologic | varchar | 6 |
tumorSizeSummary | varchar | 6 |
typeOfReportingSource | varchar | 4 |
uihoFacility | varchar | 3 |
ulceration | varchar | 4 |
unusualFollowUpMethod | varchar | 3 |
urbanIndianHealthOrganization | varchar | 3 |
uric2000 | varchar | 4 |
uric2010 | varchar | 4 |
vendorName | varchar | 12 |
visceralParietalPleuralInvasion | varchar | 4 |
vitalStatus | varchar | 4 |
vitalStatusRecode | varchar | 4 |
calcUihoFacility | varchar | 5 |
calcUric2000 | varchar | 4 |
calcUric2010 | varchar | 4 |
calcUrbanIndianHealthOrganization | varchar | 4 |
calcVitalStatusRecode | varchar | 4 |
calcYostQuintileUS | varchar | 4 |
calcYostQuintileState | varchar | 4 |
calcSeerBrainCnsRecode2020 | varchar | 5 |
calcSeerCauseSpecificCod | varchar | 4 |
calcSeerLymphNeoplasmRecode2021 | varchar | 5 |
calcSeerOtherCod | varchar | 4 |
calcSeerBehaviorRecode | varchar | 4 |
calcSeerSiteRecode | varchar | 8 |
CaseID (Masked) | varchar | 128 |
Recode | varchar | 50 |
Sub_Aggregate_Recode | varchar | 50 |
Aggregate_Recode | varchar | 50 |
APCD_UNIQUE_ID (ID representing individual on Arkansas APCD) | varchar | 128 |