DIAG_TREAT

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PATIENT_ID

int

null

CARE_ID

int

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_1_NHS_NUMBER

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

L_CANCER_SITE

varchar

√

null

DECISION_DATE

smalldatetime

√

null

START_DATE

smalldatetime

√

null

N4_2_DIAGNOSIS_CODE

varchar

√

null

N4_1_DIAGNOSIS_DATE

smalldatetime

√

null

L_ORG_CODE_DIAGNOSIS

varchar

√

null

TREAT_DESC

varchar

100

√

null

CON_DESC

varchar

√

null

N2_13_CANCER_STATUS

varchar

√

null

View Definition

CREATE VIEW dbo.DIAG_TREAT
AS
SELECT     dbo.tblMAIN_REFERRALS.PATIENT_ID, dbo.tblMAIN_REFERRALS.CARE_ID, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, 
                      dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblDEMOGRAPHICS.N1_6_FORENAME, 
                      dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblDEFINITIVE_TREATMENT.DECISION_DATE, dbo.tblDEFINITIVE_TREATMENT.START_DATE, 
                      dbo.tblMAIN_REFERRALS.N4_2_DIAGNOSIS_CODE, dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE, 
                      dbo.tblMAIN_REFERRALS.L_ORG_CODE_DIAGNOSIS, dbo.ltblDEFINITIVE_TYPE.TREAT_DESC, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS
FROM         dbo.ltblCONSULTANTS RIGHT OUTER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.ltblCONSULTANTS.NATIONAL_CODE = dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT LEFT OUTER JOIN
                      dbo.tblDEFINITIVE_TREATMENT INNER JOIN
                      dbo.ltblDEFINITIVE_TYPE ON dbo.tblDEFINITIVE_TREATMENT.TREATMENT = dbo.ltblDEFINITIVE_TYPE.TREAT_CODE ON 
                      dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblDEFINITIVE_TREATMENT.CARE_ID LEFT OUTER JOIN
                      dbo.tblDEMOGRAPHICS ON dbo.tblMAIN_REFERRALS.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID
WHERE     (dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE IS NOT NULL) AND (dbo.tblMAIN_REFERRALS.L_INAP_REF IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_INAP_REF <> 1) AND (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS <> '03') AND 
                      (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS <> '07') AND (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS <> '12') AND 
                      (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS <> '13') AND (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS < '15')

Columns

View Definition

Possibly Referenced Tables/Views