Core Clinical Archetypes

Opal ships with a wide range of core clinical concepts implemented as Abstract Subrecords. Applications that are generated via the $ opal startproject command will automatically contain concrete implementations of these models in the application.

Common Metadata fields

All subrecords will contain the following fields, which are not repreated individually

Field Type Length
created_by FK User ID
created Date
updated_by FK User ID
update Date

The details of each individual archetype are set out below:

Patient Subrecords

Demographics

Field Type Length
hospital_number Char 255
nhs_number Char 255
date_of_birth Date
place_of_birth FKorFT(Destination)
ethnicity FKorFT(Ethnicity)
surname Char 255
first_name Char 255
middle_name Char 255
sex FKorFT(Gender)

Allergies

Field Type Length
drug FKorFT(Drug)
provisional Boolean
details Char 255

Episode Subrecords

Location

Field Type Length
category Char 255
hospital Char 255
ward Char 255
bed Char 255

Treatment

Field Type Length
drug FKorFT(Drug)
dose Char 255
route FKorFT(Drugroute)
start_date Date
end_date Date
frequency FKorFT(Drugfreq)

Diagnosis

Field Type Length
condition FKorFT(Condition)
provisional Boolean
details Char 255
date_of_diagnosis Date

PastMedicalHistory

Field Type Length
condition FKorFT(Condition)
year Char 4
details Char 255

SymptomComplex

Field Type Length
symptoms ManyToMany(Symptom)
duration Char 255
details Text

ReferralRoute

Field Type Length
internal NullBoolean
referral_route FKorFT(ReferralOrganisation)
referral_name Char 255
date_of_referral Date
referral_team FKorFT(Speciality)
referral_reason FKorFT(ReferralReason)

PatientConsultation

Field Type Length
when Datetime
initials Char 255
reason_for_interaction FKorFT(Patient_consultation_reason_for_interaction)
discussion Text

Investigation

Field Type Length
test Char 255
date_ordered Date
details Char 255
microscopy Char 255
organism Char 255
sensitive_antibiotics Char 255
resistant_antibiotics Char 255
result Char 255
igm Char 20
igg Char 20
vca_igm Char 20
vca_igg Char 20
ebna_igg Char 20
hbsag Char 20
anti_hbs Char 20
anti_hbcore_igm Char 20
anti_hbcore_igg Char 20
rpr Char 20
tppa Char 20
viral_load Char 20
parasitaemia Char 20
hsv Char 20
vzv Char 20
syphilis Char 20
c_difficile_antigen Char 20
c_difficile_toxin Char 20
species Char 20
hsv_1 Char 20
hsv_2 Char 20
enterovirus Char 20
cmv Char 20
ebv Char 20
influenza_a Char 20
influenza_b Char 20
parainfluenza Char 20
metapneumovirus Char 20
rsv Char 20
adenovirus Char 20
norovirus Char 20
rotavirus Char 20
giardia Char 20
entamoeba_histolytica Char 20
cryptosporidium Char 20