vwREFERRAL_SUMMARY_BREAST


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IMAGE_ID int 4 null
CARE_ID int 4 null
N3_2_IMAGING_DATE smalldatetime 16 √ null
N3_3_MODALITY varchar 3 √ null
MOD_DESC varchar 50 √ null
OTHER_MOD varchar 50 √ null
N3_4_ANATOMICAL_SITE varchar 255 √ null
L_SITE_2 varchar 255 √ null
L_SITE_3 varchar 255 √ null
L_IM_RESULT varchar 30 √ null
R_CA125 int 4 √ null
R_CA125_RESULT varchar 255 √ null
R_AFP int 4 √ null
R_AFP_RESULT varchar 255 √ null
L_CEA int 4 √ null
L_CEA_RESULT varchar 255 √ null
L_5H1AA_RESULT varchar 255 √ null
L_5H1AA int 4 √ null
L_CA199_RESULT varchar 255 √ null
L_CA199 int 4 √ null
L_PSA_RESULT varchar 255 √ null
L_PSA int 4 √ null
L_HCG int 4 √ null
L_HCG_RESULT varchar 255 √ null
L_LDH int 4 √ null
L_LDH_RESULT varchar 255 √ null
L_OTHER_RESULT varchar 255 √ null
L_OTHER_MARKER int 4 √ null
L_FBC int 4 √ null
L_FBC_RESULT varchar 255 √ null
L_UE int 4 √ null
L_UE_RESULT varchar 255 √ null
L_LFT int 4 √ null
L_LFT_RESULT varchar 255 √ null
L_CALCIUM int 4 √ null
L_CALCIUM_RESULT varchar 255 √ null
L_OTHER int 4 √ null
L_OTHER_LAB varchar 255 √ null
L_B2M int 4 √ null
L_B2M_RESULT varchar 255 √ null
L_IG int 4 √ null
L_IG_RESULT varchar 255 √ null
L_T_STAGE varchar 2 √ null
L_T_LETTER char 1 √ null
L_N_STAGE varchar 2 √ null
L_N_LETTER char 1 √ null
L_M_STAGE char 1 √ null
L_M_LETTER char 1 √ null
L_CREAT int 4 √ null
L_CREAT_RESULT varchar 255 √ null
L_RENAL int 4 √ null
L_RENAL_RESULT varchar 255 √ null
L_VIR int 4 √ null
L_VIR_RESULT varchar 255 √ null
L_CRATECH int 4 √ null
L_CRATECH_RESULT varchar 255 √ null
L_SIDE varchar 50 √ null
L_SITE varchar 50 √ null
L_FINDINGS varchar 3 √ null
N3_5_LESION_SIZE real 4 √ null
L_RESULTS text 2147483647 √ null

View Definition

Possibly Referenced Tables/Views