tblHAEMATOLOGY_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_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_tblHAEMATOLOGY_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
TRIAL_STATUS varchar 2 √ null
HISTOLOGY_GROUP int 4 √ null
HISTOLOGY varchar 10 √ null
DIAGNOSIS varchar 50 √ null
DIAGNOSIS_DATE smalldatetime 16 √ 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
PLANNED_TRANSPLANT int 4 √ null
BINET int 4 √ null
RAI int 4 √ null
ANN_STAGE int 4 √ null
ANN_SYMP int 4 √ null
DURIE_SALMON varchar 2 √ 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
cTSTAGE varchar 2 √ null
cTLETTER varchar 2 √ null
cNSTAGE varchar 2 √ null
cNLETTER varchar 2 √ null
cMSTAGE varchar 2 √ null
cMLETTER varchar 2 √ 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
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
GERM_CELL_NON_CNS_ID int 4 √ null
ISS_ID int 4 √ null
ANN_EXTRA int 4 √ null
ANN_BULK int 4 √ null
MURPHY_ID int 4 √ null
CO_MORBIDITY_ID int 4 √ null
RECURRENCE_CANCER_SITE_ID int 4 √ null
ICD03 varchar 6 √ null
ICD03_GROUP int 4 √ null
SOKAL_SCORE_CODE int 4 √ null
HASFORD_ID int 4 √ null
ALK_1_ID int 4 √ null
PRIMARY_DIAGNOSIS_SUB_COMMENT varchar 50 √ null
WHITE_BLOOD_CELL_COUNT real 4 √ null
CYTOGENETIC_RISK_SUBSIDIARY_COMMENT varchar 50 √ null
GONADOTROPIN_SERUM int 4 √ null
FETOPROTEIN_SERUM int 4 √ null
LDH_LEVEL_ID int 4 √ null
NO_OF_ABNORMAL_NODAL_AREAS int 4 √ null
FLIPI_INDEX int 4 √ null
RIPI_INDEX int 4 √ null
HASENCLEVER_SCORE int 4 √ null
BM_KARYOTYPE_ID int 4 √ null
EXTRANODAL_SITE_ID int 4 √ null
NO_OF_EXTRANODAL_SITES int 4 √ null
IPSS real 4 √ null
HEPATOMEGALY_IND char 1 √ null
SPLENOMEGALY_IND char 1 √ null
SOKAL_INDEX real 4 √ null
BASIS_DIAGNOSIS 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
KEY_WORKER_NEW int 4 √ null
KEY_WORKER_OTHER varchar 255 √ 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
RAI_STAGE_DATE smalldatetime 16 √ null
BINET_STAGE_DATE smalldatetime 16 √ null
ISS_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
NON_CANCER_DIAGNOSIS_CHAPTER int 4 √ null
NON_CANCER_DIAGNOSIS_GROUP varchar 5 √ null
NON_CANCER_DIAGNOSIS_CODE varchar 5 √ 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_tblHAEMATOLOGY_MDT_SNOMEDCTConceptsR
DATE_PT_INFORMED datetime 16,3 √ null
R_MET_LYMPH_REGIONAL int 4 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblHAEMATOLOGY_MDT_ltblNonPrimaryPathwayOptionsR
TNMOrganisation int 4 √ null
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_tblHAEMATOLOGY_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_tblHAEMATOLOGY_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
N_H120_SOKAL int 4 √ null
N_H116_ALBUMIN bit 1 ((0))
N_H116_HB bit 1 ((0))
N_H116_MALE bit 1 ((0))
N_H116_AGE bit 1 ((0))
N_H116_STAGE bit 1 ((0))
N_H116_WBC bit 1 ((0))
N_H116_LYMPHOCYTE bit 1 ((0))
PeripheralBloodBlasts int 4 √ null
L_ORG_CODE_DIAGNOSIS varchar 5 √ null
ReferralSubtypeID int 4 √ null
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblHAEMATOLOGY_MDT_ltblMDTDiscussionTypeR
PostInductionMRD int 4 √ null
ltblPOSTInductionMRD.ID FK_tblHAEMATOLOGY_MDT_ltblPOSTInductionMRDR
ELNGeneticRisk int 4 √ null
ltblELNGeneticRisk.ID FK_tblHAEMATOLOGY_MDT_ltblELNGeneticRiskR
RISSStage int 4 √ null
ltblRISSStaging.ID FK_tblHAEMATOLOGY_MDT_ltblRISSStagingR
StageLymphomaReportDate smalldatetime 16 √ null
StageLymphomaOrgID int 4 √ null
OrganisationSites.ID FK_tblHAEMATOLOGY_MDT_OrganisationSitesR
StageLeukaemiaReportDate smalldatetime 16 √ null
StageLeukaemiaOrgID int 4 √ null
OrganisationSites.ID FK_tblHAEMATOLOGY_MDT_OrganisationSites1R
LabResponseReportDate smalldatetime 16 √ null
LabResponseOrgID int 4 √ null
OrganisationSites.ID FK_tblHAEMATOLOGY_MDT_OrganisationSites2R
LabLeukaemiaReportDate smalldatetime 16 √ null
LabLeukaemiaOrgID int 4 √ null
OrganisationSites.ID FK_tblHAEMATOLOGY_MDT_OrganisationSites3R
LabMyelodysplasiaReportDate smalldatetime 16 √ null
LabMyelodysplasiaOrgID int 4 √ null
OrganisationSites.ID FK_tblHAEMATOLOGY_MDT_OrganisationSites4R
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblHAEMATOLOGY_MDT_OrganisationMiscSitesR
RISSDate date 20 √ null
RISSOrg int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation