vwCNS_PRINT

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

NURSE_ID

int

null

CARE_ID

int

null

L_CANCER_SITE

varchar

√

null

N4_1_DIAGNOSIS_DATE

smalldatetime

√

null

DIAG_DESC

varchar

150

√

null

CONSULTANT

varchar

√

null

FIRST_CONTACT

int

√

null

L_DEC_REF_DATE

smalldatetime

√

null

L_REF_DATE

smalldatetime

√

null

L_SEEN_DATE

smalldatetime

√

null

L_DISCH_DATE

smalldatetime

√

null

L_TOTAL_TIME

int

√

null

PLACE_DESC

varchar

√

null

L_CONTACT_TYPE

varchar

√

null

STATUS_DESC

varchar

√

null

CNS_NAME

varchar

√

null

L_KEY_WORKER

varchar

255

√

null

L_CONTACT_PAT

int

√

null

L_CONTACT_REL

int

√

null

L_CONTACT_CARER

int

√

null

L_CONTACT_PROF

int

√

null

REF1

varchar

√

null

REF2

varchar

√

null

L_NURSE

varchar

√

null

ACT1

varchar

100

√

null

ACT2

varchar

100

√

null

ACT3

varchar

100

√

null

ACT4

varchar

100

√

null

L_NOTES

text

2147483647

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

N1_10_DATE_BIRTH

datetime

16,3

√

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_1_NHS_NUMBER

varchar

√

null

View Definition

CREATE VIEW [vwCNS_PRINT]
AS
SELECT     dbo.tblSPECIALIST_NURSE.NURSE_ID, dbo.tblSPECIALIST_NURSE.CARE_ID, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, 
                      dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE, dbo.ltblDIAGNOSIS.DIAG_DESC, 
                      dbo.ltblCONSULTANTS.TITLE + dbo.ltblCONSULTANTS.CON_DESC AS CONSULTANT, dbo.tblSPECIALIST_NURSE.FIRST_CONTACT, 
                      dbo.tblSPECIALIST_NURSE.L_DEC_REF_DATE, dbo.tblSPECIALIST_NURSE.L_REF_DATE, dbo.tblSPECIALIST_NURSE.L_SEEN_DATE, 
                      dbo.tblSPECIALIST_NURSE.L_DISCH_DATE, dbo.tblSPECIALIST_NURSE.L_TOTAL_TIME, dbo.ltblCNS_LOCATION.PLACE_DESC, 
                      dbo.tblSPECIALIST_NURSE.L_CONTACT_TYPE, dbo.ltblCNS_PT_STATUS.STATUS_DESC, dbo.ltblCNS_NAME.CNS_NAME, 
                      dbo.tblSPECIALIST_NURSE.L_KEY_WORKER, dbo.tblSPECIALIST_NURSE.L_CONTACT_PAT, dbo.tblSPECIALIST_NURSE.L_CONTACT_REL, 
                      dbo.tblSPECIALIST_NURSE.L_CONTACT_CARER, dbo.tblSPECIALIST_NURSE.L_CONTACT_PROF, dbo.ltblCNS_PRIME_REF.REF_DESC AS REF1, 
                      dbo.ltblCNS_SECOND_REF.REF_DESC AS REF2, dbo.tblSPECIALIST_NURSE.L_NURSE, ltblCNS_ACTIVITIES_1.ACT_DESC AS ACT1, 
                      ltblCNS_ACTIVITIES_2.ACT_DESC AS ACT2, ltblCNS_ACTIVITIES_3.ACT_DESC AS ACT3, ltblCNS_ACTIVITIES_4.ACT_DESC AS ACT4, 
                      dbo.tblSPECIALIST_NURSE.L_NOTES, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblDEMOGRAPHICS.N1_6_FORENAME, 
                      dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, 
                      dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER
FROM         dbo.ltblCONSULTANTS RIGHT OUTER JOIN
                      dbo.ltblDIAGNOSIS RIGHT OUTER JOIN
                      dbo.tblDEMOGRAPHICS INNER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID ON 
                      dbo.ltblDIAGNOSIS.DIAG_CODE = dbo.tblMAIN_REFERRALS.N4_2_DIAGNOSIS_CODE ON 
                      dbo.ltblCONSULTANTS.NATIONAL_CODE = dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT RIGHT OUTER JOIN
                      dbo.ltblCNS_PRIME_REF RIGHT OUTER JOIN
                      dbo.ltblCNS_NAME RIGHT OUTER JOIN
                      dbo.ltblCNS_ACTIVITIES AS ltblCNS_ACTIVITIES_2 RIGHT OUTER JOIN
                      dbo.tblSPECIALIST_NURSE LEFT OUTER JOIN
                      dbo.ltblCNS_PT_STATUS ON dbo.tblSPECIALIST_NURSE.L_PT_STATUS = dbo.ltblCNS_PT_STATUS.STATUS_ID LEFT OUTER JOIN
                      dbo.ltblCNS_ACTIVITIES AS ltblCNS_ACTIVITIES_4 ON dbo.tblSPECIALIST_NURSE.L_ACTIVITY_4 = ltblCNS_ACTIVITIES_4.ACT_CODE LEFT OUTER JOIN
                      dbo.ltblCNS_ACTIVITIES AS ltblCNS_ACTIVITIES_3 ON dbo.tblSPECIALIST_NURSE.L_ACTIVITY_3 = ltblCNS_ACTIVITIES_3.ACT_CODE ON 
                      ltblCNS_ACTIVITIES_2.ACT_CODE = dbo.tblSPECIALIST_NURSE.L_ACTIVITY_2 LEFT OUTER JOIN
                      dbo.ltblCNS_ACTIVITIES AS ltblCNS_ACTIVITIES_1 ON dbo.tblSPECIALIST_NURSE.L_ACTIVITY_1 = ltblCNS_ACTIVITIES_1.ACT_CODE LEFT OUTER JOIN
                      dbo.ltblCNS_LOCATION ON dbo.tblSPECIALIST_NURSE.L_CONTACT_PLACE = dbo.ltblCNS_LOCATION.PLACE_ID ON 
                      dbo.ltblCNS_NAME.ID = dbo.tblSPECIALIST_NURSE.L_CNS LEFT OUTER JOIN
                      dbo.ltblCNS_SECOND_REF ON dbo.tblSPECIALIST_NURSE.L_REFERRAL_2 = dbo.ltblCNS_SECOND_REF.REF_ID ON 
                      dbo.ltblCNS_PRIME_REF.REF_ID = dbo.tblSPECIALIST_NURSE.L_REFERRAL_1 ON 
                      dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblSPECIALIST_NURSE.CARE_ID

Columns

View Definition

Possibly Referenced Tables/Views