tblMAIN_CHEMOTHERAPY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CHEMO_ID int identity 4 √ null
tblCHEMOTHERAPY_DERMATOLOGY.CHEMO_ID FK_tblCHEMOTHERAPY_DERMATOLOGY_tblMAIN_CHEMOTHERAPYC
tblCHEMOTHERAPY_GYNAECOLOGY.CHEMO_ID FK_tblCHEMOTHERAPY_GYNAECOLOGY_tblMAIN_CHEMOTHERAPYC
tblCHEMOTHERAPY_PAEDIATRIC.CHEMO_ID FK_tblCHEMOTHERAPY_PAEDIATRIC_tblMAIN_CHEMOTHERAPYC
tblCHEMOTHERAPY_UROLOGY.CHEMO_ID FK_tblCHEMOTHERAPY_UROLOGY_tblMAIN_CHEMOTHERAPYC
tblChemotherapyDrugRegimen.ChemoID FK_tblChemotherapyDrugRegimen_tblMAIN_CHEMOTHERAPYR
tblChemotherapyToxicitySymptoms.ChemoID FK_tblChemotherapyToxicitySymptoms_tblMAIN_CHEMOTHERAPYR
tblMAIN_CHEMO_TREATMENT.CHEMO_ID FK_tblMAIN_CHEMO_TREATMENT_tblMAIN_CHEMOTHERAPYC

Unique Record ID (Auto)
CARE_ID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblMAIN_CHEMOTHERAPY_tblMAIN_REFERRALSC

Links record to Referrals
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR

System ID
PROG_NUMBER int 4 √ null
REG_NUMBER int 4 √ null
N9_1_SITE_CODE varchar 5 √ null

Organisation
N_SITE_CODE_DTT varchar 5 √ null
N9_2_CONSULTANT varchar 8 √ null

Consultant
N9_3_SPECIALTY varchar 5 √ null

Specialty (Derived)
N9_4_DECISION_DATE smalldatetime 16 √ null

Date Decision to Treat
N9_7_THERAPY_TYPE varchar 1 √ null

Drug Therapy Type
N9_8_TREATMENT_INTENT int 4 √ null
ltblTreatmentIntent.IntentID FK_tblMAIN_CHEMOTHERAPY_ltblTreatmentIntentR

Treatment Intent
N9_9_DRUG_REGIMEN varchar 255 √ null

Drug Regimen Acronym
N9_10_START_DATE smalldatetime 16 √ null

Initial Start Date
N9_16_CYCLE_NO varchar 10 √ null

Planned Cycles/Courses
N9_20_DOSAGE int 4 √ null

Dosage - not used
N9_21_DURATION int 4 √ null

Duration - not used
N9_22_RESPONSE int 4 √ null

Disease Response
N9_24_CHEMO_HRG varchar 50 √ null

HRG - not used
N_B7_ENDOCRINE_TYPE varchar 50 √ null

Endocrine Therapy Type (Breast only)
N_L27_CHEMO_GIVEN varchar 2 √ null

Treatment Given (Lung only)
N_TREATMENT_EVENT varchar 2 √ null
N_TREATMENT_SETTING varchar 2 √ null
N_CHEMORADIO int 4 √ null
L_END_DATE smalldatetime 16 √ null

Review/End Date
L_TRIAL int 4 √ null

Is this a Clinical Trial
L_CYCLE_GIVEN varchar 10 √ null

Actual Cycles/Courses
DEPRECATED_20_02_L_NAMED_COMP varchar 50 √ null

Severe Complications (Head and Neck only)
L_AROMATASE int 4 √ null

Aromatase (Breast only)
L_AROMATASE_DETAILS varchar 255 √ null

Aromatase Details (Breast only)
L_ROUTE varchar 2 √ null

Route of Administration (Brain and Skin only)
DEFINITIVE_TREATMENT int 4 √ null

Definitive Treatment Flag (System)
CWT_PROFORMA int 4 √ null

CWT Proforma Entry Flag (System)
L_HEIGHT real 4 √ null
L_WEIGHT real 4 √ null
L_WHO_STATUS int 4 √ null
L_CO_MORBIDITY int 4 √ null
L_DOSE_REDUCTION int 4 √ null
L_TIME_DELAY int 4 √ null
L_STOPPED_EARLY int 4 √ null
L_DATE_DEATH smalldatetime 16 √ null
L_COMMENTS text 2147483647 √ null

Comments
CONSULTANT_AGE_SPECIALTY varchar 1 √ null
TRANS_ARTERIAL_CHEMOEMBO varchar 1 √ null
ROOT_START_DATE_COMMENTS text 2147483647 √ null
ROOT_END_DATE_COMMENTS text 2147483647 √ null
ACTION_ID int 4 √ null
CHEMO_TIMING int 4 √ null
DEPRECATED_20_02_DISCHARGE_DATE smalldatetime 16 √ null
DEPRECATED_20_02_DISCHARGE_DELAY_REASON int 4 √ null
DEPRECATED_20_02_DISCHARGE_DESTINATION varchar 50 √ null
DISCHARGE_SUMMARY_SENT int 4 √ null
HANADrugRegimen int 4 √ null
AcuteToxicity int 4 √ null
ROOT_DECISION_DATE_COMMENTS text 2147483647 √ null
PrimaryInductionFailureID int 4 √ null
ltblYNNK.YN_ID FK_tblMAIN_CHEMOTHERAPY_PrimaryInductionFailureR
AdjunctiveTherapyID int 4 √ null
ltblAdjunctiveTherapy.AdjunctiveTherapyID FK_tblMAIN_CHEMOTHERAPY_ltblAdjunctiveTherapyR
OtherTreatmentIntent varchar 255 √ null
HCCEmbolisation int 4 √ null
HCCEmbolisationModality int 4 √ null
TreatmentCompletedAsPlanned int 4 √ null
ltblTreatmentCompletedAsPlanned.ID FK_tblMAIN_CHEMOTHERAPY_ltblTreatmentCompletedAsPlannedR
NotCompleteReasonID int 4 √ null
ltblChemotherapyNotCompleteReason.ID FK_tblMAIN_CHEMOTHERAPY_ltblChemotherapyNotCompleteReasonR
PalExtendLifeExpectancy bit 1 ((0))
PalRelieveControlSymptoms bit 1 ((0))
PalAchieveRemission bit 1 ((0))
PalDelayTumourProgression bit 1 ((0))
OtherReasonNotCompleted varchar 55 √ null
RegOutcomeToxicity int 4 √ null
RegOutcomeNonCurative int 4 √ null
TertiaryReferralKey uniqueidentifier 16 √ null
ROOT_PRIM_ADJUSTMENT_COMMENTS text 2147483647 √ null
ROOT_SUBPRIM_ADJUSTMENT_COMMENTS text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblMAIN_CHEMOTHERAPY Primary key Asc CHEMO_ID
IX_MAIN_CHEMOTHERAPY__CARE_ID Performance Asc CARE_ID
IX_tblMAIN_CHEMOTHERAPY_CARE_ID Performance Asc CARE_ID
UQ_tblMAIN_CHEMOTHERAPY_CareID_TertiaryReferralKey Must be unique Asc/Asc CARE_ID + TertiaryReferralKey

Relationships

Close relationships within degrees of separation