tblREFERRAL_HAEMATOLOGY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblREFERRAL_HAEMATOLOGY_tblMAIN_REFERRALSC

Referral Record ID
N_H110_ANN int 4 √ null

Ann Arbor Symptoms
N_H111_NODAL int 4 √ null

Extra Nodal Disease
N_H112_BONE bit 1 ((0))

Extra Nodal Disease Site - Bone
N_H112_BM bit 1 ((0))

Extra Nodal Disease Site - Bone Marrow
N_H112_UGI bit 1 ((0))

Extra Nodal Disease Site - UDI Tract
N_H112_CNS bit 1 ((0))

Extra Nodal Disease Site - CNS
N_H112_GU bit 1 ((0))

Extra Nodal Disease Site - Genitourinary
N_H112_LIVER bit 1 ((0))

Extra Nodal Disease Site - Liver
N_H112_LGI bit 1 ((0))

Extra Nodal Disease Site - LGI Tract
N_H112_ORBIT bit 1 ((0))

Extra Nodal Disease Site - Orbit
N_H112_SKIN bit 1 ((0))

Extra Nodal Disease Site - Skin
N_H112_STOMACH bit 1 ((0))

Extra Nodal Disease Site - Stomach
N_H112_TESTIS bit 1 ((0))

Extra Nodal Disease Site - Testis
N_H112_THYMUS bit 1 ((0))

Extra Nodal Disease Site - Thymus
N_H112_THYROID bit 1 ((0))

Extra Nodal Disease Site - Thyroid
N_H112_OTHER bit 1 ((0))

Extra Nodal Disease Site - Other
N_H114_AGE int 4 √ null

Age >60
N_H114_LDH int 4 √ null

LDH >Normal
N_H114_WHO int 4 √ null

WHO Status 2-4
N_H114_STAGE int 4 √ null

Stage III/IV
N_H114_SITE int 4 √ null

Extra Nodal Disease >1 Site
N_H115_SCORE int 4 √ null

Prognostic Index
N_H116_ALBUMIN bit 1 ((0))

Serum Albumin <4g/l
N_H116_HB bit 1 ((0))

Hb <10.5g/dl
N_H116_MALE bit 1 ((0))

Gender Male
N_H116_AGE bit 1 ((0))

Age >45
N_H116_STAGE bit 1 ((0))

Stage IV
N_H116_WBC bit 1 ((0))

WBC >15 x10 9 /l
N_H116_LYMPHOCYTE bit 1 ((0))

Lymphocyte <0.6 x 10 9 /l
N_H117_SCORE int 4 √ null

Hasenclever Score
N_H120_SOKAL int 4 √ null

Sokal Score
N_H121_HB int 4 √ null

Hb <10g/dl
N_H121_WBC_L int 4 √ null

WBC <4 x 10 9 /l
N_H121_WBC_H int 4 √ null

WBC >30 x 10 9 /l
N_H122_SCORE int 4 √ null

Lille Score
N_H124_HB int 4 √ null

Hb <10g/dl
N_H124_SYMPTOMS int 4 √ null

Constitutional Symptoms
N_H124_BLASTS int 4 √ null

Circulating Blasts >1%
N_H125_SCORE int 4 √ null

Cervantes Score
L_RAI_STAGE int 4 √ null

Rai Classification
ANN_ARBOR_BULK_ID int 4 √ null

Ann Arbor Bulk
MURPHY_CODE int 4 √ null
ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.Code Implied ConstraintR

Murphy (St Jude) Stage
ANN_ARBOR_EXTRANODALITY_ID int 4 √ null

Ann Arbor Extranodality
BINET_ID int 4 √ null

Binet Classification
DURIE_SALMON varchar 5 √ null

Durie & Salmon Stage
HASFORD_ID int 4 √ null

Hasford Index
ALK_1_ID int 4 √ null

ALK-1 Status
SOKAL_INDEX real 4 √ null

Sokal Index
EXTRANODAL_SITE_ID int 4 √ null

Primary Extranodal Disease Site
WHITE_BLOOD_CELL_COUNT real 4 √ null

White Blood Cell Count (Highest Pre Treatment)
CYTOGENETIC_RISK_SUBSIDIARY_COMMENT varchar 50 √ null

Cytogenetic Risk Subsidiary Comment
BM_KARYOTYPE_ID int 4 √ null

BM Karyotype
LDH_LEVEL_ID int 4 √ null

LDH Level
IPSS real 4 √ null

IPSS
HEPATOMEGALY_IND char 1 √ null

Hepatomegaly Indicator
SPLENOMEGALY_IND char 1 √ null

Splenomegaly Indicator
FLIPI_INDEX int 4 √ null

FLIPI Index Score
RIPI_INDEX int 4 √ null

(R)IPI Index for DLBCL Score
NO_OF_ABNORMAL_NODAL_AREAS int 4 √ null

No of Abnormal Nodal Areas
ANN_ARBOR_SPLENIC_INV int 4 √ null

Ann Arbor Splenic Involvement
EXTRAMED_DIS_TESTES bit 1 ((0))

Extramedullary Disease - Testes
EXTRAMED_DIS_CNS bit 1 ((0))

Extramedullary Disease - CNS
EXTRAMED_DIS_OTHER bit 1 ((0))

Extramedullary Disease - Other
EXTRAMED_DIS_CNS_1 bit 1 ((0))
EXTRAMED_DIS_CNS_2 bit 1 ((0))
EXTRAMED_DIS_CNS_3 bit 1 ((0))
NICEFever bit 1 ((0))
NICENightSweats bit 1 ((0))
NICESoB bit 1 ((0))
NICEPruritus bit 1 ((0))
NICEWeightLoss bit 1 ((0))
NICEAlcohol bit 1 ((0))
AMLRiskFactorsID int 4 √ null
ltblAMLRiskFactors.AMLRiskFactorsID Implied ConstraintR
ALLRiskGroupAllocationID int 4 √ null
ltblALLRiskGroupAllocation.ALLRiskGroupAllocationID FK_tblREFERRAL_HAEMATOLOGY_ltblALLRiskGroupAllocationR
FABClassificationID int 4 √ null
ltblFABClassification.FABClassificationID FK_tblREFERRAL_HAEMATOLOGY_ltblFABClassificationR
PaedRiskGroupID int 4 √ null
ltblPaedRiskGroup.PaedRiskGroupID FK_tblREFERRAL_HAEMATOLOGY_ltblPaedRiskGroupR
EGILScoreID int 4 √ null
ltblEGILScore.EGILScoreID Implied ConstraintR
MixedPhenoSplenomegaly bit 1 ((0))
MixedPhenoLymphadenopathy bit 1 ((0))
MixedPhenoMediastinalMass bit 1 ((0))
MixedPhenoHepatomegaly 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))
MyelodysplasiaConsanguinity bit 1 ((0))
MyelodysplasiaOrganomegaly bit 1 ((0))
MyelodysplasiaLymphadenopathy bit 1 ((0))
MyelodysplasiaSevereInfections bit 1 ((0))
MyelodysplasiaImmunodeficiency bit 1 ((0))
CongenitalAnomalies varchar 300 √ null
PaedMyelodysplasiaDeNovoMDS bit 1 ((0))
PaedMyelodysplasiaCytopenia bit 1 ((0))
PaedMyelodysplasiaCytopeniaSideroblasts bit 1 ((0))
PaedMyelodysplasiaCytopeniaBlasts bit 1 ((0))
PaedMyelodysplasiaRAEBInTransformation bit 1 ((0))
Cellularity int 4 √ null
DEBTestID int 4 √ null
ltblDEBTest.DebTestID Implied ConstraintR
DysplasticHaemopoiesisID int 4 √ null
ltblDysplasticHaemopoiesis.DysplasticHaemopoiesisID Implied ConstraintR
BoneMarrowBlasts int 4 √ null
PeripheralBloodBlasts int 4 √ null
PostInductionMRD int 4 √ null
ltblPOSTInductionMRD.ID FK_tblREFERRAL_HAEMATOLOGY_ltblPOSTInductionMRDR
ELNGeneticRisk int 4 √ null
ltblELNGeneticRisk.ID FK_tblREFERRAL_HAEMATOLOGY_ltblELNGeneticRiskR
RISSStage int 4 √ null
ltblRISSStaging.ID FK_tblREFERRAL_HAEMATOLOGY_ltblRISSStagingR
StageLymphomaReportDate smalldatetime 16 √ null
StageLymphomaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSitesR
StageLeukaemiaReportDate smalldatetime 16 √ null
StageLeukaemiaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites1R
LabResponseReportDate smalldatetime 16 √ null
LabResponseOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites2R
LabLeukaemiaReportDate smalldatetime 16 √ null
LabLeukaemiaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites3R
LabMyelodysplasiaReportDate smalldatetime 16 √ null
LabMyelodysplasiaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites4R
RISSDate date 20 √ null
RISSOrg int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblREFERRAL_HAEMATOLOGY Primary key Asc CARE_ID
IX_ltblREFERRAL_HAEMATOLOGY Performance Asc CARE_ID

Relationships

Close relationships within degrees of separation