Order

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

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

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 Placer Order Number String 200

HL7 Placer Order Number

6 Filler Order Number String 200

HL7 Filler Order Number

7 Order Text String MAX
8 Is PRN String

true,false

9 Start Date Date

If not specified this will be automatically defaulted to Date Min value (01/01/0001)

10 Stop Date Date

If not specified this will be automatically defaulted to Date Max value (12/31/9999)

11 Order Date Date

If not specified this will be automatically defaulted to what is in Start Date

12 Comment String MAX
13 Min Dose Decimal 18, 10
14 Max Dose Decimal 18, 10
15 Strength String 50
16 Refills INT
17 Quantity String 50
18 Priority Term Term

code|name|namespace|family|ns desc. If not specified this will be automatically defaulted to UNKNOWN|UNKNOWN|<namespace>||

19 Ordering Caregiver ID REF

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

20 Entering Caregiver ID REF

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

21 Order Status Term Term

code|name|namespace|family|ns desc.

22 Frequency Term Term

code|name|namespace|family|ns desc.If not specified this will be automatically defaulted to UNKNOWN|UNKNOWN|<namespace>||

23 Stop Reason Term Term

code|name|namespace|family|ns desc.

24 Dose Units Term Term

code|name|namespace|family|ns desc.

25 Route Term Term

code|name|namespace|family|ns desc.

26 Strength Units Term Term

code|name|namespace|family|ns desc.

27 Specimen Source Term Term

code|name|namespace|family|ns desc.

28 Item Term Term

code|name|namespace|family|ns desc.

29 Department Term Term

code|name|namespace|family|ns desc.

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 Ordering Caregiver Identifier String 50

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

34 Ordering Caregiver Record Authority ID REF

Surrogate Key to a Record Authority.

35 Entering Caregiver Identifier String 50

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

36 Entering Caregiver Record Authority ID REF

Surrogate Key to a Record Authority.

37 Placer Group Number String 200

Placer Group Number

38 Namespace Identifier String 50

Placer Assigning Authority. Namespace identifier

39 Universal Identifier String 200

Placer Assigning Authority. Universal identifier

40 Universal Identifier Type String 50

Placer Assigning Authority. Universal identifier type

41 Namespace Identifier String 50

Filler Assigning Authority. Namespace identifier

42 Universal Identifier String 200

Filler Assigning Authority. Universal identifier

43 Universal Identifier Type String 50

Filler Assigning Authority. Universal identifier type

44 Namespace Identifier String 50

Placer Group Assigning Authority. Namespace identifier

45 Universal Identifier String 200

Placer Group Assigning Authority. Universal identifier

46 Universal Identifier Type String 50

Placer Group Assigning Authority. Universal identifier type

47 Item Text String MAX

Orderable-Item Item Text

48 Item Alternate Term Term

Deprecated – use field 51 below - Item Term Alternates

49 Inserted Audit Data Audit

Audit data for when the record was inserted/created

50 Last Modified Audit Data Audit

Audit data for when the record was last modified

51 Item Term Alternates Term List

See Term List Format – List of terms

52 Data Source Data Source 50|MAX

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