tblUGI_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_SITE varchar 50 √ null
NEW_MDT varchar 50 √ null
PLAN_ID int 4 √ null
NEW_PATH varchar 50 √ null
PATH_ID int 4 √ null
NEW_NURSE varchar 50 √ null
NURSE_ID int 4 √ null
NEW_TRIAL varchar 50 √ null
TRIAL_ID int 4 √ null
CARE_ID int 4 √ null
tblMAIN_REFERRALS.CARE_ID FK_tblUGI_MDT_tblMAIN_REFERRALSC
APP_DATE smalldatetime 16 √ null
CONSULTANT varchar 8 √ null
MDT_DATE smalldatetime 16 √ null
LOCATION varchar 50 √ null
ACTION_BY varchar 255 √ null
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
WHO_REFERRED_TO varchar 8 √ null
LETTER_CC varchar 50 √ null
TRIAL_STATUS varchar 2 √ null
HISTOLOGY varchar 255 √ null
GRADE varchar 255 √ null
DIAGNOSIS varchar 50 √ null
DIAGNOSIS_DATE smalldatetime 16 √ null
PATH_REVIEW varchar 50 √ null
REVIEW_WHO varchar 50 √ null
PATH_TNM_DATE smalldatetime 16 √ null
pTSTAGE varchar 2 √ null
pTLETTER varchar 2 √ null
pNSTAGE varchar 2 √ null
pNLETTER varchar 2 √ null
pMSTAGE varchar 2 √ null
pMLETTER varchar 2 √ null
BASIS_DIAGNOSIS int 4 √ null
DIAG_METHOD varchar 50 √ null
NODES int 4 √ null
POS_NODES int 4 √ null
VASCULAR char 1 √ null
LOCAL_INV varchar 3 √ null
LIVER_METS varchar 50 √ null
STATUS int 4 √ null
PRE_POST varchar 4 √ null
OTHER_TRUST varchar 5 √ null
TERTIARY_REASON int 4 √ null
KEY_WORKER varchar 255 √ null
DATE_NETWORK_MEETING smalldatetime 16 √ null
NETWORK_ACTIONED varchar 255 √ null
CARE_PLAN_AGREED_MDT char 1 √ null
WHO_STATUS int 4 √ null
NETWORK_FEEDBACK text 2147483647 √ null
NETWORK_COMMENTS text 2147483647 √ null
COMMENTS text 2147483647 √ null
DIAG_COMMENTS text 2147483647 √ null
REPORT_COMMENTS text 2147483647 √ null
cTSTAGE varchar 2 √ null
cTLETTER varchar 2 √ null
cNSTAGE varchar 2 √ null
cNLETTER varchar 2 √ null
cMSTAGE varchar 2 √ null
cMLETTER varchar 2 √ null
SIEWERT int 4 √ null
TREATMENT_SITE varchar 2 √ 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
fTSTAGE varchar 50 √ null
fTLETTER varchar 50 √ null
fNSTAGE varchar 50 √ null
fNLETTER varchar 50 √ null
fMSTAGE varchar 50 √ null
fMLETTER varchar 50 √ null
fTNM_CATEGORY varchar 50 √ null
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
GERM_CELL_NON_CNS_PATH_ID int 4 √ null
CO_MORBIDITY_ID int 4 √ null
RECURRENCE_CANCER_SITE_ID int 4 √ null
L_PATHOLOGY_TEXT varchar 2147483647 √ null
PRIMARY_DIAGNOSIS_SUB_COMMENT varchar 50 √ null
GONADOTROPIN_SERUM int 4 √ null
FETOPROTEIN_SERUM int 4 √ null
NO_OF_LIVER_METS int 4 √ null
REPORT_NUMBER varchar 50 √ null
LATERALITY varchar 50 √ null
NEXT_OPA smalldatetime 16 √ null
TO_BE_SEEN_BY varchar 50 √ null
PAT_INFORMED_MDT_OUTCOME varchar 2147483647 √ null
R_NOT_CUR varchar 2 √ null
LATERALITY_PATH varchar 50 √ null
KEY_WORKER_NEW int 4 √ null
KEY_WORKER_OTHER varchar 255 √ null
MARGINS varchar 50 √ null
NUM_LESIONS_RADIOLOGICAL int 4 √ null
BARCELONA_CLINIC_STAGE varchar 2 √ null
CHILD_PUGH_SCORE 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_tblUGI_MDT_SNOMEDCTConceptsR
DATE_PT_INFORMED datetime 16,3 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblUGI_MDT_ltblNonPrimaryPathwayOptionsR
UKELDScore int 4 √ null
TNMOrganisation int 4 √ null
TNMOrganisation_Integrated int 4 √ null
LDHValue int 4 √ null
DEPRECATED_21_01_LDH_NORMAL int 4 √ null
L_ORG_CODE_DIAGNOSIS varchar 5 √ null
PostNeoadjuvantTNMDate date 20 √ null
PostNeoadjuvantTStage varchar 3 √ null
PostNeoadjuvantTLetter varchar 3 √ null
PostNeoadjuvantNStage varchar 3 √ null
PostNeoadjuvantNLetter varchar 3 √ null
PostNeoadjuvantMStage varchar 3 √ null
ReferralSubtypeID int 4 √ null
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblUGI_MDT_ltblMDTDiscussionTypeR
StageUGIReportDate smalldatetime 16 √ null
StageUGIOrgID int 4 √ null
OrganisationSites.ID FK_tblUGI_MDT_OrganisationSitesR
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblUGI_MDT_OrganisationMiscSitesR
PRETEXT int 4 √ null
ltblPAED_STAGE.STAGE_CODE FK_tblUGI_MDT_ltblPAED_STAGER
SNOMEDMorph int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation