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 (DMARD parameters)
Dosing: Flags critical alert if dose frequency is NOT explicitly "once weekly" or similar.
FBC: Withhold and review if Neutrophils < 1.5, WBC < 3.5, or Platelets < 100.
LFT: Withhold and review if ALT > 100 (or >2x ULN).
Interactions: Absolute contraindication for Trimethoprim/Co-trimoxazole. Caution for NSAIDs.
Intervals: Standard monitoring is every 12 weeks (3 months) once stable.
FBC: Withhold and review if Neutrophils < 1.5, WBC < 3.5, or Platelets < 100.
LFT: Withhold and review if ALT > 100 (or >2x ULN).
Interactions: Absolute contraindication for Trimethoprim/Co-trimoxazole. Caution for NSAIDs.
Intervals: Standard monitoring is every 12 weeks (3 months) once stable.