User Maintenance window: CSV text file formats

In the CSV format (comma delimited), the sample report may take more than one line per sample.

No character is provided for a test without a value (no entry, test not run), but the comma delimiter displays.

Data items 14 through 22 are repeated for each reported test result.

The report format is as follows:

NOTE

In the following format: dark red characters are actually output (literals), text within braces {} identify data item variables, and CR and LF are control characters.

Data item number {}

Data item description

Comments

1

sample identification number

13 characters maximum

2

sample position

7 characters maximum

The actual format depends on the sampling device:

·   tray sampler (STT) = 5 characters (tt-ccc; tray 01 to 97, cup 01 to 84)

·   rack sampler = 7 characters (rrrr-cc; rack 0001 to 9999, cup 01 to 10)

·   If barcode labels are used, the sample position might not be required and data item 2 will contain no (0) characters.

3

LAS (lab automation) number

 

4

dilution factor

5 characters maximum, including decimal point

5

cup or container type

a number from 1 to 9

6

sample type

1 serum; 2: urine

7

comment 1

16 characters maximum

If there is no entry, data item contains no (0) characters.

8

comment 2

16 characters maximum

If there is no entry, data item contains no (0) characters.

9

patient age

3 characters maximum

10

aspiration date and time

DD MM YYYY

11

control lot number

control sample only, patient sample is blank

12

patient sex

1: male; 2: female

13

number of tests requested

3 characters maximum

14

test number

process sequence number

15

test name

 

16

test results

qualitative results, 6 characters maximum; density value - fixed 9 characters and right justified.

If there is no entry, data item will contain no (0) characters.

17

units

 

18

flag report

contains 12 characters for spectrophotometric tests and 11 characters for electrolyte tests.

If item is not run, data item contains no (0) characters.

19

user code

 

20

calibration lot number

 

21

reagent 1 lot number

 

22

reagent 2 lot number

 

 

The mark (flag) report format for spectrophotometric tests is:

1

2

3

4

5

6

7

8

9

10

11

12

H,L,h,l

u,d

U,D

P,E

*

n

N

C

S

r

R

s,t

The mark (flag) report format for electrolyte tests is:

1

2

3

4

5

6

7

8

9

10

11

H,L,h,l

U

space

space

*

T

B

C

S

r

R