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 |