VIEW_BREAST_RADIOLOGY

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

N3_2_IMAGING_DATE

smalldatetime

√

null

MOD_DESC

varchar

√

null

OTHER_MOD

varchar

√

null

L_T_STAGE

varchar

√

null

L_T_LETTER

varchar

√

null

L_N_STAGE

varchar

√

null

L_N_LETTER

varchar

√

null

L_M_STAGE

char

√

null

View Definition

CREATE VIEW dbo.VIEW_BREAST_RADIOLOGY
AS
SELECT     TOP 100 PERCENT dbo.tblMAIN_IMAGING.CARE_ID, dbo.tblMAIN_IMAGING.N3_2_IMAGING_DATE, ltblIMAGING_MOD_2.MOD_DESC, 
                      ltblIMAGING_MOD_1.MOD_DESC AS OTHER_MOD, dbo.tblBREAST_IMAGING.L_T_STAGE, dbo.tblBREAST_IMAGING.L_T_LETTER, 
                      dbo.tblBREAST_IMAGING.L_N_STAGE, dbo.tblBREAST_IMAGING.L_N_LETTER, dbo.tblBREAST_IMAGING.L_M_STAGE
FROM         dbo.tblMAIN_IMAGING LEFT OUTER JOIN
                      dbo.ltblIMAGING_MOD ltblIMAGING_MOD_1 ON dbo.tblMAIN_IMAGING.L_OTHER_IMAGING = ltblIMAGING_MOD_1.MOD_CODE LEFT OUTER JOIN
                      dbo.tblBREAST_IMAGING ON dbo.tblMAIN_IMAGING.IMAGE_ID = dbo.tblBREAST_IMAGING.IMAGING_ID LEFT OUTER JOIN
                      dbo.ltblIMAGING_MOD ltblIMAGING_MOD_2 ON dbo.tblMAIN_IMAGING.N3_3_MODALITY = ltblIMAGING_MOD_2.MOD_CODE
WHERE     (dbo.tblBREAST_IMAGING.L_T_STAGE <> '') OR
                      (dbo.tblBREAST_IMAGING.L_N_STAGE <> '') OR
                      (dbo.tblBREAST_IMAGING.L_M_STAGE <> '')

Columns

View Definition

Possibly Referenced Tables/Views