UROLOGY_SURGERY

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

N7_9_SURGERY_DATE

smalldatetime

√

null

N7_2_CONSULTANT

varchar

√

null

CARE_ID

int

√

null

SURGERY_ID

int

null

N7_12_DISCHARGE_DATE

smalldatetime

√

null

PROC_DESC

varchar

255

√

null

N1_1_NHS_NUMBER

varchar

√

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

L_SURGEON

varchar

√

null

L_ASSISTANT_1

varchar

√

null

PATIENT_ID

int

√

null

View Definition

CREATE VIEW dbo.UROLOGY_SURGERY
AS
SELECT     TOP (100) PERCENT dbo.tblMAIN_SURGERY.N7_9_SURGERY_DATE, dbo.tblMAIN_SURGERY.N7_2_CONSULTANT, 
                      dbo.tblMAIN_REFERRALS.CARE_ID, dbo.tblMAIN_SURGERY.SURGERY_ID, dbo.tblMAIN_SURGERY.N7_12_DISCHARGE_DATE, 
                      dbo.ltblUROLOGY_PROCEDURES.PROC_DESC, dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, 
                      dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblMAIN_SURGERY.L_SURGEON, 
                      dbo.tblMAIN_SURGERY.L_ASSISTANT_1, dbo.tblDEMOGRAPHICS.PATIENT_ID
FROM         dbo.tblSURGERY_UROLOGY INNER JOIN
                      dbo.tblMAIN_SURGERY ON dbo.tblSURGERY_UROLOGY.SURGERY_ID = dbo.tblMAIN_SURGERY.SURGERY_ID LEFT OUTER JOIN
                      dbo.ltblUROLOGY_PROCEDURES ON dbo.tblMAIN_SURGERY.L_PROCEDURE = dbo.ltblUROLOGY_PROCEDURES.PROC_ID LEFT OUTER JOIN
                      dbo.tblDEMOGRAPHICS INNER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID ON 
                      dbo.tblMAIN_SURGERY.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
WHERE     (dbo.tblMAIN_SURGERY.N7_9_SURGERY_DATE IS NOT NULL) AND (dbo.tblMAIN_REFERRALS.L_CANCER_SITE = 'Urology')

Columns

View Definition

Possibly Referenced Tables/Views