vwMAIN_IMAGING_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 4 √ 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 bit 1 null
R_CA125_RESULT varchar 255 √ null
R_AFP bit 1 null
R_AFP_RESULT varchar 255 √ null
L_CEA bit 1 null
L_CEA_RESULT varchar 255 √ null
L_5H1AA_RESULT varchar 255 √ null
L_5H1AA bit 1 null
L_CA199_RESULT varchar 255 √ null
L_CA199 bit 1 null
L_PSA_RESULT varchar 255 √ null
L_PSA bit 1 null
L_HCG bit 1 null
L_HCG_RESULT varchar 255 √ null
L_LDH bit 1 null
L_LDH_RESULT varchar 255 √ null
L_OTHER_RESULT varchar 255 √ null
L_OTHER_MARKER bit 1 null
L_FBC bit 1 null
L_FBC_RESULT varchar 255 √ null
L_UE bit 1 null
L_UE_RESULT varchar 255 √ null
L_LFT bit 1 null
L_LFT_RESULT varchar 255 √ null
L_CALCIUM bit 1 null
L_CALCIUM_RESULT varchar 255 √ null
L_OTHER bit 1 null
L_OTHER_LAB varchar 255 √ null
L_B2M bit 1 null
L_B2M_RESULT varchar 255 √ null
L_IG bit 1 null
L_IG_RESULT varchar 255 √ null
L_T_STAGE varchar 3 √ null
L_T_LETTER varchar 3 √ null
L_N_STAGE varchar 3 √ null
L_N_LETTER varchar 3 √ null
L_M_STAGE varchar 3 √ null
L_M_LETTER varchar 3 √ null
L_CREAT bit 1 null
L_CREAT_RESULT varchar 255 √ null
L_RENAL bit 1 null
L_RENAL_RESULT varchar 255 √ null
L_VIR bit 1 null
L_VIR_RESULT varchar 255 √ null
L_CRATECH bit 1 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_RESULTS2 text 2147483647 √ null
L_RESULTS text 2147483647 √ null
L_IMAGING_REPORT_TEXT text 2147483647 √ null
L_OTHER_IMAGING varchar 4 √ null
L_GROUP bit 1 null
L_ECG bit 1 null
L_XMATCH bit 1 null
L_CA153 bit 1 null
MOD_DESC_2 varchar 50 √ null
L_CLOTTING bit 1 null
L_9AMCORTISOL bit 1 null
L_ALBUMIN bit 1 null
ALBUMIN_CB bit 1 null
L_CALCITONIN bit 1 null
L_CRP bit 1 null
L_FSH bit 1 null
L_FT4 bit 1 null
L_GLUCOSE bit 1 null
L_GROWTH_HORMONE bit 1 null
L_IGF_I bit 1 null
L_LH bit 1 null
L_PFT bit 1 null
L_PHENYTOIN bit 1 null
L_PROLACTIN bit 1 null
L_PROTEIN bit 1 null
L_SERUM bit 1 null
L_SODIUM bit 1 null
L_THYROGLOBULIN bit 1 null
L_TSH bit 1 null
L_UFC bit 1 null
L_UNITS int 4 √ null
R_BHCG bit 1 null
L_BENCE bit 1 null
LDH_MLT bit 1 null
L_MYELOMA bit 1 null
L_TESTOSTERONE_LAB bit 1 null
L_CEA_TM bit 1 null
L_HB bit 1 null
L_LDH_TM bit 1 null
L_LFT_TM bit 1 null
L_PSAD bit 1 null
L_TESTOSTERONE bit 1 null
ALBUMIN_LEVEL int 4 √ null
BETA2_MICROGLOBULIN_LEVEL real 4 √ null
N_L5_FEV1_AMOUNT real 4 √ null
N_L6_FEV1_PER real 4 √ null
L_FVC real 4 √ null
L_FVC_PER real 4 √ null
L_DLCO real 4 √ null
L_DLCO_PER real 4 √ null
L_KCO real 4 √ null
L_KCO_PER real 4 √ null
L_PAO2 real 4 √ null
L_PAO2_PER real 4 √ null
R_LVEF real 4 √ null
R_LVEF_PER real 4 √ null
L_ALPTEST bit 1 null
L_ALP_TEST_RESULT varchar 255 √ null

View Definition

Possibly Referenced Tables/Views