MedicationAdministration

Field Type Length Allow Null Natural Key Description
1 Record Type ID String

Indicates the record type. For this record it will always be “MedicationAdministration”.

2 ID ID

Surrogate Key

3 Medication Profile ID REF

Surrogate Key to a MedicationProfileCorresponds to a (MedicationProfile line in the same file set)’s ID value

4 Patient ID REF

Surrogate key to a patientCorresponds to a (Patient line in the same file set)’s ID value

5 Encounter ID REF

Surrogate Key to an EncounterCorresponds to a (Encounter line in the same file set)’s ID value

6 Caregiver ID REF

Surrogate Key to a CaregiverCorresponds to a (Caregiver line in the same file set)’s ID value

7 Status Term Term

code|name|namespace|family|ns desc

8 Dose Units Term Term

code|name|namespace|family|ns desc

9 Dose Rate Units Term Term

code|name|namespace|family|ns desc

10 Volume Units Term Term

code|name|namespace|family|ns desc

11 Fluid Rate Units Term Term

code|name|namespace|family|ns desc

12 IV Flow Type Term Term

code|name|namespace|family|ns desc

13 Route Term Term

code|name|namespace|family|ns desc

14 Method Term Term

code|name|namespace|family|ns desc

15 Site Term Term

code|name|namespace|family|ns desc

16 Reason Given Term Term

code|name|namespace|family|ns desc

17 Reason Not Given Term Term

code|name|namespace|family|ns desc

18 Scheduled Time Date
19 Dose Start Time Date
20 Dose End Time Date
21 Dose Decimal 18, 10
22 Dose Rate Decimal 18, 10
23 Volume Decimal 18, 10
24 Fluid Rate Decimal 18, 10
25 IV Bag Number Integer
26 Waste String MAX
27 Response String MAX
28 Comment String MAX
29 Quantity Per Dose String 50
30 Patient Identifier String 128

Natural Key for existing patient. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for a patient

31 Patient Record Authority ID REF

Surrogate Key to a Record Authority.

32 Encounter Identifier String 128

Natural Key for existing encounter. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for an encounter

33 Caregiver Identifier String 64

Natural Key for existing caregiver. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for a caregiver

34 Caregiver Record Authority ID REF

Surrogate Key to a Record Authority.

35 MedicationProfile Identifier String 200

Part of the MedicationProfile Natural Key

36 Inserted Audit Data Audit

Audit data for when the record was inserted/created

37 Last Modified Audit Data Audit

Audit data for when the record was last modified