vwTertiaryReferralsCore


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
CancerSite varchar 50 √ null
NHSNumber varchar 10 √ null
NHSNumberStatus varchar 3 √ null
NHSNumberStatusDesc varchar 70 √ null
Title int 4 √ null
TitleDesc varchar 50 √ null
GivenName varchar 50 √ null
FamilyName varchar 60 √ null
Dob date 20 √ 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
GpName varchar 100 √ null
GpCode varchar 8 √ null
GpPracticeCode varchar 20 √ null
GpPracticeName varchar 250 √ null
GpPracticeAddress1 varchar 250 √ null
GpPracticeAddress2 varchar 250 √ null
GpPracticeAddress3 varchar 250 √ null
GpPostCode varchar 20 √ null
Ccg varchar 100 √ null
CcgCode varchar 3 √ null
DateOfDeath date 20 √ 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
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
MorphologySnomed varchar 10 √ null
MorphologySnomedDesc varchar 255 √ 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
MetastaticSites varchar 3 null
PreTreatmentTNM varchar 3 null
TnmVersion varchar 2 √ null
TNMStageGrouping varchar 50 √ null
DatePatientInformedOfDiagnosis smalldatetime 16 √ null
RelativeCarerInformedOfDiagnosis int 4 √ null
TreatmentModality varchar 3 null
StandardType varchar 3 null
PpiTargetDateFor62DayStandardType varchar 3 null
DateDecisionToRefer smalldatetime 16 √ null
DateReceived smalldatetime 16 √ null
DateFirstSeen smalldatetime 16 √ null
FirstSeenOrgCode varchar 5 √ 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
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
TargetDateFor31DayStandard varchar 3 null
RadiotherapyIntent varchar 3 null
RadiotherapyPriority varchar 3 null
TreatmentSetting varchar 3 null
DateDecisionToTreat varchar 3 null
DateDecisionToTreatOrganisation varchar 3 null
DateDecisionToTreatOrganisationCode varchar 3 null
ClinicalTrial varchar 3 null
TreatmentOrganisation varchar 3 null
TreatmentOrganisation Code varchar 3 null
TreatmentStart Date varchar 3 null
DecisionToTreatAdjustment varchar 3 null
DecisionToTreatAdjustmentReason varchar 3 null
TreatmentDelayReason varchar 3 null
TreatmentDelayReasonComments varchar 3 null
MDTDiscussionIndicator varchar 3 null
DateOfLastMDT varchar 3 null
LastMDTComments varchar 3 null

View Definition

Possibly Referenced Tables/Views