|
Name |
Type |
Discontinued? |
|
| 1 |
ORDER_MED_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the order record associated with this medication order. This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION. |
|
|
| 2 |
PAT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the patient record for this line. This column is frequently used to link to the PATIENT table. |
|
|
| 3 |
PAT_ENC_DATE_REAL |
FLOAT |
No |
|
|
|
| A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. |
|
|
| 4 |
PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
| The unique contact serial number (CSN) for the patient contact associated with this medication order. This number is unique across patients and encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI). |
|
|
| 5 |
ORDERING_DATE |
DATETIME |
No |
|
|
|
| The date when the medication order was placed. |
|
|
| 6 |
ORDER_CLASS_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the order class. This value is used to define how clinical systems process the order. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Normal |
|
|
| 7 |
PHARMACY_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the pharmacy record that is associated with this medication order. This column is frequently used to link to the RX_PHR table. This field is only populated if the clinical system user selects a specific pharmacy from the list, otherwise the field is null. This field is only populated by the ambulatory clinical system, not the pharmacy system. |
|
|
| 8 |
PHARMACY_ID_PHARMACY_NAME |
VARCHAR |
No |
|
|
|
| The name of the pharmacy. |
|
|
| 9 |
ORD_CREATR_USER_ID |
VARCHAR |
No |
|
|
|
| The EMP ID (.1) of the user who signed the order (for a non-signed and held order) or the last person who performed a sign and hold or release action for a signed and held order. |
|
|
| 10 |
ORD_CREATR_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 11 |
MEDICATION_ID_MEDICATION_NAME |
VARCHAR |
No |
|
|
|
| The name of this medication record. |
|
|
| 12 |
DESCRIPTION |
VARCHAR |
No |
|
|
|
| The description of the order. This information is found in the Order field of clinical system’s Order Detail window. |
|
|
| 13 |
DOSAGE |
VARCHAR |
No |
|
|
|
| The dispensation amount for the prescription entered by the user in the orders activity. This amount is stored as a string in the orders database. |
|
|
| 14 |
QUANTITY |
VARCHAR |
No |
|
|
|
| The quantity of the prescription being dispensed as entered by the user. |
|
|
| 15 |
REFILLS |
VARCHAR |
No |
|
|
|
| The number of refills allowed for this prescription as entered by the user. |
|
|
| 16 |
START_DATE |
DATETIME |
No |
|
|
|
| The date when the medication order started. The date appears in calendar format. |
|
|
| 17 |
END_DATE |
DATETIME |
No |
|
|
|
| The date when the medication order is to end. |
|
|
| 18 |
DISP_AS_WRITTEN_YN |
VARCHAR |
No |
|
|
|
| Indicates whether or not the prescription should be dispensed as written for this medication. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| No |
|
|
| 19 |
RSN_FOR_DISCON_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the reason a prescription has been discontinued. This column contains data only in prescription orders that have been discontinued. |
| May contain organization-specific values: Yes |
|
|
| 20 |
MED_PRESC_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
| The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
| 21 |
NONFRM_XCPT_CD_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for medication's exception code. This code explains the reason a non-formulary medication was ordered. |
| May contain organization-specific values: Yes |
|
|
| 22 |
PANEL_MED_ID_MEDICATION_NAME |
VARCHAR |
No |
|
|
|
| The name of this medication record. |
|
|
| 23 |
UPDATE_DATE |
DATETIME (Local) |
No |
|
|
|
| The date and time when this row was created or last updated in Clarity. |
|
|
| 24 |
ORDER_INST |
DATETIME (Local) |
No |
|
|
|
| The date and time the order was placed. The date appears in calendar format. |
|
|
| 25 |
DISPLAY_NAME |
VARCHAR |
No |
|
|
|
| The name of the medication as it appears on the medication record itself. |
|
|
| 26 |
AS_MEDICATION_ID_MEDICATION_NAME |
VARCHAR |
No |
|
|
|
| The name of this medication record. |
|
|
| 27 |
HV_HOSPITALIST_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this is a hospitalist order. A Y indicates a hospitalist order. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 28 |
ORDER_PRIORITY_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the priority assigned to an order. |
| May contain organization-specific values: Yes |
|
|
| 29 |
MED_ROUTE_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the route of administration of a medication. |
| May contain organization-specific values: Yes |
|
|
| 30 |
DISCON_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the user who discontinued the order. |
|
|
| 31 |
DISCON_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 32 |
DISCON_TIME |
DATETIME (UTC) |
No |
|
|
|
| The date and time when the medication order was discontinued. The date appears in calendar format. |
|
|
| 33 |
CHNG_ORDER_MED_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the changed or reordered medication order that this order replaced. This column is frequently used to link back to the ORDER_MED table. |
|
|
| 34 |
PEND_APPR_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the user who approved a pended order. |
|
|
| 35 |
PEND_APPR_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 36 |
PEND_REF_REAS_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the reason a pended medication was refused. |
| May contain organization-specific values: Yes |
|
|
| 37 |
HV_DISCR_FREQ_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the discrete frequency record associated with this medication order. This column is frequently used to link to the IP_FREQUENCY table. |
|
|
| 38 |
HV_DISCR_FREQ_ID_FREQ_NAME |
VARCHAR |
No |
|
|
|
| The name of the frequency record. |
|
|
| 39 |
HV_DISCRETE_DOSE |
VARCHAR |
No |
|
|
|
| The discrete dose for a medication as entered by the user in the orders activity. |
|
|
| 40 |
HV_DOSE_UNIT_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the dosage unit of a medication. |
| May contain organization-specific values: Yes |
| Category Entries: |
| mL |
| L |
| mg |
| g |
| Units |
| mmol |
| mEq |
| mcg |
| % |
| Int'l Units |
| Million Units |
| kcal |
| ng |
| mg PE |
| milli-units |
| pg |
| KBq |
| MBq |
| GBq |
| mcL |
| mL/min |
| L/min |
| mg/min |
| g/min |
| Units/min |
| mmol/min |
| mEq/min |
| mcg/min |
| kJ/min |
| Int'l Units/min |
| Million Units/min |
| kcal/min |
| ng/min |
| mg PE/min |
| milli-units/min |
| pg/min |
| KBq/min |
| MBq/min |
| GBq/min |
| mcL/min |
| mL/hr |
| L/hr |
| mg/hr |
| g/hr |
| Units/hr |
| mmol/hr |
| mEq/hr |
| mcg/hr |
| kJ/hr |
| Int'l Units/hr |
| Million Units/hr |
| kcal/hr |
| ng/hr |
| mg PE/hr |
| milli-units/hr |
| pg/hr |
| KBq/hr |
| MBq/hr |
| GBq/hr |
| mcL/hr |
| mL/day |
| L/day |
| mg/day |
| g/day |
| Units/day |
| mmol/day |
| mEq/day |
| mcg/day |
| kJ/day |
| Int'l Units/day |
| Million Units/day |
| kcal/day |
| ng/day |
| mg PE/day |
| milli-units/day |
| pg/day |
| Inch/day |
| KBq/day |
| MBq/day |
| GBq/day |
| mcL/day |
| IR/day |
| BAU/day |
| PFU/day |
| Million PFU/day |
| Million Int'l Units/day |
| Kilo Int'l Units/day |
| EIN/day |
| Million EIN/day |
| mL/kg |
| L/kg |
| mg/kg |
| g/kg |
| Units/kg |
| mmol/kg |
| mEq/kg |
| mcg/kg |
| kJ/kg |
| Int'l Units/kg |
| Million Units/kg |
| kcal/kg |
| ng/kg |
| mg PE/kg |
| milli-units/kg |
| pg/kg |
| mg/kg (Actual) |
| Each/kg |
| Puff/kg |
| Package/kg |
| Drop/kg |
| Inch/kg |
| KBq/kg |
| MBq/kg |
| GBq/kg |
| mcL/kg |
| IR/kg |
| BAU/kg |
| Million Int'l Units/kg |
| mcmol/kg |
| 1e12 Vector Genomes/kg |
| Vector Genomes/kg |
| Dose/kg |
| mcg DFE/kg |
| Kilo Int'l Units/kg |
| 1e11 Vector Genomes/kg |
| 1e13 Vector Genomes/kg |
| 1e14 Vector Genomes/kg |
| 1e15 Vector Genomes/kg |
| EIN/kg |
| IR/min |
| BAU/min |
| Million Int'l Units/min |
| Kilo Int'l Units/min |
| IR/hr |
| BAU/hr |
| Million Int'l Units/hr |
| Kilo Int'l Units/hr |
| mL/mL |
| L/mL |
| mg/mL |
| g/mL |
| Units/mL |
| mmol/mL |
| mEq/mL |
| mcg/mL |
| kJ/mL |
| Int'l Units/mL |
| Million Units/mL |
| kcal/mL |
| ng/mL |
| mg PE/mL |
| milli-units/mL |
| pg/mL |
| KBq/mL |
| MBq/mL |
| GBq/mL |
| mcL/mL |
| IR/mL |
| BAU/mL |
| PFU/mL |
| Million PFU/mL |
| Million Int'l Units/mL |
| mcmol/mL |
| 1e12 Vector Genomes/mL |
| Vector Genomes/mL |
| Kilo Int'l Units/mL |
| 1e11 Vector Genomes/mL |
| 1e13 Vector Genomes/mL |
| 1e14 Vector Genomes/mL |
| 1e15 Vector Genomes/mL |
| millicurie/mL |
| mL/L |
| L/L |
| mg/L |
| g/L |
| Units/L |
| mmol/L |
| mEq/L |
| mcg/L |
| kJ/L |
| Int'l Units/L |
| Million Units/L |
| kcal/L |
| ng/L |
| mg PE/L |
| milli-units/L |
| pg/L |
| KBq/L |
| MBq/L |
| GBq/L |
| mcL/L |
| IR/L |
| BAU/L |
| Million Int'l Units/L |
| Kilo Int'l Units/L |
| mL/m2 |
| L/m2 |
| mg/m2 |
| g/m2 |
| Units/m2 |
| mmol/m2 |
| mEq/m2 |
| mcg/m2 |
| kJ/m2 |
| Int'l Units/m2 |
| Million Units/m2 |
| kcal/m2 |
| ng/m2 |
| mg PE/m2 |
| milli-units/m2 |
| pg/m2 |
| mg/m2 (Actual) |
| Each/m2 |
| Puff/m2 |
| Package/m2 |
| Drop/m2 |
| KBq/m2 |
| MBq/m2 |
| GBq/m2 |
| mcL/m2 |
| IR/m2 |
| BAU/m2 |
| Million Int'l Units/m2 |
| mcmol/m2 |
| 1e12 Vector Genomes/m2 |
| Vector Genomes/m2 |
| Kilo Int'l Units/m2 |
| 1e11 Vector Genomes/m2 |
| 1e13 Vector Genomes/m2 |
| 1e14 Vector Genomes/m2 |
| 1e15 Vector Genomes/m2 |
| mL/1.7m2 |
| L/1.7m2 |
| mg/1.7m2 |
| g/1.7m2 |
| Units/1.7m2 |
| mmol/1.7m2 |
| mEq/1.7m2 |
| mcg/1.7m2 |
| kJ/1.7m2 |
| Int'l Units/1.7m2 |
| Million Units/1.7m2 |
| kcal/1.7m2 |
| ng/1.7m2 |
| mg PE/1.7m2 |
| milli-units/1.7m2 |
| pg/1.7m2 |
| Each/1.7m2 |
| KBq/1.7m2 |
| MBq/1.7m2 |
| GBq/1.7m2 |
| mcL/1.7m2 |
| IR/1.7m2 |
| BAU/1.7m2 |
| Million Int'l Units/1.7m2 |
| Kilo Int'l Units/1.7m2 |
| mL/kg (IDL) |
| L/kg (IDL) |
| mg/kg (IDL) |
| g/kg (IDL) |
| Units/kg (IDL) |
| mmol/kg (IDL) |
| mEq/kg (IDL) |
| mcg/kg (IDL) |
| Int'l Units/kg (IDL) |
| Million Units/kg (IDL) |
| Kcal/kg (IDL) |
| ng/kg (IDL) |
| mg PE/kg (IDL) |
| milli-units/kg (IDL) |
| pg/kg (IDL) |
| mg/m2 (IDL) |
| mL/kg (ADJ) |
| L/kg (ADJ) |
| mg/kg (ADJ) |
| g/kg (ADJ) |
| Units/kg (ADJ) |
| mmol/kg (ADJ) |
| mEq/kg (ADJ) |
| mcg/kg (ADJ) |
| Int'l Units/kg (ADJ) |
| Million Units/kg (ADJ) |
| Kcal/kg (ADJ) |
| ng/kg (ADJ) |
| mg PE/kg (ADJ) |
| milli-units/kg (ADJ) |
| pg/kg (ADJ) |
| mg/m2 (ADJ) |
| mL/100 mL |
| L/100 mL |
| mg/100 mL |
| g/100 mL |
| Units/100 mL |
| mmol/100 mL |
| mEq/100 mL |
| mcg/100 mL |
| kJ/100 mL |
| Int'l Units/100 mL |
| Million Units/100 mL |
| kcal/100 mL |
| ng/100 mL |
| mg PE/100 mL |
| milli-units/100 mL |
| pg/100 mL |
| KBq/100 mL |
| MBq/100 mL |
| GBq/100 mL |
| mcL/100 mL |
| IR/100 mL |
| BAU/100 mL |
| Million Int'l Units/100 mL |
| Kilo Int'l Units/100 mL |
| mL/oz |
| L/oz |
| mg/oz |
| g/oz |
| Units/oz |
| mmol/oz |
| mEq/oz |
| mcg/oz |
| kJ/oz |
| Int'l Units/oz |
| Million Units/oz |
| kcal/oz |
| ng/oz |
| mg PE/oz |
| milli-units/oz |
| pg/oz |
| KBq/oz |
| MBq/oz |
| GBq/oz |
| mcL/oz |
| IR/oz |
| BAU/oz |
| Million Int'l Units/oz |
| Kilo Int'l Units/oz |
| mL/kg/min |
| L/kg/min |
| mg/kg/min |
| g/kg/min |
| Units/kg/min |
| mmol/kg/min |
| mEq/kg/min |
| mcg/kg/min |
| kJ/kg/min |
| Int'l Units/kg/min |
| Million Units/kg/min |
| kcal/kg/min |
| ng/kg/min |
| mg PE/kg/min |
| milli-units/kg/min |
| pg/kg/min |
| KBq/kg/min |
| MBq/kg/min |
| GBq/kg/min |
| mcL/kg/min |
| mL/kg/min (IDL) |
| L/kg/min (IDL) |
| mg/kg/min (IDL) |
| g/kg/min (IDL) |
| Units/kg/min (IDL) |
| mmol/kg/min (IDL) |
| mEq/kg/min (IDL) |
| mcg/kg/min (IDL) |
| Int'l Units/kg/min (IDL) |
| Million Units/kg/min (IDL) |
| Kcal/kg/min (IDL) |
| ng/kg/min (IDL) |
| mg PE/kg/min (IDL) |
| milli-units/kg/min (IDL) |
| pg/kg/min (IDL) |
| mL/kg/min (ADJ) |
| L/kg/min (ADJ) |
| mg/kg/min (ADJ) |
| g/kg/min (ADJ) |
| Units/kg/min (ADJ) |
| mmol/kg/min (ADJ) |
| mEq/kg/min (ADJ) |
| mcg/kg/min (ADJ) |
| Int'l Units/kg/min (ADJ) |
| Million Units/kg/min (ADJ) |
| Kcal/kg/min (ADJ) |
| ng/kg/min (ADJ) |
| mg PE/kg/min (ADJ) |
| milli-units/kg/min (ADJ) |
| pg/kg/min (ADJ) |
| IR/kg/min |
| BAU/kg/min |
| Million Int'l Units/kg/min |
| Kilo Int'l Units/kg/min |
| mL/m2/min |
| L/m2/min |
| mg/m2/min |
| g/m2/min |
| Units/m2/min |
| mmol/m2/min |
| mEq/m2/min |
| mcg/m2/min |
| kJ/m2/min |
| Int'l Units/m2/min |
| Million Units/m2/min |
| kcal/m2/min |
| ng/m2/min |
| mg PE/m2/min |
| milli-units/m2/min |
| pg/m2/min |
| KBq/m2/min |
| MBq/m2/min |
| GBq/m2/min |
| mcL/m2/min |
| mL/1.7m2/min |
| L/1.7m2/min |
| mg/1.7m2/min |
| g/1.7m2/min |
| Units/1.7m2/min |
| mmol/1.7m2/min |
| mEq/1.7m2/min |
| mcg/1.7m2/min |
| kJ/1.7m2/min |
| Int'l Units/1.7m2/min |
| Million Units/1.7m2/min |
| kcal/1.7m2/min |
| ng/1.7m2/min |
| mg PE/1.7m2/min |
| milli-units/1.7m2/min |
| pg/1.7m2/min |
| KBq/1.7m2/min |
| MBq/1.7m2/min |
| GBq/1.7m2/min |
| mSv |
| mGy |
| mcL/1.7m2/min |
| mg of pseudoephedrine |
| IR/m2/min |
| BAU/m2/min |
| Million Int'l Units/m2/min |
| Kilo Int'l Units/m2/min |
| IR/1.7m2/min |
| BAU/1.7m2/min |
| Million Int'l Units/1.7m2/min |
| Kilo Int'l Units/1.7m2/min |
| mL/kg/hr |
| L/kg/hr |
| mg/kg/hr |
| g/kg/hr |
| Units/kg/hr |
| mmol/kg/hr |
| mEq/kg/hr |
| mcg/kg/hr |
| kJ/kg/hr |
| Int'l Units/kg/hr |
| Million Units/kg/hr |
| kcal/kg/hr |
| ng/kg/hr |
| mg PE/kg/hr |
| milli-units/kg/hr |
| pg/kg/hr |
| KBq/kg/hr |
| MBq/kg/hr |
| GBq/kg/hr |
| mcL/kg/hr |
| mL/kg/hr (IDL) |
| L/kg/hr (IDL) |
| mg/kg/hr (IDL) |
| g/kg/hr (IDL) |
| Units/kg/hr (IDL) |
| mmol/kg/hr (IDL) |
| mEq/kg/hr (IDL) |
| mcg/kg/hr (IDL) |
| Int'l Units/kg/hr (IDL) |
| Million Units/kg/hr (IDL) |
| Kcal/kg/hr (IDL) |
| ng/kg/hr (IDL) |
| mg PE/kg/hr (IDL) |
| milli-units/kg/hr (IDL) |
| pg/kg/hr (IDL) |
| mL/kg/hr (ADJ) |
| L/kg/hr (ADJ) |
| mg/kg/hr (ADJ) |
| g/kg/hr (ADJ) |
| Units/kg/hr (ADJ) |
| mmol/kg/hr (ADJ) |
| mEq/kg/hr (ADJ) |
| mcg/kg/hr (ADJ) |
| Int'l Units/kg/hr (ADJ) |
| Million Units/kg/hr (ADJ) |
| Kcal/kg/hr (ADJ) |
| ng/kg/hr (ADJ) |
| mg PE/kg/hr (ADJ) |
| milli-units/kg/hr (ADJ) |
| pg/kg/hr (ADJ) |
| IR/kg/hr |
| BAU/kg/hr |
| Million Int'l Units/kg/hr |
| Kilo Int'l Units/kg/hr |
| mL/m2/hr |
| L/m2/hr |
| mg/m2/hr |
| g/m2/hr |
| Units/m2/hr |
| mmol/m2/hr |
| mEq/m2/hr |
| mcg/m2/hr |
| kJ/m2/hr |
| Int'l Units/m2/hr |
| Million Units/m2/hr |
| kcal/m2/hr |
| ng/m2/hr |
| mg PE/m2/hr |
| milli-units/m2/hr |
| pg/m2/hr |
| KBq/m2/hr |
| MBq/m2/hr |
| GBq/m2/hr |
| mcL/m2/hr |
| mL/1.7m2/hr |
| L/1.7m2/hr |
| mg/1.7m2/hr |
| g/1.7m2/hr |
| Units/1.7m2/hr |
| mmol/1.7m2/hr |
| mEq/1.7m2/hr |
| mcg/1.7m2/hr |
| kJ/1.7m2/hr |
| Int'l Units/1.7m2/hr |
| Million Units/1.7m2/hr |
| kcal/1.7m2/hr |
| ng/1.7m2/hr |
| mg PE/1.7m2/hr |
| milli-units/1.7m2/hr |
| pg/1.7m2/hr |
| KBq/1.7m2/hr |
| MBq/1.7m2/hr |
| GBq/1.7m2/hr |
| mcL/1.7m2/hr |
| IR/1.7m2/hr |
| BAU/1.7m2/hr |
| Million Int'l Units/1.7m2/hr |
| Kilo Int'l Units/1.7m2/hr |
| IR/m2/hr |
| BAU/m2/hr |
| Million Int'l Units/m2/hr |
| Kilo Int'l Units/m2/hr |
| mL/kg/day |
| L/kg/day |
| mg/kg/day |
| g/kg/day |
| Units/kg/day |
| mmol/kg/day |
| mEq/kg/day |
| mcg/kg/day |
| kJ/kg/day |
| Int'l Units/kg/day |
| Million Units/kg/day |
| kcal/kg/day |
| ng/kg/day |
| mg PE/kg/day |
| milli-units/kg/day |
| pg/kg/day |
| Inch/kg/day |
| KBq/kg/day |
| MBq/kg/day |
| GBq/kg/day |
| mL/kg/day (IDL) |
| L/kg/day (IDL) |
| mg/kg/day (IDL) |
| g/kg/day (IDL) |
| Units/kg/day (IDL) |
| mmol/kg/day (IDL) |
| mEq/kg/day (IDL) |
| mcg/kg/day (IDL) |
| Int'l Units/kg/day (IDL) |
| Million Units/kg/day (IDL) |
| Kcal/kg/day (IDL) |
| ng/kg/day (IDL) |
| mg PE/kg/day (IDL) |
| milli-units/kg/day (IDL) |
| pg/kg/day (IDL) |
| mL/kg/day (ADJ) |
| L/kg/day (ADJ) |
| mg/kg/day (ADJ) |
| g/kg/day (ADJ) |
| Units/kg/day (ADJ) |
| mmol/kg/day (ADJ) |
| mEq/kg/day (ADJ) |
| mcg/kg/day (ADJ) |
| Int'l Units/kg/day (ADJ) |
| Million Units/kg/day (ADJ) |
| Kcal/kg/day (ADJ) |
| ng/kg/day (ADJ) |
| mg PE/kg/day (ADJ) |
| milli-units/kg/day (ADJ) |
| pg/kg/day (ADJ) |
| mcL/kg/day |
| IR/kg/day |
| BAU/kg/day |
| Million Int'l Units/kg/day |
| mL/m2/day |
| L/m2/day |
| mg/m2/day |
| g/m2/day |
| Units/m2/day |
| mmol/m2/day |
| mEq/m2/day |
| mcg/m2/day |
| kJ/m2/day |
| Int'l Units/m2/day |
| Million Units/m2/day |
| kcal/m2/day |
| ng/m2/day |
| mg PE/m2/day |
| milli-units/m2/day |
| pg/m2/day |
| KBq/m2/day |
| MBq/m2/day |
| GBq/m2/day |
| mcL/m2/day |
| mL/1.7m2/day |
| L/1.7m2/day |
| mg/1.7m2/day |
| g/1.7m2/day |
| Units/1.7m2/day |
| mmol/1.7m2/day |
| mEq/1.7m2/day |
| mcg/1.7m2/day |
| kJ/1.7m2/day |
| Int'l Units/1.7m2/day |
| Million Units/1.7m2/day |
| kcal/1.7m2/day |
| ng/1.7m2/day |
| mg PE/1.7m2/day |
| milli-units/1.7m2/day |
| pg/1.7m2/day |
| KBq/1.7m2/day |
| MBq/1.7m2/day |
| GBq/1.7m2/day |
| mcL/1.7m2/day |
| mL/oz/day |
| L/oz/day |
| mg/oz/day |
| g/oz/day |
| Units/oz/day |
| mmol/oz/day |
| mEq/oz/day |
| mcg/oz/day |
| kJ/oz/day |
| Int'l Units/oz/day |
| Million Units/oz/day |
| kcal/oz/day |
| ng/oz/day |
| mg PE/oz/day |
| milli-units/oz/day |
| pg/oz/day |
| KBq/oz/day |
| MBq/oz/day |
| GBq/oz/day |
| mcL/oz/day |
| IR/m2/day |
| BAU/m2/day |
| Million Int'l Units/m2/day |
| Kilo Int'l Units/m2/day |
| IR/1.7m2/day |
| BAU/1.7m2/day |
| Million Int'l Units/1.7m2/day |
| Kilo Int'l Units/1.7m2/day |
| IR/oz/day |
| BAU/oz/day |
| Million Int'l Units/oz/day |
| Kilo Int'l Units/oz/day |
| kJ/30 mL |
| kcal/30 mL |
| Gy-cm2 |
| mL/cm2 |
| mg/cm2 |
| mOsmol |
| each |
| tablet |
| capsule |
| drop |
| tsp |
| puff |
| suppository |
| spray |
| Squirt |
| inch |
| patch |
| Act |
| ampule |
| Bar |
| Bottle |
| Can |
| Device |
| enema |
| Gallon |
| Inhaler |
| kit |
| lb |
| lozenge |
| oz |
| packet |
| Stick |
| strip |
| Tbsp |
| Tube |
| vial |
| Wafer |
| Container |
| Syringe |
| Package |
| applicator |
| cm |
| Applicatorful |
| Troche |
| millicurie |
| Intra Uterine Device |
| Part |
| m |
| Film |
| Million Cells |
| Dose |
| mm |
| IR |
| BAU |
| kg |
| cm2 |
| Imperial Gallon |
| kJ |
| PFU |
| Piece |
| Million PFU |
| Doses/Fill |
| Cartridge |
| Thousand Units |
| Lipoprotein Lipase Releasing Unit |
| Scoop |
| Million Int'l Units |
| mm2 |
| Pump |
| fluid ounce |
| Product |
| Bag |
| mcmol |
| 1e12 Vector Genomes |
| Vector Genomes |
| millicurie/kg |
| millicurie/m2 |
| millicurie/1.7m2 |
| microcurie |
| microcurie/kg |
| microcurie/m2 |
| microcurie/1.7m2 |
| Canister |
| mcg DFE |
| Billion Cells |
| Application |
| Box |
| Capful |
| Inhalation |
| Lancet |
| Needle |
| Pad |
| Pen |
| Piece of gum |
| Ring |
| Swab |
| Sachet |
| Implant |
| Insert |
| Pools |
| Kilo Int'l Units |
| Kilo Int'l Units/kg/day |
| 1e11 Vector Genomes |
| 1e13 Vector Genomes |
| 1e14 Vector Genomes |
| 1e15 Vector Genomes |
| Cells |
| EIN |
| Million EIN |
| EIN/kg/day |
| None / Other |
|
|
| 41 |
HV_IS_SELF_ADM_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this medication was self-administered. A Y indicates that the order was self-administered. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 42 |
ORDER_START_TIME |
DATETIME (Local) |
No |
|
|
|
| The date and time when the medication order is to start. The date appears in calendar format. |
|
|
| 43 |
ORDER_END_TIME |
DATETIME (Local) |
No |
|
|
|
| The date and time when the medication order is scheduled to end. The date appears in calendar format. |
|
|
| 44 |
NON_FORMULARY_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this medication is not on the formulary. A Y indicates a non-formulary medication. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 45 |
ORDER_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the current status of an order. |
| May contain organization-specific values: No |
| Category Entries: |
| Pending |
| Sent |
| Resulted |
| Canceled |
| Completed |
| Holding for Referral |
| Denied Approval |
| Suspend |
| Discontinued |
| Verified |
| Dispensed |
| Pending Verify |
|
|
| 46 |
AUTHRZING_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
| The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
| 47 |
ORD_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
| The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
| 48 |
MIN_DISCRETE_DOSE |
NUMERIC |
No |
|
|
|
| The minimum ordered dose amount for the medication as specified by the user in the orders activity. |
|
|
| 49 |
MAX_DISCRETE_DOSE |
NUMERIC |
No |
|
|
|
| The maximum ordered dose amount for the medication as specified by the user in the orders activity. |
|
|
| 50 |
DOSE_UNIT_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the dose unit of a medication. |
| The category values for this column were already listed for column: HV_DOSE_UNIT_C_NAME |
|
|
| 51 |
IS_PENDING_ORD_YN |
VARCHAR |
No |
|
|
|
| Indicates whether the order has a pending status. A Y indicates that the order does have a pending status. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
|
|
| 52 |
BULK_DISP_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this is a bulk dispense order. A Y indicates this is a bulk dispense order. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 53 |
PROVIDER_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| The medication provider type category number for the order. This item distinguishes between authorizing and documenting provider types for historical and non-historical medications. If the medication was ordered as historical, the provider is considered the documenting provider and is reflected as such in this item. If the medication was not ordered as historical, the provider is considered the authorizing provider is reflected in this item as such. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Authorizing |
| Documenting |
|
|
| 54 |
MODIFY_TRACK_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the flag that both indicates and distinguishes whether an order was reordered or modified. |
| May contain organization-specific values: No |
| Category Entries: |
| REORDERED |
| MODIFIED |
|
|
| 55 |
SPECIFIED_FIRST_TM |
DATETIME (Local) |
No |
|
|
|
| If the order was placed with a Specified frequency (the frequency's Type (I EFQ 50) item has a value of 1) and the user specified a first occurrence time, the time specified is stored in this column. |
|
|
| 56 |
SCHED_START_TM |
DATETIME (Local) |
No |
|
|
|
| The date and time at which an order was scheduled to begin. The date appears in calendar format. |
|
|
| 57 |
ACT_ORDER_C_NAME |
VARCHAR |
No |
|
|
|
| The category number indicating additional information about an order's status--Active, Completed, Discontinued, or Cancelled. An active order is any order that has not been completed, discontinued, cancelled, pended, or signed and held. |
| May contain organization-specific values: No |
| Category Entries: |
| Active Medication |
| Active Procedure |
| Discontinued Medication |
| Canceled Procedure |
| Completed Medication |
| Completed Procedure |
|
|
| 58 |
EXP_AFT_START_DATE |
DATETIME |
No |
|
|
|
| The number of days after the start date that the medication order will expire based on the setting in the medication record. The date appears in calendar format. |
|
|
| 59 |
EXP_BEF_END_DATE |
DATETIME |
No |
|
|
|
| The number of days before the end date that the medication order will expire based on the setting in the medication record. The date appears in calendar format. |
|
|
| 60 |
MED_COMMENTS |
VARCHAR |
No |
|
|
|
| Comments for a medication order, as entered by the ordering user when entering the order. |
|
|
| 61 |
USER_SEL_MED_ID_MEDICATION_NAME |
VARCHAR |
No |
|
|
|
| The name of this medication record. |
|
|
| 62 |
USER_SEL_ERX_DAT |
DATETIME |
No |
|
|
|
| The date that the medication record was actually selected by the user. This item is populated only if Intelligent Medication Selection (IMS) replaced the original user-selected medication with another medication record. |
|
|
| 63 |
REQ_RNVERIFY_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this medication order requires RN verification before it is administered. A Y indicates that it does require RN verification. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 64 |
MDL_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the medication problem list record that is associated with this medication order. This column is frequently used to link to the MDL_MD_PRBLM_LIST table. |
|
|
| 65 |
LASTDOSE |
VARCHAR |
No |
|
|
|
| Comments for the last administered dose of a medication entered in the medication documentation navigator section. |
|
|
| 66 |
INFORMANT_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the informant of a prior to admission (PTA) medication. The informant is the person who reports a PTA medication being taken by the patient. |
| May contain organization-specific values: Yes |
|
|
| 67 |
AMB_MED_DISP_NAME |
VARCHAR |
No |
|
|
|
| The name of the ambulatory medication. |
|
|
| 68 |
WEIGHT_BASED_YN |
VARCHAR |
No |
|
|
|
| Indicates whether the dose for this medication order is based on the patient's weight. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 69 |
WEIGHT_REVIEW_YN |
VARCHAR |
No |
|
|
|
| Indicates whether or not the patient's weight needs to be reviewed for this medication order due to the patient's weight change. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 70 |
ORD_TM_WEIGHT |
NUMERIC |
No |
|
|
|
| The patient's last reviewed weight at the time the medication was ordered. |
|
|
| 71 |
ORDER_TIME_WT_INST |
DATETIME (Local) |
No |
|
|
|
| The date and time when a new weight is recorded for a patient for a weight based medication review. |
|
|
| 72 |
REVIEW_WEIGHT |
NUMERIC |
No |
|
|
|
| The patient's last non-reviewed weight at the time the medication was ordered. |
|
|
| 73 |
REVIEW_WEIGHT_INST |
DATETIME (Local) |
No |
|
|
|
| The instant when the patient's last non-reviewed weight was entered prior to when the medication was ordered. |
|
|
| 74 |
REFILLS_REMAINING |
NUMERIC |
No |
|
|
|
| The number of refills remaining in the medication. |
|
|
| 75 |
MED_REFILL_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
| The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
| 76 |
OLD_ORDER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the order record that points to the parent medication for refills. |
|
|
| 77 |
OLD_ORDER_DAT |
VARCHAR |
No |
|
|
|
| The internal contact date of the parent medication in integer format. Used to identify the parent medication and will only be populated for child orders. This does not link to CONTACT_DATE_REAL. |
|
|
| 78 |
RESUME_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The category number that indicates an outpatient medication order's status before it was suspended as a result on inpatient admission. |
| The category values for this column were already listed for column: ORDER_STATUS_C_NAME |
|
|
| 79 |
USER_ID_OF_PROV |
VARCHAR |
No |
|
|
|
| The unique ID of the user record that is linked to the provider ID in the AUTHRZING_PROV_ID column. |
|
|
| 80 |
ORDERING_MODE_C_NAME |
VARCHAR |
No |
|
|
|
| The category number for the ordering mode of the order (i.e. Outpatient, Inpatient). Note that Outpatient orders can be placed from an Inpatient encounter as discharge orders / take-home prescriptions. This column might be blank for Outpatient orders placed prior to the creation of the IP module. |
| May contain organization-specific values: No |
| Category Entries: |
| Outpatient |
| Inpatient |
|
|
| 81 |
PEND_APPROVE_FLAG_C_NAME |
VARCHAR |
No |
|
|
|
| The pending medication approval status category number for the order. |
| May contain organization-specific values: No |
| Category Entries: |
| Approved |
| Refused |
|
|
| 82 |
NF_POST_VERIF_YN |
VARCHAR |
No |
|
|
|
| Indicates whether a medication order has been verified by the pharmacist as non-formulary. A Y indicates that the pharmacist verified the medication order as non-formulary. An administrator can use this column to report on how many orders that were placed as non-formulary were also verified as such. To find which orders were placed as non-formulary, use the NON_FORMULARY_YN column. |
| The category values for this column were already listed for column: REQ_RNVERIFY_YN |
|
|
| 83 |
EXT_ELG_SOURCE_ID |
VARCHAR |
No |
|
|
|
| External eligibility source ID |
|
|
| 84 |
EXT_ELG_MEMBER_ID |
VARCHAR |
No |
|
|
|
| External eligibility member ID |
|
|
| 85 |
EXT_FORMULARY_ID |
VARCHAR |
No |
|
|
|
|
| 86 |
EXT_COVERAGE_ID |
VARCHAR |
No |
|
|
|
|
| 87 |
EXT_COPAY_ID |
VARCHAR |
No |
|
|
|
| This column contains the external copay ID for an order. |
|
|
| 88 |
EXT_PHARMACY_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| External pharmacy type |
| May contain organization-specific values: Yes |
| Category Entries: |
| Retail |
| Mail Order |
| Retail+Mail |
|
|
| 89 |
EXT_FORMULARY_STAT |
VARCHAR |
No |
|
|
|
| External Formulary Status |
|
|
| 90 |
EXT_COV_AGE_LMT_YN |
VARCHAR |
No |
|
|
|
| External coverage age limits |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 91 |
EXT_COV_EXCLUS_YN |
VARCHAR |
No |
|
|
|
| External coverage product coverage exclusion |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 92 |
EXT_COV_SEX_LMT_YN |
VARCHAR |
No |
|
|
|
| External coverage gender limits |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 93 |
EXT_COV_MED_NCST_YN |
VARCHAR |
No |
|
|
|
| External coverage medical necessity |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 94 |
EXT_COV_PRI_AUTH_YN |
VARCHAR |
No |
|
|
|
| External coverage prior authorization |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 95 |
EXT_COV_QNTY_LMT_YN |
VARCHAR |
No |
|
|
|
| External coverage quantity limits |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 96 |
EXT_COV_LNK_DRUG_YN |
VARCHAR |
No |
|
|
|
| External coverage resource link drug |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 97 |
EXT_COV_LNK_SMRY_YN |
VARCHAR |
No |
|
|
|
| External coverage resource link summary |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 98 |
EXT_COV_STEP_MED_YN |
VARCHAR |
No |
|
|
|
| External coverage step medication |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 99 |
EXT_COV_STEP_THR_YN |
VARCHAR |
No |
|
|
|
| External coverage step therapy |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 100 |
USR_SEL_IMS_YN |
VARCHAR |
No |
|
|
|
| This item stores whether the product to use with IMS was selected by the user or chosen automatically. Yes means the user chose the product, No means the product was selected automatically. |
| The category values for this column were already listed for column: REQ_RNVERIFY_YN |
|
|
| 101 |
INDICATION_COMMENTS |
VARCHAR |
No |
|
|
|
| The comment entered for the indications of use for this order. |
|
|
| 102 |
DOSE_ADJ_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| The type of dose adjustment that was triggered by the order (i.e. maximum or minimum dose). |
| May contain organization-specific values: No |
| Category Entries: |
| Maximum Dose |
| Minimum Dose |
| Minimum and Maximum Adjustment |
|
|
| 103 |
DOSE_ADJ_OVERRID_YN |
VARCHAR |
No |
|
|
|
| This item indicates whether the dose adjustment (i.e. maximum or minimum dose) was overridden. |
| The category values for this column were already listed for column: REQ_RNVERIFY_YN |
|
|
| 104 |
MAX_DOSE |
NUMERIC |
No |
|
|
|
| The maximum allowed dose for this medication order. |
|
|
| 105 |
MAX_DOSE_UNIT_C_NAME |
VARCHAR |
No |
|
|
|
| The unit for the maximum allowed dose for this medication order. |
| The category values for this column were already listed for column: HV_DOSE_UNIT_C_NAME |
|
|
| 106 |
PRN_COMMENT |
VARCHAR |
No |
|
|
|
| The user-entered comments for why the as needed (PRN) medication should be administered. |
|
|
| 107 |
INST_OF_UPDATE_TM |
DATETIME (Local) |
No |
|
|
|
| The day and time the order record was last updated. |
|
|
| 108 |
PEND_ACTION_C_NAME |
VARCHAR |
No |
|
|
|
| The manner in which the medication was reordered, such as reorder from order review or reorder from the medications activity. |
| May contain organization-specific values: No |
| Category Entries: |
| Change |
| Reorder |
| Request From Existing |
| Request From Preference List |
| Reorder from Medication Activity |
| Reorder from Order Review |
| Reorder from Reports |
|
|
| 109 |
MED_DIS_DISP_QTY |
NUMERIC |
No |
|
|
|
| This item stores the discrete dispense quantity when discrete dispense is enabled. |
|
|
| 110 |
MED_DIS_DISP_UNIT_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the discrete dispense unit when discrete dispense is enabled. |
| The category values for this column were already listed for column: HV_DOSE_UNIT_C_NAME |
|
|
| 111 |
END_BEFORE_CMP_INST |
DATETIME (Local) |
No |
|
|
|
| The default end date and time of a completed order. When an order is completed, we will store the system calculated end date and time (which may differ from the actual completion time) in this column in the event the completion is reversed and the defaults need to be restored. |
|
|
| 112 |
BSA_BASED_YN |
VARCHAR |
No |
|
|
|
| Indicates whether the dose for this medication order is based on the patient's body surface area (BSA). |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 113 |
BSA_REVIEW_YN |
VARCHAR |
No |
|
|
|
| Flags orders that need to be reviewed because of a BSA change. |
| The category values for this column were already listed for column: DISP_AS_WRITTEN_YN |
|
|
| 114 |
ORD_TM_BSA |
NUMERIC |
No |
|
|
|
| The patient's last reviewed BSA at the time this order was placed. |
|
|
| 115 |
REVIEW_BSA |
NUMERIC |
No |
|
|
|
| The patient's last non-reviewed body surface areas (BSA) at the time the medication was ordered. |
|
|
| 116 |
LAST_DOSE_TIME |
VARCHAR |
No |
|
|
|
| Store the time that a PTA med was last taken. |
|
|
