vwMDT_LIST_PALLIATIVE

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

MDT_ID

int

null

MEETING_ID

int

√

null

CA_ID

int

√

null

MEETING_TYPE_ID

int

√

null

MDT_DATE

smalldatetime

√

null

OTHER_SITE

varchar

√

null

PT_ORDER

int

√

null

PATIENT_ID

int

√

null

CARE_ID

int

√

null

PRE_POST

varchar

√

null

DONE

int

√

null

PREP

int

√

null

N1_1_NHS_NUMBER

varchar

√

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_6_FORENAME

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_10_DATE_BIRTH

date

√

null

L_DATE_OF_FIRST_CONTACT

smalldatetime

√

null

CON_DESC

varchar

√

null

L_RA3_RID

varchar

√

null

L_RA7_RID

varchar

√

null

L_RVJ01_RID

varchar

√

null

View Definition

CREATE VIEW [dbo].[vwMDT_LIST_PALLIATIVE]
AS
SELECT     dbo.tblMDT_LIST.MDT_ID, dbo.tblMDT_LIST.MEETING_ID, dbo.vwMDT_MEETING_DATES.MEETING_ID AS CA_ID, 
                      dbo.vwMDT_MEETING_DATES.MEETING_TYPE_ID, dbo.tblMDT_LIST.MDT_DATE, dbo.tblMDT_LIST.OTHER_SITE, 
                      dbo.tblMDT_LIST.PT_ORDER, dbo.tblMDT_LIST.PATIENT_ID, dbo.tblMDT_LIST.CARE_ID, dbo.tblMDT_LIST.PRE_POST, dbo.tblMDT_LIST.DONE, 
                      dbo.tblMDT_LIST.PREP, dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, 
                      dbo.tblPALLIATIVE_CARE.L_DATE_OF_FIRST_CONTACT, dbo.ltblCONSULTANTS.CON_DESC, dbo.tblDEMOGRAPHICS.L_RA3_RID, 
                      dbo.tblDEMOGRAPHICS.L_RA7_RID, dbo.tblDEMOGRAPHICS.L_RVJ01_RID
FROM         dbo.vwMDT_MEETING_DATES RIGHT OUTER JOIN
                      dbo.tblMDT_LIST LEFT OUTER JOIN
                      dbo.tblDEMOGRAPHICS INNER JOIN
                      dbo.tblPALLIATIVE_CARE ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblPALLIATIVE_CARE.PATIENT_ID ON 
                      dbo.tblMDT_LIST.CARE_ID = dbo.tblPALLIATIVE_CARE.PALLIATIVE_ID ON 
                      dbo.vwMDT_MEETING_DATES.MDT_ID = dbo.tblMDT_LIST.MEETING_ID LEFT OUTER JOIN
                      dbo.ltblCONSULTANTS ON dbo.tblPALLIATIVE_CARE.L_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE
WHERE     (dbo.tblMDT_LIST.CARE_ID IS NOT NULL) AND (dbo.tblMDT_LIST.DONE <> 2) AND (dbo.tblMDT_LIST.OTHER_SITE = 'Palliative Care') AND (dbo.ltblCONSULTANTS.IS_DELETED = 0 OR ltblCONSULTANTS.NATIONAL_CODE IS NULL)

Columns

View Definition

Possibly Referenced Tables/Views