tblGYNAECOLOGY_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_TRIAL varchar 50 √ null
TRIAL_ID int 4 √ null
NEW_NURSE varchar 50 √ null
NURSE_ID int 4 √ null
CARE_ID int 4 √ null
tblMAIN_REFERRALS.CARE_ID FK_tblGYNAECOLOGY_MDT_tblMAIN_REFERRALSC
MDT_DATE smalldatetime 16 √ null
APP_DATE smalldatetime 16 √ null
CONSULTANT varchar 8 √ 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
TRIAL_STATUS varchar 2 √ null
PRE_POST varchar 4 √ null
HISTOLOGY varchar 255 √ null
GRADE varchar 255 √ null
FIGO varchar 3 √ null
FIGO2 varchar 3 √ null
DIAGNOSIS varchar 50 √ null
DIAGNOSIS_DATE smalldatetime 16 √ null
LATERALITY varchar 1 √ null
PATH_REVIEW varchar 50 √ null
REVIEW_WHO varchar 50 √ null
SEEN_NURSE_DATE smalldatetime 16 √ null
CLINICAL_TNM_DATE smalldatetime 16 √ null
cTSTAGE varchar 2 √ null
cTLETTER varchar 3 √ null
cNSTAGE varchar 2 √ null
cNLETTER varchar 3 √ null
cMSTAGE varchar 2 √ null
PATH_TNM_DATE smalldatetime 16 √ null
pTSTAGE varchar 2 √ null
pTLETTER varchar 3 √ null
pNSTAGE varchar 2 √ null
pNLETTER varchar 3 √ null
pMSTAGE varchar 2 √ null
STATUS int 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
cMLETTER varchar 3 √ null
pMLETTER 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
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
FIGO3 varchar 5 √ null
STAGE_FIGO varchar 5 √ null
STAGE_FIGO2 varchar 5 √ null
STAGE_FIGO3 varchar 5 √ null
NODAL_STATUS_ID int 4 √ 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
BASIS_DIAGNOSIS int 4 √ null
REPORT_NUMBER varchar 50 √ null
NEXT_OPA smalldatetime 16 √ null
TO_BE_SEEN_BY varchar 50 √ null
PATIENT_INFORMED_DIAGNOSIS_DATE datetime 16,3 √ null
PAT_INFORMED_MDT_OUTCOME varchar 2147483647 √ null
STAGE_FIGO4 varchar 5 √ null
STAGE_FIGO_STAGINGTYPE varchar 5 √ null
STAGE_FIGO_PATH varchar 5 √ null
STAGE_FIGO2_PATH varchar 5 √ null
STAGE_FIGO3_PATH varchar 5 √ null
STAGE_FIGO4_PATH varchar 5 √ null
STAGE_FIGO_STAGINGTYPE_PATH varchar 5 √ null
LATERALITY_PATH varchar 1 √ null
KEY_WORKER_NEW int 4 √ null
KEY_WORKER_OTHER varchar 255 √ null
EXCISION_MARGINS varchar 2 √ 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_tblGYNAECOLOGY_MDT_SNOMEDCTConceptsR
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblGYNAECOLOGY_MDT_ltblNonPrimaryPathwayOptionsR
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
ReferralSubtypeID int 4 √ null
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblGYNAECOLOGY_MDT_ltblMDTDiscussionTypeR
StageGynaeReportDate smalldatetime 16 √ null
StageGynaeOrgID int 4 √ null
OrganisationSites.ID FK_tblGYNAECOLOGY_MDT_OrganisationSitesR
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblGYNAECOLOGY_MDT_OrganisationMiscSitesR
SNOMEDMorph int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation