DIAGNOSIS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

L_CANCER_SITE

varchar

√

null

PATIENT_ID

int

null

CARE_ID

int

null

N2_13_CANCER_STATUS

varchar

√

null

N4_2_DIAGNOSIS_CODE

varchar

√

null

N4_1_DIAGNOSIS_DATE

smalldatetime

√

null

L_INAP_REF

int

√

null

N4_3_LATERALITY

varchar

√

null

N6_9_SITE_CLASSIFICATION

varchar

√

null

L_NEW_CA_SITE

varchar

√

null

L_TUMOUR_STATUS

int

√

null

L_OTHER_DIAG_DATE

smalldatetime

√

null

L_HISTOLOGY_GROUP

int

√

null

N4_5_HISTOLOGY

varchar

√

null

M_DESC

varchar

255

√

null

N_H110_ANN

int

√

null

L_RAI_STAGE

int

√

null

R_FIGO

varchar

√

null

R_FIGO2

varchar

√

null

L_AJCC

varchar

√

null

SHORT_DESC

varchar

√

null

View Definition

CREATE VIEW [dbo].[DIAGNOSIS]
AS
SELECT     dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.PATIENT_ID, dbo.tblMAIN_REFERRALS.CARE_ID, 
                      dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS, dbo.tblMAIN_REFERRALS.N4_2_DIAGNOSIS_CODE, 
                      dbo.tblMAIN_REFERRALS.N4_1_DIAGNOSIS_DATE, dbo.tblMAIN_REFERRALS.L_INAP_REF, dbo.tblMAIN_REFERRALS.N4_3_LATERALITY, 
                      dbo.tblMAIN_REFERRALS.N6_9_SITE_CLASSIFICATION, dbo.tblMAIN_REFERRALS.L_NEW_CA_SITE, dbo.tblMAIN_REFERRALS.L_TUMOUR_STATUS, 
                      dbo.tblMAIN_REFERRALS.L_OTHER_DIAG_DATE, dbo.tblMAIN_REFERRALS.L_HISTOLOGY_GROUP, dbo.tblMAIN_REFERRALS.N4_5_HISTOLOGY, 
                      dbo.ltblSNOMed.M_DESC, dbo.tblREFERRAL_HAEMATOLOGY.N_H110_ANN, dbo.tblREFERRAL_HAEMATOLOGY.L_RAI_STAGE, 
                      dbo.tblREFERRAL_GYNAECOLOGY.R_FIGO, dbo.tblREFERRAL_GYNAECOLOGY.R_FIGO2, L_AJCC = dbo.ltblSKIN_AJCC.AJCC_DESC, 
                      dbo.ltblSTATUS.SHORT_DESC
FROM         dbo.tblMAIN_REFERRALS LEFT OUTER JOIN
                      dbo.tblREFERRAL_DERMATOLOGY ON dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblREFERRAL_DERMATOLOGY.CARE_ID LEFT OUTER JOIN
                      dbo.ltblSNOMed ON dbo.tblMAIN_REFERRALS.N4_5_HISTOLOGY = dbo.ltblSNOMed.M_CODE LEFT OUTER JOIN
                      dbo.ltblSTATUS ON dbo.tblMAIN_REFERRALS.N2_13_CANCER_STATUS = dbo.ltblSTATUS.STATUS_CODE LEFT OUTER JOIN
                      dbo.tblREFERRAL_GYNAECOLOGY ON dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblREFERRAL_GYNAECOLOGY.CARE_ID LEFT OUTER JOIN
                      dbo.tblREFERRAL_HAEMATOLOGY ON dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblREFERRAL_HAEMATOLOGY.CARE_ID LEFT OUTER JOIN
					dbo.ltblSKIN_AJCC ON dbo.tblREFERRAL_DERMATOLOGY.L_AJCC = dbo.ltblSKIN_AJCC.AJCC_CODE

Columns

View Definition

Possibly Referenced Tables/Views