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 |