tblMAIN_IMAGING


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IMAGE_ID int identity 4 √ null
tblBREAST_IMAGING.IMAGING_ID FK_tblBREAST_IMAGING_tblMAIN_IMAGINGC

Investigation Record ID
CARE_ID int 4 null

Referral Record ID
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_REQUEST_DATE smalldatetime 16 √ null

Date Requested
N3_1_SITE_CODE varchar 5 √ null

Organisation
N3_2_IMAGING_DATE smalldatetime 16 √ null

Date Performed
L_REPORT_DATE smalldatetime 16 √ null

Date Reported
N3_3_MODALITY varchar 4 √ null

Investigation
L_OTHER_IMAGING varchar 4 √ null

Other Investigation
L_MOD_TYPE int 4 √ null

Contrast
N3_4_ANATOMICAL_SITE varchar 5 √ null

Anatomical Site
L_SITE_2 varchar 5 √ null

Anatomical Site 2
L_SITE_3 varchar 5 √ null

Anatomical Site 3
L_ANATOMICAL_SIDE_CODE varchar 1 √ null

Anatomical Side
L_LATERALITY varchar 1 √ null

Laterality
N3_5_LESION_SIZE real 4 √ null

Primary Lesion Size
L_IM_RESULT varchar 30 √ null

Outcome
L_T_STAGE varchar 3 √ null

Radiological Staging - T Stage
L_T_LETTER varchar 3 √ null

Radiological Staging - T Letter
L_N_STAGE varchar 3 √ null

Radiological Staging - N Stage
L_N_LETTER varchar 3 √ null

Radiological Staging - N Letter
L_M_STAGE varchar 3 √ null

Radiological Staging - M Stage
L_M_LETTER varchar 3 √ null

Radiological Staging - M Letter
N_C6_INCOMPLETE varchar 20 √ null

Inadequate Reason
L_OTHER_INCOMPLETE varchar 255 √ null

Inadequate Reason - Details
R_COLONOSCOPY_COMP varchar 50 √ null

Complications
R_OTHER_COMPLICATIONS varchar 255 √ null

Complication Details
R_MRI_MARGINS varchar 1 √ null

Margins Threatened
L_CONTRAST varchar 20 √ null

Contrast
L_REQ_BY int 4 √ null

Requested By
L_BOOKED int 4 √ null

Pre-booked Investigation
L_FBC bit 1 null

Lab Tests - FBC
L_FBC_RESULT varchar 255 √ null

Lab Tests - FBC Result
L_UE bit 1 ((0))

Lab Tests - UE
L_UE_RESULT varchar 255 √ null

Lab Tests - UE Result
L_LFT bit 1 ((0))

Lab Tests - LFT
L_LFT_RESULT varchar 255 √ null

Lab Tests - LFT Result
L_CREAT bit 1 null

Creatinine
L_CREAT_RESULT varchar 255 √ null

Creatinine Result
L_RENAL bit 1 ((0))

K, Ca,P04,Mg
L_RENAL_RESULT varchar 255 √ null

K, Ca,P04,Mg Result
L_VIR bit 1 ((0))

Virology
L_VIR_RESULT varchar 255 √ null

Virology Result
L_ECG bit 1 ((0))

Lab Tests - ECG
L_GROUP bit 1 ((0))

Lab Tests - Group Save
L_XMATCH bit 1 ((0))

Lab Tests - XMatch
L_CLOTTING bit 1 ((0))

Lab Tests - Clotting
L_CA153 bit 1 ((0))

Lab Tests - CA 15-3
L_CALCIUM bit 1 ((0))

Lab Tests - Calcium
L_CALCIUM_RESULT varchar 255 √ null

Lab Tests - Calcium Result
L_SODIUM bit 1 ((0))

Lab Tests - Sodium
L_ALBUMIN bit 1 ((0))

Lab Tests - Albumin
L_GLUCOSE bit 1 ((0))

Lab Tests - Randon Glucose
L_UNITS int 4 √ null

Lab Tests - No. of Units
L_PFT bit 1 ((0))

Lab Tests - PFT
L_CRP bit 1 ((0))

Lab Tests - CRP
L_PHENYTOIN bit 1 ((0))

Lab Tests - Phenytoin Level
L_OTHER bit 1 ((0))

Lab Tests - Other
L_OTHER_LAB varchar 255 √ null

Lab Tests - Other
L_FT4 bit 1 ((0))

Lab Tests - Free Thyroxine
L_FT4_RESULTS varchar 255 √ null

Lab Tests - Free Thyroxine Results
L_TSH bit 1 ((0))

Lab Tests - Thyroid Stimulating Hormone
L_TSH_RESULTS varchar 255 √ null

Lab Tests - Thyroid Stimulating Hormone Results
L_9AMCORTISOL bit 1 ((0))

Lab Test - 9 am Cortisol
L_9AMCORTISOL_RESULTS varchar 255 √ null

Lab Tests - 9 am Cortisol Results
L_UFC bit 1 ((0))

Lab Tests - Urinary Free Cortisol
L_UFC_RESULTS varchar 255 √ null

Lab Tests - Urinary Free Cortisol Results
L_LH bit 1 ((0))

Lab Tests - LH
L_LH_RESULTS varchar 255 √ null

Lab Tests - LH Results
L_FSH bit 1 ((0))

Lab Tests - FSH
L_FSH_RESULTS varchar 255 √ null

Lab Tests - FSH Results
L_PROLACTIN bit 1 ((0))

Lab Tests - Prolactin
L_PROLACTIN_RESULTS varchar 255 √ null

Lab Tests - Prolactin Results
L_GROWTH_HORMONE bit 1 ((0))

Lab Tests - Growth Hormone
L_GROWTH_HORMONE_RESULTS varchar 255 √ null

Lab Tests - Growth Hormone Results
L_IGF_I bit 1 ((0))

Lab Tests - IGF-I
L_IGF_I_RESULTS varchar 255 √ null

Lab Tests - IGF-I Results
L_TESTOSTERONE_LAB bit 1 ((0))

Lab Tests - Testosterone
L_TESTOSTERONE_LAB_RESULTS varchar 255 √ null

Lab Tests - Testosterone Results
L_CALCITONIN bit 1 ((0))

Lab Tests - Calcitonin
L_CALCITONIN_RESULT varchar 255 √ null

Lab Tests - Calcitonin Results
L_THYROGLOBULIN bit 1 ((0))

Lab Tests - Thyroglobulin
L_THYROGLOBULIN_RESULT varchar 255 √ null

Lab Tests - Thyroglobulin Results
L_LAB_COMMENTS varchar 8000 √ null

Lab Tests - Comments
L_DILATION bit 1 null

Dilation Required
R_CA125 bit 1 null

Tumour Markers - CA 125
R_CA125_RESULT varchar 255 √ null

Tumour Markers - CA 125 Results
R_AFP bit 1 null

Tumour Markers - AFP
R_AFP_RESULT varchar 255 √ null

Tumour Markers - AFP Results
L_CEA bit 1 ((0))

Lab Tests - CEA
L_CEA_RESULT varchar 255 √ null

Lab Tests - CEA Results
L_CA199 bit 1 null

Tumour Markers - CA 199
L_CA199_RESULT varchar 255 √ null

Tumour Markers - CA 199 Results
L_5H1AA bit 1 null

Lab Tests - 5H1AA
L_5H1AA_RESULT varchar 255 √ null

Lab Tests - 5H1AA Results
L_PSA bit 1 null

Tumour Markers - PSA
L_PSA_RESULT varchar 255 √ null

Tumour Markers - PSA Results
L_HCG bit 1 null

Lab Tests - HCG
L_HCG_RESULT varchar 255 √ null

Lab Tests - HCG Results
L_LDH bit 1 null

Lab Tests - LDH
L_LDH_RESULT varchar 255 √ null

Lab Tests - LDH Results
L_CRATECH bit 1 null

Lab Tests - Catecholamine
L_CRATECH_RESULT varchar 255 √ null

Lab Tests - Catecholamine Results
L_OTHER_MARKER bit 1 null

Tumour Markers - Other
L_OTHER_RESULT varchar 255 √ null

Tumour Markers - Other Results
L_HB bit 1 null

Tumour Markers - Hb
L_HB_RESULT varchar 255 √ null

Tumour Markers - Hb
L_TESTOSTERONE bit 1 null

Tumour Markers - Testosterone
L_TESTOSTERONE_RESULT varchar 255 √ null

Tumour Markers - Testosterone Results
L_PSAD bit 1 null

Tumour Markers - PSA Density
L_PSAD_RESULT varchar 255 √ null

Tumour Markers - PSA Density Details
R_BHCG bit 1 ((0))

Lab Tests - BHCG
R_LIVER_RESULTS int 4 √ null

Liver Results
R_SECOND_MRI int 4 √ null

Result of MRI
R_ENVELOPE real 4 √ null

Tumour to Mesorectal Envelope
R_SPICULES_ENVELOPE real 4 √ null

Spicules to Mesorectal Envelope
R_MESO_ENVELOPE real 4 √ null

Lateral Mesorectal Deposits to Mesorectal Envelope
L_BIOPSY varchar 3 √ null

Biopsy Taken
R_FIGO varchar 50 √ null

Figo Stage (1)
R_FIGO2 varchar 50 √ null

Figo Stage (2)
R_ASCITES varchar 5 √ null

Ascites
R_REASON_CT varchar 255 √ null

Reason CT Used instead of MRI
R_PROBLEM_SIZE varchar 255 √ null

Measurement Comments
L_APPROACH int 4 √ null

Did MRI change surgical approach?
L_SOURCE int 4 √ null

Source
N_L5_FEV1_AMOUNT real 4 √ null

Lung Function Test - FEV1 Amount
N_L6_FEV1_PER real 4 √ null

Lung Function Test - FEV1 Per
L_FVC real 4 √ null

Lung Function Test - FVC Amount
L_FVC_PER real 4 √ null

Lung Function Test - FVC Per
L_DLCO real 4 √ null

Lung Function Test - DLCO Amount
L_DLCO_PER real 4 √ null

Lung Function Test - DLCO Per
L_KCO real 4 √ null

Lung Function Test - KCO Amount
L_KCO_PER real 4 √ null

Lung Function Test - KCO Per
L_PAO2 real 4 √ null

Lung Function Test - Pa02 Amount
L_PAO2_PER real 4 √ null

Lung Function Test - Pa02 Per
R_LVEF real 4 √ null

Lung Function Test - LVEF Amount
R_LVEF_PER real 4 √ null

Lung Function Test - LVEF Per
R_WBC int 4 √ null

WBC Count
L_B2M bit 1 ((0))

Lab Tests - β2 Microglobulin
L_B2M_RESULT varchar 255 √ null

Lab Tests - β2 Microglobulin Results
L_IG bit 1 ((0))

Lab Tests - Immunoglobulin
L_IG_RESULT varchar 255 √ null

Lab Test - Immunoglobulin Results
N_H2_MASS int 4 √ null

Mediastinal Mass Ratio
N_H4_BULK int 4 √ null

Bulk Disease
N_H5_SURVEY int 4 √ null

Myeloma Skeletal Survey
N_H6_EVIDENCE int 4 √ null

Evidence of Myeloma
R_ALBUMIN real 4 √ null

Albumin Result
N_CC22_ANAE varchar 3 √ null

Anaesthesia Required
L_MORPHOLOGY varchar 255 √ null

Morphology
L_IMMUNOPHENOTYPE varchar 255 √ null

Immunophenotype
L_CYTOGENETICS varchar 255 √ null

Cytogenetics
L_EXTRAMEDULLARY_DISEASE varchar 255 √ null

Extramedullary Disease
L_CELL_COUNT real 4 √ null

White Cell Count
L_GLUCOSE_RES real 4 √ null

Glucose
L_PROTEIN_RES real 4 √ null

Protein
L_BIOPSY_SCORE_1 int 4 √ null

Gleason Score (1)
L_BIOPSY_SCORE_2 int 4 √ null

Gleason Score (2)
L_PROSTATE_VOL varchar 50 √ null

Prostate Volume
L_CORES int 4 √ null

No of Cores Sampled
L_CORES_POS int 4 √ null

No of Cores Positive
L_RESULTS text 2147483647 √ null

Comments
L_IMAGING_REPORT_TEXT text 2147483647 √ null

Imaging Report Text
R_FIGO3 varchar 50 √ null

FIGO Stage (3)
HGD_APPEARANCE int 4 √ null

Appearance of HGD
HGD_LESION int 4 √ null

HGD lesion
HGD_COL_LIN_CIRC_LENGTH int 4 √ null

Length of circumferential columnar lining (mm)
HGD_COL_LIN_MAX_LENGTH int 4 √ null

Maximum length of columnar lining (mm)
HGD_BARRETTS_SEGMENT int 4 √ null

Barretts Segment
UGI_STAGING_PROCEDURE varchar 3 √ null

Staging Procedure
L_IMAGING_CODE varchar 6 √ null

Imaging Code(NICIP)
FBC_PLATELET_COUNT int 4 √ null

Lab Tests - FBC - Platelet Count
FBC_WBC_COUNT real 4 √ null

Lab Tests - FBC - WBC Count
FBC_HB_CONCENTRATION real 4 √ null

Lab Tests - FBC - Hb Concentration
BM_BLASTS int 4 √ null

Bone Marrow Blasts
FBC_NEUTROPHIL_COUNT real 4 √ null

Lab Tests - FBC - Neutrophil Count
ALBUMIN_LEVEL int 4 √ null

Albumin Level
ALBUMIN_COMMENTS nvarchar 1000 √ null

Albumin Comments
BETA2_MICROGLOBULIN_LEVEL real 4 √ null

Lab Tests - β2 Microglobulin
FBC_LYMPHOCYTE_COUNT real 4 √ null

Lab Tests - FBC - Lymphocyte Count
FBC_BLOOD_MYELOBLASTS int 4 √ null

Lab Tests - FBC - Blood Myeloblasts
FBC_BLOOD_BASOPHILS int 4 √ null

Lab Tests - FBC - Blood Basophils
FBC_BLOOD_EOSINOPHILS int 4 √ null

Lab Tests - FBC - Blood Eosinophils
ALBUMIN_CB bit 1 ((0))

Lab Tests - Albumin Level
L_PROTEIN bit 1 null

Lab Tests - Protein Electrophonesis
L_PROTEIN_RESULTS varchar 255 √ null

Lab Tests - Protein Electrophonesis Results
L_BENCE bit 1 null

Lab Tests - Bence Jones Protein
L_BENCE_RESULTS varchar 255 √ null

Lab Tests - Bence Jones Protein Results
L_SERUM bit 1 ((0))

Lab Tests - Serum Light Assay
L_SERUM_RESULTS varchar 255 √ null

Lab Tests - Serum Light Assay Results
ROOT_REQUEST_COMMENTS text 2147483647 √ null

RCA - Investigation Requested Comments
ROOT_PERFORMED_COMMENTS text 2147483647 √ null

RCA - Investigation Performed Comments
R_FIGO4 varchar 5 √ null

FIGO Stage (4)
R_FIGO_STAGINGTYPE varchar 5 √ null

FIGO Stage - Staging Type
SNOMED_CT varchar 18 √ null

Imaging Code (SNOMED CT)
ACTION_ID int 4 √ null

Latest Audit Record ID
PORTAL_INVASION_SELECTED bit 1 ((0))

Portal Invasion - COSD Inclusion
QUADRANTIC_BIOPSIES int 4 √ null

Were quadrantic biopsies taken every 2cm from the entire segment of Barrett’s?
ADDITIONAL_BIOPSIES int 4 √ null

Were additional biopsies taken of any visible nodule?
L_MYELOMA bit 1 ((0))

Lab Tests - Myeloma Screening
L_CEA_TM bit 1 null

Tumour Markers - CEA
L_LFT_TM bit 1 null

Tumour Markers - LFT
L_LFT_MLT bit 1 ((0))

Lab Tests - LFT
ROOT_REPORTED_COMMENTS text 2147483647 √ null

RCA - Investigation Reported Comments
RadiologistID int 4 √ null

Radiologist
MOD_ID int 4 null
ltblIMAGING_MOD.MOD_ID FK_tblMAIN_IMAGING_ltblIMAGING_MODR
OtherDescription varchar 50 √ null
REASON_NOT_PERFORMED_ID int 4 √ null
REASON_NOT_PERFORMED_OTHER varchar 40 √ null
LDH_MLT bit 1 ((0))
LDH_MLT_RESULT varchar 255 √ null
R_BHCG_RESULT varchar 255 √ null
L_CA153_RESULT varchar 255 √ null
L_CLOTTING_RESULT varchar 255 √ null
L_CRP_RESULT varchar 255 √ null
L_ECG_RESULT varchar 255 √ null
L_GROUP_RESULT varchar 255 √ null
L_MYELOMA_RESULT varchar 255 √ null
L_PFT_RESULT varchar 255 √ null
L_PHENYTOIN_RESULT varchar 255 √ null
L_SODIUM_RESULT varchar 255 √ null
L_XMATCH_RESULT varchar 255 √ null
L_CEA_TM_RESULT varchar 255 √ null
L_LFT_TM_RESULT varchar 255 √ null
L_LDH_TM_RESULT varchar 255 √ null
L_LDH_TM bit 1 ((0))
L_RANDOM_GLUCOSE varchar 255 √ null
LEFT_VENT_EFR int 4 √ null
CPET_TYPE int 4 √ null
CPET_RESULT int 4 √ null
PortalVeinInvasionID int 4 √ null
ltblPortalVeinInvasion.PortalVeinInvasionID FK_tblMAIN_IMAGING_ltblPortalVeinInvasionR
TertiaryReferralKey uniqueidentifier 16 √ null
PSALessThan01 bit 1 ((0))
TransrectalBiopsyTechnique int 4 √ null
ltblTransrectalBiopsyTechnique.ID FK_tblMAIN_IMAGING_ltblTransrectalBiopsyTechniqueR
TransperinealBiopsyTechnique int 4 √ null
ltblTransperinealBiopsyTechnique.ID FK_tblMAIN_IMAGING_ltblTransperinealBiopsyTechniqueR
BiopsyAnaesthetic int 4 √ null
ltblBiopsyAnaesthetic.ID FK_tblMAIN_IMAGING_ltblBiopsyAnaestheticR
L_ALPTEST bit 1 ((0))
L_ALP_TEST_RESULT varchar 255 √ null
PiradsCategoryId int 4 √ null
PiradsCategory.Id FK_tblMAIN_IMAGING_PiradsCategoryIdR
LikertScoreId int 4 √ null
LikertScore.Id FK_tblMAIN_IMAGING_LikertScoreR

Indexes

Constraint Name Type Sort Column(s)
PK_tblMAIN_IMAGING Primary key Asc IMAGE_ID
IX_CareID Performance Asc CARE_ID
UQ_tblMAIN_IMAGING_CareID_TertiaryReferralKey Must be unique Asc/Asc CARE_ID + TertiaryReferralKey

Relationships

Close relationships within degrees of separation