vwSUMMARY_PATHOLOGY

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

L_CANCER_SITE

varchar

√

null

N8_2_RECEIPT_DATE

smalldatetime

√

null

N8_3_RESULT_DATE

smalldatetime

√

null

N8_16_PATH_T_STAGE

varchar

√

null

N8_17_PATH_N_STAGE

varchar

√

null

N8_18_PATH_M_STAGE

varchar

√

null

L_PATH_T_LETTER

varchar

√

null

L_PATH_N_LETTER

varchar

√

null

L_PATH_M_LETTER

varchar

√

null

M_DESC

varchar

255

√

null

GRADE_DESC

varchar

100

√

null

L_DUKES

varchar

√

null

TYPE_DESC

varchar

√

null

L_COMMENTS

text

2147483647

√

null

SNOMedCT

int

√

null

View Definition

CREATE VIEW [dbo].[vwSUMMARY_PATHOLOGY]
AS
SELECT     TOP 100 PERCENT dbo.tblMAIN_REFERRALS.CARE_ID, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_PATHOLOGY.N8_2_RECEIPT_DATE, 
                      dbo.tblMAIN_PATHOLOGY.N8_3_RESULT_DATE, dbo.tblMAIN_PATHOLOGY.N8_16_PATH_T_STAGE, 
                      dbo.tblMAIN_PATHOLOGY.N8_17_PATH_N_STAGE, dbo.tblMAIN_PATHOLOGY.N8_18_PATH_M_STAGE, dbo.tblMAIN_PATHOLOGY.L_PATH_T_LETTER, 
                      dbo.tblMAIN_PATHOLOGY.L_PATH_N_LETTER, dbo.tblMAIN_PATHOLOGY.L_PATH_M_LETTER, dbo.ltblSNOMed.M_DESC, 
                      dbo.ltblDIFFERENTIATION.GRADE_DESC, dbo.tblPATHOLOGY_COLORECTAL.L_DUKES, dbo.ltblINVESTIGATION_TYPE.TYPE_DESC, 
                      dbo.tblMAIN_PATHOLOGY.L_COMMENTS,dbo.tblMAIN_PATHOLOGY.SNOMedCT
FROM         dbo.tblMAIN_REFERRALS INNER JOIN
                      dbo.tblMAIN_PATHOLOGY ON dbo.tblMAIN_REFERRALS.CARE_ID = dbo.tblMAIN_PATHOLOGY.CARE_ID LEFT OUTER JOIN
                      dbo.ltblSNOMed ON dbo.tblMAIN_PATHOLOGY.N8_10_HISTOLOGY = dbo.ltblSNOMed.M_CODE LEFT OUTER JOIN
                      dbo.ltblINVESTIGATION_TYPE ON dbo.tblMAIN_PATHOLOGY.N8_1_PATHOLOGY_TYPE = dbo.ltblINVESTIGATION_TYPE.TYPE_CODE LEFT OUTER JOIN
                      dbo.tblPATHOLOGY_COLORECTAL ON 
                      dbo.tblMAIN_PATHOLOGY.PATHOLOGY_ID = dbo.tblPATHOLOGY_COLORECTAL.PATHOLOGY_ID LEFT OUTER JOIN
                      dbo.ltblDIFFERENTIATION ON dbo.tblMAIN_PATHOLOGY.N8_11_GRADE_DIFF = dbo.ltblDIFFERENTIATION.GRADE_CODE

Columns

View Definition

Possibly Referenced Tables/Views