SUSPECTED_DIAGNOSED

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

PATIENT_ID

int

null

L_CANCER_SITE

varchar

√

null

N2_13_CANCER_STATUS

varchar

√

null

N2_9_FIRST_SEEN_DATE

smalldatetime

√

null

N1_3_ORG_CODE_SEEN

varchar

√

null

N2_6_RECEIPT_DATE

smalldatetime

√

null

N2_4_PRIORITY_TYPE

varchar

√

null

N1_1_NHS_NUMBER

varchar

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_5_SURNAME

varchar

√

null

N1_6_FORENAME

varchar

√

null

CON_DESC

varchar

√

null

TYPE_DESC

varchar

√

null

SPECIALTY_DESC

varchar

150

√

null

L_TUMOUR_STATUS

int

√

null

View Definition

CREATE VIEW dbo.SUSPECTED_DIAGNOSED
AS
SELECT     dbo.tblMAIN_REFERRALS.CARE_ID, dbo.tblMAIN_REFERRALS.PATIENT_ID, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, 
                      dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, 
                      dbo.tblMAIN_REFERRALS.N1_3_ORG_CODE_SEEN, dbo.tblMAIN_REFERRALS.N2_6_RECEIPT_DATE, 
                      dbo.tblMAIN_REFERRALS.N2_4_PRIORITY_TYPE, dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, 
                      dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblDEMOGRAPHICS.N1_6_FORENAME, dbo.ltblCONSULTANTS.CON_DESC, 
                      dbo.ltblAPP_TYPE.TYPE_DESC, dbo.ltblSPECIALTIES.SPECIALTY_DESC, dbo.tblMAIN_REFERRALS.L_TUMOUR_STATUS
FROM         dbo.ltblAPP_TYPE RIGHT OUTER JOIN
                      dbo.tblDEMOGRAPHICS INNER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID ON 
                      dbo.ltblAPP_TYPE.TYPE_CODE = dbo.tblMAIN_REFERRALS.L_FIRST_APP LEFT OUTER JOIN
                      dbo.ltblSPECIALTIES RIGHT OUTER JOIN
                      dbo.ltblCONSULTANTS ON dbo.ltblSPECIALTIES.SPECIALTY_CODE = dbo.ltblCONSULTANTS.SPEC_CODE ON 
                      dbo.tblMAIN_REFERRALS.N2_7_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE
WHERE     (dbo.tblMAIN_REFERRALS.L_INAP_REF IS NULL) OR
                      (dbo.tblMAIN_REFERRALS.L_INAP_REF <> 1)

Columns

View Definition

Possibly Referenced Tables/Views