vwMDT_PALLIATIVE_OUTCOME_DETAIL

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

HospitalNos

varchar

2147483647

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

N1_10_DATE_BIRTH

date

√

null

Code

varchar

√

null

N1_12_GP_PRACTICE_CODE

varchar

√

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

text

2147483647

√

null

L_COMMENTS

text

2147483647

√

null

ACTIONS_COMMENTS

text

2147483647

√

null

GPNAME

varchar

100

√

null

AddLine

varchar

250

null

GPPracCode

int

√

null

N1_3_ORG_CODE_SEEN

varchar

√

null

L_CONSULTANT

varchar

√

null

REFERRED_TO

int

√

null

WHO_REFERRED_TO

int

√

null

View Definition

CREATE VIEW [dbo].[vwMDT_PALLIATIVE_OUTCOME_DETAIL]
AS
--Update Date: 3/1/2020
--Update Author: David FC
--Update Details: Added in the following new fields:
--GP.[Name] as GPNAME, ISNULL(AddressLine1,'<blank address line>') as AddLine, Practice.ID As GPPracCode, N1_3_ORG_CODE_SEEN, L_CONSULTANT, REFERRED_TO,WHO_REFERRED_TO
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.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID) AS HospitalNos, 
                      dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, 
                      GP.Code,Practice.Code AS [N1_12_GP_PRACTICE_CODE], 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, dbo.tblPALLIATIVE_MDT.ACTIONS_COMMENTS,
					  GP.[Name] as GPNAME, ISNULL(AddressLine1,'<blank address line>') as AddLine, Practice.ID As GPPracCode, N1_3_ORG_CODE_SEEN, L_CONSULTANT,
					  NULL as REFERRED_TO, NULL as WHO_REFERRED_TO
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.tblMAIN_REFERRALS ON tblMAIN_REFERRALS.CARE_ID = 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 AND ltblCONSULTANTS.IS_DELETED = 0
LEFT JOIN GP on tblDEMOGRAPHICS.RegisteredGP = GP.ID
LEFT JOIN Practice on tblDEMOGRAPHICS.RegisteredPractice = Practice.ID

Columns

View Definition

Possibly Referenced Tables/Views