tblMAIN_TELETHERAPY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TELE_ID int identity 4 √ null
tblTELETHERAPY_DERMATOLOGY.TELE_ID FK_tblTELETHERAPY_DERMATOLOGY_tblMAIN_TELETHERAPYC
tblTeletherapyToxicitySymptoms.TeleID FK_tblTeletherapyToxicitySymptoms_tblMAIN_TELETHERAPYR

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

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

System ID
N10_1_SITE_CODE varchar 5 √ null

Organisation
N_SITE_CODE_DTT varchar 5 √ null
N10_2_CONSULTANT varchar 8 √ null

Consultant
N10_3_DECISION_DATE smalldatetime 16 √ null

Date Decision to Treat
N10_6_TREATMENT_INTENT int 4 √ null
ltblTreatmentIntent.IntentID FK_tblMAIN_TELETHERAPY_ltblTreatmentIntentR

Treatment Intent
N10_7_TREATMENT_SITE varchar 5 √ null

Anatomical Site
N10_8_START_DATE smalldatetime 16 √ null

Start Date
N10_9_END_DATE smalldatetime 16 √ null

End Date
N10_10_DOSE real 4 √ null

Prescribed Dose
N10_11_FRACTIONS real 4 √ null

Prescribed Fractions
N10_12_DURATION int 4 √ null

Prescribed Duration
N10_13_ACTUAL_DOSE real 4 √ null

Actual Dose
N10_14_ACTUAL_FRACTIONS real 4 √ null

Actual Fractions
N10_15_ACTUAL_DURATION int 4 √ null

Actual Duration
N10_16_BEAM_TYPE varchar 1 √ null

Beam Quality
N10_17_BEAM_ENERGY_1 varchar 1 √ null

Energy - Electrons
N10_17_BEAM_ENERGY_2 varchar 1 √ null

Energy - Photons
N10_18_FIELDS varchar 1 √ null

Fields
N10_19_COMPLEXITY varchar 1 √ null

Complexity Group
N10_20_ANAESTHETIC varchar 5 √ null

Anaesthetic Required
N10_21_MULTIPLE_PLANNING varchar 5 √ null

Multiple Planning
N_L26_RT_GIVEN varchar 2 √ null

Treatment Given (Lung only)
N_TREATMENT_EVENT varchar 2 √ null
N_TREATMENT_SETTING varchar 2 √ null
N_PRIORITY varchar 1 √ null
N_CHEMORADIO int 4 √ null
L_DOSE_FRACTIONS real 4 √ null

Doses per Fraction
L_FRACTIONS_WEEK int 4 √ null

Fraction per Week
L_NAMED_COMP varchar 50 √ null

Severe Complications (Head and Neck only)
L_COMP_3MTH varchar 50 √ null

Complications > 3mths (Head and Neck only)
L_SHORT_LONG varchar 5 √ null

Short/Long Course
L_TRIAL int 4 √ null

Is this a Clinical Trial
L_FRAME int 4 √ null

Frame Used (Brain only)
R_TREAT_TO varchar 2 √ null
DEFINITIVE_TREATMENT int 4 √ null

Definitive Treatment Flag (System)
CWT_PROFORMA int 4 √ null

CWT Proforma Entry Flag (System)
L_COMMENTS text 2147483647 √ null

Comments
BRAIN_RADIOSURGERY_INDICATOR varchar 2 √ null
PRE_TREAT_PSA real 4 √ null
ROOT_START_DATE_COMMENTS text 2147483647 √ null
ROOT_END_DATE_COMMENTS text 2147483647 √ null
ACTION_ID int 4 √ null
DISCHARGE_SIX_DAYS bit 1 √ null
DATE_LAST_FRACTION date 20 √ null
PLANNED_START_DATE date 20 √ null
DISCHARGE_DATE smalldatetime 16 √ null
DISCHARGE_DELAY_REASON int 4 √ null
DISCHARGE_DESTINATION char 2 √ null
PLANNED_REASON int 4 √ null
DELAY_REASON int 4 √ null
TECHNIQUE int 4 √ null
ToxicitySymptom int 4 √ null
ROOT_DECISION_DATE_COMMENTS text 2147483647 √ null
AdjunctiveTherapyID int 4 √ null
ltblAdjunctiveTherapy.AdjunctiveTherapyID FK_tblMAIN_TELETHERAPY_ltblAdjunctiveTherapyR
OtherTreatmentIntent varchar 255 √ null
HCCEmbolisation int 4 √ null
HCCEmbolisationModality int 4 √ null
TreatmentCompletedAsPlanned int 4 √ null
ltblTreatmentCompletedAsPlanned.ID FK_tblMAIN_TELETHERAPY_ltblTreatmentCompletedAsPlannedR
NotCompleteReasonID int 4 √ null
ltblTeletherapyNotCompleteReason.ID FK_tblMAIN_TELETHERAPY_ltblTeletherapyNotCompleteReasonR
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_TELETHERAPY Primary key Asc TELE_ID
IX_tblMAIN_TELETHERAPY_CARE_ID Performance Asc CARE_ID
UQ_tblMAIN_TELETHERAPY_CareID_TertiaryReferralKey Must be unique Asc/Asc CARE_ID + TertiaryReferralKey

Relationships

Close relationships within degrees of separation