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 |