Upload EMIS CSV
Export from EMIS Population Reporting and upload below. Columns are mapped strictly by position (A-P). Ensure you do not reorder the standard 16 columns.
Standard Operating Procedure
- Export Data: Run the EMIS search, export as a CSV (excluding the first summary rows), and upload the file here.
- Recall Patients: Click the Bloods / Wt Due dashboard metric to generate a recall list. Contact these patients to arrange their necessary checks. Keep a note of where you left off if pausing mid-session.
- Refresh Data: Once checks are complete and EMIS is updated, re-run the EMIS search and upload the fresh CSV.
- Process Reviews: Click the Ready to Complete dashboard metric. Copy the generated DOAC review notes into EMIS and add the appropriate CrCl code.
- Escalate: Target patients flagged under the CP Review and For GP Review metrics for appropriate clinical escalation.
- Maintain: Re-run this process at agreed regular intervals to maintain compliance.
Technical Reference: EMIS Layout & Clinical Parameters
16-Column Expected Layout (A–P)
A = Full Name
B = EMIS Number
C = Age
D = Gender
E = SCr Value (µmol/L)
F = SCr Date
G = LFT Date
H = ALT level (iu/L)
B = EMIS Number
C = Age
D = Gender
E = SCr Value (µmol/L)
F = SCr Date
G = LFT Date
H = ALT level (iu/L)
I = Bilirubin (µmol/L)
J = FBC Date
K = Haemoglobin (g/L)
L = Platelets (10*9/L)
M = Weight (kg)
N = DOAC & Dosage
O = Linked Indication
P = Interacting Drug
J = FBC Date
K = Haemoglobin (g/L)
L = Platelets (10*9/L)
M = Weight (kg)
N = DOAC & Dosage
O = Linked Indication
P = Interacting Drug
Clinical Alerts (SPS parameters)
LFT: Flags review if ALT > 2x ULN (>90) or Bilirubin > 1.5x ULN (>31.5).
FBC: Flags caution for Anaemia (Hb <130 Men, <120 Women) or low Platelets (<100).
Weight: Flags caution for body weight extremes (<50 kg or >120 kg).
Interactions: Flags review if interacting drug present in Col P. Multiple are combined.
Intervals: CrCl <30 (3m), CrCl 30-60 (CrCl÷10m), Age ≥75 (max 4m), Standard (12m).
FBC: Flags caution for Anaemia (Hb <130 Men, <120 Women) or low Platelets (<100).
Weight: Flags caution for body weight extremes (<50 kg or >120 kg).
Interactions: Flags review if interacting drug present in Col P. Multiple are combined.
Intervals: CrCl <30 (3m), CrCl 30-60 (CrCl÷10m), Age ≥75 (max 4m), Standard (12m).