gzBREACH_SUB_TREAT

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

N1_1_NHS_NUMBER

varchar

10

√

null

L_CANCER_SITE

varchar

50

√

null

DECISION_DATE

smalldatetime

16

√

null

START_DATE

smalldatetime

16

√

null

ORG_CODE

varchar

5

√

null

TREATMENT_SETTING

varchar

2

√

null

ADJ_DAYS

int

4

√

null

ADJ_CODE

int

4

√

null

ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.Code

Implied ConstraintR

L_DIAGNOSIS

varchar

5

√

null

N4_5_HISTOLOGY

varchar

10

√

null

Relationships

Close relationships within degrees of separation

View Definition

CREATE VIEW dbo.gzBREACH_SUB_TREAT
AS
SELECT     TOP (100) PERCENT dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, 
                      dbo.tblDEFINITIVE_TREATMENT.DECISION_DATE, dbo.tblDEFINITIVE_TREATMENT.START_DATE, dbo.tblDEFINITIVE_TREATMENT.ORG_CODE, 
                      dbo.tblDEFINITIVE_TREATMENT.TREATMENT_SETTING, dbo.tblDEFINITIVE_TREATMENT.ADJ_DAYS, dbo.tblDEFINITIVE_TREATMENT.ADJ_CODE, 
                      dbo.tblMAIN_REFERRALS.L_DIAGNOSIS, dbo.tblMAIN_REFERRALS.N4_5_HISTOLOGY
FROM         dbo.tblDEMOGRAPHICS RIGHT OUTER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID FULL OUTER JOIN
                      dbo.tblDEFINITIVE_TREATMENT ON dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblDEFINITIVE_TREATMENT.CARE_ID
WHERE     (dbo.tblDEFINITIVE_TREATMENT.START_DATE > { fn NOW() } - 30) AND (dbo.tblDEFINITIVE_TREATMENT.DECISION_DATE IS NOT NULL) AND 
                      (NOT (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS IN ('03', '07', '18'))) AND (dbo.tblDEFINITIVE_TREATMENT.TREAT_NO = 2) AND 
                      (dbo.tblMAIN_REFERRALS.L_INAP_REF IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_INAP_REF <> 1) AND (dbo.tblMAIN_REFERRALS.L_FIRST_APP IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_FIRST_APP <> 1) AND (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS IN ('12', '13')) OR
                      (dbo.tblDEFINITIVE_TREATMENT.START_DATE IS NULL) AND (dbo.tblDEFINITIVE_TREATMENT.DECISION_DATE BETWEEN { fn NOW() } - 31 AND 
                      { fn NOW() } - 18) AND (NOT (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS IN ('03', '07', '18'))) AND 
                      (dbo.tblDEFINITIVE_TREATMENT.TREAT_NO = 2) AND (dbo.tblMAIN_REFERRALS.L_INAP_REF IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_INAP_REF <> 1) AND (dbo.tblMAIN_REFERRALS.L_FIRST_APP IS NULL OR
                      dbo.tblMAIN_REFERRALS.L_FIRST_APP <> 1) AND (dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS IN ('12', '13'))
ORDER BY dbo.tblDEFINITIVE_TREATMENT.START_DATE DESC, dbo.tblMAIN_REFERRALS.L_CANCER_SITE

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views