vwFIRST_BRACHYTHERAPY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
BRACHY_ID int 4 null
CARE_ID int 4 null
TEMP_ID varchar 255 null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
N11_1_SITE_CODE varchar 5 null
N_SITE_CODE_DTT varchar 5 null
N11_2_CONSULTANT varchar 8 null
N11_3_DECISION_DATE smalldatetime 16 null
N11_6_TREATMENT_INTENT varchar 1 null
N11_7_TYPE varchar 2 null
N11_8_TREATMENT_SITE varchar 5 null
N11_9_START_DATE smalldatetime 16 null
N11_10_END_DATE smalldatetime 16 null
N11_11_DOSE real 4 null
N11_12_DURATION int 4 null
N11_13_FRACTIONS real 4 null
N11_14_ACTUAL_DOSE real 4 null
N11_15_DOSE_RATE varchar 1 null
N11_16_ACTUAL_DURATION int 4 null
L_TYPE_OF_DOSE int 4 null
N11_17_ISOTOPE_TYPE varchar 1 null
N11_18_ANAESTHETIC varchar 5 null
N11_19_UNSEALED varchar 1 null
N11_20_DELIVERY_TYPE varchar 1 null
N11_22_STATUS int 4 null
N_TREATMENT_EVENT varchar 2 null
N_TREATMENT_SETTING varchar 2 null
L_NAMED_COMP varchar 50 null
L_COMP_3MTH varchar 50 null
L_SHORT_LONG varchar 5 null
R_INSERTIONS int 4 null
R_DOSE_INSERTION real 4 null
R_TREAT_TO varchar 2 null
L_TRIAL int 4 null
ENDOSCOPIC bit 1 null
DEFINITIVE_TREATMENT int 4 null
CWT_PROFORMA int 4 null
L_COMMENTS text 2147483647 null
PRE_TREAT_PSA real 4 null

Relationships

View Definition