tblINITIAL_ASSESSMENT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
GermlineTesting.CareID FK_GermlineTesting_tblINITIAL_ASSESSMENTR
SomaticTesting.CareID FK_SomaticTesting_tblINITIAL_ASSESSMENTR
tblFAMILY_HISTORY.CARE_ID FK_tblFAMILY_HISTORY_tblINITIAL_ASSESSMENTC
tblINITIAL_BRAIN.CARE_ID FK_tblINITIAL_BRAIN_tblINITIAL_ASSESSMENTR
tblINITIAL_PAEDIATRICS.CARE_ID FK_tblINITIAL_PAEDIATRICS_tblINITIAL_ASSESSMENTR
tblPresentationHeadNeckActualSiteOfSymptoms.CareID FK_tblPresentationHeadNeckActualSiteOfSymptoms_tblINITIAL_ASSESSMENTR
tblPresentationHeadNeckActualSymptoms.CareID FK_tblPresentationHeadNeckActualSymptoms_tblINITIAL_ASSESSMENTR
tblPresentationHeadNeckSiteOfPreviousCancer.CareID FK_tblPresentationHeadNeckSiteOfPreviousCancer_tblINITIAL_ASSESSMENTR
tblPresentationHeadNeckSiteOfPreviousCancerICD10.CareID FK_tblPresentationHeadNeckSiteOfPreviousCancerICD10_tblINITIAL_ASSESSMENTC
tblMAIN_REFERRALS.CARE_ID FK_tblINITIAL_ASSESSMENT_tblMAIN_REFERRALSC

Referral Record ID
N_B4_MENSTRUAL_STATUS int 4 √ null

Menstrual Status (Breast/Gynaecology only)
N_B5_LMP_DATE smalldatetime 16 √ null

LMP Date (Breast/Gynaecology only)
N_HN1_CANCER_HISTORY varchar 50 √ null

Previous Malignancy
N_HN2_CANCER_YEAR int 4 √ null

Year Diagnosed
N_HN3_PREVIOUS_TREATMENT varchar 10 √ null

Treated elsewhere for current tumour
N_HN4_TOBACCO varchar 50 √ null

Type of Tobacco
N_HN5_SMOKER varchar 2 √ null

History of Smoking
N_HN6_CHEWING_TOBACCO int 4 √ null

Chewing Tobacco - not used
N_HN7_YEAR_STOPPED int 4 √ null

Year Stopped Smoking
N_HN8_PACK_YEARS int 4 √ null

Estimated Pack Years
N_HN9_ALCOHOL int 4 √ null

History of Alcohol
N_HN11_SYMPTOM_DATE smalldatetime 16 √ null

Date Symptoms First Noted (Head and Neck only)
N_SK13_DETERMINED varchar 1 √ null

Genetically Determined Skin Cancer Syndrome (Skin only)
N_L4_COPD bit 1 ((0))

COPD (Lung only)
N_L10_DEMENTIA bit 1 ((0))

Dementia/Cerebrovascular Disease (Lung only)
N_L11_RENAL bit 1 ((0))

Renal Failure (Lung only)
N_L12_OTHER bit 1 ((0))

Other Malignancy (Lung only)
N_L13_SEVERE bit 1 ((0))

Severe Weight Loss (Lung only)
DEPRECATED_21_02_N_L9_CARDIOVASCULAR bit 1 ((0))

Cardiovascular Disease (Lung only)
N_H7_PREDISPOSING varchar 2 √ null

Predisposing Condition (Haematology only)
N_H12_SPLEEN real 4 √ null

Splenomegaly (Haematology only)
N_H13_HEPATOMEGALY real 4 √ null

Hepatomegaly (Haematology only)
N_H14_LYMPHODENOPATHY varchar 2 √ null

Lymphodenopathy Site (Haematology only)
N_H15_SKIN int 4 √ null

Skin Involvement (Haematology only)
N_H16_TESTICULAR int 4 √ null

Testicular Involvement (Haematology only)
N_H17_NEUROLOGICAL int 4 √ null

Neurological Involvement (Haematology only)
N_H19_PRURITIS int 4 √ null

Pruritis (Haematology only)
L_HOSPITAL varchar 5 √ null

Organisation (Brain only)
L_ASSESS_DATE smalldatetime 16 √ null

Date of Assessment
L_AS_BY int 4 √ null

Assessment By
L_HEIGHT real 4 √ null

Height
L_WEIGHT real 4 √ null

Weight
L_SOCIAL int 4 √ null

Do you wish to enter Social History
L_SMOKING_AMOUNT int 4 √ null

Smoking Amount (Brain/Gynaecology/Upper GI only)
L_ALCOHOL_AMOUNT int 4 √ null

Alcohol Amount (Brain/Upper GI only)
L_SMOKING_CESSATION bit 1 ((0))

Smoking Cessation Info Given (Head & Neck/Lung only)
R_SPECIFY_OTHER_CA varchar 255 √ null

Malignancy Details (Brain/Haematology/Head & Neck/Upper GI only)
R_DISEASE_HISTORY varchar 2147483647 √ null

Cardiac Disease History (Upper GI only)
R_CARDIAC_RISK int 4 √ null

Cardiac Risk Index (Upper GI only)
R_PERFORMANCE int 4 √ null

Performance Status
R_ADENOMA bit 1 ((0))

Colorectal Adenoma (Colorectal only)
R_COLITIS bit 1 ((0))

Ulcerative Colitis (Colorectal only)
R_CROHNS bit 1 ((0))

Crohns (Colorectal only)
R_POLYPOSIS bit 1 ((0))

Famillial Adenomatous Polyposis (Colorectal only)
R_FINDINGS varchar 2 √ null

Examination Findings (Breast only)
L_FINDINGS varchar 2 √ null

Examination Findings (Breast only)
L_CHILDREN int 4 √ null

No. of Children (Breat only)
L_ON_HRT varchar 50 √ null

HRT (Breast/Gynaecology only)
L_HRT varchar 255 √ null

HRT - Length of Usage (Breast/Gynaecology only)
L_COPD_DETAILS varchar 255 √ null

COPD Details (Lung only)
L_ABDO_PAIN bit 1 ((0))

Abdominal Pain (Colorectal/Gynaecology/Upper GI only)
L_CHANGE_BOWELS bit 1 ((0))

Change in Bowels (Colorectal/Gynaecology only)
L_DIARRHOEA bit 1 ((0))

Diarrhoea (Colorectal/Gynaecology only)
L_CONSTIPATION bit 1 ((0))

Constipation (Colorectal/Gynaecology only)
L_ALTERNATING bit 1 ((0))

Alternating Diarrhoea/Constipation (Colorectal/Gynaecology only)
L_NOCTURNAL bit 1 ((0))

Nocturnal Bowel Action (Colorectal/Gynaecology only)
L_BLOOD_STOOLS bit 1 ((0))

Blood in Stools (Colorectal/Gynaecology only)
L_FRESH bit 1 ((0))

Fresh (Colorectal only)
L_DARK bit 1 ((0))

Dark (Colorectal only)
L_SEPARATE bit 1 ((0))

Separate (Colorectal only)
L_MIXED bit 1 ((0))

Mixed (Colorectal only)
L_PAINFUL bit 1 ((0))

Painful (Colorectal only)
L_PAINLESS bit 1 ((0))

Painless (Colorectal only)
L_TENESMUS bit 1 ((0))

Tenesmus (Colorectal/Gynaecology only)
L_IRON_DEFICIENCY bit 1 ((0))

Iron Deficiency (Colorectal/Gynaecology/Upper GI only)
L_ASYMPTOMATIC bit 1 ((0))

Asymptomatic Screening (Colorectal only)
L_WEIGHT_LOSS bit 1 ((0))

Weight Loss (Colorectal/Gynaecology/Upper GI only)
L_LOST_WEIGHT real 4 √ null

Weight Loss (Colorectal/Gynaecology/Upper GI only)
L_PALPABLE_MASS bit 1 ((0))

Palpable Mass (Colorectal/Gynaecology only)
L_ABDO_SURGERY bit 1 ((0))

Previous Abdominal Surgery (Colorectal/Upper GI only)
L_APPENDICECTOMY bit 1 ((0))

Appendectomy (Colorectal only)
L_CHOLECYSTECTOMY bit 1 ((0))

Cholecystectomy (Colorectal only)
L_GASTRODUODENAL bit 1 ((0))

Gastroduodenal (Colorectal only)
L_GYNAE_PELVIC bit 1 ((0))

Gynae Pelvic (Colorectal only)
L_OTHER_PELVIC bit 1 ((0))

Other Pelvic (Colorectal only)
L_ERECTILE_FUNCTION varchar 30 √ null

Sexual Function (Colorectal/Gynaecology only)
L_BLADDER_FUNCTION varchar 15 √ null

Bladder Function (Colorectal/Gynaecology only)
L_OTHER_BLADDER varchar 255 √ null

Other Bladder Function (Colorectal only)
L_OTHER_LUNG bit 1 ((0))

Other Lung Disease (Lung only)
L_LUMP_NECK bit 1 ((0))

Lump - Neck (Head & Neck only)
L_LUMP_PARTOID bit 1 ((0))

Lump - Partoid (Head & Neck only)
L_OTOLOGIA bit 1 ((0))

Otologia (Head & Neck only)
L_SWELLING bit 1 ((0))

Lump - Mouth (Head & Neck only)
L_VOICE int 4 √ null

Voice (not used)
L_LESION bit 1 ((0))

Lesion - Cheek (Head & Neck only)
L_THROAT bit 1 ((0))

Sore Throat (Head & Neck only)
L_DYSPHAGIA int 4 √ null

Dysphagia (Head & Neck only)
L_MOUTH bit 1 ((0))

Lesion - Oral Cavity (Head & Neck only)
L_PALSY bit 1 ((0))

Vocal Cord Palsy (Head & Neck only)
L_LYMPHODENOPATHY bit 1 ((0))

Lymphodenopathy (Head & Neck only)
L_DYSPHONIA bit 1 ((0))

Dysphonia (Head & Neck only)
L_PHARYNX bit 1 ((0))

Lesion - Oral Pharynx (Head & Neck only)
L_COMPLAINT_A int 4 √ null

Presenting Complaints (Skin only)
L_COMPLAINT_B int 4 √ null

Presenting Complaints (Skin only)
L_SAME_SKIN varchar 5 √ null

Previous Skin Malignancy - same site (Skin only)
L_OTHER_SKIN varchar 5 √ null

Previous Skin Malignancy - other site (Skin only)
L_TRANSPLANT varchar 3 √ null

Transplant Patient (Skin only)
L_IMMUNO_DISORDER varchar 3 √ null

Immunosuppressive Disorder (Skin only)
L_PHOTOTHERAPY varchar 20 √ null

Phototherapy - same site (Skin only)
L_RADIOTHERAPY varchar 3 √ null

Radiotherapy - same site (Skin only)
L_UN_LMP bit 1 ((0))

Unknown LMP (Breast & Gynaecology only)
L_CYCLE int 4 √ null

Cycle Length (Breast & Gynaecology only)
L_AGE_MEN int 4 √ null

Age at Menarch (Breast & Gynaecology only)
L_AGE_MENO int 4 √ null

Age at Menopause (Breast & Gynaecology only)
L_MEDICAL_MEN int 4 √ null

Medical Menopause (Breast & Gynaecology only)
L_CHILDREN_YN int 4 √ null

Children (Breast only)
L_AGE_FIRST int 4 √ null

Age at First Delivery (Breast only)
L_BREAST_FED int 4 √ null

Breast Fed First Child (Breast only)
L_FED_MONTHS int 4 √ null

Length of Time Breast Fed (Breast only)
L_OCP varchar 50 √ null

Oral Contractive Pill (Breast & Gynaecology only)
L_OCP_PRE int 4 √ null

OCP Length of Time Pre-First Child (Breast only)
L_OCP_TOTAL int 4 √ null

OCP Total Length of Time (Breast only)
L_OCP_COMMENTS varchar 255 √ null

OCP Details (Breast only)
L_COIL varchar 10 √ null

Coil (Gynaecology only)
L_STERILISED int 4 √ null

Sterilised (Gynaecology only)
L_HYSTERECTOMY int 4 √ null

Hysterectomy (Breast & Gynaecology only)
L_HYST_AGE int 4 √ null

Age at Hysterectomy (Breast & Gynaecology only)
L_HYST_TYPE int 4 √ null

Type of Hysterectomy (Gynaecology only)
L_OVARIES int 4 √ null

Ovaries Conserved (Breast & Gynaecology only)
L_MASS_L int 4 √ null

Mass - Left (Breast only)
L_MASS_R int 4 √ null

Mass - Right (Breast only)
L_CLOCK_L int 4 √ null

Position - Left (Breast only)
L_CLOCK_R int 4 √ null

Position - Right (Breast only)
L_DIS_L real 4 √ null

Distance from Nipple - Left (Breast only)
L_DIS_R real 4 √ null

Distance from Nipple - Right (Breast only)
L_SIZE_L real 4 √ null

Size of Mass - Left (Breast only)
L_SIZE_R real 4 √ null

Size of Mass - Right (Breast only)
L_CYSTIC_L bit 1 ((0))

Cystic - Left (Breast only)
L_CYSTIC_R bit 1 ((0))

Cystic - Right (Breast only)
L_SOLID_L bit 1 ((0))

Solid - Left (Breast only)
L_SOLID_R bit 1 ((0))

Solid - Right (Breast only)
L_FIXED_SKIN_L bit 1 ((0))

Fixed to Skin - Left (Breast only)
L_FIXED_SKIN_R bit 1 ((0))

Fixed to Skin - Right (Breast only)
L_FIXED_MUS_L bit 1 ((0))

Fixed to Muscle - Left (Breast only)
L_FIXED_MUS_R bit 1 ((0))

Fixed to Muscle - Right (Breast only)
L_LUMP_L bit 1 ((0))

Discrete Lump - Left (Breast only)
L_LUMP_R bit 1 ((0))

Discrete Lump - Right (Breast only)
L_NODULARITY_L bit 1 ((0))

Nodularity - Left (Breast only)
L_NODULARITY_R bit 1 ((0))

Nodularity - Right (Breast only)
L_NIPPLE_CHANGE_L bit 1 ((0))

Nipple Change - Left (Breast only)
L_NIPPLE_CHANGE_R bit 1 ((0))

Nipple Change - Right (Breast only)
L_NIPPLE_DISCHARGE_L bit 1 ((0))

Nipple Discharge - Left (Breast only)
L_NIPPLE_DISCHARGE_R bit 1 ((0))

Nipple Discharge - Right (Breast only)
L_NIPPLE_DISTORTION_L bit 1 ((0))

Nipple Distortion - Left (Breast only)
L_NIPPLE_DISTORTION_R bit 1 ((0))

Nipple Distortion - Right (Breast only)
L_ABSCESS_L bit 1 ((0))

Abscess - Left (Breast only)
L_ABSCESS_R bit 1 ((0))

Abscess - Right (Breast only)
L_ORANGE_L bit 1 ((0))

Peau d’orange - Left (Breast only)
L_ORANGE_R bit 1 ((0))

Peau d’orange - Right (Breast only)
L_ULCERATION_L bit 1 ((0))

Ulceration - Left (Breast only)
L_ULCERATION_R bit 1 ((0))

Ulceration - Right (Breast only)
L_LYMPH_L bit 1 ((0))

Lymph Nodes - Left (Breast only)
L_LYMPH_R bit 1 ((0))

Lymph Nodes - Right (Breast only)
L_OTHER_L bit 1 ((0))

Other - Left (Breast only)
L_OTHER_R bit 1 ((0))

Other - Right (Breast only)
L_AUX_L int 4 √ null

Axillary Node Status - Left (Breast only)
L_AUX_R int 4 √ null

Axillary Node Status - Right (Breast only)
L_MAMMOGRAM int 4 √ null

Previous Mammogram (Breast only)
L_MAM_INFO varchar 255 √ null

Details (Breast only)
L_PREGNANT bit 1 √ ((0))

Pregnant (Brain, Breast & Gynaecology only)
L_POSTPARTUM bit 1 ((0))

Postpartum (Breast & Gynaecology only)
L_FEEDING int 4 √ null

Currently Breast Feeding (Breast only)
L_DUE_DATE smalldatetime 16 √ null

Expected Date of Delivery (Breast & Gynaecology only)
L_DELIVERY_DATE smalldatetime 16 √ null

Date of Delivery (Breast & Gynaecology only)
L_TRIMESTER int 4 √ null

Trimester (Brain only)
L_LACTATING int 4 √ null

Lactating (Brain only)
L_CO_M int 4 √ null

Is there significant co-morbidity (Lung only)
L_ODYNOPHAGIA bit 1 ((0))

Odynophagia (Upper GI only)
L_EPIGASTRIC int 4 √ null

Epigastric Pain (Upper GI only)
L_BLEEDING int 4 √ null

Bleeding (Upper GI only)
L_JAUNDICE bit 1 ((0))

Jaundice (Upper GI only)
L_VOMITING bit 1 ((0))

Vomiting (Upper GI only)
L_REFLUX int 4 √ null

Reflux (Upper GI only)
L_OESOPHAGITIS int 4 √ null

Oesophagitis (Upper GI only)
L_BARRETTS int 4 √ null

Barretts Length (Upper GI only)
L_OTHER_RISKS varchar 255 √ null

Other Risks (Upper GI only)
L_OESOPHAGUS bit 1 ((0))

Oesophagus (Upper GI only)
L_STOMACH bit 1 ((0))

Stomach (Upper GI only)
L_SMALL_BOWEL bit 1 ((0))

Small Bowel (Upper GI only)
L_COLON bit 1 ((0))

Colon (Upper GI only)
L_RECTUM bit 1 ((0))

Rectum (Upper GI only)
L_PHYSICAL bit 1 ((0))

Physical Exam (Upper GI only)
L_ANAEMIC bit 1 ((0))

Anaemic (Upper GI only)
L_MASS bit 1 ((0))

Mass (Upper GI only)
L_NODES bit 1 ((0))

Nodes (Upper GI only)
L_HOARSE_VOICE bit 1 ((0))

Hoarse Voice (Upper GI only)
L_DISSEMINATED bit 1 ((0))

Disseminated Disease (Upper GI only)
L_LYMPH_SIZE real 4 √ null

Lymphodenopathy Size (Haematology only)
L_FAMILY varchar 255 √ null

Relations (Haematology only)
L_PARITY varchar 255 √ null

Parity (Gynaecology only)
L_CESAREAN varchar 2 √ null

Cesarean Section (Gynaecology only)
L_SMEAR int 4 √ null

Previous Smear (Gynaecology only)
L_SMEAR_DATE smalldatetime 16 √ null

Date of Last Smear (Gynaecology only)
L_SMEAR_RESULT varchar 10 √ null

Result of Last Smear (Gynaecology only)
L_SMEAR_DETAILS varchar 255 √ null

Result Details (Gynaecology only)
L_INFERTILITY int 4 √ null

Infertility (Gynaecology only)
L_INFERTILITY_TX varchar 255 √ null

Infertility Treatment (Gynaecology only)
L_PELVIC_EXAM int 4 √ null

Pelvic Exam (Gynaecology only)
L_EXAM_VULVA varchar 255 √ null

Vulva (Gynaecology only)
L_EXAM_CERVIX varchar 255 √ null

Cervix (Gynaecology only)
L_EXAM_UTERUS varchar 255 √ null

Uterus (Gynaecology only)
L_EXAM_ADNEXA varchar 255 √ null

Adnexa (Gynaecology only)
L_EXAM_RECTUM varchar 255 √ null

Rectum (Gynaecology only)
L_COMORBIDITY_INDEX int 4 √ null

Co-morbidity Index (Brain & Skin only)
L_MOLE int 4 √ null

Pre-existing Mole (Skin only)
L_MOLE_DETAILS varchar 255 √ null

Mole Details (Skin only)
L_LUTS bit 1 ((0))

LUTS
L_TURP bit 1 ((0))

Previous TURP
L_DRE int 4 √ null

DRE
L_CM_ACUTE bit 1 ((0))

Acute Pancreatitis
L_CM_ALCOHOL bit 1 ((0))

Alcohol-Induced Pancreatitis
L_CM_ANAEMIA bit 1 ((0))

Anaemia
L_CM_ANGINA bit 1 ((0))

Angina
L_CM_ASPRIN bit 1 ((0))

On Asprin
L_CM_BOWEL bit 1 ((0))

Inflammatory Bowel Disease
L_CM_CARDIAC bit 1 ((0))

Cardiac Disease
DEPRECATED_21_02_L_CM_CEREBAL bit 1 ((0))

Cerebal Vascular Disease
L_CM_CHRONIC bit 1 ((0))

Chronic Pancreatitis
L_CM_CIRRHOSIS bit 1 ((0))

Cirrhosis/Liver Disease
L_CM_CLOTTING bit 1 ((0))

Blood Clotting Disorder
L_CM_COAD bit 1 ((0))

COAD
L_CM_CVA bit 1 ((0))

History of CVA
L_CM_DIABETES1 bit 1 ((0))

Type I Diabetes
L_CM_DIABETES2 bit 1 ((0))

Type II Diabetes
L_CM_FAILURE bit 1 ((0))

History of Cardiac Failure
L_CM_HEART bit 1 ((0))

Ischaemic Heart Disease
L_CM_HYPERTENSION bit 1 ((0))

Hypertension
L_CM_LIVER bit 1 ((0))

Liver Disease
L_CM_MENTAL bit 1 ((0))

Mental Illness
DEPRECATED_21_02_L_CM_MI bit 1 ((0))

Myocardial Infarction
L_CM_NEURO bit 1 ((0))

Neurological Disease
L_CM_OTHER bit 1 ((0))

Other
L_CM_PERIPHERAL bit 1 ((0))

Peripheral Vascular Disease
L_CM_RENAL bit 1 ((0))

Renal Disease
L_CM_RESPIRATORY bit 1 ((0))

Respiratory Disease
L_CM_SERUM bit 1 ((0))

Creatinine >170mmol/l
L_CM_STEROIDS bit 1 ((0))

On Systemic Steroids
L_CM_VASCULAR bit 1 ((0))

Other Vascular Disease
L_CM_WARFARIN bit 1 ((0))

On Warfarin
L_CM_DIP bit 1 ((0))

On Dipyridamole
L_CM_CLOP bit 1 ((0))

On Clopidogrel
L_CM_PACE bit 1 ((0))

Pacemaker
L_CM_BARRETTS_OES bit 1 ((0))

Barrett’s Oesophagus
L_OTHER_MORBIDITIES varchar 255 √ null

Other Co-morbidities
L_FAMILY_TAKEN int 4 √ null

Family History of Cancer
L_PRE_TREAT_DENTAL int 4 √ null

Pre Treatment Dental Assessment
L_PRE_TREAT_DENTAL_DATE smalldatetime 16 √ null

Date of Pre Treatment Dental Assessment
L_PRE_TREAT_NUTRITION int 4 √ null

Pre Treatment Nutrition Assessment
L_PRE_TREAT_NUTRITION_DATE smalldatetime 16 √ null

Date of Pre Treatment Nutrition Assessment
L_COMMENTS text 2147483647 √ null

History of Complaints/Comments
L_OTHER_INFO text 2147483647 √ null

Social History
L_OTHER_PMH text 2147483647 √ null

Past Medical History
L_MEDICATION text 2147483647 √ null

Medication
L_ALLERGIES text 2147483647 √ null

Allergies
N_HN11_SYMPTOM_DAY varchar 2 √ null

Date Symptoms First Noted (Day)
N_HN11_SYMPTOM_MONTH varchar 2 √ null

Date Symptoms First Noted (Month)
N_HN11_SYMPTOM_YEAR varchar 4 √ null

Date Symptoms First Noted (Year)
OTHER_DIAGNOSIS_SUB_COMMENT varchar 50 √ null

Other Significant Diagnosis Subsidiary Comment
FAMILIAL_CANCER_SYNDROME_ID int 4 √ null

Familial Cancer Syndrome
FAMILIAL_CANCER_SYNDROME_SUB_COMMENT varchar 50 √ null

Familial Cancer Syndrome Subsidiary Comment
ASSESS_SITE_CODE varchar 5 √ null

Organisation Site
SKIN_CLINICAL_DIAGNOSIS int 4 √ null

Clinical Diagnosis (Pre-Histological Result)
CTYA_SECONDARY_DIAGNOSIS_1 varchar 6 √ null

Secondary Diagnosis (ICD) (1st field)
CTYA_SECONDARY_DIAGNOSIS_2 varchar 6 √ null

Secondary Diagnosis (ICD) (2nd field)
CTYA_SECONDARY_DIAGNOSIS_3 varchar 6 √ null

Secondary Diagnosis (ICD) (3rd field)
CTYA_SECONDARY_DIAGNOSIS_4 varchar 6 √ null

Secondary Diagnosis (ICD) (4th field)
RECTAL_BLEEDING bit 1 ((0))

Rectal Bleeding
PROST_COMP_SYMP_METS bit 1 ((0))

Symptoms possibly linked to metastasis (e.g. pain)
PROST_COMP_GENERAL bit 1 ((0))

General symptoms (e.g. lethargy)
PROST_COMP_NOT_KNOWN bit 1 ((0))

Not Known
PROST_COMP_NONE bit 1 ((0))

None (no NPCA valid symptoms)
ACTION_ID int 4 √ null

Latest Audit ID for Referral Data
UroRaisedPSA bit 1 ((0))

Raised PSA
UroHaematuria bit 1 ((0))

Haematuria
HospPreviousTreatment int 4 √ null

Hospital of Previous Treatment
PrevTreatmentDay int 4 √ null

Date of Previous Cancer Treatment (Day)
PrevTreatmentMonth int 4 √ null

Date of Previous Cancer Treatment (Month)
PrevTreatmentYear int 4 √ null

Date of Previous Cancer Treatment (Year)
ActualSiteOfSymptoms int 4 √ null

Actual Site of Symptoms
ActualSymptoms int 4 √ null

Actual Symptoms
SitePreviousCancer int 4 √ null

Site of Previous Head & Neck Cancer
CoMobNone bit 1 ((0))
N_HN9_ALCOHOL_PAST int 4 √ null
FitnessAssessment int 4 √ null
ltblYN.YN_ID FK_tblINITIAL_ASSESSMENT_ltblYNR
FitnessAssessmentDate smalldatetime 16 √ null
ClinicalFrailtyScale int 4 √ null
ClinicalFrailtyScale.ID FK_tblINITIAL_ASSESSMENT_ClinicalFrailtyScaleR
AbbreviatedMentalTestScore int 4 √ null
CardiorespiratoryDisease int 4 √ null
ltblYN.YN_ID FK_tblINITIAL_ASSESSMENT_ltblYN1R
OtherNonBreastLocallyAdvancedMetastaticMalignancy int 4 √ null
ltblYN.YN_ID FK_tblINITIAL_ASSESSMENT_ltblYN2R
TobaccoAddiction int 4 √ null
TobaccoAddiction.ID FK_tblINITIAL_ASSESSMENT_TobaccoAddictionR
CurrentPhysicalActivity int 4 √ null
CurrentPhysicalActivity.ID FK_tblINITIAL_ASSESSMENT_CurrentPhysicalActivityR
OtherMorbidities bit 1 ((0))
CerebrovascularDisease bit 1 ((0))
Arthritis bit 1 ((0))
CognitiveImpairment bit 1 ((0))
Depression bit 1 ((0))
LongstandingPhysicalDisability bit 1 ((0))
Obesity bit 1 ((0))
PreviousCancer bit 1 ((0))
SevereLongstandingMentalIllness bit 1 ((0))
NotKnown bit 1 ((0))

Indexes

Constraint Name Type Sort Column(s)
PK_tblINITIAL_ASSESSMENT Primary key Asc CARE_ID
IX_INITIAL_ASSESSMENT__CARE_ID Performance Asc CARE_ID

Relationships

Close relationships within degrees of separation