Page Comparison

COLUMN_NAME

DATA_TYPE

CHARACTER_MAXIMUM_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