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 |