SPECIALIST_NURSE

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

N1_1_NHS_NUMBER

varchar

√

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

L_CANCER_SITE

varchar

√

null

L_SPEC_NURSE_DATE

smalldatetime

√

null

L_SEEN_NURSE_DATE

smalldatetime

√

null

N4_1_DIAGNOSIS_DATE

smalldatetime

√

null

DIAG_DESC

varchar

√

null

L_ORG_CODE_DIAGNOSIS

varchar

√

null

PATIENT_ID

int

null

CARE_ID

int

null

View Definition

CREATE VIEW dbo.SPECIALIST_NURSE
AS
SELECT     dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.L_SPEC_NURSE_DATE, 
                      dbo.tblMAIN_REFERRALS.L_SEEN_NURSE_DATE, dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE, dbo.ltblDIAGNOSIS.DIAG_DESC, 
                      dbo.tblMAIN_REFERRALS.L_ORG_CODE_DIAGNOSIS, dbo.tblMAIN_REFERRALS.PATIENT_ID, dbo.tblMAIN_REFERRALS.CARE_ID
FROM         dbo.ltblDIAGNOSIS RIGHT OUTER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.ltblDIAGNOSIS.DIAG_CODE = dbo.tblMAIN_REFERRALS.L_DIAGNOSIS LEFT OUTER JOIN
                      dbo.tblDEMOGRAPHICS ON dbo.tblMAIN_REFERRALS.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID
WHERE     (dbo.tblMAIN_REFERRALS.L_SEEN_NURSE_DATE IS NOT NULL) AND (dbo.tblMAIN_REFERRALS.L_INAP_REF <> 1 OR
                      dbo.tblMAIN_REFERRALS.L_INAP_REF IS NULL)

Columns

View Definition

Possibly Referenced Tables/Views