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 |