Medication

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

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

2 ID ID

Surrogate Key

3 Patient ID REF

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

4 Encounter ID REF

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

5 Medication Term Term

code|name|namespace|family|ns desc. The actually medication

6 Therapeutic Class Term

code|name|namespace|family|ns desc

7 Date Date
8 Refills INT
9 Quantity Decimal 18, 10
10 Prescribed By Caregiver ID REF

Surrogate Key to a CaregiverCorresponds to a (Caregiver line in the same file set)’s ID value This is the physician who prescribed or ordered the Med.

11 Days supplied INT
12 Prescribed date Date
13 Identifier 50
14 Dose Decimal 18, 10
15 Is Generic

true,false

16 Comment String MAX
17 Amount Paid Decimal 18, 10
18 Amount Billed Decimal 18, 10
19 Refill Number SMALL INT
20 Units Term Term

code|name|namespace|family|ns desc

21 Claim ID String
22 Frequency Term Term

code|name|namespace|family|ns desc

23 Status Term Term

code|name|namespace|family|ns desc

24 Filled By Caregiver ID REF

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

25 Dose Units Term Term

code|name|namespace|family|ns desc

26 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

27 Patient Record Authority ID REF

Surrogate Key to a Record Authority.

28 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

29 Prescribed By 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 caregiverThis is the physician who prescribed or ordered the Med.

30 Prescribed By Caregiver Record Authority ID REF

Surrogate Key to a Record Authority.

31 Filled By 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

32 Filled By Caregiver Record Authority ID REF

Surrogate Key to a Record Authority.

33 Claim Identifier String 50

Used to look up existing claim (along with known patient and encounter)

34 Inserted Audit Data Audit

Audit data for when the record was inserted/created

35 Last Modified Audit Data Audit

Audit data for when the record was last modified

36 Reconcile Status Term Term

code|name|namespace|family|ns desc.

37 Alternate Identifier String 100
38 Strength String 100
39 Dispensed As Written String 50
40 Data Source Data Source 50|MAX

Code|Name. See Data Source Format - Source of the data