gzBREACH_2WW

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

N1_1_NHS_NUMBER

varchar

null

L_CANCER_SITE

varchar

√

null

WAITING_TIME

int

√

null

N2_6_RECEIPT_DATE

smalldatetime

√

null

L_CANCELLED_DATE

smalldatetime

√

null

N2_9_FIRST_SEEN_DATE

smalldatetime

√

null

N1_3_ORG_CODE_SEEN

varchar

√

null

TYPE_DESC

varchar

√

null

View Definition

CREATE VIEW dbo.gzBREACH_2WW
AS
SELECT     TOP (100) PERCENT dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, DATEDIFF(d, 
                      dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE) 
                      - dbo.tblMAIN_REFERRALS.N2_14_ADJ_TIME AS WAITING_TIME, dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE, 
                      dbo.tblMAIN_REFERRALS.L_CANCELLED_DATE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, 
                      dbo.tblMAIN_REFERRALS.N1_3_ORG_CODE_SEEN, dbo.ltblAPP_TYPE.TYPE_DESC
FROM         dbo.tblMAIN_REFERRALS INNER JOIN
                      dbo.tblDEMOGRAPHICS ON dbo.tblMAIN_REFERRALS.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID LEFT OUTER JOIN
                      dbo.ltblAPP_TYPE ON dbo.tblMAIN_REFERRALS.L_FIRST_APP = dbo.ltblAPP_TYPE.TYPE_CODE
WHERE     (dbo.tblMAIN_REFERRALS.N2_4_PRIORITY_TYPE = '03') AND (dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE > { fn NOW() } - 30) AND 
                      (dbo.tblMAIN_REFERRALS.L_NEW_CA_SITE IS NULL) AND (DATEDIFF(d, dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE, 
                      dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE) - dbo.tblMAIN_REFERRALS.N2_14_ADJ_TIME > 14) AND 
                      (dbo.tblMAIN_REFERRALS.L_FIRST_APP IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_FIRST_APP <> 1) OR
                      (dbo.tblMAIN_REFERRALS.N2_4_PRIORITY_TYPE = '03') AND (dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE IS NULL) AND 
                      (dbo.tblMAIN_REFERRALS.L_NEW_CA_SITE IS NULL) AND (dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE BETWEEN { fn NOW() } - 14 AND { fn NOW()
                       } - 8) AND (dbo.tblMAIN_REFERRALS.L_FIRST_APP IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_FIRST_APP <> 1)
ORDER BY dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE DESC, dbo.tblMAIN_REFERRALS.L_CANCER_SITE

Columns

View Definition

Possibly Referenced Tables/Views