vwMDT_PALLIATIVE_OUTCOMES

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PATIENT_ID

int

√

null

L_RA3_RID

varchar

√

null

L_RA7_RID

varchar

√

null

L_RVJ01_RID

varchar

√

null

N1_1_NHS_NUMBER

varchar

√

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

N1_10_DATE_BIRTH

datetime

16,3

√

null

L_DATE_OF_FIRST_CONTACT

smalldatetime

√

null

PALLIATIVE_ID

int

null

CON_DESC

varchar

√

null

MDT_ID

int

√

null

MEETING_ID

int

√

null

L_MDT_DATE

datetime

16,3

√

null

L_ACTIONS

varchar

255

√

null

L_COMMENTS

text

2147483647

√

null

View Definition

CREATE VIEW dbo.vwMDT_PALLIATIVE_OUTCOMES
AS
SELECT     dbo.tblDEMOGRAPHICS.PATIENT_ID, dbo.tblDEMOGRAPHICS.L_RA3_RID, dbo.tblDEMOGRAPHICS.L_RA7_RID, dbo.tblDEMOGRAPHICS.L_RVJ01_RID, 
                      dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblPALLIATIVE_CARE.L_DATE_OF_FIRST_CONTACT, 
                      dbo.tblPALLIATIVE_CARE.PALLIATIVE_ID, dbo.ltblCONSULTANTS.CON_DESC, dbo.tblPALLIATIVE_MDT.MDT_ID, dbo.tblPALLIATIVE_MDT.MEETING_ID, 
                      dbo.tblPALLIATIVE_MDT.L_MDT_DATE, dbo.tblPALLIATIVE_MDT.L_ACTIONS, dbo.tblPALLIATIVE_MDT.L_COMMENTS
FROM         dbo.tblPALLIATIVE_MDT RIGHT OUTER JOIN
                      dbo.tblPALLIATIVE_CARE ON dbo.tblPALLIATIVE_MDT.PALLIATIVE_ID = dbo.tblPALLIATIVE_CARE.PALLIATIVE_ID LEFT OUTER JOIN
                      dbo.tblDEMOGRAPHICS ON dbo.tblPALLIATIVE_CARE.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID LEFT OUTER JOIN
                      dbo.ltblCONSULTANTS ON dbo.tblPALLIATIVE_CARE.L_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE

Columns

View Definition

Possibly Referenced Tables/Views