tblREFERRAL_PAEDIATRICS


Columns

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

Referral Record ID
N_CC1_CCLG_NO varchar 50 √ null
N_CC2_COUNTRY varchar 3 √ null
N_CC15_REF_REASON int 4 √ null
N_CC15_OTHER_REASON varchar 255 √ null
N_CC34_MURPHY int 4 √ null
N_CC37_ANN_A int 4 √ null
N_CC38_ANN_B int 4 √ null
N_CC44_RENAL int 4 √ null
N_CC45_IRS int 4 √ null
IRS_DATE smalldatetime 16 √ null
R_PRETEXT int 4 √ null
R_PRETEXT_EXT int 4 √ null
R_CHANG int 4 √ null
L_SUSPICIOUS bit 1 ((0))
L_EMR_AD bit 1 ((0))
ANN_ARBOR_EXTRANODALITY_ID int 4 √ null
ALK_1_ID int 4 √ null
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 real 4 √ null
NECROSIS int 4 √ null
ADEQUACY_ID int 4 √ null
EWINGS_VOLUME_ID int 4 √ null
EWINGS_CYTOGENETIC_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
MULTIFOCAL_INDICATOR varchar 2 √ null
ANN_ARBOR_SPLENIC_INV int 4 √ null
ANN_ARBOR_DATE smalldatetime 16 √ null
MURPHY_STAGE_DATE smalldatetime 16 √ null
EXTRAMED_DIS_TESTES bit 1 ((0))
EXTRAMED_DIS_CNS bit 1 ((0))
EXTRAMED_DIS_OTHER bit 1 ((0))
CANCER_SITE int 4 √ null
EXTRAMED_DIS_CNS_1 bit 1 ((0))
EXTRAMED_DIS_CNS_2 bit 1 ((0))
EXTRAMED_DIS_CNS_3 bit 1 ((0))
VisualAcuityLeft int 4 √ null
ltblANU.ANU_ID FK_tblREFERRAL_PAEDIATRICS_ltblANU_LeftR
VisualAcuityRight int 4 √ null
ltblANU.ANU_ID FK_tblREFERRAL_PAEDIATRICS_ltblANU_RightR
VisualFieldsLeft int 4 √ null
ltblANU.ANU_ID FK_tblREFERRAL_PAEDIATRICS_ltblANU_VisualFieldsLeftR
VisualFieldsRight int 4 √ null
ltblANU.ANU_ID FK_tblREFERRAL_PAEDIATRICS_ltblANU_VisualFieldsRightR
AMLRiskFactorsID int 4 √ null
ltblAMLRiskFactors.AMLRiskFactorsID Implied ConstraintR
FABClassificationID int 4 √ null
ltblFABClassification.FABClassificationID FK_tblREFERRAL_PAEDIATRICS_ltblFABClassificationR
PaedRiskGroupID int 4 √ null
ltblPaedRiskGroup.PaedRiskGroupID FK_tblREFERRAL_PAEDIATRICS_ltblPaedRiskGroupR
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))
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
WilmsTumourStage int 4 √ null
ltblPAED_RENAL.RENAL_CODE FK_tblREFERRAL_PAEDIATRICS_ltblPAED_RENALR
INRGStagingSystem int 4 √ null
ltblINRG_STAGING.INRG_ID FK_tblREFERRAL_PAEDIATRICS_ltblINRG_STAGINGR
UrineVMACreatinineRatio real 4 √ null
PRETEXT int 4 √ null
ltblPAED_STAGE.STAGE_CODE FK_tblREFERRAL_PAEDIATRICS_ltblPAED_STAGER
StageRenalReportDate smalldatetime 16 √ null
StageRenalReportOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSitesR
StageBrainReportDate smalldatetime 16 √ null
StageBrainOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites1R
LabReportBrainDate smalldatetime 16 √ null
LabReportBrainOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites2R
LabReportSarcomaDate smalldatetime 16 √ null
LabReportSarcomaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites3R
StageUGIReportDate smalldatetime 16 √ null
StageUGIOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites4R
StageLymphomaReportDate smalldatetime 16 √ null
StageLymphomaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites5R
LabMyelodysplasiaReportDate smalldatetime 16 √ null
LabMyelodysplasiaOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites6R
PostInductionMRD int 4 √ null
ltblPOSTInductionMRD.ID FK_tblREFERRAL_PAEDIATRICS_ltblPOSTInductionMRDR
LabResponseReportDate smalldatetime 16 √ null
LabResponseOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites7R

Indexes

Constraint Name Type Sort Column(s)
PK_tblREFERRAL_PAEDIATRICS_1 Primary key Asc CARE_ID
IX_tblREFERRAL_PAEDIATRICS Performance Asc CARE_ID

Relationships

Close relationships within degrees of separation