bktblINITIAL_ASSESSMENT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ASSESS_ID int 4 null
CARE_ID int 4 null
TEMP_ID varchar 255 null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
N_B4_MENSTRUAL_STATUS int 4 √ null
N_B5_LMP_DATE smalldatetime 16 √ null
N_HN1_CANCER_HISTORY varchar 50 √ null
N_HN2_CANCER_YEAR int 4 √ null
N_HN3_PREVIOUS_TREATMENT varchar 10 √ null
N_HN4_TOBACCO varchar 50 √ null
N_HN5_SMOKER varchar 2 √ null
N_HN6_CHEWING_TOBACCO int 4 √ null
N_HN7_YEAR_STOPPED int 4 √ null
N_HN8_PACK_YEARS int 4 √ null
N_HN9_ALCOHOL int 4 √ null
N_HN11_SYMPTOM_DATE smalldatetime 16 √ null
N_SK13_DETERMINED varchar 1 √ null
N_L4_COPD varchar 1 √ null
N_L10_DEMENTIA varchar 1 √ null
N_L11_RENAL varchar 1 √ null
N_L12_OTHER varchar 1 √ null
N_L13_SEVERE varchar 1 √ null
N_L9_CARDIOVASCULAR varchar 1 √ null
N_H7_PREDISPOSING varchar 2 √ null
N_H12_SPLEEN real 4 √ null
N_H13_HEPATOMEGALY real 4 √ null
N_H14_LYMPHODENOPATHY varchar 2 √ null
N_H15_SKIN int 4 √ null
N_H16_TESTICULAR int 4 √ null
N_H17_NEUROLOGICAL int 4 √ null
N_H19_PRURITIS int 4 √ null
L_HOSPITAL varchar 5 √ null
L_ASSESS_DATE smalldatetime 16 √ null
L_AS_BY int 4 √ null
L_HEIGHT real 4 √ null
L_WEIGHT real 4 √ null
L_SOCIAL int 4 √ null
L_SMOKING_AMOUNT int 4 √ null
L_ALCOHOL_AMOUNT int 4 √ null
L_SMOKING_CESSATION char 3 √ null
R_SPECIFY_OTHER_CA varchar 255 √ null
R_DISEASE_HISTORY varchar 255 √ null
R_CARDIAC_RISK int 4 √ null
R_PERFORMANCE int 4 √ null
R_ADENOMA int 4 √ null
R_COLITIS int 4 √ null
R_CROHNS int 4 √ null
R_POLYPOSIS int 4 √ null
R_FINDINGS varchar 2 √ null
L_FINDINGS varchar 2 √ null
L_CHILDREN int 4 √ null
L_ON_HRT varchar 50 √ null
L_HRT varchar 255 √ null
L_COPD_DETAILS varchar 255 √ null
L_ABDO_PAIN int 4 √ null
L_CHANGE_BOWELS int 4 √ null
L_DIARRHOEA int 4 √ null
L_CONSTIPATION int 4 √ null
L_ALTERNATING int 4 √ null
L_NOCTURNAL int 4 √ null
L_BLOOD_STOOLS int 4 √ null
L_FRESH int 4 √ null
L_DARK int 4 √ null
L_SEPARATE int 4 √ null
L_MIXED int 4 √ null
L_PAINFUL int 4 √ null
L_PAINLESS int 4 √ null
L_TENESMUS int 4 √ null
L_IRON_DEFICIENCY int 4 √ null
L_ASYMPTOMATIC int 4 √ null
L_WEIGHT_LOSS int 4 √ null
L_LOST_WEIGHT real 4 √ null
L_PALPABLE_MASS int 4 √ null
L_ABDO_SURGERY int 4 √ null
L_APPENDICECTOMY int 4 √ null
L_CHOLECYSTECTOMY int 4 √ null
L_GASTRODUODENAL int 4 √ null
L_GYNAE_PELVIC int 4 √ null
L_OTHER_PELVIC int 4 √ null
L_ERECTILE_FUNCTION varchar 30 √ null
L_BLADDER_FUNCTION varchar 15 √ null
L_OTHER_BLADDER varchar 255 √ null
L_OTHER_LUNG int 4 √ null
L_LUMP_NECK int 4 √ null
L_LUMP_PARTOID int 4 √ null
L_OTOLOGIA int 4 √ null
L_SWELLING int 4 √ null
L_VOICE int 4 √ null
L_LESION int 4 √ null
L_THROAT int 4 √ null
L_DYSPHAGIA int 4 √ null
L_MOUTH int 4 √ null
L_PALSY int 4 √ null
L_LYMPHODENOPATHY int 4 √ null
L_DYSPHONIA int 4 √ null
L_PHARYNX int 4 √ null
L_COMPLAINT_A int 4 √ null
L_COMPLAINT_B int 4 √ null
L_SAME_SKIN varchar 5 √ null
L_OTHER_SKIN varchar 5 √ null
L_TRANSPLANT varchar 3 √ null
L_IMMUNO_DISORDER varchar 3 √ null
L_PHOTOTHERAPY varchar 20 √ null
L_RADIOTHERAPY varchar 3 √ null
L_UN_LMP int 4 √ null
L_CYCLE int 4 √ null
L_AGE_MEN int 4 √ null
L_AGE_MENO int 4 √ null
L_MEDICAL_MEN int 4 √ null
L_CHILDREN_YN int 4 √ null
L_AGE_FIRST int 4 √ null
L_BREAST_FED int 4 √ null
L_FED_MONTHS int 4 √ null
L_OCP varchar 50 √ null
L_OCP_PRE int 4 √ null
L_OCP_TOTAL int 4 √ null
L_OCP_COMMENTS varchar 255 √ null
L_COIL varchar 10 √ null
L_STERILISED int 4 √ null
L_HYSTERECTOMY int 4 √ null
L_HYST_AGE int 4 √ null
L_HYST_TYPE int 4 √ null
L_OVARIES int 4 √ null
L_MASS_L int 4 √ null
L_MASS_R int 4 √ null
L_CLOCK_L int 4 √ null
L_CLOCK_R int 4 √ null
L_DIS_L real 4 √ null
L_DIS_R real 4 √ null
L_SIZE_L real 4 √ null
L_SIZE_R real 4 √ null
L_CYSTIC_L int 4 √ null
L_CYSTIC_R int 4 √ null
L_SOLID_L int 4 √ null
L_SOLID_R int 4 √ null
L_FIXED_SKIN_L int 4 √ null
L_FIXED_SKIN_R int 4 √ null
L_FIXED_MUS_L int 4 √ null
L_FIXED_MUS_R int 4 √ null
L_LUMP_L int 4 √ null
L_LUMP_R int 4 √ null
L_NODULARITY_L int 4 √ null
L_NODULARITY_R int 4 √ null
L_NIPPLE_CHANGE_L int 4 √ null
L_NIPPLE_CHANGE_R int 4 √ null
L_NIPPLE_DISCHARGE_L int 4 √ null
L_NIPPLE_DISCHARGE_R int 4 √ null
L_NIPPLE_DISTORTION_L int 4 √ null
L_NIPPLE_DISTORTION_R int 4 √ null
L_ABSCESS_L int 4 √ null
L_ABSCESS_R int 4 √ null
L_ORANGE_L int 4 √ null
L_ORANGE_R int 4 √ null
L_ULCERATION_L int 4 √ null
L_ULCERATION_R int 4 √ null
L_LYMPH_L int 4 √ null
L_LYMPH_R int 4 √ null
L_OTHER_L int 4 √ null
L_OTHER_R int 4 √ null
L_AUX_L int 4 √ null
L_AUX_R int 4 √ null
L_MAMMOGRAM int 4 √ null
L_MAM_INFO varchar 255 √ null
L_PREGNANT int 4 √ null
L_POSTPARTUM int 4 √ null
L_FEEDING int 4 √ null
L_DUE_DATE smalldatetime 16 √ null
L_DELIVERY_DATE smalldatetime 16 √ null
L_TRIMESTER int 4 √ null
L_LACTATING int 4 √ null
L_CO_M int 4 √ null
L_ODYNOPHAGIA int 4 √ null
L_EPIGASTRIC int 4 √ null
L_BLEEDING int 4 √ null
L_JAUNDICE int 4 √ null
L_VOMITING int 4 √ null
L_REFLUX int 4 √ null
L_OESOPHAGITIS int 4 √ null
L_BARRETTS int 4 √ null
L_OTHER_RISKS varchar 255 √ null
L_OESOPHAGUS int 4 √ null
L_STOMACH int 4 √ null
L_SMALL_BOWEL int 4 √ null
L_COLON int 4 √ null
L_RECTUM int 4 √ null
L_PHYSICAL int 4 √ null
L_ANAEMIC int 4 √ null
L_MASS int 4 √ null
L_NODES int 4 √ null
L_HOARSE_VOICE int 4 √ null
L_DISSEMINATED int 4 √ null
L_LYMPH_SIZE real 4 √ null
L_FAMILY varchar 255 √ null
L_PARITY varchar 255 √ null
L_CESAREAN varchar 2 √ null
L_SMEAR int 4 √ null
L_SMEAR_DATE smalldatetime 16 √ null
L_SMEAR_RESULT varchar 10 √ null
L_SMEAR_DETAILS varchar 255 √ null
L_INFERTILITY int 4 √ null
L_INFERTILITY_TX varchar 255 √ null
L_PELVIC_EXAM int 4 √ null
L_EXAM_VULVA varchar 255 √ null
L_EXAM_CERVIX varchar 255 √ null
L_EXAM_UTERUS varchar 255 √ null
L_EXAM_ADNEXA varchar 255 √ null
L_EXAM_RECTUM varchar 255 √ null
L_COMORBIDITY_INDEX int 4 √ null
L_MOLE int 4 √ null
L_MOLE_DETAILS varchar 255 √ null
L_LUTS int 4 √ null
L_TURP int 4 √ null
L_DRE int 4 √ null
L_CM_ACUTE int 4 √ null
L_CM_ALCOHOL int 4 √ null
L_CM_ANAEMIA int 4 √ null
L_CM_ANGINA int 4 √ null
L_CM_ASPRIN int 4 √ null
L_CM_BOWEL int 4 √ null
L_CM_CARDIAC int 4 √ null
L_CM_CEREBAL int 4 √ null
L_CM_CHRONIC int 4 √ null
L_CM_CIRRHOSIS int 4 √ null
L_CM_CLOTTING int 4 √ null
L_CM_COAD int 4 √ null
L_CM_CVA int 4 √ null
L_CM_DIABETES1 int 4 √ null
L_CM_DIABETES2 int 4 √ null
L_CM_FAILURE int 4 √ null
L_CM_HEART int 4 √ null
L_CM_HYPERTENSION int 4 √ null
L_CM_LIVER int 4 √ null
L_CM_MENTAL int 4 √ null
L_CM_MI int 4 √ null
L_CM_NEURO int 4 √ null
L_CM_OTHER int 4 √ null
L_CM_PERIPHERAL int 4 √ null
L_CM_RENAL int 4 √ null
L_CM_RESPIRATORY int 4 √ null
L_CM_SERUM int 4 √ null
L_CM_STEROIDS int 4 √ null
L_CM_VASCULAR int 4 √ null
L_CM_WARFARIN int 4 √ null
L_CM_DIP int 4 √ null
L_CM_CLOP int 4 √ null
L_CM_PACE int 4 √ null
L_CM_BARRETTS_OES bit 1 √ null
L_OTHER_MORBIDITIES varchar 255 √ null
L_FAMILY_TAKEN int 4 √ null
L_PRE_TREAT_DENTAL int 4 √ null
L_PRE_TREAT_DENTAL_DATE smalldatetime 16 √ null
L_PRE_TREAT_NUTRITION int 4 √ null
L_PRE_TREAT_NUTRITION_DATE smalldatetime 16 √ null
L_COMMENTS text 2147483647 √ null
L_OTHER_INFO text 2147483647 √ null
L_OTHER_PMH text 2147483647 √ null
L_MEDICATION text 2147483647 √ null
L_ALLERGIES text 2147483647 √ null
N_HN11_SYMPTOM_DAY varchar 2 √ null
N_HN11_SYMPTOM_MONTH varchar 2 √ null
N_HN11_SYMPTOM_YEAR varchar 4 √ null
OTHER_DIAGNOSIS_SUB_COMMENT varchar 50 √ null
FAMILIAL_CANCER_SYNDROME_ID int 4 √ null
FAMILIAL_CANCER_SYNDROME_SUB_COMMENT varchar 50 √ null
ASSESS_SITE_CODE varchar 5 √ null
SKIN_CLINICAL_DIAGNOSIS int 4 √ null
CTYA_SECONDARY_DIAGNOSIS_1 varchar 6 √ null
CTYA_SECONDARY_DIAGNOSIS_2 varchar 6 √ null
CTYA_SECONDARY_DIAGNOSIS_3 varchar 6 √ null
CTYA_SECONDARY_DIAGNOSIS_4 varchar 6 √ null
RECTAL_BLEEDING bit 1 √ null
PROST_COMP_SYMP_METS bit 1 √ null
PROST_COMP_GENERAL bit 1 √ null
PROST_COMP_NOT_KNOWN bit 1 √ null
PROST_COMP_NONE bit 1 √ null
ACTION_ID int 4 √ null
UroRaisedPSA bit 1 √ null
UroHaematuria bit 1 √ null
HospPreviousTreatment int 4 √ null
PrevTreatmentDay int 4 √ null
PrevTreatmentMonth int 4 √ null
PrevTreatmentYear int 4 √ null
ActualSiteOfSymptoms int 4 √ null
ActualSymptoms int 4 √ null
SitePreviousCancer int 4 √ null
CopyStartedAt datetime2 54 √ null

Relationships

Close relationships within degrees of separation