vwCWT_VIEW_TEMP

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

NHSNumber

varchar

√

null

HospitalNumber

varchar

√

null

Forename

varchar

√

null

Surname

varchar

√

null

DateBirth

datetime

16,3

√

null

Gender

varchar

√

null

DateDeath

datetime

16,3

√

null

PatientPathwayID

varchar

√

null

PathwayIDOrgCode

varchar

√

null

ReferralDecisionDate

varchar

√

null

SourceReferral

varchar

√

null

SourceReferralDesc

varchar

100

√

null

PriorityTypeCode

varchar

√

null

PriorityTypeDesc

varchar

√

null

ReferralReceivedDate

varchar

√

null

ReferralType

varchar

√

null

ReferralTypeDesc

varchar

100

√

null

UpgradeDate

varchar

√

null

UpgradeOrgCode

varchar

√

null

FirstSeenDate

varchar

√

null

FirstSeenOrgCode

varchar

√

null

FirstSeenAdj

int

√

null

FirstSeenAdjReason

int

√

null

FirstSeenDelayComment

varchar

500

√

null

FirstSeenDelayReason

varchar

√

null

MDTDiscussionIndicator

varchar

√

null

MDTDiscussionDate

varchar

√

null

PatientStatus

varchar

√

null

PatientStatusDesc

varchar

√

null

PrimaryDiagnosis

varchar

√

null

TumourLaterality

varchar

√

null

TreatmentEventType

varchar

√

null

TreatmentEventTypeDesc

varchar

100

√

null

MetastaticSite

varchar

√

null

DecisionTreatOrgCode

varchar

√

null

DecisionTreatDate

varchar

√

null

TreatmentStartDate

varchar

√

null

TreatmentModality

varchar

√

null

TreatmentModalityDesc

varchar

100

√

null

CareSetting

varchar

√

null

CareSettingDesc

varchar

√

null

ClinicalTrial

varchar

√

null

TreatmentOrgCode

varchar

√

null

RadiotherapyPriority

varchar

√

null

RadiotherapyIntent

varchar

√

null

DecisionTreatmentDelayComment

varchar

500

√

null

DecisionTreatmentDelayReason

varchar

√

null

TreatmentAdj

int

√

null

TreatmentAdjReason

int

√

null

RefTreatmentDelayComment

varchar

500

√

null

RefTreatmentDelayReason

varchar

√

null

UpgradeTreatmentDelayComment

varchar

500

√

null

UpgradeTreatmentDelayReason

varchar

√

null

Validated

varchar

√

null

Username

varchar

√

null

View Definition

CREATE VIEW [dbo].[vwCWT_VIEW_TEMP]
AS

SELECT  dbo.expCWT_TEMP.NHSNumber, dbo.expCWT_TEMP.HospitalNumber, dbo.expCWT_TEMP.Forename, dbo.expCWT_TEMP.Surname, 
		dbo.expCWT_TEMP.DateBirth, dbo.expCWT_TEMP.Gender, dbo.expCWT_TEMP.DateDeath, dbo.expCWT_TEMP.PatientPathwayID, 
		dbo.expCWT_TEMP.PathwayIDOrgCode, dbo.expCWT_TEMP.ReferralDecisionDate, dbo.expCWT_TEMP.SourceReferral, 
		dbo.ltblOUT_PATIENT_REFERRAL.REF_DESC AS SourceReferralDesc, dbo.expCWT_TEMP.PriorityType AS PriorityTypeCode, 
		dbo.ltblPRIORITY_TYPE.PRIORITY_DESC AS PriorityTypeDesc, dbo.expCWT_TEMP.ReferralReceivedDate, dbo.expCWT_TEMP.ReferralType, 
		dbo.ltblCANCER_TYPE.CANCER_TYPE_DESC AS ReferralTypeDesc, dbo.expCWT_TEMP.UpgradeDate, dbo.expCWT_TEMP.UpgradeOrgCode, 
		dbo.expCWT_TEMP.FirstSeenDate, dbo.expCWT_TEMP.FirstSeenOrgCode, dbo.expCWT_TEMP.FirstSeenAdj, 
		dbo.expCWT_TEMP.FirstSeenAdjReason, dbo.expCWT_TEMP.FirstSeenDelayComment, dbo.expCWT_TEMP.FirstSeenDelayReason, 
		dbo.expCWT_TEMP.MDTDiscussionIndicator, dbo.expCWT_TEMP.MDTDiscussionDate, dbo.expCWT_TEMP.PatientStatus, 
		dbo.ltblSTATUS.SHORT_DESC AS PatientStatusDesc, dbo.expCWT_TEMP.PrimaryDiagnosis, dbo.expCWT_TEMP.TumourLaterality, 
		dbo.expCWT_TEMP.TreatmentEventType, dbo.ltblTREATMENT_EVENT.EVENT_DESC AS TreatmentEventTypeDesc, dbo.expCWT_TEMP.MetastaticSite, 
		dbo.expCWT_TEMP.DecisionTreatOrgCode, dbo.expCWT_TEMP.DecisionTreatDate, dbo.expCWT_TEMP.TreatmentStartDate, 
		dbo.expCWT_TEMP.TreatmentModality, 
		CASE 
			WHEN (dbo.expCWT_TEMP.TreatmentModality = '18') THEN 'Other'
			ELSE dbo.ltblDEFINITIVE_TYPE.TREAT_DESC
		END AS TreatmentModalityDesc,
		dbo.expCWT_TEMP.CareSetting, 
		dbo.ltblTREATMENT_SETTING.SET_DESC AS CareSettingDesc, dbo.expCWT_TEMP.ClinicalTrial, dbo.expCWT_TEMP.TreatmentOrgCode, 
		dbo.expCWT_TEMP.RadiotherapyPriority, dbo.expCWT_TEMP.RadiotherapyIntent, 
		CASE
		WHEN ISNULL(DATEDIFF(day, CONVERT(datetime, dbo.expCWT_TEMP.DecisionTreatDate, 120), CONVERT(datetime, dbo.expCWT_TEMP.TreatmentStartDate, 120)), 0) > 31 
		THEN dbo.expCWT_TEMP.DecisionTreatmentDelayComment
		ELSE NULL
		END DecisionTreatmentDelayComment, 
		CASE
		WHEN ISNULL(DATEDIFF(day, CONVERT(datetime, dbo.expCWT_TEMP.DecisionTreatDate, 120), CONVERT(datetime, dbo.expCWT_TEMP.TreatmentStartDate, 120)), 0) > 31 
		THEN dbo.expCWT_TEMP.DecisionTreatmentDelayReason
		ELSE NULL
		END DecisionTreatmentDelayReason,					                        
		--dbo.expCWT_TEMP.DecisionTreatmentDelayComment, 
		--dbo.expCWT_TEMP.DecisionTreatmentDelayReason, 
		dbo.expCWT_TEMP.TreatmentAdj, 
		dbo.expCWT_TEMP.TreatmentAdjReason, 
		dbo.expCWT_TEMP.RefTreatmentDelayComment, 
		dbo.expCWT_TEMP.RefTreatmentDelayReason, 
		dbo.expCWT_TEMP.UpgradeTreatmentDelayComment, 
		dbo.expCWT_TEMP.UpgradeTreatmentDelayReason,                       
		dbo.expCWT_TEMP.Validated, 
		dbo.expCWT_TEMP.Username
FROM	dbo.expCWT_TEMP LEFT OUTER JOIN
		dbo.ltblTREATMENT_SETTING ON dbo.expCWT_TEMP.CareSetting = dbo.ltblTREATMENT_SETTING.SET_CODE LEFT OUTER JOIN
		dbo.ltblDEFINITIVE_TYPE ON dbo.expCWT_TEMP.TreatmentModality = dbo.ltblDEFINITIVE_TYPE.TREAT_CODE LEFT OUTER JOIN
		dbo.ltblTREATMENT_EVENT ON dbo.expCWT_TEMP.TreatmentEventType = dbo.ltblTREATMENT_EVENT.EVENT_CODE LEFT OUTER JOIN
		dbo.ltblSTATUS ON dbo.expCWT_TEMP.PatientStatus = dbo.ltblSTATUS.STATUS_CODE LEFT OUTER JOIN
		dbo.ltblCANCER_TYPE ON dbo.expCWT_TEMP.ReferralType = dbo.ltblCANCER_TYPE.CANCER_TYPE_CODE LEFT OUTER JOIN
		dbo.ltblPRIORITY_TYPE ON dbo.expCWT_TEMP.PriorityType = dbo.ltblPRIORITY_TYPE.PRIORITY_CODE LEFT OUTER JOIN
		dbo.ltblOUT_PATIENT_REFERRAL ON dbo.expCWT_TEMP.SourceReferral = dbo.ltblOUT_PATIENT_REFERRAL.REF_CODE

Columns

View Definition

Possibly Referenced Tables/Views