ACTION_SEQUENCE |
DOUBLE |
Y |
which action sequence the comment goes with |
ADMIN_COUNT |
DOUBLE |
Y |
counter for number of administrations for this order |
ADMIN_DT_TM |
DATETIME |
Y |
administration date and time |
ADMIN_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
ADMIT_DT_TM |
DATETIME |
Y |
admission date and time |
ADMIT_PHYS_ID |
DOUBLE |
N |
Admitting physician ID number |
ADMIT_PHYS_NAME |
VARCHAR(50) |
Y |
Name of the admitting physician. |
ADMIT_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
ATTEND_PHYS_ID |
DOUBLE |
N |
Attending Physicians ID number. |
ATTEND_PHYS_NAME |
VARCHAR(50) |
Y |
Name of the attending physician. |
AUTHORIZATION_NBR |
VARCHAR(50) |
Y |
Alpha numeric string returned by Claims Processor for Accepted Claims. |
BAG_NBR |
DOUBLE |
Y |
Bag number in IV set. |
BASAL_RATE_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the Basal Rate Unit |
BASAL_RATE_UNIT_S |
VARCHAR(40) |
Y |
Display value for the Basal Rate Unit. |
BASAL_RATE_VALUE |
DOUBLE |
Y |
The amount of drug given as a continuous infusion. |
BED_CD |
DOUBLE |
N |
Patients bed code value |
BED_S |
CHAR(40) |
Y |
Patients bed description |
BIRTH_DT_TM |
DATETIME |
Y |
Patient"s Birth Date |
BIRTH_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
BRAND_NAME |
VARCHAR(50) |
Y |
Brand name of product |
BSA |
DOUBLE |
Y |
Body Surface Area |
BSA_UNIT_CD |
DOUBLE |
N |
Unit of measure for body surface area |
BSA_UNIT_S |
VARCHAR(40) |
Y |
Display value for BSA unit code |
CDM |
VARCHAR(25) |
Y |
A unique number that can be tied to a drug (or other things that may be billed to a patient) in order to associate a charge with it |
CHARGE_QTY |
DOUBLE |
Y |
Quantity charged. |
CLINICIAN_DOSE_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the Clinician Dose Unit. |
CLINICIAN_DOSE_UNIT_S |
VARCHAR(40) |
Y |
Display value for the Clinician Dose Unit. |
CLINICIAN_DOSE_VALUE |
DOUBLE |
Y |
Prescribed dose that can be given at the discretion of the patient care provider. |
COMMENT1_WHERE_TO_PRINT |
DOUBLE |
Y |
Specifies whether comment 1 will print on label, MAR, and/or fill. |
COMMENT2_WHERE_TO_PRINT |
DOUBLE |
Y |
Specifies whether comment 2 will print on label, MAR, and/or fill. |
COMMUNICATION_TYPE_CD |
DOUBLE |
N |
Code value representing the communication type for an order. |
COMMUNICATION_TYPE_S |
VARCHAR(60) |
Y |
Description of orders communication type. |
COMPOUND_IND |
DOUBLE |
Y |
Indicates that the Order is a compound order (Compounded with multiple ingredients.) |
COMPOUND_TEXT_ID |
DOUBLE |
N |
Instructions for compounding |
COMPOUND_TOTAL |
DOUBLE |
Y |
Compound Total |
CONCENTRATION |
DOUBLE |
N |
For continuous infusions, the amount of a component in a given volume. |
CONCENTRATION_UNIT_CD |
DOUBLE |
N |
Concentration unit of measure code value. |
CONCENTRATION_UNIT_S |
VARCHAR(40) |
Y |
Display value for concentration unit of measure. |
CONTAINER_SEQ |
DOUBLE |
Y |
The sequence of the container this row is associated to. Will only be greater than 0 for rows denoting products of split container dispense events. |
CONTROL_NUMBER |
VARCHAR(25) |
Y |
A number Pharmacy uses when dispensing controlled substances. |
COPAY |
DOUBLE |
Y |
Co pay amount |
CRCL |
DOUBLE |
Y |
Most recent result for serum creatinine |
CRCL_UNIT_CD |
DOUBLE |
N |
Unit of measure for creatinine clearance. |
CRCL_UNIT_S |
VARCHAR(40) |
Y |
Display value for Creatinine Clearance unit code |
CREDIT_INV_IND |
DOUBLE |
Y |
Identifies an Order that was credited during Net Cart event, but wasn't returned in Inventory. |
CREDIT_QTY |
DOUBLE |
Y |
Quantity credited. |
CUR_DISP_LOC_CD |
DOUBLE |
N |
Dispense from location code for the current event. |
CUR_DISP_LOC_S |
VARCHAR(40) |
Y |
Display Value of the location code for the current event. |
DAW_CD |
DOUBLE |
N |
Dispense as written code |
DAYS_SUPPLY |
DOUBLE |
Y |
Number of days the quantity dispensed (given to the patient) will last. |
DISPENSE_CATEGORY_CD |
DOUBLE |
N |
Dispense category code. |
DISPENSE_CATEGORY_S |
CHAR(40) |
Y |
Dispense category. |
DISPENSE_COMMENT_TEXT_ID |
DOUBLE |
Y |
Long_text_id of the dispense comment. Originally written to the order_comment table with comment_type_cd of "RXADISPNOTE". |
DISPENSE_DEVICE_IND |
DOUBLE |
Y |
Dispense device indicator. 0 = this dispense event was not passed to a dispense device; 1 = this dispense event was passed to a dispense device. |
DISPENSE_DT_TM |
DATETIME |
Y |
Dispense date and time |
DISPENSE_FROM_CD |
DOUBLE |
N |
Code value representing the location that an order is dispensed from. |
DISPENSE_FROM_S |
VARCHAR(60) |
Y |
Display value for the location code from which an order is dispensed. |
DISPENSE_ID |
DOUBLE |
N |
Dispense Id for this order and dispense |
DISPENSE_LOC_CD |
DOUBLE |
N |
Location where the last initial dose came from |
DISPENSE_SR_CD |
DOUBLE |
N |
Dispense Service Resource code |
DISPENSE_STATUS_HX_ID |
DOUBLE |
N |
Dispense Status Hx id |
DISPENSE_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. For inpatient rows, this is the time zone of the encounter. For Retail Pharmacy, it is the time zone of the pharmacy's facility. |
DISP_PRIORITY_CD |
DOUBLE |
N |
dispense Priority Cd |
DISP_PRIORITY_DT_TM |
DATETIME |
Y |
Dispense Priority Date and tiem |
DISP_PRIORITY_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
DISP_QTY |
DOUBLE |
Y |
Dispense Quantity |
DISP_QTY_UNIT_CD |
DOUBLE |
N |
dispense quantityunit cd |
DOSES_OMITTED_IND |
DOUBLE |
N |
Indicates if there were doses possibly omitted in this print for this order. |
DOSE_FORM_CD |
DOUBLE |
N |
Code value representing the type of dose for an order. |
DOSE_FORM_S |
VARCHAR(60) |
Y |
Display value for the dose form (e.g.: tab, ea...) of an order. |
DOSE_LIMIT_TIME_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the Dose Limit Time Unit. |
DOSE_LIMIT_TIME_UNIT_S |
VARCHAR(40) |
Y |
Display value for the Dose Limit Time Unit. |
DOSE_LIMIT_TIME_VALUE |
DOUBLE |
Y |
Time period related to the Dose Limit value. |
DOSE_LIMIT_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the Dose Limit Unit. |
DOSE_LIMIT_UNIT_S |
VARCHAR(40) |
Y |
Display value for the Dose Limit Unit. |
DOSE_LIMIT_VALUE |
DOUBLE |
Y |
Maximum amount of medication that can be delivered over a specified time period. |
DOSE_QUANTITY |
DOUBLE |
Y |
Dose quantity. |
DOSE_QUANTITY_TXT |
VARCHAR(150) |
Y |
Textual representation of the dose quantity as received from the device. For use with orders that utilize variable dosing. |
DOSE_QUANTITY_UNIT_CD |
DOUBLE |
N |
Dose quantity unit of measure code. |
DOSE_QUANTITY_UNIT_S |
CHAR(40) |
Y |
Dose quantity unit of measure. |
DOSING_METHOD_FLAG |
DOUBLE |
N |
Indicates the type of dosing that is applied to the order. |
DUR_CONFLICT_CD |
DOUBLE |
N |
DUR Conflict Cd |
DUR_INTER_CD |
DOUBLE |
N |
Drug Utilization Review Interaction Code |
DUR_OUTCOME_CD |
DOUBLE |
N |
DUR Outcome Cd |
EARLY_REASON_CD |
DOUBLE |
N |
Early reason cd |
ELIGIBILITY_CLARIFY_CD |
DOUBLE |
N |
Clarification Code indicating patient's eligibility for the benefit. |
ENCNTR_ID |
DOUBLE |
N |
This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENTERED_DT_TM |
DATETIME |
Y |
Date and time order was entered into the system |
ENTERED_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
ENTER_USER_ID |
DOUBLE |
N |
User ID of the person who entered the order |
ENTRY_ID |
DOUBLE |
N |
ID of the person entering the order. |
ENTRY_NAME |
VARCHAR(50) |
Y |
Name of the person who entered the order. |
ERROR_LOG |
VARCHAR(100) |
Y |
Error information, if any. |
EXTRA_REASON_CD |
DOUBLE |
N |
extra reason cd |
EXT_COPAY_IND |
DOUBLE |
Y |
Used to notify external systems that a patient will be charged a copay for a prescription. |
EXT_DISP_QTY |
DOUBLE |
Y |
Dispense quantity used to send to external systems. |
EXT_DISP_QTY_CONV_FACTOR_AMT |
DOUBLE |
Y |
Client configurable dispense conversion factor within the Product Tool which is used to maintain the package size to dispense factor ratio by converting the NCPDP quantity to a quantity recognized by external systems. |
EXT_DISP_QTY_UNIT_S |
VARCHAR(60) |
Y |
Dispense quantity unit used to send to external systems. |
EXT_DRUG_DESC |
VARCHAR(200) |
Y |
Drug description used to send to external systems. |
EXT_DRUG_IDENT |
VARCHAR(200) |
Y |
Client configurable drug identifier defined in the Product Tool to be sent outbound to an external system. |
FACILITY_CD |
DOUBLE |
N |
Facility code. |
FACILITY_S |
CHAR(40) |
Y |
Facility description. |
FILL_ANCHOR_DT_TM |
DATETIME |
Y |
Fill date used to calculate the next dispense date/time. |
FILL_NBR |
DOUBLE |
Y |
A sequential number indicating the number of times a prescription got filled. |
FILL_NOTE_ID |
DOUBLE |
N |
Identifier for fill note. |
FILL_QUANTITY |
DOUBLE |
Y |
fill quantity |
FINNBR |
VARCHAR(100) |
Y |
Financial number |
FINNBR_ID |
DOUBLE |
N |
financial number ID |
FLOORSTOCK_IND |
DOUBLE |
Y |
Floorstock indicator - 1 = true, 0 = false. |
FORMULARY_STATUS_CD |
DOUBLE |
N |
Formulary status code |
FORMULARY_STATUS_S |
CHAR(40) |
Y |
Formulary status description |
FORM_CD |
DOUBLE |
N |
Dosage form code. |
FORM_S |
CHAR(40) |
Y |
Dosage form description |
FREETEXT_DOSE |
VARCHAR(50) |
Y |
Free-text dose information. |
FREETEXT_RATE |
VARCHAR(255) |
Y |
Text representing the rate for an order entered by user. |
FREQUENCY_CD |
DOUBLE |
N |
Frequency code. |
FREQUENCY_S |
CHAR(40) |
Y |
Frequency description |
FUTURE_ORDER_IND |
DOUBLE |
N |
Indication of whether or not the order is in a future status at the time the dispense occurred. |
GEN_NAME |
VARCHAR(200) |
Y |
Generic name of the product |
HEALTH_PLAN_ID |
DOUBLE |
N |
Display name of the health plan. |
HEALTH_PLAN_S |
VARCHAR(40) |
Y |
Display (Name) of the Health Plan |
HEIGHT |
DOUBLE |
Y |
Patient"s height |
HEIGHT_UNIT_CD |
DOUBLE |
N |
Unit of measure patients height is measured in. |
HEIGHT_UNIT_S |
CHAR(40) |
Y |
Unit of measure patients height is measured in. |
IBW |
DOUBLE |
Y |
Ideal Body Weight |
IBW_UNIT_CD |
DOUBLE |
N |
Unit of measure for Ideal Body Weight. |
IBW_UNIT_S |
VARCHAR(40) |
Y |
Display value for Ideal Body Weight unit code. |
ICD9_ID |
DOUBLE |
N |
Nomenclature ID for the ICD9 code. |
ICD9_S |
VARCHAR(100) |
Y |
ICD9_s |
IGNORE_IND |
DOUBLE |
Y |
No longer in use. |
INFUSE_OVER |
DOUBLE |
Y |
Time the IV will be infused over. |
INFUSE_UNIT_CD |
DOUBLE |
N |
Unit of measure code IV infusion time is measured in. |
INFUSE_UNIT_S |
CHAR(40) |
Y |
Unit of measure description IV infusion time is measured in. |
INGRED_CNT |
DOUBLE |
Y |
Number of ingredients in order. |
INGRED_DESC |
VARCHAR(200) |
Y |
Description of ingredient. |
INGRED_SEQ |
DOUBLE |
Y |
The identifier for the ingredient |
INS_CD |
DOUBLE |
N |
Insurance Code |
INS_POLICY |
CHAR(40) |
Y |
Insurance Policy |
ITEM_ID |
DOUBLE |
N |
The unique identifier for the product. |
IV_IN_SEQ |
DOUBLE |
Y |
IV set rotation, Alternate IV. |
IV_SET_SIZE |
DOUBLE |
Y |
Number of bags in IV set. |
LABEL1_ID |
DOUBLE |
N |
Identifier for label 1 text |
LABEL2_ID |
DOUBLE |
N |
Identifier for label 2 text |
LABEL_DESC |
VARCHAR(200) |
Y |
Description for label |
LABEL_REASON_CD |
DOUBLE |
N |
Reason for printing label code (fill, reprint, printer jam, etc.). |
LABEL_REASON_S |
CHAR(40) |
Y |
Reason for printing label description (fill, reprint, printer jam, etc.). |
LABEL_TYPE_CD |
DOUBLE |
N |
Label type that will be created when the row is printed. |
LANGUAGE_CD |
DOUBLE |
N |
Patient's Language |
LAST_REFILL_DT_TM |
DATETIME |
Y |
Last Refill date and time |
LAST_REFILL_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
LATE_REASON_CD |
DOUBLE |
N |
late reason cd |
LBL_ID |
DOUBLE |
N |
Column Not Used |
LEGAL_STATUS_CD |
DOUBLE |
N |
DEA schedule code, etc. |
LEGAL_STATUS_S |
CHAR(40) |
Y |
DEA schedule description, etc. |
LOADING_DOSE_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the Loading Dose Unit. |
LOADING_DOSE_UNIT_S |
VARCHAR(40) |
Y |
Display value for the Loading Dose Unit. |
LOADING_DOSE_VALUE |
DOUBLE |
Y |
Dose ordered to initiate medication treatment. This dose is typically larger than PCA dose |
LOCATION_CD |
DOUBLE |
N |
Patient"s location code (nursing station). |
LOCATION_S |
CHAR(40) |
Y |
Patient"s location (nursing station). |
LOCKOUT_INT_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the Lockout Interval Unit. |
LOCKOUT_INT_UNIT_S |
VARCHAR(40) |
Y |
Display value for the Lockout Interval Unit. |
LOCKOUT_INT_VALUE |
DOUBLE |
Y |
The time interval before the pump can provide the next PCA dose. |
LOT_TRACKING_IND |
DOUBLE |
N |
Indicates whether or not lot tracking should be required for this item. |
MANF_CD |
DOUBLE |
N |
manufacturer code |
MEDREC_NBR |
VARCHAR(100) |
Y |
Med rec number |
MEDREC_NBR_ID |
DOUBLE |
N |
Med rec number ID |
MED_FIN_IND |
DOUBLE |
Y |
Indicator to display med rec number or financial number |
MED_PRODUCT_ID |
DOUBLE |
N |
med Product Id |
ML_HR |
DOUBLE |
Y |
IV rate |
MULTUM_PIL_IDENT |
VARCHAR(20) |
Y |
Identifies the multum DNUM or MMDC identifier based on whether the prescribed drug has patient information leaflet data defined in the multum drug database. If MMDC has PIL information available, MMDC will be written. Otherwise, if DNUM has PIL information available, DNUM will be written. |
NBR_OF_REFILLS |
DOUBLE |
Y |
Number of refills allowed |
NDC |
VARCHAR(30) |
Y |
NDC Number |
NET_CART_IND |
DOUBLE |
Y |
Indication to indicate that a change has occurred to the quantity on the cart. |
NET_CART_QTY |
DOUBLE |
Y |
If order is changed, this field will contain the difference the human will need to change the quantity on the cart by. |
NEXT_DISPENSE_DT_TM |
DATETIME |
Y |
next dispense date/time |
NEXT_DISPENSE_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. For inpatient rows, this is the time zone of the encounter. For Retail Pharmacy, it is the time zone of the pharmacy's facility. |
NORMALIZED_RATE |
DOUBLE |
N |
In the context of a continuous infusion, the amount of a medication to be administered per time unit (e.g., mg/hour), or the amount of a medication to be administered per patient weight unit per time unit (e.g., mcg/kg/minute). |
NORMALIZED_RATE_UNIT_CD |
DOUBLE |
N |
Normalized rate unit of measure code value. |
NORMALIZED_RATE_UNIT_S |
VARCHAR(40) |
Y |
Display value for normalized rate unit of measure. |
ORDERED_AS_MNEMONIC |
VARCHAR(100) |
Y |
Text representing the name by which an ingredient was ordered. |
ORDER_COMMENT_ID |
DOUBLE |
N |
Identifier representing the order comment. |
ORDER_ENTRY_LOC_CD |
DOUBLE |
N |
not in use |
ORDER_ID |
DOUBLE |
N |
Order identifier |
ORDER_PRIORITY_CD |
DOUBLE |
N |
Code value representing the order priority. |
ORDER_PRIORITY_S |
VARCHAR(60) |
Y |
Display value for the order priority. |
ORDER_ROW_SEQ |
DOUBLE |
N |
Sequence counter for the rows included with this order |
ORDER_START_DT_TM |
DATETIME |
Y |
Order start date and time. |
ORDER_START_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
ORDER_STATUS_DT_TM |
DATETIME |
Y |
Order status date/time |
ORDER_STATUS_ENUM |
DOUBLE |
Y |
Order status enumerated type |
ORDER_STATUS_S |
CHAR(40) |
Y |
Order status |
ORDER_STATUS_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
ORDER_STOP_DT_TM |
DATETIME |
Y |
Order stop date and time. |
ORDER_STOP_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
ORDER_TYPE_FLAG |
DOUBLE |
Y |
Type of this order |
ORD_COST |
DOUBLE |
Y |
Cost of the order |
ORD_DESC |
VARCHAR(100) |
Y |
Order description. |
ORD_PEND_STATUS |
CHAR(20) |
Y |
pending order status |
ORD_PHYS_ID |
DOUBLE |
N |
Identifier for ordering physician |
ORD_PHYS_NAME |
VARCHAR(50) |
Y |
Name of ordering physician |
ORD_PRICE |
DOUBLE |
Y |
Price of the order |
ORD_TYPE |
DOUBLE |
Y |
Type of order (med, IV) |
OTHER_COVERAGE_CD |
DOUBLE |
N |
other coverage code |
OUTPUT_FORMAT_CD |
DOUBLE |
N |
Code for desired output format |
OVERFILL_AMT |
DOUBLE |
Y |
Overfill Amount |
PATIENT_MED_IND |
DOUBLE |
N |
Indicates whether the order is a patient's own medication. |
PATIENT_TEXT_ID |
DOUBLE |
N |
Long text id of patient note. |
PAT_TEXT_ID |
DOUBLE |
N |
Not in use. |
PAYMENT_METHOD_CD |
DOUBLE |
N |
Payment Method |
PA_BEG_DT_TM |
DATETIME |
Y |
PA Beginning Date and time |
PA_BEG_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
PA_END_DT_TM |
DATETIME |
Y |
PA End Date and Time |
PA_END_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
PA_NUMBER |
VARCHAR(25) |
Y |
Prior Authorization Number |
PCA_DOSE_UNIT_CD |
DOUBLE |
Y |
Code value from code set 54 representing the PCA Dose Unit. |
PCA_DOSE_UNIT_S |
VARCHAR(40) |
Y |
Display value for the PCA Dose Unit. |
PCA_DOSE_VALUE |
DOUBLE |
Y |
On-demand dose delivered by pump upon patient pressing dose delivery button |
PERSON_ID |
DOUBLE |
N |
This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PERSON_NAME_S |
VARCHAR(50) |
Y |
Patients name. |
PERSON_OWE_QTY |
DOUBLE |
Y |
Amount of quantity owed to the patient on this dispense. |
PHARM_COMMENT_TEXT_ID |
DOUBLE |
Y |
Long text id of the pharmacy comment. Originally from order_comment table with comment_type_cd of "PHARM COMMEN". |
PHARM_TYPE_CD |
DOUBLE |
N |
Pharm type cd |
PHYSICIAN_DEA_TXT |
VARCHAR(50) |
Y |
The doctor's Drug Enforcement Administration number |
PKG_COUNT |
DOUBLE |
Y |
Indicates the number of packages involved in the dispense event. |
PKG_NBR |
DOUBLE |
Y |
Indicates the relative package within the dispense if multiple packages are dispensed. (i.e., 1 of 2, 2 of 2) |
PKG_QUANTITY |
DOUBLE |
Y |
Indicates the quantity in each package |
PRICE_CODE_CD |
DOUBLE |
N |
Price code code |
PRN_IND |
DOUBLE |
Y |
Indicates whether this is a prn order |
PRN_REASON_CD |
DOUBLE |
N |
Code Value representing PRN reason. |
PRN_REASON_S |
VARCHAR(60) |
Y |
String representation of the PRN reason for the order. |
PRODUCT_NOTE_ID |
DOUBLE |
N |
Identifier representing the product note. |
PRODUCT_STRENGTH_UNIT_CD |
DOUBLE |
Y |
Strength unit code value of an individual product within an order. |
PRODUCT_STRENGTH_VALUE |
DOUBLE |
Y |
Strength value of an individual product within an order. |
PRODUCT_VOLUME_UNIT_CD |
DOUBLE |
Y |
Volume unit code value of an individual product within an order. |
PRODUCT_VOLUME_VALUE |
DOUBLE |
Y |
Volume value of an individual product within an order. |
PROD_CNT |
DOUBLE |
Y |
Total number of products in the ingredient |
PROD_DESC |
VARCHAR(200) |
Y |
Description of product. |
PROXY_PRESCRIBER_ID |
DOUBLE |
N |
The proxy prescriber identifier of the prescription. |
PROXY_PRESCRIBER_NAME |
VARCHAR(50) |
Y |
The proxy prescriber name of the prescription. |
QTY_REMAINING |
DOUBLE |
Y |
Quantity remaining |
RACE_CD |
DOUBLE |
N |
code value for race |
RACE_S |
CHAR(40) |
Y |
race |
RATE |
DOUBLE |
Y |
IV rate |
REASON_FOR_USE |
VARCHAR(100) |
Y |
reason for use |
REFILLS_REMAINING |
DOUBLE |
Y |
refills remaining |
REFILL_QTY |
DOUBLE |
Y |
refill quantity |
REIMBURSEMENT |
DOUBLE |
Y |
Amount reimbursed by the health plan |
REPLACE_EVERY |
DOUBLE |
Y |
Length of time after which an IV bag should be replaced |
REPLACE_EVERY_UNIT_CD |
DOUBLE |
N |
Unit of Measure for replace_every interval |
REPLACE_EVERY_UNIT_S |
VARCHAR(40) |
Y |
Denormalized display value for replace_every_unit_cd |
REPORT_ID |
DOUBLE |
N |
Column Not Used |
ROOM_CD |
DOUBLE |
N |
Code value for room |
ROOM_S |
CHAR(40) |
Y |
room description |
ROUTE_CD |
DOUBLE |
N |
Route code. |
ROUTE_S |
CHAR(40) |
Y |
Route description |
RPH_ID |
DOUBLE |
N |
ID for pharmacist |
RPH_INITIALS |
CHAR(8) |
Y |
Pharmacist initials |
RPH_NAME |
VARCHAR(50) |
Y |
Pharmacist name |
RUN_ID |
DOUBLE |
N |
Print run identifier |
RX_EXPIRE_DT_TM |
DATETIME |
Y |
rx expire date and time |
RX_EXPIRE_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
RX_NBR |
DOUBLE |
Y |
Retail number |
RX_NBR_CD |
DOUBLE |
N |
Prescription number |
RX_NBR_IN_SET |
DOUBLE |
Y |
retail number in set |
RX_NBR_S |
VARCHAR(40) |
Y |
Formatted Prescription Number |
RX_PERSON_OWE_DOSES_CNT |
DOUBLE |
Y |
This field will populate with person owe doses associated to the order. |
RX_QTY |
DOUBLE |
Y |
rx quantity |
RX_SET_SIZE |
DOUBLE |
Y |
rx_set_size |
RX_WORKSTATION_CD |
DOUBLE |
N |
Service Resource Level 5 code (Code Set 221, CDF Meaning 'LEVEL5'). Identifies the pharmacy workstation that administered the order; entered, dispensed, etc. |
SAFETY_CAP_CD |
DOUBLE |
N |
Indicates whether or not the patient has requested a Safety Cap for their prescription |
SAFETY_CAP_S |
VARCHAR(1) |
Y |
safety_cap_s |
SCH_PRN_IND |
DOUBLE |
Y |
Indicator for prn order with scheduled times |
SCRIPT_CLARIFY_CD |
DOUBLE |
N |
Script (prescription) clarification code |
SCRIPT_ORIGIN_CD |
DOUBLE |
N |
Code indicating the origin of the prescription. |
SEX_CD |
DOUBLE |
N |
Sex code |
SEX_S |
CHAR(40) |
Y |
Sex description |
SIDE_EFFECT_CODE |
VARCHAR(10) |
Y |
Not in use at present time. |
SIG_ALT_LANG_TEXT_ID |
DOUBLE |
N |
Long Text ID for the alternate language signature instructions. |
SIG_CODES |
VARCHAR(100) |
Y |
Pharmacy signature codes (such as PO BID) |
SIG_TEXT_ID |
DOUBLE |
N |
Long Text ID for the primary or default language signature instructions. |
SKIP_DISPENSE_FLAG |
DOUBLE |
N |
A flag that indicates if the product was dispensed or skipped |
SORT_CLASS |
VARCHAR(20) |
Y |
Not in use. |
SPLIT_CONTAINER_FLAG |
DOUBLE |
Y |
Indicates whether the dispense event was associated to a split container dispense. |
STATUS_DT_TM |
DATETIME |
Y |
Status date and time |
STRENGTH |
DOUBLE |
Y |
Strength value |
STRENGTH_UNIT_CD |
DOUBLE |
N |
Code value for strength unit |
STRENGTH_UNIT_S |
CHAR(40) |
Y |
Strength unit description |
STRENGTH_WITH_OVERFILL_UNIT_CD |
DOUBLE |
N |
The strength dose unit on the product's ingredient including the overfill added during TPN balancing. |
STRENGTH_WITH_OVERFILL_UNIT_S |
VARCHAR(40) |
Y |
Display value of the strength_with_overfill unit of measure. |
STRENGTH_WITH_OVERFILL_VALUE |
DOUBLE |
N |
The strength dose on the product's ingredient including the overfill added during TPN balancing. |
SUSPEND_ROUTING_TYPE_CD |
DOUBLE |
Y |
Routing type for a suspended order. |
TECH_ID |
DOUBLE |
N |
Pharmacy tech prsnl_id that was responsible for this print. |
TECH_INITIALS |
VARCHAR(8) |
Y |
Pharmacy Tech username that was responsible for this print. |
TECH_NAME |
VARCHAR(50) |
Y |
Pharmacy tech name (full formatted) that was responsible for this print. |
TEMP_STOCK_IND |
DOUBLE |
N |
If set to 1, this was a temporary stock event. |
THER_CLASS_CODE |
VARCHAR(20) |
Y |
AHFS Code Number (e.g. 080000) |
THER_CLASS_DESC |
VARCHAR(100) |
Y |
AHFS class description (e.g. Anti-Infectives) |
THER_CLASS_ID |
DOUBLE |
N |
Key to alt_sel_cat table |
THER_CLASS_SORT_CODE |
VARCHAR(20) |
Y |
Therapeutic class of first ingredient, used for sorting. |
TITRATE_IND |
DOUBLE |
Y |
Titrate indicator; 1 = titrate, 0 = not titrate. |
TNF_ID |
DOUBLE |
N |
Key to template_non-formulary table |
TOTAL_REFILLS |
DOUBLE |
Y |
Number of times a prescription can be re-filled (does NOT include the initial fill) |
TOTAL_RX_QTY |
DOUBLE |
Y |
total rx quantity |
TOT_VOLUME |
DOUBLE |
Y |
Total volume |
TRACK_NBR |
DOUBLE |
Y |
A number to track the prescription |
TRACK_NBR_CD |
DOUBLE |
N |
TRACK nbr cd |
TRACK_NBR_S |
VARCHAR(40) |
Y |
track number s |
TRANSFER_TO_LOC_CD |
DOUBLE |
N |
Location code where stock is transferred to. |
TRANSFER_TO_LOC_S |
VARCHAR(40) |
Y |
Display value for location code where stock is transferred to. |
UC_PRICE |
DOUBLE |
Y |
Usual and Customary Price |
UNIQUE_BAG_ID |
DOUBLE |
N |
Column Not Used |
UNROUNDED_DOSE_QTY |
DOUBLE |
Y |
Product's quantity per dose prior to rounding for the product dispense. |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VERIFY_PRSNL_ID |
DOUBLE |
Y |
Personnel who created or verified the order. |
VOLUME |
DOUBLE |
Y |
Volume |
VOLUME_UNIT_CD |
DOUBLE |
N |
Volume unit of measure code. |
VOLUME_UNIT_S |
CHAR(40) |
Y |
Volume unit of measure. |
VOLUME_WITH_OVERFILL_UNIT_CD |
DOUBLE |
N |
The volume dose unit on the product's ingredient including the overfill added during TPN balancing. |
VOLUME_WITH_OVERFILL_UNIT_S |
VARCHAR(40) |
Y |
Display value of the volume_with_overfill unit of measure. |
VOLUME_WITH_OVERFILL_VALUE |
DOUBLE |
N |
The volume dose on the product's ingredient including the overfill added during TPN balancing. |
WASTE_FLAG |
DOUBLE |
Y |
Indicates this dispense event can have waste applied. |
WEIGHT |
DOUBLE |
Y |
Patient"s weight. |
WEIGHT_UNIT_CD |
DOUBLE |
N |
Unit of measure patients weight is measured in. |
WEIGHT_UNIT_S |
CHAR(40) |
Y |
Unit of measure patients weight is measured in. |