vwMDT_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

CARE_ID

int

null

L_CANCER_SITE

varchar

√

null

N2_9_FIRST_SEEN_DATE

smalldatetime

√

null

CON_DESC

varchar

√

null

STATUS_DESC

varchar

√

null

View Definition

CREATE VIEW dbo.vwMDT_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.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
FROM         dbo.ltblCONSULTANTS RIGHT OUTER JOIN
                      dbo.tblDEMOGRAPHICS INNER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID ON 
                      dbo.ltblCONSULTANTS.NATIONAL_CODE = dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT LEFT OUTER JOIN
                      dbo.ltblTRIAL_STATUS RIGHT OUTER JOIN
                      dbo.tblMAIN_TRIAL ON dbo.ltblTRIAL_STATUS.STATUS_CODE = dbo.tblMAIN_TRIAL.N13_1_ENTERED ON 
                      dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblMAIN_TRIAL.CARE_ID

Columns

View Definition

Possibly Referenced Tables/Views