Table Detail Report

RX_WORK_ITEM_QUEUE_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Work Item Queue History
Definition: History of pharmacy work items that have been removed.
Table Type: ACTIVITY





Column Detail - RX_WORK_ITEM_QUEUE_HX


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N The create_dt_tm from the original row on the RX_WORK_ITEM_QUEUE table.
CREATE_TZ DOUBLE N The create_tz from the original row on the RX_WORK_ITEM_QUEUE table.
DELETE_DT_TM DATETIME N The date and time that the row was delete from RX_WORK_TIME_QUEUE
DELETE_PRSNL_ID DOUBLE N The personnel that deleted the row on the RX_WORK_ITEM_QUEUE table.
DELETE_TZ DOUBLE N The time zone associated to the delete_dt_tm column.
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.
PRIORITY_CD DOUBLE N The priority code value for the work item.
RX_WORK_ITEM_QUEUE_HX_ID DOUBLE N Unique generated number that identifies a single row on the RX_WORK_ITEM_QUEUE_HX 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 on the deleted RX_WORK_ITEM_QUEUE row. Examples: ERX, Unverified Order, Med Request.



Relationship Detail - RX_WORK_ITEM_QUEUE_HX


Child Column in RX_WORK_ITEM_QUEUE_HX(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
DELETE_PRSNL_ID PRSNL PERSON_ID


RX_WS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Worksheet
Definition: Reference information about the defined methods of creating one item from multiple sub-items. This is a work table for creating a worksheet.
Table Type: REFERENCE





Column Detail - RX_WS


Column Name Type Null? Definition
LABEL_FORMAT_CD DOUBLE N The default format used when the worksheet is printed on a label.
LABOR_COST_AMT DOUBLE N The total cost of the labor required to create the parent item.
LABOR_NBR DOUBLE N The amount of time that is required to create the parent item.
LABOR_RATIO_IND DOUBLE N Indicates whether the labor and labor costs are directly associated to the number of items created.
LABOR_UNIT_CD DOUBLE N The unit for the amount of time that is required to create the parent item.
MIXING_INSTR_TEXT_ID DOUBLE N The mixing instructions required to create the parent item.
PHARMACY_TYPE_CD DOUBLE N Indicates the pharmacy type that the worksheet will be created for.
REPORT_FORMAT_CD DOUBLE N The default format used when the worksheet is printed on a report.
RX_WS_ID DOUBLE N Unique, generated number that uniquely identifies a row on the RX_WS table.
SHELF_LIFE_NBR DOUBLE N The amount of time that the parent item is good for. (Expiration Date)
SHELF_LIFE_UNIT_CD DOUBLE N The unit for the amount of time that the parent item is good for.
TOTAL_QTY DOUBLE N Indicates the amount of the parent item that will be created by the Pharmacy Worksheet.
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.
WS_BEGIN_EFFECTIVE_DT_TM DATETIME N The date and time the worksheet takes effect.
WS_BEGIN_EFFECTIVE_TZ DOUBLE N Time zone associated with WS_BEGIN_EFFECTIVE_DT_Tm.
WS_CD DOUBLE N The code value for the Pharmacy Worksheet.
WS_END_EFFECTIVE_DT_TM DATETIME N The date and time the Pharmacy Worksheet is no longer valid for use.
WS_END_EFFECTIVE_TZ DOUBLE N Time zone associated with WS_END_EFFECTIVE_DT_TM.



Relationship Detail - RX_WS


Child Column in RX_WS(FK) Parent Table Name Parent Column Name
Parents: MIXING_INSTR_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in RX_WS (PK) Child Table Name Child Column Name
Children: RX_WS_ID RX_WS_FAC_RELTN RX_WS_ID
RX_WS_FAC_RELTN_HX RX_WS_ID


RX_WS_FAC_ITEM_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Worksheet Facility Item History
Definition: Contains the historical reference data about the items on a worksheet at a facility.
Table Type: REFERENCE





Column Detail - RX_WS_FAC_ITEM_HX


Column Name Type Null? Definition
ITEM_ID DOUBLE N The Pharmacy or Supply item needed to create the parent item of the Pharmacy Worksheet, expressed in terms of the quantity unit.
ITEM_QTY DOUBLE N The amount of the Pharmacy or Supply item needed to create the parent item of the Pharmacy Worksheet, expressed in terms of the quantity unit.
ITEM_TYPE_FLAG DOUBLE N Indicates the type of item.
MAINTAIN_RATIO_IND DOUBLE N Indicates if the quantity of the item needed is directly associated to the number of items created.
RX_WS_FAC_ITEM_HX_ID DOUBLE N Unique, generated number that identifies a single row on the RX_WS_-FAC_ITEM_HX table.
RX_WS_FAC_RELTN_HX_ID DOUBLE N Unique, generated number that identifies a unique row on the RX_WS_FAC_RELTN_HX 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_WS_FAC_ITEM_HX


Child Column in RX_WS_FAC_ITEM_HX(FK) Parent Table Name Parent Column Name
Parents: RX_WS_FAC_RELTN_HX_ID RX_WS_FAC_RELTN_HX RX_WS_FAC_RELTN_HX_ID




Parent Column in RX_WS_FAC_ITEM_HX (PK) Child Table Name Child Column Name
Children: RX_WS_FAC_ITEM_HX_ID RX_WF_WS_ITEM_RELTN RX_WS_FAC_ITEM_HX_ID


RX_WS_FAC_ITEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Worksheet Facility Item Relation
Definition: Contains the reference data for the items on a worksheet at a location.
Table Type: REFERENCE





Column Detail - RX_WS_FAC_ITEM_RELTN


Column Name Type Null? Definition
ITEM_ID DOUBLE N The Pharmacy or Supply item needed to create the parent item of the Pharmacy Worksheet, expressed in terms of the quantity unit.
ITEM_QTY DOUBLE N The amount of the Pharmacy or Supply item needed to create the parent item of the Pharmacy Worksheet, expressed in terms of the quantity unit.
ITEM_TYPE_FLAG DOUBLE N Indicates the type of item.
MAINTAIN_RATIO_IND DOUBLE N Indicates if the quantity of the item needed is directly associated to the number of items created.
RX_WS_FAC_ITEM_RELTN_ID DOUBLE N Unique, generated number that uniquely identifies a row on the RX_WS_FAC_ITEM_RELTN table.
RX_WS_FAC_RELTN_ID DOUBLE N Foreign key to the RX_WS_FAC_RELTN table. Identifies the master worksheet and the facility this item pertains to.
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_WS_FAC_ITEM_RELTN


Child Column in RX_WS_FAC_ITEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
RX_WS_FAC_RELTN_ID RX_WS_FAC_RELTN RX_WS_FAC_RELTN_ID


RX_WS_FAC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Worksheet Facility Relation
Definition: Contains information pertinent to a worksheet at a facility.
Table Type: REFERENCE





Column Detail - RX_WS_FAC_RELTN


Column Name Type Null? Definition
FAC_CD DOUBLE N The facility that the Pharmacy Worksheet is valid for.
MAINTAIN_RATIO_IND DOUBLE N Indicates whether or not the quantity created by the worksheet is directly related to the child item quantities for the parent item.
PARENT_ITEM_ID DOUBLE N The item that is created by the worksheet.
RX_WS_FAC_RELTN_ID DOUBLE N Unique, generated number that uniquely identifies a row on the RX_WS_FAC_RELTN table.
RX_WS_ID DOUBLE N Identifies the worksheet that is valid at a specific location.
STATUS_CD DOUBLE N Indicates the status of the worksheet for the given facility. (i.e. 'Approved','In Process', etc.)
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_WS_FAC_RELTN


Child Column in RX_WS_FAC_RELTN(FK) Parent Table Name Parent Column Name
Parents: PARENT_ITEM_ID ITEM_DEFINITION ITEM_ID
FAC_CD LOCATION LOCATION_CD
RX_WS_ID RX_WS RX_WS_ID




Parent Column in RX_WS_FAC_RELTN (PK) Child Table Name Child Column Name
Children: RX_WS_FAC_RELTN_ID RX_WS_FAC_ITEM_RELTN RX_WS_FAC_RELTN_ID