Table Detail Report

ORDER_DISPENSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: order_dispense
Definition: Store a record of dispensing for each pharmacy order dispensed
Table Type: ACTIVITY





Column Detail - ORDER_DISPENSE


Column Name Type Null? Definition
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.



Relationship Detail - ORDER_DISPENSE


Child Column in ORDER_DISPENSE(FK) Parent Table Name Parent Column Name
Parents: FUTURE_LOC_FACILITY_CD CODE_VALUE CODE_VALUE
FUTURE_LOC_NURSE_UNIT_CD CODE_VALUE CODE_VALUE
LAST_FILL_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
LAST_RX_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
LAST_FILL_HX_ID FILL_BATCH_HX FILL_HX_ID
FREQUENCY_ID FREQUENCY_SCHEDULE FREQUENCY_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ERX_MSG_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
PRICE_SCHEDULE_ID PRICE_SCHED PRICE_SCHED_ID
RESEARCH_ACCOUNT_ID RESEARCH_ACCOUNT RESEARCH_ACCOUNT_ID
RXA_PRESCRIPTION_MSG_ID RXA_PRESCRIPTION_MSG RXA_PRESCRIPTION_MSG_ID


ORDER_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: order_product
Definition: For each ingredient of a medication order store the pharmacy product(s) to dispense which satisfy this ingredient
Table Type: ACTIVITY





Column Detail - ORDER_PRODUCT


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Identifier to reference the action taken
AUTO_ASSIGN_FLAG DOUBLE N Auto assign flag
BRAND_DESC VARCHAR(100) Y brand desc for product
CMPD_BASE_IND DOUBLE Y Indicates compound base setting for product
COMPOUND_FLAG DOUBLE Y Compound flag
DISP_QTY DOUBLE Y Current Dispensable qty unit for REFILL event
DISP_QTY_UNIT_CD DOUBLE N Current Dispensable qty unit for REFILL event
DOSE_QUANTITY DOUBLE Y Value to describe this product dose
DOSE_QUANTITY_TXT VARCHAR(150) Y The concatenated string of the individual dose quantities for a variable dosed order.
DOSE_QUANTITY_UNIT_CD DOUBLE N Unit to apply to the dose quantity
DRUG_IDENTIFIER VARCHAR(100) Y Drug Id (NDC, etc.) for product
GENERIC_DESC VARCHAR(100) Y Generic desc for product
IGNORE_IND DOUBLE Y For PREMIXES, indicates whether or not to ignore current row
INGRED_SEQUENCE DOUBLE N Identifier for the ingredient
ITEM_ID DOUBLE N Reference to the medication definition pharmacy product
IV_SEQ DOUBLE Y For alternating IV"s, the place a bag holds in the series.
LABEL_DESC VARCHAR(100) Y Label desc for product
MED_PRODUCT_ID DOUBLE N Stores unique field for NDC
ON_ADMIN_IND DOUBLE N This field identifies whether or not this record was added because of Charge On Admin charge processing.
ORDER_ID DOUBLE N Identifier for the order
PACKAGE_TYPE_ID DOUBLE N Package type id
PARENT_PRODUCT_SEQ DOUBLE Y For child products of a compound, this points to the parent order_product
PBS_DRUG_UUID VARCHAR(255) Y The drug identifier for the product.
PRODUCT_SEQ DOUBLE Y Unique sequence for each order_product row
RXA_ORDERING_UNIT_CD DOUBLE N The unit of the ordering quantity for the dispense.
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_VALUE DOUBLE N The strength dose on the product's ingredient including the overfill added during TPN balancing.
TNF_ID DOUBLE N Key to template_non-formulary table
TOTAL_CHARGE_QUANTITY DOUBLE Y Cumulative counter for number of units charged. Amounts based on product unit (i.e. mg)
TOTAL_CREDIT_QUANTITY DOUBLE Y Cumulative counter for number of units to credit. Amounts based on product unit (i.e. mg)
TOTAL_DISPENSE_QUANTITY DOUBLE Y Cumulative counter for number of units dispensed. Amounts based on product unit (i.e. mg)
UNROUNDED_DOSE_QTY DOUBLE N Product's quantity per dose prior to rounding.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
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_VALUE DOUBLE N The volume dose on the product's ingredient including the overfill added during TPN balancing.



Relationship Detail - ORDER_PRODUCT


Child Column in ORDER_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID




Parent Column in ORDER_PRODUCT (PK) Child Table Name Child Column Name
Children: ACTION_SEQUENCE ORDER_PRODUCT_DOSE ACTION_SEQUENCE
INGRED_SEQUENCE ORDER_PRODUCT_DOSE INGRED_SEQUENCE
ITEM_ID ORDER_PRODUCT_DOSE ITEM_ID
ORDER_ID ORDER_PRODUCT_DOSE ORDER_ID
TNF_ID ORDER_PRODUCT_DOSE TNF_ID


ORDER_PRODUCT_DOSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Product Dose
Definition: Stores doses assigned to a particular order product.
Table Type: ACTIVITY





Column Detail - ORDER_PRODUCT_DOSE


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N A sequence number used to identify the order of the actions.
DOSE_QUANTITY DOUBLE N The number of units to be administered to the patient. The dosage amount given, if given 500 mg of drug X, but there are only 250 mg tabs, then the dose quantity is 2 in order to get the dosage up to the amount of the order.
DOSE_QUANTITY_UNIT_CD DOUBLE N Unit to apply to the dose quantity
INGRED_SEQUENCE DOUBLE N A sequence number used to identify the order of ingredients.
ITEM_ID DOUBLE N Reference to the formulary item pharmacy product.
ORDER_ID DOUBLE N The order this dose pertains to.
ORDER_PRODUCT_DOSE_ID DOUBLE N Unique, generated number that identifies a single row on the ORDER_PRODUCT_DOSE table.
SCHEDULE_SEQ DOUBLE N The sequence of the related frequency schedule which the order ingredient dose instance represents.
TNF_ID DOUBLE N Key to template_non-formulary table
UNROUNDED_DOSE_QTY DOUBLE N Product's quantity per dose prior to rounding.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - ORDER_PRODUCT_DOSE


Child Column in ORDER_PRODUCT_DOSE(FK) Parent Table Name Parent Column Name
Parents: ACTION_SEQUENCE ORDER_PRODUCT ACTION_SEQUENCE
INGRED_SEQUENCE ORDER_PRODUCT INGRED_SEQUENCE
ITEM_ID ORDER_PRODUCT ITEM_ID
ORDER_ID ORDER_PRODUCT ORDER_ID
TNF_ID ORDER_PRODUCT TNF_ID


ORD_FAVORITE_DEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Favorite Destination
Definition: User's favorite output destination for prescriptions.
Table Type: ACTIVITY





Column Detail - ORD_FAVORITE_DEST


Column Name Type Null? Definition
DEST_TXT VARCHAR(100) Y Textual information of ad hoc destination
FAVORITE_DEST_SEQ DOUBLE N Sequencing of multiple output destinations of a person.
ORD_FAVORITE_DEST_ID DOUBLE N Uniquely identifies a user's favorite output destination for prescriptions.
ORGANIZATION_ID DOUBLE N The organization that the output dest belongs.
OUTPUT_DEST_ID DOUBLE N Identifies the output destination
PRSNL_ID DOUBLE N Identifies the personnel associated to the established favorite output destination.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - ORD_FAVORITE_DEST


Child Column in ORD_FAVORITE_DEST(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
OUTPUT_DEST_ID OUTPUT_DEST OUTPUT_DEST_CD
PRSNL_ID PRSNL PERSON_ID


PEX_STD_DOSE_UP_MATCH_GTTD



Column Section Top of Page


Table-level Detail

Description: Standardized Dose Upload Matches Global Temporary Table
Definition: Used to efficiently transform data from a CSV file (joining with information from the Order_catalog_synonym, standardized_order_dose, and other tables) to facilitate populatin of the standardized_order_dose table; stores information on matches which may not be one-to-one with the STD_DOSE_UPLOAD_TMP table
Table Type: ACTIVITY





Column Detail - PEX_STD_DOSE_UP_MATCH_GTTD


Column Name Type Null? Definition
CSV_ROW_NBR DOUBLE Y Identifies which row of the CSV file the row came from.
MATCH_FLAG DOUBLE Y Captures whether the match was found via CKI or mnemonic. 0 = CKI, 1 = Mnemonic
SKIP_FLAG DOUBLE Y Indicates whether business logic requires the data to NOT be populated into the standardized_order_table and the reason. 0 indicates that the row should not be skipped as long as all other columns are valid. Value 0: Row should not be skipped, 1=Combination of synonym_id and route_cd already exists in the synonym_order_dose table. 2=Duplication in the CSV file itself that would violate the unique constraint in synonym_order_dose.
SYNONYM_ID DOUBLE Y Defines what type of domain setting a configuration is (view,detail, viewcomp, message center etc.)