BIvwTreatmentBrachytherapy

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

Date Decision to Treat

varchar

√

null

Organisation (DTT)

nvarchar

500

√

null

Date Start of Treatment

varchar

√

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

Treatment Site

varchar

√

null

Anatomical Site

varchar

255

√

null

Brachytherapy Type

varchar

√

null

Isotope Type

varchar

√

null

Delivery Type

varchar

√

null

Anaesthetic Required

varchar

√

null

Unsealed Source Pt Type

varchar

√

null

Prescribed Dose (Gy)

real

√

null

Prescribed Duration

int

√

null

Prescribed Fractions

real

√

null

Actual Dose (Gy)

real

√

null

Actual Duration

int

√

null

No of Insertions

int

√

null

Dose per Insertion

real

√

null

Dose Rate

varchar

√

null

Treatment Outcome

nvarchar

100

√

null

End Date

varchar

√

null

Comments

text

2147483647

√

null

View Definition

CREATE VIEW [dbo].[BIvwTreatmentBrachytherapy]
		AS
		SELECT
			tblMAIN_BRACHYTHERAPY.CARE_ID AS 'CARE_ID',
			tblMAIN_REFERRALS.L_CANCER_SITE											AS 'Cancer Site',
			tblDEMOGRAPHICS.N1_1_NHS_NUMBER											AS 'NHS Number',
			tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER									AS 'Hospital Number',
			tblDEMOGRAPHICS.N1_6_FORENAME +' '+ tblDEMOGRAPHICS.N1_5_SURNAME		AS 'Full Name',
			ConsultantsByCode.CON_DESC +' - '+ ConsultantsByCode.CON_CODE			AS 'Consultant',
			convert(varchar, tblMAIN_BRACHYTHERAPY.N11_3_DECISION_DATE, 103)		AS 'Date Decision to Treat',
			OrganisationSites.Description													AS 'Organisation (DTT)',
			convert(varchar, tblMAIN_BRACHYTHERAPY.N11_9_START_DATE, 103)			AS 'Date Start of Treatment',
			N11_1_SITE_CODE															AS 'Organisation (Treatment) Site Code',
			OrganisationSites2.Description													AS 'Organisation (Treatment) Name',
			ltblTREATMENT_EVENT.EVENT_DESC											AS 'Treatment Event Type',
			ltblTREATMENT_SETTING.SET_DESC											AS 'Treatment Setting',
			CASE tblMAIN_BRACHYTHERAPY.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],
			tblMAIN_BRACHYTHERAPY.L_SHORT_LONG										AS 'Short/Long Course',
			ltblTREATMENT_SITE.TREAT_DESC											AS 'Treatment Site',
			ltblPROCEDURES.PROC_DESC												AS 'Anatomical Site',
			ltblBRACHY_TYPE.BRACH_TYPE_DESC											AS 'Brachytherapy Type',
			ltblRADIO_ISOTOPE.ISOTOPE_DESC											AS 'Isotope Type',
			ltblRADIO_DELIVERY.DEL_DESC												AS 'Delivery Type',
			tblMAIN_BRACHYTHERAPY.N11_18_ANAESTHETIC								AS 'Anaesthetic Required',
			ltblPATIENT_TYPE.PATIENT_DESC											AS 'Unsealed Source Pt Type',
			tblMAIN_BRACHYTHERAPY.N11_11_DOSE										AS 'Prescribed Dose (Gy)',
			tblMAIN_BRACHYTHERAPY.N11_12_DURATION									AS 'Prescribed Duration',
			tblMAIN_BRACHYTHERAPY.N11_13_FRACTIONS									AS 'Prescribed Fractions',
			tblMAIN_BRACHYTHERAPY.N11_14_ACTUAL_DOSE								AS 'Actual Dose (Gy)',
			tblMAIN_BRACHYTHERAPY.N11_16_ACTUAL_DURATION							AS 'Actual Duration',
			tblMAIN_BRACHYTHERAPY.R_INSERTIONS										AS 'No of Insertions',
			tblMAIN_BRACHYTHERAPY.R_DOSE_INSERTION									AS 'Dose per Insertion',
			ltblRADIO_DOSE.DOSE_DESC												AS 'Dose Rate',
			ltblTeletherapyNotCompleteReason.Description							AS 'Treatment Outcome',
			convert(varchar, tblMAIN_BRACHYTHERAPY.N11_10_END_DATE, 103)			AS 'End Date',
			tblMAIN_BRACHYTHERAPY.L_COMMENTS										AS 'Comments'	
		FROM
			tblMAIN_BRACHYTHERAPY
			LEFT JOIN tblMAIN_REFERRALS
				ON tblMAIN_BRACHYTHERAPY.CARE_ID = tblMAIN_REFERRALS.CARE_ID
			LEFT JOIN tblDEMOGRAPHICS
				ON tblMAIN_REFERRALS.PATIENT_ID = tblDEMOGRAPHICS.PATIENT_ID
			LEFT JOIN ConsultantsByCode
				ON tblMAIN_BRACHYTHERAPY.N11_2_CONSULTANT = ConsultantsByCode.NATIONAL_CODE
			LEFT JOIN OrganisationSites
				ON tblMAIN_BRACHYTHERAPY.N_SITE_CODE_DTT = OrganisationSites.Code
			LEFT JOIN OrganisationSites OrganisationSites2
				ON tblMAIN_BRACHYTHERAPY.N11_1_SITE_CODE = OrganisationSites2.Code
			LEFT JOIN ltblTREATMENT_EVENT
				ON tblMAIN_BRACHYTHERAPY.N_TREATMENT_EVENT = ltblTREATMENT_EVENT.EVENT_CODE
			LEFT JOIN ltblTREATMENT_SETTING
				ON tblMAIN_BRACHYTHERAPY.N_TREATMENT_SETTING = ltblTREATMENT_SETTING.SET_CODE			
			LEFT JOIN ltblTreatmentIntent ti ON N11_6_TREATMENT_INTENT = ti.IntentID
			LEFT JOIN ltblTREATMENT_SITE
				ON tblMAIN_BRACHYTHERAPY.R_TREAT_TO = ltblTREATMENT_SITE.TREAT_ID
			LEFT JOIN ltblPROCEDURES
				ON tblMAIN_BRACHYTHERAPY.N11_8_TREATMENT_SITE = ltblPROCEDURES.PROC_CODE
			LEFT JOIN ltblBRACHY_TYPE
				ON tblMAIN_BRACHYTHERAPY.N11_7_TYPE = ltblBRACHY_TYPE.BRACH_TYPE_CODE
			LEFT JOIN ltblRADIO_ISOTOPE
				ON tblMAIN_BRACHYTHERAPY.N11_17_ISOTOPE_TYPE = ltblRADIO_ISOTOPE.ISOTOPE_CODE
			LEFT JOIN ltblRADIO_DELIVERY
				ON tblMAIN_BRACHYTHERAPY.N11_20_DELIVERY_TYPE = ltblRADIO_DELIVERY.DEL_CODE
			LEFT JOIN ltblPATIENT_TYPE
				ON tblMAIN_BRACHYTHERAPY.N11_19_UNSEALED = ltblPATIENT_TYPE.PATIENT_CODE
			LEFT JOIN ltblRADIO_DOSE
				ON tblMAIN_BRACHYTHERAPY.N11_15_DOSE_RATE = ltblRADIO_DOSE.DOSE_CODE
			LEFT JOIN ltblTeletherapyNotCompleteReason
				ON tblMAIN_BRACHYTHERAPY.NotCompleteReasonID = ltblTeletherapyNotCompleteReason.ID
			LEFT JOIN ltblAdjunctiveTherapy ON tblMAIN_BRACHYTHERAPY.AdjunctiveTherapyID = ltblAdjunctiveTherapy.AdjunctiveTherapyID

Columns

View Definition

Possibly Referenced Tables/Views