tblAO_ASSESSMENT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AssessmentID int identity 4 √ null
FollowupDetail.AssessmentID Implied ConstraintR
lnkAO_ASSESSED_BY_CNS.AssessmentID FK_lnkAO_ASSESSED_BY_CNS_tblAO_ASSESSMENTR
lnkAO_ASSESSED_BY_CONSULTANT.AssessmentID FK_lnkAO_ASSESSED_BY_CONSULTANT_tblAO_ASSESSMENTR
lnkAO_ASSESSMENT_RESULT.AssessmentID FK_lnkAO_ASSESSMENT_RESULT_tblAO_ASSESSMENTR
tmpHANAPATH_Post_Treat_Assessment.AssessmentID Implied ConstraintR

AO assessment record ID
ReferralID int 4 null

AO Referral Record ID
AssessmentTypeID int 4 √ null
ltblAO_ASSESSMENT_TYPE.AssessmentTypeID Implied ConstraintR

Assessment Type
AssessmentTypeOtherDesc varchar 250 √ null

Other Assessment Type
WardUnitID int 4 √ null

Assessment Location
ContactWithPatient bit 1 ((0))

Contact With (Patient)
ContactWithCarer bit 1 ((0))

Contact With (Carer)
ContactWithHcp bit 1 ((0))

Contact With (HCP)
ContactWithGp bit 1 ((0))

Contact With (GP)
IsFrailtySuspected int 4 √ ((0))

Is Frailty Suspected?
IsCgaRequired int 4 √ ((0))

Is a Comprehensive Geriatric Assessment (CGA) required?
PerformanceStatus int 4 √ null

Performance Status (WHO)
VadCentralLineID int 4 √ null

VAD/Central Line?
RecordOfAssessment varchar 2147483647 √ null

Record Of Assessment
DiscussedWith varchar 2147483647 √ null

Discussed With
SignificantMedicalHistory varchar 2147483647 √ null

Significant Medical History
AdditionalNotes varchar 2147483647 √ null

Additional Notes
ATFeverReceivingChemo int 4 √ null

Fever (and receiving Chemo)
ATChestPain int 4 √ null

Chest Pain
ATPerformanceStatus int 4 √ null

Performance Status
ATNausea int 4 √ null

Nausea
ATVomiting int 4 √ null

Vomiting
ATOralStomatitis int 4 √ null

Oral Stomatitis
ATDiarrhoea int 4 √ null

Diarrhoea
ATConstipation int 4 √ null

Constipation
ATFeverNotReceivingChemo int 4 √ null

Fever (not Chemo)
ATInfection int 4 √ null

Infection
ATPalmerPlanterSyndrome int 4 √ null

Palmer Planter Syndrome
ATFatigue int 4 √ null

Fatigue
ATAnorexia int 4 √ null

Anorexia
ATDyspnoeaShortnessOfBreath int 4 √ null

Dysponea/shortness of breath
ATRash int 4 √ null

Rash
ATNeurosensoryMotor int 4 √ null

Neurosensory/Motor
ATBleeding int 4 √ null

Bleeding
ATPain int 4 √ null

Pain
ATBruising int 4 √ null

Bruising
ATExtravasation int 4 √ null

Extravasation
AGAttendAssessmentUnit bit 1 ((0))

Patient to attend an assessment unit
AGAttendAE bit 1 ((0))

Patient to attend A&E
AGContactGP bit 1 ((0))

Patient to contact GP
AGContactedFollowUpCall bit 1 ((0))

Patient to receive a follow up call
AGAttendPrePlannedOPA bit 1 ((0))

Patient to attend pre-planned OPA
AGAttendNewlyArrangeOPA bit 1 ((0))

Patient to attend newly arranged OPA
AGAdvisedReferralToAnotherTeam bit 1 ((0))

Advised referral to another Team
AGAdvisedReferralToAnotherHospital bit 1 ((0))

Advised referral to another Hospital
AGRecommendedDiagnosticTests bit 1 ((0))

Recommended diagnostic tests
AGInfoGivenHcpGp bit 1 ((0))

Information given (HCP/GP)
AGInfoGivenPatientCarer bit 1 ((0))

Information given (Patient/Carer)
AGPsychologicalSupport bit 1 ((0))

Psychological support (Patient/Carer)
AGHcpName varchar 250 √ null

Name of HCP Advice Was Given To
AGAdditional varchar 2147483647 √ null

Additional Advice Given
ActionSymptomManagement bit 1 ((0))

Symptom management
ActionArrangeEarlyClinicAppointment bit 1 ((0))

Arrange Early/Fast Track Clinic appointment
ActionArrangeRoutineSiteSpecificFU bit 1 ((0))

Arrange Routine Site Specific F/U
ActionArrangeUrgentSiteSpecificFU bit 1 ((0))

Arrange Urgent Site Specific F/U
ActionPatientAdmittedToHospital bit 1 ((0))

Patient admitted to Hospital
ActionTakenOverByAOSOrOncology bit 1 ((0))

Taken over by AOS or Oncology
ActionFurtherAOReviewAsInpatient bit 1 ((0))

Further AO review as Inpatient
ActionFollowUpCallToBeMadeWithin24Hours bit 1 ((0))

Follow up call to be made within 24 hours
ActionNoFurtherAOFUPlanned bit 1 ((0))

No further AO F/U planned
ActionReferredToHospitalPalliativeCareTeam bit 1 ((0))

Referred to Hospital Palliative Care Team
ActionReferredToCommunityPalliativeCareTeam bit 1 ((0))

Referred to Community Palliative Care Team
ActionReferredToGP bit 1 ((0))

Referred to GP
ActionReferredToAnotherService bit 1 ((0))

Referred to other service
ActionAdditional varchar 2147483647 √ null

Additional Action Taken
TestsCancelled int 4 √ null

Tests Cancelled?
TestsCancelledBiopsy bit 1 ((0))

Biopsy
TestsCancelledCT bit 1 ((0))

CT
TestsCancelledMRI bit 1 ((0))

MRI
TestsCancelledPET bit 1 null

PET
TestsCancelledBloods bit 1 ((0))

Bloods
TestsCancelledBoneScan bit 1 ((0))

Bone Scan
TestsCancelledOther bit 1 ((0))

Other
TestsCancelledOtherDesc varchar 250 √ null

Other Tests Cancelled
AuditID int 4 √ null
tblAUDIT_RECORD.AuditID Implied ConstraintR

Latest Audit ID for AO assessment data
ActionOtherService varchar 250 √ null

Name of Other Service
AssessmentDate date 20 √ null

Assessment Date
AssessmentTime time 32 √ null

Assessment Time
PreV18_02UkonsScore varchar 20 √ null
NotApplicableUkons bit 1 ((0))
AssessmentOrganisationID int 4 √ null
OrganisationSites.ID FK_tblAO_ASSESSMENT_OrganisationSitesR
AssessmentOutcome int 4 √ null
ltblAOAssessmentOutcome.ID FK_tblAO_ASSESSMENT_ltblAOAssessmentOutcomeR
AssessmentLocation int 4 √ null
ltblAOAssessmentLocation.ID FK_tblAO_ASSESSMENT_ltblAOAssessmentLocationR
AssessmentLocationOther varchar 250 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblAO_ASSESSMENT Primary key Asc AssessmentID

Relationships

Close relationships within degrees of separation