tblAO_REFERRAL


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReferralID int identity 4 √ null
lnkAO_REFERRAL_PATIENT_TYPE.ReferralID FK_lnkAO_REFERRAL_PATIENT_TYPE_tblAO_REFERRALR
tblAO_COMPLICATIONS_TREATMENT.ReferralID FK_tblAO_COMPLICATIONS_TREATMENT_tblAO_REFERRALR
tblAO_MSCC.ReferralID FK_tblAO_MSCC_tblAO_REFERRALR
tblAO_NEUTROPENIC_SEPSIS.ReferralID FK_tblAO_NEUTROPENIC_SEPSIS_tblAO_REFERRALR
tblAO_OUTCOME.ReferralID FK_tblAO_OUTCOME_tblAO_REFERRALR

AO Referral Record ID
PatientID int 4 null

Demographic record ID
CareID int 4 √ null

Linked referral record ID
ReferredToID int 4 null
ltblAO_REFERRED_TO.ReferredToID Implied ConstraintR

Referral To
RouteOfReferralID int 4 √ null

Route of Referral
RouteOfReferralOther varchar 250 √ null

Other Route
MethodOfReferralID int 4 √ null

Method of Referral
MethodOfReferralOther varchar 250 √ null

Other Method
ReferrerName varchar 250 √ null

Referrer Name
ReferrerContactTel varchar 250 √ null

Referrer Contact Tel
ReferrerContactEmail varchar 250 √ null

Referrer Email
ReasonForReferralID int 4 √ null

Reason for Referral
ReasonForReferralOther varchar 250 √ null

Other Reason
PrimaryTumourSiteID int 4 √ null

Primary Tumour Site
PrimaryTumourSubSiteID int 4 √ null

Tumour Sub Site Type
PrimaryTumourSubSiteOther varchar 250 √ null

Other Tumour Sub Site
PatientAwareDiagnosisID int 4 √ null

If this is a new presentation, is the Patient aware of the diagnosis?
KnownPalliativeCare int 4 √ null

Is the Patient known to the Palliative Care Team?
EndOfLifeCare int 4 √ null

Does the Patient need End of Life Care?
ReasonForReferralToAcuteOncology varchar 2147483647 √ null

Reason for Referral to Acute Oncology Service
EmergencyAdmissionID int 4 √ null

Emergency Admission?
TeamAdmittedUnderCareID int 4 √ null

Team admitted under the care of
TeamAdmittedUnderCareOther varchar 250 √ null

Other Team
ConsultantAdmittedUnderCareID int 4 √ null

Consultant admitted under the care of
ConsultantAdmittedUnderCareOther varchar 250 √ null

Other Consultant
CurrentWardID int 4 √ null

Current Ward
PatientAlreadyDischarged int 4 √ null

Patient Already Discharged?
CupXray bit 1 ((0))

XRay
CupUltrasoundScan bit 1 ((0))

Ultrasound Scan
CupCtScan bit 1 ((0))

CT Scan
CupMriScan bit 1 ((0))

MRI Scan
CupFbc bit 1 ((0))

FBC
CupUe bit 1 ((0))

UE
CupOtherBloods bit 1 ((0))

Other Bloods
CupBiopsy bit 1 ((0))

Biopsy
CupBronchoscopy bit 1 ((0))

Bronchoscopy
CupGiScoping bit 1 ((0))

GI Scoping
CupTm5h1aa bit 1 ((0))

5H1AA
CupTmAfp bit 1 ((0))

AFP
CupTmHcg bit 1 ((0))

HCG
CupTmCa125 bit 1 ((0))

CA125
CupTmPsa bit 1 ((0))

PSA
CupTmPsaDensity bit 1 ((0))

PSA Density
CupTmCa199 bit 1 ((0))

CA 199
CupTmCea bit 1 ((0))

CEA
CupTmHb bit 1 ((0))

Hb
CupTmLdh bit 1 ((0))

LDH
CupTmLft bit 1 ((0))

LFT
CupFurtherTests varchar 2147483647 √ null

Further Tests
AuditID int 4 √ null
tblAUDIT_RECORD.AuditID Implied ConstraintR

Latest Audit ID for AO referral data
ReferredDate date 20 null

Date Referred
ReferredTime time 32 √ null

Referred Time
ArrivalDate date 20 √ null

Referral Arrival Date
ArrivalTime time 32 √ null

Referral Arrival Time
AdmissionDate date 20 √ null

Referral Admission Date
AdmissionTime time 32 √ null

Referral Admission Time
PatientTypeOther varchar 250 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblREFERRAL_ACUTE_ONCOLOGY Primary key Asc ReferralID
IX_tblAO_REFERRAL_PatientID Performance Asc PatientID

Relationships

Close relationships within degrees of separation