Table Detail Report

RXS_GROUP_LOCATION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Group Location Relation
Definition: The locations a defined group is defined for.
Table Type: REFERENCE





Column Detail - RXS_GROUP_LOCATION_RELTN


Column Name Type Null? Definition
LOCATION_CD DOUBLE N The location this group is defined for.
RXS_GROUP_ID DOUBLE N The group that this location belongs to.
RXS_GROUP_LOCATION_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_GROUP_LOCATION_RELTN 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 - RXS_GROUP_LOCATION_RELTN


Child Column in RXS_GROUP_LOCATION_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
RXS_GROUP_ID RXS_GROUP RXS_GROUP_ID


RXS_ITEM_COUNTBACK



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Item Countback
Definition: Shows the actual and anticipated counts every time a countback is required by the system.
Table Type: ACTIVITY





Column Detail - RXS_ITEM_COUNTBACK


Column Name Type Null? Definition
ACTUAL_QTY DOUBLE N The actual physical quantity found on hand during a countback.
CLUSTER_CD DOUBLE N If the location_cd is an RxStation device, this is the cluster (grouping) that the RxStation device belongs to.
COUNTBACK_SEQ DOUBLE N Sequence number differentiating multiple countback attempts during the same encounter with the same location for the same item.
CREATE_DT_TM DATETIME Y Date this countback was performed.
CREATE_TZ DOUBLE N Time zone associated with CREATE_DT_TM.
EVENT_TYPE_CD DOUBLE N Indicates the type of event that was being processed when the countback took place.
EXPECTED_QTY DOUBLE N The quantity that the device had stored in its inventory at the time of the countback according to the system.
FACILITY_CD DOUBLE N The facility where the countback was performed.
INV_ITEM_ID DOUBLE N Indicates the item this countback was for.
LOCATION_CD DOUBLE N The location where the countback was performed. PharmNet and Supply Chain both require this for dispensing and inventory tracking.
LOCATOR_CD DOUBLE N The bin or tray in an RxStation device where the item countback was done.
MED_ITEM_ID DOUBLE N Indicates the pharmacy formulary item for this task.
MED_PRODUCT_ID DOUBLE N The id that identifies the actual pharmacy product item that is being counted.
PACKAGE_TYPE_DESC_TXT VARCHAR(100) N Description of the package type of the item being counted.
PACKAGE_TYPE_ID DOUBLE N The package type of the item being counted.
PACKAGE_TYPE_QTY DOUBLE N The quantity in the package type of the item being counted.
PACKAGE_TYPE_UOM_CD DOUBLE N The unit of measure for the package for the item being counted.
PHARM_TYPE_CD DOUBLE N Pharmacy type code that indicates if the countback occurred at an Inpatient or Retail establishment.
PROD_DISPENSE_HX_ID DOUBLE N Product dispense history information for the dispense event during which the countback took place.
PRSNL_ID DOUBLE N The personnel performing the countback.
RXS_ITEM_COUNTBACK_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_ITEM_COUNTBACK table.
RXS_LOCATION_TASK_ID DOUBLE N The task that triggered the countback to occur.
RX_WORKFLOW_STS_ID DOUBLE N The workflow step during which the countback took place.
SERVICE_RESOURCE_CD DOUBLE N The representation in the service resource model of the location where the countback was performed. PharmNet requires this for dispensing routing.
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.
WITNS_PRSNL_ID DOUBLE N Identifier for witness overseeing countback event



Relationship Detail - RXS_ITEM_COUNTBACK


Child Column in RXS_ITEM_COUNTBACK(FK) Parent Table Name Parent Column Name
Parents: INV_ITEM_ID ITEM_DEFINITION ITEM_ID
CLUSTER_CD LOCATION LOCATION_CD
FACILITY_CD LOCATION LOCATION_CD
LOCATION_CD LOCATION LOCATION_CD
LOCATOR_CD LOCATION LOCATION_CD
MED_ITEM_ID MEDICATION_DEFINITION ITEM_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PRSNL_ID PRSNL PERSON_ID
WITNS_PRSNL_ID PRSNL PERSON_ID
RXS_LOCATION_TASK_ID RXS_LOCATION_TASK RXS_LOCATION_TASK_ID
RX_WORKFLOW_STS_ID RX_WORKFLOW_STS RX_WORKFLOW_STS_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in RXS_ITEM_COUNTBACK (PK) Child Table Name Child Column Name
Children: RXS_ITEM_COUNTBACK_ID MM_DISCREPANCY RXS_ITEM_COUNTBACK_ID


RXS_ITEM_GROUP_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Item Group Activity
Definition: Stores activities related to RxStation item groups
Table Type: ACTIVITY





Column Detail - RXS_ITEM_GROUP_ACT


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVITY_PRSNL_ID DOUBLE N Personnel who performs item group activity.
ACTIVITY_TYPE_CD DOUBLE N Code value that identifies the activity type for the item group.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date that the row becomes or became effective.
ENCNTR_ID DOUBLE N The encounter that this activity was for.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ITEM_GROUP_ENTITY_ID DOUBLE N Identifier that refers to a group of items
ITEM_GROUP_ENTITY_NAME VARCHAR(32) N Name of the entity that represents a group of items
RXS_ITEM_GROUP_ACT_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_ITEM_GROUP_ACT table.
SURG_CASE_ID DOUBLE N A reference (foreign key) to the surgical_case table indicating the surgical case associated with this activity.Can be 0, if surgical case is not available.
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 - RXS_ITEM_GROUP_ACT


Child Column in RXS_ITEM_GROUP_ACT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ACTIVITY_PRSNL_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in RXS_ITEM_GROUP_ACT (PK) Child Table Name Child Column Name
Children: RXS_ITEM_GROUP_ACT_ID RXS_LOCATION_TASK RXS_ITEM_GROUP_ACT_ID


RXS_LAST_LOCATOR_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Last Locator Activity
Definition: Stores the latest RxStation-specific activities performed for a locator_cd and item_id.
Table Type: ACTIVITY





Column Detail - RXS_LAST_LOCATOR_ACTIVITY


Column Name Type Null? Definition
CLUSTER_CD DOUBLE N The cluster (grouping) that this RxStation device belongs to.
ITEM_ID DOUBLE N The pharmacy formulary item.
LAST_ACTIVITY_DT_TM DATETIME Y The date and time of the last activity for this locator_cd and item_id.
LAST_DISPENSE_DT_TM DATETIME Y The date and time of the last dispense activity for this locator_cd and item_id.
LAST_INV_COUNT_DT_TM DATETIME Y The date and time of the last inventory count activity for this locator_cd and item_id.
LAST_SCANNED_BARCODE VARCHAR(255) N The last barcode scanned for this locator_cd and item_id.
LAST_SCANNED_BARCODE_DT_TM DATETIME Y The date and time a barcode was last scanned for this locator_cd and item_id.
LOCATION_CD DOUBLE N Identifies an RxStation device.
LOCATOR_CD DOUBLE N The lowest level of the location hierarchy for which the item will be placed.
RXS_LAST_LOCATOR_ACTIVITY_ID DOUBLE N Unique generated number that identifies a single row on the RXS_LAST_LOCATOR_ACTIVITY 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 - RXS_LAST_LOCATOR_ACTIVITY


Child Column in RXS_LAST_LOCATOR_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
CLUSTER_CD LOCATION LOCATION_CD
LOCATION_CD LOCATION LOCATION_CD
LOCATOR_CD LOCATION LOCATION_CD


RXS_LOCATION_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Location Task
Definition: Represents tasks that have been generated for a location.
Table Type: ACTIVITY





Column Detail - RXS_LOCATION_TASK


Column Name Type Null? Definition
ACTUAL_QTY DOUBLE N Actual quantity used to complete this task. For example, the requested quantity may call for 50 units of an item, but the pharmacy only contains 40 of this item.
CAPACITY_ATTR_CONFIG_NBR DOUBLE Y The capacity configuration relevant to this specific task.
CATALOG_CD DOUBLE N The catalog code for an item for which a task is created in rxs_location_task.
CLUSTER_CD DOUBLE N If the location_cd is an RxStation device, this is the cluster (grouping) that the RxStation device belongs to.
CONNECTORS_ATTR_CONFIG_NBR DOUBLE Y The connectors configuration relevant to this specific task.
CREATE_DT_TM DATETIME N Date and time the task was created.
CREATE_PRSNL_ID DOUBLE N The personnel who created this task.
CREATE_TZ DOUBLE N Time zone associated with CREATE_DT_TM.
ENCNTR_ID DOUBLE Y Refers to a patient encounter which is associated to a location task. Can be 0. (skewed column, most of them will be 0). As of today, we will use that field if we do not have SurgiNet integration.
EXPIRE_DT_TM DATETIME Y Planned expiration date for items used on a replenishment task.
EXPIRE_TZ DOUBLE N Time zone associated with EXPIRE_DT_TM.
FACILITY_CD DOUBLE N The facility that is responsible for this location.
FILL_LOCATION_CD DOUBLE N For replenishment tasks, this is the location from which the item is expected to be pulled.
FILL_WITNESS_PRSNL_ID DOUBLE N If a witness is required to check the fill for the transfer in the pharmacy, this is the personnel ID of the person who checked the fill.
INV_ITEM_ID DOUBLE N Indicates the item this task pertains to.
LINKED_TASK_ID DOUBLE N *** obsolete ***
LOCATION_CD DOUBLE N The location that this task pertains to.
LOCATOR_CD DOUBLE N The lowest level of the location hierarchy for which the item will be placed.
MED_ITEM_ID DOUBLE N Indicates the pharmacy formulary item for this task.
ORDER_ACTION_SEQ DOUBLE N The action sequence at the time of task for tasks with an order_id context.
ORDER_ID DOUBLE Y The order that was satisfied by this task.
PACKAGE_TYPE_DESC_TXT VARCHAR(100) N Description of the type of package for the item on the task.
PACKAGE_TYPE_ID DOUBLE N Indicates the package (unit of measure) for the item. Examples include tablets, bottles, etc.
PACKAGE_TYPE_QTY DOUBLE N The quantity of base packages contained in this package. For example, if this item comes packed individually, a box might contain multiple individual packages.
PACKAGE_TYPE_UOM_CD DOUBLE N Unit of measure for the package.
PHARM_TYPE_CD DOUBLE N Pharmacy type code that indicates if the task applies to Inpatient or Retail.
RECONCILE_FLAG DOUBLE N Indicates whether the transfer has been reconciled. Used for transfers to a provider. Values include 0 = reconciliation not needed; 1 = needs reconciliation; 2 = reconciliation in process; 3 = reconciliation complete.
REQUESTED_QTY DOUBLE N Quantity requested for this task. For example, in a replenishment task, this is the quantity of the item needed to completely fill the locator as determined by the system during the TBR (task-based replenishment) process.
RXS_ALERT_ID DOUBLE N *** OBSOLETE ***
RXS_ITEM_GROUP_ACT_ID DOUBLE N Macro table's index id. This is used to match the rxs_item_group_act table's macro info.
RXS_LOCATION_TASK_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_LOCATION_TASK table.
RXS_RECEIVING_DETAIL_ID DOUBLE N Documents the forms used for this receiving drug task.
RXS_WORKLIST_EVENT_ID DOUBLE N The worklist event that generated this task.
SA_TODO_LIST_PROCESSED_IND DOUBLE N indicate if surginet anesthesia has retrieved the activity for the to do list.
SERVICE_RESOURCE_CD DOUBLE N The representation of the location in the service resource model.
STATUS_DT_TM DATETIME Y The date and time the task_status_cd field was last updated.
STATUS_PRSNL_ID DOUBLE N Personnel that last updated the task_status_cd field.
STATUS_TZ DOUBLE N Time zone associated with STATUS_DT_TM.
SURG_CASE_ID DOUBLE Y Refers to a surgery case which is associated to a location task. Can be 0 (skewed column, most of them will be 0). Location tasks that are created for anesthesia cart dispenses, returns and wastes will be associated with a surgical case, if SurgiNet integration exists.
TASK_STATUS_CD DOUBLE N The task's current status. For example: Pending, In Process.
TASK_TYPE_CD DOUBLE N The type of task - for example: replenish, load, unload.
TRANSFER_PRSNL_ID DOUBLE N Personnel who received the medication and is responsible for the transfer between the fill_location_cd and the location_cd.
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.
WITNESS_PRSNL_ID DOUBLE N The personnel that was responsible for witnessing this task.



Relationship Detail - RXS_LOCATION_TASK


Child Column in RXS_LOCATION_TASK(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
INV_ITEM_ID ITEM_DEFINITION ITEM_ID
CLUSTER_CD LOCATION LOCATION_CD
FACILITY_CD LOCATION LOCATION_CD
FILL_LOCATION_CD LOCATION LOCATION_CD
LOCATION_CD LOCATION LOCATION_CD
LOCATOR_CD LOCATION LOCATION_CD
MED_ITEM_ID MEDICATION_DEFINITION ITEM_ID
ORDER_ID ORDERS ORDER_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
FILL_WITNESS_PRSNL_ID PRSNL PERSON_ID
STATUS_PRSNL_ID PRSNL PERSON_ID
TRANSFER_PRSNL_ID PRSNL PERSON_ID
WITNESS_PRSNL_ID PRSNL PERSON_ID
RXS_ITEM_GROUP_ACT_ID RXS_ITEM_GROUP_ACT RXS_ITEM_GROUP_ACT_ID
RXS_RECEIVING_DETAIL_ID RXS_RECEIVING_DETAIL RXS_RECEIVING_DETAIL_ID
RXS_WORKLIST_EVENT_ID RXS_WORKLIST_EVENT RXS_WORKLIST_EVENT_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in RXS_LOCATION_TASK (PK) Child Table Name Child Column Name
Children: RXS_LOCATION_TASK_ID RXS_ACTIVITY_INDEX RXS_LOCATION_TASK_ID
RXS_ITEM_COUNTBACK RXS_LOCATION_TASK_ID
RXS_LOCATION_TASK_RELTN CHILD_TASK_ID
RXS_LOCATION_TASK_RELTN PARENT_TASK_ID
RXS_TASK_ALERT_RELTN RXS_LOCATION_TASK_ID
RXS_TASK_DISPENSE_RELTN RXS_LOCATION_TASK_ID
RXS_TASK_SR_HX RXS_LOCATION_TASK_ID