AUTO_CREDIT_IND |
DOUBLE |
N |
Used to determine if auto crediting should be performed on this order when the order gets end-stated. |
CART_FILL1_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
CART_FILL2_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
CART_FILL3_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
CART_FILL_DOSES1 |
DOUBLE |
Y |
This is the number of doses calculated to fill from the last batch fill that was ran. |
CART_FILL_DOSES2 |
DOUBLE |
Y |
This is the number of doses calculated to fill from the last batch fill that was ran. |
CART_FILL_DOSES3 |
DOUBLE |
Y |
This is the number of doses calculated to fill from the last batch fill that was ran. |
CART_FILL_DT_TM1 |
DATETIME |
Y |
The from cycle date time specified by the fill batch from which this order qualified. |
CART_FILL_DT_TM2 |
DATETIME |
Y |
The from cycle date time specified by the fill batch from which this order qualified. |
CART_FILL_DT_TM3 |
DATETIME |
Y |
The from cycle date time specified by the fill batch from which this order qualified. |
CART_FILL_RUN_ID1 |
DOUBLE |
Y |
The run_id assigned to this fill batch run. The run_id will be on the fill_print_hx table. |
CART_FILL_RUN_ID2 |
DOUBLE |
Y |
The run_id assigned to this fill batch run. The run_id will be on the fill_print_hx table. |
CART_FILL_RUN_ID3 |
DOUBLE |
Y |
The run_id assigned to this fill batch run. The run_id will be on the fill_print_hx table. |
CLAIM_FLAG |
DOUBLE |
Y |
Is there a claim on this order?0 - No claim; 1 - Claim |
COB_IND |
DOUBLE |
Y |
Indicates if Coordination of benefits was used during the claim submission. |
DAW_CD |
DOUBLE |
N |
dispense as written code |
DAYS_SUPPLY |
DOUBLE |
Y |
Number of days the order will supply. |
DEPT_STATUS_CD |
DOUBLE |
N |
Order status - department level |
DISPENSE_CATEGORY_CD |
DOUBLE |
N |
Code value for the dispense category of the order |
DISPLAY_LINE |
VARCHAR(255) |
Y |
order detail display line, similar to order sentence. |
ENCNTR_ID |
DOUBLE |
N |
encounter identifier value |
ERX_MSG_LONG_TEXT_ID |
DOUBLE |
Y |
long_text_id associated to the electronic prescription message on the long_text table |
EXPIRE_DT_TM |
DATETIME |
Y |
expire date and time value |
EXPIRE_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
FILL_NBR |
DOUBLE |
Y |
Contains the fill number for this order. |
FLOORSTOCK_IND |
DOUBLE |
Y |
Indicates whether this order is dispensed from floorstock |
FLOORSTOCK_OVERRIDE_IND |
DOUBLE |
Y |
The floorstock override indicator overrides the number inventory dispensing logic and instructs the fill process not to fill the order from the Pharmacy inventory but from the floorstock (nursing station). |
FREQUENCY_ID |
DOUBLE |
N |
The frequency id is used to find the frequency_schedule information which specifies the interval at which the order should be dispensed. |
FUTURE_LOC_FACILITY_CD |
DOUBLE |
N |
Estimated facility for an order in a future status. Field value reverts to zero once the order is no longer a future order. |
FUTURE_LOC_NURSE_UNIT_CD |
DOUBLE |
N |
Estimated nurse unit location for an order in a future status. Field value reverts to zero once the order is no longer a future order. |
HEALTH_PLAN_ID |
DOUBLE |
N |
Contains the health plan related to this order. |
IGNORE_IND |
DOUBLE |
Y |
The Ignore Indicator is used to temporarily mark an order not to qualify for a fill list. 1 = ignore (skip fill), 0 = fill as instructed. |
IV_SET_SIZE |
DOUBLE |
Y |
The IV Set Size is denormalized from the order_details and specifies the number of IV bags that are in a set. |
LAST_CLIN_REVIEW_ACT_SEQ |
DOUBLE |
N |
Sequence corresponding to the action sequence of the last action clinically reviewed. |
LAST_CLIN_REVIEW_INGR_SEQ |
DOUBLE |
N |
Sequence corresponding to the action sequence of the last existing set of ingredients clinically reviewed. |
LAST_FILL_ACT_SEQ |
DOUBLE |
Y |
Last action sequence for fill list |
LAST_FILL_DISPENSE_HX_ID |
DOUBLE |
N |
Contains the dispense ID for the last fill run on this order. (Related to (Inpatient) workflow). Identifies a dispense of a single order or dose on the dispense hx table. |
LAST_FILL_HX_ID |
DOUBLE |
N |
Identifies the id for the last batch or fill run on this order. |
LAST_FILL_INGR_SEQ |
DOUBLE |
Y |
Contains the last ingredient sequence to be filled |
LAST_FILL_STATUS |
DOUBLE |
Y |
Order status when the last fill was run. |
LAST_PBS_DRUG_UUID |
VARCHAR(255) |
Y |
The drug UUID of the item used in the most recent dispense. |
LAST_PBS_ITEM_CODE |
VARCHAR(10) |
Y |
The pbs code of the item used in the most recent dispense. |
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. |
LAST_RX_DISPENSE_HX_ID |
DOUBLE |
N |
Stores the dispense_hx_id of the last fill performed on the order. (Related to PharmNet Ambulatory (Retail) flow) |
LAST_VER_ACT_SEQ |
DOUBLE |
Y |
Last verified action sequence |
LAST_VER_INGR_SEQ |
DOUBLE |
Y |
Last verified ingredient sequence |
LEGAL_STATUS_CD |
DOUBLE |
N |
Legal Status Code |
NEED_RX_PROD_ASSIGN_FLAG |
DOUBLE |
N |
Flag for identifying whether the order's product assignment has been completed or not. |
NEED_RX_VERIFY_IND |
DOUBLE |
Y |
Indicator on whether Pharmacy needs to verify this order. (from Orders table) |
NEXT_DISPENSE_DT_TM |
DATETIME |
Y |
Time stamp for when next dose is to be dispensed |
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. |
NEXT_IV_SEQ |
DOUBLE |
Y |
Next IV sequence to be dispensed |
ORDER_COST_VALUE |
DOUBLE |
Y |
The order cost is denormalized from the order_details and represents the define cost of the order. |
ORDER_DISPENSE_IND |
DOUBLE |
Y |
Indicates if this order is dispensable (1) or not (0). |
ORDER_ID |
DOUBLE |
N |
The unique identifier for the order |
ORDER_PRICE_VALUE |
DOUBLE |
Y |
The order price is denormalized from the order_details and generally represents the price for each doses that will be charged. |
ORDER_TYPE |
DOUBLE |
Y |
Order type indicates whether the order is med, continuous, or intermittent. |
OWE_QTY |
DOUBLE |
Y |
Contains the latest quantity (of medication) owed to the patient on a fill. |
PARENT_ORDER_ID |
DOUBLE |
N |
This field contains the Order_ID of the prescription placed in Easy Script that was used to create the current order. |
PAR_DOSES |
DOUBLE |
Y |
PAR doses is denormalized from the order_details and specifies the number of doses on average that should be dispensed for a 24 hour period. |
PATIENT_MED_IND |
DOUBLE |
N |
Indicates whether the order is a patient's own med. |
PERSON_ID |
DOUBLE |
N |
Person ID |
PHARM_TYPE_CD |
DOUBLE |
N |
Pharmacy type code of the order (e.g. Inpatient, Ambulatory, etc.) |
PRICE_CODE_CD |
DOUBLE |
N |
Contains the price code detail from order details. |
PRICE_SCHEDULE_ID |
DOUBLE |
N |
The price schedule id is denormalized from the order_detail table and contains information about which price schedule to use for calculating billing. |
PRINT_IND |
DOUBLE |
Y |
Indicates whether this order is printable on batch fill output or whether this order can be skipped from being printed. Pharmacy order entry initially sets all orders as "printable" (true) and the fill process may later update the value to "not printable" (false) |
PRN_IND |
DOUBLE |
Y |
Indicates if this is a prn order |
PROFILE_DISPLAY_DT_TM |
DATETIME |
Y |
Display date and time |
QTY_REMAINING |
DOUBLE |
Y |
Contains the remaining quantity of the order. |
REFILLS_REMAINING |
DOUBLE |
Y |
Remaining refills for this order. |
REPLACE_EVERY |
DOUBLE |
Y |
Replace Every is a numeric value representing the time interval at which the order should be replaced (dosed). The units associated with the replace_every value are contain in the replace_every_unit_cd column. |
REPLACE_EVERY_CD |
DOUBLE |
N |
Replace Every Code Value determines the units the replace_every column is representing. i.e. Minutes, Hours, Days, Weeks. |
RESEARCH_ACCOUNT_ID |
DOUBLE |
N |
The research account that the order will be billed against. |
RESUME_DT_TM |
DATETIME |
Y |
Date and time the order was resumed. |
RESUME_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
REVIEWED_PARENT_ACTION_SEQ |
DOUBLE |
N |
This field contains the action sequence of the parent order that was reviewed by the user that performed the latest fill on the current order. |
RXA_ERX_MULTICHILD_IND |
DOUBLE |
N |
indicates whether the child Retail order is a part of multiple child orders or regular order. |
RXA_PRESCRIPTION_MSG_ID |
DOUBLE |
Y |
The unique identifier for the electronic prescription message associated to the external prescription |
RXA_SIG_OVERRIDE_IND |
DOUBLE |
N |
Indicates whether user has manually overridden the Sig that was automatically expanded by the system based on Sig codes. |
RX_NBR |
DOUBLE |
Y |
prescription number |
RX_NBR_CD |
DOUBLE |
N |
Prescription number code |
SOURCE_PARENT_ACTION_SEQ |
DOUBLE |
N |
This field contains the action sequence of the parent order that was used as the source to create the current order. |
START_DISPENSE_DT_TM |
DATETIME |
Y |
Date and time the order will start dispensing. |
START_DISPENSE_TZ |
DOUBLE |
N |
Time zone associated with the corresponding start_dispense_dt_tm field. |
STOP_DT_TM |
DATETIME |
Y |
Date and time the order was discontinued |
STOP_TYPE_CD |
DOUBLE |
N |
Stop type code, indicates whether stop was hard, soft, etc. |
STOP_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
SUSPEND_DT_TM |
DATETIME |
Y |
Date and time the order was suspended. |
SUSPEND_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
TOTAL_DISPENSE_DOSES |
DOUBLE |
Y |
Cumulative counter for number of doses dispensed (administrations) |
TOTAL_RX_QTY |
DOUBLE |
Y |
Quantity total from order details. |
TRANSFER_CNT |
DOUBLE |
Y |
transfer count |
UNVERIFIED_ACTION_TYPE_CD |
DOUBLE |
N |
Identifies the action that was performed. (from order_action) |
UNVERIFIED_COMM_TYPE_CD |
DOUBLE |
N |
Identifies the communication type of the order. (from order_action) |
UNVERIFIED_ROUTE_CD |
DOUBLE |
N |
Identifies the route of administration on a medication order (from order_detail table) |
UNVERIFIED_RX_ORD_PRIORITY_CD |
DOUBLE |
N |
Identifies the pharmacy order priority. (from order_detail table) |
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. |
WORKFLOW_CD |
DOUBLE |
N |
Indicates the workflow sequence of an order. Used to route orders to workflow monitor. |