Table Detail Report

RX_WORKFLOW_STS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Workflow Status
Definition: Stores a workflow event that is routed to the pharmacy workflow monitor.
Table Type: ACTIVITY





Column Detail - RX_WORKFLOW_STS


Column Name Type Null? Definition
CMPLT_DT_TM DATETIME Y Date and time when a sequence was completed.
CMPLT_TZ DOUBLE N Time zone associated to the cmplt_dt_tm that records when the sequence was completed.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_TZ DOUBLE N Time zone associated with the created_dt_tm column.
DISPENSE_CATEGORY_S VARCHAR(40) N The display value of the dispense category cd from 4008 that is associated to an event.
DISPENSE_FROM_LOC_CD DOUBLE N The location a dispense event of an order is to be dispensed from.
DISPENSE_HX_ID DOUBLE N This field links the rx_workflow_sts record to the dispensing event record. This will enable users to track back to the original dispense.
EVENT_NBR_DAY_SEQ DOUBLE N An incrementing number of occurrences during a particular day.
ITEM_ID DOUBLE N This column represents the item in the medication_definition table.
PHARM_TYPE_CD DOUBLE N Pharmacy type code that indicates if the event is Inpatient or Retail.
PREP_INFO_CD DOUBLE N Code value from code set 4760 that represents the worksheet associated to a workflow event.
RX_WORKFLOW_STS_ID DOUBLE N Unique, generated key for each workflow_sts row.
SCHED_DT_TM DATETIME Y Date and time of the first admin a workflow event is to occur.
SCHED_TZ DOUBLE N Time zone associated with sched_dt_tm.
STS_FLAG DOUBLE N Indicates if the sequence is no longer active (0), active (1), or completed (2).
TOTAL_DOSE_NBR DOUBLE N Amount requested to be made for an event.
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.
UPDT_TZ DOUBLE N Time zone associated with field updt_dt_tm.
WORKFLOW_CD DOUBLE N Indicates the workflow sequence of an order. Used to route orders to workflow monitor.
WORKFLOW_STS_CD DOUBLE N Indicates the status of the workflow sequence associated to an order's dispense.



Relationship Detail - RX_WORKFLOW_STS


Child Column in RX_WORKFLOW_STS(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ITEM_ID MEDICATION_DEFINITION ITEM_ID




Parent Column in RX_WORKFLOW_STS (PK) Child Table Name Child Column Name
Children: RX_WORKFLOW_STS_ID RXS_ITEM_COUNTBACK RX_WORKFLOW_STS_ID
RX_PROD_VLDTN_EVENT RX_WORKFLOW_STS_ID
RX_WF_WS RX_WORKFLOW_STS_ID
RX_WORKFLOW_STS_HX RX_WORKFLOW_STS_ID
RX_WORKFLOW_STS_ITEM RX_WORKFLOW_STS_ID
RX_WORKFLOW_STS_SCHED RX_WORKFLOW_STS_ID


RX_WORKFLOW_STS_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Status History
Definition: Stores the history of a dispense event's workflow status change.
Table Type: ACTIVITY





Column Detail - RX_WORKFLOW_STS_HX


Column Name Type Null? Definition
RX_WORKFLOW_STS_HX_ID DOUBLE N Generated, unique identifier for each row.
RX_WORKFLOW_STS_ID DOUBLE N Foreign key to the rx_workflow_sts table.
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.
UPDT_TZ DOUBLE N Time zone for the updt_dt_tm field.
WORKFLOW_CD DOUBLE N Indicates the workflow sequence of an order. Used to route orders to workflow monitor.
WORKFLOW_STS_CD DOUBLE N Indicates the status of the workflow sequence associated to an order's dispense.



Relationship Detail - RX_WORKFLOW_STS_HX


Child Column in RX_WORKFLOW_STS_HX(FK) Parent Table Name Parent Column Name
Parents: RX_WORKFLOW_STS_ID RX_WORKFLOW_STS RX_WORKFLOW_STS_ID


RX_WORKFLOW_STS_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Workflow Status Item
Definition: Stores the child items of a workflow event that is not specific to a patient's dispense.
Table Type: ACTIVITY





Column Detail - RX_WORKFLOW_STS_ITEM


Column Name Type Null? Definition
ITEM_ID DOUBLE N The item used in the workflow event.
ITEM_QTY DOUBLE N The quantity of the item needed to satisfy the Workflow event.
RX_WORKFLOW_STS_ID DOUBLE N The workflow event this item belongs to. Foreign key to the RX_WORKFLOW_STS table.
RX_WORKFLOW_STS_ITEM_ID DOUBLE N Unique, generated number that identifies a single row in the RX_WORKFLOW_STS_ITEM table.
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 - RX_WORKFLOW_STS_ITEM


Child Column in RX_WORKFLOW_STS_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
RX_WORKFLOW_STS_ID RX_WORKFLOW_STS RX_WORKFLOW_STS_ID


RX_WORKFLOW_STS_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Workflow Status Schedule
Definition: Stores the schedule of a dispense event's workflow.
Table Type: ACTIVITY





Column Detail - RX_WORKFLOW_STS_SCHED


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_DT_TM DATETIME Y The date and time a recurring event should begin.
DAYS_OF_WEEK_BIT DOUBLE N Day of week bitmap value for a dispense sequence's schedule. 0 - non scheduled, 1 - Monday, 2 - Tuesday, 4 - Wednesday, 8 - Thursday, 16 - Friday, 32 - Saturday, 64 - Sunday.
DAY_NTRVL_NBR DOUBLE N The number of days an event should reoccur.
END_DT_TM DATETIME Y The date and time a reocccurring event should end.
MONTH_NTRVL_NBR DOUBLE N The number of months an event should reoccur. For example, if an event were to occur every month, value should be 1.
RX_WORKFLOW_STS_ID DOUBLE N Foreign key to the rx_workflow_sts table.
RX_WORKFLOW_STS_SCHED_ID DOUBLE N Unique, generated identifier for the table.
TIME_OF_DAY DOUBLE N Time of day value in minutes of when a dispense sequence is scheduled to occur.
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.
UPDT_TZ DOUBLE N Time zone for the updt_dt_tm field.
WEEK_NTRVL_NBR DOUBLE N The number of weeks between reoccurrences of an event.. For example, if an event were to occur every other week, value should be 2.



Relationship Detail - RX_WORKFLOW_STS_SCHED


Child Column in RX_WORKFLOW_STS_SCHED(FK) Parent Table Name Parent Column Name
Parents: RX_WORKFLOW_STS_ID RX_WORKFLOW_STS RX_WORKFLOW_STS_ID


RX_WORK_ITEM_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Work Item Queue
Definition: Holds items that need to be worked.
Table Type: ACTIVITY





Column Detail - RX_WORK_ITEM_QUEUE


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N The date and time the work item was created.
CREATE_TZ DOUBLE N The time zone associated to the CREATE_DT_TM column.
CURRENT_START_DT_TM DATETIME Y The current start date and time associated to the work item.
CURRENT_START_TZ DOUBLE N The time zone associated with the CURRENT_START_DT_TM column.
DISCHARGE_EFFECTIVE_DT_TM DATETIME Y The date and time the encounter associated to the work item will be discharged.
ENCNTR_ID DOUBLE N The encounter associated to the work item.
FACILITY_CD DOUBLE N The facility associated to the work item.
LOGICAL_DOMAIN_ID DOUBLE N The logical domain that the work item is associated with.
MED_SERVICE_CD DOUBLE N The medical service related to the work item.
NURSE_UNIT_CD DOUBLE N The nurse unit associated to the work item.
ORDER_ID DOUBLE N The order associated to the work item.
PARENT_ENTITY_ID DOUBLE N The med request that this queue item pertains to.
PARENT_ENTITY_NAME VARCHAR(32) N The table that has more details about this work item. The only value to start with will be RXS_MED_REQUEST.
PERSON_ID DOUBLE N The person associated to the work item.
PRIORITY_CD DOUBLE N The priority code value for the work item.
RX_WORK_ITEM_QUEUE_ID DOUBLE N Unique, generated number that identifies a single row on the RX_WORK_ITEM_QUEUE table.
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.
WORK_ITEM_TYPE_CD DOUBLE N The type of work item. Examples: ERX, Unverified Order, Med Request



Relationship Detail - RX_WORK_ITEM_QUEUE


Child Column in RX_WORK_ITEM_QUEUE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
FACILITY_CD LOCATION LOCATION_CD
NURSE_UNIT_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID