BIvwEndometrialCancer

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

NHS Number

varchar

null

Hospital Number

varchar

√

null

Treatment Type

char

√

null

Treatment Start Date

smalldatetime

√

null

Surgery Date

smalldatetime

√

null

Primary Procedure Code

varchar

√

null

Primary Procedure Description

varchar

255

√

null

Incision

varchar

null

Sub Procedure Code

varchar

√

null

Sub Procedure Description

varchar

255

√

null

Sub Procedure Code 2

varchar

√

null

Sub Procedure Description 2

varchar

255

√

null

View Definition

CREATE VIEW [dbo].[BIvwEndometrialCancer]
		AS
		SELECT     dbo.tblMAIN_REFERRALS.CARE_ID,
				   dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER AS [NHS Number], 
				   dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER AS [Hospital Number],
				   dbo.tblDEFINITIVE_TREATMENT.TREATMENT AS [Treatment Type],
				   dbo.tblDEFINITIVE_TREATMENT.START_DATE AS [Treatment Start Date],
				   dbo.tblMAIN_SURGERY.N7_9_SURGERY_DATE AS [Surgery Date],
				   dbo.tblMAIN_SURGERY.N7_10_PROCEDURE_1 AS [Primary Procedure Code],
				   ltblPROCEDURES_1.PROC_DESC AS [Primary Procedure Description],
				   dbo.ltblGYNAE_INCISION.INC_DESC AS [Incision],
				   dbo.tblMAIN_SURGERY.N7_11_PROCEDURE_2 AS [Sub Procedure Code], 
				   dbo.ltblPROCEDURES.PROC_DESC AS [Sub Procedure Description],
				   dbo.tblMAIN_SURGERY.N7_11_PROCEDURE_3 AS [Sub Procedure Code 2],
				   ltblPROCEDURES_2.PROC_DESC AS [Sub Procedure Description 2]
		FROM         dbo.tblDEMOGRAPHICS INNER JOIN
							  dbo.ltblGYNAE_INCISION INNER JOIN
							  dbo.tblSURGERY_GYNAECOLOGY INNER JOIN
							  dbo.tblMAIN_SURGERY INNER JOIN
							  dbo.tblDEFINITIVE_TREATMENT INNER JOIN
							  dbo.tblMAIN_REFERRALS ON dbo.tblDEFINITIVE_TREATMENT.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID ON 
							  dbo.tblMAIN_SURGERY.CARE_ID = dbo.tblDEFINITIVE_TREATMENT.CARE_ID ON 
							  dbo.tblSURGERY_GYNAECOLOGY.SURGERY_ID = dbo.tblMAIN_SURGERY.SURGERY_ID ON 
							  dbo.ltblGYNAE_INCISION.INC_CODE = dbo.tblSURGERY_GYNAECOLOGY.R_INCISION ON 
							  dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID LEFT OUTER JOIN
							  dbo.ltblPROCEDURES AS ltblPROCEDURES_2 ON 
							  dbo.tblMAIN_SURGERY.N7_11_PROCEDURE_3 = ltblPROCEDURES_2.PROC_CODE LEFT OUTER JOIN
							  dbo.ltblPROCEDURES ON dbo.tblMAIN_SURGERY.N7_11_PROCEDURE_2 = dbo.ltblPROCEDURES.PROC_CODE LEFT OUTER JOIN
							  dbo.ltblPROCEDURES AS ltblPROCEDURES_1 ON dbo.tblMAIN_SURGERY.N7_10_PROCEDURE_1 = ltblPROCEDURES_1.PROC_CODE
		WHERE     (dbo.tblMAIN_REFERRALS.N4_2_DIAGNOSIS_CODE = 'C541')

Columns

View Definition

Possibly Referenced Tables/Views