Appendix One

List of field names for import to INR RELAY

Field Num

Description

e/d#

format~

max char  length

Example

 

1

Surname

e

An

20

Smith

 

2  

Firstname

e

An

20

John

 

3

CLINIC NUMBER   

d

Int

10

1234567890

 

4

DATE OF BIRTH

e

dd:mm:yyyy

8

18:10:1955

 

5

address line 1 

e

An

24

23 Holmgrove Ave

 

6

address line 2

d

An

24

Benfleet

 

7

address line 3

d

An

24

Essex

 

8

address line 4

d

An

24

 

 

9

post code

e

An

8

SS14 7ML

 

10

tel number

e

Int

11

01268 232312

 

11

drug name

e

An

16

Phenindione

 

12

rangelow

e

N

5

2.5

 

13

Rangehigh

e

N

5

4

 

14

PREVIOUS DOSE

d

N

5

3.5

 

15

current test date

e

dd:mm:yyyy

8

22:04:2002

 

16

nexttest DATE

e

dd:mm:yyyy

8

20:06:2002

 

17

CURENT inr result

e

n(0.5 - 10.0)

5

3.4

 

18

Missdays**

e

An

4

2x0

 

19

currentavdose

e

N

5

3.5

 

20

currentdosecode*

e

An

8

4sw13

 

21

Transcode

d

a(N/H/T)!

1

H

 

22

Diagnosis

d

A

12

DVT

 

23

P.LastDate1

d

dd:mm:yyyy

8

13:03:2002

 

24

P.Lastinr.1

D

N

5

3.2

 

25

P.Lastdose.1

d

N

5

3.5

 

26

Lastmissdays1

d

Int

1

0

 

27

P.LastDate2

d

dd:mm:yyyy

8

11:02:2002

 

28

P.Lastinr.2

d

N

5

1.8

 

29

P.Lastdose.2

d

N

5

3.5

 

30

Lastmissdays2

d

Int

1

0

 

31

LONGTERM FLAG

d

a (Y/N)

1

N

 

32

DUE TO STOP DATE

d

dd:mm:yyyy

8

12:07:2002

 

33

DNA FLAG 

e

int (0-3)

1

0

 

34

Hospname

e

An

8

Basildon

 

35

LANGUAGE  FREE

d

An

8

English

 

36

Monday dose*

e

N

5

3.5

 

37

Tuesday dose*

e

N

5

3.5

 

38

Wednesday dose*

e

N

5

3.5

 

39

Thursday dose*

e

N

5

3.5

 

40

Friday dose*

e

N

5

3.5

 

41

Saturday dose*

e

N

5

3.5

 

42

Sunday dose*

e

N

5

3.5

 

43

Free

 

44

Free

 

45

Free

 

46

Free

 

47

Free

 

48

Free

 

49

Free

 

 

 

 

50

Free

 

 

 

 

51

free

 

 

 

 

52

Free

 

 

 

 

# e= essential      d= desirable

~ an= alfanumeric   n= numeric(allowing one decimal point) int=integer

a= alfa (characters only)   dd:mm:yyyy = day:month:year

! N=No arrangements  H=Home visit by phlebotomist   T=Hospital transport

* there are three acceptable ways of recording the current dose:

METHOD A     Dose code method - Field 20 mandatory - Dose code table mandatory

METHOD B     Individual Daily dose method - Fields 36-42 mandatory No Dose code  table

METHOD C     Average daily dose  method - Field 19 mandatory - No dose code table

**  Field 18, Missdays varaible allows you to specify a number of days to take a specific dose before the regular medication takes effect.  The "x" character is used to separate the integer containing the number of days and the dose:  Some examples follow: 
2x0 take no anticoagulant for two days, miss two days then......
2 take no anticoagulant for two days, miss two days then......
4x3 take three milligrams  for four days then......
3x9 take nine milligrams for three days then.....

 

 

Appendix Two: Voicemail.txt sample USER LETTER output from DAWN 4S

 may use dosecode table (Appendix 2) to reference daily doses from dose code value (field 20)

  - text following semicolons is for clarification only

<<ALLTRIM(P.surname)>>                                     ;surname (field 1)

<<ALLTRIM(P.Forename)>>                                   ;first name (field 2)

<<ALLTRIM(P.Hosno)>>                                         ;clinic number (field 3)

<<P.DOB>>                                                            ;date of birth     (field 4)         

<<ALLTRIM(P.Address)>>                                      ;address line 1 (field 5)

<<ALLTRIM(P.District)>>                                        ;address line 2 (field 6)

<<ALLTRIM(P.Town)>>                                         ;address line 3 (field 7)

<<ALLTRIM(P.County)>>                                       ;address line 4 (field 8)

<<ALLTRIM(P.PCode)>>                                       ;address post code (field 9)

<<ALLTRIM(P.TelNo)>>                                        ; patient tel. number (field 10)

<<ALLTRIM(P.Antidesc)>>                                    ; anticoagulant name (field 11)

<<ALLTRIM(P.RangeDesc)>>                                ; rangelow - rangehigh (contains fields 12 & 13)

<<ALLTRIM(P.LabTxt1A)>>                                  ; previous dose (field 14)

<<P.LastAppt>>                                                    ; last test date (field 15)

<<P.NextSample>>                                              ; next test date (field 16)

<<P.CurrentInr>>                                                  ; current INR (field 17)

<<P.CurrMissX>>                                                  ; miss days  (field 18)

<<ALLTRIM(P.LabTxtA)>>                                    ; current average dose (field 19)

<<ALLTRIM(P.LabTxtD)>>                                    ; current average dose code (field 20)

<<ALLTRIM(P.Transport)>>                                  ; transport flag (T/H/N) (field 21)

<<.PrimeAC>>                                                      ; indication for anticoagulation (field 22)

<<P.LASTDATE1>>                                               ; date of previous INR result (field 23)

<<P.LastInr1>>                                                     ; value of previous INR result (field 24)

<<P.LastDose1>>                                                  ; previous average anticoagulant dose (field 25)

<<P.MissDayX1>>                                                 ; previous value of missdays (field 26)

<<P.LastDate2>>                                                  ; date of previous INR result but one (field 27)

<<P.LastINR2>>                                                    ; value of previous INR result but one (field 28)

<<P.LastDose2>>                                              ; previous average anticoagulant dose but one (29)

<<P.MissDayX2>>                                                 ; previous value of missdays but one (field 30)

<<P.LongTerm>>                                                 ; long term anticoag flag (Y/N) (field 31)

<<P.StopDate>>                                                    ; termination of treatment date (field 32)

<<P.ConseqDNA>>                                                ; DNA flag (0/1/2/3) (field 33)

Basildon                                                               ; name of clinic (field 34)

English                                                                 ; language (field 35)

<<ALLTRIM(P.LabTxtB)>><<ALLTRIM(P.LabTxtC)>>    ; (fields 36-42)

                                                                                     ; string containing Mon-Sun daily doses

 <<free                                                                       ; (field 43)

free                                                                       ; (field 44)    

free                                                                       ; (field 45)    

free                                                                       ; (field 46)  

free                                                                       ; (field 47)

free                                                                       ; (field 48)    

free                                                                       ; (field 49)    

free                                                                       ; (field 50)  

free                                                                       ; (field 51)

free                                                                       ; (field 52)    

 

 

top