BIvwTreatmentTeletherapy

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

Cancer Site

varchar

√

null

NHS Number

varchar

√

null

Hospital Number

varchar

√

null

Full Name

varchar

111

√

null

Consultant

varchar

√

null

Priority

varchar

√

null

Date Decision to Treat

smalldatetime

√

null

Organisation (DTT)

nvarchar

500

√

null

Date Start of Treatment

smalldatetime

√

null

Organisation (Treatment) Site Code

varchar

√

null

Organisation (Treatment) Name

nvarchar

500

√

null

Treatment Event Type

varchar

100

√

null

Treatment Setting

varchar

√

null

Clinical Trial

varchar

√

null

Treatment Intent

varchar

√

null

Adjunctive Therapy

varchar

√

null

Short/Long Course

varchar

√

null

Chemo-Radiotherapy

varchar

√

null

Beam Quality

varchar

√

null

Treatment Site

varchar

√

null

Anatomical Site

varchar

255

√

null

Complexity Group

varchar

√

null

Anaesthetic Required

varchar

√

null

Fields

varchar

√

null

Multiple Planning

varchar

√

null

Prescribed Dose (Gy)

real

√

null

Dose per Fraction

real

√

null

Prescribed Fractions

real

√

null

Fraction per Week

int

√

null

Prescribed Duration

int

√

null

Actual Dose (Gy)

real

√

null

Actual Duration

int

√

null

Actual Fractions

real

√

null

Treatment Outcome

nvarchar

100

√

null

Radio Surgery Performed Indicator

varchar

√

null

End Date

smalldatetime

√

null

Comments

text

2147483647

√

null

View Definition

CREATE VIEW [dbo].[BIvwTreatmentTeletherapy]
		AS
		SELECT     dbo.tblMAIN_TELETHERAPY.CARE_ID, dbo.tblMAIN_REFERRALS.L_CANCER_SITE AS [Cancer Site], dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER AS [NHS Number], 
							  dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER AS [Hospital Number], 
							  dbo.tblDEMOGRAPHICS.N1_6_FORENAME + ' ' + dbo.tblDEMOGRAPHICS.N1_5_SURNAME AS [Full Name], 
							  dbo.ConsultantsByCode.CON_DESC + ' - ' + dbo.ConsultantsByCode.CON_CODE AS Consultant, dbo.ltblRADIO_PRIORITY.URGENCY_DESC AS Priority, 
							  dbo.tblMAIN_TELETHERAPY.N10_3_DECISION_DATE AS [Date Decision to Treat], dbo.OrganisationSites.Description AS [Organisation (DTT)], 
							  dbo.tblMAIN_TELETHERAPY.N10_8_START_DATE AS [Date Start of Treatment],
							  N10_1_SITE_CODE AS [Organisation (Treatment) Site Code],
							  OrganisationSites2.Description AS [Organisation (Treatment) Name], 
							  dbo.ltblTREATMENT_EVENT.EVENT_DESC AS [Treatment Event Type], dbo.ltblTREATMENT_SETTING.SET_DESC AS [Treatment Setting], 
							  CASE tblMAIN_TELETHERAPY.L_TRIAL WHEN '1' THEN 'Yes' WHEN '0' THEN 'No' WHEN '99' THEN 'Unknown' ELSE NULL END AS [Clinical Trial], 
							  ti.NonSurgicalIntentDesc AS [Treatment Intent],ltblAdjunctiveTherapy.AdjunctiveTherapyDesc as [Adjunctive Therapy], dbo.tblMAIN_TELETHERAPY.L_SHORT_LONG AS [Short/Long Course], 
							  CASE tblMAIN_TELETHERAPY.N_CHEMORADIO WHEN '1' THEN 'Yes' WHEN '0' THEN 'No' ELSE NULL END AS [Chemo-Radiotherapy], 
							  dbo.ltblRADIO_BEAM_TYPE.BEAM_DESC AS [Beam Quality], dbo.ltblTREATMENT_SITE.TREAT_DESC AS [Treatment Site], 
							  dbo.ltblPROCEDURES.PROC_DESC AS [Anatomical Site], dbo.ltblRADIO_COMPLEX_GROUP.GROUP_DESC AS [Complexity Group], 
							  dbo.tblMAIN_TELETHERAPY.N10_20_ANAESTHETIC AS [Anaesthetic Required], dbo.ltblRADIO_FIELDS.FIELD_DESC AS Fields, 
							  dbo.tblMAIN_TELETHERAPY.N10_21_MULTIPLE_PLANNING AS [Multiple Planning], dbo.tblMAIN_TELETHERAPY.N10_10_DOSE AS [Prescribed Dose (Gy)], 
							  dbo.tblMAIN_TELETHERAPY.L_DOSE_FRACTIONS AS [Dose per Fraction], dbo.tblMAIN_TELETHERAPY.N10_11_FRACTIONS AS [Prescribed Fractions], 
							  dbo.tblMAIN_TELETHERAPY.L_FRACTIONS_WEEK AS [Fraction per Week], dbo.tblMAIN_TELETHERAPY.N10_12_DURATION AS [Prescribed Duration], 
							  dbo.tblMAIN_TELETHERAPY.N10_13_ACTUAL_DOSE AS [Actual Dose (Gy)], dbo.tblMAIN_TELETHERAPY.N10_15_ACTUAL_DURATION AS [Actual Duration], 
							  dbo.tblMAIN_TELETHERAPY.N10_14_ACTUAL_FRACTIONS AS [Actual Fractions], dbo.ltblTeletherapyNotCompleteReason.Description AS [Treatment Outcome], 
							  CASE dbo.tblMAIN_TELETHERAPY.BRAIN_RADIOSURGERY_INDICATOR WHEN 'Y' THEN 'Yes' WHEN 'N' THEN 'No' WHEN '9' THEN 'Not Known' ELSE NULL 
							  END AS [Radio Surgery Performed Indicator], dbo.tblMAIN_TELETHERAPY.N10_9_END_DATE AS [End Date], 
							  dbo.tblMAIN_TELETHERAPY.L_COMMENTS AS Comments
		FROM         dbo.tblMAIN_TELETHERAPY LEFT OUTER JOIN
							  dbo.tblMAIN_REFERRALS ON dbo.tblMAIN_TELETHERAPY.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID LEFT OUTER JOIN
							  dbo.tblDEMOGRAPHICS ON dbo.tblMAIN_REFERRALS.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID LEFT OUTER JOIN
							  dbo.ConsultantsByCode ON dbo.tblMAIN_TELETHERAPY.N10_2_CONSULTANT = dbo.ConsultantsByCode.NATIONAL_CODE LEFT OUTER JOIN
							  dbo.ltblRADIO_PRIORITY ON dbo.tblMAIN_TELETHERAPY.N_PRIORITY = dbo.ltblRADIO_PRIORITY.URGENCY_CODE LEFT OUTER JOIN
							  dbo.OrganisationSites ON dbo.tblMAIN_TELETHERAPY.N_SITE_CODE_DTT = dbo.OrganisationSites.Code LEFT OUTER JOIN
							  dbo.OrganisationSites AS OrganisationSites2 ON dbo.tblMAIN_TELETHERAPY.N10_1_SITE_CODE = OrganisationSites2.Code LEFT OUTER JOIN
							  dbo.ltblTREATMENT_EVENT ON dbo.tblMAIN_TELETHERAPY.N_TREATMENT_EVENT = dbo.ltblTREATMENT_EVENT.EVENT_CODE LEFT OUTER JOIN
							  dbo.ltblTREATMENT_SETTING ON dbo.tblMAIN_TELETHERAPY.N_TREATMENT_SETTING = dbo.ltblTREATMENT_SETTING.SET_CODE LEFT OUTER JOIN
							  ltblTreatmentIntent ti ON N10_6_TREATMENT_INTENT = ti.IntentID LEFT OUTER JOIN
							  dbo.ltblRADIO_BEAM_TYPE ON dbo.tblMAIN_TELETHERAPY.N10_16_BEAM_TYPE = dbo.ltblRADIO_BEAM_TYPE.BEAM_CODE LEFT OUTER JOIN
							  dbo.ltblTREATMENT_SITE ON dbo.tblMAIN_TELETHERAPY.R_TREAT_TO = dbo.ltblTREATMENT_SITE.TREAT_ID LEFT OUTER JOIN
							  dbo.ltblPROCEDURES ON dbo.tblMAIN_TELETHERAPY.N10_7_TREATMENT_SITE = dbo.ltblPROCEDURES.PROC_CODE LEFT OUTER JOIN
							  dbo.ltblRADIO_COMPLEX_GROUP ON dbo.tblMAIN_TELETHERAPY.N10_19_COMPLEXITY = dbo.ltblRADIO_COMPLEX_GROUP.GROUP_CODE LEFT OUTER JOIN
							  dbo.ltblRADIO_FIELDS ON dbo.tblMAIN_TELETHERAPY.N10_18_FIELDS = dbo.ltblRADIO_FIELDS.FIELD_CODE
							  LEFT OUTER JOIN dbo.ltblTeletherapyNotCompleteReason ON dbo.tblMAIN_TELETHERAPY.NotCompleteReasonID = dbo.ltblTeletherapyNotCompleteReason.ID
							LEFT JOIN ltblAdjunctiveTherapy ON tblMAIN_TELETHERAPY.AdjunctiveTherapyID = ltblAdjunctiveTherapy.AdjunctiveTherapyID

Columns

View Definition

Possibly Referenced Tables/Views