vwBRAIN_PRESENTATION


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
L_HOSPITAL varchar 5 √ null
HOSPITAL nvarchar 500 √ null
L_ASSESS_DATE smalldatetime 16 √ null
L_AS_BY int 4 √ null
AS_BY varchar 50 √ null
L_HEIGHT real 4 √ null
L_WEIGHT real 4 √ null
L_SOCIAL int 4 √ null
N_HN5_SMOKER varchar 2 √ null
SMOKER varchar 80 √ null
TobaccoAddiction varchar 50 √ null
N_HN9_ALCOHOL int 4 √ null
ALCOHOLCurrent varchar 100 √ null
N_HN9_ALCOHOL_PAST int 4 √ null
ALCOHOLPast varchar 100 √ null
L_SMOKING_AMOUNT int 4 √ null
SMOKING_AMOUNT varchar 50 √ null
L_ALCOHOL_AMOUNT int 4 √ null
ALCOHOL_AMOUNT varchar 50 √ null
N_HN1_CANCER_HISTORY varchar 50 √ null
CANCER_HISTORY varchar 100 √ null
N_HN2_CANCER_YEAR int 4 √ null
R_SPECIFY_OTHER_CA varchar 255 √ null
R_PERFORMANCE int 4 √ null
L_PREGNANT bit 1 √ null
L_TRIMESTER int 4 √ null
TRIMESTER varchar 50 √ null
L_LACTATING int 4 √ null
L_COMORBIDITY_INDEX int 4 √ null
COMORBIDITY_INDEX varchar 50 √ 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
L_CM_CARDIAC 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_OTHER_MORBIDITIES varchar 255 √ 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
CORNEAL_L varchar 50 √ null
L_MASSETER_L int 4 √ null
MASSETER_L varchar 50 √ null
L_SENSATION_L varchar 255 √ null
L_FACIAL_L int 4 √ null
FACIAL_L varchar 50 √ null
L_HOUSE_L int 4 √ null
HOUSE_L varchar 50 √ null
L_HEARING_L int 4 √ null
HEARING_L varchar 50 √ null
L_VESTIBULAR_L varchar 255 √ null
L_GAG_L int 4 √ null
GAG_L varchar 50 √ null
L_PHARYNGEAL_L int 4 √ null
PHARYNGEAL_L varchar 50 √ 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
CORNEAL_R varchar 50 √ null
L_MASSETER_R int 4 √ null
MASSETER_R varchar 50 √ null
L_SENSATION_R varchar 255 √ null
L_FACIAL_R int 4 √ null
FACIAL_R varchar 50 √ null
L_HOUSE_R int 4 √ null
HOUSE_R varchar 50 √ null
L_HEARING_R int 4 √ null
HEARING_R varchar 50 √ null
L_VESTIBULAR_R varchar 255 √ null
L_GAG_R int 4 √ null
GAG_R varchar 50 √ null
L_PHARYNGEAL_R int 4 √ null
PHARYNGEAL_R varchar 50 √ 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
DRUGS varchar 50 √ null
L_STATINS int 4 √ null
L_PLATELETS int 4 √ null
PLATELETS varchar 50 √ 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
ANTICONVULSANTS varchar 50 √ null
L_OTHER_DRUGS int 4 √ null
L_ANAESTHETIC varchar 255 √ null
L_GENERAL_EXAM text 2147483647 √ null
L_PLAN text 2147483647 √ null
L_COMMENTS text 2147483647 √ null
L_OTHER_INFO text 2147483647 √ null
L_OTHER_PMH 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

View Definition

Possibly Referenced Tables/Views