tblREFERRAL_UPPER_GI


Columns

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

Referral Record ID
N_UG10_SYMPTOMS varchar 50 √ null

Field not in use
N_UG11_SYMPTOMS varchar 50 √ null

Field not in use
L_DIAG_METHOD varchar 50 √ null

Method of Diagnosis
R_REF_DOCTOR varchar 50 √ null

Referring Doctor Specialism
L_SIEWERT int 4 √ null

Siewert Classification
L_TREATMENT_SITE varchar 2 √ null

Pre-treatment tumour site
HGD_OVERRIDE bit 1 ((0))

Force NOGCA HGD inclusion
PRETEXT int 4 √ null
ltblPAED_STAGE.STAGE_CODE FK_tblREFERRAL_UPPER_GI_ltblPAED_STAGER

Pretext Grouping
NUM_LIVER_METS varchar 1 √ null

No. of Liver Mets (Pre-Op Imaging)
NUM_LESIONS_RADIOLOGICAL int 4 √ null

Number Of Lesions (Radiological)
BARCELONA_CLINIC_STAGE varchar 2 √ null

Barcelona Clinic Liver Cancer (BCLC) Stage
CHILD_PUGH_SCORE varchar 2 √ null

Child-Pugh Score
NICEDiarrhoea bit 1 ((0))
NICEBackPain bit 1 ((0))
NICEAbdominalPain bit 1 ((0))
NICENausea bit 1 ((0))
NICEVomiting bit 1 ((0))
NICEConstipation bit 1 ((0))
NICEDiabetes bit 1 ((0))
LiverCirrhosisTypeID int 4 √ null
ltblLiverCirrhosisType.LiverCirrhosisTypeID FK_tblREFERRAL_UPPER_GI_ltblLiverCirrhosisTypeC
LiverSurveillanceScans int 4 √ null
ltblYNNK.YN_ID FK_tblREFERRAL_UPPER_GI_LiverSurveillanceScansC
DiabetesIndicator int 4 √ null
ltblYNNK.YN_ID FK_tblREFERRAL_UPPER_GI_DiabetesIndicatorR
CirrhosisCauseAlcoholExcess bit 1 ((0))
CirrhosisCauseHepatitisB bit 1 ((0))
CirrhosisCauseHepatitisC bit 1 ((0))
CirrhosisCauseNonAlcoholFattyDisease bit 1 ((0))
CirrhosisCauseHereditaryHaemochromatosis bit 1 ((0))
CirrhosisCauseOther bit 1 ((0))
CirrhosisCauseNotKnown bit 1 ((0))
CirrhosisCauseOtherText varchar 255 √ null
UKELDScore int 4 √ null
NICEWeightloss bit 1 ((0))
PostNeoadjuvantTNMDate date 20 √ null
PostNeoadjuvantTStage varchar 2 √ null
PostNeoadjuvantTLetter varchar 2 √ null
PostNeoadjuvantNStage varchar 2 √ null
PostNeoadjuvantNLetter varchar 2 √ null
PostNeoadjuvantMStage nvarchar 4 √ null
StageUGIReportDate datetime 16,3 √ null

Barcelona Clinic Liver Cancer (BCLC) Stage Date
StageUGIOrgID int 4 √ null
OrganisationSites.ID FK_tblREFERRAL_UPPER_GI_OrganisationSitesR
CirrhosisCauseAutoimmuneHepatitis bit 1 ((0))
CirrhosisCausePrimarySclerosingCholangitis bit 1 ((0))
CirrhosisCausePrimaryBiliaryCholangitis bit 1 ((0))
CholangiocarcinomaCategory int 4 √ null
ltblCholangiocarcinoma.ID FK_tblREFERRAL_UPPER_GI_ltblCholangiocarcinomaR

Indexes

Constraint Name Type Sort Column(s)
PK_tblREFERRAL_UPPER_GI_1 Primary key Asc CARE_ID
IX_tblREFERRAL_UPPER_GI Performance Asc CARE_ID

Relationships

Close relationships within degrees of separation