vwMDT_Outcome_Detail

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

MDTDetailID

int

√

null

MEETING_ID

int

√

null

PT_ORDER

int

√

null

MDT_ID

varchar

255

null

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_2_HOSPITAL_NUMBER

varchar

√

null

N1_12_GP_PRACTICE_CODE

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

N1_10_DATE_BIRTH

date

√

null

CARE_ID

int

√

null

L_CANCER_SITE

varchar

√

null

N2_9_FIRST_SEEN_DATE

smalldatetime

√

null

CON_DESC

varchar

√

null

STATUS_DESC

varchar

√

null

DIAGNOSIS_DATE

varchar

√

null

DIAGNOSIS

varchar

√

null

DIAG_DESC

varchar

150

√

null

PRE_POST

varchar

√

null

MDT_DATE

smalldatetime

√

null

HISTOLOGY

varchar

255

√

null

M_DESC

varchar

255

√

null

GRADE

varchar

255

√

null

GRADE_DESC

varchar

100

√

null

CARE_INTENT

char

√

null

NO_TREATMENT

varchar

√

null

REASON_DESC

varchar

√

null

TREATMENT_1

varchar

√

null

TREATMENT_2

varchar

√

null

TREATMENT_3

varchar

√

null

TREATMENT_4

varchar

√

null

ACTION_BY

varchar

255

√

null

WHO_REFERRED_TO

varchar

√

null

REFERRED_TO

varchar

√

null

REF_TITLE

varchar

√

null

REF_CON_DESC

varchar

√

null

Code

varchar

√

null

Description

nvarchar

500

√

null

COMMENTS

text

2147483647

√

null

View Definition

CREATE View [dbo].[vwMDT_Outcome_Detail] 
as
SELECT TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblBRAIN_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblBRAIN_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblBRAIN_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblBRAIN_MDT.PRE_POST, dbo.tblBRAIN_MDT.MDT_DATE, tblBRAIN_MDT.HISTOLOGY, SNOMED.M_DESC, NULL as GRADE, NULL as GRADE_DESC,
						dbo.tblBRAIN_MDT.CARE_INTENT, dbo.tblBRAIN_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblBRAIN_MDT.ACTION_BY, dbo.tblBRAIN_MDT.WHO_REFERRED_TO, dbo.tblBRAIN_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblBRAIN_MDT.COMMENTS 
	FROM tblBRAIN_MDT left join tblMAIN_REFERRALS on tblBRAIN_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblBRAIN_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblBRAIN_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblBRAIN_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblBRAIN_MDT.HISTOLOGY
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblBRAIN_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblBRAIN_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblBRAIN_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblBRAIN_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblBRAIN_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblBRAIN_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblBRAIN_MDT.OTHER_TRUST
	
	/* WHERE tblBRAIN_MDT.MEETING_ID is not null */
UNION ALL
	SELECT TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblBREAST_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblBREAST_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblBREAST_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblBREAST_MDT.PRE_POST, dbo.tblBREAST_MDT.MDT_DATE, tblBREAST_MDT.HISTOLOGY, SNOMED.M_DESC, tblBREAST_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblBREAST_MDT.CARE_INTENT, dbo.tblBREAST_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblBREAST_MDT.ACTION_BY, dbo.tblBREAST_MDT.WHO_REFERRED_TO, dbo.tblBREAST_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblBREAST_MDT.COMMENTS 
	FROM         tblBREAST_MDT left join tblMAIN_REFERRALS on tblBREAST_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblBREAST_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblBREAST_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblBREAST_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblBREAST_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblBREAST_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblBREAST_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblBREAST_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblBREAST_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblBREAST_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblBREAST_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblBREAST_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblBREAST_MDT.OTHER_TRUST
	/* WHERE tblBREAST_MDT.MEETING_ID is not null */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblCOLORECTAL_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblCOLORECTAL_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblCOLORECTAL_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblCOLORECTAL_MDT.PRE_POST, dbo.tblCOLORECTAL_MDT.MDT_DATE, tblCOLORECTAL_MDT.HISTOLOGY, SNOMED.M_DESC, tblCOLORECTAL_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblCOLORECTAL_MDT.CARE_INTENT, dbo.tblCOLORECTAL_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblCOLORECTAL_MDT.ACTION_BY, dbo.tblCOLORECTAL_MDT.WHO_REFERRED_TO, dbo.tblCOLORECTAL_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblCOLORECTAL_MDT.COMMENTS 
	FROM         tblCOLORECTAL_MDT left join tblMAIN_REFERRALS on tblCOLORECTAL_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblCOLORECTAL_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblCOLORECTAL_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblCOLORECTAL_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblCOLORECTAL_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblCOLORECTAL_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblCOLORECTAL_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblCOLORECTAL_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblCOLORECTAL_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblCOLORECTAL_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblCOLORECTAL_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblCOLORECTAL_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblCOLORECTAL_MDT.OTHER_TRUST
	/* WHERE tblCOLORECTAL_MDT.MEETING_ID is not null */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblGYNAECOLOGY_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblGYNAECOLOGY_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblGYNAECOLOGY_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblGYNAECOLOGY_MDT.PRE_POST, dbo.tblGYNAECOLOGY_MDT.MDT_DATE, tblGYNAECOLOGY_MDT.HISTOLOGY, SNOMED.M_DESC, tblGYNAECOLOGY_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblGYNAECOLOGY_MDT.CARE_INTENT, dbo.tblGYNAECOLOGY_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblGYNAECOLOGY_MDT.ACTION_BY, dbo.tblGYNAECOLOGY_MDT.WHO_REFERRED_TO, dbo.tblGYNAECOLOGY_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblGYNAECOLOGY_MDT.COMMENTS 
	FROM         tblGYNAECOLOGY_MDT left join tblMAIN_REFERRALS on tblGYNAECOLOGY_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblGYNAECOLOGY_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblGYNAECOLOGY_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblGYNAECOLOGY_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblGYNAECOLOGY_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblGYNAECOLOGY_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblGYNAECOLOGY_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblGYNAECOLOGY_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblGYNAECOLOGY_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblGYNAECOLOGY_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblGYNAECOLOGY_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblGYNAECOLOGY_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblGYNAECOLOGY_MDT.OTHER_TRUST
	/* WHERE tblGYNAECOLOGY_MDT.MEETING_ID is not NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblHAEMATOLOGY_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblHAEMATOLOGY_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblHAEMATOLOGY_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblHAEMATOLOGY_MDT.PRE_POST, dbo.tblHAEMATOLOGY_MDT.MDT_DATE, tblHAEMATOLOGY_MDT.HISTOLOGY, SNOMED.M_DESC, NULL as GRADE, NULL as GRADE_DESC,
						dbo.tblHAEMATOLOGY_MDT.CARE_INTENT, dbo.tblHAEMATOLOGY_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblHAEMATOLOGY_MDT.ACTION_BY, dbo.tblHAEMATOLOGY_MDT.WHO_REFERRED_TO, dbo.tblHAEMATOLOGY_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblHAEMATOLOGY_MDT.COMMENTS 
	FROM         tblHAEMATOLOGY_MDT left join tblMAIN_REFERRALS on tblHAEMATOLOGY_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblHAEMATOLOGY_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblHAEMATOLOGY_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblHAEMATOLOGY_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblHAEMATOLOGY_MDT.HISTOLOGY
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblHAEMATOLOGY_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblHAEMATOLOGY_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblHAEMATOLOGY_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblHAEMATOLOGY_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblHAEMATOLOGY_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblHAEMATOLOGY_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblHAEMATOLOGY_MDT.OTHER_TRUST
	/* WHERE tblHAEMATOLOGY_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblHEAD_NECK_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblHEAD_NECK_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblHEAD_NECK_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblHEAD_NECK_MDT.PRE_POST, dbo.tblHEAD_NECK_MDT.MDT_DATE, tblHEAD_NECK_MDT.HISTOLOGY, SNOMED.M_DESC, tblHEAD_NECK_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblHEAD_NECK_MDT.CARE_INTENT, dbo.tblHEAD_NECK_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblHEAD_NECK_MDT.ACTION_BY, dbo.tblHEAD_NECK_MDT.WHO_REFERRED_TO, dbo.tblHEAD_NECK_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblHEAD_NECK_MDT.COMMENTS 
	FROM         tblHEAD_NECK_MDT left join tblMAIN_REFERRALS on tblHEAD_NECK_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblHEAD_NECK_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblHEAD_NECK_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblHEAD_NECK_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblHEAD_NECK_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblHEAD_NECK_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblHEAD_NECK_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblHEAD_NECK_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblHEAD_NECK_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblHEAD_NECK_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblHEAD_NECK_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblHEAD_NECK_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblHEAD_NECK_MDT.OTHER_TRUST
	/* WHERE tblHEAD_NECK_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblLUNG_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblLUNG_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblLUNG_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblLUNG_MDT.PRE_POST, dbo.tblLUNG_MDT.MDT_DATE, tblLUNG_MDT.HISTOLOGY, SNOMED.M_DESC, tblLUNG_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblLUNG_MDT.CARE_INTENT, dbo.tblLUNG_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblLUNG_MDT.ACTION_BY, dbo.tblLUNG_MDT.WHO_REFERRED_TO, dbo.tblLUNG_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblLUNG_MDT.COMMENTS 
	FROM         tblLUNG_MDT left join tblMAIN_REFERRALS on tblLUNG_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblLUNG_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblLUNG_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblLUNG_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblLUNG_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblLUNG_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblLUNG_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblLUNG_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblLUNG_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblLUNG_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblLUNG_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblLUNG_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblLUNG_MDT.OTHER_TRUST
	/* WHERE tblLUNG_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER, tblOTHER_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblOTHER_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblOTHER_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblOTHER_MDT.PRE_POST, dbo.tblOTHER_MDT.MDT_DATE, tblOTHER_MDT.HISTOLOGY, SNOMED.M_DESC, tblOTHER_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblOTHER_MDT.CARE_INTENT, dbo.tblOTHER_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblOTHER_MDT.ACTION_BY, dbo.tblOTHER_MDT.WHO_REFERRED_TO, dbo.tblOTHER_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblOTHER_MDT.COMMENTS 
	FROM         tblOTHER_MDT left join tblMAIN_REFERRALS on tblOTHER_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblOTHER_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblOTHER_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblOTHER_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblOTHER_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblOTHER_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblOTHER_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblOTHER_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblOTHER_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblOTHER_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblOTHER_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblOTHER_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblOTHER_MDT.OTHER_TRUST
	/* WHERE tblOTHER_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER,tblPAEDIATRIC_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblPAEDIATRIC_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblPAEDIATRIC_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblPAEDIATRIC_MDT.PRE_POST, dbo.tblPAEDIATRIC_MDT.MDT_DATE, tblPAEDIATRIC_MDT.HISTOLOGY, SNOMED.M_DESC, NULL as GRADE, NULL as GRADE_DESC,
						dbo.tblPAEDIATRIC_MDT.CARE_INTENT, dbo.tblPAEDIATRIC_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblPAEDIATRIC_MDT.ACTION_BY, dbo.tblPAEDIATRIC_MDT.WHO_REFERRED_TO, dbo.tblPAEDIATRIC_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblPAEDIATRIC_MDT.COMMENTS 
	FROM         tblPAEDIATRIC_MDT left join tblMAIN_REFERRALS on tblPAEDIATRIC_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblPAEDIATRIC_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblPAEDIATRIC_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblPAEDIATRIC_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblPAEDIATRIC_MDT.HISTOLOGY
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblPAEDIATRIC_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblPAEDIATRIC_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblPAEDIATRIC_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblPAEDIATRIC_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblPAEDIATRIC_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblPAEDIATRIC_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblPAEDIATRIC_MDT.OTHER_TRUST
	/* WHERE tblPAEDIATRIC_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER,tblSARCOMA_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblSARCOMA_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblSARCOMA_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblSARCOMA_MDT.PRE_POST, dbo.tblSARCOMA_MDT.MDT_DATE, tblSARCOMA_MDT.HISTOLOGY, SNOMED.M_DESC, tblSARCOMA_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblSARCOMA_MDT.CARE_INTENT, dbo.tblSARCOMA_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblSARCOMA_MDT.ACTION_BY, dbo.tblSARCOMA_MDT.WHO_REFERRED_TO, dbo.tblSARCOMA_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblSARCOMA_MDT.COMMENTS 
	FROM         tblSARCOMA_MDT left join tblMAIN_REFERRALS on tblSARCOMA_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblSARCOMA_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblSARCOMA_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblSARCOMA_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblSARCOMA_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblSARCOMA_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblSARCOMA_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblSARCOMA_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblSARCOMA_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblSARCOMA_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblSARCOMA_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblSARCOMA_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblSARCOMA_MDT.OTHER_TRUST
	/* WHERE tblSARCOMA_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER,tblSKIN_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblSKIN_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblSKIN_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblSKIN_MDT.PRE_POST, dbo.tblSKIN_MDT.MDT_DATE, tblSKIN_MDT.HISTOLOGY, SNOMED.M_DESC, tblSKIN_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblSKIN_MDT.CARE_INTENT, dbo.tblSKIN_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblSKIN_MDT.ACTION_BY, dbo.tblSKIN_MDT.WHO_REFERRED_TO, dbo.tblSKIN_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblSKIN_MDT.COMMENTS 
	FROM         tblSKIN_MDT left join tblMAIN_REFERRALS on tblSKIN_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblSKIN_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblSKIN_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblSKIN_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblSKIN_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblSKIN_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblSKIN_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblSKIN_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblSKIN_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblSKIN_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblSKIN_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblSKIN_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblSKIN_MDT.OTHER_TRUST
	/* WHERE tblSKIN_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER,tblUGI_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblUGI_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblUGI_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblUGI_MDT.PRE_POST, dbo.tblUGI_MDT.MDT_DATE, tblUGI_MDT.HISTOLOGY, SNOMED.M_DESC, tblUGI_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblUGI_MDT.CARE_INTENT, dbo.tblUGI_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblUGI_MDT.ACTION_BY, dbo.tblUGI_MDT.WHO_REFERRED_TO, dbo.tblUGI_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblUGI_MDT.COMMENTS 
	FROM         tblUGI_MDT left join tblMAIN_REFERRALS on tblUGI_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblUGI_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblUGI_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblUGI_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblUGI_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblUGI_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblUGI_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblUGI_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblUGI_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblUGI_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblUGI_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblUGI_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblUGI_MDT.OTHER_TRUST
	/* WHERE tblUGI_MDT.MEETING_ID IS NOT NULL */
UNION ALL
	SELECT     TOP 100 MDTDetailID = cast((cast(tblMDT_LIST.MEETING_ID as varchar(6)) + right('00000' + cast(dbo.tblMAIN_REFERRALS.CARE_ID as varchar(5)), 5)) as INTEGER),  tblMDT_LIST.MEETING_ID, tblMDT_LIST.PT_ORDER,tblUROLOGY_MDT.MDT_ID, 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, HospitalNos = dbo.getHospitalNumbersByPatientID(dbo.tblDEMOGRAPHICS.PATIENT_ID), dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, 
                      dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.tblDEMOGRAPHICS.N1_10_DATE_BIRTH, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblTRIAL_STATUS.STATUS_DESC, convert(varchar(10),dbo.tblUROLOGY_MDT.DIAGNOSIS_DATE, 103) as DIAGNOSIS_DATE, dbo.tblUROLOGY_MDT.DIAGNOSIS, dbo.ltblDIAGNOSIS.DIAG_DESC, 
						dbo.tblUROLOGY_MDT.PRE_POST, dbo.tblUROLOGY_MDT.MDT_DATE, tblUROLOGY_MDT.HISTOLOGY, SNOMED.M_DESC, tblUROLOGY_MDT.GRADE, dbo.ltblDIFFERENTIATION.GRADE_DESC,
						dbo.tblUROLOGY_MDT.CARE_INTENT, dbo.tblUROLOGY_MDT.NO_TREATMENT, dbo.ltblNO_TREATMENT.REASON_DESC,
						TREATMENT_1.TREATMENT_DESC as TREATMENT_1,TREATMENT_2.TREATMENT_DESC as TREATMENT_2,
						TREATMENT_3.TREATMENT_DESC as TREATMENT_3,	TREATMENT_4.TREATMENT_DESC as TREATMENT_4,
						dbo.tblUROLOGY_MDT.ACTION_BY, dbo.tblUROLOGY_MDT.WHO_REFERRED_TO, dbo.tblUROLOGY_MDT.REFERRED_TO, CONREF.TITLE as REF_TITLE, 
						CONREF.CON_DESC as REF_CON_DESC, dbo.OrganisationSites.Code, dbo.OrganisationSites.[Description], tblUROLOGY_MDT.COMMENTS 
	FROM         tblUROLOGY_MDT left join tblMAIN_REFERRALS on tblUROLOGY_MDT.CARE_ID = tblMAIN_REFERRALS.CARE_ID
					left join dbo.tblMAIN_TRIAL ON dbo.tblMAIN_TRIAL.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID
                      LEFT join dbo.ltblTRIAL_STATUS  ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED 
						left join dbo.tblDEMOGRAPHICS on tblDEMOGRAPHICS.PATIENT_ID = tblMAIN_REFERRALS.PATIENT_ID
						LEFT JOIN dbo.tblMDT_LIST on tblUROLOGY_MDT.MEETING_ID = tblMDT_LIST.MEETING_ID AND tblUROLOGY_MDT.CARE_ID = tblMDT_LIST.CARE_ID
						LEFT JOIN dbo.ltblCONSULTANTS ON dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0
						left join dbo.ltblDIAGNOSIS on dbo.ltblDIAGNOSIS.DIAG_CODE = tblUROLOGY_MDT.DIAGNOSIS
						left join dbo.SNOMED on dbo.SNOMED.M_CODE = tblUROLOGY_MDT.HISTOLOGY
						left join dbo.ltblDIFFERENTIATION on dbo.ltblDIFFERENTIATION.GRADE_CODE = tblUROLOGY_MDT.GRADE
						LEFT JOIN dbo.ltblNO_TREATMENT on dbo.ltblNO_TREATMENT.REASON_CODE = tblUROLOGY_MDT.NO_TREATMENT
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_1 ON TREATMENT_1.TREATMENT_CODE = tblUROLOGY_MDT.TREATMENT_1
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_2 ON TREATMENT_2.TREATMENT_CODE = tblUROLOGY_MDT.TREATMENT_2
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_3 ON TREATMENT_3.TREATMENT_CODE = tblUROLOGY_MDT.TREATMENT_3
						LEFT JOIN dbo.ltblTREATMENT_TYPE TREATMENT_4 ON TREATMENT_4.TREATMENT_CODE = tblUROLOGY_MDT.TREATMENT_4
						LEFT JOIN dbo.ltblCONSULTANTS CONREF on CONREF.NATIONAL_CODE = tblUROLOGY_MDT.WHO_REFERRED_TO AND CONREF.IS_DELETED = 0
						LEFT JOIN dbo.OrganisationSites on dbo.OrganisationSites.Code = tblUROLOGY_MDT.OTHER_TRUST
	/*WHERE tblUROLOGY_MDT.MEETING_ID IS NOT NULL */
	ORDER BY 25, 2, 3

Columns

View Definition

Possibly Referenced Tables/Views