vwBRAIN_ASSESSMENT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 √ null
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 bit 1 √ null
N_L10_DEMENTIA bit 1 √ null
N_L11_RENAL bit 1 √ null
N_L12_OTHER bit 1 √ null
N_L13_SEVERE bit 1 √ null
L_CM_CARDIAC bit 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 bit 1 √ null
R_SPECIFY_OTHER_CA varchar 255 √ null
R_DISEASE_HISTORY varchar 2147483647 √ null
R_CARDIAC_RISK int 4 √ null
R_PERFORMANCE int 4 √ null
R_ADENOMA bit 1 √ null
R_COLITIS bit 1 √ null
R_CROHNS bit 1 √ null
R_POLYPOSIS bit 1 √ 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 bit 1 √ null
L_CHANGE_BOWELS bit 1 √ null
L_DIARRHOEA bit 1 √ null
L_CONSTIPATION bit 1 √ null
L_ALTERNATING bit 1 √ null
L_NOCTURNAL bit 1 √ null
L_BLOOD_STOOLS bit 1 √ null
L_FRESH bit 1 √ null
L_DARK bit 1 √ null
L_SEPARATE bit 1 √ null
L_MIXED bit 1 √ null
L_PAINFUL bit 1 √ null
L_PAINLESS bit 1 √ null
L_TENESMUS bit 1 √ null
L_IRON_DEFICIENCY bit 1 √ null
L_ASYMPTOMATIC bit 1 √ null
L_WEIGHT_LOSS bit 1 √ null
L_LOST_WEIGHT real 4 √ null
L_PALPABLE_MASS bit 1 √ null
L_ABDO_SURGERY bit 1 √ null
L_APPENDICECTOMY bit 1 √ null
L_CHOLECYSTECTOMY bit 1 √ null
L_GASTRODUODENAL bit 1 √ null
L_GYNAE_PELVIC bit 1 √ null
L_OTHER_PELVIC bit 1 √ null
L_ERECTILE_FUNCTION varchar 30 √ null
L_BLADDER_FUNCTION varchar 15 √ null
L_OTHER_BLADDER varchar 255 √ null
L_OTHER_LUNG bit 1 √ null
L_LUMP_NECK bit 1 √ null
L_LUMP_PARTOID bit 1 √ null
L_OTOLOGIA bit 1 √ null
L_SWELLING bit 1 √ null
L_VOICE int 4 √ null
L_LESION bit 1 √ null
L_THROAT bit 1 √ null
L_DYSPHAGIA int 4 √ null
L_MOUTH bit 1 √ null
L_PALSY bit 1 √ null
L_LYMPHODENOPATHY bit 1 √ null
L_DYSPHONIA bit 1 √ null
L_PHARYNX bit 1 √ 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 bit 1 √ 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 bit 1 √ null
L_CYSTIC_R bit 1 √ null
L_SOLID_L bit 1 √ null
L_SOLID_R bit 1 √ null
L_FIXED_SKIN_L bit 1 √ null
L_FIXED_SKIN_R bit 1 √ null
L_FIXED_MUS_L bit 1 √ null
L_FIXED_MUS_R bit 1 √ null
L_LUMP_L bit 1 √ null
L_LUMP_R bit 1 √ null
L_NODULARITY_L bit 1 √ null
L_NODULARITY_R bit 1 √ null
L_NIPPLE_CHANGE_L bit 1 √ null
L_NIPPLE_CHANGE_R bit 1 √ null
L_NIPPLE_DISCHARGE_L bit 1 √ null
L_NIPPLE_DISCHARGE_R bit 1 √ null
L_NIPPLE_DISTORTION_L bit 1 √ null
L_NIPPLE_DISTORTION_R bit 1 √ null
L_ABSCESS_L bit 1 √ null
L_ABSCESS_R bit 1 √ null
L_ORANGE_L bit 1 √ null
L_ORANGE_R bit 1 √ null
L_ULCERATION_L bit 1 √ null
L_ULCERATION_R bit 1 √ null
L_LYMPH_L bit 1 √ null
L_LYMPH_R bit 1 √ null
L_OTHER_L bit 1 √ null
L_OTHER_R bit 1 √ 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 bit 1 √ null
L_POSTPARTUM bit 1 √ 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 bit 1 √ null
L_EPIGASTRIC int 4 √ null
L_BLEEDING int 4 √ null
L_JAUNDICE bit 1 √ null
L_VOMITING bit 1 √ null
L_REFLUX int 4 √ null
L_OESOPHAGITIS int 4 √ null
L_BARRETTS int 4 √ null
L_OTHER_RISKS varchar 255 √ null
L_OESOPHAGUS bit 1 √ null
L_STOMACH bit 1 √ null
L_SMALL_BOWEL bit 1 √ null
L_COLON bit 1 √ null
L_RECTUM bit 1 √ null
L_PHYSICAL bit 1 √ null
L_ANAEMIC bit 1 √ null
L_MASS bit 1 √ null
L_NODES bit 1 √ null
L_HOARSE_VOICE bit 1 √ null
L_DISSEMINATED bit 1 √ 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 bit 1 √ null
L_TURP bit 1 √ null
L_DRE int 4 √ null
L_CM_ACUTE bit 1 √ null
L_CM_ALCOHOL bit 1 √ null
L_CM_ANAEMIA bit 1 √ null
L_CM_ANGINA bit 1 √ null
L_CM_ASPRIN bit 1 √ null
L_CM_BOWEL bit 1 √ null
CerebrovascularDisease bit 1 √ null
L_CM_CHRONIC bit 1 √ null
L_CM_CIRRHOSIS bit 1 √ null
L_CM_CLOTTING bit 1 √ null
L_CM_COAD bit 1 √ null
L_CM_CVA bit 1 √ null
L_CM_DIABETES1 bit 1 √ null
L_CM_DIABETES2 bit 1 √ null
L_CM_FAILURE bit 1 √ null
L_CM_HEART bit 1 √ null
L_CM_HYPERTENSION bit 1 √ null
L_CM_LIVER bit 1 √ null
L_CM_MENTAL bit 1 √ null
L_CM_NEURO bit 1 √ null
L_CM_OTHER bit 1 √ null
L_CM_PERIPHERAL bit 1 √ null
L_CM_RENAL bit 1 √ null
L_CM_RESPIRATORY bit 1 √ null
L_CM_SERUM bit 1 √ null
L_CM_STEROIDS bit 1 √ null
L_CM_VASCULAR bit 1 √ null
L_CM_WARFARIN bit 1 √ null
L_CM_DIP bit 1 √ null
L_CM_CLOP bit 1 √ null
L_CM_PACE bit 1 √ 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
L_ICP bit 1 null
L_VOMIT bit 1 null
L_CONFUSION bit 1 null
L_CONSCIOUS bit 1 null
L_VISUAL bit 1 null
L_SEIZURE bit 1 null
L_EXPRESS bit 1 null
L_RECEPT bit 1 null
L_MEMORY bit 1 null
L_BEHAVIOUR bit 1 null
L_MOTOR bit 1 null
L_DYSFUNCTION bit 1 null
L_LHEM bit 1 null
L_RHEM bit 1 null
L_SENSORY bit 1 null
L_NO_VOMIT bit 1 null
L_B_CONTROL bit 1 null
L_U_CONTROL bit 1 null
L_TIREDNESS bit 1 null
L_LETHARGY bit 1 null
L_FOCAL bit 1 null
L_VERTIGO bit 1 null
L_UNSTEADINESS bit 1 null
L_PAIN bit 1 null
L_ICP_DURATION int 4 √ null
L_VOMIT_DURATION int 4 √ null
L_CONFUSION_DURATION int 4 √ null
L_CONSCIOUS_DURATION int 4 √ null
L_VISUAL_DURATION int 4 √ null
L_SEIZURE_DURATION int 4 √ null
L_EXPRESS_DURATION int 4 √ null
L_RECEPT_DURATION int 4 √ null
L_MEMORY_DURATION int 4 √ null
L_BEHAVIOUR_DURATION int 4 √ null
L_MOTOR_DURATION int 4 √ null
L_DYSFUNCTION_DURATION int 4 √ null
L_LHEM_DURATION int 4 √ null
L_RHEM_DURATION int 4 √ null
L_SENSORY_DURATION int 4 √ null
L_NO_VOMIT_DURATION int 4 √ null
L_B_CONTROL_DURATION int 4 √ null
L_U_CONTROL_DURATION int 4 √ null
L_TIREDNESS_DURATION int 4 √ null
L_LETHARGY_DURATION int 4 √ null
L_FOCAL_DURATION int 4 √ null
L_VERTIGO_DURATION int 4 √ null
L_UNSTEADINESS_DURATION int 4 √ null
L_PAIN_DURATION int 4 √ null
L_MS bit 1 null
L_PARK bit 1 null
L_NEURONE bit 1 null
L_EPILEPSY bit 1 null
L_MIGRAINE bit 1 null
L_HEAD bit 1 null
L_TIA bit 1 null
L_CHICKENPOX bit 1 null
L_FUNDOSCOPY int 4 √ null
L_FUNDOSCOPY_DETAILS varchar 255 √ null
L_ACUITY int 4 √ null
L_ACUITY_DETAILS varchar 255 √ null
L_PUPILLARY int 4 √ null
L_PUPILLARY_DETAILS varchar 255 √ null
L_LLL_POWER int 4 √ null
L_LUL_POWER int 4 √ null
L_RLL_POWER int 4 √ null
L_RUL_POWER int 4 √ null
L_NEURO_ASS int 4 √ null
L_CRANIAL_EXAM int 4 √ null
L_N1_L int 4 √ null
L_N3_L int 4 √ null
L_N3_DETAILS_L varchar 255 √ null
L_N4_L int 4 √ null
L_N4_DETAILS_L varchar 255 √ null
L_N5_L int 4 √ null
L_N6_L int 4 √ null
L_N6_DETAILS_L varchar 255 √ null
L_N7_L int 4 √ null
L_N8_L int 4 √ null
L_N9_L int 4 √ null
L_N9_DETAILS_L varchar 255 √ null
L_N10_L int 4 √ null
L_N10_DETAILS_L varchar 255 √ null
L_N11_L int 4 √ null
L_N11_DETAILS_L varchar 255 √ null
L_N12_L int 4 √ null
L_N12_DETAILS_L varchar 255 √ null
L_CORNEAL_L int 4 √ null
L_MASSETER_L int 4 √ null
L_SENSATION_L varchar 255 √ null
L_FACIAL_L int 4 √ null
L_HOUSE_L int 4 √ null
L_HEARING_L int 4 √ null
L_VESTIBULAR_L varchar 255 √ null
L_GAG_L int 4 √ null
L_PHARYNGEAL_L int 4 √ null
L_N1_R int 4 √ null
L_N3_R int 4 √ null
L_N3_DETAILS_R varchar 255 √ null
L_N4_R int 4 √ null
L_N4_DETAILS_R varchar 255 √ null
L_N5_R int 4 √ null
L_N6_R int 4 √ null
L_N6_DETAILS_R varchar 255 √ null
L_N7_R int 4 √ null
L_N8_R int 4 √ null
L_N9_R int 4 √ null
L_N9_DETAILS_R varchar 255 √ null
L_N10_R int 4 √ null
L_N10_DETAILS_R varchar 255 √ null
L_N11_R int 4 √ null
L_N11_DETAILS_R varchar 255 √ null
L_N12_R int 4 √ null
L_N12_DETAILS_R varchar 255 √ null
L_CORNEAL_R int 4 √ null
L_MASSETER_R int 4 √ null
L_SENSATION_R varchar 255 √ null
L_FACIAL_R int 4 √ null
L_HOUSE_R int 4 √ null
L_HEARING_R int 4 √ null
L_VESTIBULAR_R varchar 255 √ null
L_GAG_R int 4 √ null
L_PHARYNGEAL_R int 4 √ null
L_ANAEMIA bit 1 null
L_OEDEMA bit 1 null
L_HR int 4 √ null
L_SYSTOLIC_BP real 4 √ null
L_DIASTOLIC_BP real 4 √ null
L_BRUITS bit 1 null
L_JVP bit 1 null
L_HEART_SOUNDS bit 1 null
L_PULSES bit 1 null
L_BREATH_SOUNDS bit 1 null
L_DYSPNOEA bit 1 null
L_ABDO bit 1 null
L_RECTAL bit 1 null
L_DRUGS int 4 √ null
L_STATINS int 4 √ null
L_PLATELETS int 4 √ null
L_DEPRESSANTS int 4 √ null
L_BETA_BLOCKERS int 4 √ null
L_DIURETICS int 4 √ null
L_COAGULANTS int 4 √ null
L_INHIBITORS int 4 √ null
L_CALCIUM_BLOCKERS int 4 √ null
L_ANTIOTENSINS int 4 √ null
L_ANTICONVULSANTS int 4 √ null
L_OTHER_DRUGS int 4 √ null
L_ANAESTHETIC varchar 255 √ null
L_GENERAL_EXAM text 2147483647 √ null
L_PLAN text 2147483647 √ null

View Definition

Possibly Referenced Tables/Views