Table Detail Report

RXS_ALERT_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Alert Location Relation
Definition: Captures the service locations tied to an alert.
Table Type: ACTIVITY





Column Detail - RXS_ALERT_LOC_RELTN


Column Name Type Null? Definition
RXS_ALERT_ID DOUBLE N The alert associated to this service location.
RXS_ALERT_LOC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_ALERT_LOC_RELTN table.
SVC_LOC_CD DOUBLE N The service location (Nurse Unit, Ambulatory, Pharmacy, Surgery, etc.) for which the medication is requested.
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_ALERT_LOC_RELTN


Child Column in RXS_ALERT_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: SVC_LOC_CD LOCATION LOCATION_CD
RXS_ALERT_ID RXS_ALERT RXS_ALERT_ID


RXS_EXTENDED_COUNT_PROP



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Extended Count Property
Definition: Contains additional information on when a count should be performed for a given location/item.
Table Type: REFERENCE





Column Detail - RXS_EXTENDED_COUNT_PROP


Column Name Type Null? Definition
COUNTBACK_FLAG DOUBLE N Flag used to determine if this item/location requires a physical count once the icurrent quantity level reached dynamic count level.
COUNT_CONTROL_NBR DOUBLE N A number indicating how often or when to start counting.
COUNT_RULE_CD DOUBLE N The count rule that is defined for this location/item.
ITEM_ID DOUBLE N The item this count relates to.
LOCATION_CD DOUBLE N The location this count relates to.
RXS_EXTENDED_COUNT_PROP_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_EXTENDED_COUNT_PROP table.
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.



Relationship Detail - RXS_EXTENDED_COUNT_PROP


Child Column in RXS_EXTENDED_COUNT_PROP(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
LOCATION_CD LOCATION LOCATION_CD


RXS_FOREIGN_DEVICE_ALERT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Foreign Device Alert
Definition: The purpose of this table is to house alerts generated by foreign systems e.g. CF Pyxis to achieve interoperability.
Table Type: ACTIVITY





Column Detail - RXS_FOREIGN_DEVICE_ALERT


Column Name Type Null? Definition
ALERT_UNIT VARCHAR(255) N This is an optional field that provides the type of units appropriate for the ALERT_VALUE.
ALERT_VALUE VARCHAR(1000) N This is an optional field that provides a value associated with the alert.
CREATE_PRSNL_ID DOUBLE N This item contains the identifier of the personnel associated with the alert .
CREATE_PRSNL_NAME VARCHAR(255) N This field contains the name of the personnel associated with the alert .
DEVICE_DRAWER_NAME VARCHAR(255) N The name of a drawer in a device.
DEVICE_LOCATOR_NAME VARCHAR(255) N This field contains the exact location on the device that is associated with the alert.
DEVICE_LOC_CD DOUBLE N This field contains the location code of the device location that caused the alert.
DEVICE_NAME VARCHAR(255) N This field contains the name of the foreign device that originated the alert.
DEVICE_SUB_DRAWER_NAME VARCHAR(255) N Name of a sub drawer in a device.
ENS_MESSAGE_DT_TM DATETIME N This field contains the timestamp associated with the ENS message.
ENS_MESSAGE_IDENT VARCHAR(255) N This field contains the unique message ID from the ENS toolkit.
FACILITY_CD DOUBLE N The field contains the code value of the facility.
FACILITY_NAME VARCHAR(255) N This field provides the name of the facility that originated the alert.
FOREIGN_ITEM_IDENTIFIER VARCHAR(255) N Identifier sent by a foreign device through HL7 message.
INV_ITEM_ID DOUBLE N This field provides an identification number for the item associated with the alert.
INV_ITEM_NAME VARCHAR(255) N This field contains the name of the item associated with the alert per INV_ITEM _ID.
MSG_BODY_LONG_TEXT_ID DOUBLE N Reference to LONG_TEXT table. Contains the original message sent with the alert as received from the foreign system.
NURSE_UNIT_CD DOUBLE N This fields contains the nurse unit location code of the patient.
NURSE_UNIT_NAME VARCHAR(255) N The name of the nursing unit associated with the alert.
PATIENT_ID DOUBLE N This is the patient's primary identification number. This field is optional depending on the type of alert.
PATIENT_NAME_FORMATTED VARCHAR(255) N The formatted name of the patient associated to this alert. It is a combination of the patient's first name, middle initial, and last name.
REFERENCE_RANGE_TXT VARCHAR(255) N This field provides what is considered a normal range of values for the alert. It is an optional field based on the type of alert (TYPE_CD).
RXS_FOREIGN_DEVICE_ALERT_ID DOUBLE N Unique generated number that identifies a single row on the RXS_FOREIGN_DEVICE_ALERT table.
STATE_CD DOUBLE N This field indicates the status for the alert.
STATE_DT_TM DATETIME N The date/time of the last state change.
SVRTY_CD DOUBLE N Indicates the severity of this alert.
TRANSACTION_DT_TM DATETIME N This field is a timestamp for the transaction that created the alert on the foreign device.
TRANSACTION_IDENT VARCHAR(255) N The transaction ID is the foreign system's identifier assigned to the transaction that generated the alert. It is required.
TYPE_CD DOUBLE N This field indicates the type of the alert.
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_FOREIGN_DEVICE_ALERT


Child Column in RXS_FOREIGN_DEVICE_ALERT(FK) Parent Table Name Parent Column Name
Parents: INV_ITEM_ID ITEM_DEFINITION ITEM_ID
DEVICE_LOC_CD LOCATION LOCATION_CD
FACILITY_CD LOCATION LOCATION_CD
NURSE_UNIT_CD LOCATION LOCATION_CD
MSG_BODY_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PATIENT_ID PERSON PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in RXS_FOREIGN_DEVICE_ALERT (PK) Child Table Name Child Column Name
Children: RXS_FOREIGN_DEVICE_ALERT_ID RXS_ALERT_AUDIT_HX RXS_FOREIGN_DEVICE_ALERT_ID


RXS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Group
Definition: Contains items on an order set. For example: all the medications that are bee sting medicines.
Table Type: REFERENCE





Column Detail - RXS_GROUP


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.
CREATE_DT_TM DATETIME Y The date and time the group was created
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the group.
GROUP_DESCRIPTION VARCHAR(100) N The description or name of the group that is defined.
RXS_GROUP_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_GROUP table.
RXS_GROUP_TYPE_CD DOUBLE N Identifies the type of group. Initially, the only type will be for an order set.
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.



Relationship Detail - RXS_GROUP


Child Column in RXS_GROUP(FK) Parent Table Name Parent Column Name
Parents: CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in RXS_GROUP (PK) Child Table Name Child Column Name
Children: RXS_GROUP_ID RXS_GROUP_ITEM_RELTN RXS_GROUP_ID
RXS_GROUP_LOCATION_RELTN RXS_GROUP_ID


RXS_GROUP_ITEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Group Item Relation
Definition: The items that are part of a defined group.
Table Type: REFERENCE





Column Detail - RXS_GROUP_ITEM_RELTN


Column Name Type Null? Definition
ACTION_TYPE_CD DOUBLE N Indicates if this item is to be included or not included in the dispense.
DEFAULT_REASON_CD DOUBLE N The reason an override was performed.
DEFAULT_ROUTE_CD DOUBLE N The default route for this item in this group.
ITEM_ID DOUBLE N The item that is in the defined group.
ITEM_QTY DOUBLE N The default dose of the item in this group.
RXS_GROUP_ID DOUBLE N The group that this item belongs to.
RXS_GROUP_ITEM_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_GROUP_ITEM_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_ITEM_RELTN


Child Column in RXS_GROUP_ITEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
RXS_GROUP_ID RXS_GROUP RXS_GROUP_ID