tblPAEDIATRIC_MDT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MDT_ID varchar 255 null

Table Primary key, unique identifyer
MEETING_ID int 4 √ null

Meeting ID of the MDT meeting
UPDATED varchar 50 √ null

MDT saved indicator (derived)
MDT_SITE varchar 50 √ null

MDT cancer site
NEW_MDT varchar 50 √ null
PLAN_ID int 4 √ null

Care Plan Record ID
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_tblPAEDIATRIC_MDT_tblMAIN_REFERRALSC

Referral Record ID
MDT_DATE smalldatetime 16 √ null

Date of the MDT meeting
APP_DATE smalldatetime 16 √ null
CONSULTANT varchar 8 √ null

The Consulatant in charge of this patient for the MDT meeting
HISTOLOGY_GROUP int 4 √ null

Used to filter the histology items shown in the diagnosis screens (first histology dropdown)
HISTOLOGY varchar 10 √ null

Morphology (SNOMed)
DIAGNOSIS_DATE smalldatetime 16 √ null

Patients Date of diagnosis
DIAGNOSIS varchar 50 √ null

Patients Primary Diagnosis
STATUS int 4 √ null

Tumour Staus
LATERALITY varchar 50 √ null

Laterality
LOCATION varchar 50 √ null

MDT Location
ACTION_BY varchar 255 √ null

MDT Treatment Tab, Action By Field
CARE_INTENT char 1 √ null

MDT CarePlan Intent
TREATMENT_1 varchar 3 √ null

MDT First Treatment
TREATMENT_2 varchar 3 √ null

MDT Second Treatment
TREATMENT_3 varchar 3 √ null

MDT Third Treatment
TREATMENT_4 varchar 3 √ null

MDT Forth Treatment
NO_TREATMENT varchar 50 √ null

Reason if no treatment selected
TRIAL_STATUS varchar 2 √ null

Clinical Trial Status
PRE_POST varchar 4 √ null

MDT List Type
REFERRED_TO varchar 50 √ null

Referred To
WHO_REFERRED_TO varchar 8 √ null

Who Referred To
OTHER_TRUST varchar 5 √ null

Oranisation Referred To
TERTIARY_REASON int 4 √ null

Reason for Referral
KEY_WORKER varchar 255 √ null

Key Worker
PATH_TNM_DATE smalldatetime 16 √ null
PATH_T_STAGE varchar 5 √ null
PATH_N_STAGE varchar 5 √ null
PATH_M_STAGE varchar 5 √ null
PATH_T_LETTER varchar 5 √ null
MURPHY int 4 √ null
ANN_A int 4 √ null
ANN_B int 4 √ null
RENAL int 4 √ null
WILMS_DATE smalldatetime 16 √ null
IRS int 4 √ null
IRS_DATE smalldatetime 16 √ null
CHANG int 4 √ null
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
cTSTAGE varchar 5 √ null

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

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

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

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

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

Final Pre-Treatment (Clinical) Staging M Letter
PATH_N_LETTER varchar 5 √ null
PATH_M_LETTER varchar 5 √ 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
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
ANN_ARBOR_EXTRA_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
ALK_1_ID int 4 √ null
PRIMARY_DIAGNOSIS_SUB_COMMENT varchar 50 √ null

Primary Diagnosis Subsidiary Comment
WHITE_BLOOD_CELL_COUNT real 4 √ null
CYTOGENETIC_RISK_SUBSIDIARY_COMMENT varchar 50 √ null
CYTOGENETIC_RISK_CLASSIFICATION_ID int 4 √ null
RISK_CLASS_PATH_NEPHRECTOMY_ID int 4 √ null
RISK_CLASS_PATH_CHEMOTHERAPY_ID int 4 √ null
RHAB_CYTOGENETICS_ID int 4 √ null
RHAB_SITE_PROGNOSIS_CODE_ID int 4 √ null
PRIMARY_TUMOUR_SIZE int 4 √ null
NECROSIS int 4 √ null
ADEQUACY_ID int 4 √ null
EWINGS_VOLUME_ID int 4 √ null
EWINGS_CYTOGENETIC_ID int 4 √ null
FETOPROTEIN int 4 √ null

Alpha Fetoprotein (Cerebrospinal Fluid)
GONADOTROPIN int 4 √ null

Beta Human Chorionic Gonadotropin
GONADOTROPIN_SERUM int 4 √ null

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

Alpha Fetoprotein (Serum)
SARCOMA_TUMOUR_SITE_BONE varchar 4 √ null
SARCOMA_TUMOUR_SITE_SOFT_TISSUE varchar 4 √ null
SARCOMA_TUMOUR_SUBSITE_BONE varchar 2 √ null
SARCOMA_TUMOUR_SUBSITE_SOFT_TISSUE int 4 √ null
BASIS_DIAGNOSIS int 4 √ null

Basis of Diagnosis
LANSKY_ID int 4 √ null
FLIPI_INDEX int 4 √ null
RIPI_INDEX int 4 √ null
LDH_LEVEL_ID int 4 √ null
NO_OF_ABNORMAL_NODAL_AREAS int 4 √ null
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
KEY_WORKER_NEW int 4 √ null

Key Worker
KEY_WORKER_OTHER varchar 255 √ null

Key Worker (Other)
MULTIFOCAL_INDICATOR varchar 2 √ null
EXTRAMED_DIS_TESTES bit 1 √ null
EXTRAMED_DIS_CNS bit 1 √ null
EXTRAMED_DIS_OTHER bit 1 √ null
ANN_ARBOR_SPLENIC_INV int 4 √ null
ANN_ARBOR_DATE smalldatetime 16 √ null
MURPHY_STAGE_DATE smalldatetime 16 √ 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
PAED_CANCER_SITE int 4 √ 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
EXTRAMED_DIS_CNS2 bit 1 ((0))
EXTRAMED_DIS_CNS3 bit 1 ((0))
EXTRAMED_DIS_CNS1 bit 1 ((0))
SNOMEDDiagnosisID int 4 √ null
SNOMEDCTConcepts.ID FK_tblPAEDIATRIC_MDT_SNOMEDCTConceptsR
DATE_PT_INFORMED datetime 16,3 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblPAEDIATRIC_MDT_ltblNonPrimaryPathwayOptionsR
TNMOrganisation int 4 √ null
VisualAcuityLeft int 4 √ null
ltblANU.ANU_ID FK_tblPAEDIATRIC_MDT_ltblANU_LeftR
VisualAcuityRight int 4 √ null
ltblANU.ANU_ID FK_tblPAEDIATRIC_MDT_ltblANU_RightR
VisualFieldsLeft int 4 √ null
ltblANU.ANU_ID FK_tblPAEDIATRIC_MDT_ltblANU_VisualFieldsLeftR
VisualFieldsRight int 4 √ null
ltblANU.ANU_ID FK_tblPAEDIATRIC_MDT_ltblANU_VisualFieldsRightR
TNMOrganisation_Integrated int 4 √ null
LDHValue int 4 √ null
DEPRECATED_21_01_LDH_NORMAL int 4 √ null
AMLRiskFactorsID int 4 √ null
ltblAMLRiskFactors.AMLRiskFactorsID Implied ConstraintR
FABClassificationID int 4 √ null
ltblFABClassification.FABClassificationID FK_tblPAEDIATRIC_MDT_ltblFABClassificationR
EGILScoreID int 4 √ null
ltblEGILScore.EGILScoreID Implied ConstraintR
MixedPhenoHepatomegaly bit 1 ((0))
MixedPhenoSplenomegaly bit 1 ((0))
MixedPhenoLymphadenopathy bit 1 ((0))
MixedPhenoMediastinalMass bit 1 ((0))
UnderlyingIBFMS bit 1 ((0))
UnderlyingPreviousMalignancy bit 1 ((0))
UnderlyingRadiation bit 1 ((0))
UnderlyingToxicInsult bit 1 ((0))
UnderlyingMitochondrialDisorder bit 1 ((0))
UnderlyingOtherSystematicDisorder bit 1 ((0))
UnderlyingCongenitalAnomalies bit 1 ((0))
UnderlyingNoDisease bit 1 ((0))
PaedRiskGroupID int 4 √ null
ltblPaedRiskGroup.PaedRiskGroupID FK_tblPAEDIATRIC_MDT_ltblPaedRiskGroupR
MyelodysplasiaConsanguinity bit 1 ((0))
MyelodysplasiaOrganomegaly bit 1 ((0))
MyelodysplasiaLymphadenopathy bit 1 ((0))
MyelodysplasiaSevereInfections bit 1 ((0))
MyelodysplasiaImmunodeficiency bit 1 ((0))
PaedMyelodysplasiaDeNovoMDS bit 1 ((0))
PaedMyelodysplasiaCytopenia bit 1 ((0))
PaedMyelodysplasiaCytopeniaSideroblasts bit 1 ((0))
PaedMyelodysplasiaCytopeniaBlasts bit 1 ((0))
PaedMyelodysplasiaRAEBInTransformation bit 1 ((0))
CongenitalAnomalies varchar 300 √ null
Cellularity int 4 √ null
BoneMarrowBlasts int 4 √ null
DEBTestID int 4 √ null
ltblDEBTest.DebTestID Implied ConstraintR
DysplasticHaemopoiesisID int 4 √ null
ltblDysplasticHaemopoiesis.DysplasticHaemopoiesisID Implied ConstraintR
PeripheralBloodBlasts int 4 √ null
L_ORG_CODE_DIAGNOSIS varchar 5 √ null
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblPAEDIATRIC_MDT_ltblMDTDiscussionTypeR
StageLymphomaOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSites6R
StageLymphomaReportDate smalldatetime 16 √ null
LabMyelodysplasiaOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSites5R
LabMyelodysplasiaReportDate smalldatetime 16 √ null
LabReportSarcomaOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSites4R
LabReportSarcomaDate smalldatetime 16 √ null
StageUGIOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSites3R
StageUGIReportDate smalldatetime 16 √ null
StageRenalReportOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSites2R
StageRenalReportDate smalldatetime 16 √ null
StageBrainOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSites1R
StageBrainReportDate smalldatetime 16 √ null
LabReportBrainOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationSitesR
LabReportBrainDate smalldatetime 16 √ null
PostInductionMRD int 4 √ null
UrineVMACreatinineRatio real 4 √ null
INRGStagingSystem int 4 √ null
ltblINRG_STAGING.INRG_ID FK_tblPAEDIATRIC_MDT_ltblINRG_STAGINGR
R_PRETEXT int 4 √ null
R_PRETEXT_EXT int 4 √ null
WilmsTumourStage int 4 √ null
ltblPAED_RENAL.RENAL_CODE FK_tblPAEDIATRIC_MDT_ltblPAED_RENALR
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblPAEDIATRIC_MDT_OrganisationMiscSitesR

Indexes

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

Relationships

Close relationships within degrees of separation