vwTertiaryReferralsReferral


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReferralCareID int 4 null
CancerSite varchar 50 √ null
SubSite int 4 √ null
SubSiteDesc nvarchar 100 √ null
SourceOfReferral varchar 2 √ null
SourceOfReferralDesc varchar 100 √ null
PriorityType varchar 2 √ null
PriorityTypeDesc varchar 60 √ null
PatientStatus varchar 2 √ null
PatientStatusDesc varchar 100 √ null
PrimaryDiagnosisParentCode varchar 5 √ null
PrimaryDiagnosis varchar 5 √ null
PrimaryDiagnosisDesc varchar 150 √ null
PrimaryDiagnosisSubsidiaryComment varchar 50 √ null
DiagnosisDate smalldatetime 16 √ null
ConsultantAtDiagnosisCode varchar 8 √ null
ConsultantAtDiagnosisDesc varchar 50 √ null
ConsultantAtDiagnosisAgeCode varchar 1 √ null
ConsultantAtDiagnosisAgeDesc varchar 50 √ null
MorphologySnomedGroup int 4 √ null
MorphologySnomed varchar 10 √ null
MorphologySnomedDesc varchar 255 √ null
MorphologySnomedICD03Group int 4 √ null
MorphologySnomedICD03GroupDesc varchar 50 √ null
MorphologySnomedICD03 varchar 6 √ null
MorphologySnomedICD03Desc varchar 200 √ null
GradeOfDifferentiation varchar 2 √ null
GradeOfDifferentiationDesc varchar 100 √ null
TumourLaterality varchar 1 √ null
TumourLateralityDesc varchar 50 √ null
DiagnosisOrgCode varchar 5 √ null
DiagnosisOrgCodeDesc nvarchar 500 √ null
BasisOfDiagnosis int 4 √ null
BasisOfDiagnosisDesc varchar 50 √ null
CnsSeenByIndicationCode varchar 2 √ null
CnsSeenByIndicationCodeDesc varchar 255 √ null
TnmVersion varchar 2 √ null
TnmEdition int 4 √ null
TnmEditionDesc varchar 10 √ null
TnmClinicalTStage varchar 5 √ null
TnmClinicalTLetter varchar 5 √ null
TnmClinicalNStage varchar 5 √ null
TnmClinicalNLetter varchar 5 √ null
TnmClinicalMStage varchar 5 √ null
TnmClinicalMLetter varchar 5 √ null
TnmIntegratedTStage varchar 5 √ null
TnmIntegratedTLetter varchar 5 √ null
TnmIntegratedNStage varchar 5 √ null
TnmIntegratedNLetter varchar 5 √ null
TnmIntegratedMStage varchar 5 √ null
TnmIntegratedMLetter varchar 5 √ null
TNMStageGrouping varchar 50 √ null
TnmClinicalDate smalldatetime 16 √ null
TnmIntegratedDate smalldatetime 16 √ null
TNMIntegratedStageGrouping varchar 50 √ null
DatePatientInformedOfDiagnosis smalldatetime 16 √ null
RelativeCarerInformedOfDiagnosis int 4 √ null
DateDecisionToRefer smalldatetime 16 √ null
DateReceived smalldatetime 16 √ null
DateFirstSeen smalldatetime 16 √ null
FirstSeenOrgCode varchar 5 √ null
FirstSeenOrgCodeDesc nvarchar 500 √ null
FirstSeenAdjustment int 4 √ null
FirstSeenAdjustmentReason int 4 √ null
FirstSeenAdjustmentReasonDesc varchar 150 √ null
FirstSeenDelayReason varchar 2 √ null
FirstSeenDelayReasonDesc varchar 500 √ null
FirstSeenDelayComments text 2147483647 √ null
DateDecisionToUpgrade smalldatetime 16 √ null
UpgradeOrgDesc nvarchar 500 √ null
UpgradeOrgCode varchar 5 √ null
ReferralToTreatAdjustment int 4 √ null
ReferralToTreatAdjustmentReason int 4 √ null
ReferralToTreatAdjustmentReasonDesc varchar 150 √ null
ReferralToTreatmentDelayReason int 4 √ null
ReferralToTreatmentDelayReasonDesc varchar 350 √ null
Referral to Treatment Delay Comments text 2147483647 √ null
ReferralType varchar 2 √ null
ReferralTypeDesc varchar 100 √ null
FirstAppointmentOffered int 4 √ null
ConsultantFirstApptCode varchar 8 √ null
ReferralAppropriateSpecialist int 4 √ null
SpecialistDateReferred smalldatetime 16 √ null
SpecialistDateSeen smalldatetime 16 √ null
OrganisationReferredFromCode varchar 5 √ null
OrganisationReferredFromDesc nvarchar 500 √ null
OrganisationFirstApptSpecialistCode varchar 5 √ null
OrganisationFirstApptSpecialistDesc nvarchar 500 √ null
ConsultantSpecialistReferralCode varchar 8 √ null
ConsultantSpecialistReferralDesc varchar 50 √ null
UpgradeWhen int 4 √ null
UpgradeWhenDesc varchar 50 √ null
UpgradeWho int 4 √ null
UpgradeWhoDesc varchar 50 √ null
DNAApptReBookedDate smalldatetime 16 √ null
AssessedBy int 4 √ null
AssessedByDesc varchar 50 √ null
TumourStatus int 4 null
TumourStatusDesc varchar 50 √ null
SymptomsFirstNotedDay varchar 2 √ null
SymptomsFirstNotedMonth varchar 2 √ null
SymptomsFirstNotedYear varchar 4 √ null
SNOMEDDiagID int 4 √ null
SNOMEDDiagCode bigint 8 √ null
SNOMEDDiagDesc nvarchar 500 √ null
TnmClinicalOrgCode varchar 5 √ null
TnmClinicalOrgDesc nvarchar 500 √ null
TnmIntegratedOrgCode varchar 5 √ null
TnmIntegratedOrgDesc nvarchar 500 √ null
FasterDiagnosisDelayReasonComments nvarchar 1073741823 √ null
FasterDiagnosisExclusionDate datetime 16,3 √ null
FasterDiagnosisSiteOverride nvarchar 100 √ null
FasterDiagnosisOrganisation nvarchar 500 √ null
FasterDiagnosisExclusionReason nvarchar 160 √ null
FasterDiagnosisDelayReason nvarchar 320 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID Implied ConstraintR
NonPrimaryPathwayOptionsDesc varchar 50 √ null
PrimaryDiagnosisRecurrenceCancerSiteID int 4 √ null
PrimaryDiagnosisRecurrenceCancerSite varchar 50 √ null
PrimaryReferralFlag bit 1 null
PlannedIntervalScanning bit 1 null
RapidDiagnosticCode nvarchar 4 √ null
RapidDiagnosticDesc varchar 3 √ null
ReferralRoute int 4 √ null
ReferralRouteDesc nvarchar 200 √ null
ReferralOtherRoute nvarchar 100 √ null
MetsString nvarchar 1073741823 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views