tblBREAST_MDT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MDT_ID varchar 255 null
MEETING_ID int 4 √ null
UPDATED varchar 50 √ null

MDT saved indicator (derived)
MDT_SITE varchar 50 √ null

MDT cancer site
NEW_MDT varchar 50 √ null

New MDT indicator (derived)
PLAN_ID int 4 √ null
NEW_PATH varchar 50 √ null
PATH_ID int 4 √ null
NEW_PATH2 varchar 50 √ null
PATH_ID2 int 4 √ null
NEW_PATH3 varchar 50 √ null
PATH_ID3 int 4 √ null
NEW_PATH4 varchar 50 √ null
PATH_ID4 int 4 √ null
NEW_NURSE varchar 50 √ null
NURSE_ID int 4 √ null
CARE_ID int 4 √ null
tblMAIN_REFERRALS.CARE_ID FK_tblBREAST_MDT_tblMAIN_REFERRALSC
NEW_TRIAL varchar 50 √ null
TRIAL_ID int 4 √ null
MDT_DATE smalldatetime 16 √ null
PRE_POST varchar 4 √ null
APP_DATE smalldatetime 16 √ null
CONSULTANT varchar 8 √ null
LOCATION varchar 50 √ null
TNM_DATE smalldatetime 16 √ null
TSTAGE varchar 5 √ null
T_LETTER varchar 3 √ null
NSTAGE varchar 5 √ null
N_LETTER varchar 3 √ null
MSTAGE varchar 5 √ null
ACTION_BY varchar 255 √ null

Action By
CARE_INTENT char 1 √ null
TREATMENT_1 varchar 3 √ null
TREATMENT_2 varchar 3 √ null
TREATMENT_3 varchar 3 √ null
TREATMENT_4 varchar 3 √ null
NO_TREATMENT varchar 50 √ null
REFERRED_TO varchar 50 √ null

Referred To
WHO_REFERRED_TO varchar 8 √ null

Who Referred To
LATERALITY varchar 50 √ null

Laterality
ONCOLOGISTS varchar 255 √ null

Oncologists
DIAGNOSIS varchar 50 √ null
DIAGNOSIS_DATE smalldatetime 16 √ null
PATH_REVIEW varchar 50 √ null

Reviewd by Pathologist prior to MDT
REVIEW_WHO varchar 50 √ null

Reviewed by
HISTOLOGY varchar 255 √ null

Morphology (SNOMed)
GRADE varchar 100 √ null

Grade of Differentiation
PATH_DATE smalldatetime 16 √ null

Biopsy Receipt Date
PATH_DATE2 smalldatetime 16 √ null

Cytology Receipt Date
PATH_DATE3 smalldatetime 16 √ null

Excision Receipt Date
INVASION varchar 50 √ null

Vasculat/Lymphatic Invasion
NODES int 4 √ null

Nodes Examined
POS_NODES int 4 √ null

Positive Nodes
MARGINS varchar 50 √ null

Excision Margins
ER varchar 50 √ null
ER_SCORE real 4 √ null
ER_DETAILS varchar 255 √ null
PR varchar 50 √ null
PR_SCORE real 4 √ null
PR_DETAILS varchar 255 √ null
CERBB2 varchar 50 √ null
CERBB2_SCORE real 4 √ null
CERBB2_DETAILS varchar 255 √ null
BCL2 varchar 50 √ null
BCL2_SCORE real 4 √ null
BCL2_DETAILS varchar 255 √ null
pS2 varchar 50 √ null
pS2_SCORE real 4 √ null
pS2_DETAILS varchar 255 √ null
HER2 varchar 50 √ null
HER2_DETAILS varchar 255 √ null
FISH varchar 50 √ null
FISH_DETAILS varchar 255 √ null
STATUS int 4 √ null

Tumour Staus
TM_DATE smalldatetime 16 √ null
OTHER_TRUST varchar 5 √ null

Oranisation Referred To
TERTIARY_REASON int 4 √ null

Reason for Referral
CLINICAL_TRIAL varchar 2 √ null
KEY_WORKER varchar 255 √ null

Key Worker
DATE_NETWORK_MEETING smalldatetime 16 √ null

Date of Network MDT
NETWORK_ACTIONED varchar 255 √ null

Network MDT To Be Actioned By
CARE_PLAN_AGREED_MDT char 1 √ null

Care Plan agreed at MDT
WHO_STATUS int 4 √ null

Performance Status
NETWORK_FEEDBACK text 2147483647 √ null

Network Feedback
NETWORK_COMMENTS text 2147483647 √ null

Network Comments
COMMENTS text 2147483647 √ null
TRIAL_COMMENTS text 2147483647 √ null
SURGICAL_OUTCOME text 2147483647 √ null
PATH_COMMENTS text 2147483647 √ null
PATH_COMMENTS2 text 2147483647 √ null
cTSTAGE varchar 2 √ null

Final Pre-Treatment (Clinical) Staging (T)
cTLETTER varchar 3 √ null

Final Pre-Treatment (Clinical) Staging T Letter
cNSTAGE varchar 2 √ null

Final Pre-Treatment (Clinical) Staging N Stage
cNLETTER varchar 3 √ null

Final Pre-Treatment (Clinical) Staging N Letter
cMSTAGE varchar 2 √ null

Final Pre-Treatment (Clinical) Staging M Stage
cMLETTER varchar 3 √ null

Final Pre-Treatment (Clinical) Staging M Letter
M_LETTER varchar 3 √ null
cTNM_CATEGORY varchar 50 √ null
cCERTAINTY_FACTORS_T varchar 50 √ null
cCERTAINTY_FACTORS_N varchar 50 √ null
cCERTAINTY_FACTORS_M varchar 50 √ null
cCERTAINTY_FACTORS_OVERALL varchar 50 √ null
FINAL_TNM_DATE datetime 16,3 √ null

Final (Integrated) Staging Date
fTSTAGE varchar 50 √ null

Final (Integrated) Staging T Stage
fTLETTER varchar 50 √ null

Final (Integrated) Staging T Letter
fNSTAGE varchar 50 √ null

Final (Integrated) Staging N Stage
fNLETTER varchar 50 √ null

Final (Integrated) Staging N Letter
fMSTAGE varchar 50 √ null

Final (Integrated) Staging M Stage
fMLETTER varchar 50 √ null

Final (Integrated) Staging M Letter
fTNM_CATEGORY varchar 50 √ null

Final (Integrated) Staging Grouping
fCERTAINTY_FACTORS_T varchar 50 √ null
fCERTAINTY_FACTORS_N varchar 50 √ null
fCERTAINTY_FACTORS_M varchar 50 √ null
fCERTAINTY_FACTORS_OVERALL varchar 50 √ null
CLINICAL_TNM_DATE datetime 16,3 √ null
GERM_CELL_NON_CNS_ID int 4 √ null

TNM Stage Grouping for Non-CNS Germ Cell Tumours
GERM_CELL_NON_CNS_PATH_ID int 4 √ null
CO_MORBIDITY_ID int 4 √ null

Co-morbidity Evaluation - 27 Score
RECURRENCE_CANCER_SITE_ID int 4 √ null

Cancer Site of Recurrence
L_PATHOLOGY_TEXT varchar 2147483647 √ null

Pathology Report Text
PRIMARY_DIAGNOSIS_SUB_COMMENT varchar 50 √ null

Primary Diagnosis Subsidiary Comment
GONADOTROPIN_SERUM int 4 √ null

Beta Human Chorionic Gonadotropin (Serum)
FETOPROTEIN_SERUM int 4 √ null

Alpha Fetoprotein (Serum)
BIOPSY_PATH_TEXT text 2147483647 √ null
CYTOLOGY_PATH_TEXT text 2147483647 √ null
BASIS_DIAGNOSIS int 4 √ null

Basis of Diagnosis
REPORT_NUMBER varchar 50 √ null

Report Number
NEXT_OPA smalldatetime 16 √ null
TO_BE_SEEN_BY varchar 50 √ null
PAT_INFORMED_MDT_OUTCOME varchar 2147483647 √ null

Patient Informed of MDT Outcome
LATERALITY_PATH varchar 50 √ null

Tumour Laterality (Pathology)
KEY_WORKER_OTHER varchar 255 √ null

Key Worker (Other)
KEY_WORKER_NEW int 4 √ null

Key Worker
BIOPSY_REPORT_NUMBER varchar 50 √ null
CYTOLOGY_REPORT_NUMBER varchar 50 √ null
R_NOT_CUR varchar 2 √ null
REASON_PAT_DECLINED bit 1 √ null
REASON_UNFIT_PERFORMANCE bit 1 √ null
REASON_UNFIT_COMORBIDITY bit 1 √ null
REASON_UNFIT_ADVANCED bit 1 √ null
REASON_UNKNOWN_PRIMARY bit 1 √ null
REASON_DIED bit 1 √ null
REASON_NO_TREATMENT bit 1 √ null
REASON_OTHER bit 1 √ null
REASON_MONITORING bit 1 √ null
REASON_NOT_KNOWN bit 1 √ null
NON_CANCER_DIAGNOSIS_CHAPTER int 4 √ null
NON_CANCER_DIAGNOSIS_GROUP varchar 5 √ null
NON_CANCER_DIAGNOSIS_CODE varchar 5 √ null
SNOMedCT int 4 √ null
SNOMEDDiagnosisID int 4 √ null
SNOMEDCTConcepts.ID FK_tblBREAST_MDT_SNOMEDCTConceptsR
DATE_PT_INFORMED datetime 16,3 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblBREAST_MDT_ltblNonPrimaryPathwayOptionsR
TNMOrganisation int 4 √ null
TNMOrganisation_Integrated int 4 √ null
LDHValue int 4 √ null
DEPRECATED_21_01_LDH_NORMAL int 4 √ null
L_PROGNOSIS varchar 50 √ null
L_SIZE real 4 √ null
L_LYMPH_SCORE varchar 50 √ null
L_TUMOUR_GRADE varchar 50 √ null
L_ORG_CODE_DIAGNOSIS varchar 5 √ null
ReferralSubtypeID int 4 √ null
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblBREAST_MDT_ltblMDTDiscussionTypeR
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblBREAST_MDT_OrganisationSitesR
SNOMEDMorph int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblBREAST_MDT Primary key Asc MDT_ID

Relationships

Close relationships within degrees of separation