gzNEW_REFERRALS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

N1_1_NHS_NUMBER

varchar

√

null

L_CANCER_SITE

varchar

√

null

N2_4_PRIORITY_TYPE

varchar

√

null

N2_6_RECEIPT_DATE

smalldatetime

√

null

N2_7_CONSULTANT

varchar

√

null

N2_9_FIRST_SEEN_DATE

smalldatetime

√

null

MINI_DESC

varchar

√

null

TYPE_DESC

varchar

√

null

View Definition

CREATE VIEW dbo.gzNEW_REFERRALS
AS
SELECT     TOP (100) PERCENT dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, 
                      dbo.tblMAIN_REFERRALS.N2_4_PRIORITY_TYPE, dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE, dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT, 
                      dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblSOURCE_REFERRAL.MINI_DESC, dbo.ltblAPP_TYPE.TYPE_DESC
FROM         dbo.ltblAPP_TYPE RIGHT OUTER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.ltblAPP_TYPE.TYPE_CODE = dbo.tblMAIN_REFERRALS.L_FIRST_APP LEFT OUTER JOIN
                      dbo.tblDEMOGRAPHICS ON dbo.tblMAIN_REFERRALS.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID LEFT OUTER JOIN
                      dbo.ltblSOURCE_REFERRAL ON dbo.tblMAIN_REFERRALS.N2_1_REFERRAL_SOURCE = dbo.ltblSOURCE_REFERRAL.SOURCE_CODE
WHERE     (dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE IS NULL) AND (dbo.tblMAIN_REFERRALS.L_FIRST_APP IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_FIRST_APP <> 1) AND (dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE > { fn NOW() } - 30) AND 
                      (dbo.tblMAIN_REFERRALS.L_NEW_CA_SITE IS NULL)
ORDER BY dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE DESC, dbo.tblMAIN_REFERRALS.L_CANCER_SITE

Columns

View Definition

Possibly Referenced Tables/Views