DIAGNOSIS_SITE_INFO

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

N1_1_NHS_NUMBER

varchar

null

N1_2_HOSPITAL_NUMBER

varchar

√

null

N1_6_FORENAME

varchar

√

null

N1_5_SURNAME

varchar

√

null

N2_9_FIRST_SEEN_DATE

smalldatetime

√

null

N4_1_DIAGNOSIS_DATE

smalldatetime

√

null

N4_2_DIAGNOSIS_CODE

varchar

√

null

DIAGNOSIS_YEAR

int

√

null

L_ORG_CODE_DIAGNOSIS

varchar

√

null

L_CANCER_SITE

varchar

√

null

DIAG_DESC

varchar

√

null

PATIENT_ID

int

null

CARE_ID

int

null

L_TUMOUR_STATUS

int

√

null

View Definition

CREATE VIEW dbo.DIAGNOSIS_SITE_INFO
AS
SELECT     dbo.tblDEMOGRAPHICS.N1_1_NHS_NUMBER, dbo.tblDEMOGRAPHICS.N1_2_HOSPITAL_NUMBER, dbo.tblDEMOGRAPHICS.N1_6_FORENAME, 
                      dbo.tblDEMOGRAPHICS.N1_5_SURNAME, dbo.tblMAIN_REFERRALS.N2_9_FIRST_SEEN_DATE, dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE, 
                      dbo.tblMAIN_REFERRALS.N4_2_DIAGNOSIS_CODE, YEAR(dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE) AS DIAGNOSIS_YEAR, 
                      dbo.tblMAIN_REFERRALS.L_ORG_CODE_DIAGNOSIS, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.ltblDIAGNOSIS.DIAG_DESC, 
                      dbo.tblMAIN_REFERRALS.PATIENT_ID, dbo.tblMAIN_REFERRALS.CARE_ID, dbo.tblMAIN_REFERRALS.L_TUMOUR_STATUS
FROM         dbo.tblDEMOGRAPHICS INNER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblDEMOGRAPHICS.PATIENT_ID = dbo.tblMAIN_REFERRALS.PATIENT_ID LEFT OUTER JOIN
                      dbo.ltblDIAGNOSIS ON dbo.tblMAIN_REFERRALS.N4_2_DIAGNOSIS_CODE = dbo.ltblDIAGNOSIS.DIAG_CODE
WHERE     (dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE IS NOT NULL)

Columns

View Definition

Possibly Referenced Tables/Views