vwIMAGING_SUMMARY_BREAST

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

IMAGE_ID

int

null

CARE_ID

int

null

N3_2_IMAGING_DATE

smalldatetime

√

null

N3_3_MODALITY

varchar

√

null

MOD_DESC

varchar

√

null

OTHER_MOD

varchar

√

null

N3_4_ANATOMICAL_SITE

varchar

255

√

null

L_SITE_2

varchar

255

√

null

L_SITE_3

varchar

255

√

null

L_IM_RESULT

varchar

√

null

R_CA125

bit

null

R_CA125_RESULT

varchar

255

√

null

R_AFP

bit

null

R_AFP_RESULT

varchar

255

√

null

L_CEA

bit

null

L_CEA_RESULT

varchar

255

√

null

L_5H1AA_RESULT

varchar

255

√

null

L_5H1AA

bit

null

L_CA199_RESULT

varchar

255

√

null

L_CA199

bit

null

L_PSA_RESULT

varchar

255

√

null

L_PSA

bit

null

L_HCG

bit

null

L_HCG_RESULT

varchar

255

√

null

L_LDH

bit

null

L_LDH_RESULT

varchar

255

√

null

L_OTHER_RESULT

varchar

255

√

null

L_OTHER_MARKER

bit

null

L_FBC

bit

null

L_FBC_RESULT

varchar

255

√

null

L_UE

bit

null

L_UE_RESULT

varchar

255

√

null

L_LFT

bit

null

L_LFT_RESULT

varchar

255

√

null

L_CALCIUM

bit

null

L_CALCIUM_RESULT

varchar

255

√

null

L_OTHER

bit

null

L_OTHER_LAB

varchar

255

√

null

L_B2M

bit

null

L_B2M_RESULT

varchar

255

√

null

L_IG

bit

null

L_IG_RESULT

varchar

255

√

null

L_T_STAGE

varchar

√

null

L_T_LETTER

varchar

√

null

L_N_STAGE

varchar

√

null

L_N_LETTER

varchar

√

null

L_M_STAGE

varchar

√

null

L_M_LETTER

varchar

√

null

L_CREAT

bit

null

L_CREAT_RESULT

varchar

255

√

null

L_RENAL

bit

null

L_RENAL_RESULT

varchar

255

√

null

L_VIR

bit

null

L_VIR_RESULT

varchar

255

√

null

L_CRATECH

bit

null

L_CRATECH_RESULT

varchar

255

√

null

N3_5_LESION_SIZE

real

√

null

L_HB

bit

null

L_HB_RESULT

varchar

255

√

null

L_TESTOSTERONE

bit

null

L_TESTOSTERONE_RESULT

varchar

255

√

null

L_PSAD

bit

null

L_PSAD_RESULT

varchar

255

√

null

L_SIDE

varchar

√

null

L_SITE

varchar

√

null

L_FINDINGS

varchar

√

null

L_RESULTS

text

2147483647

√

null

L_OTHER_IMAGING

varchar

√

null

View Definition

CREATE VIEW [dbo].[vwIMAGING_SUMMARY_BREAST]
AS
SELECT     TOP (100) PERCENT dbo.tblMAIN_IMAGING.IMAGE_ID, dbo.tblMAIN_IMAGING.CARE_ID, dbo.tblMAIN_IMAGING.N3_2_IMAGING_DATE, 
                      dbo.tblMAIN_IMAGING.N3_3_MODALITY, ltblIMAGING_MOD_1.MOD_DESC, ltblIMAGING_MOD_2.MOD_DESC AS OTHER_MOD, 
                      dbo.vwANATOMICAL_SITE.SITE_DESC AS N3_4_ANATOMICAL_SITE, vwANATOMICAL_SITE_1.SITE_DESC AS L_SITE_2, 
                      vwANATOMICAL_SITE_2.SITE_DESC AS L_SITE_3, dbo.tblMAIN_IMAGING.L_IM_RESULT, dbo.tblMAIN_IMAGING.R_CA125, 
                      dbo.tblMAIN_IMAGING.R_CA125_RESULT, dbo.tblMAIN_IMAGING.R_AFP, dbo.tblMAIN_IMAGING.R_AFP_RESULT, dbo.tblMAIN_IMAGING.L_CEA, 
                      dbo.tblMAIN_IMAGING.L_CEA_RESULT, dbo.tblMAIN_IMAGING.L_5H1AA_RESULT, dbo.tblMAIN_IMAGING.L_5H1AA, 
                      dbo.tblMAIN_IMAGING.L_CA199_RESULT, dbo.tblMAIN_IMAGING.L_CA199, dbo.tblMAIN_IMAGING.L_PSA_RESULT, dbo.tblMAIN_IMAGING.L_PSA, 
                      dbo.tblMAIN_IMAGING.L_HCG, dbo.tblMAIN_IMAGING.L_HCG_RESULT, dbo.tblMAIN_IMAGING.L_LDH, dbo.tblMAIN_IMAGING.L_LDH_RESULT, 
                      dbo.tblMAIN_IMAGING.L_OTHER_RESULT, dbo.tblMAIN_IMAGING.L_OTHER_MARKER, dbo.tblMAIN_IMAGING.L_FBC, 
                      dbo.tblMAIN_IMAGING.L_FBC_RESULT, dbo.tblMAIN_IMAGING.L_UE, dbo.tblMAIN_IMAGING.L_UE_RESULT, dbo.tblMAIN_IMAGING.L_LFT, 
                      dbo.tblMAIN_IMAGING.L_LFT_RESULT, dbo.tblMAIN_IMAGING.L_CALCIUM, dbo.tblMAIN_IMAGING.L_CALCIUM_RESULT, 
                      dbo.tblMAIN_IMAGING.L_OTHER, dbo.tblMAIN_IMAGING.L_OTHER_LAB, dbo.tblMAIN_IMAGING.L_B2M, dbo.tblMAIN_IMAGING.L_B2M_RESULT, 
                      dbo.tblMAIN_IMAGING.L_IG, dbo.tblMAIN_IMAGING.L_IG_RESULT, dbo.tblMAIN_IMAGING.L_T_STAGE, dbo.tblMAIN_IMAGING.L_T_LETTER, 
                      dbo.tblMAIN_IMAGING.L_N_STAGE, dbo.tblMAIN_IMAGING.L_N_LETTER, dbo.tblMAIN_IMAGING.L_M_STAGE, dbo.tblMAIN_IMAGING.L_M_LETTER, 
                      dbo.tblMAIN_IMAGING.L_CREAT, dbo.tblMAIN_IMAGING.L_CREAT_RESULT, dbo.tblMAIN_IMAGING.L_RENAL, 
                      dbo.tblMAIN_IMAGING.L_RENAL_RESULT, dbo.tblMAIN_IMAGING.L_VIR, dbo.tblMAIN_IMAGING.L_VIR_RESULT, dbo.tblMAIN_IMAGING.L_CRATECH, 
                      dbo.tblMAIN_IMAGING.L_CRATECH_RESULT, dbo.tblMAIN_IMAGING.N3_5_LESION_SIZE, dbo.tblMAIN_IMAGING.L_HB, 
                      dbo.tblMAIN_IMAGING.L_HB_RESULT, dbo.tblMAIN_IMAGING.L_TESTOSTERONE, dbo.tblMAIN_IMAGING.L_TESTOSTERONE_RESULT, 
                      dbo.tblMAIN_IMAGING.L_PSAD, dbo.tblMAIN_IMAGING.L_PSAD_RESULT, dbo.tblBREAST_IMAGING.L_SIDE, dbo.tblBREAST_IMAGING.L_SITE, 
                      dbo.tblBREAST_IMAGING.L_FINDINGS, dbo.tblBREAST_IMAGING.L_RESULTS, dbo.tblMAIN_IMAGING.L_OTHER_IMAGING
FROM         dbo.vwANATOMICAL_SITE AS vwANATOMICAL_SITE_1 RIGHT OUTER JOIN
                      dbo.tblBREAST_IMAGING RIGHT OUTER JOIN
                      dbo.tblMAIN_IMAGING ON dbo.tblBREAST_IMAGING.IMAGING_ID = dbo.tblMAIN_IMAGING.IMAGE_ID LEFT OUTER JOIN
                      dbo.vwANATOMICAL_SITE AS vwANATOMICAL_SITE_2 ON dbo.tblMAIN_IMAGING.L_SITE_3 = vwANATOMICAL_SITE_2.SITE_CODE ON 
                      vwANATOMICAL_SITE_1.SITE_CODE = dbo.tblMAIN_IMAGING.L_SITE_2 LEFT OUTER JOIN
                      dbo.vwANATOMICAL_SITE ON dbo.tblMAIN_IMAGING.N3_4_ANATOMICAL_SITE = dbo.vwANATOMICAL_SITE.SITE_CODE LEFT OUTER JOIN
                      dbo.ltblIMAGING_MOD AS ltblIMAGING_MOD_2 ON dbo.tblMAIN_IMAGING.L_OTHER_IMAGING = ltblIMAGING_MOD_2.MOD_CODE LEFT OUTER JOIN
                      dbo.ltblIMAGING_MOD AS ltblIMAGING_MOD_1 ON dbo.tblMAIN_IMAGING.N3_3_MODALITY = ltblIMAGING_MOD_1.MOD_CODE

Columns

View Definition

Possibly Referenced Tables/Views