Skip to main content

Table 1 Set of variables used in the multidimensional request-procedure model with a description of the variable and of its type of existence in the model

From: Business intelligence applied to the consumption of iodinated contrast agents in computed tomography scans

Set

Variable ID

Name of the variable

Description of the variable

Type of existence in the model

1st quadrant: Native and created variables of interest generated by the transaction system and imported into the model

1

Date

Date in which the patient was cared for

NM

2

Time

Time in which the attention took place

NM

3

Age (years)

Age of the patient at the day of the attention

NM

4

Sex

Sex of the patient

NM

5

Patient mass

Mass of the patient at the day of the attention

CP

6

Name of the exam

Name of the exam

NM

7

Part of the body

Part of the body analyzed

NM

8

Modality

Diagnostic modality (CT scan, magnetic resonance imaging, X-ray, ultrasound scan, etc.)

NM

9

Origin of attention

Classification of the origin of the attention (outpatient clinic, hospitalization, emergency, external)

NM

10

Clinical information

Information described by the physician requesting the exam, together with the request and including relevant information on the clinical issues of the patient and the reason why the exam was requested. It accompanies a set of answers to questions of interest of the radiologist, which aim to aid in the medical diagnostic

NM

11

Exam room

Room in which the exam was conducted (room 1, room 2, room 3, all rooms)

NM

12

ICA concentration (mg iodine/mL)

ICA concentration (300 mg iodine/mL, 350 mg iodine/mL, all concentrations)

CO

13

Batch number

Number of the batch of the ICA

CO

14

Form of ICA injection

Manner in which the ICA was injected (automated with an injector pump, manual with a syringe, all manners)

CO

15

Injection flow of ICA (mL/s)

Injection flow of the ICA through an endovenous pathway

CO

16

Occurrence of adverse reactions

Occurrence of adverse reactions

CO

17

Occurrence of extravasation

Occurrence of extravasation

CO

18

Amount of extravasation

Amount of extravasation

CO

19

Pacient_code

Sequential number of the attention within the RIS system

NM

20

Request_code

Sequential number in the HIS system of exam requests

NM

21

Exam_code

Identification code of the exam

NM

22

Radiology Technician_code

Identification code of the Radiology technician

NM

23

Nursing

Technician_code

Identification code of the Nursing technician

NM

24

ICA volume (mL)

Records of the volume of ICA injected in the patient

CO

2nd quadrant: complementary variables of interest that already existed in the model

25

Year

Year in which attention took place

EM

26

Month

Name of the month in which attention took place

EM

27

Day

Number of the day in which the attention took place

EM

28

Weekday

Weekday in which the attention took place

EM

29

Semester

Name of the semester in which attention took place

EM

30

Trimester

Name of the trimester in which attention took place

EM

31

Hour

Hour in which the attention took place

EM

32

Equipment

Equipment used to carry out the exam, including a description of the producer and number of channels (Ge 8 channels, Phillips—16 channels, Toshiba—64 channels, all)

EM

33

Name of the Radiology technician

Name of the Radiology technician that carried out the attention

EM

34

Name of the Nursing technician

Name of the Nursing technician that carried out the attention

EM

35

No. of exams

Measure—sum of exams

EM

3rd quadrant: secondary variables and measurements calculated and created in the model

36

Shift

Work shift (morning – 7:00 a.m. to 12:59 p.m, afternoon – 1:00 p.m. to 6:59 p.m, Night – 7:00 p.m to 6:59 a.m., all)

CM

37

Age group

Age group of the patient at the day of the attention

CM

38

Mass range

Mass range of the patient at the day of the attention

CM

39

Specialty

Medical specialty of radiological diagnostic

CM

40

Exam group

Group of the exam (tomography or angiotomography)

CM

41

Cost (R$/mL)

Ratio of financial value to ICA volume

MC

42

Volume per mass (mL/Kg)

Ratio of the volume of ICA injected in the patient to the mass of the patient

MC

43

Reference values for volume (mL)

Reference values for the volume of ICA to be injected for each combination of exam and weight range of the patient

MC

44

Excess (mL)

Volume of ICA injected above the volume limit

MC

45

Cost of the excess (R$)

Cost of the volume of ICA injected above the volume limit

MC

46

Rate of contrasted patients (%)

Rate of variable 47 to variable 35

MC

47

No. of contrasted exams

Sum of the exams where variable 12 was filled in

MC

48

Maximum volume per exam (mL/exam)

Ratio of the sum of the volume of ICA injected in the patient to the sum of the exams carried out

MC

  1. Captions: Acronyms correspond to the form of existence in the multidimensional request-procedure model: NM—native Qdoc variable that previously existed in the model; CO—variable created in the Qdoc and imported into the model by request of the organization; CP—variable created at the Qdoc and imported to into the model at the request of the researchers; EM—variable that already existed in the model; CM—secondary variable created in the model by the researchers; MC—measure calculated and created in the model by the researchers