tblSKIN_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

Indicator for creation of new pathology record
PATH_ID int 4 √ null
NEW_TRIAL varchar 50 √ null

Indicator for creation of new clinical trial record
TRIAL_ID int 4 √ null
NEW_NURSE varchar 50 √ null

Indicator for creation of new CNS contact
NURSE_ID int 4 √ null
CARE_ID int 4 √ null
tblMAIN_REFERRALS.CARE_ID FK_tblSKIN_MDT_tblMAIN_REFERRALSC
APP_DATE smalldatetime 16 √ null

Date First Appointment
CONSULTANT varchar 8 √ null

Consultant
MDT_DATE smalldatetime 16 √ null

MDT Date
LOCATION varchar 50 √ null

MDT Location
ACTION_BY varchar 255 √ null
CARE_INTENT char 1 √ null

Care Plan Intent
TREATMENT_1 varchar 3 √ null

Care plan treatment 1
TREATMENT_2 varchar 3 √ null

Care plan treatment 2
TREATMENT_3 varchar 3 √ null

Care plan treatment 3
TREATMENT_4 varchar 3 √ null

Care plan treatment 4
NO_TREATMENT varchar 50 √ null

No treatment reason
REFERRED_TO varchar 50 √ null
WHO_REFERRED_TO varchar 8 √ null
TRIAL_STATUS varchar 2 √ null
HISTOLOGY varchar 255 √ null
GRADE varchar 255 √ null
DIAGNOSIS varchar 50 √ null

Diagnosis
DIAGNOSIS_DATE smalldatetime 16 √ null

Diagnosis date
THICKNESS varchar 20 √ null

Breslow thickness
CLARK_LEVEL int 4 √ null

Clark level
AJCC int 4 √ null
AJCC_DATE smalldatetime 16 √ null
ULCERATION varchar 1 √ null
MITOTIC varchar 2147483647 √ null
PATH_REVIEW varchar 50 √ null
REVIEW_WHO varchar 50 √ null
CLINICAL_TNM_DATE smalldatetime 16 √ 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
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
LATERALITY varchar 50 √ null
STATUS int 4 √ null
PRE_POST varchar 4 √ null

Pre/post-treatment indicator
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

MDT Comments
REPORT_COMMENTS text 2147483647 √ 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
AJCC_PATH 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

Next OPA
TO_BE_SEEN_BY varchar 50 √ null

To be seen by
PAT_INFORMED_MDT_OUTCOME varchar 2147483647 √ null
LATERALITY_PATH varchar 50 √ null
KEY_WORKER_NEW int 4 √ null
KEY_WORKER_OTHER varchar 255 √ null
MARGINS varchar 50 √ null
R_NOT_CUR varchar 2 √ null
REASON_PAT_DECLINED bit 1 √ null

Reason Not Curative - Patient Declined Treatment
REASON_UNFIT_PERFORMANCE bit 1 √ null

Reason Not Curative - Unfit: Poor Performance Status
REASON_UNFIT_COMORBIDITY bit 1 √ null

Reason Not Curative - Unfit: Significant Co-morbidity
REASON_UNFIT_ADVANCED bit 1 √ null

Reason Not Curative - Unfit: Advanced Stage Cancer
REASON_UNKNOWN_PRIMARY bit 1 √ null

Reason Not Curative - Unknown Primary Site
REASON_DIED bit 1 √ null

Reason Not Curative - Died Before Treatment
REASON_NO_TREATMENT bit 1 √ null

Reason Not Curative - No Anti-Cancer Treatment Available
REASON_OTHER bit 1 √ null

Reason Not Curative - Other
REASON_MONITORING bit 1 √ null

Reason Not Curative - Monitoring Only
REASON_NOT_KNOWN bit 1 √ null

Reason Not Curative - Not Known
NON_CANCER_DIAGNOSIS_CHAPTER int 4 √ null

Non-cancer diagnosis chapter
NON_CANCER_DIAGNOSIS_GROUP varchar 5 √ null

Non-cancer diagnosis group
NON_CANCER_DIAGNOSIS_CODE varchar 5 √ null

Non-cancer diagnosis code
AJCC_TEXT varchar 4 √ null
AJCC_PATH_TEXT varchar 4 √ null
SNOMedCT int 4 √ null
SNOMEDDiagnosisID int 4 √ null
SNOMEDCTConcepts.ID FK_tblSKIN_MDT_SNOMEDCTConceptsR
DATE_PT_INFORMED datetime 16,3 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblSKIN_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_tblSKIN_MDT_ltblMDTDiscussionTypeR
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblSKIN_MDT_OrganisationMiscSitesR
SNOMEDMorph int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation