vwPOV_PATHOLOGY

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

PATHOLOGY_ID

int

null

N8_3_RESULT_DATE

smalldatetime

√

null

TYPE_DESC

varchar

√

null

N8_16_PATH_T_STAGE

varchar

√

null

L_PATH_T_LETTER

char

√

null

N8_17_PATH_N_STAGE

varchar

√

null

L_PATH_N_LETTER

char

√

null

N8_18_PATH_M_STAGE

varchar

√

null

L_PATH_M_LETTER

char

√

null

L_DUKES

varchar

√

null

R_LIVER_METS

varchar

√

null

R_FIGO

varchar

√

null

R_FIGO2

varchar

√

null

M_DESC

varchar

255

√

null

WHO_DESC

varchar

√

null

View Definition

CREATE VIEW dbo.vwPOV_PATHOLOGY
AS
SELECT     dbo.tblMAIN_PATHOLOGY.CARE_ID, dbo.tblMAIN_PATHOLOGY.PATHOLOGY_ID, dbo.tblMAIN_PATHOLOGY.N8_3_RESULT_DATE, 
                      dbo.ltblINVESTIGATION_TYPE.TYPE_DESC, dbo.tblMAIN_PATHOLOGY.N8_16_PATH_T_STAGE, dbo.tblMAIN_PATHOLOGY.L_PATH_T_LETTER, 
                      dbo.tblMAIN_PATHOLOGY.N8_17_PATH_N_STAGE, dbo.tblMAIN_PATHOLOGY.L_PATH_N_LETTER, dbo.tblMAIN_PATHOLOGY.N8_18_PATH_M_STAGE, 
                      dbo.tblMAIN_PATHOLOGY.L_PATH_M_LETTER, dbo.tblPATHOLOGY_COLORECTAL.L_DUKES, dbo.tblPATHOLOGY_COLORECTAL.R_LIVER_METS, 
                      dbo.tblPATHOLOGY_GYNAECOLOGY.R_FIGO, dbo.tblPATHOLOGY_GYNAECOLOGY.R_FIGO2, dbo.ltblSNOMed.M_DESC, 
                      dbo.ltblBRAIN_WHO.WHO_DESC
FROM         dbo.ltblBRAIN_WHO RIGHT OUTER JOIN
                      dbo.tblPATHOLOGY_BRAIN ON dbo.ltblBRAIN_WHO.WHO_CODE = dbo.tblPATHOLOGY_BRAIN.R_WHO RIGHT OUTER JOIN
                      dbo.tblMAIN_PATHOLOGY ON dbo.tblPATHOLOGY_BRAIN.PATHOLOGY_ID = dbo.tblMAIN_PATHOLOGY.PATHOLOGY_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.tblPATHOLOGY_GYNAECOLOGY ON dbo.tblMAIN_PATHOLOGY.PATHOLOGY_ID = dbo.tblPATHOLOGY_GYNAECOLOGY.PATHOLOGY_ID

Columns

View Definition

Possibly Referenced Tables/Views