vwNOGCA_LATEST_OGD


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IMAGE_ID int 4 null
CARE_ID int 4 null
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_REQUEST_DATE smalldatetime 16 √ null
N3_1_SITE_CODE varchar 5 √ null
N3_2_IMAGING_DATE smalldatetime 16 √ null
L_REPORT_DATE smalldatetime 16 √ null
N3_3_MODALITY varchar 4 √ null
L_OTHER_IMAGING varchar 4 √ null
L_MOD_TYPE int 4 √ null
N3_4_ANATOMICAL_SITE varchar 5 √ null
L_SITE_2 varchar 5 √ null
L_SITE_3 varchar 5 √ null
L_ANATOMICAL_SIDE_CODE varchar 1 √ null
L_LATERALITY varchar 1 √ null
N3_5_LESION_SIZE real 4 √ null
L_IM_RESULT varchar 30 √ 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
N_C6_INCOMPLETE varchar 20 √ null
L_OTHER_INCOMPLETE varchar 255 √ null
R_COLONOSCOPY_COMP varchar 50 √ null
R_OTHER_COMPLICATIONS varchar 255 √ null
R_MRI_MARGINS varchar 1 √ null
L_CONTRAST varchar 20 √ null
L_REQ_BY int 4 √ null
L_BOOKED int 4 √ 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_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_ECG bit 1 null
L_GROUP bit 1 null
L_XMATCH bit 1 null
L_CLOTTING bit 1 null
L_CA153 bit 1 null
L_CALCIUM bit 1 null
L_CALCIUM_RESULT varchar 255 √ null
L_SODIUM bit 1 null
L_ALBUMIN bit 1 null
L_GLUCOSE bit 1 null
L_UNITS int 4 √ null
L_PFT bit 1 null
L_CRP bit 1 null
L_PHENYTOIN bit 1 null
L_OTHER bit 1 null
L_OTHER_LAB varchar 255 √ null
L_FT4 bit 1 null
L_FT4_RESULTS varchar 255 √ null
L_TSH bit 1 null
L_TSH_RESULTS varchar 255 √ null
L_9AMCORTISOL bit 1 √ null
L_9AMCORTISOL_RESULTS varchar 255 √ null
L_UFC bit 1 null
L_UFC_RESULTS varchar 255 √ null
L_LH bit 1 null
L_LH_RESULTS varchar 255 √ null
L_FSH bit 1 null
L_FSH_RESULTS varchar 255 √ null
L_PROLACTIN bit 1 null
L_PROLACTIN_RESULTS varchar 255 √ null
L_GROWTH_HORMONE bit 1 null
L_GROWTH_HORMONE_RESULTS varchar 255 √ null
L_IGF_I bit 1 null
L_IGF_I_RESULTS varchar 255 √ null
L_TESTOSTERONE_LAB bit 1 null
L_TESTOSTERONE_LAB_RESULTS varchar 255 √ null
L_CALCITONIN bit 1 null
L_CALCITONIN_RESULT varchar 255 √ null
L_THYROGLOBULIN bit 1 null
L_THYROGLOBULIN_RESULT varchar 255 √ null
L_LAB_COMMENTS varchar 8000 √ null
L_DILATION bit 1 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_CA199 bit 1 null
L_CA199_RESULT varchar 255 √ null
L_5H1AA bit 1 null
L_5H1AA_RESULT varchar 255 √ null
L_PSA bit 1 null
L_PSA_RESULT varchar 255 √ null
L_HCG bit 1 null
L_HCG_RESULT varchar 255 √ null
L_LDH bit 1 null
L_LDH_RESULT varchar 255 √ null
L_CRATECH bit 1 null
L_CRATECH_RESULT varchar 255 √ null
L_OTHER_MARKER bit 1 null
L_OTHER_RESULT varchar 255 √ null
L_HB bit 1 null
L_HB_RESULT varchar 255 √ null
L_TESTOSTERONE bit 1 null
L_TESTOSTERONE_RESULT varchar 255 √ null
L_PSAD bit 1 null
L_PSAD_RESULT varchar 255 √ null
R_BHCG bit 1 null
R_LIVER_RESULTS int 4 √ null
R_SECOND_MRI int 4 √ null
R_ENVELOPE real 4 √ null
R_SPICULES_ENVELOPE real 4 √ null
R_MESO_ENVELOPE real 4 √ null
L_BIOPSY varchar 3 √ null
R_FIGO varchar 50 √ null
R_FIGO2 varchar 50 √ null
R_ASCITES varchar 5 √ null
R_REASON_CT varchar 255 √ null
R_PROBLEM_SIZE varchar 255 √ null
L_APPROACH int 4 √ null
L_SOURCE int 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
R_WBC int 4 √ null
L_B2M bit 1 null
L_B2M_RESULT varchar 255 √ null
L_IG bit 1 null
L_IG_RESULT varchar 255 √ null
N_H2_MASS int 4 √ null
N_H4_BULK int 4 √ null
N_H5_SURVEY int 4 √ null
N_H6_EVIDENCE int 4 √ null
R_ALBUMIN real 4 √ null
N_CC22_ANAE varchar 3 √ null
L_MORPHOLOGY varchar 255 √ null
L_IMMUNOPHENOTYPE varchar 255 √ null
L_CYTOGENETICS varchar 255 √ null
L_EXTRAMEDULLARY_DISEASE varchar 255 √ null
L_CELL_COUNT real 4 √ null
L_GLUCOSE_RES real 4 √ null
L_PROTEIN_RES real 4 √ null
L_BIOPSY_SCORE_1 int 4 √ null
L_BIOPSY_SCORE_2 int 4 √ null
L_PROSTATE_VOL varchar 50 √ null
L_CORES int 4 √ null
L_CORES_POS int 4 √ null
L_RESULTS text 2147483647 √ null
L_IMAGING_REPORT_TEXT text 2147483647 √ null
R_FIGO3 varchar 50 √ null
HGD_APPEARANCE int 4 √ null
HGD_LESION int 4 √ null
HGD_COL_LIN_CIRC_LENGTH int 4 √ null
HGD_COL_LIN_MAX_LENGTH int 4 √ null
HGD_BARRETTS_SEGMENT int 4 √ null
UGI_STAGING_PROCEDURE varchar 3 √ null
L_IMAGING_CODE varchar 6 √ null
FBC_PLATELET_COUNT int 4 √ null
FBC_WBC_COUNT real 4 √ null
FBC_HB_CONCENTRATION real 4 √ null
BM_BLASTS int 4 √ null
FBC_NEUTROPHIL_COUNT real 4 √ null
ALBUMIN_LEVEL int 4 √ null
ALBUMIN_COMMENTS nvarchar 1000 √ null
BETA2_MICROGLOBULIN_LEVEL real 4 √ null
FBC_LYMPHOCYTE_COUNT real 4 √ null
FBC_BLOOD_MYELOBLASTS int 4 √ null
FBC_BLOOD_BASOPHILS int 4 √ null
FBC_BLOOD_EOSINOPHILS int 4 √ null
ALBUMIN_CB bit 1 null
QUADRANTIC_BIOPSIES int 4 √ null
ADDITIONAL_BIOPSIES int 4 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views