tmpCOSD_CORE_DATA


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
CancerSite varchar 50 null
PatientID int 4 null
IsPrimary bit 1 ((0))
IsRecurrence bit 1 ((0))
IsProgression bit 1 ((0))
IsTransformation bit 1 ((0))
NHSNumber varchar 10 null
NHSValid int 4 null
LocalPatientId varchar 20 √ null
NHSNumberStatusIndicator varchar 2 √ null
Birthdate date 20 √ null
OrganisationIdentifierCodeOfProvider varchar 5 √ null
PrimaryDiagnosis varchar 5 √ null
ClinicalDateCancerDiagnosis date 20 √ null
PersonFamilyName varchar 60 √ null
PersonGivenName varchar 50 √ null
ADDRESS1 varchar 150 √ null
ADDRESS2 varchar 150 √ null
ADDRESS3 varchar 150 √ null
ADDRESS4 varchar 150 √ null
ADDRESS5 varchar 150 √ null
Postcode varchar 10 √ null
Gender varchar 2 √ null
PersonStatedSexualOrientationCodeAtDiagnosis char 1 √ null
GMPSpecified varchar 8 √ null
GMPRegistration varchar 6 √ null
PersonBirthFamilyName varchar 60 √ null
Ethnicity varchar 50 √ null
SourceOfReferralOutPatients varchar 2 √ null
DateFirstSeen date 20 √ null
ProfessionalRegistrationIssuerCodeConsultantFirstSeen char 2 √ null
ProfessionalRegistrationEntryIdentifierConsultantFirstSeen varchar 8 √ null
OrganisationSiteIdentifierOfProviderFirstSeen varchar 5 √ null
DateFirstSeenCancerSpecialist date 20 √ null
OrganisationSiteIdentifierOfProviderFirstCancerSpecialist varchar 5 √ null
CancerOrSymptomaticBreastReferralPatientStatus varchar 2 √ null
CancerSymptomsDateFirstNoted varchar 10 √ null
TumourLaterality varchar 1 √ null
BasisOfDiagnosisCancer int 4 √ null
MorphologySnomedDiagnosis varchar 10 √ null
MorphologyIcdo3 varchar 8 √ null
TopographyIcdo3 varchar 7 √ null
GradeOfDifferentiationAtDiagnosis varchar 2 √ null
ClinicalNurseSpecialistIndicationCode varchar 2 √ null
SmokingStatusCode varchar 2 √ null
TobaccoSmokingCessation char 1 √ null
AlcoholHistoryCancerInLastThreeMonths char 1 √ null
AlcoholHistoryCancerBeforeLastThreeMonths char 1 √ null
CurrentPhysicalActivity char 1 √ null
MenopausalStatus char 1 √ null
DiabetesMellitusIndicator char 1 √ null
FinalPreTreatmentTNMDate date 20 √ null
FinalPreTreatmentTCategory varchar 10 √ null
FinalPreTreatmentNCategory varchar 10 √ null
FinalPreTreatmentMCategory varchar 10 √ null
FinalPreTreatmentTNMStageGrouping varchar 20 √ null
OrganisationSiteIdentifierOfTNMStageGroupingFinalPretreatment varchar 5 √ null
IntegratedStageTNMDate date 20 √ null
IntegratedStageTCategory varchar 10 √ null
IntegratedStageNCategory varchar 10 √ null
IntegratedStageMCategory varchar 10 √ null
IntegratedStageTNMStageGrouping varchar 20 √ null
OrganisationSiteIdentifierOfTNMStageGroupingIntegrated varchar 5 √ null
TNMCodingEdition int 4 √ null
TNMVersionNumberStaging varchar 2 √ null
PalliativeCareSpecialistSeenIndicatorCancerRecurrence varchar 1 √ null
PersonDeathDate date 20 √ null
DeathLocationType int 4 √ null
OrganisationSiteIdentifierOfDiagnosis varchar 5 √ null
SnomedVersionDiagnosis varchar 2 √ null
PerformanceStatusAdult int 4 √ null
DiagnosisCodeSnomedCt varchar 18 √ null
IsLiver int 4 null
NonPrimaryCancerPathwayType varchar 2 √ null
CancerProgressionICD varchar 5 √ null
CancerProgressionAgreedDatePrimaryCancerPathway varchar 2147483647 √ null
PrimaryDiagnosisSubsidiaryComment varchar 50 √ null
OtherSignificantDiagnosisSubsidiaryComment varchar 50 √ null
FamilialCancerSyndrome varchar 1 √ null
FamilialCancerSyndromeSubsidiaryComment varchar 50 √ null
TissueBankedAtDiagnosisIndicator varchar 1 √ null
SecondaryDiagICD1 varchar 6 √ null
SecondaryDiagICD2 varchar 6 √ null
SecondaryDiagICD3 varchar 6 √ null
SecondaryDiagICD4 varchar 6 √ null
BankedTissueTumour int 4 √ null
BankedTissueBlood int 4 √ null
BankedTissueCSF int 4 √ null
BankedTissueBoneMarrow int 4 √ null
BankedTissueUrine int 4 √ null
MorphologySNOMEDCancerTransformation varchar 2147483647 √ null
MorphologyICDOCancerTransformation varchar 2147483647 √ null
CancerTransformationAgreedDatePrimaryCancerPathway varchar 2147483647 √ null
SNOMEDVersionCancerTransformation varchar 2147483647 √ null
PaedCancerSite varchar 50 √ null
BetaHumanChorionicGonadotropinSerum int 4 √ null
AlphaFetoproteinSerum int 4 √ null
LdhValue int 4 √ null
LaboratoryResultDate smalldatetime 16 √ null
OrganisationIdentifierLaboratoryResult varchar 10 √ null
RelapseMorphology char 1 √ null
RelapseFlow char 1 √ null
RelapseMolecular char 1 √ null
RelapseClinicalExamination char 1 √ null
RelapseOther char 1 √ null
IsAdditionalPaedRecord int 4 null
Username varchar 100 null
TabNumber int 4 null

Indexes

Constraint Name Type Sort Column(s)
PK_tmpCOSD_CORE_DATA Primary key Asc/Asc/Asc/Asc CareID + CancerSite + IsAdditionalPaedRecord + Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors