vwSURGERY_NOT_PERFORMED

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

SURGERY_ID

int

null

View Definition

CREATE VIEW [dbo].[vwSURGERY_NOT_PERFORMED]
AS
select SURGERY_ID from tblSURGERY_BRAIN where tblSURGERY_BRAIN.L_NOT_OP = 1
UNION
select SURGERY_ID from tblSURGERY_BREAST where tblSURGERY_BREAST.L_CANCELLED = 1
UNION
select SURGERY_ID from tblSURGERY_COLORECTAL where tblSURGERY_COLORECTAL.R_NOT_OP = 'Yes'
UNION
select SURGERY_ID from tblSURGERY_DERMATOLOGY where tblSURGERY_DERMATOLOGY.L_NOT_OP = 1
UNION
select SURGERY_ID from tblSURGERY_GYNAECOLOGY where tblSURGERY_GYNAECOLOGY.L_NOT_OP = 1
UNION
select SURGERY_ID from tblSURGERY_HAEMATOLOGY where tblSURGERY_HAEMATOLOGY.L_NOT_OP = 1
UNION
select SURGERY_ID from tblSURGERY_HEAD_NECK where tblSURGERY_HEAD_NECK.L_CANCELLED = 1
UNION
select SURGERY_ID from tblSURGERY_LUNG where tblSURGERY_LUNG.L_CANCELLED = 1
UNION
select SURGERY_ID from tblSURGERY_PAEDIATRICS where tblSURGERY_PAEDIATRICS.L_NOT_OP = 1
UNION
select SURGERY_ID from tblSURGERY_UPPER_GI where tblSURGERY_UPPER_GI.R_DELAY = 1
UNION
select SURGERY_ID from tblSURGERY_UROLOGY where tblSURGERY_UROLOGY.L_NOT_OP = 1

Columns

View Definition

Possibly Referenced Tables/Views